RECFLD_DESCR_VW

index back

PSRECFIELD / PSDBFIELD View


select a.recname, a.fieldnum, a.fieldname, b.fieldtype, c.shortname from psrecfield a, psdbfield b, psdbfldlabl c where a.fieldname = b.fieldname and b.fieldname = c.fieldname and c.default_label = 1

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19