EPO_POS_FLTR_VW(SQL View) |
Index Back |
---|---|
Objectives PositionGets positions for Position filter in MSS Objectives page. |
SELECT HDR.EPO_PAGE_ID , HDR.EPO_PAGE_OWNER_ID , HDR.EPO_PG_UPD_ALT_ID , HDR.EPO_OBJ_PLAN , %Substring(HDR.EPO_NODE_ID, 1, 8) , PD.DESCR , PLN.EPO_PLAN_BEGIN_DT , PLN.EPO_PLAN_END_DT FROM PS_EPO_PG_HDR HDR , PS_EPO_OBJ_PLAN PLN , PS_POSITION_DATA PD WHERE HDR.EPO_OBJ_PLAN = PLN.EPO_OBJ_PLAN AND PLN.EPO_HIERARCHY_MTHD = 'P' AND HDR.EPO_NODE_ID = PD.POSITION_NBR AND %Substring(HDR.EPO_NODE_ID, 1, 8) = PD.POSITION_NBR AND PD.EFF_STATUS = 'A' AND PD.EFFDT = ( SELECT MAX(PD2.EFFDT) FROM PS_POSITION_DATA PD2 WHERE PD2.POSITION_NBR = PD.POSITION_NBR AND PD2.EFFDT <= %CurrentDateIn) AND HDR.EFFDT = ( SELECT MAX(HDR2.EFFDT) FROM PS_EPO_PG_HDR HDR2 WHERE HDR2.EPO_NODE_ID = HDR.EPO_NODE_ID AND HDR2.EFFDT <= %CurrentDateIn) AND HDR.EPO_PAGE_STATUS <> 'I' |
# | 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 | EPO_PAGE_OWNER_ID | Character(11) | VARCHAR2(11) NOT NULL | Objectives Management: Emplid of the person who owns the Objective Page |
3 | EPO_PG_UPD_ALT_ID | Character(11) | VARCHAR2(11) NOT NULL | Objectives Management: Emplid of the person who updates the Objective Page |
4 | EPO_OBJ_PLAN | Character(8) | VARCHAR2(8) NOT NULL | Objectives Management: Objective Plan ID field |
5 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | EPO_PLAN_BEGIN_DT | Date(10) | DATE | the Date the Objective Plan begins |
8 | EPO_PLAN_END_DT | Date(10) | DATE | The date the Objective Plan ends |