EPO_SECTN_DEFN

(SQL Table)
Index Back

Objective Page Sections

Section definition for Objective Pages

  • Related Language Record: EPO_SECTN_LANG
  • # 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