CM_ROLE_COMPS_V

(SQL View)
 Index Back

Current Role Competencies - Vw

CM_ROLE_COMPS_V is a view that selects the current competency or cluster profile of 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 , B.competency , B.cm_cluster , B.cm_importance , B.proficiency , B.FP_SKIL_HIR , B.FP_SKIL_TEN , B.FP_SKIL_PRM FROM ps_cm_role A , PS_CM_ROLE_COMPS B WHERE a.position_nbr = B.position_nbr AND a.jobcode = b.jobcode AND a.job_task = b.job_task AND a.job_family = b.job_family AND a.setid=b.setid AND a.effdt = b.effdt

  • 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
    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
    10 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
    11 FP_SKIL_HIR Character(1) VARCHAR2(1) NOT NULL Hiring Requirements
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N