Datasets synchronization

Description

Datasets in UKG HR Service Delivery are used to store structured reference data (e.g., cost centers, job codes, locations). Synchronizing datasets ensures that business processes and document generation can rely on up-to-date controlled vocabularies.

Import file

Format

Datasets are synchronized via UTF‑8 encoded CSV files. The file can be uploaded through the admin interface or via SFTP. Imports can be incremental or complete.

Structure

The CSV file must include:

• dataset_code — Unique identifier of the dataset.
• value_code — Unique identifier of the dataset value.
• label — Display name of the value.
• description — Optional descriptive text.

Example (simplified)

dataset_code;value_code;label;description
JOB_CODES;ENG;Engineer;Engineering role
JOB_CODES;HR;Human Resources;HR role

Report file

Each import generates an XML report in the SFTP out/dse directory. The report includes:

• JOB_REFERENCE, JOB_REPORT_TIMESTAMP, JOB_DESCRIPTION, JOB_TYPE (always dse), COUNT_ROWS.
• MESSAGE elements with details for each dataset value processed (ENTITY_ID, RESULT_CODE, RESULT_MESSAGE).