Eagle Performance has three different types of tables in PERFORMDBO that should have a purge and archive strategy identified:
...
This table stores the audit history of any time performance is committed. If you are going to purge or archive this table, you can do so by UPDATE_DATE so the most recent year or six months is available. If you archive, you can always get the data back if an audit question arises.
...
Info |
---|
Be aware that if you archive the associated record in this table, you cannot finalize or un-finalize performance using the Commit Journal. |
Anchor | ||||
---|---|---|---|---|
|
...
Anchor | ||||
---|---|---|---|---|
|
The results tables are currently specific to Retail Fund Performance. You can purge or archive these tables based on the results you require. The data tables are described as follows.
...