Examples of Loading Job Requisitions
This topic provides sample files that show how to create and update job requisitions. It also shows how to set a job requisition to the Deleted status.
Creating Job Requisitions
Job Requisition in Draft – In Progress
This sample JobRequisition.dat file creates a basic job requisition in the Draft – In Progress status using the RequisitionNumber, CurrentPhaseCode, and CurrentStateCode, PrimaryLocationName, and OrganizationCode attributes.
METADATA|JobRequisition|RequisitionNumber|RecruitingType|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|OrganizationCode|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode|SourceSystemId|SourceSystemOwner
MERGE|JobRequisition|HDLJobRequisition|ORA_CAMPUS|Y|HDL-JobRequisition-Title|ZFRCE0571_ZBEN|ZFRCE001_ZBEN|Brazil|ZBEN United Benefits Corporation|REQUISITION_DRAFT|REQUISITION_IN_PROGRESS|ZFRCELOC1|US|CSP-DEFAULT|DEFAULT_AF|HDL-JobRequisition-SysID-1|HRC_SQLLOADER
Job Requisition with Child Objects
This sample JobRequisition.dat file creates a job requisition in the Open – Posted status with these child objects: PostingDetails, Language, Hiring Team, Other Location, Other Work Location, and Job Profile. The sample file below contains all the mandatory attributes required for the job load.
METADATA|JobRequisition|RequisitionNumber|RecruitingType|NumberOfOpenings|UnlimitedOpeningsFlag|RequisitionTitle|InternalRequisitionTitle|BusinessJustification|JobFunction|SourcingBudget|TravelBudget|RelocationBudget|EmployeeReferralBonus|MaximumSalary|MinimumSalary|PayFrequency|WorkerType|RegularOrTemporary|ManagementLevel|FullTimeOrPartTime|JobShift|JobType|EducationLevel|ContactNameExternal|ContactEmailExternal|ExternalShortDescription|ExternalDescription|ExternalEmployerDescriptionId|ExternalOrganizationDescriptionId|ContactNameInternal|ContactEmailInternal|InternalShortDescription|InternalDescription|InternalEmployerDescriptionId|InternalOrganizationDescriptionId|DisplayInOrgChartFlag|Comments|SourceSystemOwner|SourceSystemId|JobCode|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|GradeCode|OrganizationName|ClassificationCode|JobFamilyName|LegalEmployerName|BusinessUnitShortCode|DepartmentName|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BudgetCurrencyName|SalaryCurrencyName|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode
MERGE|JobRequisition|HDL-JobRequisitionOpenPosted|ORA_EXECUTIVES|6|No|HDL-JobRequisitionOpenPosted-Title|HDL-JobRequisitionOpenPosted-InternalTitle|New Position|Managerial|11000|12000|13000|14000|15000000|13000000|Annually|Employee|Regular|Supervisor|Full Time|Night|Standard|First Professional|External Name|external@gmail.com|ExtShortDesc-EN.txt|ExtLongDesc-EN.txt|300100126268471|300100171064623|Internal name|internal@gmail.com|IntShortDesc-EN.txt|IntLongDesc-EN.txt|300100171064619|300100171064623|No|Comments2.txt|HRC_SQLLOADER|HDL-JobRequisitionOpenPosted-SysID|ZFRCE CHRO|ZFRCE0525_ZBEN|ZFRCE001_ZBEN|United States|ZFRCE MGMT3|Vision Corporation Enterprise, ZBEN United Benefits Corporation|DEPARTMENT|ZFRCE_Management|ZFRCE_US_LE1_ZBEN|ZBEN_Common_Business Unit|ZFRCE US Payables|REQUISITION_OPEN|REQUISITION_POSTED|ZFRCELOC1|US Dollar|US Dollar|US|HDLTestCSP-001|ORA_GLOBAL_EXTERNAL
METADATA|PostingDetails|RequisitionNumber|ExternalOrInternal|StartDate|EndDate
MERGE|PostingDetails|HDL-JobRequisitionOpenPosted|Internal|2018/02/03 00:00:00|2030/12/11 00:00:00
MERGE|PostingDetails|HDL-JobRequisitionOpenPosted|External|2018/02/03 00:00:00|2030/12/11 00:00:00
METADATA|Language|LanguageCode|RequisitionNumber|SourceSystemId|SourceSystemOwner
MERGE|Language|KO|HDL-JobRequisitionOpenPosted|HDL-JobRequisitionOpenPosted-LANG-1|HRC_SQLLOADER
METADATA|HiringTeam|RequisitionNumber|PersonNumber|MemberType
MERGE|HiringTeam|HDL-JobRequisitionOpenPosted|ZFRCE071_ZBEN|Collaborator
METADATA|OtherLocation|RequisitionNumber|OtherLocationName|SourceSystemId|SourceSystemOwner
MERGE|OtherLocation|HDL-JobRequisitionOpenPosted|Germany|HDL-JobRequisitionOpenPosted-OLOC-1|HRC_SQLLOADER
METADATA|OtherWorkLocation|RequisitionNumber|OtherWorkLocationCode
MERGE|OtherWorkLocation|HDL-JobRequisitionOpenPosted|ZBEN_Greece
METADATA|JobProfile|RequisitionNumber|SourceSystemOwner|SourceSystemId|ContentType|DateFrom|ItemText301|ItemText303|ItemText305|ItemText3014|ItemText3015|ItemNumber1|ItemNumber2
MERGE|JobProfile|HDL-JobRequisitionOpenPosted|HRC_SQLLOADER|HDL-JobRequisitionOpenPosted-JP-1|WORK_REQUIREMENTS|2016/09/27|Y|N|N|MTS|WH1|7|5
Adding a Questionnaire and Questions to a Job Requisition
This sample JobRequisition.dat file adds an additional questionnaire and question to a job requisition. Prescreening questionnaires, if defined, are defaulted based on the context. The sample file below contains all the mandatory attributes required for the load.
METADATA|InterviewQuestionnaire|RequisitionNumber|QuestionnaireCode|TemplateFlag|QstnrVersionNum
MERGE|InterviewQuestionnaire|HDL-JobRequisition|300100166479930|N|1
METADATA|ApplicationSpecificQuestion|RequisitionNumber|QstnrTypeCode|QuestionCode|QstnVersionNum|AdhocFlag
MERGE|ApplicationSpecificQuestion|HDL-JobRequisition|ORA_INTERNAL_APPLYFLOW_QSTNR|500110-0278|1|N
Adding a Partner Configuration to the Job Requisition
This sample JobRequisition.dat file adds the background check, tax credit, and assessment child objects to a job requisition. The sample file below contains all the mandatory attributes required for the load.
Background Check
METADATA|BackgroundCheckConfiguration|RequisitionNumber|PartnerName|AccountUserName|MultipleRequestFlag|GUID|AccountId|ReqAccountId|AllowUpdateOnJaFlag|ProvisioningId|RequisitionId|SourceSystemId|SourceSystemOwner
MERGE|BackgroundCheckConfiguration|HDL-JobRequisition|HDLPartnerB221|BGCBrnzU|Y|||||||CFGSSID1|HRC_SQLLOADER
METADATA|BackgroundCheckScreeningPackageV2|RequisitionNumber|PartnerName|AccountUserName|ScrPkgCode|ScrPkgName|AddedBy|EnteringPhaseFlag|LeavingPhaseFlag|PhaseCode|StateCode|SourceSystemId|SourceSystemOwner
MERGE|BackgroundCheckScreeningPackageV2|HDL-JobRequisition|HDLPartnerB221|BGCBrnzU|HPKG1|HDLPkg1|ZFRCE001_ZBEN|Y|N|NEW||PKGSSID1|HRC_SQLLOADER
MERGE|BackgroundCheckScreeningPackageV2|HDL-JobRequisition|HDLPartnerB221|BGCBrnzU|HPKG2|HDLPkg2|ZFRCE001_ZBEN|||NEW|TO_BE_REVIEWED|PKGSSID2|HRC_SQLLOADER
MERGE|BackgroundCheckScreeningPackageV2|HDL-JobRequisition|HDLPartnerB221|BGCBrnzU|HPKG3|HDLPkg3|ZFRCE001_ZBEN|Y||300100539005663||PKGSSID2|HRC_SQLLOADER
MERGE|BackgroundCheckScreeningPackageV2|HDL-JobRequisition|HDLPartnerB221|BGCBrnzU|HPKG4|HDLPkg4|ZFRCE001_ZBEN|||300100539005663|300100185138381|PKGSSID3|HRC_SQLLOADER
MERGE|BackgroundCheckScreeningPackageV2|HDL-JobRequisition|HDLPartnerB221|BGCBrnzU|HPKG5|HDLPkg5|ZFRCE001_ZBEN|||SCREENING|PHONE_SCREEN_COMPLETED|PKGSSID4|HRC_SQLLOADER
Tax Credit
METADATA|TaxCreditConfiguration|AccountUserName|PartnerName|RequisitionNumber|SourceSystemId|SourceSystemOwner
MERGE|TaxCreditConfiguration|User-PTR2|Tax Credit-PTR|HDL-JobRequisition1|CFGSSIDTC1|HRC_SQLLOADER
MERGE|TaxCreditConfiguration|User-PTR2|Tax Credit-PTR|HDL-JobRequisition2|CFGSSIDTC2|HRC_SQLLOADER
METADATA|TaxCreditScreeningPackage|TriggerTypeCode|AccountUserName|PartnerName|RequisitionNumber|PackageCode|PackageName|SourceSystemOwner|SourceSystemId
MERGE|TaxCreditScreeningPackage|ORA_IRC_CSP|User-PTR2|Tax Credit-PTR|HDL-JobRequisition1|TCPKGCODE1|TCPKGNAME1|TCPKGSSID1|HRC_SQLLOADER
MERGE|TaxCreditScreeningPackage|ORA_IRC_APPLY_EXT|User-PTR2|Tax Credit-PTR|HDL-JobRequisition2|TCPKGCODE1|TCPKGNAME1|TCPKGSSID2|HRC_SQLLOADER
Assessment
METADATA|AssessmentConfiguration|AccountUserName|PartnerName|RequisitionNumber|MultiPhaseCspFlag|SourceSystemId|SourceSystemOwner
MERGE|AssessmentConfiguration|HDLABU221|HDL_BA01|HDLJobRequisition|Y|ASMT-CONF-1|HRC_SQLLOADER
METADATA|AssessmentScreeningPackage|AccountUserName|PartnerName|PackageCode|PackageName|TriggerTypeCode|PhaseCode|StateCode|RequisitionNumber|PackageSequence|SourceSystemId|SourceSystemOwner
MERGE|AssessmentScreeningPackage|HDLABU221|HDL_BA01|TESTPKG1|TestPkg1|ORA_IRC_CSP|NEW|TO_BE_REVIEWED|HDLJobRequisition|1|ASMT-PKG-1|HRC_SQLLOADER
MERGE|AssessmentScreeningPackage|HDLABU221|HDL_BA01|TESTPKG2|TestPkg2|ORA_IRC_CSP|SCREENING|PHONE_SCREEN_COMPLETED|HDLJobRequisition|2|ASMT-PKG-2|HRC_SQLLOADER
MERGE|AssessmentScreeningPackage|HDLABU221|HDL_BA01|TESTPKG3|TestPkg3|ORA_IRC_CSP|OFFER|OFFER_EXTENDED|HDLJobRequisition|3|ASMT-PKG-3|HRC_SQLLOADER
MERGE|AssessmentScreeningPackage|HDLABU221|HDL_BA01|TESTPKG4|TestPkg4|ORA_IRC_APPLY_INT|||HDLJobRequisition|4|ASMT-PKG-4|HRC_SQLLOADER
MERGE|AssessmentScreeningPackage|HDLABU221|HDL_BA01|TESTPKG5|TestPkg5|ORA_IRC_APPLY_EXT|||HDLJobRequisition|5|ASMT-PKG-5|HRC_SQLLOADER
Creating a Pipeline or Linked Job Requisition
This sample JobRequisition.dat file creates a pipeline job requisition using attributes such as RequisitionNumber, RequisitionTitle, CurrentPhaseCode, CurrentStateCode, and PipelineRequisitionFlag.
Pipeline Requisition
METADATA|JobRequisition|RequisitionNumber|RecruitingType|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|OrganizationCode|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode|SourceSystemId|SourceSystemOwner|PipelineRequisitionFlag
MERGE|JobRequisition|HDLJobRequisitionPipeline|ORA_CAMPUS|Y|HDL-JobRequisition-Pipeline|ZFRCE0571_ZBEN|ZFRCE001_ZBEN|Brazil|ZBEN United Benefits Corporation|REQUISITION_DRAFT|REQUISITION_IN_PROGRESS|ZFRCELOC1|US|CSP-DEFAULT|DEFAULT_AF|HDL-JobRequisition-SysID-1|HRC_SQLLOADER|Y
Linking a Hiring Requisition to a Pipeline Requisition
This sample JobRequisition.dat file links a hiring requisition to a pipeline requisition using attributes such as RequisitionNumber, RequisitionTitle, CurrentPhaseCode, CurrentStateCode, and PipelineRequisitionNumber.
METADATA|JobRequisition|RequisitionNumber|RecruitingType|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|OrganizationCode|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode|SourceSystemId|SourceSystemOwner|PipelineRequisitionNumber
MERGE|JobRequisition|HDLLinkedHiringRequsition|ORA_CAMPUS|Y|HDL-HDLLinkedHiringRequsition|ZFRCE0571_ZBEN|ZFRCE001_ZBEN|Brazil|ZBEN United Benefits Corporation|REQUISITION_DRAFT|REQUISITION_IN_PROGRESS|ZFRCELOC1|US|CSP-DEFAULT|DEFAULT_AF|HDL-JobRequisition-SysID-1|HRC_SQLLOADER|HDLJobRequisitionPipeline
Creating a Position-Based Job Requisition
The JobCode attribute can be passed to link a job to a requisition but the required values from the job requisition have to be explicitly provided in the JobRequisition.dat file.
Creating a Job-Based Job Requisition
The PositionCode attribute can be passed to link a job to a requisition but the required values from the job requisition have to be explicitly provided in the JobRequisition.dat file.
Creating a Confidential Job Requisition
This sample JobRequisition.dat file creates a confidential job requisition using attributes such as RequisitionNumber, CurrentPhaseCode, and CurrentStateCode, and ApplyWhenNotPostedFlag.
METADATA|JobRequisition|RequisitionNumber|RecruitingType|NumberOfOpenings|ApplyWhenNotPostedFlag|UnlimitedOpeningsFlag|RequisitionTitle|InternalRequisitionTitle|BusinessJustification|JobFunction|SourcingBudget|TravelBudget|RelocationBudget|EmployeeReferralBonus|MaximumSalary|MinimumSalary|PayFrequency|WorkerType|RegularOrTemporary|ManagementLevel|FullTimeOrPartTime|JobShift|JobType|EducationLevel|ContactNameExternal|ContactEmailExternal|ExternalShortDescription|ExternalDescription|ExternalEmployerDescriptionId|ExternalOrganizationDescriptionId|ContactNameInternal|ContactEmailInternal|InternalShortDescription|InternalDescription|InternalEmployerDescriptionId|InternalOrganizationDescriptionId|DisplayInOrgChartFlag|Comments|SourceSystemOwner|SourceSystemId|JobCode|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|GradeCode|OrganizationName|ClassificationCode|JobFamilyName|LegalEmployerName|BusinessUnitShortCode|DepartmentName|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BudgetCurrencyName|SalaryCurrencyName|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode
MERGE|JobRequisition|HDLJobRequisition|EXECUTIVE|7|YES|No|HDLJobRequisition-Title|HDLJobRequisition-InternalTitle|New Position|Managerial|11000|12000|13000|14000|15000000|13000000|Annually|Employee|Regular|Supervisor|Full Time|Night|Standard|First Professional|External Name|external@gmail.com|ExtShortDesc-EN.txt|ExtLongDesc-EN.txt|300100126268471|300100171064623|Internal name|internal@gmail.com|IntShortDesc-EN.txt|IntLongDesc-EN.txt|300100171064619|300100171064623|No|Comments2.txt|HRC_SQLLOADER|HDLJobRequisition-SysID|ZFRCE CHRO|ZFRCE0525_ZBEN|ZFRCE001_ZBEN|United States|ZFRCE MGMT3|Vision Corporation Enterprise, ZBEN United Benefits Corporation|DEPARTMENT|ZFRCE_Management|ZFRCE_US_LE1_ZBEN|ZBEN_Common_Business Unit|ZFRCE US Payables|REQUISITION_OPEN|REQUISITION_NOT_POSTED|ZFRCELOC1|US Dollar|US Dollar|US|HDLTestCSP-001|HDL-JAFlow01
Updating Requisitions
This sample JobRequisition.dat file moves a job requisition to the Job Formatting – In Progress status and updates its primary work location and Candidate Selection Process (CSP) using these attributes: CurrentPhaseCode, CurrentStateCode, PrimaryWorkLocationCode, and CandidateSelectionProcessCode. In addition to these, the RequisitionNumber attribute is mandatory.
METADATA|JobRequisition|RequisitionNumber|RecruitingType|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|OrganizationCode|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode|SourceSystemId|SourceSystemOwner
MERGE|JobRequisition|HDLJobRequisition|ORA_CAMPUS|Y|HDL-JobRequisition-Title|ZFRCE0571_ZBEN|ZFRCE001_ZBEN|Brazil|ZBEN United Benefits Corporation|REQUISITION_JOB_FORMATTING|REQUISITION_IN_PROGRESS|ZFRCELOC1UPD|US|CSP-UPDATED|DEFAULT_AF|HDL-JobRequisition-SysID-1|HRC_SQLLOADER
Deleting Requisitions
This sample JobRequisition.dat file moves a job requisition to the Draft – Deleted status by updating the CurrentPhaseCode and CurrentStateCode attributes. In addition to these, the RequisitionNumber attribute is mandatory.
METADATA|JobRequisition|RequisitionNumber|RecruitingType|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|OrganizationCode|CurrentPhaseCode|CurrentStateCode|PrimaryWorkLocationCode|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode|SourceSystemId|SourceSystemOwner
MERGE|JobRequisition|HDLJobRequisition|ORA_CAMPUS|Y|HDL-JobRequisition-Title|ZFRCE0571_ZBEN|ZFRCE001_ZBEN|Brazil|ZBEN United Benefits Corporation|REQUISITION_DRAFT|REQUISITION_DELETED|ZFRCELOC1|US|CSP-DEFAULT|DEFAULT_AF|HDL-JobRequisition-SysID-1|HRC_SQLLOADER