CM_ROLE_COMP_VW

(SQL View)
 Index Back

Competencies of Role

CM_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 <> ' '

  • Parent record: CM_ROLE

    • # 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 Hiring Requirements
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 FP_SKIL_TEN Character(1) VARCHAR2(1) NOT NULL Tenure Requirements
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    14 FP_SKIL_PRM Character(1) VARCHAR2(1) NOT NULL Promotion Requirements
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N