| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GPGB_ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
|
| 3 |
PIN_USER_FLD1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 4 |
PIN_USER_FLD2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 5 |
PIN_USER_FLD3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 7 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 8 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
|
| 9 |
RECIPIENT_TAG |
Number(3,0) |
SMALLINT NOT NULL |
Used to identify recipients for E/D, PI
|
| 10 |
GPGB_CO_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Used to pass a number for each type of order to the GP process - for example, if there are three DEOs, they will be numbered from 1 - 3
|