PSQRYDEFN

index back

Query Definition


  • Related language record: PSQRYDEFNLANG
  • Parent record of PSCPQBINDLANG PSQRYBIND PSQRYBINDLANG PSQRYEXECLOG PSQRYEXPR PSQRYSELECT PSQRYSTATS PSQRYXFORM PSQRYXFORM_VW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    QRYTYPENumber(1,0)SMALLINT NOT NULLQuery type field with translates for Query
    SELCOUNTNumber(2,0)SMALLINT NOT NULLSelect Count
    EXPCOUNTNumber(3,0)SMALLINT NOT NULLExpression Count
    BNDCOUNTNumber(3,0)SMALLINT NOT NULLBind Count
    QRYVALIDNumber(1,0)SMALLINT NOT NULLValid Query
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(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 CharacterCLOBLong Description
    QRYAPPROVEDCharacter(1)VARCHAR2(1) NOT NULLApproved
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
    APPROVEOPRIDCharacter(30)VARCHAR2(30) NOT NULLApprover's Oper ID
    APPROVEDTTMDateTime(26)TIMESTAMPDateTime of Query Approval
    EXECLOGGINGCharacter(1)VARCHAR2(1) NOT NULLFlag for Logging Qry Execution
    QRYDISABLEDCharacter(1)VARCHAR2(1) NOT NULLQuery Disabled
    N=No
    Y=Yes
    QRYFOLDERCharacter(18)VARCHAR2(18) NOT NULLQuery Folder
    QRYJOINOPTIMIZENumber(1,0)SMALLINT NOT NULLSecurity Join Optimizer

    Default: 0

    QRYIMGTYPENumber(1,0)SMALLINT NOT NULLQuery Image Type
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19