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" |
| |+ | | |+ |