EPO_SECTN_DEFN(SQL Table) |
Index Back |
---|---|
Objective Page SectionsSection definition for Objective Pages |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EPO_SECTION_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Objectives Section type |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
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 |