EPO_PAGE_TITLEEPO_PAGE_IDEFFDTDefault Value: %date
A=In Progress - Assigned
I=Inactive
P=Published
R=Ready to Publish
U=In Progress - Unassigned
UX_SEL_PRS_VW(SQL View) |
Index Back |
|---|---|
Page TitleObjective Title on Personization page for Business Objective Alignment Pagelet This view will select all the Business Objective Pages for user to select. |
| SELECT EPO_PAGE_TITLE , EPO_PAGE_ID , EFFDT , EPO_OBJ_PLAN , EPO_NODE_ID , EPO_PAGE_STATUS , EPO_PAGE_OWNER_ID FROM PS_EPO_PAGE_SEL_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EPO_PAGE_TITLE |
Character(100) | VARCHAR2(100) NOT NULL | Title on the Objectives Page |
| 2 | EPO_PAGE_ID |
Number(8,0) | INTEGER NOT NULL | Objectives Management: Objective Page ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EPO_OBJ_PLAN | Character(8) | VARCHAR2(8) NOT NULL | Objectives Management: Objective Plan ID field |
| 5 | EPO_NODE_ID | Character(10) | VARCHAR2(10) NOT NULL | Objectives Management. Used to store the Node ID associated with the Objective Plan |
| 6 | EPO_PAGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Objectives Management: Status of the Objective Page
A=In Progress - Assigned I=Inactive P=Published R=Ready to Publish U=In Progress - Unassigned |
| 7 | EPO_PAGE_OWNER_ID | Character(11) | VARCHAR2(11) NOT NULL | Objectives Management: Emplid of the person who owns the Objective Page |