FF_RUNCTL

(SQL Table)
Index Back

Run control table

Flat file run control table

  • Parent Record Of FF_QRYPRVWPARM FF_QRYRUNPARM
  • # 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