PSQRYDEFN

Return to Index

  • Related language record: PSQRYDEFNLANG
  • Parent record of PSQRYBIND PSQRYBINDLANG PSQRYEXECLOG PSQRYEXPR PSQRYSELECT PSQRYSTATS
  • PeopleSoft Field NameField TypeDescription
    OPRIDVARCHAR2(30) NOT NULLA user's ID
    QRYNAMEVARCHAR2(30) NOT NULLQuery Name
    DESCRVARCHAR2(30) NOT NULLDescription
    VERSIONDECIMAL(10) NOT NULLVersion
    QRYTYPESMALLINT NOT NULLQuery type field with translates for Query
    SELCOUNTSMALLINT NOT NULLSelect Count
    EXPCOUNTSMALLINT NOT NULLExpression Count
    BNDCOUNTSMALLINT NOT NULLBind Count
    QRYVALIDSMALLINT NOT NULLValid Query
    LASTUPDDTTMDATESpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    DESCRLONGLONG VARCHARLong Description
    QRYAPPROVEDVARCHAR2(1) NOT NULLApproved
    CREATEOPRIDVARCHAR2(30) NOT NULLA user's ID
    CREATEDTTMDATEDateTime of Query Creation
    APPROVEOPRIDVARCHAR2(30) NOT NULLApprover's Oper ID
    APPROVEDTTMDATEDateTime of Query Approval
    EXECLOGGINGVARCHAR2(1) NOT NULLFlag for Logging Qry Execution
    QRYDISABLEDVARCHAR2(1) NOT NULLQuery Disabled
    N=No
    Y=Yes
    QRYFOLDERVARCHAR2(18) NOT NULLQuery Folder
    QRYJOINOPTIMIZESMALLINT NOT NULLSecurity Join Optimizer

    Default: 0

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015