EOEN_FLDKEY_VW (SQL View)	Index Back
Unique Key Fields View of fields defined as part of the primary unique key on a record. Similar to PSRECFLDKEYVW except that view only works for records that are of Record Type SQL Table. This view also displays unique keys on records based solely on PeopleTools Record MetaData, i.e. works for views and work records also.

EOEN_FLDKEY_VW

(SQL View)

Unique Key Fields

View of fields defined as part of the primary unique key on a record. Similar to PSRECFLDKEYVW except that view only works for records that are of Record Type SQL Table. This view also displays unique keys on records based solely on PeopleTools Record MetaData, i.e. works for views and work records also.

SELECT A.RECNAME ,A.FIELDNAME ,B.LONGNAME FROM PSRECFIELDALL A , PSDBFLDLABL B WHERE %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT AND B.FIELDNAME = A.FIELDNAME AND B.DEFAULT_LABEL = 1

# 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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

#	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	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name