PSKEYDEFN |
This table contains one row for each column in each index specified in PeopleTools, so it roughly corresponds to DBA_IND_COLUMNS.
| PSKEYDEFN | DBA_IND_COLUMNS | Description of PeopleTools Column |
|---|---|---|
| PeopleSoft Field Name | Corresponding Oracle Column Name | |
 RECNAME | TABLE_NAME | Record (Table) Name. Not an exact match for TABLE_NAME see PSRECDEFN.SQLTABLENAME |
| INDEXID | INDEX_NAME | Index Identifier. Not an exact match for INDEX_NAME, see PSINDEXDEFN.INDEXID |
| KEYPOSN | COLUMN_POSITION | Order of column or sub-record in index |
| FIELDNAME | COLUMN_NAME | Name of field or sub-record on PeopleTools record. |
| ASCDESC | DESCEND | Ascending/Descending
From PeopleTools 8.15 this no longer causes a descending order index to be built. PeopleSoft eventually removed this functionality because of Oracle Bug #869177, which affected descending indexes on most gversions of Oracle 8.1.x. (see Oracle support website and PeopleTools installation guide for PT8.15). |
Author: David Kurtz | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 25 July 2010 |