LM_POSITION_NBRSETIDLM_HR_JOBCODEEFFDTLM_OBJV_IDLM_ROLE_COMP_VW(SQL View) |
Index Back |
|---|---|
Competencies of RoleJoins role competencies with LM_OBJV_EXT_SRC to bring in rating model and review points for gap comparisons. |
| SELECT LM_POSITION_NBR , A.SETID , A.LM_HR_JOBCODE , A.EFFDT , A.LM_OBJV_ID , A.LM_REVIEW_RATING , A.LM_COMPETENCY FROM PS_LM_ROLE_COMPS A , PS_LM_OBJV_EXT_SRC B WHERE A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_LM_ROLE_COMPS D WHERE D.LM_POSITION_NBR = A.LM_POSITION_NBR AND D.LM_JOB_FAMILY = A.LM_JOB_FAMILY AND D.SETID = A.SETID AND D.LM_HR_JOBCODE = A.LM_HR_JOBCODE AND D.LM_JOB_TASK = A.LM_JOB_TASK AND D.EFFDT <= %CurrentDateIn AND D.LM_OBJV_ID = A.LM_OBJV_ID AND D.LM_CM_CLUSTER = A.LM_CM_CLUSTER) AND B.LM_EXT_SRC_CD = 'HRCOMP' AND B.LM_EXT_CD = A.LM_COMPETENCY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_POSITION_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Position Number |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | LM_HR_JOBCODE |
Character(15) | VARCHAR2(15) NOT NULL | Job Code in Human Resources |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | LM_OBJV_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 6 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |
| 7 | LM_COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency |