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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19