LM_ROLE_COMPS(SQL Table) |
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). |
| # | 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_HR_JOBCODE |
Character(15) | VARCHAR2(15) NOT NULL | Job Code in Human Resources |
| 5 | LM_JOB_TASK |
Character(6) | VARCHAR2(6) NOT NULL | Job Task |
| 6 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | LM_OBJV_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 8 | LM_CM_CLUSTER |
Character(6) | VARCHAR2(6) NOT NULL | Competency Cluster |
| 9 | LM_CM_IMPORTANCE | Character(1) | VARCHAR2(1) NOT NULL |
Compentency Importance
1=1-Low 2=2-Below Average 3=3-Average 4=4-Above Average 5=5-High |
| 10 | LM_COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 11 | LM_CM_IMPRTNCE_NBR | Number(3,0) | SMALLINT NOT NULL | Competency Importance |
| 12 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |
| 13 | LM_FP_SKIL_HIR | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether hiring requirements exist
Y/N Table Edit Default Value: N |
| 14 | LM_FP_SKIL_TEN | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether tenure requirements exist
Y/N Table Edit Default Value: N |
| 15 | LM_FP_SKIL_PRM | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether promotion requirements exist
Y/N Table Edit Default Value: N |