SET_FIELDNAMEVW

index back

TableSet Fields


select distinct a.fieldname ,c.longname from psdbfield a ,psrecdefn b ,psdbfldlabl c where (a.fieldname = b.setcntrlfld and a.fieldname = c.fieldname and c.default_label = 1) or (a.fieldname = 'SETID' and a.fieldname = c.fieldname and c.default_label = 1)

PeopleSoft Field Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19