PSRFLDBKEYDEFVW

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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
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