Absence GET_ENTITLEMENTS by band name
Summary:
We have a requirement to view entitlements for a Company Sickness Plan by band name.
Has anyone been able to use the GET_ENTITLEMENTS in Absence FF by band name instead of percentage?
Content (please ensure you mask any confidential information):
Company Sickness Plan has the following bands:
- Waiting Days - 3 days - 0%
- Full Pay - 4 weeks - 100%
- Half Pay - 4 weeks - 50%
So I added the code to the band entitlement formula as per this note:
Get Absence Balance in worksheet — Cloud Customer Connect
roll_back_reference_date = ADD_MONTHS(IV_START_DATE,-12)l_used_entitlements = GET_ENTITLEMENTS('CSP with Band Formula','Waiting Days',
0