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 Maintain Data Table by Application for more information.

This script takes the following parameters:

  • Location

  • Start Period

  • End Period

  • Category

To execute the Maintain Data Table by Location script:

  1. On the Workflow tab, under System Maintenance Tasks, select Maintain Data Table by Location and then click Execute.
  2. From Execute Script page, from Location, select the location from which to delete data.

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

  3. From Start Period, select the starting period from which to delete data.
  4. From End Period, select the ending period from which to delete data.
  5. From Category, select the category data to delete.

    To delete all category data, leave blank.

  6. Click OK.