CS_KEYFIELD_VW (SQL View)	Index Back
Key in Index Definition

CS_KEYFIELD_VW

(SQL View)

Key in Index Definition

SELECT K.RECNAME , K.FIELDNAME , K.KEYPOSN , F.FIELDTYPE , F.LENGTH , F.DECIMALPOS , K.ASCDESC FROM PSKEYDEFN K , PSDBFIELD F WHERE K.INDEXID = '_' AND F.FIELDNAME = K.FIELDNAME

Parent record: PSINDEXDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

3 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position

4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

5 LENGTH Number(5,0) INTEGER NOT NULL Length

6 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions

7 ASCDESC Number(1,0) SMALLINT NOT NULL Ascending/Descending
1 = Ascending order
0 = Descending order
PeopleSoft removed decending indexes in PT8.54 (due to Oracle Bug #869177 on Oracle 8i), reintroduced them in PT8.48, and finally removed them again in PT8.54.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	KEYPOSN	Number(3,0)	SMALLINT NOT NULL	Key Position
4	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
5	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
6	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
7	ASCDESC	Number(1,0)	SMALLINT NOT NULL	Ascending/Descending 1 = Ascending order 0 = Descending order PeopleSoft removed decending indexes in PT8.54 (due to Oracle Bug #869177 on Oracle 8i), reintroduced them in PT8.48, and finally removed them again in PT8.54.