EP_PARTIC_VW (SQL View)	Index Back
Document Role This view excludes Employee and Manager roles

EP_PARTIC_VW

(SQL View)

Document Role

This view excludes Employee and Manager roles

SELECT EP_APPRAISAL_ID , EP_ROLE , EP_REVIEWER_ID , EP_DUE_DT , EP_REVIEW_STATUS , EP_SHOW_TO_EE_FLG , EP_CREATE_DTTM , EP_CREATE_OPRID , LASTUPDDTTM , LASTUPDOPRID FROM PS_EP_APPR_ROLE WHERE EP_ROLE NOT IN ('E', 'M')

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=Shared with Employee
CA=Canceled
CO=Completed
EC=Define Criteria
IP=Evaluation in Progress
NS=Not Started
PA=Approval
RH=Pending Acknowledgement
TP=Track Progress
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=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress 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.