| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 3 |
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)
|
| 4 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 5 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
Prompt Table:
GP_PINTYPE_VW
|
| 6 |
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
|
| 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_ELEM_CMP_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
F=Failed
N=Compare Not Done
S=Successful
W=Warning
|
| 9 |
GP_PKG_FAIL_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
A=Parent used in Rule Defn.
C=Element Owner/Type Conflict
D=Cannot delete PS-Owned Element
I=Member Element not found
M=MbrElement Owner/Type Conflict
N=Used in Non-Elem Defn
O=Used in Output Results
P=Used in Payee Data
R=Used in Rule Defn.
S=Auto-component used in RuleDfn
T=Element PIN Type Conflict
U=PS Delivered/Customer Modified
V=PS Delivered/PS Modified
X=Element does not exist
Y=new Elem not copied completely
Z=Duplicate Package Elmnt found
|
| 10 |
PIN_NUM_TGT |
Number(8,0) |
INTEGER NOT NULL |
Element number [PIN] field
|