You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Sample file for HDL ScheduleAssignment.dat to load Calendar Event Category Exceptions

    edited Feb 26, 2020 2:31PM in Workforce Management 7 comments

    Summary

    Sample file required to load Calendar Event Exceptions for Employee Assignments

    Content

    I have downloaded the ScheduleAssignment.dat from below

    Person management -> Data Exchange -> View Business Object -> Schedule Assignment -> Schedule Exception Component

    File format below

     

    COMMENT Data for Business Object: ScheduleAssignment Version: V2 Created on: 09-10-2019 
    METADATA|ScheduleAssignment|ScheduleAssignmentId|ScheduleId|ScheduleName|StartDate|EndDate|ResourceId|ResourceType|PrimaryFlag|DepartmentName|LocationSetCode|InternalLocationCode|PositionCode|BusinessUnitName|JobSetCode|JobCode|LegalEmployerName|EnterpriseName|AssignmentNumber|WorkTermsAssignmentNumber|StartPatternDtlId|SourceSystemOwner|SourceSystemId|GUID|ResourceLocationId|ResourceJobId|ResourcePositionId|ResourceDepartmentId|ResourceAssignmentId|ResourceWorkTermsId|ResourceLegalEmployerId|ResourceEnterpriseId|SourceRefTableName=<source-table-name>|SourceRef001=<source-column-001>|SourceRef002=<source-column-002>|SourceRef003=<source-column-003>|SourceRef004=<source-column-004>|SourceRef005=<source-column-005>|SourceRef006=<source-column-006>|SourceRef007=<source-column-007>|SourceRef008=<source-column-008>|SourceRef009=<source-column-009>|SourceRef010=<source-column-010>

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!