UX_EPO_SEC_VW

(SQL View)
Index Back

View Summary Data by Section

View used to sum data by section from EPO_OBJ_SUM_VW which is based on EPO_OBJ_EXTRACT

SELECT EPO_PAGE_ID , EFFDT , EPO_SECTION_TYPE FROM PS_EPO_PG_SECTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

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