| # |
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 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 4 |
SEQ_NUM5 |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
DATA_KEY1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Key - Character
|
| 6 |
DATA_KEY1_DT |
Date(10) |
DATE |
Data Key Date
|
| 7 |
DATA_KEY1_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Key - Decimal
|
| 8 |
DATA_KEY2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Key - Character
|
| 9 |
DATA_KEY2_DT |
Date(10) |
DATE |
Data Key Date
|
| 10 |
DATA_KEY2_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Key - Decimal
|
| 11 |
DATA_KEY3 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Key - Character
|
| 12 |
DATA_KEY3_DT |
Date(10) |
DATE |
Data Key - Date
|
| 13 |
DATA_KEY3_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Key - Decimal
|
| 14 |
DATA_KEY4 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Key - Character
|
| 15 |
DATA_KEY4_DT |
Date(10) |
DATE |
Data Key - Date
|
| 16 |
DATA_KEY4_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Key - Decimal
|
| 17 |
DATA_KEY5 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Key - Character
|
| 18 |
DATA_KEY5_DT |
Date(10) |
DATE |
Data Key - Date
|
| 19 |
DATA_KEY5_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Key - Decimal
|
| 20 |
DATA_VAL1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 21 |
DATA_VAL1_DT |
Date(10) |
DATE |
Data Value - Date
|
| 22 |
DATA_VAL1_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 23 |
DATA_VAL1_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 24 |
ENTRY_TYPE_VAL1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 25 |
PIN_VAL1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 26 |
DATA_VAL2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 27 |
DATA_VAL2_DT |
Date(10) |
DATE |
Data Value - Date
|
| 28 |
DATA_VAL2_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 29 |
DATA_VAL2_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 30 |
ENTRY_TYPE_VAL2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 31 |
PIN_VAL2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 32 |
DATA_VAL3 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 33 |
DATA_VAL3_DT |
Date(10) |
DATE |
Data Value - Date
|
| 34 |
DATA_VAL3_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 35 |
DATA_VAL3_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 36 |
ENTRY_TYPE_VAL3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 37 |
PIN_VAL3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 38 |
DATA_VAL4 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 39 |
DATA_VAL4_DT |
Date(10) |
DATE |
Data Value - Date
|
| 40 |
DATA_VAL4_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 41 |
DATA_VAL4_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 42 |
ENTRY_TYPE_VAL4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 43 |
PIN_VAL4_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 44 |
DATA_VAL5 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 45 |
DATA_VAL5_DT |
Date(10) |
DATE |
Data Value - Date
|
| 46 |
DATA_VAL5_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 47 |
DATA_VAL5_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 48 |
ENTRY_TYPE_VAL5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 49 |
PIN_VAL5_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 50 |
DATA_VAL6 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 51 |
DATA_VAL6_DT |
Date(10) |
DATE |
Data Value - Date
|
| 52 |
DATA_VAL6_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 53 |
DATA_VAL6_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 54 |
ENTRY_TYPE_VAL6 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 55 |
PIN_VAL6_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 56 |
DATA_VAL7 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 57 |
DATA_VAL7_DT |
Date(10) |
DATE |
Data Value - Date
|
| 58 |
DATA_VAL7_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 59 |
DATA_VAL7_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 60 |
ENTRY_TYPE_VAL7 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 61 |
PIN_VAL7_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|
| 62 |
DATA_VAL8 |
Character(18) |
VARCHAR2(18) NOT NULL |
Data Value - Character
|
| 63 |
DATA_VAL8_DT |
Date(10) |
DATE |
Data Value - Date
|
| 64 |
DATA_VAL8_DEC |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Data Value - Decimal
|
| 65 |
DATA_VAL8_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code for Bracket Data Value
|
| 66 |
ENTRY_TYPE_VAL8 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type for Bracket Value
|
| 67 |
PIN_VAL8_NUM |
Number(8,0) |
INTEGER NOT NULL |
Bracket Value Element Number
|