Lookup Table Maintenance window

Owned by
Former user (Deleted)
Last updated: Oct 06, 2021 by
Richard Kennedy (Unlicensed)
2 min read

Use the Lookup Table Maintenance window to maintain the values in reference tables used in Synergetic.

 Opening the Lookup Table Maintenance window

To open the Lookup Table Maintenance window:

  1. Select Module > System Maintenance > Lookup Tables Maintenance.
    The Lookup Table Maintenance window is displayed.


Lookup Table Maintenance window key fields and buttons
Fields

Field

Description

Table

List of available lookup tables.

Scroll down and select the lookup table required.

Table Values

For the selected table, the fields (columns) and records (rows) are displayed.

Use the navigation and other buttons to perform actions on the data in this area.

Tip: You can use the Table Values field to search for terms within the selected lookup table.

Active Records Only

For the selected table, select the Active Records Only field to display only records that have their ActiveFlag field (column) selected.

In the example below the records with code 0001 does not have its ActiveFlag field selected and so it is not displayed.
 
Untick the Active Records Only field to display active and inactive records.
In the example below the record with code 0001 is displayed as well as the active records.


Buttons

Button

Description

Go to the first record in the Table Data area, for the selected table.

Go to the previous record in the Table Data area, for the selected table.

Go to the next record in the Table Data area, for the selected table.

Go to the last record in the Table Data area, for the selected table.

Create a new lookup table entry, for the selected table.

A new blank record is created at the bottom of the grid and the cursor is moved into the first field so that you can enter the details for the new record.

Tip: You can load default settings for some tables.

Save the changes made to the current record.
Note: If you try to rename a lookup table it does not update the name.

Undo the:

  • new record added
  • changes made to the current record.

Delete the selected record.
The following confirmation message is displayed.

Note: Deleting records from certain tables can cause some functions within Synergetic to perform incorrectly. However, deleting records does not necessarily delete the data from any records it is stored against.

Tip: Alt+d deletes a highlighted record, while Alt+y confirms that you want to delete the record. These shortcuts are useful when deleting multiple entries.

Load default records for certain tables. See Loading lookup tables for external systems.

For example, you can load reference data for the following external systems:

  • School Curriculum and Standards Authority (Western Australia)
  • Catholic Education Office (Victorian Catholic schools)
  • MCEETYA (Australia, Ministerial Council on Education, Employment, Training and Youth Affairs)
  • NZMOE (New Zealand Ministry of Education)
  • NZQA (New Zealand Qualifications Authority).