The SISfm Room Bookings module can optionally access timetable information from a CELCAT (Corbett Engineering Limited Computer-Assisted Timetabling) database, in which it uses the following:
Fields shaded grey are not currently accessed.
Currently ct_event.notes is not accessed.
One or more CELCAT databases can be defined using DbConnectionCELCAT settings. For each, ct_config.week1_date through ct_config.week56_date specify the time period covered. To obtain the timetable for a week, the first database whose time period includes this week is used.
The field ct_room.original_id is matched with the facility database table rm field specified by the BookCELCATRoomKeyField setting.
On a timetable, entries are labelled with ct_module.unique_name, with a tooltip displaying ct_module.name (and ct_event.notes if defined).