This page (revision-39) was last changed on 09-Jun-2022 17:33 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
39 09-Jun-2022 17:33 4 KB Kevin Higgs to previous
38 12-Jan-2022 16:18 4 KB Kevin Higgs to previous | to last
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
P 2 K_PU
P2K_PU

Version management

Difference between version and

At line 5 added 6 lines
|[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
|[ACCUM_ADD|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_INIT|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_VALUE|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[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.
At line 12 added one line
|[BBL|P2K_PU.BBL]|Retrieves benefit line information from an employee's pay
At line 8 changed 2 lines
|[DES_TYPE|P2K_PU.DES_TYPE]|Provides the [EMPLOYMENT_TYPE] for an Employment [STATUS_CODE]
|[EASD|P2K_PU.EASD]|Retrieve assignment detail information for an assignment, as seen on [IEAS]
|[DES_TYPE|P2K_PU.DES_TYPE]|Provides the [STATUS_TYPE] for an Employment [STATUS_CODE]
At line 17 added one line
|[EASD|P2K_PU.EASD]|Retrieve assignment detail information for an assignment, as seen on [IEAS]
At line 15 changed one line
|[PSN|P2K_PU.PSN]|Retrieve sundry line information, as seen on [IPSN]
|[EPS|P2K_PU.EPS] |Retrieve PERSONALS information
|[FILE_NAME|P2K_PU.FILE_NAME]|Used to transform a file name parameter using replacement phrases
|[FIRST_MGR|P2K_PU.FIRST_MGR]|Get Identity ID for derived first manager
|[GC|P2K_PU.GC]|Retrieve column value from a table, given the table ID
|[GET_BBR|P2K_PU.GET_BBR]|Captures Recipient ID [BBR_ID] for a contact, using a [PLAN_CODE] and an as of date
|[GET_CHILD_ID|P2K_PU.GET_CHILD_ID]|Determines the ID of date-sensitive child record|
|[GET_EAS|P2K_PU.GET_EAS]|Determines the [EAS_ID] for an employee, given an [EEM_ID] and an [ASSIGNMENT_CODE]
|[GET_EASD|P2K_PU.GET_EASD]|Determines the primary assignment [EASD_ID] for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE]
|[GET_EEM|P2K_PU.GET_EEM]|Determines the [EEM_ID] for the first active employment for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE] or [EXTERNAL_RETIREMENT_ID]
|[GET_EEM_ASOF|GET_EEM_ASOF]|Determine the [EEM_ID] for the employee given [PERSON_CODE],[ASSIGNMENT_TYPE] and an as of date.
|[GET_EID|P2K_PU.GET_EID]|Determines the [EID_ID] for an employee, given either [PERSON_CODE] or [GOVERNMENT_CODE] or [EXTERNAL_RETIREMENT_ID]
|[GET_PPH|P2K_PU.GET_PPH]|Captures Pay Header ID [PPH_ID] for an employee, given a [PERSON_CODE], a pay number [PAY_NUMBER] and batch id [PBT_ID]
|[GET_PPP|P2K_PU.GET_PPP]|Determines the ID of the pay period record for an employee
|[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]
|[IS_DATE|P2K_PU.IS_DATE]|Verifies if the string contains a valid formatted date
|[IS_NUMERIC|P2K_PU.IS_NUMERIC]|Verifies if the string contains only numeric values
At line 18 changed one line
|[TCC|P2K_PU.TCC]|Retrieves CLOCK CARD information for an employee, as seen on [ITTC]
|[PPRU_MISC|P2K_PU.PPRU_MISC]|Retrieves Misc Tax parameter information for an employee, as seen on [IPRLUS]
|[PSN|P2K_PU.PSN]|Retrieve sundry line information, as seen on [IPSN]
At line 20 changed one line
|[VALB|P2K_PU.VALB]|Retrieves attendance bank information (official and processed only) for an employee, as seen on [VALB]
|[TCC|P2K_PU.TCC]|Retrieves CLOCK CARD information for an employee, as seen on [ITTC]
|[TOTAL_FTE|P2K_PU.TOTAL_FTE]|Totals the FTE across active assignments given an employment ID [EEM_ID] and an as of date
At line 22 changed 10 lines
|[FIRST_MGR|P2K_PU.FIRST_MGR]|Get Identity ID for derived first manager
|[GC|P2K_PU.GC]|Retrieve column value from a table, given the table ID
|[GET_EID|P2K_PU.GET_EID]|Determines the [EID_ID] for an employee, given either [PERSON_CODE] or [GOVERNMENT_CODE]
|[GET_EEM|P2K_PU.GET_EEM]|Determines the [EEM_ID] for the first active employment for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE] or [EXTERNAL_RETIREMENT_ID]
|[GET_EASD|P2K_PU.GET_EASD]|Determines the primary assignment [EASD_ID] for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE]
|[ACCUM_INIT|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_ADD|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_VALUE|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[FILE_NAME|P2K_PU.FILE_NAME]|Used to transform a file name parameter using replacement phrases
|[ISNUMBER|P2K_PU.ISNUMBER]|Verifies if the string contains only numeric values
|[VALB|P2K_PU.VALB]|Retrieves attendance bank information (official and processed only) for an employee, as seen on [VALB]
This page (revision-39) was last changed on 09-Jun-2022 17:33 by Kevin HiggsTop