PSQRYFIELD

index back

Query Field


  • Related language record: PSQRYFIELDLANG
  • Parent record: PSQRYSELECT
  • 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
    QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
    SELNUM Number(2,0) SMALLINT NOT NULL Select Number
    FLDNUM Number(3,0) SMALLINT NOT NULL Field Number
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FLDRCDNUM Number(2,0) SMALLINT NOT NULL Field Record Number
    FLDEXPNUM Number(3,0) SMALLINT NOT NULL Field Expression Number
    HDGTYPE Number(1,0) SMALLINT NOT NULL Heading Type
    HEADING Character(30) VARCHAR2(30) NOT NULL Field Heading
    COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number
    GROUPBYNUM Number(3,0) SMALLINT NOT NULL Group-By Number
    ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number
    ORDERBYDIR Character(1) VARCHAR2(1) NOT NULL Order-By Direction
    A=Ascending
    D=Descending
    TTLTYPE Number(1,0) SMALLINT NOT NULL Title Type
    SUBTTLNUM Number(3,0) SMALLINT NOT NULL Subtitle Number
    USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
    XLATTYPE Number(1,0) SMALLINT NOT NULL Translate Table Type
    XLATEXPRTYPE Number(1,0) SMALLINT NOT NULL Translate Expression Type
    XLATFLDNUM Number(3,0) SMALLINT NOT NULL Translate Field Number
    XLATEXPNUM Number(3,0) SMALLINT NOT NULL Translate Expression Number
    AGGREGATEFUNC Character(1) VARCHAR2(1) NOT NULL Aggregate Function
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19