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_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence number Default Value: 10
6	EP_SECTION_RTD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the section can be rated Y/N Table Edit Default Value: N
7	EP_SECTION_WTD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the section can be weighted Y/N Table Edit Default Value: N
8	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
9	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
10	EP_SPCL_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Special processing used for a review section E=Employee Comments L=Learning M=Manager Comments N=None O=Overall Summary S=Signatures 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_CRIT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the critical field is available Y/N Table Edit Default Value: N
13	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
14	EP_ITEM_INIT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the initialize from job profile is allowed Y/N Table Edit Default Value: N
15	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
16	EP_ITEM_MANDTRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the mandatory field is available Y/N Table Edit Default Value: N
17	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
18	EP_ITEM_OWNER_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to Y/N Table Edit Default Value: N
19	EP_ITEM_MIN_WT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the minimum weight field is available Y/N Table Edit Default Value: N
20	EP_ITEM_REMIND_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the reminder date field is available Y/N Table Edit Default Value: N
21	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
22	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
23	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
24	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
25	EP_J_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	ePerformance specific field for Profile Type Prompt Table: EP_J_JP_NPERS_I
26	EP_ITEM_PROMPT	Character(15)	VARCHAR2(15) NOT NULL	Prompt table used to populate an item Prompt Table: EP_REC_ITEM_VW
27	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
28	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
29	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
30	EP_SUB_PROMPT	Character(15)	VARCHAR2(15) NOT NULL	Sub-Item prompt record Prompt Table: EP_REC_SUB_VW
31	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model Prompt Table: RATING_MDL_TBL
32	EP_CALC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Calculation method used - Summary, Average, Review Band A=Average R=Review Band S=Summation
33	EP_LINK_SECTION	Character(8)	VARCHAR2(8) NOT NULL	The section to link items to Prompt Table: EP_SECTION_DEFN
34	EP_ALL_ITEMS_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if all items use the same Rating Model Y/N Table Edit Default Value: N
35	EP_PRELIM_RTG_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the preliminary rating field is available Y/N Table Edit Default Value: N
36	EP_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Weight factor
37	EP_MIN_WEIGHT	Number(3,0)	SMALLINT NOT NULL	Minumum weight used (percentage)
38	EP_JOB_PROFILE_SRC	Character(1)	VARCHAR2(1) NOT NULL	Determines if the job profile is used and where the it comes from C=Job Code F=Job Family N=Not Used P=Position S=Salary Grade Default Value: N
39	EP_ITEM_RTD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items are rated Y/N Table Edit Default Value: N
40	EP_ITEM_TARGET_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items are rated for Target Rating Y/N Table Edit Default Value: N
41	EP_ITEM_WTD_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items are weighted Y/N Table Edit Default Value: N
42	EP_ITEM_ADD_EST_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if items can be added for a section by a specific role during the Establish Criteria process. Y/N Table Edit Default Value: N