EPO_PUB_OWNR_VW

(SQL View)
 Index Back

Obj Page Header Record

Objectives Management Header record for the Objectives Page

SELECT A.EPO_PAGE_ID , A.EFFDT , B.EPO_OBJ_PLAN , B.SETID , B.EPO_NODE_ID , A.EPO_PAGE_STATUS , A.EPO_PAGE_LOCKED_SW , A.EPO_PAGE_OWNER_ID , A.EPO_PAGE_OWNER_RCD , A.EPO_PG_UPD_ALT_ID , A.EPO_PUBLISH_DT FROM PS_EPO_PG_HDR A , PS_EPO_PLAN_PAGES B WHERE A.EPO_OBJ_PLAN = B.EPO_OBJ_PLAN AND A.SETID = B.SETID AND A.EPO_NODE_ID = B.EPO_NODE_ID AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_EPO_PG_HDR A2 WHERE A2.EPO_PAGE_ID = A.EPO_PAGE_ID AND A2.EFFDT <= %CurrentDateIn) AND A.EPO_PAGE_STATUS = 'P'

# 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_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
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_LOCKED_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch specifying whether or not the Objective Page is Locked to updates.
8 EPO_PAGE_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who owns the Objective Page
9 EPO_PAGE_OWNER_RCD Number(3,0) SMALLINT NOT NULL Page Owner Record Number
10 EPO_PG_UPD_ALT_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who updates the Objective Page
11 EPO_PUBLISH_DT Date(10) DATE Date the Objective Page was published