EP_J_UPD_SUB(SQL View) |
Index Back |
---|---|
Document ItemePerformance table used to store Evaluation Item information. |
SELECT A.EP_APPRAISAL_ID , A.EP_ROLE , A.EP_REVIEWER_ID , A.EP_SECTION_TYPE , A.EP_ITEM_ID , A.EP_SUB_ID , D.PERIOD_END_DT , B.EP_J_ITEM_CAT_TYPE , B.EP_J_SUB_CAT_TYPE , B.EP_J_UPD_JP_TYPE , B.EP_J_UPD_CAT_QUAL , C.RATING_MODEL , A.REVIEW_RATING FROM PS_EP_APPR_SUBITEM A , PS_EP_APPR_SECTION B , PS_EP_APPR_ITEM C , PS_EP_APPR D WHERE A.EP_APPRAISAL_ID = B.EP_APPRAISAL_ID AND A.EP_ROLE = B.EP_ROLE AND A.EP_REVIEWER_ID = B.EP_REVIEWER_ID AND A.EP_SECTION_TYPE = B.EP_SECTION_TYPE AND A.EP_ITEM_ID <> ' ' AND A.EP_SUB_ID <> ' ' AND B.EP_ITEM_UPD_JPM_SW = 'Y' AND B.EP_J_UPD_JP_TYPE <> ' ' 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_SECTION_TYPE = C.EP_SECTION_TYPE AND A.EP_ITEM_ID = C.EP_ITEM_ID AND A.EP_APPRAISAL_ID = D.EP_APPRAISAL_ID |
# | 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
Prompt Table: EP_ROLE_TBL |
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_SUB_ID | Character(12) | VARCHAR2(12) NOT NULL |
Sub-Item unique identifier
Prompt Table: %EDITTABLE |
7 | PERIOD_END_DT | Date(10) | DATE NOT NULL | Period End Date |
8 | EP_J_ITEM_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
Prompt Table: EP_J_CAT_T_IT_I |
9 | EP_J_SUB_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
Prompt Table: EP_J_CAT_T_SB_I |
10 | EP_J_UPD_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table: EP_J_JP_PERS_I |
11 | EP_J_UPD_CAT_QUAL | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance version of the JPM_CAT_ITEM_QUAL. Used to map values to the JPM_CAT_ITEM_QUAL field when updating JPM Profiles with ePerformance items.
Prompt Table: EP_J_QUAL_VW |
12 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table: RATING_MDL_TBL |
13 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |