Space / Occupancy / Standard Space Chargeback (Non-Transactional)
Update Employee Headcount Calculations (Non-Transactional)
The Occupancy / Background Data / Update Employee Headcounts task runs the following calculations.
Note: You only need to run this task if working with non-Space views referencing the rm.count_em field. All out-of-the-box views in Space calculate the employee count dynamically.
| 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 |