GP_PKG_ELEM_D(SQL Table) |
Index Back |
|---|---|
Package Elements-DerivedGlobal Payroll derived record for Package Elements |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | 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) |
| 3 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 4 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 5 | PIN_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Element Owner
C=Customer Maintained M=PS Delivered/Customer Modified N=PS Delivered / Not Maintained P=PS Delivered / Maintained S=PS Delivered/Maintained/Secure |
| 6 | GP_PKG_INCL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Field used for element packaging
F=Focus Element Only M=Focus Element + Members |
| 7 | GP_PKG_UPG_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Field used for element packaging
D=Delete I=Informational Only U=Upgrade |
| 8 | GP_PKG_LEVEL | Number(5,0) | INTEGER NOT NULL | Field used for element packaging |
| 9 | GP_PKG_BRANCH | Number(5,0) | INTEGER NOT NULL | Field used for element packaging |
| 10 | PROCESSED_IND | Character(1) | VARCHAR2(1) NOT NULL |
Processed Indicator
Y/N Table Edit Default Value: N |