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