How is the data populated into the data warehouse?
Once the data is extracted from SR and CPI, some transformations are performed as the data is loaded into the data warehouse. The loading criteria are slightly different from the collection criteria. For example, the single data element discipline event context and location code is split into separate time and place codes in the data warehouse. Therefore, in some reports, the data will be displayed differently because the storage structures are different.
