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: #
NumericErrors: #
- 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
