PSRECFLDDBKEYVW

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

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
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