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

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
27 26-Nov-2021 10:22 51 KB kparrott to previous
26 26-Nov-2021 10:22 50 KB jmyers to previous | to last
25 26-Nov-2021 10:22 53 KB jmyers to previous | to last
24 26-Nov-2021 10:22 53 KB jmyers to previous | to last
23 26-Nov-2021 10:22 52 KB jmyers to previous | to last
22 26-Nov-2021 10:22 50 KB jmyers to previous | to last
21 26-Nov-2021 10:22 50 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 494 changed 56 lines
| 356101 | Pay Number (PPH) | |
| 356102 | Tax Weeks (PPH) | |
| 356103 | Pay Issue Date (PPH) | |
| 356104 | PPP Start Date (PPH) | |
| 356105 | First Pay in Issue Month | |
| 356106 | Last Pay in Issue Month | |
| 356200 | Pay Line ID (PPL) | |
| 356201 | Pay Line Status (PPL) | |
| 356202 | PL State Date (PPL) | |
| 356203 | PL End Date (PPL) | |
| 356204 | Time Entered (PPL) | |
| 356205 | Time Basis (PPL) (35) | |
| 356206 | PL Source (PPL) | |
| 356207 | Retro Pay (PPL) | |
| 356208 | First Date of PPL Date | |
| 356209 | Last Date of PPL Date | |
| 356210 | Affected Month (PPL) | |
| 356220 | Nbr Pays in PPL Month | |
| 356300 | PPLD_ID | |
| 356301 | PL Detail status (PPLD) | |
| 356302 | Wage Rate (PPLD) | |
| 356303 | Wage Rate O/R (PPLD) | |
| 356304 | Rate Basis (PPLD) | |
| 356305 | Rate Basis O/R (PPLD) | |
| 356306 | Amount (PPLD) | |
| 356307 | Amount O/R (PPLD) | |
| 356308 | Amount Processed (PPLD) | |
| 356309 | Retro Amount (PPLD) | |
| 356310 | PPC_ID (PPLD) | |
| 356312 | PPC in Element-1 (Internal) | |
| 356313 | PPC in Element-2 (Internal) | |
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface Program. This PL/SQL table holds up to 5 columns information. Each column has a description and an amount. Each amount can be totaled. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose, e.g. [UPROEF] uses this table to hold up to 52 Pay Periods in Desc1 column and the associated hours in Amount 1 column and earnings in Amount 2 column for each pay period. This PL/SQL table is not used for [UEEF]. This variable name returns the internal PL/SQL Table Column 1 description
| 358002 | Internal Table Desc2 | |Same as Internal Table Desc 1. This variable name returns Column 2 description
| 358003 | Internal Table Desc3 | |Same as Internal Table Desc 1. This variable name returns Column 3 description
| 358004 | Internal Table Desc4 | |Same as Internal Table Desc 1. This variable name returns Column 4 description
| 358005 | Internal Table Desc5 | |Same as Internal Table Desc 1. This variable name returns Column 5 description
| 358011 | Internal Table Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Amount
| 358012 | Internal Table Amt 2 | |Same as Internal Table Desc 1. This variable name returns Column 2 Amount.
| 358013 | Internal Table Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Amount
| 358014 | Internal Table Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Amount
| 358015 | Internal Table Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Amount
| 358021 | Internal Total for Amt 1 | |Same as Internal Table Desc 1. This variable name returns Column 1 Total Amount.
| 358022 | Internal Total for Amt 2 | |Same as Internal Table Desc 1. This variable name returns Column 2 Total Amount.
| 358023 | Internal Total for Amt 3 | |Same as Internal Table Desc 1. This variable name returns Column 3 Total Amount
| 358024 | Internal Total for Amt 4 | |Same as Internal Table Desc 1. This variable name returns Column 4 Total Amount
| 358025 | Internal Total for Amt 5 | |Same as Internal Table Desc 1. This variable name returns Column 5 Total Amount
| 358030 | UDF (EID) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|User must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field
| 358031 | UDF (EEM) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|User must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field
| 358032 | UDF (EASD) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|User must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field
| 358033 | UDF (BPN) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|User must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section. On [IDIF] screen, user must enter the [IMUF] UDF name in the Constant Value field
| 358034 | UDF (EPS) (35) | |
| 358035 | UDF (DED) (35) | |
| 358036 | UDF (DDD) (35) | |
| 358037 | UDF (DLN) (35) | |
| 358038 | UDF (DUD) (35) | |
| 358039 | UDF (DGD) (35) | |
| 358001 | Internal Table Desc1 | |A temporary internal PL/SQL table is defined for the Generic Interface Program. This PL/SQL table holds up to 5 columns information. Each column has a description and an amount. Each amount can be totaled. Depending on each business requirement, the program will load information into this PL/SQL table for internal purpose, e.g. [UPROEF] uses this table to hold up to 52 Pay Periods in Desc1 column and the associated hours in Amount 1 column and earnings in Amount 2 column for each pay period.\\ \\This PL/SQL table is not used for [UEEF].\\ \\This variable name returns the internal PL/SQL Table Column 1 description
| 358002 | Internal Table Desc2 | |Same as Internal Table Desc 1.\\This variable name returns Column 2 description
| 358003 | Internal Table Desc3 | |Same as Internal Table Desc 1.\\This variable name returns Column 3 description
| 358004 | Internal Table Desc4 | |Same as Internal Table Desc 1.\\This variable name returns Column 4 description
| 358005 | Internal Table Desc5 | |Same as Internal Table Desc 1.\\This variable name returns Column 5 description
| 358011 | Internal Table Amt 1 | |Same as Internal Table Desc 1.\\This variable name returns Column 1 Amount
| 358012 | Internal Table Amt 2 | |Same as Internal Table Desc 1.\\This variable name returns Column 2 Amount.
| 358013 | Internal Table Amt 3 | |Same as Internal Table Desc 1.\\This variable name returns Column 3 Amount
| 358014 | Internal Table Amt 4 | |Same as Internal Table Desc 1.\\This variable name returns Column 4 Amount
| 358015 | Internal Table Amt 5 | |Same as Internal Table Desc 1.\\This variable name returns Column 5 Amount
| 358021 | Internal Total for Amt 1 | |Same as Internal Table Desc 1.\\This variable name returns Column 1 Total Amount.
| 358022 | Internal Total for Amt 2 | |Same as Internal Table Desc 1.\\This variable name returns Column 2 Total Amount.
| 358023 | Internal Total for Amt 3 | |Same as Internal Table Desc 1.\\This variable name returns Column 3 Total Amount
| 358024 | Internal Total for Amt 4 | |Same as Internal Table Desc 1.\\This variable name returns Column 4 Total Amount
| 358025 | Internal Total for Amt 5 | |Same as Internal Table Desc 1.\\This variable name returns Column 5 Total Amount
| 358030 | UDF (EID) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_IDENTITIES] (EID)|User must define the UDF on [IMUF] screen for [P2K_HR_IDENTITIES] and then enter the value on [IEID] screen. On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.\\If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358031 | UDF (EEM) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_EMPLOYMENTS] (EEM)|User must define the UDF on [IMUF] screen for [P2K_HR_EMPLOYMENTS] and then enter the value on [IEEI] screen.\\On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field.\\If this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358032 | UDF (EASD) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_HR_ASSIGNMENT_DETAILS] (EASD)|User must define the UDF on [IMUF] screen for [P2K_HR_ASSIGNMENT_DETAILS] and then enter the value on [IEAS] screen Effective date sections.\\On [IDIF] screen, you must enter the [IMUF] UDF name in the Constant Value field\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358033 | UDF (BPN) (35) | Indicates this Rec#/Fld# contains a UDF value from [P2K_BE_PLAN_DEFINITIONS] (BPN)|User must define the UDF on [IMUF] screen for [P2K_BE_PLAN_DEFINITIONS] and then enter the value on [IBPN] screen section.\\On [IDIF] screen, user must enter the [IMUF] UDF name in the Constant Value field.\\- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen.
| 358034 | UDF (EPS) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_HR_PERSONALS (EPS)
- user must define the UDF on IMUF screen for P2K_HR_PERSONALS and then enter the value on IEPI screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358035 | UDF (DED) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_ENTITY_DETAILS (DED)
- user must define the UDF on IMUF screen for P2K_CM_ENTITY_DETAILS and then enter the value on IDEN screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358036 | UDF (DDD) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_DEPARTMENT_DETAILS (DDD)
- user must define the UDF on IMUF screen for P2K_CM_DEPARTMENT_DETAILS and then enter the value on IDDP screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358037 | UDF (DLN) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_LOCATIONS (DLN)
- user must define the UDF on IMUF screen for P2K_CM_LOCATIONS and then enter the value on IDLN screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358038 | UDF (DUD) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_UNIT_DETAILS (DUD)
- user must define the UDF on IMUF screen for P2K_CM_UNIT_DETAILS and then enter the value on IDUN screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen
| 358039 | UDF (DGD) (35) | |- indicates this Rec#/Fld# contains a UDF value from P2K_CM_GROUP_DETAILS (DGD)
- user must define the UDF on IMUF screen for P2K_CM_GROUP_DETAILS and then enter the value on IDGR screen
- on IDIF screen, user must enter the IMUF UDF name in the Constant Value field
- if this Rec#/Fld# is defined with Record Type ’92-Update Record’, in non-Trial mode, this UDF will be Inserted or Updated, the user does not need to set up UDF on IMUF screen