EP_MSS_CUR_VW (SQL View)	Index Back
Current Doc Selection View This view is used to display current documents available for selection

EP_MSS_CUR_VW

(SQL View)

Current Doc Selection View

This view is used to display current documents available for selection

SELECT DISTINCT A.EMPLID , A.EP_APPRAISAL_ID , A.EMPL_RCD , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , A.EP_REVIEW_TYPE , A.EP_TEMPLATE_ID , A.EP_TMPL_EFFDT , A.EP_REVIEW_STATUS , A.EP_APPROVAL_STATUS , A.EP_EE_REVIEW_FLG , A.EP_EMPL_ACK_IND , A.EP_EMPL_ACK_DT , A.RATING_MODEL , A.REVIEW_RATING , A.EP_PRE_REVW_RATING , A.EP_MANAGER_ID , D.EP_DOC_USAGE_IND , C.NAME_DISPLAY , C.NAME_DISPLAY_SRCH FROM PS_EP_APPR A , PS_EP_REVW_TYP_TBL D , PS_PERSON_NAME C WHERE A.EP_REVIEW_TYPE = D.EP_REVIEW_TYPE AND A.EMPLID = C.EMPLID AND (A.EP_REVIEW_STATUS <> 'CO' AND A.EP_REVIEW_STATUS <> 'CA')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date

5 PERIOD_END_DT Date(10) DATE Period End Date

6 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type
Prompt Table: EP_REVW_TYP_VW

7 EP_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier

8 EP_TMPL_EFFDT Date(10) DATE the effdt of the Template

9 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

10 EP_APPROVAL_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
APRV=Approved
DENY=Denied
ERRO=Approval Error
NREQ=Not Required
OPEN=Not Submitted
SUBM=Submitted

11 EP_EE_REVIEW_FLG Character(2) VARCHAR2(2) NOT NULL Field used to determine the process flow for a performance review.
01=Apvl Before Review-5 Steps
02=Apvl After Review-4 Steps
03=No Apvl with Review-4 Steps
04=No Apvl No Review
05=Apvl No Review
06=No Apvl with Review-2 Steps
07=Apvl Before Review-3 Steps
08=Apvl After Review-3 Steps

12 EP_EMPL_ACK_IND Character(4) VARCHAR2(4) NOT NULL This field tracks whether an employee has acknowledged that a review has been held. Note that it does not indicate whether the employee agrees with the content of the review.
ACKN=Employee Acknowledged
NREQ=Not Required
OPEN=Open
OVRD=Manager Override
RFSD=Employee Refused

13 EP_EMPL_ACK_DT Date(10) DATE This field tracks the date that the employee acknowledged that a review has been held.

14 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

15 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
Prompt Table: REVW_RATING_TBL

16 EP_PRE_REVW_RATING Character(1) VARCHAR2(1) NOT NULL Preliminary Review Rating Code (character).
Prompt Table: REVW_RATING_TBL

17 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.

18 EP_DOC_USAGE_IND Character(1) VARCHAR2(1) NOT NULL Indicator used to determine what document types are available for performance assessments and which are available for development assessments.
D=Development
P=Performance

19 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

20 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
5	PERIOD_END_DT	Date(10)	DATE	Period End Date
6	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
7	EP_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Template unique identifier
8	EP_TMPL_EFFDT	Date(10)	DATE	the effdt of the Template
9	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
10	EP_APPROVAL_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately. APRV=Approved DENY=Denied ERRO=Approval Error NREQ=Not Required OPEN=Not Submitted SUBM=Submitted
11	EP_EE_REVIEW_FLG	Character(2)	VARCHAR2(2) NOT NULL	Field used to determine the process flow for a performance review. 01=Apvl Before Review-5 Steps 02=Apvl After Review-4 Steps 03=No Apvl with Review-4 Steps 04=No Apvl No Review 05=Apvl No Review 06=No Apvl with Review-2 Steps 07=Apvl Before Review-3 Steps 08=Apvl After Review-3 Steps
12	EP_EMPL_ACK_IND	Character(4)	VARCHAR2(4) NOT NULL	This field tracks whether an employee has acknowledged that a review has been held. Note that it does not indicate whether the employee agrees with the content of the review. ACKN=Employee Acknowledged NREQ=Not Required OPEN=Open OVRD=Manager Override RFSD=Employee Refused
13	EP_EMPL_ACK_DT	Date(10)	DATE	This field tracks the date that the employee acknowledged that a review has been held.
14	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
15	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating Prompt Table: REVW_RATING_TBL
16	EP_PRE_REVW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Preliminary Review Rating Code (character). Prompt Table: REVW_RATING_TBL
17	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
18	EP_DOC_USAGE_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator used to determine what document types are available for performance assessments and which are available for development assessments. D=Development P=Performance
19	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
20	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.