OPRIDRUN_CNTL_IDPrompt Table: FF_FILEDEFN_VW
Prompt Table: FF_FLVERSION_VW
D=Report Manager
P=File Path
U=URL
Default Value: D
Prompt Table: PSURLDEFN
Default Value: 5
N=No
Y=Yes
Default Value: N
FF_RUNCTL(SQL Table) |
Index Back |
|---|---|
Run control tableFlat file run control table |
| # | 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 | FF_FILE_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Flat file name
Prompt Table: FF_FILEDEFN_VW |
| 4 | FF_VERSION | Character(30) | VARCHAR2(30) NOT NULL |
Message Version
Prompt Table: FF_FLVERSION_VW |
| 5 | FF_RUNFILEVERSION | Character(61) | VARCHAR2(61) NOT NULL | File.Version to generate |
| 6 | FF_FILE_DEST | Character(1) | VARCHAR2(1) NOT NULL |
Flat file destination
D=Report Manager P=File Path U=URL Default Value: D |
| 7 | FF_FILE_PATH | Character(250) | VARCHAR2(250) NOT NULL | Flat file destination |
| 8 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |
| 9 | FF_PRVW_CNT | Number(2,0) | SMALLINT NOT NULL |
Flat file preview row count
Default Value: 5 |
| 10 | FF_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Flat file send notifications
N=No Y=Yes Default Value: N |
| 11 | FF_USERFILENAME | Character(64) | VARCHAR2(64) NOT NULL | Output File Name |