EPO_NO_HIST_VW (SQL View)	Index Back
Historical effective dated pgs Objectives view used as a prompt table for the View History button on the Update Obj Pages component. This view selects NO rows so when the page has no history, no rows will display in the dropdown list.

EPO_NO_HIST_VW

(SQL View)

Historical effective dated pgs

Objectives view used as a prompt table for the View History button on the Update Obj Pages component. This view selects NO rows so when the page has no history, no rows will display in the dropdown list.

SELECT HDR.EPO_PAGE_ID , HDR.EFFDT FROM PS_EPO_PG_HDR HDR WHERE 1 = 2

# 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

#	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