EPO_PG_SECTN_VW (SQL View)	Index Back
Objectives Page Item Holds the Item information for the Objectives Pages

EPO_PG_SECTN_VW

(SQL View)

Objectives Page Item

Holds the Item information for the Objectives Pages

SELECT A.EPO_PAGE_ID , A.EPO_SECTION_TYPE , C.DESCR50 FROM PS_EPO_PG_SECTION A , PS_EPO_PG_HDR B , PS_EPO_SECTN_DEFN C WHERE A.EPO_PAGE_ID = B.EPO_PAGE_ID AND A.EFFDT = B.EFFDT AND A.EPO_SECTION_TYPE = C.EPO_SECTION_TYPE AND C.EFFDT <= A.EFFDT AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EPO_PG_SECTION A1 WHERE A1.EPO_PAGE_ID = A.EPO_PAGE_ID AND A1.EPO_SECTION_TYPE = A.EPO_SECTION_TYPE AND A1.EFFDT <= %CurrentDateIn)

Parent record: 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
Prompt Table: EPO_PG_HDR

2 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type
Prompt Table: EPO_SECTN_DEFN

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	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 Prompt Table: EPO_PG_HDR
2	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type Prompt Table: EPO_SECTN_DEFN
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50