PSQRYEXPR

index back

Query Expression


  • Parent record: PSQRYDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    EXPNUM Number(3,0) SMALLINT NOT NULL Expression Number
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    LENGTH Number(5,0) INTEGER NOT NULL Length
    DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
    EXPRESSIONTEXT Long Character CLOB Expression Text
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19