Skip to main content

Setting Up Outcome Data Status (status change) via flat-file Integration for Dayforce

This guide covers how Dayforce pushes outcome data to Sapia.ai via flat-file (CSV), ensuring application statuses stay up to date automatically.

E
Written by Elbert Pranoto

For Dayforce, application status change data (Outcome Data) collection can be 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.

sFTP Folder: StatusChangeData

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


CSV Specification

File Type/Format: CSV (Comma Separated Value)

Column Header

Required?

Description

externalTenantID

Optional

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

externalApplicationID

Optional/Required

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

Please read the note below on Data Identifiers

externalCandidateID

Optional/Required

Maps to Candidate Id in Dayforce

Please read the note below on Data Identifiers

externalJobID

Optional/Required

Maps to Job Id in Dayforce

Please read the note below on Data Identifiers

applicationStatus

Required

The Candidate status name as configured in your Dayforce tenant (e.g. Manager Review, Hired, Pre-Offer, Offer Accepted).

Contact Sapia.ai to configure the mapping between your Dayforce status names and the corresponding Sapia.ai stages:
​APPS_APPLICATION_NEW
​APPS_APPLICATION_LONGLISTED
​APPS_APPLICATION_SHORTLISTED
​APPS_APPLICATION_INTERVIEW
​APPS_APPLICATION_DECLINED
​APPS_APPLICATION_OFFERED
​APPS_APPLICATION_HIRED
​APPS_APPLICATION_WITHDRAWN

Candidate status names must be provided to Sapia.ai verbatim

date

Required

Format: yyyy-MM-dd

Timestamp when the status change occurred

comment

Optional

​Free-text field for additional information

about the status change

Important Notes

Column order and Headers

Column headers and their order do not need to match this specification exactly. Sapia.ai supports flexible field mapping during setup, so your CSV columns can be mapped to the correct fields in Sapia.ai's configuration.

Below is the sample file:

Did this answer your question?