PSQRYFIELD

index back

Query Field


  • Related language record: PSQRYFIELDLANG
  • Parent record: PSQRYSELECT
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field
    SELNUMNumber(2,0)SMALLINT NOT NULLSelect Number
    FLDNUMNumber(3,0)SMALLINT NOT NULLField Number
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    FLDRCDNUMNumber(2,0)SMALLINT NOT NULLField Record Number
    FLDEXPNUMNumber(3,0)SMALLINT NOT NULLField Expression Number
    HDGTYPENumber(1,0)SMALLINT NOT NULLHeading Type
    HEADINGCharacter(30)VARCHAR2(30) NOT NULLField Heading
    COLUMNNUMNumber(3,0)SMALLINT NOT NULLColumn Number
    GROUPBYNUMNumber(3,0)SMALLINT NOT NULLGroup-By Number
    ORDERBYNUMNumber(3,0)SMALLINT NOT NULLOrder-By Number
    ORDERBYDIRCharacter(1)VARCHAR2(1) NOT NULLOrder-By Direction
    A=Ascending
    D=Descending
    TTLTYPENumber(1,0)SMALLINT NOT NULLTitle Type
    SUBTTLNUMNumber(3,0)SMALLINT NOT NULLSubtitle Number
    USECOUNTNumber(3,0)SMALLINT NOT NULLUse Count
    XLATTYPENumber(1,0)SMALLINT NOT NULLTranslate Table Type
    XLATEXPRTYPENumber(1,0)SMALLINT NOT NULLTranslate Expression Type
    XLATFLDNUMNumber(3,0)SMALLINT NOT NULLTranslate Field Number
    XLATEXPNUMNumber(3,0)SMALLINT NOT NULLTranslate Expression Number
    AGGREGATEFUNCCharacter(1)VARCHAR2(1) NOT NULLAggregate Function
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19