Leave Accrual Information#
Functionality:#
This function retrieves information as seen on IALA, for an employee's leave accrual. Leave Accruals must be active.Parameters:#
| EEM_ID | The actual ID for the employment record of the employee you are getting data for |
| POLICY_TYPE | The leave policy type you are looking for |
| WHAT | Any field on the P2K_AT_LEAVE_ACCRUALS table AC-Axxxx where Axxxx is an attendance component code |
| AS_OF | Optional. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used. |
Returns: #
Varchar2 (regardless of the type of data actually requested)Errors: #
If any errors occur, a zero value will be returned. *BAD LEAVE TYPE - When the Leave Type provided is invalid *BAD WHAT|| - When the WHAT parameter cannot be decipheredExample: #
P2K_PU.ALA(~,'SICK','ENTITLEMENT_GIVEN_DATE')
Will return the Entitlement Given data for the employee's SICK type plan
P2K_PU.VALB(~,'VACATION','AC-A740')
Will return the Payout Termination Time Owing (Attendance Component A740) for the employee's VACATION type plan
