HCR_CM_RL_ACC_I

(SQL View)
Index Back

Accomplishments Role Interf.V

Interface View for accomplishments that profile a role

SELECT A.POSITION_NBR , A.JOB_FAMILY , A.SETID , A.JOBCODE , A.JOB_TASK , A.EFFDT , A.ACCOMPLISHMENT , A.CM_IMPORTANCE FROM PS_CM_ROLE_ACCOMPS A

  • 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

    Prompt Table: %RECNAME_EDIT

    2 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family

    Prompt Table: JOB_FAMILY_TBL

    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    5 JOB_TASK Character(6) VARCHAR2(6) NOT NULL Job Task

    Prompt Table: JOB_TASK_TBL

    6 EFFDT Date(10) DATE NOT NULL Effective Date
    7 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: ACCOMP_TBL

    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

    Default Value: 3