<< Click to Display Table of Contents >> Navigation:  General Functions > Archiving Customer Data (ESI Only) > Important Notes

1.  There are a few tables on the MIE that have multiple columns participating in the primary key.  The tables where that currently is the case are the archive and offline staging tables (ATdataIMACStageArchive and ATdataIMACStageOffline).  These tables use the iStageNo and the Updated column together as the primary key.  The archiving logic current expects a single column primary key, so what it ends up doing is trimming these tables (keeps the first unique record of each series).  The row counts in these tables will be fewer, usually, than the source table.