RECNAMEINDEXIDPSINDEXDEFN(SQL Table) |
Index Back |
|---|---|
Index Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | INDEXID |
Character(1) | VARCHAR2(1) NOT NULL | Index Identifier |
| 3 | INDEXTYPE | Number(1,0) | SMALLINT NOT NULL | Index Type |
| 4 | UNIQUEFLAG | Number(1,0) | SMALLINT NOT NULL | Index Unique |
| 5 | CLUSTERFLAG | Number(1,0) | SMALLINT NOT NULL | Index Cluster Flag |
| 6 | ACTIVEFLAG | Number(1,0) | SMALLINT NOT NULL | Index Active |
| 7 | CUSTKEYORDER | Number(1,0) | SMALLINT NOT NULL | Custom Key Order |
| 8 | KEYCOUNT | Number(3,0) | SMALLINT NOT NULL | Number of Keys |
| 9 | DDLCOUNT | Number(3,0) | SMALLINT NOT NULL | Number of DDL Override Parms |
| 10 | PLATFORM_SBS | Number(1,0) | SMALLINT NOT NULL | SQLBase |
| 11 | PLATFORM_DB2 | Number(1,0) | SMALLINT NOT NULL | DB2/MVS |
| 12 | PLATFORM_ORA | Number(1,0) | SMALLINT NOT NULL | Oracle |
| 13 | PLATFORM_INF | Number(1,0) | SMALLINT NOT NULL | Informix |
| 14 | PLATFORM_DBX | Number(1,0) | SMALLINT NOT NULL | DB2 for Unix |
| 15 | PLATFORM_ALB | Number(1,0) | SMALLINT NOT NULL | AllBase |
| 16 | PLATFORM_SYB | Number(1,0) | SMALLINT NOT NULL | Sybase Sql Server |
| 17 | PLATFORM_MSS | Number(1,0) | SMALLINT NOT NULL | MicroSoft Sql Server |
| 18 | PLATFORM_DB4 | Number(1,0) | SMALLINT NOT NULL | DB2/400 |
| 19 | IDXCOMMENTS | Character(254) | VARCHAR2(254) NOT NULL | INDEX COMMENTS |