LM_CI_RVRTG_VW

(SQL View)
 Index Back

Adhoc review rating descr

Adhoc review rating descr

SELECT A.LM_CI_ID , A.LM_OBJV_ID , A.LM_REVIEW_RATING ,C.LM_RATING_MODEL , C.DESCR FROM PS_LM_CI_OBJV_TBL A , PS_LM_OBJV_TBL B , PS_LM_RVW_RTNG_TBL C WHERE A.LM_OBJV_ID = B.LM_OBJV_ID AND B.LM_RATING_MODEL = C.LM_RATING_MODEL AND A.LM_REVIEW_RATING = C.LM_REVIEW_RATING AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_LM_RVW_RTNG_TBL C1 WHERE C.LM_RATING_MODEL = C1.LM_RATING_MODEL AND C.LM_REVIEW_RATING = C1.LM_REVIEW_RATING AND C1.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_LM_CI_OBJV_TBL A1 WHERE A.LM_CI_ID = A1.LM_CI_ID AND A.LM_OBJV_ID = A1.LM_OBJV_ID AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record: LM_CI_RVRTG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    3 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
    4 LM_RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Used in Competency Sync messages
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description