Get Employee AAL_TODATE#

Functionality:#

The purpose of this function is to capture the values from the IALA "Previous Evaluations" tab that have been processed within the date range specified.

Parameters:#

EEM_ID	Required.The EEM_ID from P2K_HR_EMPLOYMENTS belonging to the employee to be processed
LEAVE_TYPE	Required.The LEAVE_TYPE_CODE defined on P2K_AT_LEAVE_POLICY_TYPES in which leave lines are to be captured
AC_CODE	Required.The AC_CODE as defined on P2K_AT_ATTENDANCE_COMPONENTS (ie, A290,A300,etc.)
START	Optional The earliest start date from the P2K_AT_LEAVE_LINESto be included. (Sysdate will be used if left blank)
END	Optional The latest end date from the P2K_AT_LEAVE_LINES to be included. (Sysdate will be used if left blank)

Returns: #

Numeric

Errors: #

• When No Data is found than 0 will be returned
• When there is an undetermined exception than -1 will be returned

Example: #

Using the EEM_ID as the parameter, this will return leave lines values linked to the LEAVE_TYPE_CODE 'VACATION' and the AC_CODE A290 that can be seen on the IALA leave history tab that have a START_DATE that falls between '01-Jan-2017 and 31-Jan-2017'

• AAL_TODATE (~,'VACATION','A290','01-Jan-2017','31-Jan-2017')

Using the EEM_ID as the parameter, this will return leave lines values linked to the LEAVE_TYPE_CODE 'VACATION' and the AC_CODE A300 that can be seen on the IALA leave history tab that have a START_DATE that falls on the current system date

• AAL_TODATE (~,'VACATION')

Using the EEM_ID as the parameter, this will return leave lines values linked to the LEAVE_TYPE_CODE 'SICK' and the AC_CODE A300 that can be seen on the IALA leave history tab that have a START_DATE that falls between '01-DEC-2017' and the current system date

• AAL_TODATE (~,'SICK','A290','01-Dec-2017')

Notes#

• The EEM_ID will be used to check leave lines details for the value of the specified AC code for the leave type as of the listed date.
• This will be to return the accumulated values as seen in the Previous Evaluations tab of IALA.
• This should not be used for capturing AC codes that report to_date values (like A700) as they will be summarized and incorrect
• Only leave lines without a TIME_CODE will be picked up
• Only Leave lines with an accrual status not with an ACCRUAL_TYPE of 3-In Payroll, 1-Requested or 2-Requested Processed will be picked up