EPO_PGHDR_EFF_V

(SQL View)
 Index Back

Obj Page Header Record

Objectives Management Header record for the Objectives Page

SELECT A.EPO_PAGE_ID , A.EFFDT , A.EPO_OBJ_PLAN , A.SETID , A.EPO_NODE_ID , A.EPO_PAGE_OWNER_ID , A.EPO_PAGE_OWNER_RCD , B.NAME , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , A.EPO_PG_UPD_ALT_ID , A.EPO_PAGE_STATUS FROM PS_EPO_PG_HDR A , PS_PERSON_NAME B WHERE A.EPO_PAGE_STATUS = 'P' 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_OWNER_ID = B.EMPLID

# 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_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who owns the Objective Page
7 EPO_PAGE_OWNER_RCD Number(3,0) SMALLINT NOT NULL Page Owner Record Number
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
11 EPO_PG_UPD_ALT_ID Character(11) VARCHAR2(11) NOT NULL Objectives Management: Emplid of the person who updates the Objective Page
12 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