EP_OC_NAME_VW

(SQL View)

SELECT A.EP_APPRAISAL_ID , A.EP_ROLE , A.EP_REVIEWER_ID , B.NAME_DISPLAY , C.EP_TRK_ANM_EE_SW , C.EP_TRK_ANM_MGR_SW FROM PS_EP_APPR_ROLE A , PS_PERSON_NAME B , PS_EP_APPR_PARTIC C WHERE A.EP_REVIEWER_ID = B.EMPLID AND A.EP_APPRAISAL_ID = C.EP_APPRAISAL_ID AND A.EP_ROLE = C.EP_ROLE

# 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

3 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
Prompt Table: EP_REVWR_ID_VW

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

5 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.

6 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.

#	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
3	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID Prompt Table: EP_REVWR_ID_VW
4	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
5	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.
6	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.