EPO_SECTION_VW (SQL View)	Index Back
prompt view for Active Section Prompt view used to find all Active Sections

EPO_SECTION_VW

(SQL View)

prompt view for Active Section

Prompt view used to find all Active Sections

SELECT EPO_SECTION_TYPE , EP_J_ITEM_CAT_TYPE , DESCR50 FROM PS_EPO_SECTN_DEFN A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EPO_SECTN_DEFN A1 WHERE A1.EPO_SECTION_TYPE = A.EPO_SECTION_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type

2 EP_J_ITEM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific version of the JPM Catalog Type field.

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type
2	EP_J_ITEM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	ePerformance specific version of the JPM Catalog Type field.
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50