Accounting Activity Data Flows

Imports

Accounting activity is imported into the AccountingActivity table in the CBSFinancialFrontend database. It loads all activity from the last 10 days where the accounting activity key does not exist in the AccountingActivity table, thus if the data warehouse load fails the data will be inserted on the next run of the program.

Exports

When accounting activity is reconciled it is flagged as such and the ReconciledDate field is populated with the current date and time. There is then a separate process on the SQL server that deletes all accounting activity records that are reconciled and where the reconciled date is older than 20 days, allowing a buffer from when the deletion actually occurs.