Data dictionary system tables

Data dictionary tables displayed in the System group provide information about the data being collected by certain functions. Only the labels in these tables can be changed – changing the labels will change the labels used for these fields in the relevant maintenance screens. Unless you use different terminology it is unlikely that you will make any changes to any of these tables – the “Customising your RefTracker” section of this manual provides more information about when you might want to make changes to these System Data dictionary tables.

There are number of tables provided in the System group. Some examples are:

• Location Labels in System>Locations function
• Request form Labels in System>Request forms>Details
• Staff table Labels in System>Full and ServicePoint user maintenance screens and the My preferences screen.

If your organisation is licensed for the optional RefTracker Dynamic Lookups module, a Code map, Code map item, Lookup token, Lookup definitions and Lookup definition item code tables will also be showing here – they are used by the Dynamic lookups documentation and do not need to be changed.

Exercise:

Go to System>Data dictionary, and in the group selection drop down at the top of the screen choose System tables (or use the menu lists to go to this screen). To see the definition of a table click on its name. Use of the screens in this section and how to change the labels in them is identical to use of the Data dictionary Questions tables. As it is rare that you will need to change anything in these system tables, we will now go on to System>Data dictionary>Question tables to learn more about the Data dictionary.