View Data Dictionary Information for All Tables

This data dictionary is the front-end interface to all tables contained in the back-end. From here, for all tables, you can view information such as the data type and the primary and key reference. You can also view the upgrade rule for each table here which is helpful during an upgrade and for the impacts on reporting.

Note: This list does not include the following:

• Audit Tables (_a) - The table used to track the history of changes made to the data of the table. 
• Data Extension Tables (_x) - These tables are extension tables linked to a main table that allows you to store your own user defined fields (UDFs). These fields are created in the table_x when you create a new database field on a form in Form Designer. You can report on these fields by using a third-party report writer.

► Table Types

Each table is assigned to a type. These table types define how upgrades will handle each table.

• Data Dictionary Table - System tables that store all information pertaining to the definitions of all tables.  These are for system use only and are of no use to the agency.
• Date Entry Table - Basic Data entry table to store data (such as the people table).
• Data Entry Table – Event Log Extension - Extension tables for event log.  Each event category (within which events are defined) is associated to one of these tables.  These tables store additional data unique to the event category to go along with data stored within the event_log table (as previously shown with the training and legal_history tables).
• Data Entry Table – not Extensible - These tables do not have an associated table_x so you will not be able to add user defined fields to them.
• Netsmart Special Table - Tables used by Netsmart for system use only.
• Netsmart System Table - Netsmart System tables that are always overwritten with upgrades
• Libraries - Similar to regular look-up tables, these are tables that hold libraries of values such as treatment goals, objectives, and methods.
• Regular Look-up Table - Tables the agency populates in table maintenance (Setup > System > Table Maintenance).
• System Look-Up Table - These tables are similar to agency-defined look-ups, except they have values that are controlled by Netsmart Systems.
• User Defined Setup Table  - Similar to regular look-up tables, except that they are not available in the Table Maintenance area. Instead, they can be found in their own business-specific area. For example, the following incident tables are defined similar to the way regular look-ups are defined, but for ease of setup and understanding they are organized together in a separate area, not in Table Maintenance.

1. ---

   Go to: Setup > User Tools > Data Dictionary > All Tables
2. In the toolbar, choose Filter > Filter Settings to search for the appropriate table. 
3. Enter the appropriate filters to find the table and select Apply.
4.  Select the + to view the following information:
   • Table Type
   • Table Name
   • English Name
   • Table Remarks
   • Upgrade Rule
5. To view all fields in the table, select Non-Primary Key Columns.