Examples of Loading Candidates

This topic provides examples that show how to load candidates.

Creating Candidates

This example Candidate.dat file creates a basic candidate record with the attributes CandidateNumber, CandidateEmail, CandidateName, CandidatePhone and CandidateAddress.

METADATA|Candidate|CandidateNumber|PrefPhoneCntTypeCode|ObjectStatus|AvailabilityDate|StartDate|CountryOfBirth|RegionOfBirth|TownOfBirth|AddedByFlowCode|ConfirmedFlag|VisibleToCandidateFlag|CandPrefLanguageCode|SourceSystemId|SourceSystemOwner
MERGE|Candidate|CAN001|HM|Active|2017/11/01 00:00:00|2015/12/01|US|Colorado|Denver|ORA_INTERNAL|Y|Y|US|CAN001|HRC_SQLLOADER
METADATA|CandidateEmail|SourceSystemId|DateFrom|EmailAddress|EmailType|SourceSystemId|SourceSystemOwner
MERGE|CandidateEmail|CAN001|2015/12/01|CAN001@invalidemail.com|Home Email|CAN001_EMAIL|HRC_SQLLOADER
METADATA|CandidateName|EffectiveStartDate|CandidateNumber|NameType|FirstName|LastName|SourceSystemId|SourceSystemOwner
MERGE|CandidateName|2015/12/01|CAN001|GLOBAL|CAN001_FN|CAN001_LN|CAN001_NAME|HRC_SQLLOADER
METADATA|CandidatePhone|CandidateNumber|AreaCode|PhoneNumber|PhoneType|DateFrom|SourceSystemId|SourceSystemOwner
MERGE|CandidatePhone|CAN001|749|3111227|HM|2015/12/01|CAN001_PHONE|HRC_SQLLOADER
METADATA|CandidateAddress|CandidateNumber|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|FloorNumber|TownOrCity|Region1|Region2|Region3|Country|PostalCode|EffectiveStartDate|AddressType|SourceSystemId|SourceSystemOwner
MERGE|CandidateAddress|CAN001|879 Fyxaiba Street|Suite 4242|||||FLORENCE|BOONE|KY||US|41022|2015/12/01|HOME|CAN001_ADDR|HRC_SQLLOADER

This example Candidate.dat file creates a comprehensive candidate record with all its child attributes CandidateNumber, CandidateEmail, CandidateName, CandidatePhone, CandidateAddress, CandidateProfile, CandidateInteraction, CandidatePreference, CandidatePreferredJobFamily, CandidatePreferredLocation, and Attachment.

