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

EP_SECTION_VW

(SQL View)

prompt view for Active Section

Prompt view used to find all Active Sections

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL 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	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	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