PSRECFLDKEYSVW

Return to Index

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.

PlatformView Text
DefaultSELECT A.RECNAME ,A.FIELDNAME FROM PSRECFIELDALL A WHERE %DecMult(%Round(%DECDIV(A.USEEDIT,2),0 ) , 2) <> A.USEEDIT

PeopleSoft Field NameDescription
RECNAMERecord (Table) Name
FIELDNAMEField Name

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010