RS_CLUSTERCOMPETENCYPrompt Table: COMPETENCY_TBL
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
Default Value: 3
Default Value: 3
Prompt Table: REVW_RATING_TBL
RS_CLUSTER_COMP(SQL Table) |
Index Back |
|---|---|
Cluster CompetenciesCM_CLUSTER_COMP identifies the competencies of a competency cluster and the importance of each, and the desired employee proficiency. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RS_CLUSTER |
Character(6) | VARCHAR2(6) NOT NULL | Competency Cluster |
| 2 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 3 | RS_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 |
| 4 | RS_IMPORTANCE_NBR | Number(3,0) | SMALLINT NOT NULL |
Competency Importance
Default Value: 3 |
| 5 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Proficiency
Prompt Table: REVW_RATING_TBL |