Skip to main content

How to Obtain Demographics Data via flat-file Integration for Oracle (ORC)

This guide explains how to configure Oracle Recruiting to send candidate demographic data to Sapia.ai via flat-file (CSV) export.

E
Written by Elbert Pranoto

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

sFTP Folder: DemographicsData

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

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?