EP_J_UPD_SUB

(SQL View)
 Index Back

Document Item

ePerformance 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

  • Parent record: EP_APPR_SECTION

    • # 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