This page (revision-38) was last changed on 12-Jan-2022 16:19 by Kevin Higgs

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

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
38 12-Jan-2022 16:19 4 KB Kevin Higgs to previous
37 26-Nov-2021 10:22 4 KB khiggs to previous | to last
36 26-Nov-2021 10:22 4 KB khiggs to previous | to last
35 26-Nov-2021 10:22 4 KB khiggs to previous | to last
34 26-Nov-2021 10:22 3 KB khiggs to previous | to last
33 26-Nov-2021 10:22 3 KB rforbes to previous | to last
32 26-Nov-2021 10:22 3 KB rforbes to previous | to last P2K_PU.ISNUMBER ==> P2K_PU.IS_NUMERIC
31 26-Nov-2021 10:22 3 KB rforbes to previous | to last
30 26-Nov-2021 10:22 2 KB rforbes to previous | to last
29 26-Nov-2021 10:22 2 KB rforbes to previous | to last
28 26-Nov-2021 10:22 2 KB rforbes to previous | to last
27 26-Nov-2021 10:22 2 KB rforbes to previous | to last
26 26-Nov-2021 10:22 2 KB rforbes to previous | to last
25 26-Nov-2021 10:22 2 KB rforbes to previous | to last
24 26-Nov-2021 10:22 2 KB jmyers to previous | to last
23 26-Nov-2021 10:22 2 KB rforbes to previous | to last
22 26-Nov-2021 10:22 2 KB rforbes to previous | to last
21 26-Nov-2021 10:22 2 KB rforbes to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 37 changed 4 lines
|[GET_PPRU|P2K_PU.GET_PPRU]|Captures Pay Header ID [PPH_ID] for an employee, given a [PERSON_CODE], a pay number [PAY_NUMBER] and batch id [PBT_ID]
|[TOTAL_FTE|P2K_PU.TOTAL_FTE]|Captures Pay Header ID [PPH_ID] for an employee, given a [PERSON_CODE], a pay number [PAY_NUMBER] and batch id [PBT_ID]
|[AAL_TODATE|P2K_PU.AAL_TODATE]|Captures Pay Header ID [PPH_ID] for an employee, given a [PERSON_CODE], a pay number [PAY_NUMBER] and batch id [PBT_ID]
|[ALA_LAST|P2K_PU.ALA_LAST]|Captures Pay Header ID [PPH_ID] for an employee, given a [PERSON_CODE], a pay number [PAY_NUMBER] and batch id [PBT_ID]
|[GET_PPRU|P2K_PU.GET_PPRU]|Given an employment ID [EEM_ID], a state id [DSP_ID] and an as of date, capture US Pay Rule ID [IPRLU]
|[TOTAL_FTE|P2K_PU.TOTAL_FTE]|Totals the FTE across active assignments given an employment ID [EEM_ID] and an as of date
|[AAL_TODATE|P2K_PU.AAL_TODATE]|Given an employment ID [EEM_ID], a leave type [ALPT_ID] an Attendance code [AC_CODE] and a date range, captures total amount of processed leave lines for the specified range
|[ALA_LAST|P2K_PU.ALA_LAST]|Given an employment ID [EEM_ID], a leave type [ALPT_ID] an Attendance code [AC_CODE] and an as of date, capture the value of an AC_CODE from the last Accrual Record produced in the month.