PTINDEXDEFN

index back

Index Definition


  • Parent record: PSRECDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    INDEXIDCharacter(1)VARCHAR2(1) NOT NULLIndex Identifier
    INDEXTYPENumber(1,0)SMALLINT NOT NULLIndex Type
    UNIQUEFLAGNumber(1,0)SMALLINT NOT NULLIndex Unique
    CLUSTERFLAGNumber(1,0)SMALLINT NOT NULLIndex Cluster Flag
    ACTIVEFLAGNumber(1,0)SMALLINT NOT NULLIndex Active
    CUSTKEYORDERNumber(1,0)SMALLINT NOT NULLCustom Key Order
    KEYCOUNTNumber(3,0)SMALLINT NOT NULLNumber of Keys
    DDLCOUNTNumber(3,0)SMALLINT NOT NULLNumber of DDL Override Parms
    PLATFORM_SBSNumber(1,0)SMALLINT NOT NULLSQLBase
    PLATFORM_DB2Number(1,0)SMALLINT NOT NULLDB2/MVS
    PLATFORM_ORANumber(1,0)SMALLINT NOT NULLOracle
    PLATFORM_INFNumber(1,0)SMALLINT NOT NULLInformix
    PLATFORM_DBXNumber(1,0)SMALLINT NOT NULLDB2 for Unix
    PLATFORM_ALBNumber(1,0)SMALLINT NOT NULLAllBase
    PLATFORM_SYBNumber(1,0)SMALLINT NOT NULLSybase Sql Server
    PLATFORM_MSSNumber(1,0)SMALLINT NOT NULLMicroSoft Sql Server
    PLATFORM_DB4Number(1,0)SMALLINT NOT NULLDB2/400
    IDXCOMMENTSCharacter(254)VARCHAR2(254) NOT NULLINDEX COMMENTS
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19