Evidence and Reports Data Warehouse

Executive Summary

Within the RCMP's "E" Division, an investigation may be considered a "major case" if it is serious, complex, and resource intensive. Investigations that are deemed to be a "major case" will apply the Major Case Management (MCM) model. The MCM model establishes the foundation for managing major cases by planning, setting priorities, meeting objectives, allocating resources, and the overall speed, flow, direction and accountability of the investigation.

To support the information management needs of the MCM model, investigative teams employ the Evidence and Reports III (E&R) electronic major case management system. E&R allows investigators to 'task' (assign a duty), 'report' (report back on duty assigned) and store investigative material gathered through the course of the investigation. Each new E&R investigation requires the creation of a standalone database which limits the ability of Criminal Operations (CROPS) to analyze and report on major investigations.

The E&R Data Warehouse (E&RDW) is a Protected B platform that consolidates information from the set of standalone E&R databases into a single searchable source^{Footnote 1}. This consolidation will allow for enhanced de-confliction^{Footnote 2}, robust reporting to senior management, an improved ability to conduct criminal intelligence analysis, and a greater impact on public safety. Material extracted from E&R into the E&RDW will include tombstone data for persons related to or involved in the file, vehicle registration information, supporting documents received, documents created by investigators (e.g. officer notes), locations of various businesses or residences and witness/suspect interviews.

The E&RDW will be made available to authorized "E" Division Criminal Intelligence Analysts through a standard analytical tool (e.g. iBase). These Criminal Intelligence Analysts are subject to Top Secret security requirements as a condition of their role.

Date modified:

2018-05-22