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. |
Parent Topic:Installed with Facilities Service Management