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 the values from the [IALA] "Previous Evaluations" tab that have been processed within the date range specified.
The purpose of this function is to Capture any leave lines that have been processed within the date range defined.
At line 9 added 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 added 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 added one line
At line 20 changed 2 lines
* When No Data is found than 0 will be returned
* When there is an undetermined exception than -1 will be returned
* If any error occurs during data retrieval, 0 is returned
At line 31 added one line
{{P2K_PU.TOTAL_FTE(~)}}
At line 26 changed one line
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'
will get the TOTAL_FTE for the passed EEM_ID as of the system date.
At line 28 removed one line
*AAL_TODATE (~,'VACATION','A290','01-Jan-2017','31-Jan-2017')
At line 36 added one line
{{P2K_PU.TOTAL_FTE(~,'01-Jan-2017')}}
At line 31 changed one line
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
will get the TOTAL_FTE for the passed EEM_ID as of '01-Jan-2017'.
At line 33 removed 6 lines
*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')
At line 40 removed 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 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
At line 42 added 6 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.
----
![Notes|Edit:Internal.GET_EID]
[{InsertPage page='Internal.P2K_PU.DES_TYPE' default='Click to create a new notes page'}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggsTop