Configure badging table data

  • Release version: Yokohama
  • Updated January 30, 2025
  • 3 minutes to read

    • Register details for a new provider, configure a badging table and import data from the source table to the target table to integrate with the badging system.

    Before you begin

    The Source Badging Table is the source table and the Badging Data table is the target table. The badging data from the source table is imported from a badging provider (for example, the attendance data from badge readers).

    Role required: sn_wsd_wc.admin

    Procedure

    1. Navigate to All > Workplace Connectors > Provider Connector Configurations.
    2. From the menu, select the application scope icon (Application Scope icon.).
    3. Select Create New.

      On the form, fill in the fields.

      Table 1. Provider Connector Configuration form
      Field Description
      Provider Name of badging data provider.
      Connector Configuration Select the lookup list icon (Lookup list icon.) and select Badging.

      For more information, see Configure connector configuration for badging data.
      Source Type Source from where the badging data is collected and loaded into the target Badging Data 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.
      Source table Source table from where the badging data is collected and loaded into the target Badging Data table.

      From the drop-down list, select Source Badging Table.
      Run frequency Day and time frequency to import data from the workplace system. For example: 5 minutes.

      The process provider data record picks the records from the badging data table and populates the Employee Attendance table based on the run frequency.
      Active Option to indicate that the provider configuration is active.
      Auto Refresh Location Option to auto-refresh locations when spaces are added or when some spaces are removed from a selected location.

      The scheduled Job Refresh Provider Space Mapping records runs daily and reads the Auto Refresh Location field in the Provider Connector Configuration table. It reads all records in the Provider Connector Configuration records and updates the Provider Space Mapping table with the latest data. For example, if a new floor or a space is added to a location, then they're automatically added to a selected location.
      Metrics Option to select target record for supported metrics. Select Event Data.
    4. Select Submit.
    5. 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.

    6. Select Save.
    7. Navigate to All > System Definition > Scheduled jobs.
    8. 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).
    9. Select and open the Schedule Script Execution for Provider process data records in the edit mode.
    10. Review the Process provider data records form.
      If necessary, change or update the Repeat interval timings for the scheduled job.
    11. 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.