For Oracle, application status change data (Outcome Data) collection can be collected via flat-file data transfer.
Clients can automate this through Oracle reporting system or any other data 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 |
| Optional | This value is provided by Sapia.ai and remains constant across all records. |
| Required | Maps to candidateToken in Oracle. |
| Required | The Candidate phase-state name as configured in your Oracle tenant (e.g. Offer-Accetped).
Contact Sapia.ai to configure the mapping between your Oracle status phase-state and the corresponding Sapia.ai stages: The phase-state names must be provided to Sapia.ai verbatim Note: The Phase–State values below are provided as a reference only — your configuration may differ. |
| Required | Format: Timestamp when the status change occurred |
| Optional | Free-text field for additional information about the status change |
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: