AMI Data Export (ADE)

The ADE table sizes are maintained by the Historical Purge Framework. The framework purges old ADE exceptions, messages, requests, and summaries by two different purge groups, but they are functionally listed together.

  • Rows in the following ADE summary tables are deleted by the AdeSummary_Purge stored procedure using the specified columns.

    • AdeExceptionSummary (using ExceptionHour column)

    • AdeExportSummary (using ExportHour column)

    • AdeProcessSummary (using ProcessHour column)

  • Rows in the following tables are deleted based on the purge framework stored procedure.

    • AdeEntity

      AdeEntityMessage

    • AdeEntitySPChannel

    • AdeRequest

    • Rows are deleted using the AdeRequest.ReceivedDate column.

    • The retention period (1) is retrieved from the Retention Days setting on the ADE template. The chunk size is retrieved from the HistoricalPurgeModule table.

      Location of chunk size on the task template dialog.

  • The retention period and chunk size parameters are retrieved from the HistoricalPurgeModule table:

    Table 70 Historical purge module

    Module Target

    Purge Procedure

    Days to Keep

    Chunk Size

    AdeRequest_purge

    AdeRequest_Purge

    (1)

    2000

    AdeSummary_purge

    AdeSummary_Purge

    180

    2000