EPO_PLAN_DPT_VW (SQL View)	Index Back
Objective Plan - Setids This table holds the Setids for the Objective Plan. Only used when the Objective Plan is defined using a Department Hierarchy.

EPO_PLAN_DPT_VW

(SQL View)

Objective Plan - Setids

This table holds the Setids for the Objective Plan. Only used when the Objective Plan is defined using a Department Hierarchy.

SELECT EPO_OBJ_PLAN , SETID , TREE_NAME FROM PS_EPO_PLAN_DEPT

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: EPO_TREESET_VW

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: EPO_TREEDEFN_VW

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: EPO_TREESET_VW
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: EPO_TREEDEFN_VW