CAN_NOC_TBL

(SQL Table)
 Index Back

CAN National Occupation Codes

Canada only. CAN_NOC_TBL contains the National Occupational Classificaton Codes and the occupational group that the NOC belongs to. This functionality is located in the Regulatory Requirements Canada application.

  • Related Language Record: CAN_NOC_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CAN_NOC_OCC_GROUP Character(2) VARCHAR2(2) NOT NULL NOC Occupational Group
    01=Senior Managers
    02=Middle and Other Managers
    03=Professionals
    04=Semi-Professions & Technicns
    05=Supervisors
    06=Supv-Crafts & Trades
    07=Admin & Senior Clerical
    08=Skilled Sales & Service
    09=Skilled Crafts and Trades
    10=Clerical Personnel
    11=Intermediate Sales & Service
    12=Semi-Skilled Manual Workers
    13=Other Sales & Service
    14=Other Manual Workers
    6 SKILL_LEVEL Character(1) VARCHAR2(1) NOT NULL Can OEE Skill Level
    A=Skill Level A
    B=Skill Level B
    C=Skill Level C
    D=Skill Level D
    N=Not Applicable
    7 SKILL_TYPE Character(2) VARCHAR2(2) NOT NULL Can OEE Skill Type
    8 TEER_CAT Character(2) VARCHAR2(2) NOT NULL TEER Category
    0=Management Occupations
    1=Occupations/University Degree
    2=Occup/Dipl/2+App/Supvr Occup
    3=Occup/Dipl/<2App/6 Mth OTJ Trn
    4=Occup/HS Dipl/Sevrl Wk OTJ Trn
    5=Occup/ST Work Demo/No Forml Ed