PSFIELDRECDVW

index back

Records for a field

This view brings up all the records for a field, accounting for sub records.
SELECT B.FIELDNAME , A.RECNAME FROM PSRECDEFN A , PSRECFIELD B WHERE B.SUBRECORD = 'N' AND (A.RECNAME = B.RECNAME OR (A.RECNAME <> B.RECNAME AND B.RECNAME IN ( SELECT C.FIELDNAME FROM PSRECFIELD C WHERE C.SUBRECORD = 'Y' AND C.RECNAME = A.RECNAME)))

PeopleSoft Field Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20