| # |
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 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 5 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 6 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
Prompt Table:
GP_PINTYPE_VW
|
| 7 |
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
|
| 8 |
GP_PKG_UPG_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
D=Delete
I=Informational Only
U=Upgrade
|
| 9 |
PKG_LNG_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines options available for exporting language-data.
A=All(Base&Related)
B=Base Only
R=Related Only
|
| 10 |
PIN_NUM_TGT |
Number(8,0) |
INTEGER NOT NULL |
Element number [PIN] field
|
| 11 |
GP_PKG_NEW_PIN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
Y/N Table Edit
Default Value: N
|
| 12 |
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
Default Value: N
|
| 13 |
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
|
| 14 |
GP_PKG_UPG_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
Y/N Table Edit
Default Value: Y
|
| 15 |
GP_PKG_ELEM_UPG_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
A=Not Applicable
N=Upgrade Not Done
Y=Upgrade Done
Default Value: N
|