POSITION_NBRJOB_FAMILYSETIDJOBCODEJOB_TASKEFFDTCM_CLUSTERPrompt Table: CM_CLUSTER_TBL
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
Default Value: 3
Default Value: 3
CM_ROLE_CLAC_VW(SQL View) |
Index Back |
|---|---|
Role Cluster AccomplishmentsCM_ROLE_CLAC_VW is a view that selects the accomplishments 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.accomplishment , B.cm_importance , B.cm_importance_nbr FROM PS_CM_ROLE_COMPS A , PS_CM_CLUSTER_ACMP 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 | ACCOMPLISHMENT | Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
| 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 |