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 deciphered

Example: #

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


Notes#

Click to create a new notes page