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

Mass upload to remove absence reason to null using HDL

Received Response
61
Views
7
Comments

Hi,

Sick leave absence reason updated incorrectly and we need to remove the reason and make it null for the absence applied.

Note: Sick leave reason is not mandatory for this type.

Provided below HDL for sample used and it's not working as expected. Any experts please suggest how to remove the updated reason and make it as null through HDL.

METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceType|AbsenceReason|AbsenceStatus|ApprovalStatus|StartDatetime|StartDateDuration|EndDatetime|EndDateDuration|StartDate|StartTime|EndDate|EndTime|Duration

MERGE|PersonAbsenceEntry|LadbrokesBetting&GamingLimited|1108192|Sicknesshours|#NULL|SUBMITTED|APPROVED||3|||2023/02/09|00:00|2023/02/11|23:59|3

or

METADATA|PersonAbsenceEntry|Employer|PersonNumber|PerAbsenceEntryId|AbsenceType|AbsenceReason|StartDate|StartTime|EndDate|EndTime|Duration|AbsenceStatus|ApprovalStatus

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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