EP_J_UPD_ITEM

(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 , C.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 , A.RATING_MODEL , A.EP_ITEM_DUE_DT , A.EP_ITEM_REMIND_DT , A.EP_ITEM_MANDTRY_SW , A.EP_ITEM_CRIT_SW , A.EP_WEIGHT , A.EP_MIN_WEIGHT , A.REVIEW_RATING FROM PS_EP_APPR_ITEM A , PS_EP_APPR_SECTION B , PS_EP_APPR C 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 B.EP_ITEM_UPD_JPM_SW = 'Y' AND B.EP_J_UPD_JP_TYPE <> ' ' AND A.EP_APPRAISAL_ID = C.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 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date
    7 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

    8 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

    9 EP_J_UPD_JP_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific field for Profile Type

    Prompt Table: EP_J_JP_PERS_I

    10 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

    11 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

    Prompt Table: RATING_MDL_TBL

    12 EP_ITEM_DUE_DT Date(10) DATE Date that an item is due.
    13 EP_ITEM_REMIND_DT Date(10) DATE Date to remind an item is due.
    14 EP_ITEM_MANDTRY_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch used to determine if the mandatory field is available

    Y/N Table Edit

    Default Value: N

    15 EP_ITEM_CRIT_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch used to determine if the critical field is available

    Y/N Table Edit

    Default Value: N

    16 EP_WEIGHT Number(3,0) SMALLINT NOT NULL Weight factor
    17 EP_MIN_WEIGHT Number(3,0) SMALLINT NOT NULL Minumum weight used (percentage)
    18 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

    Prompt Table: REVW_RATING_TBL