EP_APPR_TASK (SQL Table)	Index Back
Task - Dcoument association Table to keep track of which Tasks are associated to which ePerformance documents. Only used if installation is using ePerf Integration to Microsoft Outlook

EP_APPR_TASK

(SQL Table)

Task - Dcoument association

Table to keep track of which Tasks are associated to which ePerformance documents. Only used if installation is using ePerf Integration to Microsoft Outlook

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

2 EP_APPR_TYPE Character(3) VARCHAR2(3) NOT NULL Type of ePerformance document: Criteria, Evaluation or Mid-period

3 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

4 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

5 EODI_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Transaction ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_APPR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of ePerformance document: Criteria, Evaluation or Mid-period
3	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier
4	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID
5	EODI_TRANS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Transaction ID