EPO_PAGE_IDEFFDTDefault Value: %date
LANGUAGE_CDEPO_PAGE_SEL_LV(SQL View) |
Index Back |
|---|---|
Obj Page Header Related LangRelated language record for the Objectives Management Header record used in the Objectives Page. |
| SELECT HDR.EPO_PAGE_ID , HDR.EFFDT , HDR.LANGUAGE_CD , HDR.EPO_PAGE_PIC_TITLE , HDR.EPO_PAGE_TITLE , HDR.EPO_PAGE_COMMENTS FROM PS_EPO_PG_HDR_LANG HDR WHERE HDR.EFFDT = ( SELECT MAX ( HDR2.EFFDT ) FROM PS_EPO_PG_HDR_LANG HDR2 WHERE HDR2.EPO_PAGE_ID = HDR.EPO_PAGE_ID ) |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EPO_PAGE_PIC_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Objectives Management: Title of the Page Owner on the Objectives Page |
| 5 | EPO_PAGE_TITLE | Character(100) | VARCHAR2(100) NOT NULL | Title on the Objectives Page |
| 6 | EPO_PAGE_COMMENTS | Long Character | CLOB | Objectives Management: Comments on the Objectives Page |