QUERY_RUN_CNTRL

index back

Scheduled Query Run Control


  • Parent record of QRY_RUN_TREEPRM QUERY_RUN_PARM
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    QRYTYPENumber(1,0)SMALLINT NOT NULLQuery type field with translates for Query

    Default: 1

    PRIVATE_QUERY_FLAGCharacter(1)VARCHAR2(1) NOT NULLYes/No Flag to indicate if its a private query

    Y/N Table Edit

    Default: N

    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
    ASIAN_FONT_SETTINGCharacter(3)VARCHAR2(3) NOT NULLSetting 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_IDCharacter(30)VARCHAR2(30) NOT NULLFeed ID (see PSFP_FEED).
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19