index back

Key in Index Definition

  • Parent record: PSINDEXDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    INDEXIDCharacter(1)VARCHAR2(1) NOT NULLIndex Identifier
    KEYPOSNNumber(3,0)SMALLINT NOT NULLKey Position
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    ASCDESCNumber(1,0)SMALLINT NOT NULLAscending/Descending
  • 1 = Ascending order
  • 0 = Descending order
    PeopleSoft removed decending indexes in PT8.54 (due to Oracle Bug #869177 on Oracle 8i), reintroduced them in PT8.48, and finally removed them again in PT8.54.
  • index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19