PSRECFLDDBKEYVW (SQL View)	Index Back
Unique Key Fields Metadata View to show fields defined as part of the primary unique key on a record based on PeopleTools Record MetaData as captured in PSRECFIELDDB table.

PSRECFLDDBKEYVW

(SQL View)

Unique Key Fields Metadata

View to show fields defined as part of the primary unique key on a record based on PeopleTools Record MetaData as captured in PSRECFIELDDB table.

SELECT A.RECNAME ,A.FIELDNUM ,A.FIELDNAME FROM PSRECFIELDDB A WHERE %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).