LM_POSITION_NBRLM_JOB_FAMILYSETIDLM_JOB_TASKEFFDTDefault Value: %date
LM_ROLE_HR_VW(SQL View) |
Index Back |
|---|---|
Competencies of RoleCM_ROLE_COMPS is a table that contains the competencies or competency clusters that profile a role (position, jobcode, job task, or job family). |
| SELECT DISTINCT A.LM_POSITION_NBR , A.LM_JOB_FAMILY ,A.SETID , A.LM_JOB_TASK , A.EFFDT , A.LM_HR_JOBCODE FROM PS_LM_ROLE_COMPS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LM_ROLE_COMPS B WHERE B.LM_POSITION_NBR = A.LM_POSITION_NBR AND B.LM_JOB_FAMILY = A.LM_JOB_FAMILY AND B.SETID = A.SETID AND B.LM_HR_JOBCODE = A.LM_HR_JOBCODE AND B.LM_JOB_TASK = A.LM_JOB_TASK AND B.EFFDT <= %CurrentDateIn AND B.LM_OBJV_ID = A.LM_OBJV_ID AND B.LM_CM_CLUSTER = A.LM_CM_CLUSTER) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_POSITION_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Position Number |
| 2 | LM_JOB_FAMILY |
Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | LM_JOB_TASK |
Character(6) | VARCHAR2(6) NOT NULL | Job Task |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | LM_HR_JOBCODE | Character(15) | VARCHAR2(15) NOT NULL | Job Code in Human Resources |