Facility, 137 (ver3.6.1)
This table stores building information or other such areas to be used as facilities. This is copied from ScheduleFacilities when the schedule is published.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | Varchar(30) | Description of the facility. Although required it could be anything such as a Theatre, Gym, etc. that can be used for scheduling special requirements. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
RoomType_GUID | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |