CM_ROLE_CLCM_VW(SQL View) |
Index Back |
|---|---|
Role Cluster CompetenciesCM_ROLE_CLCM_VW is a view that selects the competencies that are included in the clusters that are required for a role (position, jobcode, job task, or job family) |
| SELECT A.position_nbr , A.job_family , A.setid , A.jobcode , A.job_task , A.effdt , A.cm_cluster , B.competency , B.cm_importance , B.cm_importance_nbr , B.proficiency FROM PS_CM_ROLE_COMPS A , PS_CM_CLUSTER_COMP B WHERE A.CM_CLUSTER <> ' ' AND A.CM_CLUSTER = B.CM_CLUSTER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | JOB_FAMILY |
Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | JOB_TASK |
Character(6) | VARCHAR2(6) NOT NULL | Job Task |
| 6 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 7 | CM_CLUSTER |
Character(6) | VARCHAR2(6) NOT NULL |
Competency Cluster
Prompt Table: CM_CLUSTER_TBL |
| 8 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 9 | CM_IMPORTANCE | Character(1) | VARCHAR2(1) NOT NULL |
Competency Importance
1=1-Low 2=2-Below Average 3=3-Average 4=4-Above Average 5=5-High Default Value: 3 |
| 10 | CM_IMPORTANCE_NBR | Number(3,0) | SMALLINT NOT NULL |
Competency Importance
Default Value: 3 |
| 11 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Proficiency
Prompt Table: REVW_RATING_TBL |