Examples of Loading Candidate Job Applications

This topic provides sample files that show how to create and delete job applications, and also move them to specific phases and states that are supported in HCM Data Loader.

Creating Candidate Job Applications

Job Application with Basic Information

This sample CandidateJobApplication.dat file creates a basic job application using the RequisitionNumber, CandidateNumber, SubmissionLanguageCode, SourceSystemId, and SourceSystemOwner attributes.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|SubmissionLanguageCode|SourceSystemId|SourceSystemOwner

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|KO|CAN001-HDLJobRequisition|HRC_SQLLOADER

Job Application with Full Information

This sample CandidateJobApplication.dat file creates a full job application, including child objects such as Attachment and Candidate Job Application Profile. The sample file contains the required attributes required for the load.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|SubmissionLanguageCode|SourceSystemId|SourceSystemOwner|Source|SourceMedium
METADATA|Attachment|Title|File|DataTypeCode|URLorFileName|RequisitionNumber|CandidateNumber|Category
METADATA|CandidateJobApplicationProfile|RequisitionNumber|CandidateNumber|ContentTypeId|ContentItem|ContentType|CountryId|Importance|DateFrom|DateTo|ItemDate1|ItemDate2|ItemDate3|ItemDate4|ItemDate6|ItemDate7|ItemDate8|ItemDecimal1|ItemNumber1|ItemNumber2|ItemNumber3|ItemNumber4|ItemNumber5|ItemNumber8|ItemNumber9|ItemNumber10|ItemText20001|ItemText20003|ItemText20004|ItemText20005|ItemText2401|ItemText2402|ItemText2403|ItemText2404|ItemText2405|ItemText2406|ItemText2407|ItemText2408|ItemText2409|ItemText24012|ItemText24013|ItemText24014|ItemText301|ItemText302|ItemText303|ItemText304|ItemText305|ItemText306|ItemText307|ItemText308|ItemText309|ItemText3010|ItemText3011|ItemText3012|ItemText3013|RatingLevelId1|RatingLevelId2|RatingLevelId3|RatingModelId1|RatingModelId2|RatingModelId3|ItemClob1|ItemClob2|ItemClob3|ItemClob4|ItemClob5|SourceSystemId|SourceSystemOwner|CountryCountryCode|StateGeographyCode

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|KO|SUB-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|email|campaign
MERGE|Attachment|CAN001-Resume-File|Resume.rtf|FILE|Resume.rtf|HDLJobRequisition|CAN001|IRC_CANDIDATE_RESUME
MERGE|Attachment|CAN001-Resume-Link||WEB_PAGE|http://www.google.com|HDLJobRequisition|CAN001|IRC_CANDIDATE_RESUME
MERGE|Attachment|CAN001-CoverLetter-File|Cover-Letter.doc|FILE|Cover-Letter.doc|HDLJobRequisition|CAN001|IRC_CANDIDATE_COVERLETTER
MERGE|Attachment|CAN001-CoverLetter-Link||WEB_PAGE|http://www.oracle.com|HDLJobRequisition|CAN001|IRC_CANDIDATE_COVERLETTER
MERGE|Attachment|CAN001-Social-Link||WEB_PAGE|http://www.facebook.com|HDLJobRequisition|CAN001|IRC_CANDIDATE_SOCIAL
MERGE|Attachment|CAN001-InternalDoc-File|Internal-Document.docx|FILE|Internal-Document.docx|HDLJobRequisition|CAN001|IRC_INTERNAL
MERGE|Attachment|CAN001-InternalDoc-Link||WEB_PAGE|http://www.yahoo.com|HDLJobRequisition|CAN001|IRC_INTERNAL
MERGE|CandidateJobApplicationProfile|HDLJobRequisition|CAN001|109|Korean|Languages||2|2018/06/22||2018/05/06||||||||||||||||||||||||||||||||Y|N|Y|||||||||||8001|8002|8003|8|8|8|Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|SUBPROF-LANG-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|US|GU
MERGE|CandidateJobApplicationProfile|HDLJobRequisition|CAN001|117||||2|2018/06/21||||||||||100000011915673|100000012474304|100000015162235|100000011915004|||130000|77|||||JA Relocation Reason Text 123||||||||||||Y|25PCT|Y|75PCT|Y||Y|Y|Y|PKR|M|||||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|SUBPROF-WORKREQ-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|US|CA
MERGE|CandidateJobApplicationProfile|HDLJobRequisition|CAN001|106|ML - Masters Level Degree|Degrees|1|2|2018/06/25|||||2015/04/30|2016/06/08|2013/07/01|2016/05/31|9.98|77777|44444|99999|||2016|300100153827153||JA School Name Test 123|JAComments Comments Comments||JA Reimbursement Arrangements Comments|JA Major Test 123||JA Awarding Body Test 123|JA Educator Test 123|JA Minor Test 123|A|55555||JA Faculty or Department Test 123|JA City Test 123|||Y|N|SAR|GOOD|N||Class||||Active|Y|I|||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|SUBPROF-DEGREE-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|US|MA
MERGE|CandidateJobApplicationProfile|HDLJobRequisition|CAN001|129||||2|2018/06/25||2013/07/13|2015/07/12||||||||||||300100148485144|||JA Gained Knowledge on C++||||JA Previous Employer Name Test 1|JA Other Job Function Test 1|7777777777|JASupervisorEmailTest1@oracle.com||JA Supervisor Name Test 1|JA Supervisor Title Test 1|JA Starting Position Test 1|Junior QA|JA Employer City Test 1|JA Type of Business Test 1|JA Other Compensation Test 123|N|Y|||||MANAG|First IT Services||||||||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|SUBPROF-PREVEMP-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|US|IA
MERGE|CandidateJobApplicationProfile|HDLJobRequisition|CAN001|103|Oracle Certified Professional (OCP)|Licenses and Certifications|10099|2|2018/06/25||||2019/06/20|2018/12/13|2017/07/11|||||1221123|1221140||||300100153573741||JA Educational Establishment Test 123|Comments Comments|JA Restrictions Comments Values||Cardio Pulmonary Title|JA Certificate Number Test 123||JA Issued By Test 123|||123||||||Y||||N|Y||||||||||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|SUBPROF-CERT-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|AU|ACT

