EO_PSDBFLD2_VW (SQL View)	Index Back
Field types from PSDBFIELD Used with Prior Level Field Name

EO_PSDBFLD2_VW

(SQL View)

Field types from PSDBFIELD

Used with Prior Level Field Name

SELECT DISTINCT FIELDNAME FLDNAME_1, FIELDTYPE FROM PSDBFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FLDNAME_1 Character(18) VARCHAR2(18) NOT NULL Field 1 Name

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

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