PM_RECFIELDS_VW

index back

PS Record Fields


select recname, fieldname from psrecfield a where exists (select 'x' from PSRECDEFN b where a.recname = b.recname and b.rectype = 0)

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