PSRECFIELDALL

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 , USEEDIT FROM PSRECFIELDDB

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).
USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19