Check the traffic table report count
About this task
This procedure enables you to check the number of traffic reports to determine whether you need to purge data. The Traffic Report Counts window shows the current number of reports by type using the actual database table name.
The following lists the database table name to the report name available from the Reports navigator. Any table name that includes the word Archive (such as ECAlertArchive) shows the number of traffic reports in the traffic data archive.
| Database Table Name | View in Traffic Reports |
|---|---|
| ECAlert | Traffic Alert |
| ECICStatus | Data Type View |
| EDF_Status_IC | EDIFACT Interchanges |
| EDF_Status_FG | EDIFACT Functional Groups |
| EDF_Status_Msg | EDIFACT Messages |
| EDF_Status_SegErr | EDIFACT Segment Errors |
| EDF_Status_DEErr | EDIFACT Data Element Errors |
| X12DEError | X12 Data Element errors; if these errors exist, they are shown in the traffic reports segment error views. See Traffic Reports. |
| X12FGStatus | X12 Functional Groups |
| X12ICStatus | X12 Interchanges |
| X12SegError | X12 Segment errors; if these errors exist, they are shown in the Reports navigator under Transmissions. See Reports Navigator Overview. |
| X12TSStatus | X12 Transactions |
| MapStatus | Transmissions |
| TRCICStatus | TRADACOMS interchanges |
| TRCDocHeader | TRADACOMS document header |
| TRCDocBody | TRADACOMS document body |
| TRCSegError | TRADACOMS document segment errors |
| TRCDEError | TRADACOMS document data element errors |
To check the traffic table report count