OPA_RECFLD_VW

index back

All record fields w/ subrec

This view brings up all the fields for a record, including the fields in the subrecords, if any.
SELECT RECNAME , FIELDNAME FROM PSRECFIELD WHERE FIELDNAME IN( SELECT FIELDNAME FROM PSDBFIELD WHERE FIELDTYPE NOT IN(1,7,8,9))

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
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