PersonEntitlementDetail.dat not able to adjust balance for multiple entitlements.
Summary:
We have multiple entitlements configured for Sick Leave plan of Qualification Type.
100% for 15 days entitlements
50% for 30 Days entitlements
Due to some reasons some employee's entitlements have to be adjusted, therefore we were using PersonEntitlementDetail.dat to do it.
METADATA | PersonEntitlementDetail | SourceSystemOwner | SourceSystemId | PersonNumber | PlanName | WorkTermsNumber | ProcdDate | StartDate | EndDate | PayFactor | Value |
|---|---|---|---|---|---|---|---|---|---|---|---|
MERGE | PersonEntitlementDetail | AB_HDL | ABS18309720261013 | 18345678 | AB Sick Leave | ET18345678-2 | 2026/10/01 | 2026/01/01 | 2026/12/31 | 100 | -15 |
MERGE | PersonEntitlementDetail | AB_HDL | ABS18309720261001 | 18345678 | AB Sick Leave | ET18345678-2 | 2026/10/01 | 2026/01/01 | 2026/12/31 | 50 | -18 |
When we try to load the data like above mentioned, we faced an error.
Then we tried to load each record separately, it was loading for their respective Payfactor, and any new changes removes the changes in previous load payfactor value.