EP_TMPL_ROLE_EC

(SQL Table)
Index Back

Template Section Role: Setup

Template Section Role: Setup - Used to create/update template section roles.

  • Parent record: EP_TMPL_SECTION
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

    Prompt Table: EP_REVW_TYP_VW

    2 EP_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

    Prompt Table: EP_SECTION_DEFN

    5 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

    Prompt Table: EP_NO_ROLES_VW

    6 EP_ITEM_ADD_EC_SW Character(1) VARCHAR2(1) NOT NULL Y/N switch for ePerformance Section, to allow Items to be Added in the Establish Criteria document

    Y/N Table Edit

    Default Value: N

    7 EP_ITEM_UPD_EC_SW Character(1) VARCHAR2(1) NOT NULL Y/N switch for ePerformance Section, to allow Items to be Updated in the Establish Criteria document

    Y/N Table Edit

    Default Value: N

    8 EP_ITEM_DEL_EC_SW Character(1) VARCHAR2(1) NOT NULL Y/N switch for ePerformance Section, to allow Items to be Deleted in the Establish Criteria document

    Y/N Table Edit

    Default Value: N

    9 EP_CPY_OBJ_EC_SW Character(1) VARCHAR2(1) NOT NULL Y/N switch for ePerformance Section, to allow Items to be Copied in the Establish Criteria document

    Y/N Table Edit

    Default Value: N

    10 EP_CPY_MGR_EC_SW Character(1) VARCHAR2(1) NOT NULL Y/N switch for ePerformance Section, to allow Items to be Copied in the Establish Criteria document

    Y/N Table Edit

    Default Value: N

    11 EP_CPY_ITMS_EC_SW Character(1) VARCHAR2(1) NOT NULL Y/N switch for ePerformance Section, to allow Items to be Copied in from another document

    Y/N Table Edit

    Default Value: N

    12 EP_VIEW_OTHR_EC_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch used to determine if Participant Feedback info is displayed on the Define Criteria page

    Y/N Table Edit

    Default Value: N