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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
LENGTHNumber(5,0)INTEGER NOT NULLLength
DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
LONGNAMECharacter(30)VARCHAR2(30) NOT NULLLong Name
SHORTNAMECharacter(15)VARCHAR2(15) NOT NULLField Short Name
SUBRECORDCharacter(1)VARCHAR2(1) NOT NULLSub Record
DEFFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLDefault Field Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19