PER Employment Equity Workforce Profile (PDF)

      select decode(
                    pzee.level_cat,
                   'Top Management',
                   'Top management',
                   'Senior Management',
                   'Senior management',
                   'Prof Qualified and Experienced Specialist and Mid-Management',
                   'Professionally qualified and experienced specialists and mid-management',
                   'Skilled, Academic, Jr Mgmt, Supervisors, Foremen and Supts',
                   'Skilled technical and academically qualified workers, junior management, supervisors, foremen, and superintendents',
                   'Semiskilled and Discretionary Decision Making',
                   'Semi-skilled and discretionary decision making',
                   'Unskilled and Defined Decision Making',
                   'Unskilled and defined decision making',
                   'Non-Renewal of Contract',
                   'Non-renewal of contract',
                   'Dismissal - Operational Requirements',
                   'retrenchment - Operational requirements',
                   'Dismissal - Misconduct',
                   'Dismissal - misconduct',
                   'Dismissal - Incapacity',
                   'Dismissal - incapacity',
                    pzee.level_cat
                   )             level_cat,
             pzee.level_cat_code level_cat_code,
             sum(nvl(pzee.ma,0)) ma,
             sum(nvl(pzee.mc,0)) mc,
             sum(nvl(pzee.mi,0)) mi,
             sum(nvl(pzee.mw,0)) mw,
             sum(nvl(pzee.fa,0)) fa,
             sum(nvl(pzee.fc,0)) fc,
             sum(nvl(pzee.fi,0)) fi,
             sum(nvl(pzee.fw,0)) fw,
             sum(nvl(pzee.total,0)) total,
             sum(nvl(pzee1.ma,0) +
                 nvl(pzee1.mc,0) +
                 nvl(pzee1.mi,0) +
                 nvl(pzee1.mw,0)) fm,
             sum(nvl(pzee1.fa,0) +
                 nvl(pzee1.fc,0) +
                 nvl(pzee1.fi,0) +
                 nvl(pzee1.fw,0)) ff,
             sum(nvl(pzee1.total,0)) f_total,
             sum(nvl(pzee1.total,0) + nvl(pzee.total,0)) all_total,
             PER_ZA_EE_WORKFORCE_PROFILE.CF_EQ2_ALL_TOTALFORMULA(:REPORT_ID,sum(nvl(pzee1.total,0) + nvl(pzee.total,0))) CF_EQ2_ALL_TOTAL
        from per_za_employment_equity pzee,
             per_za_employment_equity pzee1
       where pzee.legal_entity_id = :LEGAL_ENTITY_ID
         and pzee.business_group_id = :P_BUSINESS_GROUP_ID
         and pzee.report_id = :REPORT_ID
         and pzee.legal_entity_id = pzee1.legal_entity_id
         and pzee.report_id ||'F' = pzee1.report_id
         and pzee.level_cat_code = pzee1.level_cat_code
         and pzee.level_cat = pzee1.level_cat
         and nvl(pzee.disability,'X') = nvl(pzee1.disability ,'X')
         and pzee.employment_type = pzee1.employment_type
         and pzee.employment_type = 'Permanent'
         and pzee.level_cat_code <> '15'
    group by pzee.level_cat,pzee.level_cat_code
    order by level_cat_code