ECRECFIELD_VW

index back

View of Fields from psrecfield


SELECT A.RECNAME , A.FIELDNAME , B.FIELDTYPE , A.FIELDNUM , B.LENGTH , B.DECIMALPOS , C.LONGNAME , C.SHORTNAME , A.SUBRECORD , A.DEFFIELDNAME 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).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
LENGTH Number(5,0) INTEGER NOT NULL Length
DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record
DEFFIELDNAME Character(18) VARCHAR2(18) NOT NULL Default Field Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19