PSCPQ_RUN_PARM

(SQL Table)
Index Back

Scheduled Query Run Parameters

  • Parent record: QUERY_RUN_CNTRL
  • # 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 BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 BNDNAME Character(30) VARCHAR2(30) NOT NULL Query Bind Name
    6 BNDVALUE Long Character CLOB Bind Value