EP_FDBK_SUB_VW (SQL View)	Index Back
Subitem Particpant Rating View This view displays all the subitem participant ratings for completed evaluations for all roles except the manager and employee roles.

EP_FDBK_SUB_VW

(SQL View)

Subitem Particpant Rating View

This view displays all the subitem participant ratings for completed evaluations for all roles except the manager and employee roles.

SELECT A.EP_APPRAISAL_ID , A.EP_ROLE , A.EP_REVIEWER_ID , A.EP_SECTION_TYPE , A.EP_ITEM_ID , A.EP_ITEM_SEQ , A.EP_SUB_ID , A.EP_SUB_SEQ , B.EP_TRK_ANM_EE_SW , B.EP_TRK_ANM_MGR_SW , F.EP_SUB_ROLE_RT_SW , A.REVIEW_RATING , D.EP_DESCR FROM PS_EP_APPR_SUBITEM A , PS_EP_APPR_PARTIC B , PS_EP_APPR_ROLE C , PS_EP_ROLE_TBL D , PS_EP_APPR_SECTION F WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND A.EP_ROLE = B.EP_ROLE AND A.EP_APPRAISAL_ID = C.EP_APPRAISAL_ID AND A.EP_ROLE = C.EP_ROLE AND A.EP_REVIEWER_ID = C.EP_REVIEWER_ID AND A.EP_ROLE = D.EP_ROLE AND A.EP_APPRAISAL_ID = F.EP_APPRAISAL_ID AND A.EP_ROLE = F.EP_ROLE AND A.EP_REVIEWER_ID = F.EP_REVIEWER_ID AND A.EP_SECTION_TYPE = F.EP_SECTION_TYPE AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_EP_ROLE_TBL D1 WHERE D1.EP_ROLE = D.EP_ROLE AND D1.EFFDT <= %CurrentDateIn) AND A.EP_ROLE <> 'M' AND A.EP_ROLE <> 'E' AND C.EP_REVIEW_STATUS = 'CO'

# 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_PARTICIPANT Character(8) VARCHAR2(8) NOT NULL Participant unique identifier

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

4 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type
Prompt Table: EP_SECTION_DEFN

5 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
Prompt Table: %EDITTABLE

6 EP_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Item sequence number
Default Value: 1

7 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
Prompt Table: %EDITTABLE

8 EP_SUB_SEQ Number(2,0) SMALLINT NOT NULL Sub-Item sequence number
Default Value: 1

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

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

11 EP_SUB_ROLE_RT_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch used to determine if the role for a section can rate sub-items
Y/N Table Edit
Default Value: N

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

13 EP_DESCR Character(30) VARCHAR2(30) NOT NULL Description field used in ePerformance.

#	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_PARTICIPANT	Character(8)	VARCHAR2(8) NOT NULL	Participant unique identifier
3	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID Prompt Table: EP_REVWR_ID_VW
4	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type Prompt Table: EP_SECTION_DEFN
5	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier Prompt Table: %EDITTABLE
6	EP_ITEM_SEQ	Number(2,0)	SMALLINT NOT NULL	Item sequence number Default Value: 1
7	EP_SUB_ID	Character(12)	VARCHAR2(12) NOT NULL	Sub-Item unique identifier Prompt Table: %EDITTABLE
8	EP_SUB_SEQ	Number(2,0)	SMALLINT NOT NULL	Sub-Item sequence number Default Value: 1
9	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.
10	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.
11	EP_SUB_ROLE_RT_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No switch used to determine if the role for a section can rate sub-items Y/N Table Edit Default Value: N
12	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating Prompt Table: REVW_RATING_TBL
13	EP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description field used in ePerformance.