CM_ROLE_ACMP_V

(SQL View)
 Index Back

Current Role Accomplishmnt-Vw

CM_ROLE_ACMP_V is a view that selects the current accomplishment 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.accomplishment , B.cm_importance , B.FP_SUBJECT_CD , B.FP_DEGR_REQUIRED , B.FP_SKIL_HIR , B.FP_SKIL_TEN , B.FP_SKIL_PRM FROM ps_cm_role A , PS_CM_ROLE_ACCOMPS 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
    8 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
    9 FP_SUBJECT_CD Character(3) VARCHAR2(3) NOT NULL Subject

    Prompt Table: FPMSUBJECTS

    10 FP_DEGR_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required ?
    N=No
    Y=Yes

    Y/N Table Edit

    11 FP_SKIL_HIR Character(1) VARCHAR2(1) NOT NULL Hiring Requirements
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit