WL_RECFIELD_VW

index back

View into PSRECFIELD table

Does not display subrecords in the record definition.
SELECT DISTINCT RECNAME , FIELDNAME FROM PSRECFIELD WHERE SUBRECORD <> 'Y'

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