RECNAMEINDEXIDPTINDEXDEFN |
index back |
|---|---|
Index Definition |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |