EP_TMPL_PARTIC

#	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_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier Prompt Table: EP_ROLE_TBL
5	EP_DOCUMENT_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a role has a document. Y/N Table Edit Default Value: N
6	EP_PRIMARY_DOC_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if a document is the primary document. Y/N Table Edit Default Value: N
7	EP_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which a review is due
8	EP_DUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of due date - Before or After the period end date A=After Period End Date B=Before Period End Date
9	EP_NOM_MIN	Number(3,0)	SMALLINT NOT NULL	Number that determines what the minimum number of participants can be for a role.
10	EP_NOM_MAX	Number(3,0)	SMALLINT NOT NULL	Number that determines what the maximum number of participants can be for a role.
11	EP_NOM_ANM_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee is kept anonymous to identities of participants during the tracking of the nomination acceptance/denial/cancellation during the nominate participants process. Y/N Table Edit Default Value: N
12	EP_NOM_ANM_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if an employee is kept anonymous to identities of participants during the tracking of the nomination acceptance/denial/cancellation during the nominate participants process. Y/N Table Edit Default Value: N
13	EP_TRK_ANM_EE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if anonymity is maintained during the track participant feedback process for the employee. Y/N Table Edit Default Value: N
14	EP_TRK_ANM_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if anonymity is maintained during the track participant feedback process for the manager. Y/N Table Edit Default Value: N
15	EP_EMPLID_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows EmplID Y/N Table Edit Default Value: N
16	EP_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows step Y/N Table Edit Default Value: N
17	EP_GRADE_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows Employee's salary Plan and Grade Y/N Table Edit Default Value: N
18	EP_DEPTID_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if Document Header shows Department ID Y/N Table Edit Default Value: N
19	EP_WORKLOC_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows work location Y/N Table Edit Default Value: N
20	EP_SERVICEYR_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows Years of Service Y/N Table Edit Default Value: N
21	EP_COMPHISTRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows Compensation History Y/N Table Edit Default Value: N
22	EP_RATEHISTRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows Rating History Y/N Table Edit Default Value: N
23	EP_DISPLAYNAME_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows Compensation History Y/N Table Edit Default Value: N
24	EP_TIME_ENTRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Switch that determines if document header shows Job Time in Entry Y/N Table Edit Default Value: N
25	EP_ALLOW_DOC_SW	Character(1)	VARCHAR2(1) NOT NULL	Y/N switch for ePerformance template, to allow documents to be downloaded in the Evaluation document Y/N Table Edit