CM_ROLE_COMP_VW(SQL View) |
Index Back |
---|---|
Competencies of RoleCM_ROLE_COMP_VW is a view that selects the competencies that profile 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.competency , A.cm_cluster , A.cm_importance , A.cm_importance_nbr , A.proficiency , A.FP_SKIL_HIR , A.FP_SKIL_TEN , A.FP_SKIL_PRM FROM PS_CM_ROLE_COMPS A WHERE A.COMPETENCY <> ' ' |
# | 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 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
8 | CM_CLUSTER | Character(6) | VARCHAR2(6) NOT NULL | Competency Cluster |
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 |
12 | FP_SKIL_HIR | Character(1) | VARCHAR2(1) NOT NULL |
FPS Hiring Requirement
N=No Y=Yes Y/N Table Edit Default Value: N |
13 | FP_SKIL_TEN | Character(1) | VARCHAR2(1) NOT NULL |
FPS Tenure Requirement
N=No Y=Yes Y/N Table Edit Default Value: N |
14 | FP_SKIL_PRM | Character(1) | VARCHAR2(1) NOT NULL |
FPS Promotion Requirement
N=No Y=Yes Y/N Table Edit Default Value: N |