Facility Database

The SISfm facility database has the following structure:


Note that this structure applies if the DbConnectionIFM setting is in effect. If the DbConnectionAFM setting is in effect, SISfm accesses tables sisfm_docs, sisfm_docvers, sisfm_dwgs, sisfm_flds, sisfm_groupsforroles, sisfm_tbls, sisfm_users, sisfm_groups and table sisfm_flds fields sisfm_size, sisfm_type replacing sisfm_ by afm_ in their names.

Unshaded tables and fields form part of the default Archibus data model. Shaded tables and fields must be added and populated if required by the SISfm configuration:

The optional field hpattern_acad containing colour values is accessed in tables rm,rmcat,rmtype,bu,dv,dp, or in any field validation table, if the MapLegendColours setting is set to AFM.

 
Organisation
 
buBusiness Units
bu.bu_id Business Unit Code.
bu.name Business Unit Name.
 
dvDivisions
dv.dv_id Division Code (unique values).
dv.bu_id Business Unit Code.
dv.name Division Name.
dv.head_email Division head email address. Required by the Move Manager module if MoveMethodCostCentre is 2.
 
dpDepartments
dp.dv_id Division Code.
dp.dp_id Department Code.
dv.name Department Name.
dp.dp_fin_id_new Department cost codes, as a comma-separated list of one or more 4 character cost centre codes. Field required by the Move Manager module if MoveMethodCostCentre is the default.
dp.dp_fin_bum_email Department business unit manager email address. Required by the Move Manager module if MoveMethodCostCentre is the default.
 
Space
 
siteSites
site.site_id Site Code.
site.name Site Name.
site.access_group Site access group, as for sisfm_flds.review_group. Optional field, if absent site access control is not available.
site.lonMin
site.latMin
site.lonMax
site.latMax		 Site minimum and maximum longitude and latitude, decimal degrees in the GPS coordinate system. Optional fields, if present Map Enquiry uses them to detect whether its device is within a site.
site.<features> Site features: zero or more additional fields for any features desired. These are referenced according to SiteFeature* settings.
  • Fields with date/time data types are displayed according to the FeatureDateFormat setting.
  • Fields with numeric data types are displayed with their sisfm_flds.decimals decimal places if available.
  • The following case-insensitive feature field values are displayed specially:
       true yes y
       false no n nil
     -    unknown (or null, or empty string)
 
blBuildings
bl.bl_id Building Code (unique values).
bl.site_id Site Code.
bl.name Building Name.
bl.access_group Building access group, as for sisfm_flds.review_group. Optional field, if absent building access control is not available.
bl.build_no Building number, corresponding to the B plus b fields of the location code as defined by the LocCodeFormat setting. This field is used instead of bl_id, which Archibus requires to be unique, so that the same building numbers can be used on different sites.
bl.<area> Building area, the field specified by the BlAreaField setting. This is likely to be an existing building area field.
bl.<features> Building features: as for site features above. These are referenced according to BuildingFeature* settings.
 
flFloors
fl.bl_id Building Code.
fl.fl_id Floor Code.
fl.name Floor Name.
fl.area_gross_ext
fl.area_gross_int		 Floor external and internal gross floor areas. Optional fields, required for Map Compiler to update them (see OverlayFloorGrossAreas).
fl.access_group Floor access group, as for sisfm_flds.review_group. Optional field, if absent floor access control is not available.
fl.fl_order Floor order. Values control the order in which building floors are shown. If values are the same then floors are ordered by fl_id. May be of any data type and have any values.
fl.fl_label Floor label, shown in the Map Enquiry floor selector. Optional field, if absent or if any value for a building is not defined, the floor selector displays floor ID values.
fl.<features> Floor features: as for site features above. These are referenced according to FloorFeature* settings.
 
rmcatRoom Categories
rmcat.rm_cat Room Category Code.
rmcat.description Room Category Description.
 
rmtypeRoom Types
rmtype.rm_cat Room Category Code.
rmtype.rm_type Room Type Code.
rmtype.description Room Type Description.
rmtype.rm_type_def Room Type Definition. Optional field.
 
