RB_TD_FLD3_VW (SQL View)	Index Back
Fields View Fields View

RB_TD_FLD3_VW

(SQL View)

Fields View

SELECT FIELDNAME , FIELDTYPE FROM PSDBFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Name of Field

2 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME3	Character(18)	VARCHAR2(18) NOT NULL	Name of Field
2	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)