71
edits
Changes
no edit summary
[[fr:Entrepôt de données d'DCMMMC]]
{{Delete|reason=Page has been moved to internal Health Canada wiki. Internal database structure should not be public.}}
== Overview ==
== Overview ==
The Medical Device and Clinical Compliance (MDCCD) Data Warehouse is an Oracle 19c based data warehouse maintained by Shared Services Canada (SSC) and Health Canada's (HC) Digital Transformation Branch (DTB).
The Medical Device and Clinical Compliance (MDCCD) Data Warehouse is an Oracle 19c based data warehouse maintained by Shared Services Canada (SSC) and Health Canada's (HC) Digital Transformation Branch (DTB).
The MDCCD Data Warehouse uses a concept called "Fundamental Datasets". Fundamental Datasets are meant to be a standardized dataset that is optimized for
The MDCCD Data Warehouse uses a concept called "Fundamental Datasets". Fundamental Datasets are meant to be a standardized dataset that is optimized for business intelligence and data science.
== Problems to Address ==
== Problems to Address ==
|-
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE WORKFLOW|MD_INS_CASE_WORKFLOW]]
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE WORKFLOW|MD_INS_CASE_WORKFLOW]]
|This table holds the busienss process flow (workflow) for an inspection.
|This table holds the business process flow (workflow) for an inspection.
|-
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IID|MD_INS_IID]]
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IID|MD_INS_IID]]