PSQRYEXPR

index back

Query Expression


  • Parent record: PSQRYDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    EXPNUMNumber(3,0)SMALLINT NOT NULLExpression Number
    FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
    LENGTHNumber(5,0)INTEGER NOT NULLLength
    DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
    USECOUNTNumber(3,0)SMALLINT NOT NULLUse Count
    EXPRESSIONTEXTLong CharacterCLOBExpression Text
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19