METADATA|Candidate|CandidateNumber|PrefPhoneCntTypeCode|ObjectStatus|AvailabilityDate|StartDate|CountryOfBirth|RegionOfBirth|TownOfBirth|AddedByFlowCode|ConfirmedFlag|VisibleToCandidateFlag|CandPrefLanguageCode|SourceSystemId|SourceSystemOwner
MERGE|Candidate|CAN002|HM|Active|2017/11/01 00:00:00|2015/12/01|US|Colorado|Denver|ORA_INTERNAL|Y|Y|US|CAN002|HRC_SQLLOADER
METADATA|CandidateEmail|SourceSystemId|DateFrom|EmailAddress|EmailType|SourceSystemId|SourceSystemOwner
MERGE|CandidateEmail|CAN002|2015/12/01|CAN002@invalidemail.com|Home Email|CAN002_EMAIL|HRC_SQLLOADER
METADATA|CandidateName|EffectiveStartDate|CandidateNumber|NameType|FirstName|LastName|SourceSystemId|SourceSystemOwner
MERGE|CandidateName|2015/12/01|CAN002|GLOBAL|CAN002_FN|CAN002_LN|CAN002_NAME|HRC_SQLLOADER
METADATA|CandidatePhone|CandidateNumber|AreaCode|PhoneNumber|PhoneType|DateFrom|SourceSystemId|SourceSystemOwner
MERGE|CandidatePhone|CAN002|749|3111228|HM|2015/12/01|CAN002_PHONE|HRC_SQLLOADER
METADATA|CandidateAddress|CandidateNumber|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|FloorNumber|TownOrCity|Region1|Region2|Region3|Country|PostalCode|EffectiveStartDate|AddressType|SourceSystemId|SourceSystemOwner
MERGE|CandidateAddress|CAN002|879 Fyxaiba Street|Suite 4242|||||FLORENCE|BOONE|KY||US|41022|2015/12/01|HOME|CAN002_ADDR|HRC_SQLLOADER
METADATA|CandidateProfile|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
MERGE|CandidateProfile|CAN002|109|Telugu|Languages||2|2018/06/22||2018/05/06||||||||||||||||||||||||||||||||Y|N|Y|||||||||||8002|8003|8001|8|8|8|Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|CAN002_LANG_0|HRC_SQLLOADER
MERGE|CandidateProfile|CAN002|117||||2|2018/06/21||||||||||100000011915673|100000012474304|100000015162235|100000011915004|||130000|77|||||Relocation Reason Text 123||||||||||||Y|75PCT|Y|25PCT|Y||Y|Y|Y|PKR|M|||||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|CAN002_WORKEXP_0|HRC_SQLLOADER
MERGE|CandidateProfile|CAN002|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||School Name Test 123|Comments Comments Comments||Reimbursement Arrangements Comments|Major Test 123||Awarding Body Test 123|Educator Test 123|Minor Test 123|A|55555||Faculty or Department Test 123|City Test 123|||Y|N|SAR|GOOD|N||Class||||Active|Y|I|||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|CAN002_DEGREE_0|HRC_SQLLOADER
MERGE|CandidateProfile|CAN002|129||||2|2018/06/25||2013/07/13|2015/07/12||||||||||||300100148485144|||Gained Knowledge on C++||||Previous Employer Name Test 1|Other Job Function Test 1|7777777777|SupervisorEmailTest1@oracle.com||Supervisor Name Test 1|Supervisor Title Test 1|Starting Position Test 1|Junior QA|Employer City Test 1|Type of Business Test 1|Other Compensation Test 123|N|Y|||||MANAG|First IT Services||||||||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|CAN002_PREVEMP_0|HRC_SQLLOADER
MERGE|CandidateProfile|CAN002|103|Oracle Certified Professional (OCP)|Licenses and Certifications|10099|2|2018/06/25||||2019/06/20|2020/12/13|2020/07/11|||||1221123|1221140||||300100153573741||Educational Establishment Test 123|Comments Comments|Restrictions Comments Values||Cardio Pulmonary Title|Certificate Number Test 123||Issued By Test 123|||123||||||Y||||N|Y||||||||||||||Clob1.txt|Clob2.txt|Clob3.txt|Clob4.txt|Clob5.txt|CAN002_LIC_CERT_0|HRC_SQLLOADER
METADATA|CandidateInteraction|AddedByPersonId|InteractionDate|InteractionId|InteractionTypeCode|PersonId|CandidateNumber|Text|SourceSystemId|SourceSystemOwner
MERGE|CandidateInteraction|300100148463523|2018/01/01 12:00:00||ORA_EMAIL||CAN002|SentEmail.txt|CAN002-Interaction1_SysId|HRC_SQLLOADER
METADATA|CandidatePreference|CandidateNumber|OptInTcEmailsDate|OptInTcEmailsFlag|SiteNumber|TcConfirmedFlag|TcConfirmedDate|SourceSystemId|SourceSystemOwner
MERGE|CandidatePreference|CAN002|2018/10/01 12:30:22|Y|CX|Y|2018/10/10 12:30:30|CAN002-CandPref_SysId|HRC_SQLLOADER
METADATA|CandidatePreferredJobFamily|CandidateNumber|JobFamilyName|SiteNumber|SourceSystemId|SourceSystemOwner
MERGE|CandidatePreferredJobFamily|CAN002|ZFRCE_Planning|CX|CAN002-CandPrefJobFam1_SysId|HRC_SQLLOADER
MERGE|CandidatePreferredJobFamily|CAN002|ZFRCE_Supply Chain and Distribution|CX|CAN002-CandPrefJobFam2_SysId|HRC_SQLLOADER
METADATA|CandidatePreferredLocation|CandidateNumber|LocationName|SiteNumber|SourceSystemId|SourceSystemOwner
MERGE|CandidatePreferredLocation|CAN002|United States|CX|CAN002-CandPrefLoc1_SysId|HRC_SQLLOADER
MERGE|CandidatePreferredLocation|CAN002|Canada|CX|CAN002-CandPrefLoc2_SysId|HRC_SQLLOADER
METADATA|Attachment|File|DataTypeCode|CandidateNumber|Title|URLorFileName|Category
MERGE|Attachment|CAN002Resume.txt|FILE||CAN002|TestAttach.txt|CAN002Resume.txt|IRC_CANDIDATE_RESUME

Adding Candidates to Candidate Pool

This example Candidate.dat file creates a candidate record and adds it to a candidate pool using the AddToPoolName and PoolOwnerPersonName attributes.

Note: When you are loading the Candidate.dat file using HDL for the second time for a specific candidate, ensure that you remove the AddToPoolName attribute for that candidate and then reload the file.

METADATA|Candidate|CandidateNumber|PrefPhoneCntTypeCode|ObjectStatus|AvailabilityDate|StartDate|CountryOfBirth|RegionOfBirth|TownOfBirth|AddedByFlowCode|ConfirmedFlag|VisibleToCandidateFlag|CandPrefLanguageCode|SourceSystemId|SourceSystemOwner|AddToPoolName|PoolOwnerPersonNumber
MERGE|Candidate|CAN003|HM|Active|2017/11/01 00:00:00|2015/12/01|US|Colorado|Denver|ORA_INTERNAL|Y|Y|US|CAN003|HRC_SQLLOADER|POOL001|POOLOWNER01
METADATA|CandidateName|EffectiveStartDate|CandidateNumber|NameType|FirstName|LastName|SourceSystemId|SourceSystemOwner
MERGE|CandidateName|2015/12/01|CAN003|GLOBAL|CAN003_FN|CAN003_LN|CAN003_NAME|HRC_SQLLOADER
METADATA|CandidatePhone|CandidateNumber|AreaCode|PhoneNumber|PhoneType|DateFrom|SourceSystemId|SourceSystemOwner
MERGE|CandidatePhone|CAN003|749|3111229|HM|2015/12/01|CAN003_PHONE|HRC_SQLLOADER

Updating Candidates

This example Candidate.dat file updates the CandidateAddress of a candidate record.

METADATA|CandidateAddress|CandidateNumber|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|FloorNumber|TownOrCity|Region1|Region2|Region3|Country|PostalCode|EffectiveStartDate|AddressType|SourceSystemId|SourceSystemOwner
MERGE|CandidateAddress|CAN002|879 Fyxaiba Street|Suite 4253|||||FLORENCE|BOONE|KY||US|41024|2015/12/01|HOME|CAN002_ADDR|HRC_SQLLOADER

Deleting Candidates

This example Candidate.dat file deletes the candidate record using the CandidateNumber attribute.

METADATA|Candidate|CandidateNumber
DELETE|Candidate|CAN_TBD-01