| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPFR_DA_STRUCT |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 2 |
GPFR_DA_DESCR |
Character(60) |
VARCHAR2(60) NOT NULL |
DADS related field
|
| 3 |
GPFR_DA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
A=Active
I=Inactive
Default Value: A
|
| 4 |
GPFR_DA_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
D=Display Only
E=Edit
I=Invisible
Default Value: E
|
| 5 |
GPFR_DA_SEQ_NUM1 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 1
|
| 6 |
GPFR_DA_SRC_DFN1 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 1
01=Sending Reference
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 7 |
GPFR_DA_SEQ_NUM2 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 2
|
| 8 |
GPFR_DA_SRC_DFN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 2
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 9 |
GPFR_DA_SEQ_NUM3 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 3
|
| 10 |
GPFR_DA_SRC_DFN3 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 3
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 11 |
GPFR_DA_SEQ_NUM4 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 4
|
| 12 |
GPFR_DA_SRC_DFN4 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 4
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 13 |
GPFR_DA_SEQ_NUM5 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 5
|
| 14 |
GPFR_DA_SRC_DFN5 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 5
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 15 |
GPFR_DA_SEQ_NUM6 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 6
|
| 16 |
GPFR_DA_SRC_DFN6 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 6
01=Sending Reference
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 17 |
GPFR_DA_SEQ_NUM7 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 7
|
| 18 |
GPFR_DA_SRC_DFN7 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 7
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 19 |
GPFR_DA_SEQ_NUM8 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 8
|
| 20 |
GPFR_DA_SRC_DFN8 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 8
01=Sending Reference
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 21 |
GPFR_DA_SEQ_NUM9 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 9
|
| 22 |
GPFR_DA_SRC_DFN9 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 9
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|
| 23 |
GPFR_DA_SEQ_NUM10 |
Number(4,0) |
SMALLINT NOT NULL |
DADS: Sequence Number 10
|
| 24 |
GPFR_DA_SRC_DFN10 |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS: Source Definition 10
01=Sending Refrence
02=Company
03=Employee ID
04=Establishment ID
05=Period Begin Date
06=First Record of Structure
07=Second Record of Structure
|