RUNCTL_TS131_DW

(SQL Table)
Index Back

Run Control for TS131 Download

# 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 TS131_FILE_OPTIONS Character(1) VARCHAR2(1) NOT NULL Downloading file options: Input a single file name or a file which contains a list of download file names, or input a directory..
D=Directory
F=Single File
L=File List Driven

Default Value: D

4 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
5 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
6 FILE_PATTERN Character(10) VARCHAR2(10) NOT NULL TS130 File Pattern for reading files in a specified directory.