Tables installed with Workday integration

Workday integration adds the following tables.

Table Description
Workday HR CMN Department Interface

[sn_hr_wday_hr_cmn_department_int]

Workday interface table for departments.
Workday HR CMN Location Interface

[sn_hr_wday_hr_cmn_location_int]

Workday interface table for location.
Workday HR Job Profile

[sn_hr_wday_hr_job_profile]

Job profile data (code, level, position).
Workday HR Job Profile Interface

[sn_hr_wday_hr_job_profile_int]

Workday interface table for job profile.
Workday Data Import

[sn_hr_wday_workday_data_import]

Workday interface for worker data.
Workday ID Cross Reference

[sn_hr_wday_workday_id_cross_reference]

Maps Workday and SN primary keys.
HR Workday Job Tracker

[sn_hr_wday_job_tracker]

Tracks the workday sync jobs. When a run starts, a record is inserted in this table and updated at the end of the sync. The update includes the last run date and time and sync end date and time.