PROCESS_INSTANCEGPFR_DA_STRUCTGPFR_DA_RECORDF=Fixed
M=Monetary
N=Numeric
T=Text
1=Data Type
2=Record
3=Translate Value
GPFR_DASR_TAO(SQL Table) |
Index Back |
|---|---|
DADS TMP - Record SetupDADS Temporary Table for File Creation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPFR_DA_STRUCT |
Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 3 | GPFR_DA_RECORD |
Character(10) | VARCHAR2(10) NOT NULL | DADS related record |
| 4 | GPFR_DA_MANDATORY | Character(1) | VARCHAR2(1) NOT NULL | DADs related field |
| 5 | GPFR_DA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
F=Fixed M=Monetary N=Numeric T=Text |
| 6 | GPFR_DA_LBLSRC | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
1=Data Type 2=Record 3=Translate Value |
| 7 | GPFR_DA_LENGTH | Number(3,0) | SMALLINT NOT NULL | DADS related field |
| 8 | GPFR_DA_DECIMAL | Number(2,0) | SMALLINT NOT NULL | DADS related field |
| 9 | GPFR_DA_DATTYP | Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
| 10 | GPFR_DA_PROMPT | Character(15) | VARCHAR2(15) NOT NULL | DADS related field |
| 11 | GPFR_DA_PR_KEY | Character(15) | VARCHAR2(15) NOT NULL | DADS related field |
| 12 | GPFR_DA_PR_DESC | Character(15) | VARCHAR2(15) NOT NULL | DADS related field |
| 13 | GPFR_DA_FIELD | Character(18) | VARCHAR2(18) NOT NULL | DADS related field |
| 14 | GPFR_DA_DESCR | Character(60) | VARCHAR2(60) NOT NULL | DADS related field |