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
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>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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