GET_ENTITLEMENTS
This formula function returns the number of plan entitlements of a particular band or payment factor consumed by absence entries in a period.
Mandatory Contexts
- PERSON_ID
- LEGISLATIVE_DATA_GROUP_ID
Parameters
Parameter name | Data Type | Description |
---|---|---|
p_pl_name | Character | The name of the qualification plan for which the entitlement usage needs to be fetched |
p_band_name | Character | The entitlement payment band name for within the qualification plan |
p_band_percentage | Number | Instead of the entitlement band name, the payment percentage can also be passed. Payment factor takes precedence over band name. |
p_start_date | Date | Start of the period for which entitlement usage data needs to be fetched |
p_end_date | Date | End of the period for which entitlement usage data needs to be fetched |
Data Returned
The entitlement units against the band or pay factor consumed during the specified period.