Maintain Data Table by Location

Use Maintain Data Table by Location to delete data for a specific location by period or category.

Note:

To delete all locations for an application, use the Maintain Data Tables by Application option. This option enables you to delete data across all locations associated with a selected target application. See for more information.

Maintain Setup Data uses a Mode parameter, which enables you to either preview or delete invalid data.

The parameters are:

• Location

• Start Period

• End Period

• Category

To run the Data Table by Location script:

1. Complete the steps for scheduling a maintenance script.

   For more information, see Scheduling Maintenance Scripts in the Job Scheduler.

2. From the Schedule Job page, select the Data Table by Location script.

3. From the Maintain Data Table by Location page, and then from the Location drop-down, select the location from which to delete data.

   To delete data from all locations, leave the Location field blank.

4. From Start Period, select the starting period from which to delete data.

5. From End Period, select the ending period from which to delete data.

6. From Category, select the category data to delete.

   To delete all category data, leave blank.

7. Click OK.