EP_FDBK_ITM_VW(SQL View) |
Index Back |
|---|---|
Item Participant Fdbk ViewThis view displays all the Item 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_ITEM_ID , A.EP_ITEM_SEQ , B.EP_TRK_ANM_EE_SW , B.EP_TRK_ANM_MGR_SW , F.EP_ITEM_ROLE_RT_SW , F.EP_ITEM_RESULTS_SW , A.REVIEW_RATING , D.EP_DESCR , A.EP_RESULTS FROM PS_EP_APPR_ITEM 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_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. |
| 8 | 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. |
| 9 | 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 |
| 10 | 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 |
| 11 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 12 | EP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description field used in ePerformance. |
| 13 | EP_RESULTS | Long Character | CLOB | Results statement |