| # |
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 |
ERROR_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Error Count
|
| 4 |
GP_PKG_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Field used for element packaging
|
| 5 |
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)
|
| 6 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 7 |
PIN_MBR_NUM |
Number(8,0) |
INTEGER NOT NULL |
Element number field
|
| 8 |
PIN_NUM_TGT |
Number(8,0) |
INTEGER NOT NULL |
Element number [PIN] field
|
| 9 |
PIN_MBR_NUM_TGT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Element number [PIN] field
|
| 10 |
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
|
| 11 |
GP_PKG_PIN_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for element packaging
|
| 12 |
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
|
| 13 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field
|
| 14 |
GP_PKG_RUNSTAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Field used for element packaging
EX=Exported from Source
IM=Imported to Target
SC=Scripts created
|
| 15 |
UPDATE_STATS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Statistics
|
| 16 |
GP_PKG_COMPARE_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox to indicator whether or not the Rules Package Compare Report should run as part of the Rules Compare process.
|
| 17 |
PRINT_ERR_WARN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Decide whether to print Compare Report section for errors and warnings.
|
| 18 |
PRINT_MOD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Decide whether to print the Compare Report section for Modified elements.
|
| 19 |
PRINT_NEW_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Decide whether to print the Compare Report section for New elements.
|
| 20 |
PRINT_DEL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Decide whether to print the Compare Report section for Deleted elements.
|
| 21 |
PRINT_UNCHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Decide whether to print the Compare Report section for Unchanged elements.
|