# |
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 |
GPES_RTR_OVRD_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Retro override definition ID
|
3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
5 |
GPES_RTR_OVRD_PRTY |
Number(3,0) |
SMALLINT NOT NULL |
FAN file payment type override priority
|
6 |
GPES_PIN_RO1_NUM |
Number(8,0) |
INTEGER NOT NULL |
Retro override value 1
|
7 |
GPES_RTR_ENT_TYPE1 |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN retro override element type 1
|
8 |
GPES_RTO_CFG_EDT1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Retro override prompt record 1
|
9 |
GPES_PIN_RO2_NUM |
Number(8,0) |
INTEGER NOT NULL |
Retro override value 2
|
10 |
GPES_RTR_ENT_TYPE2 |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN retro override element type 2
|
11 |
GPES_RTO_CFG_EDT2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Retro override prompt record 2
|
12 |
GPES_PIN_RO3_NUM |
Number(8,0) |
INTEGER NOT NULL |
Retro override value 3
|
13 |
GPES_RTR_ENT_TYPE3 |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN retro override element type 3
|
14 |
GPES_RTO_CFG_EDT3 |
Character(18) |
VARCHAR2(18) NOT NULL |
Retro override prompt record 3
|
15 |
GPES_PIN_RO4_NUM |
Number(8,0) |
INTEGER NOT NULL |
Retro override value 4
|
16 |
GPES_RTR_ENT_TYPE4 |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN retro override element type 4
|
17 |
GPES_RTO_CFG_EDT4 |
Character(18) |
VARCHAR2(18) NOT NULL |
Retro override prompt record 4
|
18 |
GPES_PIN_RO5_NUM |
Number(8,0) |
INTEGER NOT NULL |
Retro override value 5
|
19 |
GPES_RTR_ENT_TYPE5 |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN retro override element type 5
|
20 |
GPES_RTO_CFG_EDT5 |
Character(18) |
VARCHAR2(18) NOT NULL |
Retro override prompt record 5
|
21 |
GPES_PIN_RO6_NUM |
Number(8,0) |
INTEGER NOT NULL |
Retro override value 6
|
22 |
GPES_RTR_ENT_TYPE6 |
Character(3) |
VARCHAR2(3) NOT NULL |
FAN retro override element type 6
|
23 |
GPES_RTO_CFG_EDT6 |
Character(18) |
VARCHAR2(18) NOT NULL |
Retro override prompt record 6
|