PSRECFLDSR

index back

Record fields in sub record


SELECT C.RECNAME , B.FIELDNAME FROM PSRECFIELD B , PSRECFIELD C WHERE B.SUBRECORD = 'N' AND C.SUBRECORD = 'Y' AND B.RECNAME = C.FIELDNAME

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19