UX_EPO_SEC_VW(SQL View) |
Index Back |
---|---|
View Summary Data by SectionView 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 |