Configure badging table data

Source from where the badging data is collected and loaded into the target Employee attendance table. From the drop-down list, select Table.

Note: If you’re an existing user and have selected the Import from table option in an earlier release to retrieve badging data in your Workplace Connectors instance, the Source Type field is defaulted to Table. If the Import from table option wasn’t selected in your Workplace Connectors instance, then the Source Type field is defaulted to External. The Import from table option isn’t supported in the November ServiceNow Store release.

1. Select Submit.

2. In the Provider Executions table section, filter by Last query time.

   The Provider Execution table [sn_wsd_wc_provider_execution] stores all the scheduled job execution timestamps. Every time that the scheduled job Process Provider data record runs, this table shows an entry in the Last query time column. The time to import data from the source table (Badging data) to the target table (Employee attendance data) table is updated in the Last query time column.

3. Select Save.

4. Navigate to All > System Definition > Scheduled jobs.

5. In the Scheduled Jobs Name field, filter data by Process provider data records and select it.

   Process provider data records read data from vendor badging data (source table). After processing the badging data, it loads it into the Employee Attendance Data table (target table).

6. Select and open the Schedule Script Execution for Provider process data records in the edit mode.

7. Review the Process provider data records form.

   If necessary, change or update the Repeat interval timings for the scheduled job.

8. Select Execute Now.

   The scheduled job takes the source data from the Badging data table to transform the data in the required format, and place it in the target Employee Attendance Data table.

Parent Topic:Provider connector configuration

Previous topic:Provider connector configuration

Next topic:Configure a webhook event