FF_QRYRUNPARM

(SQL Table)
 Index Back

Run control table

Flat file run control table

  • Parent record: FF_RUNCTL

    • # 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
    4 FF_VERSION Character(30) VARCHAR2(30) NOT NULL Message Version
    5 FF_SECTIONID Character(30) VARCHAR2(30) NOT NULL Flat file section type
    6 FF_PARAMNUM Number(3,0) SMALLINT NOT NULL Paramnum
    7 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    9 FF_PARAMNAME Character(30) VARCHAR2(30) NOT NULL Parameter Name
    10 FF_PARAMVALUE Long Character CLOB Parameter Value
    11 FF_REQUIREDPROMPT Character(1) VARCHAR2(1) NOT NULL Optional
    N=Optional
    Y=Required
    12 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table