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

EPO_SECTN_VW

(SQL View)

prompt view for Active Section

Prompt view used to find all Active Sections

SELECT EPO_SECTION_TYPE , EFFDT , EP_J_ITEM_CAT_TYPE , DESCR50 FROM PS_EPO_SECTN_DEFN A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(EPO_SECTN_DEFN EFF,A,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

4 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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EP_J_ITEM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	ePerformance specific version of the JPM Catalog Type field.
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50