UPG_ROLE_COMPS

(SQL Table)
 Index Back

Upgrade Only - Legacy Backup

Upgrade Only - Legacy Backup This table holds a backup of Legacy Data created during the upgrade to Profile Management 9.0. When the customer is satisfied with the upgrade or no longer needs a copy of the prior data, this table should be dropped from the Database.

  • 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 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    8 CM_CLUSTER Character(6) VARCHAR2(6) NOT NULL Competency Cluster

    Prompt Table: CM_CLUSTER_TBL

    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 CM_IMPORTANCE_NBR Number(3,0) SMALLINT NOT NULL Competency Importance
    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