Where Can I Find Workers' Other IDs Field Data in the Destination?
Question
Where can I find workers' Other IDs field data in the destination?
Environment
Connector: Workday HCM
Answer
The Other IDs field in Workday maps to the Custom_ID SOAP element. Fivetran syncs this data to the PERSON_IDENTITY_DOCUMENT table in your destination with type = 'custom_id'.
You can find the corresponding Other IDs values in the following PERSON_IDENTITY_DOCUMENT columns:
document_idid_typeissued_dateexpiration_datecustom_description
To access this data in your destination, ensure that the PERSON_IDENTITY_DOCUMENT is included in your connection schema.
The Other IDs field does not map to the WORKER_DOCUMENT or WORKER_DOCUMENT_HISTORY tables.