EP_TMPL_DEFN

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	EP_TMPL_USE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Product Flag used to distingush between HR Basic templates and ePerformance templates. B=Basic HR E=ePerformance Default Value: E
7	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N
8	EP_REVIEW_ID	Character(8)	VARCHAR2(8) NOT NULL	Review ID Prompt Table: EP_REV_DEF_VW
9	EP_ROUNDING_RULE	Character(1)	VARCHAR2(1) NOT NULL	Used to determine how the review rating will be rounded to the maximum decimal point. D=Round Down S=Standard Rounding U=Round Up Default Value: S
10	EP_DEC_PLACES	Number(1,0)	SMALLINT NOT NULL	Amount of decimal places to take a numeric value out to
11	EP_RATE_MODEL_MAP	Character(1)	VARCHAR2(1) NOT NULL	Mapping used to determine the rating text to display H=Next Highest Rating L=Next Lowest Rating N=Nearest Rating Default Value: N
12	EP_OFFICIAL_SW	Character(1)	VARCHAR2(1) NOT NULL	This Yes/No switch can be set to "Y" by the user to denote that the review is "Official". The setting of this field has no real significance in the application, it is primarily a user-controlled informational field. Y/N Table Edit Default Value: N
13	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: EP_APPR_RULE_VW
14	EP_EE_REVIEW_FLG	Character(2)	VARCHAR2(2) NOT NULL	Field used to determine the process flow for a performance review. 01=Approval Before EE Review Held 02=Approval After EE Review Held 03=No Approval, EE Review Held 04=No Approval, No EE Review Held 05=Approval, No EE Review Held Default Value: 01
15	EP_CALC_RATING_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if a performance review calculates ratings. Y/N Table Edit Default Value: Y
16	EP_LANG_CHECK_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the language checker is used on the manager's performance review. Y/N Table Edit Default Value: N
17	EP_EST_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if the establish criteria step is enabled. Y/N Table Edit Default Value: N
18	EP_EST_UPD_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can update the baseline document during the establish criteria step. Y/N Table Edit Default Value: N
19	EP_EST_UPD_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can update the baseline document during the establish criteria step. Y/N Table Edit Default Value: N
20	EP_EST_CMP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role that determines if an employee or manager can complete the baseline document during the establish criteria step. Prompt Table: EP_ROLE_VW1
21	EP_EST_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which the establish criteria step is due.
22	EP_EST_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of due date - Before or After the period end date. Used for the establish criteria step. A=After Period End Date B=Before Period End Date
23	EP_NOM_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if the nomination process is enabled. Y/N Table Edit Default Value: N
24	EP_NOM_UPD_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can update the nominations list during the nominate participants process. Y/N Table Edit Default Value: N
25	EP_NOM_UPD_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can update the nominations list during the nominate participants process. Y/N Table Edit Default Value: N
26	EP_NOM_SUB_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role that determines if an employee or manager can submit nominations document during the nominate participant process. Prompt Table: EP_ROLE_VW1
27	EP_NOM_TRK_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can track the nomination acceptance/denial/cancellation during the nominate participants process. Y/N Table Edit Default Value: N
28	EP_NOM_TRK_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can track the nomination acceptance/denial/cancellation during the nominate participants process. Y/N Table Edit Default Value: N
29	EP_NOM_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which the nominate participants process is due.
30	EP_NOM_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of due date - Before or After the period end date. Used for the nominate participants process. A=After Period End Date B=Before Period End Date
31	EP_TRK_FDBK_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can track participant feedback during the track participant feedback process. Y/N Table Edit Default Value: N
32	EP_TRK_FDBK_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can track participant feedback during the track participant feedback process. Y/N Table Edit Default Value: N
33	EP_TRK_VIEW_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee can view participant documents during the track participant feedback process. Y/N Table Edit Default Value: N
34	EP_TRK_VIEW_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a manager can view participant documents during the track participant feedback process. Y/N Table Edit Default Value: N
35	EP_VIEW_AVG_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	ePerformance flag Y/N Table Edit Default Value: N
36	EP_VIEW_AVG_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	ePerformance Flag Y/N Table Edit Default Value: N
37	EP_CANCEL_OUT_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if outstanding evaluations and nominations are cancelled when the manager evaluation moves past 'in progress' status. Y/N Table Edit Default Value: N
38	PTAFDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Definition ID Prompt Table: EP_PTAFAW_PRCS