The Personnel & Occupancy/Background Data/Update Employee Headcounts task runs the following calculations:
|
Name |
Definition |
Result Tables and Columns |
Calc Tables and Columns |
Filter Tables and Columns |
|
Room |
||||
|
Employee Headcount |
Number of employees in room |
count_em |
count(em.em_id) |
em.rm_id = rm.rm_id |
|
Employee |
||||
|
Allocated Room Area |
Area of room divided by the employee headcount |
area_rm |
rm.area / rm.count_em |
em.rm_id = rm.rm_id |
|
Floor |
||||
|
Employee Headcount |
Number of employees on floor |
count_em |
count(em.em_id) |
em.fl_id = fl.fl_id |
|
Building |
||||
|
Employee Headcount |
Number of employees in building |
count_em |
sum(fl.count_em) |
fl.bl_id = bl.bl_id |
|
Site |
||||
|
Employee Headcount |
Number of employees at site |
count_em |
sum(bl.count_em) |
bl.site_id = site.site_id |
|
Division and Department |
||||
|
Employee Headcount |
Number of employees in division, department |
count_em |
count(em.em_id) |
em.dp_id = dp.dp_id and em.dv_id = dv.dv_id |
|
Business Unit |
||||
|
Employee Headcount |
Number of employees in business unit |
count_em |
sum(dv.count_em) |
dv.bu_id = bu.bu_id |
|
Room Type, Category, Standard |
||||
|
Employee Headcount |
Number of employees for each room type, category and standard |
count_em |
sum(rm.count_em) |
rm.rm_cat = rmcat.rm_cat and rm.rm_type = rmtype.rm_type and rm.rm_std = rmstd.rm_std |
|
Employee Standard |
||||
|
Employee Headcount |
Number of employees for each employee standard |
count_em |
count(em.em_id) |
em.em_std = emstd.em_std |