GPFR_DA_FILE(SQL Table) |
Index Back |
|---|---|
File Generation Process DefnDADS related record: define the process for the file generation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GPFR_DA_SNDREF |
Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: GPFR_DA_SNDREF |
| 4 | GPFR_DA_RECIP |
Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: %EDITTABLE |
| 5 | GPFR_FILE_NAME | Character(250) | VARCHAR2(250) NOT NULL | Name of a file, with full path, according to the process scheduler server. |
| 6 | GPFR_DA_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Select by
A=All S=Subset Default Value: A |
| 7 | GPFR_DA_FILE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag for DADS-U File
Y/N Table Edit Default Value: N |
| 8 | GPFR_DA_DESCR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag for Descriptive Report
Y/N Table Edit Default Value: N |
| 9 | GPFR_DA_EXCEP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag for Exception Report
Y/N Table Edit Default Value: N |
| 10 | GPFR_DA_SUMM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag for Summary Report
Y/N Table Edit Default Value: N |
| 11 | GPFR_DA_DECLNAT | Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Default Value: 01 Prompt Table: GPFR_DA_COD9_VW |
| 12 | GPFR_DA_TESTIND | Character(10) | VARCHAR2(10) NOT NULL |
DADs related field
Prompt Table: GPFR_DA_COD2_VW |
| 13 | GPFR_DA_LENGTH | Number(3,0) | SMALLINT NOT NULL | DADS related field |