EP_FDBK_SEC_VW(SQL View) |
Index Back |
|---|---|
Section Participant FeedbackThis view displays all the section participant feedback 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_SEQ_NUM , B.EP_TRK_ANM_EE_SW , B.EP_TRK_ANM_MGR_SW , A.REVIEW_RATING , D.EP_DESCR , A.EP_SEC_ROLE_RTD_SW , A.EP_ITEM_ROLE_RT_SW , A.EP_SUB_ROLE_RT_SW , A.EP_SECTION_SUMM_SW , A.EP_ITEM_RESULTS_SW , A.EP_RESULTS , A.EP_RATING , A.REVIEW_POINTS FROM PS_EP_APPR_SECTION A , PS_EP_APPR_PARTIC B , PS_EP_APPR_ROLE C , PS_EP_ROLE_TBL D 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_ROLE = D.EP_ROLE 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_REVIEWER_ID = C.EP_REVIEWER_ID 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_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence number
Default Value: 1 |
| 6 | 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. |
| 7 | 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. |
| 8 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 9 | EP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description field used in ePerformance. |
| 10 | EP_SEC_ROLE_RTD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate items
Y/N Table Edit Default Value: N |
| 11 | EP_ITEM_ROLE_RT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate items
Y/N Table Edit Default Value: N |
| 12 | 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 |
| 13 | EP_SECTION_SUMM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section is a summary section
Y/N Table Edit Default Value: N |
| 14 | EP_ITEM_RESULTS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the results field is available
Y/N Table Edit Default Value: N |
| 15 | EP_RESULTS | Long Character | CLOB | Results statement |
| 16 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
| 17 | REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Review Points |