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 NameField TypeColumn TypeDescription
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19