EP_APPR_ROLE (SQL Table)	Index Back
Document Role ePerformance table used to store Evaluation Role information.

EP_APPR_ROLE

(SQL Table)

Document Role

ePerformance table used to store Evaluation Role information.

Parent record: EP_APPR

# 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_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
Prompt Table: EP_REVWR_ID_VW

4 EP_DUE_DT Date(10) DATE Date a review is due

5 EP_REVIEW_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Available for Review
CA=Cancelled
CO=Completed
IP=In Progress
NS=Not Started
RH=Review Held
Default Value: IP

6 EP_SHOW_TO_EE_FLG Character(1) VARCHAR2(1) NOT NULL This field indicates when a Manager's review document is available for Employee review and comment.
Y/N Table Edit
Default Value: N

7 EP_CREATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time a document was created.

8 EP_CREATE_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which created a document.

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID Prompt Table: EP_REVWR_ID_VW
4	EP_DUE_DT	Date(10)	DATE	Date a review is due
5	EP_REVIEW_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately. AK=Acknowledged AR=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held Default Value: IP
6	EP_SHOW_TO_EE_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field indicates when a Manager's review document is available for Employee review and comment. Y/N Table Edit Default Value: N
7	EP_CREATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time a document was created.
8	EP_CREATE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which created a document.
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.