rmRooms
rm.bl_id Room Building Code.
rm.fl_id Room Floor Code.
rm.rm_id Room Code.
rm.dv_id Room Division Code.
rm.dp_id Room Department Code.
rm.rm_cat Room Category Code.
rm.rm_type Room Type Code.
rm.name Room Name.
rm.area Room Area.
rm.centroid_x
rm.centroid_y		 Room Centroid X,Y. Optional fields; if they exist and ExportCentroids is TRUE, Map Compiler updates them.
rm.cap_em Room Person Capacity. Field only required if People Manager is used in Archibus mode.
rm.access_group Room access group, as for sisfm_flds.review_group. Optional field, if absent room access control is not available.
rm.loc_code Room location code, must conform to the LocCodeFormat setting.
rm.rm_comments Room notes, if defined the Room Bookings module requires approval for booking this room.
rm.capacity Room capacity: the maximum number of people it can accommodate. The RoomCapacityField setting can be used to specify a different field name. If the People Manager module is enabled and PersonRoomZoneAutomatic is not TRUE, room capacity for occupiable rooms is obtained as the sum of their rm_zone.capacity, or as the number of room zones if this field does not exist.
rm.book_open_hrs The hours within which a room can be booked, as a comma separated list of "-" separated start and end times to the nearest quarter hour, e.g. 08:30-13:00,14:30-18:30. Optional field, used by the Room Bookings module. If not defined the room can be booked at any time between the default timetable range of 06:45 to 23:45. Times outside this range cause the displayed timetable range to be expanded for the room. Use 24:00 to specify an end time of midnight.
rm.book_max_hrs The maximum number of hours for which a room can be booked per day by the same user, as a decimal number to the nearest half hour. Optional field, used by the Room Bookings module. If not defined the room can be booked for any length of time.
rm.book_max_hrs_student The maximum number of hours per day for which the room can be booked by any student, as a decimal number to the nearest half hour. Optional field, used by the Room Bookings module. If not defined the field rm.book_max_hrs applies.
rm.book_max_hrs_total_student Boolean (or integer) field, True (or -1) specifies that the room participates in the BookMaxHrsTotalStudent setting condition.
rm.book_min_booking_hrs_student The minimum period the room may be booked by any student. Optional field, used by the Room Bookings module. If not defined this is unlimited for the room.
rm.book_min_booking_gap_student The minimum number of hours between two bookings by the same student on the same day. Optional field, used by the Room Bookings module. If not defined this is unlimited for the room.
rm.book_max_bookings_student The maximum number of future bookings of the room by any student. Optional field, used by the Room Bookings module. If not defined this is unlimited for the room.
rm.<features> Room features: as for site features above. These are referenced according to Feature* and Search* settings.
 
rm_amenityRoom Amenities - used to access room amenities if specified by a Feature* setting which includes the amenities group name amenity, and table rm_amenity_type lists available amenity types. Different group names may be specified to reference different types of amenities in tables whose names and amenity type fields are named correspondingly (i.e. Feature field *XXX*, rm_XXX.XXX_type and rm_XXX_type.XXX_type). The same applies for floors, buildings and sites.
rm_amenity.bl_id Room Building Code.
rm_amenity.fl_id Room Floor Code.
rm_amenity.rm_id Room Code.
rm_amenity.amenity_type Amenity Type.
rm_amenity.quantity Amenity Quantity. Optional field, if it does not exist the amenity is either present or absent.
 
rm_amenity_typeRoom Amenitiy Types
rm_amenity_type.amenity_type Amenity Type.
 
rm_cleanRoom Cleaning Schedules - optional table.
rm_clean.bl_id Room Building Code.
rm_clean.fl_id Room Floor Code.
rm_clean.rm_id Room Code.
rm_clean.clean_type Room Cleaning Type Code.
rm_clean.clean_freq Room Cleaning Frequency. One of D W M Q to indicate that this cleaning type is performed daily, weekly, monthly or quarterly.
rm_clean.clean_freq_non_semester Room Cleaning Frequency (Non-Semester). As clean_freq but for periods outside regular use. If no values for this field are present, it is not included in the cleaning schedule page.
 
