UPG_GPCEDEL_AET

(SQL Table)
Index Back

GP Country Extensions-Upgrade

Main State Record for UPG_GPCEDEL Application Engine Program (which is used in conjunction with GP Country Extension Upgrades) See UPG_GPCEDEL Application Engine for additional details.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 UPG_GPCESECTION Character(3) VARCHAR2(3) NOT NULL This field is only used in conjunction with GP Country Extension Upgrades. It is a field on the UPG_GPCEDEL_AET record with is the main state record for UPG_GPCEDEL Application Engine Program (which is used in conjunction with GP Country Extension Upgrades). This field will store the value of the section to be processed. See UPG_GPCEDEL Application Engine for additional details.
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
6 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
7 INSTALLED_PAY_GBL Character(1) VARCHAR2(1) NOT NULL Global Payroll Core
8 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging
9 GPDBNAME Character(8) VARCHAR2(8) NOT NULL Database name where Package is created.
10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
11 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
12 COUNTER_GLOB Number(19,3) DECIMAL(18,3) NOT NULL Counter
13 GP_PKG_UPGRADE Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
14 GP_PKG_UPG Character(1) VARCHAR2(1) NOT NULL Utility field for packager
15 GP_PKG_UPG_OPTN Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
16 COMMENTS Long Character CLOB Comment