PTGL_GET_FLD_VW

index back

SELECT DISTINCT A.RECNAME , C.FIELDNAME ,C.FIELDNUM , D.FIELDTYPE , D.LENGTH FROM PSRECDEFN A , PSRECFIELD C , PSDBFIELD D WHERE A.RECTYPE = 0 AND A.RECNAME=C.RECNAME AND C.FIELDNAME = D.FIELDNAME AND D.FIELDTYPE IN (0,1) AND C.FIELDNAME NOT IN ( SELECT FIELDNAME FROM PSKEYDEFN D WHERE D.RECNAME = C.RECNAME AND D.INDEXID = '_')

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
LENGTHNumber(5,0)INTEGER NOT NULLLength
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19