EP_APPRAISAL_IDEP_REVIEWER_IDEP_ITEM_IDEP_COMP_RTD_VW(SQL View) |
Index Back |
|---|---|
Appraisal Rated CompetenciesSelects competencies that were rated in an ePM appraisal for posting to the Competency Management module. |
| SELECT A.EP_APPRAISAL_ID , A.EP_REVIEWER_ID , A.EP_ITEM_ID , A.REVIEW_RATING , C.EMPLID , C.PERIOD_END_DT FROM PS_EP_APPR_ITEM A , PS_EP_APPR_SECTION B , PS_EP_APPR C WHERE A.EP_ITEM_ID <> ' ' AND A.REVIEW_RATING <> ' ' AND %Join(COMMON_KEYS, EP_APPR_SECTION B, EP_APPR_ITEM A) AND B.EP_ROLE = 'M' AND B.EP_SPCL_PROCESS = 'C' AND %Join(COMMON_KEYS, EP_APPR C, EP_APPR_ITEM A) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | EP_REVIEWER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Reviewer ID |
| 3 | EP_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
| 4 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | PERIOD_END_DT | Date(10) | DATE | Period End Date |