EODP_CNFLVW_LNG (SQL View)	Index Back
Classification filter View

EODP_CNFLVW_LNG

(SQL View)

Classification filter View

SELECT DISTINCT RF.EODP_CLFNCD , CF.LANGUAGE_CD ,CF.EODP_CFCN_NAME FROM ps_EODP_RECFIELD RF LEFT OUTER JOIN PS_EODP_CLSFCN_LNG CF ON CF.EODP_CLFNCD = RF.EODP_CLFNCD

Related Language Record for EODP_CLFN_FL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODP_CLFNCD	Number(3,0)	SMALLINT NOT NULL	Classification Code
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EODP_CFCN_NAME	Character(100)	VARCHAR2(100) NOT NULL	Classification Name