EPO_PSN_FAIL_VW (SQL View)	Index Back
Obj Page Creation-Posn Failed This view is used in the Pages Not Created grid during the creation process to display positions that encountered errors when the creation process was attempted.

EPO_PSN_FAIL_VW

(SQL View)

Obj Page Creation-Posn Failed

This view is used in the Pages Not Created grid during the creation process to display positions that encountered errors when the creation process was attempted.

SELECT EPO_OBJ_PLAN ,POSITION_NBR ,EP_SUCCESS ,EPO_STATUS_RESULT FROM PS_EPO_SELECT_POSN WHERE EP_SUCCESS = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EPO_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field

2 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: EPO_PLN_POSN_VW

3 EP_SUCCESS Character(1) VARCHAR2(1) NOT NULL Successful Creation?
Y/N Table Edit

4 EPO_STATUS_RESULT Character(254) VARCHAR2(254) NOT NULL Official Page Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EPO_OBJ_PLAN	Character(8)	VARCHAR2(8) NOT NULL	Objectives Management: Objective Plan ID field
2	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: EPO_PLN_POSN_VW
3	EP_SUCCESS	Character(1)	VARCHAR2(1) NOT NULL	Successful Creation? Y/N Table Edit
4	EPO_STATUS_RESULT	Character(254)	VARCHAR2(254) NOT NULL	Official Page Status