Skip to main content

How to Obtain Demographics Data via flat-file Integration for Dayforce

E
Written by Elbert Pranoto

For Dayforce, demographics collection is collected via flat-file data transfer.
Clients can automate this through Dayforce reporting system or any other export service, with files transferred to Sapia.ai on a regular schedule via sFTP.

For sFTP setup instructions, refer to: https://help.sapia.ai/en/articles/12394560-importing-data-via-sftp


CSV Specification

Column Header

Required?

Description

externalTenantID

Required

This value is provided by Sapia.ai and remains constant across all records.

externalApplicationID

Required

Maps to candidateAssessmentGuid in Dayforce.
This value is sent to Sapia.ai through the assessment integration)

gender

Optional

Format: String

ethnicity

Optional

Format: String

disability

Optional

Format: String
Disability status

first_nation

Optional

Format: String
First Nations people

veteran

Optional

Format: String
Veteran status

easl

Optional

Format: String
English as Second Language

age

Optional

Format: Integer
Candidate's age.

Note on column order and headers: Column headers and their order do not need to match this specification exactly. Sapia.ai supports configuration mapping, so columns can be mapped to the correct fields during setup on Sapia.ai's configuration

Below is the sample file:

Did this answer your question?