67
edits
Changes
no edit summary
!Table Description
!Table Description
|-
|-
|MD_INS_CASE
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE|MD_INS_CASE]]
|This table is the main medical device inspection table.
|This table is the main medical device inspection table.
|-
|-
|This table holds information about the corrective action plan for an inspection observation.
|This table holds information about the corrective action plan for an inspection observation.
|-
|-
|MD_INS_CASE_DESIGNATION
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE DESIGNATION|MD_INS_CASE_DESIGNATION]]
|This table holds designation codes for an inspection.
|This table holds designation codes for an inspection.
|-
|-
|MD_INS_CASE_ESTACTIVITY
|[[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.
|This table holds the activities of the establishment as entered by the inspector.
|-
|-
|MD_INS_CASE_INSPECTORS
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE INSPECTORS|MD_INS_CASE_INSPECTORS]]
|This table holds a list of inspectors working on the inspection.
|This table holds a list of inspectors working on the inspection.
|-
|-
|MD_INS_CASE_NOTES
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE NOTES|MD_INS_CASE_NOTES]]
|This table holds the notes for an inspection.
|This table holds the notes for an inspection.
|-
|-
|MD_INS_CASE_OBSERVATIONS
|[[MDCCD Data Warehouse Data Dictionary#MD INS CASE OBSERVATIONS|MD_INS_CASE_OBSERVATIONS]]
|This table holds the observations for an inspection.
|This table holds the observations for an inspection.
|-
|-
|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 busienss process flow (workflow) for an inspection.
|-
|-
|MD_INS_IID
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS IID|MD_INS_IID]]
|This table holds the ''Initial Inspection Deficiency'' information for an inspection.
|This table holds the ''Initial Inspection Deficiency'' information for an inspection.
|-
|-
|MD_INS_INSPECTORLIST
|[[MDCCD Data Warehouse Data Dictionary#MD INS INS INSPECTORLIST|MD_INS_INSPECTORLIST]]
|This table holds a list of inspectors in the MDID system.
|This table holds a list of inspectors in the MDID system.
|-
|-
|MD_INS_IRC_ENFORCEMENT
|[[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''.
|This table holds the enforcement actions listed for an inspection as part of the ''Inspection Report Card''.
|-
|-
|MD_INS_IRC_MEASURES
|[[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''.
|This table holds the measures listed for an inspection as part of the ''Inspection Report Card''.
|-
|-
|MD_INS_IRC_OBSERVATIONS
|[[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''.
|This table holds the observations listed for an inspection as part of the ''Inspection Report Card''.
|-
|-
|MD_INS_SITE
|[[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).
|This table holds the listing of sites from the MDID system including those migrated from the Medical Device System (MDS).
|-
|-
|MD_INS_SITE_CONTACT
|[[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).
|This table holds the listing of site contacts from the MDID system including those migrated from the Medical Device System (MDS).
|-
|-
|MD_INS_SITE_LICENCE
|[[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).
|This table holds the listing of site establishment licences from the MDID system including those migrated from the Medical Device System (MDS).
|-
|-
|MD_INS_SITE_LICENCEACTIVITY
|[[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).
|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)