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 NameField TypeColumn TypeDescription
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
DESCRLONGLong CharacterCLOBLong Description
LENGTHNumber(5,0)INTEGER NOT NULLLength
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19