# |
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(10) |
VARCHAR2(10) 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
|