EOIU_DBFLDS_VW (SQL View)	Index Back
Get Non-key Fields for Record Get Non-key Fields for Record

EOIU_DBFLDS_VW

(SQL View)

Get Non-key Fields for Record

SELECT A.RECNAME , A.FIELDNAME , B.DESCRLONG FROM PSRECFIELDDB A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOIU_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name

2 EOIU_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name

3 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOIU_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name
2	EOIU_FIELD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name
3	DESCRLONG	Long Character	CLOB	Long Description