Job Application with Feedback Responses

This sample CandidateJobApplication.dat file shows how to upload feedback responses received along with rating from the hiring team.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|SubmissionLanguageCode|SourceSystemId|SourceSystemOwner|Source|SourceMedium
METADATA|QuestionnaireParticipant|RequisitionNumber|CandidateNumber|QuestionnaireCode|QstnrVersionNum|FeedbackResponseFlag|RespondentPersonNumber|Rating
METADATA|QuestionnaireResponse|AttemptNum|QstnrVersionNum|RequisitionNumber|CandidateNumber|QuestionnaireCode|FeedbackResponseFlag|RespondentPersonNumber|FeedbackCompletionDate
METADATA|QuestionResponse|QuestionId|QuestionCode|QstnVersionNum|AttemptNum|QstnrVersionNum|QuestionnaireCode|RequisitionNumber|CandidateNumber|SectionSeqNum|AnswerCode
|FeedbackResponseFlag|RespondentPersonNumber

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|KO|SUB-ZFRCE-HDLJOBREQ|HRC_SQLLOADER|email|campaign
MERGE|QuestionnaireParticipant|44|47001|300000052162209|1|Y|212|5
MERGE|QuestionnaireResponse|1|1|44|47001|300000052162209|Y|212|2023/08/22 21:42:20
MERGE|QuestionResponse|300000049666199|WK_UI_AQ|1|1|1|300000052162209|44|47001|10192|300000049666212|Y|212

Deleting Candidate Job Applications

This sample CandidateJobApplication.dat file shows how to delete a candidate job application using the InactivateFlag attribute.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|InactivateFlag

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|Y

Deleting Attachments

This sample CandidateJobApplication.dat file shows how to delete an attachment.

METADATA|Attachment|AttachedDocumentId|PersonId|SubmissionId
DELETE|Attachment|30000023217|4560700|8945600000

METADATA|Attachment|Title|File|DataTypeCode|URLorFileName|RequisitionNumber|CandidateNumber|Category
DELETE|Attachment|CAN001-Resume-File|Resume.rtf|FILE|Resume.rtf|HDLJobRequisition|CAN001|IRC_CANDIDATE_RESUME

Movement of Job Applications Through Phases and States

Movement Before the Offer Phase

This sample CandidateJobApplication.dat file shows how to move a candidate job application through the Candidate Selection Process prior to the Offer phase.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|CurrentPhaseCode|CurrentStateCode

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|NEW|UNDER_CONSIDERATION
MERGE|CandidateJobApplication|HDLJobRequisition|CAN002|INTERVIEW|IN_PROGRESS

Movement in the Offer Phase

This sample CandidateJobApplication.dat file shows how to move a candidate job application between two different states in the Offer phase.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|CurrentPhaseCode|CurrentStateCode

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|OFFER|OFFER_EXTENDED
MERGE|CandidateJobApplication|HDLJobRequisition|CAN002|OFFER|OFFER_ACCEPTED

Movement in the HR Phase

This sample CandidateJobApplication.dat file shows how to move a candidate job application to the Pending Automated Processing and Rejected by Employer states in the HR phase.

METADATA|CandidateJobApplication|RequisitionNumber|CandidateNumber|CurrentPhaseCode|CurrentStateCode

MERGE|CandidateJobApplication|HDLJobRequisition|CAN001|HR|AUTOPROCESSING_PENDING
MERGE|CandidateJobApplication|HDLJobRequisition|CAN002|HR|REJECTED_EMPLOYER