EP_APPR_PARTIC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID Prompt Table: EP_APPR
2	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier Prompt Table: EP_ROLE_TBL
3	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
4	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
5	EP_DUE_DAYS	Number(3,0)	SMALLINT NOT NULL	Amount of days in which a review is due
6	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
7	EP_NOM_MIN	Number(3,0)	SMALLINT NOT NULL	Number that determines what the minimum number of participants can be for a role.
8	EP_NOM_MAX	Number(3,0)	SMALLINT NOT NULL	Number that determines what the maximum number of participants can be for a role.
9	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
10	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
11	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
12	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
13	EP_DUE_DT	Date(10)	DATE	Date a review is due