Maintain Audit Trail
To ensure that the reporting layer does not treat the Cohorts as separate accounts and to maintain data for audit purposes the Cohorts and the corresponding values are copied into another table, Collective Assessment, and then are removed from the Account Details fact table.