PSDBFLD_XLAT

index back

Fieldname and Field Length VW


SELECT a.fieldname , A.DESCRLONG , a.length , A.FIELDTYPE FROM psdbfield a WHERE A.FIELDTYPE = 0 AND A.LENGTH < 5

PeopleSoft Field Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
DESCRLONG Long Character CLOB Long Description
LENGTH Number(5,0) INTEGER NOT NULL Length
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19