EP_TMPL_ROLE_EC(SQL Table) |
Index Back |
---|---|
Template Section Role: SetupTemplate Section Role: Setup - Used to create/update template section roles. |
# | 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 |