| # |
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 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
RECNAME_RULE_DFN |
Character(15) |
VARCHAR2(15) NOT NULL |
GP Rule Definition Record Name
|
| 6 |
FIELDNAME_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Line Descr
|
| 7 |
FIELDNAME_KEY1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field created for use with element packager
|
| 8 |
FIELDNAME_KEY2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field created for use with element packager
|
| 9 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 10 |
SQL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
|
| 11 |
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)
|
| 12 |
UPG_OLD_PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 13 |
UPG_NEW_PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|