EPO_TMPL_DEFN(SQL Table) |
Index Back |
|---|---|
Objective Template: SetupTemplate Header: Setup - Used to create/update objective page template definitions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EPO_TEMPLATE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Objectives Template unique identifier |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | TABSET_ID | Character(18) | VARCHAR2(18) NOT NULL | Tab Identifier ID |
| 7 | EP_DISPLAY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Control Display Type of Document whether in Long Page Format or Tab Format
LONG=Long Format Only TABS=Tabs Format Only TOGL=Toggle - Default Long TOGT=Toggle - Default Tabs Default Value: LONG |
| 8 | EPO_DFLT_TITLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Y/N switch for Objectives Default Page Title
Y/N Table Edit Default Value: Y |
| 9 | EPO_PAGE_TITLE | Character(100) | VARCHAR2(100) NOT NULL | Title on the Objectives Page |
| 10 | EPO_COMMENTS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Y/No field for Objective Comments
Y/N Table Edit Default Value: N |
| 11 | EPO_INCL_PIC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Y/N switch for Objectives to include a photo on the Page
Y/N Table Edit Default Value: N |
| 12 | EPO_PIC_NAME_SW | Character(1) | VARCHAR2(1) NOT NULL |
Y/N switch for Objectives for whether there is a name associated to the photo on the Objectives Page
Y/N Table Edit Default Value: N |
| 13 | EPO_PIC_TITLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Y/N switch for Objectives for whether or not there is a Title associated with the photo on the Objectives Page
Y/N Table Edit Default Value: N |