POSITION_NBRJOB_FAMILYSETIDJOBCODEJOB_TASKEFFDTCOMPETENCYCM_CLUSTERCLST_COMPETENCY1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
CM_CLST_COMP_VW(SQL View) |
Index Back |
|---|---|
Role Cluster Competency VWThe CM_CLST_COMP_VW contains one row for each competency in a cluster that has been assigned to a role. |
| SELECT a.position_nbr , a.job_family , a.setid , a.jobcode , a.job_task , a.effdt , a.competency , 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 = 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 | Effective Date |
| 7 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 8 | CM_CLUSTER |
Character(6) | VARCHAR2(6) NOT NULL | Competency Cluster |
| 9 | CLST_COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 10 | 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 |
| 11 | CM_IMPORTANCE_NBR | Number(3,0) | SMALLINT NOT NULL | Competency Importance |
| 12 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL | Proficiency |