PSINDEXDEFN

index back

Index Definition


  • Parent record: PSRECDEFN
  • 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
    INDEXTYPE Number(1,0) SMALLINT NOT NULL Index Type
    UNIQUEFLAG Number(1,0) SMALLINT NOT NULL Index Unique
    CLUSTERFLAG Number(1,0) SMALLINT NOT NULL Index Cluster Flag
    ACTIVEFLAG Number(1,0) SMALLINT NOT NULL Index Active
    CUSTKEYORDER Number(1,0) SMALLINT NOT NULL Custom Key Order
    KEYCOUNT Number(3,0) SMALLINT NOT NULL Number of Keys
    DDLCOUNT Number(3,0) SMALLINT NOT NULL Number of DDL Override Parms
    PLATFORM_SBS Number(1,0) SMALLINT NOT NULL SQLBase
    PLATFORM_DB2 Number(1,0) SMALLINT NOT NULL DB2/MVS
    PLATFORM_ORA Number(1,0) SMALLINT NOT NULL Oracle
    PLATFORM_INF Number(1,0) SMALLINT NOT NULL Informix
    PLATFORM_DBX Number(1,0) SMALLINT NOT NULL DB2 for Unix
    PLATFORM_ALB Number(1,0) SMALLINT NOT NULL AllBase
    PLATFORM_SYB Number(1,0) SMALLINT NOT NULL Sybase Sql Server
    PLATFORM_MSS Number(1,0) SMALLINT NOT NULL MicroSoft Sql Server
    PLATFORM_DB4 Number(1,0) SMALLINT NOT NULL DB2/400
    IDXCOMMENTS Character(254) VARCHAR2(254) NOT NULL INDEX COMMENTS
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19