PER EEO Consolidated

Description
Categories: BI Publisher, Human Resources
Columns: C Hlmale, C Hlfemale, C Wmale, C Bmale, C Hmale, C Amale, C Imale, C Tmracesmale, C Wfemale, C Bfemale ...
Application: Human Resources
Source: EEO Consolidated Report (XML)
Short Name: PERRPEOC_XML
DB package: PER_PERUSEOC_XMLP_PKG
select count(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),3,
                               decode(peo.sex,'M',1,null),null))   "c_hlmale",
  count(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),3,
        decode(peo.sex,'F',1,null),null))   "c_hlfemale",
  count(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),1,
        decode(peo.sex,'M',1,null),null))  "c_wmale",
  count(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),2,
        decode(peo.sex,'M',1,null),null))   "c_bmale",
  count(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),5,
        decode(peo.sex,'M',1,null),null))   "c_hmale",
  count(decode(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),4,
        decode(peo.sex,'M',1,null),null))   "c_amale",
  count(decode(per_us_hr_utility_pkg