EPO_PG_SECTION(SQL Table) |
Index Back |
|---|---|
Objectives Page SectionSections on the Objectives Page |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(8,0) | INTEGER NOT NULL |
Objectives Management: Objective Page ID
Prompt Table: EPO_PG_HDR |
|
| 2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 3 | Character(8) | VARCHAR2(8) NOT NULL |
Objectives Section type
Prompt Table: EPO_SECTN_DEFN |
|
| 4 | EP_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 5 | EP_SEC_DESCR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Objectives Management: Yes/No switch used to determine if the Obj Page Section has a Description field
Y/N Table Edit Default Value: N |
| 6 | EP_SECTION_ITEM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section contains items
Y/N Table Edit Default Value: N |
| 7 | EP_J_ITEM_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
Prompt Table: EP_J_CAT_T_IT_I |
| 8 | EP_J_CONTENT_GROUP | Character(12) | VARCHAR2(12) NOT NULL |
Content Group
Prompt Table: JPM_CAT_GRPS_VW |
| 9 | EP_J_CONTENT_GRP_T | Character(15) | VARCHAR2(15) NOT NULL |
Content Group Type
Prompt Table: JPM_CAT_GTYPE |
| 10 | EP_ITEM_FREE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be entered free form
Y/N Table Edit Default Value: N |
| 11 | EP_ITEM_DESCR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the item description field is available
Y/N Table Edit Default Value: N |
| 12 | EP_ITEM_MEASURE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the measure field is available
Y/N Table Edit Default Value: N |
| 13 | EP_ITEM_PCT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the item percentage field is available
Y/N Table Edit Default Value: N |
| 14 | EP_ITEM_STATUS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the status field is available
Y/N Table Edit Default Value: N |
| 15 | JPM_C_LIST_ID | Character(18) | VARCHAR2(18) NOT NULL |
JPM Custom prompt list id
Prompt Table: EPO_CLST_ST_VW |
| 16 | EP_ITEM_LINKED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be linked
Y/N Table Edit Default Value: N |
| 17 | EP_LINK_SECTION | Character(8) | VARCHAR2(8) NOT NULL | The section to link items to |
| 18 | EPO_LINK_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Used to link Objective Pages to Content Items
Prompt Table: EPO_SECTN_VW |
| 19 | EP_ITEM_DUE_DT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the due date field is available
Y/N Table Edit Default Value: N |
| 20 | EP_CR_SUPP_ITEM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch to create a link for a Supporting Item to ePerformance Document
Y/N Table Edit Default Value: N |
| 21 | EP_COPY_ITEM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch to copy Item to ePerformance Document
Y/N Table Edit Default Value: N |
| 22 | EP_COPY_OWNER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch to copy Item to page owner's ePerformance Document
Y/N Table Edit Default Value: N |
| 23 | EP_SECTION_SUB_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section contains subitems
Y/N Table Edit Default Value: N |
| 24 | EP_J_SUB_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
Prompt Table: EP_J_CAT_T_SB_I |
| 25 | EP_SUB_FREE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if subitems can be entered free form
Y/N Table Edit Default Value: N |
| 26 | EP_SUB_DESCR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the subitem description field is available
Y/N Table Edit Default Value: N |
| 27 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 28 | TABSET_ID | Character(18) | VARCHAR2(18) NOT NULL | Tab Identifier ID |
| 29 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 30 | TAB_ID | Character(12) | VARCHAR2(12) NOT NULL |
Folder Tab Identifier
Prompt Table: EPO_TABDTL_VW |
| 31 | TAB_LABEL_TEXT | Character(20) | VARCHAR2(20) NOT NULL | Tab Label Text |
| 32 | SUB_ITEM_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Sub-Item Label Text |
| 33 | DESCRLONG | Long Character | CLOB | Long Description |