rm_clean_typeRoom Cleaning Types - required if table rm_clean exists.
rm_clean_type.clean_type Room Cleaning Type Code.
rm_clean_type.clean_sequence Room Cleaning Type Order. Lists are sorted by this field.
rm_clean_type.clean_category Room Cleaning Type category, used to insert sub-headings in cleaning type lists.
rm_clean_type.description Room Cleaning Type description.
 
rm_trialRoom Trial Layers - required if the RoomTrialLayers setting is TRUE. Other fields may also be present, will be shown in the trial room details page, and will be available for theming according to MapTheme settings. Fields trial_project_id dwgname ehandle are ignored if present.
rm_trial.bl_id Building Code.
rm_trial.fl_id Floor Code.
rm_trial.rm_id Trial Room Code.
rm_trial.layer_name Trial Drawing Layer.
rm_trial.area Trial Room Area.
 
People
 
emPeople
em.em_number Person's unique identifier. It is recommended that the EmNumberField setting is used to specify field em.em_id instead.
em.bl_id Person Building Code.
em.fl_id Person Floor Code.
em.rm_id Person Room Code.
em.dv_id Person Division Code.
em.dp_id Person Department Code.
em.email Person Email Address.
em.phone Person Phone Number.
em.extension Person Phone Extension.
em.fax Person Fax Number.
em.cellular_number Person Mobile Number.
em.access_group Person access group, as for sisfm_flds.review_group. Optional field, if absent person access control is not available. Note that:
  • This field controls whether a person is included in search results, and displayed as a room occupant.
  • This field does NOT control whether a person is included in People Manager search results, or in Map Enquiry Zone Location lists; access to these functions must be granted appropriately.
  • If Map Enquiry Zone Location is in use, a suitable test on this field must be included in the custom database view for the Cadcorp View Points layer used to display room occupants.
em.<name_last> Person's last name. Field name is specified using the EmNameFields setting.
em.<name_first> Person's first name. Field name is specified using the EmNameFields setting.
em.loc_code Person's location code, this must conform to the LocCodeFormat setting. Note that em.rm_id is currently not accessed by SISfm, but it is recommended that it is populated, and that em.loc_code is derived from it. The em.loc_code field is not used if the People Manager module is enabled.
em.em_positn Person's position title. Note that alternatively the field used for position title may be specified using the EmPositionField setting.
em.em_job Person's job ID, 1 = new staff. Used by the Move Manager module. The MoveNewStaffJobID setting is used to set the job ID for new staff. Note that this field may be included in the primary key to support members of staff having multiple positions at different sites.
em.a_g Person's staff type, optional, "A" for Academic, "G" for Professional (General), "R" for Research. Used by the Move Manager module.
em.date_start Person commencement date (e.g. of employment). Used by the People Manager module.
em.date_end Person termination date (e.g. of employment, undefined indicating permanent employment). Used by the People Manager module, and to exclude past people from searches. If People Manager is not enabled, see the EmStatusLeftValue setting.
em.em_type Person type, e.g. Employee, Student, External, TBA. Optional field. If its value is TBA then:
  • the PersonTBA setting should not be set TRUE.
  • whenever People Manager is entered, for each occupant commencement with em.start_notified not set, the occupant's department manager(s) (see em.is_dept_manager_user) are notified by email and em.start_notified is set.
em.start_notified Boolean (or integer) field, True (or -1) signifies that People Manager CHECK IN has been notified for a person with em.em_type='TBA'. Optional field.
em.is_dept_manager_user Boolean (or integer) field, True (or -1) signifies that the person is a manager of their department. Optional field.
em.auto_vacate Boolean (or integer) field, True (or -1) signifies that, whenever People Manager is entered, if the person would be in CHECK OUT, its Deallocate function occurs. Optional field.
em.<features> Person features: as for site features above. These are referenced according to PersonFeature* settings. Used by the People Manager module.
 
Documents

