1. HCM Data Loading Business Objects
  2. Examples of Loading Absence Entry

Examples of Loading Absence Entry

These example AbsenceEntry.dat files show how to load absence entries using HCM Data Loader for:

  • A time based absence entry

  • An elapsed absence entry

  • A maternity absence entry

  • An advanced absence entry

Loading Absence Entry

Example 1: Time Based Absence Entry

This example uses user keys to create an absence entry for two days sick leave.

METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceType|AbsenceStatus|ApprovalStatus|StartDate|StartTime|EndDate|EndTime|Comments|AbsenceReason
MERGE|PersonAbsenceEntry|Vision Corporation|300100005197277|SICK_LEAVE|SUBMITTED|APPROVED|2018/09/24|8:30|2018/09/25|17:00|SICK LEAVE|SICK_REASON

Example 2: Elapsed Absence Entry

This example uses user keys to create an absence entry for two days sick leave.

METADATA|PersonAbsenceEntry|PersonNumber|AbsenceType|AbsenceStatus|ApprovalStatus|StartDate|StartTime|EndDate|EndTime|Comments|StartDateDuration|EndDateDuration|AbsenceReason
MERGE|PersonAbsenceEntry|40010|10026712115|BAT_ABS_TL_Sick|SUBMITTED|APPROVED|2018/01/22||2018/01/23||Sick Comments|8|8

Loading Person Maternity Absence Entry

This example uses source keys to create an absence entry for maternity leave.

METADATA|PersonAbsenceEntry|SourceSystemOwner|SourceSystemId|Employer|PersonId(SourceSystemId)|AbsenceType|AbsenceStatus|ApprovalStatus|StartDate|StartTime|EndDate|EndTime
MERGE|PersonAbsenceEntry|VISION|AbsMaternity_HDL022|Vision Corporation|HDL022|Maternity Type|SUBMITTED|APPROVED|2018/01/26|08:00|2018/02/14|17:00
METADATA|PersonMaternityAbsenceEntry|SourceSystemOwner|SourceSystemId|PerAbsenceEntryId(SourceSystemId)|PlannedStartDate|PlannedReturnDate|LeaveDuration|IntendToWork|ExpectedDateOfChildBirth|ExpectedEndDate|ActualStartDate|ActualReturnDate|ActualDuration|ActualChildBirthDate|OpenEndedFlag
MERGE|PersonMaternityAbsenceEntry|VISION|AbsMaternityDet_HDL022|AbsMaternity_HDL022|2018/01/26|2018/02/14|||2018/01/26|2018/02/14|2018/01/25|2018/02/14||2018/01/27|

Loading Person Absence Entry Detail

This example uses source keys to create an advanced absence entry.

METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceType|AbsenceStatus|ApprovalStatus|StartDate|StartTime|EndDate|EndTime|Comments|SourceSystemId|SourceSystemOwner|AbsenceReason
MERGE|PersonAbsenceEntry|Vision Corporation|955160008192206|#SK_QUAL_HRS|SUBMITTED|APPROVED|2018/11/06|21:00|2018/11/07|05:00|Adv night shift|1SCH_SEMP_001111121|VISION|
METADATA|PersonAbsenceEntryDetail|Employer|PersonNumber|AbsenceType|PerAbsEntryDtlId|PerAbsenceEntryId(SourceSystemId)|AbsenceDate|StartTime|EndDate|EndTime|RowSeq|AbsenceStartDate|AbsenceStartTime|SourceSystemId|SourceSystemOwner
MERGE|PersonAbsenceEntryDetail|Vision Corporation|955160008192206|#SK_QUAL_HRS||1SCH_SEMP_001111121|2018/11/06|21:00|||1|2018/11/06|21:00|HDLERDTL05011121|VISION