MC_FIELD_VW

Platform	View Text
Default	SELECT A.RECNAME , A.FIELDNUM , A.FIELDNAME , B.FIELDTYPE , B.LENGTH , A.DEFFIELDNAME , C.SQR_DATA_PREFIX , C.DATATYPE_DESCR4 FROM PSRECFIELDDB A , PSDBFIELD B , PS_MC_DATA_TBL C WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE = C.FIELDTYPE

PeopleSoft Field Name	Description
RECNAME	Record (Table) Name
FIELDNUM	Field Number
FIELDNAME	Field Name
FIELDTYPE	Field Type
MC_FIELDLENGTH	Length
DEFFIELDNAME	Default Field Name
SQR_DATA_PREFIX	SQR Datatype Prefix
DATATYPE_DESCR4	Datatype Description 4

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