PSQRYFIELD

Return to Index

  • Related language record: PSQRYFIELDLANG
  • Parent record: PSQRYSELECT
  • PeopleSoft Field NameField TypeDescription
    OPRIDVARCHAR2(30) NOT NULLA user's ID
    QRYNAMEVARCHAR2(30) NOT NULLQuery Name
    QRYFLDNAMEVARCHAR2(30) NOT NULLSource Field
    SELNUMSMALLINT NOT NULLSelect Number
    FLDNUMSMALLINT NOT NULLField Number
    RECNAMEVARCHAR2(15) NOT NULLRecord (Table) Name
    FIELDNAMEVARCHAR2(18) NOT NULLField Name
    FLDRCDNUMSMALLINT NOT NULLField Record Number
    FLDEXPNUMSMALLINT NOT NULLField Expression Number
    HDGTYPESMALLINT NOT NULLHeading Type
    HEADINGVARCHAR2(30) NOT NULLField Heading
    COLUMNNUMSMALLINT NOT NULLColumn Number
    GROUPBYNUMSMALLINT NOT NULLGroup-By Number
    ORDERBYNUMSMALLINT NOT NULLOrder-By Number
    ORDERBYDIRVARCHAR2(1) NOT NULLOrder-By Direction
    A=Ascending
    D=Descending
    TTLTYPESMALLINT NOT NULLTitle Type
    SUBTTLNUMSMALLINT NOT NULLSubtitle Number
    USECOUNTSMALLINT NOT NULLUse Count
    XLATTYPESMALLINT NOT NULLTranslate Table Type
    XLATEXPRTYPESMALLINT NOT NULLTranslate Expression Type
    XLATFLDNUMSMALLINT NOT NULLTranslate Field Number
    XLATEXPNUMSMALLINT NOT NULLTranslate Expression Number
    AGGREGATEFUNCVARCHAR2(1) NOT NULLAggregate Function

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015