PSRECFLDKEYVW - Unique Key Fields - PeopleTools Table Reference

PSRECFLDKEYVW	index back
Unique Key Fields

View of fields defined as part of the primary unique key on a record

SELECT A.RECNAME ,A.FIELDNAME FROM PSRECFIELDALL A WHERE EXISTS ( SELECT 'X' FROM PSKEYDEFN B WHERE B.RECNAME=A.RECNAME AND B.FIELDNAME=A.FIELDNAME AND B.INDEXID = '_')

PeopleSoft Field Name Field Type Column Type Description

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

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

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).