EODP_CLSFCN_LVW (SQL View)	Index Back
Classification View Classification View

EODP_CLSFCN_LVW

(SQL View)

Classification View

SELECT A.EODP_CTGRY_CD , A.EODP_CLFNCD , B1.LANGUAGE_CD , B1.EODP_CFCN_NAME FROM PS_EODP_CTGRY_DTLS A , PS_EODP_CLSFCN B , PS_EODP_CLSFCN_LNG B1 WHERE A.EODP_CLFNCD = B.EODP_CLFNCD AND B.EODP_CLFNCD = B1.EODP_CLFNCD

Related Language Record for EODP_CLSFCN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

2 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code
Default Value: 1

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

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

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