LM_EXT_CDLM_RATING_MODELLM_REVIEW_RATINGLM_REVIEW_RTGS(SQL View) |
Index Back |
|---|---|
LM_RATINGSrating view |
| SELECT A.LM_EXT_CD , A. LM_RATING_MODEL ,B.LM_REVIEW_RATING ,B.LM_REVIEW_POINTS FROM PS_LM_OBJV_EXT_SRC A , PS_LM_RVW_RTNG_TBL B WHERE A.LM_EXT_SRC_CD='HRCOMP' AND A.LM_RATING_MODEL=B.LM_RATING_MODEL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_EXT_CD |
Character(30) | VARCHAR2(30) NOT NULL | External objective code |
| 2 | LM_RATING_MODEL |
Character(4) | VARCHAR2(4) NOT NULL | Used in Competency Sync messages |
| 3 | LM_REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |
| 4 | LM_REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Points for Rating models from HRMS |