Tables docs_assigned, sisfm_docs and sisfm_docvers are used to store photos/documents if the DbDocumentStorage setting is TRUE. Additional fields named xx_bl_id xx_fl_id xx_rm_id may be included to support photo/document storage for facility type XX. Additional fields named table_id may be included to support photo/document storage for assets stored in tables other than the eq table. Field name values *docId signify thumbnail versions of photos with doc_id=docId. Table sisfm_docvers fields checkin_date checkin_time doc_file doc_size are populated though not used by SISfm, but author is not populated with adsName due to an Archibus FK constraint to field sisfm_users.user_name.

 
docs_assignedDocuments Assigned
docs_assigned.doc_id Document ID.
docs_assigned.site_id Document Site Code.
docs_assigned.bl_id Document Building Code.
docs_assigned.fl_id Document Floor Code.
docs_assigned.rm_id Document Room Code.
docs_assigned.eq_id Document Equipment Code.
docs_assigned.table_id Document Code for table table.
docs_assigned.description Document Description.
docs_assigned.name Document Name.
docs_assigned.doc Document Filename.
 
sisfm_docsDocuments
sisfm_docs.table_name Inventory Table (always 'docs_assigned' for SISfm).
sisfm_docs.field_name Inventory Field (always 'doc' for SISfm).
sisfm_docs.pkey_value Inventory Primary Key (always docs_assigned.doc_id for SISfm).
sisfm_docs.description Description.
sisfm_docs.locked Locked? (0=No 1=Yes).
sisfm_docs.deleted Deleted? (0=No 1=Yes).
 
sisfm_docversDocument Versions
sisfm_docvers.table_name Inventory Table (always 'docs_assigned' for SISfm).
sisfm_docvers.field_name Inventory Field (always 'doc' for SISfm).
sisfm_docvers.pkey_value Inventory Primary Key (always docs_assigned.doc_id for SISfm).
sisfm_docvers.version Version.
sisfm_docvers.file_contents File Contents (a BLOB data type).
sisfm_docvers.author Author.
sisfm_docvers.checkin_date Check In Date.
sisfm_docvers.checkin_time Check In Time.
sisfm_docvers.doc_file Document Filename.
sisfm_docvers.doc_size Document Size (Kb).
sisfm_docvers.comments Comments (always 'Inserted by SISfm' for SISfm).
 
Database Schema
 
sisfm_tblsDatabase Tables
sisfm_tbls.table_name Table Name.
sisfm_tbls.is_sql_view Table is a database view? (0=no 1=yes)
sisfm_tbls.title Table Title - used to obtain the following table titles; any trailing "s" character is removed from the titles found:
  • tables bu dv dp rm - the default terms used are Business Unit, Division, Department and Room.
  • tables in MapLayerNetwork settings for Node, Link, Cable and Circuit tables - these are the default terms.
 
sisfm_fldsDatabase Fields
sisfm_flds.table_name Table Name.
sisfm_flds.field_name Field Name.
sisfm_flds.ml_heading Field Heading (may define line breaks using LF, CR+LF or "<br>" separators).
sisfm_flds.primary_key Primary Key (0=not a PK field, n=nth PK field).
sisfm_flds.allow_null Allow Null (0=no 1=yes).
sisfm_flds.review_group Review Group (references sisfm_groupsforroles.access_group unless accessSecurityGroups is defined during login).
sisfm_flds.edit_group Edit Group (as for Review Group).
sisfm_flds.data_type Data Type, one of:
1 Char
2 Numeric
4 Integer
5 Smallint
6 Float
7 Real
8 Double
9 Date
10 Time
12 Varchar
-1 LongVarchar
sisfm_flds.sisfm_type Type, recognised values are:
2050 None
2055 Desc
2065 Barcode
2170 Doc_Stg
2245 Currency
sisfm_flds.sisfm_size Size. Maximum number of characters in a Char Varchar LongVarchar field.
sisfm_flds.decimals Decimals. Maximum number of decimal places in a Numeric Float Real Double field.
sisfm_flds.min_val Minimum Value.
sisfm_flds.max_val Maximum Value.
sisfm_flds.dflt_val Default Value, or one of:
AUTOINCREMENT Auto-incrementing single field primary key
CURRENT  Current date (as supported by Archibus)
USERNAME  Current user session variable adsName
USERID  Current user session variable userID
USEREMAIL  Current user session variable email
USERPHONE  Current user session variable phone
USERDV  Current user em.dv_id where em.email matches session variable email
USERDP  Current user em.dp_id where em.email matches session variable email
sisfm_flds.enum_list Enumeration List (e.g. 0;No;1;Yes).
sisfm_flds.ref_table Validating Table. If this table has one PK character field, its values may contain a "|" character to specify the use of a two tier selector (the supplied table work_problem_type is an example).
sisfm_flds.dep_cols Fields to Validate (semi-colon separated field names in this table matching the ref_table PK field names; same names if undefined).
 
Access Security

If the DbAccessSecurity setting is TRUE, tables sisfm_users and sisfm_groupsforroles are used to obtain user access groups (unless accessSecurityGroups is defined during login), which are applied to the following tables to determine the accessability of the related items. All Entries YES means that values of the item are never accessible if not in the table (like the Archibus security model), NO means that values of the item are always accessible if not in the table.

TableItemAll Entries
sitesitesNO
blbuildingsNO
flfloorsNO
rmroomsNO
empeopleNO
links_tableslinksNOSee External Links Data
sisfm_fldsfeature fieldsYES
sisfm_functionsfunctionsNO(unless otherwise stated)
sisfm_layersmap layersNOSee Map Enquiry module
sisfm_layereditmap layersNOSee Map Enquiry module
sisfm_reportsreportsNOSee Report Maker module
sisfm_personadminallocate person to roomYESSee People Manager module
sisfm_roombookingsbookable roomsNOSee Room Bookings module
sisfm_roombookadminnotify/cancel room bookingsYESSee Room Bookings module
work_flow_actionswork flow actionsNOSee Maintenance module

The Database Manager module includes an Access Groups utility for showing the access security that is currently in use.

The item's access group is specified in field access_group except for table sisfm_flds in which field review_group is used and edit_group specifies whether feature fields can be edited in details pages.

If the EmView is used to specify a database view to access people, instead of table em, all of its fields are accessible,

For a room amenity feature field *XXX*, access is determined using table sisfm_flds for field rm_XXX.XXX_type, and similarly for floor, building and site amenities.

To give nobody access (e.g. to a function), specify an access group that does not exist (e.g. 'NOBODY').

NOTE that fields sisfm_users.group_1...group_10 can be used to add up to 10 user-specific access groups in addition to those defined for the user's role. However, these fields have been deprecated by Archibus and are not accessed by Web Central, therefore these groups should only be defined for use with SISfm access control.

 
sisfm_usersUsers
sisfm_users.user_name User Name.
sisfm_users.role_name Role Name.
 
sisfm_rolesAccess Roles
sisfm_roles.role_name Role Name.
sisfm_roles.role_title Role Title
 
sisfm_groupsforrolesAccess Groups for Roles
sisfm_groupsforroles.role_name Role Name.
sisfm_groupsforroles.group_name Access Group Name.
 
sisfm_layersAccess to Map Layers
sisfm_layers.map_name The name of the folder under DataFolderMap containing the site map or floor plan. If blank or null it applies to any map. An "any map" entry plus a specific map entry for the same layer is interpreted using the OR operator for that map.
sisfm_layers.layer_name The name of the layer in the site map or floor plan that can be viewed.
sisfm_layers.access_group The access group, as for sisfm_flds.review_group.
 
sisfm_layereditAccess to Edit Map Layers
sisfm_layeredit.map_name The name of the folder under DataFolderMap containing the site map or floor plan. If blank or null it applies to any map. An "any map" entry plus a specific map entry for the same layer is interpreted using the OR operator for that map.
sisfm_layeredit.layer_name The name of the layer in the site map or floor plan that can be edited (View Points real time layers in Map Enquiry only).
sisfm_layeredit.access_group The access group, as for sisfm_flds.review_group.
 
sisfm_personadminAccess to Room Zone Allocation
sisfm_personadmin.admin_code The administrative classification of people and rooms: such people may be allocated to and deallocated from such rooms. Values consist of bu_id, dv_id and dp_id values separated by the "|" character, where the dp_id or dv_id, dp_id values may be omitted to specify access to all people and rooms in the higher classification. Used by the People Manager module. NOTE that people with em.dp_id and em.dv_id not defined are always accessible.
sisfm_personadmin.access_group The access group, as for sisfm_flds.review_group.
 
sisfm_reportsAccess to Reports
sisfm_reports.report_name The name of the report definition file under DataFolderReport. Names are case-sensitive, do not include the .AVW file extension, and sub-folder names are separated by "\".
sisfm_reports.access_group The access group, as for sisfm_flds.review_group.
 
sisfm_roombookingsAccess to Room Bookings
sisfm_roombookings.loc_code The location code of a bookable room. Used by the Room Bookings module.
sisfm_roombookings.access_group The access group, as for sisfm_flds.review_group.
 
sisfm_roombookadminAccess to Room Bookings Administration
sisfm_roombookadmin.loc_code The location code of a room for which bookings can be notified and cancelled using the Report generator page. Values may also specify a floor, building or site to apply to all rooms in them. Used by the Room Bookings module.
sisfm_roombookadmin.access_group The access group, as for sisfm_flds.review_group.
 
sisfm_functionsAccess to Functions
sisfm_functions.function_name The name of a function (* means no access if the row is missing):
AddAsset *Add Asset is available in Asset details (subject to the AppAdmin setting).
AddBuilding *Add Building is available in Building details (subject to the AppAdmin setting).
AddField *Add Field is available in the Database module.
AddFloor *Add Floor is available in Floor details (subject to the AppAdmin setting).
AddPerson *Add Person is available in Person details (subject to the EmView and AppAdmin settings).
AddRoom *Add Room is available in Room details (subject to the AppAdmin setting).
AddRow *Add Row is available in the Database module.
AddSite *Add Site is available in Site details (subject to the AppAdmin setting).
AddTable *Add Table is available in the Database module.
AssetBookOverrideHours Asset Bookings opening and maximum hours can be overridden.
AssetBookReportAccess Asset Bookings report pages are available (After Hours, Weekend bookings, Report generator).
AssetBookReportAdmin Asset Bookings report generator page includes booking notification and cancellation.
BookOverrideHours Room Bookings opening and maximum hours can be overridden.
BookReportAccess Room Bookings report pages are available (After Hours, Weekend bookings, Report generator).
BookReportAdmin Room Bookings report generator page includes booking notification and cancellation.
Config *The config.aspx page can be used.
DocumentAdd Facility documents can be added by uploading them.
DocumentDelete Facility documents can be deleted.
DocumentFolderEdit Facility document folders can added and deleted.
DocumentFolderView Facility document folders can be viewed.
DocumentReplace Facility documents can be replaced by uploading them.
EditAsset Edit is available for assets.
EditAssetManager Asset Manager New and Edit tabs are available.
EditBuilding Edit is available for buildings (subject to the AppAdmin setting).
EditField Edit is available for table fields in the Database Manager module.
EditFloor Edit is available for floors (subject to the AppAdmin setting).
EditMaintenance Maintenance module updating buttons are available normally, otherwise they are disabled.
EditOccupants Edit Occupants is available for rooms (when People Manager is not enabled) (subject to the AppAdmin setting).
EditPerson Edit is available for persons (subject to the EmView and AppAdmin settings).
EditRoom Edit is available for rooms (subject to the AppAdmin setting).
EditRoomDepartment *Edit is available for rooms of the user's department.
EditRoomDivision *Edit is available for rooms of the user's division.
EditRoomTrial *Edit is available for trial rooms.
EditRow Edit is available for table rows in the Database Manager module.
EditSite Edit is available for sites (subject to the AppAdmin setting).
MaintManagement *Maintenance module functions are all available, subject to access to Work Flow Actions.
MaintLogComments Maintenance module comments can be logged.
MaintDocAdd Maintenance module Work Request documents can be added.
MaintDocDelete Maintenance module Work Request documents can be deleted.
MaintDocReplace Maintenance module Work Request documents can be replaced.
MapClickBuilding Map Enquiry site plan buildings can be selected (subject to the MapLinkFloorPlan setting).
MapClickRoom Map Enquiry floor plan rooms can be selected (subject to the MapLinkRoomDetails setting).
MapInfoPanel Map Enquiry information panel is available.
MapLayerDownload Map Enquiry layer download is available.
MapLayerMenu Map Enquiry layer menu is available.
MapNoWebStorage Map Enquiry does not access Web Storage (subject to the MapNoWebStorage setting).
MapRoomDialogAdvanced *Map Enquiry room dialog includes Quick Edit button.
MapRoomOccupantGroups Map Enquiry occupant group is available.
MapRoomZoneDialogAdvanced *Map Enquiry room zone dialog includes functions to change occupants and zone use.
MapRoomZoneDialogDepartment *Map Enquiry room zone dialog advanced functions may only add occupants of the user's department.
MapRoomZoneDialogDivision *Map Enquiry room zone dialog advanced functions may only add occupants of the user's division.
MapRoomZoneDisplayDepartment *Map Enquiry room zone display is restricted to those of the user's department.
MapRoomZoneDisplayDivision *Map Enquiry room zone display is restricted to those of the user's division.
MapRoomZoneLocation Map Enquiry room zone location is available (termed Occupant Location if PersonArchibusMode is TRUE.
MapSearch Map Enquiry search is available (subject to the MapSearch setting).
MapSiteFootprint Map Enquiry site footprint is available.
MapSiteFootprintDepartment *Map Enquiry site footprint is restricted to listing floors for the user's department.
MapSiteFootprintDivision *Map Enquiry site footprint is restricted to listing floors for the user's division.
MapTheme-bl.area Map Enquiry theme menu includes the bl.area entry.
MapTheme-bl.id Map Enquiry theme menu includes the bl.id entry.
MapTheme-bu_id Map Enquiry theme menu includes the bu_id entry.
MapTheme-id Map Enquiry theme menu includes the id entry.
MapTheme-occupantlist Map Enquiry theme menu includes the occupantlist entry.
MapTheme-occupants Map Enquiry theme menu includes the occupants entry.
MapTheme-vacancies Map Enquiry theme menu includes the vacancies entry.
MapThemeMenu Map Enquiry theme menu is available.
ModuleAdministrator The Administrator module is available.
ModuleAssetBookings The Asset Bookings module is available.
ModuleAssetManager The Asset Manager module is available.
ModuleDatabase *The Database Manager module is available.
ModuleMapEnquiry The Map Enquiry module is available.
ModuleMaintenance The Maintenance module is available.
ModuleMoveManager The Move Manager module is available.
ModulePeopleManager The People Manager module is available.
ModuleReportMaker The Report Maker module is available.
ModuleRoomBookings The Room Bookings module is available.
ModuleSpace The Space Manager module is available.
ModuleWorkstationBookings The Workstation Bookings module is available.
MovePageAdmin Move Manager administration functions are available.
MoveServicesView Move Manager Move List page is available.
PeopleGroups People Manager zone groups are available.
PeopleOccupantGroups People Manager occupant groups are available.
ReadOnly *Functions that would modify data instead advise that ReadOnly access is in effect.
RemoveAsset *Remove Asset is available in Asset details (subject to the AppAdmin setting).
RemoveBuilding *Remove Building is available in Building details (subject to the AppAdmin setting).
RemoveField *Remove Field is available in the Database Manager module.
RemoveFloor *Remove Floor is available in Floor details (subject to the AppAdmin setting).
RemovePerson *Remove Person is available in person details (subject to the EmView and AppAdmin settings).
RemoveRoom *Remove Room is available in Room details (subject to the AppAdmin setting).
RemoveRow *Remove Row is available in the Database Manager module.
RemoveSite *Remove Site is available in Site details (subject to the AppAdmin setting).
RemoveTable *Remove Table is available in the Database Manager module.
ReportDepartment *Report Maker AVW reports with Division/Department selectors are restricted to the user's department.
ReportDivision *Report Maker AVW reports with Division selectors are restricted to the user's division.
RoomAdministrationMode Space Manager option Statistics is available when Facility Type, Site, Building or Floor are selected (subject to the RoomAdministrationMode setting).
RoomCleanSchedEdit Space Manager displays the Edit button on its cleaning schedule page.
RoomCleanSchedule Space Manager displays the Cleaning Schedule button on the room details page (if its tables exist).
RoomDetailsPlusOccupants Space Manager displays room occupants after room details in Map Enquiry (subject to the RoomDetailsPlusOccupants setting).
RoomDetailsPlusTimetable Space Manager displays room timetable after room details in Map Enquiry (subject to the RoomDetailsPlusTimetable setting).
RoomOccupantDepartment Space Manager displays the department selector in its room occupants page (if the EditOccupants function is available).
RoomShowCompiledPDF *Space Manager displays Compiled PDF buttons in the Site and Floor details pages (if plans have been compiled with ExportPDF set TRUE).
RoomUtilisation Space Manager displays room utilisation in its room details page (if data exists and RoomUtilisationFields is defined).
RoomVacantReset Space Manager displays the "Reset Vacant field for all rooms" button in its room occupants page (if the EditOccupants function is available and RoomVacantField is defined).
ShowAllFields *Details pages show all other fields after feature fields (subject to the FeatureShowAllFields setting).
ShowPerson People are included in search results and shown as occupants.
SQL *The Database Manager sql.aspx page can be used.
WorkRequestsInDetails Include Work Requests panel in site, building, floor, room, asset details.
WorkRequestsShowAll Include the Show All checkbox in the item details Work Requests panel.
WorkstationBookAnyDepartment Workstation Bookings can make bookings in any department, not only that of the user.
WorkstationBookShowAnyBookings Workstation Bookings can show existing bookings for anyone.
WorkstationBookShowQR Workstation Bookings includes the Show Workstation QR function.
sisfm_functions.access_group The access group, as for sisfm_flds.review_group.
 
Miscellaneous
 
projectProjects - accessed to list and detail site and building projects if the ProjectFeature1 setting is defined
project.project_id Project Code.
project.site_id Project Site Code.
project.bl_id Project Building Code.
project.summary Project Summary.
project.description Project Description.
project.status Project Status. Optional field, see the ProjectStatusInclude setting.
 
lsLeases - accessed to list building leases if the RoomBuildingLeases setting is defined
ls.ls_id Lease Code.
ls.bl_id Lease Building Code.
ls.description Lease Description.
ls.date_end Lease End Date.
 
sisfm_hearsayHearsay Log - records user comments on Map Enquiry point features, if configured.
sisfm_hearsay.said_when Date/time when the hearsay comment was submitted.
sisfm_hearsay.said_about Feature ID for which the comment was made.
sisfm_hearsay.said_who Logged in username which submitted the comment.
sisfm_hearsay.said_text Text of the comment.
 
sisfm_doc_logDocument Update Log - optional table, contains a log of Facility Links document upload (add or replace) and delete actions. These functions are available if this table exists, and access security grants a user access to them. Rows in this table can be deleted when desired.
sisfm_doc_log.doc_when Date/time when a document action was performed.
sisfm_doc_log.doc_who Logged in username which performed the action.
sisfm_doc_log.doc_action The document action performed: ADD, REPLACE or DELETE.
sisfm_doc_log.doc_file The document file name and physical path.
 
sisfm_db_update_logDatabase Update Log - optional table, contains a log of database updates. See FAQ How do I log database updates?. Rows in this table can be deleted when desired.
sisfm_db_update_log.ID ID (autoincrement)
sisfm_db_update_log.date_time Date/Time of the update.
sisfm_db_update_log.user_name User Name of who performed the update.
sisfm_db_update_log.table_name Table Name containing the update.
sisfm_db_update_log.primary_key Primary Key values to identify the table row that was updated, separated by "~" if more than one.
sisfm_db_update_log.update_action Action, one of:
INSERT The row was inserted.
UPDATE A field in the row was updated.
DELETE The row was deleted.
sisfm_db_update_log.field_name Field Name - the name of the field that was updated. NULL if update_action is not UPDATE.
sisfm_db_update_log.field_value_old From - the value of the field that was updated. NULL if update_action is not UPDATE.
sisfm_db_update_log.field_value_new To - the new value of the field that was updated. NULL if update_action is not UPDATE.