This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggs

This page was created on 26-Nov-2021 10:22 by khiggs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 2 KB khiggs to previous
3 26-Nov-2021 10:22 2 KB khiggs to previous | to last
2 26-Nov-2021 10:22 2 KB khiggs to previous | to last
1 26-Nov-2021 10:22 2 KB khiggs to last

Page References

Incoming links Outgoing links
P 2 K_PU.AAL_TODATE
P2K_PU.AAL_TODATE

Version management

Difference between version and

At line 4 changed one line
The purpose of this function is to Capture any leave lines that have been processed within the date range defined.
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.
At line 9 removed 4 lines
|EEM_ID | ''Required''. The [EEM_ID] from [P2K_HR_EMPLOYMENTS] belonging to the employee in which FTE is to be gathered
|AS_OF_DATE | ''Required'' The as-of date in which the FTE is to be totaled. If not provided, the current date is used.
At line 18 removed 2 lines
|ACCRUALS |''Optional'' If this preference is set to "Y" than only the leave lines as seen on the [IALA] 'previous evaluation" tab will be returned
|YEAR_TO_DATE |''Optional'' If this is set to "Y" then the start and end dates will be based on the IALA accrual begin date and accrual end date
At line 22 removed one line
At line 27 changed one line
* If any error occurs during data retrieval, 0 is returned
* When No Data is found than 0 will be returned
* When there is an undetermined exception than -1 will be returned
At line 31 changed one line
{{P2K_PU.TOTAL_FTE(~)}}
FUNCTION AAL_TODATE (~,'VACATION','A290','01-Jan-2017','31-Jan-2017')
At line 33 changed one line
will get the TOTAL_FTE for the passed EEM_ID as of the system date.
Will return leave lines values linked to the leave type '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'
At line 36 changed one line
{{P2K_PU.TOTAL_FTE(~,'01-Jan-2017')}}
FUNCTION AAL_TODATE (~,'VACATION')
At line 38 changed one line
will get the TOTAL_FTE for the passed EEM_ID as of '01-Jan-2017'.
Will return leave lines values linked to the leave type '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
At line 34 added 5 lines
FUNCTION AAL_TODATE (~,'SICK','A290','01-Dec-2017')
Will return leave lines values linked to the leave type '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
At line 40 added 5 lines
* 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 Time Codes will be picked up
* Only Leave lines with an accrual status not in 3-In Payroll, 1-Requested or 2-Requested Processed will be picked up
At line 42 removed 3 lines
* If an AS_OF_DATE is not provided, then the system date will be used.
* The [DES_ID] defined on the [P2K_HR_ASSIGNMENT_DETAILS] will be used to determine if the assignment is active.
* Any [STATUS_CODE] defined on the [P2K_CM_EMPLOYMENT_STATUSES] table with a [STATUS_TYPE] of 'Active' or 'Leave' will be considered 'ACTIVE' by the funciton.
This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggsTop