index back

Key in Index Definition

  • Parent record: PSINDEXDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    INDEXID Character(1) VARCHAR2(1) NOT NULL Index Identifier
    KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    ASCDESC Number(1,0) SMALLINT NOT NULL Ascending/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 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20