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 |