Any payroll system requires tables to hold constant type data in lookup tables, such as:
- Cost codes
- Paypoint codes
- Medical aid rates and rules
- Tax rates and rules
There are of course many more tables required than the few listed above. Because nuQ data is held in a SQL database, there is no limit to the number of tables that can be held or their content. Extensive use is made of tables in nuQ, from a simple table containing just “Yes” and “No” to very complex tables containing medical aid rules and rates. Different “shapes” of medical aid tables are held for each medical aid, depending on the complexity of their rules.
Apart from the system tables provided, users can set up as many of their own tables as they feel are necessary. Creating a table in nuQ is a matter of a few minutes by a non-programmer!
At the risk of being repetitive:
- There is no limit to the number of tables that can be held in a database
- The shape of a table can be anything desired
- Tables can be very easily created