Saturday 4 September 2021

HDL Template for Job Requisition

HDL Template for Job Requisition 


For this use JobRequisition.dat file.

You can see step by step video to load Job Requisition data using this Link


Please find the below sample template :

METADATA|JobRequisition|RequisitionNumber|RecruitingType|JobCode|JobFamilyCode|JobFunction|NumberOfOpenings|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerId|RecruiterId|PrimaryLocationId|PrimaryWorkLocationId|OrganizationId|DepartmentName|LegalEmployerName|WorkerType|RegularOrTemporary|FullTimeOrPartTime|EducationLevel|CurrentPhaseCode|CurrentStateCode|ExternalApplyFlowCode|PositionCode|BaseLanguageCode|BusinessUnitShortCode|CandidateSelectionProcessCode

MERGE|JobRequisition|XXTEST100|ORA_EXECUTIVES|XXTEST_PM|HUMAN RESOURCES|GSE_TEACH|2|N|XXTEST100|100000610420334|100000610420436|300000186934005|300000221843104|300000047826629|XXTEST Department1|US1 Legal Entity|E|Regular|FULL_TIME|13|REQUISITION_OPEN|REQUISITION_POSTED|ORC_FACULTY|XXTEST_POS1|US|US1 Business Unit|ORC_FACULTY


METADATA|PostingDetails|StartDate|ExternalOrInternal|RequisitionNumber

MERGE|PostingDetails|2021/08/23 00:00:00|ORA_INTERNAL|XXTEST100

MERGE|PostingDetails|2021/08/23 00:00:00|ORA_EXTERNAL|XXTEST100


Avoid/Ignore if we have empty tag in XML.

 Ignore the Empty Tag in XML or avoid blank rows in For loop BIP Report. If we have blank row of data in For Loop in BIP Reports like in bel...