GET_XLAT_FLD_VW

index back

SELECT DISTINCT A.RECNAME , A.RELLANGRECNAME , C.FIELDNAME ,C.FIELDNUM , D.FIELDTYPE , D.LENGTH FROM PSRECDEFN A , PSRECFIELD C , PSDBFIELD D WHERE A.RELLANGRECNAME = C.RECNAME AND A.RECTYPE = 0 AND C.FIELDNAME = D.FIELDNAME 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).
RELLANGRECNAMECharacter(15)VARCHAR2(15) NOT NULLRelated Language Record Name
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