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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
SHORTNAMECharacter(15)VARCHAR2(15) NOT NULLField Short Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19