EP_TMPL_ROLS_VW

#	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 Default Value: %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_ROLE_TBL
6	EP_SEC_ROLE_RTD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can rate items Y/N Table Edit Default Value: N
7	EP_ITEM_ROLE_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can rate items Y/N Table Edit Default Value: N
8	EP_SUB_ROLE_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can rate sub-items Y/N Table Edit Default Value: N
9	EP_RATING_OVRD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if ratings can be overriden Y/N Table Edit Default Value: N
10	EP_SEC_ROLE_WTD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can weight items Y/N Table Edit Default Value: N
11	EP_ITEM_ROLE_WT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can weight items Y/N Table Edit Default Value: N
12	EP_ITEM_ADD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items can be added Y/N Table Edit Default Value: N
13	EP_ITEM_UPDATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items can be updated by a role for a specific section. This switch is used to lock down a document so it can't be updated (when = 'N'). Y/N Table Edit Default Value: N
14	EP_SECTION_SUMM_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the section is a summary section Y/N Table Edit Default Value: N
15	EP_ITEM_RESULTS_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the results field is available Y/N Table Edit Default Value: N
16	EP_SEC_WRT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine if results writer is used for a section and at what level it is used (competency or sub-competency) C=Competency N=Not Used S=Sub-Competency Default Value: N
17	EP_SEC_DEV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine if development tips are used for a section and at what level it is used (competency or sub-competency). C=Competency N=Not Used S=Sub-Competency Default Value: N
18	EP_SEC_WRT_OTH_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch used to determine if the section Writing Tool for Other Evaluator comments is enabled. Y/N Table Edit Default Value: N
19	EP_SEC_WRT_PRF_SW	Character(1)	VARCHAR2(1) NOT NULL	Performance Notes Y/N Table Edit Default Value: N
20	EP_ITEM_WRT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine if results writer is used for a item and at what level it is used (competency or sub-competency) C=Competency N=Not Used S=Sub-Competency Default Value: N
21	EP_ITEM_DEV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items have a link for development tips. C=Competency N=Not Used S=Sub-Competency Default Value: N
22	EP_ITEM_WRT_OTH_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch used to determine if the item Writing Tool for Other Evaluator comments is enabled. Y/N Table Edit Default Value: N
23	EP_ITEM_WRT_PRF_SW	Character(1)	VARCHAR2(1) NOT NULL	Performance Notes Y/N Table Edit Default Value: N
24	EP_VIEW_OTHER_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if view other authors hyperlink is display on the performance review for a section. Y/N Table Edit Default Value: N
25	EP_RATING_LBL_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the rating label is displayed Y/N Table Edit Default Value: N
26	EP_ITEM_UPD_JPM_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the item/sub-item content for a section should update the JPM Person Profile Y/N Table Edit Default Value: N
27	EP_J_UPD_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	ePerformance specific field for Profile Type Prompt Table: EP_J_JP_PERS_I
28	EP_J_UPD_CAT_QUAL	Character(12)	VARCHAR2(12) NOT NULL	ePerformance version of the JPM_CAT_ITEM_QUAL. Used to map values to the JPM_CAT_ITEM_QUAL field when updating JPM Profiles with ePerformance items. Prompt Table: EP_J_QUAL_VW
29	EP_CPY_OBJ_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance Template Role Rules to allow Objective Items to be copied to Evaluation Docs Y/N Table Edit Default Value: N
30	EP_CPY_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance Section, to allow Items to be Copied from the Manager's Evaluation document Y/N Table Edit Default Value: N
31	EP_ITEM_DEL_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance Section, to allow Items to be Deleted in the Evaluation document Y/N Table Edit Default Value: N
32	EP_EE_ROLE_RATE_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role has the ability to have an Employee Rating during the Evaluation step Y/N Table Edit Default Value: N
33	EP_SEC_EE_CMNTS_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role has the ability to have Employee Section Comments during the Evaluation Step Y/N Table Edit Default Value: N
34	EP_ITM_EE_CMNTS_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role has the ability to have Employee Item Comments during the Evaluation step Y/N Table Edit Default Value: N
35	EP_HAS_EV_RULES_SW	Character(1)	VARCHAR2(1) NOT NULL	Has Eval Role Rules Default Value: Y
36	EP_CPY_ITMS_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance Section, to allow Items to be Copied from another document Y/N Table Edit Default Value: N
37	EP_RATING_REQ	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if ratings can be overriden Y/N Table Edit Default Value: N
38	EP_SEC_CMT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if ratings can be overriden Y/N Table Edit Default Value: N
39	EP_ITM_CMT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if ratings can be overriden Y/N Table Edit Default Value: N
40	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
41	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
42	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
43	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
44	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
45	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
46	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
47	EP_ITEM_ADD_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Whether or not the role can Add Items in the Track Progress step Y/N Table Edit Default Value: N
48	EP_ITEM_UPD_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Whether or not the Role can Update Items in the Track Progress Step Y/N Table Edit Default Value: N
49	EP_ITEM_DEL_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Whether or not the Role can Delete Items during the Track Progress step Y/N Table Edit Default Value: N
50	EP_CPY_OBJ_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Copy Objective Items Y/N Table Edit Default Value: N
51	EP_CPY_MGR_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Whether or not the Role can copy Manager's Items during the Track Progress step Y/N Table Edit Default Value: N
52	EP_ITM_CMNTS_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role is enabled to have comments at the item level in the Track Progress step Y/N Table Edit Default Value: N
53	EP_SEC_CMNTS_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role is enabled to have comments at the Section level in the Track Progress step Y/N Table Edit Default Value: N
54	EP_ITM_NOTES_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role is enabled for Performance Notes at the Item level in the Track Progress step Y/N Table Edit Default Value: N
55	EP_SEC_NOTES_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	whether or not the role is enabled for Performance Notes at the Section level during the Track Progress step Y/N Table Edit Default Value: N
56	EP_CPY_ITMS_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Whether or not the Role can copy Items from other documents during the Track Progress step Y/N Table Edit Default Value: N
57	EP_VIEW_OTHR_TP_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if Participant Feedback info is displayed on the Track Progress page Y/N Table Edit Default Value: N
58	EP_SEC_TP_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch track progress section rate items Y/N Table Edit Default Value: N
59	EP_ITEM_TP_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can rate items Y/N Table Edit Default Value: N
60	EP_SUB_TP_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can rate sub-items Y/N Table Edit Default Value: N