Business rules installed with Facilities Service Management

A business rule is a server-side script that runs when a record is displayed, inserted, updated, deleted, or when a table is queried.

Facilities Service Management adds the following business rules.
Business rule Table Description
Building Utilization Building

[alm_building]

Ensures that utilization thresholds are set to numbers from 0 through 100.
Update User Primary Location Associated User

[fm_m2m_user_to_space]

Updates the sys user records location to the current primary location for the user in the fm_m2m_user_to_space table.
Reference Area Facility Space

[fm_space]

Calculates the area in common units for the space.
Prevent ancestry loop Facility Space

[fm_space]

Prevents circular space definitions where a space is both a parent and child at the same time.
Rollup Facility Space

[fm_space]

Rolls up the space information to level as info is changed on the space.
Rollup Level

[fm_level]

Rolls up level information to the building.
Floor Utilization Level

[fm_level]

Ensures that utilization thresholds are set to numbers from 0 through 100.
Rollup Associated User

[fm_m2m_user_to_space]

Updates the space utilization on a space as users are added and removed from spaces.
Reference area Campus

[fm_campus]

Calculates the area in common units for the space.
update space display name Building

[alm_building]

Generates the full display name for the space.
Max Occupancy Building

[alm_building]

Max occupancy cannot be less than 0.
Rollup Building

[alm_building]

Rolls up building data to the campus.
Request Autoclose Facilities Request

[facilities_request]

Automatically closes requests that are resolved and have not been updated in the 1 day. This number is a property in System Properties.
Facilities Primary Location Change User

[sys_user]

Updates the fm_m2m_user_to_space table when the location on the sys_user records changes.
Max Occupancy Facility Space

[fm_space]

Max occupancy cannot be less than 0.
Prevent duplicates Facility Zone

[fm_zone]

Do not allow the same space to be added to a single zone more than once.
Prevent duplicates Associated User

[fm_m2m_user_to_space]

Do not allow the same user to be added to the same space more than once.
Prevent multiple main level for building Level

[fm_level]

Do not allow there to be more than one main level set for levels in a building.
Update primary location Associated User

[fm_m2m_user_to_space]

Helps keep the sys user and fm_m2m_users_to_space tables in synchronization when primary location changes.
Facilities area unit option changed Facility Space

[fm_space]

Converts` square feet to square meters
update space display name Level

[fm_level]

Updates display name as building and level name changes
Reference Area Facility Space

[fm_space]

Calculates the area in common units for the spaces.
Max Occupancy Facility Space

[fm_space]

Max occupancy cannot be less than 0.
Reference Area Facility Space

[fm_space]

Calculates the area in common units for the space.
Space - generate full name Facility Space

[fm_space]

Generates the full display name for the space.