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. |