cmn_building
Stores information about buildings or facilities, including addresses and related location details.
Columns
| Name | Type | ReadOnly | References | Description |
| sys_mod_count | String | False |
Tracks the total number of times the building record has been modified in the Common Building (cmn_building) table. | |
| location | String | False |
Specifies the physical location or site associated with the building record, helping identify where the building is situated within the organization's structure. | |
| sys_updated_by | String | False |
Lists the user or process that last updated the building record, providing traceability for changes. | |
| sys_updated_on | Datetime | False |
Displays the date and time when the building record was last updated in the system. | |
| floors | String | False |
Indicates the number of floors or levels within the building. | |
| notes | String | False |
Contains general notes or additional details related to the building, such as maintenance information or occupancy notes. | |
| sys_created_by | String | False |
Lists the user or process that originally created the building record. | |
| name | String | False |
Specifies the official name of the building for identification in facility or location records. | |
| contact | String | False |
Lists the primary contact person responsible for the building. | |
| sys_id [KEY] | String | False |
Provides the system identifier (sys_id) that uniquely identifies the building record in the Common Building (cmn_building) table. | |
| sys_created_on | Datetime | False |
Displays the date and time when the building record was first created in the system. |