EODP_CLSFCN_VW (SQL View)	Index Back
Classification View Classification View

EODP_CLSFCN_VW

(SQL View)

Classification View

SELECT A.EODP_CTGRY_CD , A.EODP_CLFNCD , B.EODP_CFCN_NAME FROM PS_EODP_CTGRY_DTLS A , PS_EODP_CLSFCN B WHERE A.EODP_CLFNCD = B.EODP_CLFNCD

Related Language Record: EODP_CLSFCN_LVW

# 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 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	EODP_CFCN_NAME	Character(100)	VARCHAR2(100) NOT NULL	Classification Name