GPFR_AF_RUNFILE(SQL Table) |
Index Back |
---|---|
Create file recordApplication Framework - Create file record used in Application Framework |
# | 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_AF_EXTRACT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Application Framework - Extraction ID
Prompt Table: GPFR_AF_RUN_DFN |
4 | GPFR_AF_TESTIND | Character(2) | VARCHAR2(2) NOT NULL |
Application Framework - Test Indicator
0=Real 1=Test Default Value: 1 |
5 | GPFR_AF_FILE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - DADS-U File
Y/N Table Edit Default Value: N |
6 | GPFR_AF_DESCR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - Descriptive Report
Y/N Table Edit Default Value: N |
7 | GPFR_AF_FILE_NAME | Character(250) | VARCHAR2(250) NOT NULL | Application Framework - File Name |