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

Adding an Interview Schedule to the Job Requisition

This sample JobRequisition.dat file creates an interview schedule along with the location of the interview, using attributes such as ScheduleCode, ScheduleTemplate, LocationCode, and LocationType.

METADATA|JobRequisition|RequisitionNumber|RecruitingType|NumberOfOpenings|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerPersonNumber|RecruiterPersonNumber|PrimaryLocationName|OrganizationName|ClassificationCode|CurrentPhaseCode|CurrentStateCode|BaseLanguageCode|CandidateSelectionProcessCode|ExternalApplyFlowCode|HotJobFlag|BusinessUnitShortCode
MERGE|JobRequisition|ZBEN-HDLIS-APR15-1101_01|Executive|7|No|ZBEN-HDLIS-APR15-1101_01|ZFRCE001_ZBEN|ZFRCE1301_ZBEN|United States|Vision Corporation Enterprise, ZBEN United Benefits Corporation|DEPARTMENT|REQUISITION_OPEN|REQUISITION_POSTED|US|HDLTestCSP-001|ORA_GLOBAL_EXTERNAL|N|ZBEN_Common_Business Unit

METADATA|PostingDetails|PublishedJobId|RequisitionId|StartDate|EndDate|ExternalOrInternal|PostingStatus|RequisitionNumber
MERGE|PostingDetails|||2022/07/08 06:04:00|2034/07/08 08:04:00|Internal||ZBEN-HDLIS-APR15-1101_01
MERGE|PostingDetails|||2022/07/08 06:04:00|2034/07/08 08:04:00|External||ZBEN-HDLIS-APR15-1101_01

METADATA|RequisitionInterviewSchedule|ScheduleCode|RequisitionNumber|ScheduleTemplate|ScheduleTitle|IsCancellableFlag|HasChangeLockFlag|IntervwChangeLockCode|Status|IncludeIcs|IncludeJobPostingLink|IncludeResume|ScheduleAlmostFullNotif|ScheduleAlmostFullThreshold|ScheduleId|RequisitionId|ScheduleOwner|InterviewTitle
MERGE|RequisitionInterviewSchedule|HDLIS-APR15-1101_01|ZBEN-HDLIS-APR15-1101_01|HR Advisor_001|HDLIS-APR15-1101_01|Y|Y|ORA_IS_12_HOURS_CHANGE_LOCK|ORA_IS_PUBLISHED|N|Y||||||ZFRCE1101_ZBEN|Interview-Title-01

METADATA|RequisitionInterviewScheduleLocation|LocationCode|LocationType|ScheduleCode|PhoneAreaCode|PhoneCountryCodeNumber|PhoneNumber|PhoneNumberExt|PhoneNumberPasscode|WebConferenceLink|PersonLocationCode|LocationId|BusinessUnitShortCode|InterviewLocationCode
MERGE|RequisitionInterviewScheduleLocation|HDLISLOC-APR15-1101_01|ORA_IS_LOCATION_PHONE|HDLIS-APR15-1101_01||213|1234225|12|||||ZBEN_Common_Business Unit|ZBEN-USLoc011

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