EPO_PG_UPD_ALT_IDLANGUAGE_CDEPO_ALT_NAME_LV(SQL View) |
Index Back |
|---|---|
Alternate Editor |
| SELECT DISTINCT A.EPO_PG_UPD_ALT_ID , B.LANGUAGE_CD , B.NAME_DISPLAY FROM PS_EPO_PG_HDR A , PS_NAMES_LNG B WHERE A.EPO_PG_UPD_ALT_ID = B.EMPLID AND A.EPO_PAGE_STATUS <> 'I' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_EPO_PG_HDR A2 WHERE A2.EPO_PAGE_ID = A.EPO_PAGE_ID AND A2.EFFDT <= %CurrentDateIn) AND B.NAME_TYPE = 'PRI' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_NAMES_LNG B2 WHERE B2.EMPLID = B.EMPLID AND B2.NAME_TYPE = B.NAME_TYPE AND B2.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EPO_PG_UPD_ALT_ID |
Character(11) | VARCHAR2(11) NOT NULL | Objectives Management: Emplid of the person who updates the Objective Page |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |