PSRECFLDKEYSVW

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.
SELECT A.RECNAME ,A.FIELDNAME FROM PSRECFIELDALL A WHERE %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19