Co-Operative PeopleTools Table Reference

PSRECFLDKEYVW	Return to Index

View of fields defined as part of the primary unique key on a record

Platform View Text
Default 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 = '_')

Platform	View Text
Default	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 Description
RECNAME Record (Table) Name
FIELDNAME Field Name
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd. Last updated 24 July 2010

PSRECFLDKEYVW