In this topic Hide
This page provides an overview of the RME tables for reference. Tables cannot be modified or deleted. New tables will be added automatically when created in the database. This page used to be called 'RME Data Dictionary' and may display as such if this is saved in your database.
You can enable or disable auditing for a particular table. Some are enabled by default. Enabling table auditing will create a copy of a record or related item prior to any change which can be used in reports.
If enabling auditing for a table, the auditing function also needs to be enabled in RME > System > System Preferences > System > Audit Settings. As a minimum, Audit record create/update/delete? must be Yes. By default, this is set to Yes. Other settings can be enabled to capture when a record, eForm, or report is viewed, when a workflow action is performed for an eForm, and common browsers used. See: Audit Settings
The Audit Details button on the core record toolbar displays by default regardless of the Audit enabled? setting for a table. When the toolbar option is clicked, the popup displays details about changes to the record including who created it and when, and who last changed it and when.
You can create custom fields for the following tables only:
• RM_PROJECT for the Projects module
• RM_ETHICS for the Ethics module
• RM PUBLICATION for the Research Outputs module
• RM_PERSON for the Personnel module
Reporting is not available for this area so the Reports button does not display on the toolbar.
Menu path: RME > System > Table Auditing
Use Advanced search to find records.
1. Enter your search criteria in the fields. To add a line, click the green plus (+) icon.
2. To start the search, press <Enter>
on your keyboard, or select the Find
button on the toolbar.
Records that match your search criteria display
automatically in the Results tab.
3. To open a record from search results, you can either:
• Click the Open icon next to the item in the grid.
• Select the checkbox to the left of the item and click Find in the toolbar.
For more, see: Search
1. From the RME menu, select System > Table Auditing.
2. In the grid, search for the table you want to edit.
3. In the row for the table you want to edit, click the Open icon. The Table Auditing page displays.
4. See: Table Auditing
You can use this feature to export the record details shown in the core record grid, or all details from a related item, into a CSV file.
Click Export.
In the resulting popup, indicate whether you wish to open, save or cancel the file.
Result: If opened or saved, the details will be exported. The CSV file name will include the page name and today's date.
• System Preferences, Audit Settings
Product Key: Modules - Core
Page ID: DAT001S.htm