QUERY_RUN_CNTRL

index back

Scheduled Query Run Control


  • Parent record of QRY_RUN_TREEPRM QUERY_RUN_PARM
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    QRYTYPE Number(1,0) SMALLINT NOT NULL Query type field with translates for Query

    Default: 1

    PRIVATE_QUERY_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No Flag to indicate if its a private query

    Y/N Table Edit

    Default: N

    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    ASIAN_FONT_SETTING Character(3) VARCHAR2(3) NOT NULL Setting when multiple double byte languages are installed on the system. Currently, only used by PDF and the Adobe PDF print dialog refers to these as 'Asian Fonts' so we are using same terminology
    JPN=Japanese
    KOR=Korean
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    PTFP_FEED_ID Character(30) VARCHAR2(30) NOT NULL Feed ID (see PSFP_FEED).
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19