This is a tool that is located on the Maintenance section of the System Administration tab.
Function
The System Tables Maintenance interface provides the ability to maintain attribute values associated with table and column entries in the RIMS database SI_TABLES and SI_COLUMNS tables. Users assigned the "System Admin: System Tables" permission will have access to this interface and can update existing records. The image below shows an example of this interface once it is entered, and a row is selected.
Tables
There are two tables on this interface: Tables and Columns. The Tables table (top) will be sorted by Sub System and Table Name; these columns on the table are read-only. All other columns are editable if clicked into. Once a row is selected in the Tables table, the Columns table will be filled with the applicable data if any exists. The Columns table (bottom) will be sorted by Sub System, Table Name, and Column Name; these columns on the table are static and read-only. All other columns are editable if clicked into, and they can be scrolled through using the bar at the base of the table.
Links
There are two types of links provided on this interface which work with the Tables and Columns tables.
| Link | Under Which Table... | Description |
| Set Sub System | Tables |
Allows the user to filter the tables shown to a specific Sub System. |
| Set Sort Order | Tables, Columns |
Allows the user to set the sort order of the associated table’s contents. |
Set Sub System
Selecting the "Set Sub System" link under the Tables table will open a pop-up which will have the current subsystem selected. Here, the user may click another subsystem on the list or check the "Clear Filter" checkbox to display all subsystems. The "OK" button implements the user's selections.
Set Sort Order
Selecting the "Set Sort Order" link under the either table (Tables/Columns) will open a pop-up which consists of two tables and some button controls. The two tables are:
| Table | Description |
| Available Columns | Displays all columns in the tab table not already used in the sort (in alphabetical order). |
| Selected Columns | Displays all columns currently used in the sort order. |
Four actions can be taken in this interface: add columns to the sort order, change a column's sort order, modify the order of the selected columns, and remove a column from the sort order.
| Action | Description |
| Add columns to the sort order | To add columns to the sort order, the user can select one or more columns from the Available Columns list, then select the "Add" button. This places the columns on the Selected Columns list, with a default sort order of ascending. |
| Change a column's sort order |
To change a column's sort order, the user can select its Sort Order button. An up arrow denotes ascending order, and a down arrow denotes descending order. |
| Modify the order of the selected columns |
To modify the order of the selected columns, the user can select the desired row(s), then use the buttons to the right of the table to move them. The available buttons are:
|
| Remove a column from the sort order |
There are two ways to remove columns from the sort order:
|
Comments
0 comments
Please sign in to leave a comment.