Changes

no edit summary
Line 1,380: Line 1,380:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds information about the observations for an inspection.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,623: Line 1,623:  
|}
 
|}
   −
===MD_INS_INS_SITELICENCEACTIVITY===
+
===MD_INS_INS_CASE_WORKFLOW===
 
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds information about the workflow of the inspection.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,723: Line 1,723:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the Initial Inspection Deficiency information for an inspection that is posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,851: Line 1,851:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds a list of inspectors within the system.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,955: Line 1,955:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the list of enforcement actions taken by Health Canada for the Inspection Report Card posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,043: Line 2,043:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the list of corrective measures taken by Health Canada for the Inspection Report Card posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,131: Line 2,131:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the list of observations for the Inspection Report Card posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,291: Line 2,291:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the site/company dictionary. This information is migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,523: Line 2,523:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the site/company contact listing. This information is partially migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,707: Line 2,707:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the establishment licence dictionary. This information is migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,859: Line 2,859:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the establishment licence activity dictionary. This information is migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
67

edits