GET_XLAT_FLD_VW

Platform	View Text
Default	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 Name	Description
RECNAME	Record (Table) Name
RELLANGRECNAME	Related Language Record Name
FIELDNAME	Field Name
FIELDNUM	Field Number
FIELDTYPE	Field Type
LENGTH	Length

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010