...Menu...
Menu Access: Settings - Maintenance
The system table is used throughout the system as a general information file for a variety of functions ranging from table lookups to system parameter and switch settings. When system tables are referenced in a topic a link will be provided to this topic and to an illustration of the system table being discussed.
For example this function allows you to define user defined lookup tables that will be used within the H/R module. Once defined you will then assign the table values or contents for your table. To illustrate this we will use an Awards model as an example.
The Sales department has designed an award program for the companies salesmen. There will be four awards based upon sales levels of 1, 2, 3, and 4 million dollars. The sales manager has asked you to keep a history of the awards for each employee. He would like to record the award given, the date received by the employee, the award name, and some free form notes.
The first step will be to create a table for recording the awards levels. To accomplish this you will create a new table called Awards with a description as shown below. You may leave the screen name filed blank. Scroll through the browser to seem some of the other tables that have already been created.
Once you have created the new System Table in the top browser you may enter the table values in the bottom browser.
Once this table is created it can be used as a lookup when assigning awards to employees. Only the values sales, sales1, sales2, or sales3 will be valid within the context of an employee award.
Another function of the system table could be to provide information to the software. For example this system table provides information to the Help system. The values in this table would be assigned by GTR personnel whereas the values in the preceding table would be created and maintained by the end user.
Last Updated October 20, 2006