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 ==
* 4 Code: [PROGRAM]_[FUNCTION]_[TABLE GROUP]_[TABLE]
* 4 Code: [PROGRAM]_[FUNCTION]_[TABLE GROUP]_[TABLE]
** Example: MD_INS_CASE_CAPA (Medical Device Inspections, Case Table Grouping, Corrective Action Plan Table.)
** Example: MD_INS_CASE_CAPA (Medical Device Inspections, Case Table Grouping, Corrective Action Plan Table.)
=== Table Listing by Schema & Program ===
==== MDCCD_DM_OWNER ====
{| class="wikitable"
|+Medical Devices
!Table Name
!Table Description
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE|MD_INS_CASE]]
|This table is the main medical device inspection table.
|-
|[[:en:MDCCD_Data_Warehouse_Data_Dictionary#MD_INS_CASE_CAPA|MD_INS_CASE_CAPA]]
|This table holds information about the corrective action plan for an inspection observation.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE DESIGNATION|MD_INS_CASE_DESIGNATION]]
|This table holds designation codes for an inspection.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE ESTACTIVITY|MD_INS_CASE_ESTACTIVITY]]
|This table holds the activities of the establishment as entered by the inspector.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE INSPECTORS|MD_INS_CASE_INSPECTORS]]
|This table holds a list of inspectors working on the inspection.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE NOTES|MD_INS_CASE_NOTES]]
|This table holds the notes for an inspection.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE OBSERVATIONS|MD_INS_CASE_OBSERVATIONS]]
|This table holds the observations for an inspection.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE WORKFLOW|MD_INS_CASE_WORKFLOW]]
|This table holds the business process flow (workflow) for an inspection.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IID|MD_INS_IID]]
|This table holds the ''Initial Inspection Deficiency'' information for an inspection.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS INSPECTORLIST|MD_INS_INSPECTORLIST]]
|This table holds a list of inspectors in the MDID system.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IRC ENFORCEMENT|MD_INS_IRC_ENFORCEMENT]]
|This table holds the enforcement actions listed for an inspection as part of the ''Inspection Report Card''.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IRC MEASURES|MD_INS_IRC_MEASURES]]
|This table holds the measures listed for an inspection as part of the ''Inspection Report Card''.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IRC OBSERVATIONS|MD_INS_IRC_OBSERVATIONS]]
|This table holds the observations listed for an inspection as part of the ''Inspection Report Card''.
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS SITE|MD_INS_SITE]]
|This table holds the listing of sites from the MDID system including those migrated from the Medical Device System (MDS).
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS SITE CONTACT|MD_INS_SITE_CONTACT]]
|This table holds the listing of site contacts from the MDID system including those migrated from the Medical Device System (MDS).
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS LICENCE|MD_INS_SITE_LICENCE]]
|This table holds the listing of site establishment licences from the MDID system including those migrated from the Medical Device System (MDS).
|-
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS SITELICENCEACTIVITY|MD_INS_SITE_LICENCEACTIVITY]]
|This table holds the listing of site establishment licence activities from the MDID system including those migrated from the Medical Device System (MDS).
|}
== Contacts ==
== Contacts ==
=== Access & Questions ===
* Jeff Tyndall (jeff.tyndall@hc-sc.gc.ca)
* Caroline Mimeault (caroline.mimeault@hc-sc.gc.ca)