Database Tables

This section describes those database tables of Syntelate XA that it is important for you to understand and which you may need to edit. Most of these database tables can be amended via a configuration desktop rather than directly in SQL Server Management Studio.

This section does not describe any database tables for which a dedicated user interface exists. For example, the following tables should not be amended directly but instead via the Interval Manager:

  • INTERVALGROUP
  • INTERVALHOLIDAYS
  • INTERVALPATTERN
  • INTERVALTASKS
  • INTERVALWEEKDAYS

As such, these tables are not described here.

Similarly, this section does not describe tables or views related to reporting. It is important for you to be familiar with those, but you will not actually edit them. The tables and views used in reporting are described here: Reporting Tables .