EPO_PL_DPT_TREE

(SQL View)
Index Back

Objective Plan Dept Tree View

Objective Plan /Setid Tree View

SELECT A.EPO_OBJ_PLAN ,B.SETID ,A.EPO_HIERARCHY_MTHD ,A.DESCR60 ,A.DESCRSHORT ,A.EFF_STATUS ,A.EPO_PLAN_BEGIN_DT ,A.EPO_PLAN_END_DT ,B.TREE_NAME FROM PS_EPO_OBJ_PLAN A , PS_EPO_PLAN_DEPT B WHERE A.EPO_OBJ_PLAN = B.EPO_OBJ_PLAN

# 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
3 EPO_HIERARCHY_MTHD Character(1) VARCHAR2(1) NOT NULL Objective Plan's hierarchy method
D=Department
P=Position
4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 EPO_PLAN_BEGIN_DT Date(10) DATE NOT NULL the Date the Objective Plan begins
8 EPO_PLAN_END_DT Date(10) DATE NOT NULL The date the Objective Plan ends
9 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name