How to Add/Modify Table Column History

This screen allows the user to add, modify or delete records on the EC_HISTORY table. The EC_HISTORY table identifies which tables/columns are to be permanently archived during the Clean Up/History process.

Use the following steps to Add/Modify Table Column History:

          1. Click on System

          2. Click on System Audit

          3. Click on History Table Columns

          4. Enter a Search parameter, such as Table Name or Column Table.

                    To View ALL Tables, Simply click the Find button, with no parameters entered.

          5. Click the Find button at top of the menu bar to see all relevant records in the database.

          6. Select a Table Name to modify or Select New at the top of the menu screen to add a Table or Column

          7. Enter a unique Table Name

          8. Enter a unique Column Name

          9. Enter the relevant information within the grid. Double-click on a grid-column to modify the value (Consult the user guides for more information about each field)

          10. Click the Save button to save your changes