OPA_RECFLD_VW - All record fields w/ subrec - PeopleTools Table Reference

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 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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

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).