EPO_OBJ_PLAN_V2

(SQL View)
 Index Back

Objective Plan Table

Active Objective Plans

SELECT A.EPO_OBJ_PLAN , A.EPO_HIERARCHY_MTHD , A.DESCR60 , A.DESCRSHORT , A.EFF_STATUS , A.EPO_PLAN_BEGIN_DT , A.EPO_PLAN_END_DT FROM PS_EPO_OBJ_PLAN A WHERE A.EFF_STATUS = 'A'

  • Related Language Record: EPO_OBJPLN_LANG

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

    Default Value: A

    6 EPO_PLAN_BEGIN_DT Date(10) DATE NOT NULL the Date the Objective Plan begins
    7 EPO_PLAN_END_DT Date(10) DATE NOT NULL The date the Objective Plan ends