Additional Employment Objects Support in Offer Worker HDL

HCM Data Loader's (HDL) Offer Worker process now supports the following additional employment objects.

  • Assignment EFF
  • Weekly Working Hours
  • Work Relationship flexfields
  • Contract details.

You need to upload the Job Offers.dat file. This is a sample of the Offers.dat file:

METADATA|JobOffer|Comments|RecruiterId|RecruiterAssignmentId|PersonId|SubmissionId|RequisitionId|CandidateNumber|RequisitionNumber|HiringManagerPersonNumber|HiringManagerAssignmentNumber|RecruiterPersonNumber|RecruiterAssignmentNumber|HiringManagerAssignmentId|HiringManagerId|ProposedStartDate|LegalEmployer|WorkerType|PreselectedHrActionId|ActionCode|LegalEntityId|GUID|SourceSystemId|SourceSystemOwner
MERGE|JobOffer|EXT CANDIDATE - CAN59092387064||||||CAN59092387064|ZBEN-1810-OFFER-MAN|ZFRCE1509_ZBEN|EZFRCE1509_ZBEN|ZFRCE1501_ZBEN|EZFRCE1501_ZBEN|||2025/09/11|ZFRCE_USA_GAMMA_2TSCSA_ZBEN|Employee|100010026279603|ADD_PEN_WKR|||SSID_CAN59092387064ZBEN-1810-OFFER-MAN|HRC_SQLLOADER

Next, you need to upload the worker dat file. This is a sample of the Worker.dat file:

SET OFFER_ASSIGNMENTS_FILE Y
SET CALCULATE_FTE N
METADATA|WorkRelationship|DateStart|WorkerType|LegalEmployerName|PeriodOfServiceId|PrimaryFlag|SourceSystemId|SourceSystemOwner|ActionCode|PersonId|FLEX:PER_PPS_DF|wrAttrAdditional(PER_PPS_DF=Global Data Elements)
METADATA|WorkTerms|ActionCode|AssignmentId|AssignmentNumber|AssignmentType|BusinessUnitShortCode|GradeLadderPgmId|GradeLadderPgmName|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|PeriodOfServiceId(SourceSystemId)|DateStart|WorkerType|LegalEmployerName|PersonId|PersonTypeId|PersonTypeCode|SystemPersonType|SourceSystemOwner|SourceSystemId
METADATA|Assignment|ActionCode|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentNumber|BusinessUnitShortCode|GradeLadderPgmId|GradeLadderPgmName|NormalHours|Frequency|PositionCode|PositionOverrideFlag|JobCode|GradeCode|LocationCode|DepartmentName|PersonTypeCode|ProjectedStartDate|ProposedUserPersonType|ProposedWorkerType|SystemPersonType|WorkTermsNumber|SourceSystemId|SourceSystemOwner|TaxReportingUnit|OfferId(SourceSystemId)|CandidateNumber|RequisitionId|RequisitionNumber|WorkTermsAssignmentId(SourceSystemId)|FLEX:PER_ASG_DF|fblg2(PER_ASG_DF=Global Data Elements)|_Currency(PER_ASG_DF=PER_ASG_DF)
METADATA|Contract|PersonId|EffectiveStartDate|EffectiveEndDate|AssignmentId(SourceSystemId)|ContractType|SourceSystemId|SourceSystemOwner|Duration|DurationUnits|ExtensionPeriod|ExtensionPeriodUnits
MERGE|WorkRelationship|2025/09/11|O|ZFRCE_USA_GAMMA_2TSCSA_ZBEN|||WRK_Offer_CAN59092387082|HRC_SQLLOADER|EMPL_OFFER_CREATE|300100171103390|PPS_DF|A
MERGE|WorkTerms|EMPL_OFFER_CREATE|||OT|ZBEN_Common_Business Unit|||4712/12/31|Y|1|2025/09/11|WRK_Offer_CAN59092387082|2025/09/11|O|ZFRCE_USA_GAMMA_2TSCSA_ZBEN|||Recruiting Candidate|ORA_CANDIDATE|HRC_SQLLOADER|WT_Offer_CAN59092387082
MERGE|Assignment|EMPL_OFFER_CREATE||2025/09/11|4712/12/31|1|Y|O||ZBEN_Common_Business Unit|||||ZBEN ZB Analyst Position|Y|ZFRCE ZB Analyst|ZFRCE ZB M1|ZFRCELOC1|ZFRCE US HCM|Recruiting Candidate|2025/12/30|Employee|100010025072030|ORA_CANDIDATE||WASG_Offer_CAN59092387082|HRC_SQLLOADER|ZFRCE_USA_GAMMA_2TSCSA_ZBEN|SSID_CAN59092387082ZBEN-1810-OFFER-MAN||||WT_Offer_CAN59092387082|||
MERGE|Contract|300100171103390|2025/09/11|4712/12/31|WT_Offer_CAN59092387082|FIXED_CONTRACT|CON_Offer_CAN59092387082|HRC_SQLLOADER|2|Y||
METADATA|AssignmentExtraInfo|EFF_CATEGORY_CODE|FLEX:PER_ASSIGNMENT_EIT_EFF|hdl1(PER_ASSIGNMENT_EIT_EFF=HDL1)|hdl1Num(PER_ASSIGNMENT_EIT_EFF=HDL1)|ActionOccurrenceId|AeiInformationCategory|AssignmentExtraInfoId|AssignmentId(SourceSystemId)|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|GUID|InformationType|LegislationCode|SourceSystemId|SourceSystemOwner|AssignmentNumber
MERGE|AssignmentExtraInfo|PER_ASG_EIT|HDL1|EFFText224|34224||HDL1||WASG_Offer_CAN59092387082|4712/12/31|Y|1|2025/09/11||HDL1||AEFF_Offer_CAN59092387082|HRC_SQLLOADER|
METADATA|WorkingHourPattern|Object|ObjectId(SourceSystemId)|EffectiveStartDate|WorkDayDefinitionCode|WorkingHoursType|WorkShiftType|WedHours|TueHours|ThuHours|SunHours|MonHours|FriHours|SatHours|SourceSystemId|SourceSystemOwner
MERGE|WorkingHourPattern|ASSIGNMENT|WASG_Offer_CAN59092387082|2025/09/11|TIME ENTRY STOP DAY|ORA_WORK_WEEK|ORA_ELAPSED|8|8|8|8|8|8|8|WHP_Offer_CAN59092387082|HRC_SQLLOADER

This enhancement enables organizations to load a more complete set of employment data during the offer stage, reducing manual entry and streamlining the hiring process. It ensures consistency between HDL-loaded data and the Redwood experience, improving data accuracy and onboarding efficiency.

Steps to enable and configure

Assignment EFF, Work Relationship, and Weekly Working Hours sections are hidden by default in the Offer UI. You need to enable them in Business Rules

Here are the steps to enable the above sections:

  1. Go to the Offers page.
  2. Click Edit Page in Visual Builder Studio from the Settings and Actions menu.
  3. Select a project and ensure you're in Express mode in Visual Builder Studio.
  4. Go to Hiring > Job Requisitions using the Navigation Tabs.
  5. Select Visible for the Assignment EFF, Work Relationship, and Weekly Working Hours sections.
  6. Publish your changes.

Key resources

For more information, refer to these resources on the Oracle Help Center: