Table Register

The MRI Evolution system is based on a large back end database. This database contains all the Users, Preferences and data entered.

There are a wide range of functions that can be altered within the Table Register; these include; how the text in the drop down menus is displayed or allowing hazards and documents to be associated. It is also the gateway to define compulsory or unique fields that are linked with each table.

System Administration > System Preferences > System Appearance & Behaviour > Table Register

The link will open the Table Register grid. It is a grid view which can be searched, sorted and customised as normal.

Click to view - Table Register Fields and Descriptions

Field Name	Description
General
Name	The name of the table – it is highly recommended that MRI Evolution table names are not manually altered.
Maximum Page Size	The maximum page size is used to limit the Users display options. Parts of the system are able to show grids of varying sizes, maximum page size puts a cap on this size.
Default Page Size	The default page size is the number of records a grid shows.
Display Format	Defines the display text shown on records on screens and drop downs.
Store Documents?	Check the box to enable the entity to store documents.
Store Property Groups?	Check the box to enable the entity to store attributes and properties.
Allow Hazards & Alerts?	Check the box to enable the entity to store hazards.
Display Events?	Check the box to enable the entity to display events.
Store Attributes?	Check the box to enable Smart Attributes to be stored against the table - Attributes module required.
Allow PMS Core Values	Check the box to enable PMS Core Values to be stored against the table - PMS module required.
Publish Mobile Data?	Check the box to enable to entity for mobile data to be published – Evolution Go module required.
Mobile Audited?	Check the box to enable to entity to enable mobile audits - Evolution Go module required.
Store BIM Documents?	Available from 4.6.0.0 Check the box to enable BIM Documents to be stored against the table - BIM Management module required. Note: Grid and input panels for entities other than FLOCATE will not enable the tool bar buttons
Allow Work Surveys?	Available from 5.5.0.0 Check the box to enable Work Surveys against the entity. The check box is only enabled for the following entities: Sites - F_BG_GROUP Buildings - FLOCATE Locations - FAREALO Instruction Sets - FINFILE Hazard / Alert Types - HazardTypes Work Permit Classes - F_WPERMIT_CLASS When enabled a Surveys sub navigation will appear in the input panels of the entity, similar to Hazard / Alert Types.
Allow Supply Chain Surveys?	Available from 5.5.0.0 Check the box to enable Supply Chain Surveys against the entity. The check box is only enabled for the following entities: Resources - F_RESOURCE Suppliers - FSUPPLY When enabled a Surveys sub navigation will appear in the input panels of the entity, similar to Hazard / Alert Types.
Allow Select All	Available from 4.7.0.0 Check the box to enable a 'select all' check box to appear at the top of the current system entity's grid. Checking the 'select all' box will highlight/select ALL records in the grid, even in pages not currently displayed. Users can then perform relevant actions against the selected records, such as changing the status via toolbar buttons. The grid must be a 'multi-select' grid, such as the Tasks grid, to utilise this functionality. Note: If this function is used within an assignment grid the "Assign Selected" should be used to ensure all entities are assigned. Using "Assign Page" will only assign the current page.
Allow Identity Tags	Check the box to enable Identity Tags against the entity. This option will only appear when the Identity Tags Purchase Key has been licensed. When enabled an Identity Tags sub navigation will appear in the input panels of the entity, similar to Hazard / Alert Types.
Publish MRI Dreamscape Data	Available from 5.3.0.0 Check the box to enable MRI Dreamscape publishing - MRI Dreamscape applications required

Complete the fields and click Save . From the Table Register header a sub navigation can be accessed to allow additional features to be enabled.

These include:

Table Fields
Validation Rules
Translation Strings

Table Fields

Click to view more detail.

Within the Table Register specific fields can be modified to enable certain features.

System Administration > System Preferences > Table Register – Table Fields

The link will open the Table Register / Table Fields grid. It is a grid view that can be customised and sorted as normal.

To edit a Table Field, highlight the Table Field and click Edit .

Field Name	Description
Field Name	The name of the Table Field.
Description	Free text description of the Table Field – by default these are blank.
Auditing Allowed?	Check the box to turn on the audit trails for the Table Field.
Searchable?	Check the box to make the Table Field searchable in the quick search function.
Editable in Grids?	Available from 5.0.0.0 Check the box the make this field available as editable in grids by users
Grid Edit Type	Available from 5.0.0.0 From the drop down set the field type for entering data e.g. number with no decimals or number with two decimals
Grid Default Column Order	Available from 5.0.0.0 Check the box the set the default display order of the column in its primary grid Note: This setting will be overridden if a grid is personalised or used in a grid that includes fields from linked entities
Grid Filter Type	Available from 5.0.0.0 From the drop down select the filter type e.g. Multiple select-allow multiple items to be selected from the filter or Number Range- allow a number range to be entered within the filter Note: The Multi Select Filter Type function will only work with direct foreign keys e.g. AR_FKEY_BG_SEQ
Grid Footer Type	Available from 5.0.0.0 From the drop down select the aggregate to summarise data in the column footer
Grid Footer Text	Available from 5.0.0.0 Add text to in the column footer to appear before the aggregate summary
Grid Display Type	Available from 5.0.0.0 From the drop down set the field type for displaying data e.g. number with no decimals or number with two decimals

Note: The editing and display features will vary and filter dependant on the field selected

Validation Rules

Click to view more detail.

Rules can be created to control data as it is entered e.g. Req IDs are unique or that email addresses contain an @ symbol.

System Administration > System Preferences > Table Register – Validation Rules

The link will open the Table Register / Validation Rules grid. It is a grid view which can be searched, sorted and customised as normal.

To add a new Validation Rule click New , to edit an existing Validation Rule click Edit . A pop up window will appear which will allow the creation or amendment of a Validation Rule.

Click to view - Validation Rules Fields and Descriptions

Field Name	Description
Rule Name	The name of the Validation Rule.
Enable	Check the box to enable the Validation Rule.
Failure Message	Free text field to create the message a User will see it the Validation Rule is not met.
All States	Check the box if the rule is to apply regardless of the state of the entity – if the rule is only to apply when an entity is in a certain state or states, uncheck the box and click the required states.
All Applications	Check the box to apply the Validation Rule to all applications – if the Validation Rule is only to be applied in MRI Evolution and not Evolution Reach and Evolution Connect; uncheck the box and check the required applications.
All Profiles	Available from 5.1.0.0 Check the box to apply the Validation Rule to all Account Profiles - if the Validation rule is only to be applied to certain profiles uncheck All profiles and check the required profiles.
Field	From the drop down select the field the Validation Rule is to be applied to.
Rule Type	Select the radio button to set the rule type: Required Field – the field must be completed. Unique – the field cannot be a duplicate of another record. Field Comparer – the field data meets specific values or thresholds. Regex Template – the field must meet a regular pattern e.g. capitalised first letter. Regex Rule – the field must meet the expression typed here e.g. mobile numbers must start “07”. Read Only Field – the field is read only and cannot be edited.

Translation Strings

Click to view more detail.

Translation Strings are the thousands of labels from across the system. These can be altered to fit a business need.

System Administration > System Preferences > Table Register – Translation Strings

Highlight the translation string to edit, click Edit . A pop up window will appear which will allow the amendment of a Translation String.


Resource Key	Auto-populated with the name of the Resource Key.
Value	Editable value for the Translation String.

Table Register

System Administration > System Preferences > System Appearance & Behaviour > Table Register

Click to view - Table Register Fields and Descriptions

Table Fields

System Administration > System Preferences > Table Register – Table Fields

Validation Rules

System Administration > System Preferences > Table Register – Validation Rules

Click to view - Validation Rules Fields and Descriptions

Translation Strings

System Administration > System Preferences > Table Register – Translation Strings

Click to view - Translation Strings Fields and Descriptions