Line 35: |
Line 35: |
| |No | | |No |
| |NULL | | |NULL |
− | |00070-QUART HEALTHCARE INC. | + | |00070-MDCCD HEALTHCARE INC |
| |This is the inspection number. | | |This is the inspection number. |
| | | | | |
Line 832: |
Line 832: |
| |No | | |No |
| |NULL | | |NULL |
− | |MDCCD Healthcare | + | |00070-MDCCD HEALTHCARE INC |
| |This is the parent inspection number. | | |This is the parent inspection number. |
| | | | | |
Line 938: |
Line 938: |
| |No | | |No |
| |NULL | | |NULL |
− | | MDCCD Healthcare | + | | 00070-MDCCD HEALTHCARE INC |
| |This is the parent inspection number. | | |This is the parent inspection number. |
| | | | | |
Line 1,061: |
Line 1,061: |
| |No | | |No |
| |NULL | | |NULL |
− | |MDCCD Healthcare | + | |00070-MDCCD HEALTHCARE INC |
| |This is the parent inspection number. | | |This is the parent inspection number. |
| | | | | |
Line 1,176: |
Line 1,176: |
| |No | | |No |
| |NULL | | |NULL |
− | |MDCCD Healthcare | + | |00070-MDCCD HEALTHCARE INC |
| |This is the parent inspection number. | | |This is the parent inspection number. |
| | | | | |
Line 1,318: |
Line 1,318: |
| |No | | |No |
| | NULL | | | NULL |
− | |MDCCD Healthcare | + | |00070-MDCCD HEALTHCARE INC |
| |This is the parent inspection number. | | |This is the parent inspection number. |
| | | | | |
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,392: |
Line 1,392: |
| ! scope="col" style="width: 350px;" |Comments | | ! scope="col" style="width: 350px;" |Comments |
| |- | | |- |
| + | |OBS_ID |
| + | |VARCHAR2(36 CHAR) |
| + | |Primary |
| + | |No |
| + | |NULL |
| + | |5c6afa3c-3f8a-4641-8da4-9588ec7769d7 |
| + | |This is the unique record identifier for the observation. |
| | | | | |
| + | |- |
| + | |OBS_NUM |
| + | |VARCHAR2(200 CHAR) |
| | | | | |
| + | |No |
| + | |NULL |
| + | |00070-MDCCD HEALTHCARE INC -obs0001132 |
| + | |This is the observation number. |
| | | | | |
| + | |- |
| + | |INSP_ID |
| + | |VARCHAR2(36 CHAR) |
| + | |Foreign |
| + | |No |
| + | |NULL |
| + | |5c6afa3c-3f8a-4641-8da4-9588ec7769d7 |
| + | |This is the unique record identifier for the parent inspection. |
| + | |Use to join with MD_INS_CASE.INSP_ID. |
| + | |- |
| + | |INSP_NUM |
| + | |VARCHAR2(200 CHAR) |
| + | |Foreign |
| + | |No |
| + | |NULL |
| + | |00070-MDCCD HEALTHCARE INC |
| + | |This is the parent inspection number. |
| + | |- |
| + | |OBS_TYPE_EN |
| + | |VARCHAR2(200 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |MDR - Establishment licence |
| + | |This identifies the overall category of the Medical Device Regulations that the observation is cited under in English. |
| | | | | |
| + | |- |
| + | |OBS_TYPE_FR |
| + | |VARCHAR2(200 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |RIM - Licence d’établissement |
| + | |This identifies the overall category of the Medical Device Regulations that the observation is cited under in French. |
| | | | | |
| |- | | |- |
| + | |REG_SECTION_EN |
| + | |VARCHAR2(150 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |s.45 (f) Device classes |
| + | |This identifies the specific section/subsection of the Medical Device Regulations that the observation is cited under in English. |
| | | | | |
| + | |- |
| + | |REG_SECTION_FR |
| + | |VARCHAR2(150 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |MDR s.45 (f) Classes des instruments |
| + | |This identifies the specific section/subsection of the Medical Device Regulations that the observation is cited under in French. |
| | | | | |
| + | |- |
| + | |OBS_RISK |
| + | |NUMBER(1,0) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |1 |
| + | |This identifies the risk level of the observation. |
| + | |Scale 1-3. Risk 1 is the highest and risk 3 is the lowest. |
| + | |- |
| + | |OBS_REPEAT_EN |
| + | |VARCHAR2(30 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Repeat Observation |
| + | |This indicates if the observation has occurred before on a previous inspection with the company in English. |
| | | | | |
| |- | | |- |
| + | |OBS_REPEAT_FR |
| + | |VARCHAR2(30 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Observation répétée |
| + | |This indicates if the observation has occurred before on a previous inspection with the company in French. |
| | | | | |
| + | |- |
| + | |OBS_STATUS_EN |
| + | |VARCHAR2(50 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Open |
| + | |This indicates the status of the observation in English. |
| + | |- |
| + | |OBS_STATUS_FR |
| + | |VARCHAR2(50 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Ouvert |
| + | |This indicates the status of the observation in French. |
| | | | | |
| + | |- |
| + | |OBS_INCLUDEREPORT_EN |
| + | |VARCHAR2(3 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Yes |
| + | |This indicates whether the observation is included on the inspection report in English. |
| | | | | |
− | |} | + | |- |
− | | + | |OBS_INCLUDEREPORT_FR |
− | ===MD_INS_CASE_WORKFLOW===
| + | |VARCHAR2(3 CHAR) |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| |
− | | |
− | This table holds information that categorizes or "tags" an inspection.
| |
− | {| class="wikitable sortable mw-collapsible"
| |
− | |+
| |
− | ! scope="col" style="width: 350px;" | Column Name
| |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
− | |-
| |
− | | | |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Oui |
| + | |This indicates whether the observation is included on the inspection report in French. |
| | | | | |
| + | |- |
| + | |OBS_SEQ_NUM |
| + | |NUMBER(3,0) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |1 |
| + | |This indicates the order that the observations will print on the inspection report. |
| | | | | |
| + | |- |
| + | |OBS_STDLINE_EN |
| + | |VARCHAR2(1000 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |A written procedure was not provided. |
| + | |This is a standard line related to the section of the regulation cited in English. |
| | | | | |
| |- | | |- |
| + | |OBS_STDLINE_FR |
| + | |VARCHAR2(1000 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Une procédure écrite n'avait pas été fournie |
| + | |This is a standard line related to the section of the regulation cited in French. |
| | | | | |
| + | |- |
| + | |OBS_NARRATIVE |
| + | |VARCHAR2(4000 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |/*A written procedure was not provided. */ |
| + | |
| + | |
| + | The company did not have a written procedure in place for complaint handling. |
| + | |This is the inspector's narrative related to the observation. |
| | | | | |
| + | |- |
| + | |OBS_SUMMARY |
| + | |VARCHAR2(2000 CHAR) |
| | | | | |
− | | | + | |Yes |
| + | |NULL |
| + | |Observation #: 01 |
| + | |
| + | Status / Statut : Open / Ouvert |
| + | |
| + | Risk / Risque : 1 |
| + | |
| + | MDR - Establishment licence / RIM - Licence d’établissement |
| + | |
| + | MDR s.45 (f) Device classes / MDR s.45 (f) Classes des instruments |
| + | |
| + | |
| + | /*A written procedure was not provided. */ |
| + | |
| + | |
| + | The company did not have a written procedure in place for complaint handling. |
| + | |This is the overall summary of the observation that built from the above columns. |
| | | | | |
| |- | | |- |
| + | |CREATEDBYNAME |
| + | |VARCHAR2(100 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |John Smith |
| + | |This identifies the resource that created the record. |
| + | |- |
| + | |CREATEDON |
| + | |DATE |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |22-08-26 |
| + | |This identifies the date that record was created. |
| | | | | |
| + | |- |
| + | |MODIFIEDBYNAME |
| + | |VARCHAR2(100 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |John Smith |
| + | |This identifies the resource that last modified the record. |
| | | | | |
| + | |- |
| + | |MODIFIEDON |
| + | |DATE |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |22-08-26 |
| + | |This identifies the date that record was last modified. |
| | | | | |
| |} | | |} |
| | | |
− | ===MD_INS_INS_IID=== | + | ===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" |
| |+ | | |+ |
| ! scope="col" style="width: 350px;" | Column Name | | ! scope="col" style="width: 350px;" | Column Name |
| ! scope="col" style="width: 100px;" |DataType | | ! scope="col" style="width: 100px;" |DataType |
− | ! scope="col" style="width: 50px;" |Key Type | + | ! scope="col" style="width: 50px;" | Key Type |
| ! scope="col" style="width: 50px;" |Nullable | | ! scope="col" style="width: 50px;" |Nullable |
| ! scope="col" style="width: 50px;" |Data Default | | ! scope="col" style="width: 50px;" |Data Default |
| ! scope="col" style="width: 500px;" |Example Data | | ! scope="col" style="width: 500px;" |Example Data |
− | ! scope="col" style="width: 350px;" | Description | + | ! scope="col" style="width: 350px;" |Description |
| ! scope="col" style="width: 350px;" |Comments | | ! scope="col" style="width: 350px;" |Comments |
| |- | | |- |
− | | | + | |WF_ID |
− | | | + | |VARCHAR2(36 CHAR) |
− | | | + | |Primary |
− | | | + | |No |
− | | | + | |NULL |
− | | | + | |5c6afa3c-3f8a-4641-8da4-9588ec7769d7 |
| + | |This is the unique record identifier for the workflow. |
| | | | | |
| |- | | |- |
| + | |WF_NAME |
| + | |VARCHAR2(50 BYTE) |
| | | | | |
− | | | + | |Yes |
− | | | + | |NULL |
− | | | + | |Inspection Business Process |
− | | | + | |This is the name of the workflow. |
− | |
| |
| | | | | |
| |- | | |- |
| + | |INSP_ID |
| + | |VARCHAR2(36 CHAR) |
| + | |Foreign |
| + | |No |
| + | |NULL |
| + | |5c6afa3c-3f8a-4641-8da4-9588ec7769d7 |
| + | |This is the unique record identifier for the parent inspection. |
| + | |Use to join with MD_INS_CASE.INSP_ID. |
| + | |- |
| + | |INSP_NUM |
| + | |VARCHAR2(200 CHAR) |
| + | | |
| + | |No |
| + | |NULL |
| + | |00070-MDCCD HEALTHCARE INC |
| + | |This is the parent inspection number. |
| + | | |
| + | |- |
| + | |ACTIVESTAGEID |
| + | |VARCHAR2(36 CHAR) |
| | | | | |
| + | |No |
| + | |NULL |
| + | |5c6afa3c-3f8a-4641-8da4-9588ec7769d7 |
| + | |This is the unique record identifier for the current stage of the workflow. |
| | | | | |
| + | |- |
| + | |STAGE_NAME_EN |
| + | |VARCHAR2(50 BYTE) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Start Of Inspection |
| + | |This is the name of the current workflow stage in English. |
| | | | | |
| + | |- |
| + | |STAGE_NAME_FR |
| + | |VARCHAR2(50 BYTE) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |Début de l'inspection |
| + | |This is the name of the current workflow stage in French. |
| | | | | |
| + | |- |
| + | |STAGE_START_DATE |
| + | |DATE |
| | | | | |
− | |} | + | |Yes |
− | | + | |NULL |
− | ===MD_INS_INS_INSPECTORLIST===
| + | |23-11-09 |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| + | |This is the date that the current workflow stage was started. |
− | | |
− | This table holds information that categorizes or "tags" an inspection.
| |
− | {| class="wikitable sortable mw-collapsible"
| |
− | |+
| |
− | ! scope="col" style="width: 350px;" | Column Name
| |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
− | |-
| |
− | | | |
− | |
| |
| | | | | |
| + | |- |
| + | |WF_COMPLETE_DATE |
| + | |DATE |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |23-11-09 |
| + | |This is the date the workflow was completed. |
| | | | | |
| + | |- |
| + | |WF_DURATION |
| + | |NUMBER(4,0) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |42 |
| + | |This identifies how many days the workflow was active. |
| | | | | |
| |- | | |- |
| + | |CREATEDBYNAME |
| + | |VARCHAR2(100 CHAR) |
| | | | | |
− | | | + | |Yes |
− | | | + | |NULL |
− | | | + | |John Smith |
− | | | + | |This identifies the resource that created the record. |
− | |
| |
| | | | | |
| |- | | |- |
| + | |CREATEDON |
| + | |DATE |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |22-08-26 |
| + | |This identifies the date that record was created. |
| + | |- |
| + | |MODIFIEDBYNAME |
| + | |VARCHAR2(100 CHAR) |
| | | | | |
| + | |Yes |
| + | |NULL |
| + | |John Smith |
| + | |This identifies the resource that last modified the record. |
| | | | | |
| + | |- |
| + | |MODIFIEDON |
| + | |DATE |
| | | | | |
− | | | + | |Yes |
− | | | + | |NULL |
| + | |22-08-26 |
| + | |This identifies the date that record was last modified. |
| | | | | |
| |} | | |} |
| | | |
− | ===MD_INS_INS_IRC_ENFORCEMENT=== | + | |
| + | ===MD_INS_INS_IID=== |
| [[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" |
| |+ | | |+ |
| ! scope="col" style="width: 350px;" | Column Name | | ! scope="col" style="width: 350px;" | Column Name |
| ! scope="col" style="width: 100px;" |DataType | | ! scope="col" style="width: 100px;" |DataType |
− | ! scope="col" style="width: 50px;" |Key Type | + | ! scope="col" style="width: 50px;" | Key Type |
| ! scope="col" style="width: 50px;" |Nullable | | ! scope="col" style="width: 50px;" |Nullable |
| ! scope="col" style="width: 50px;" |Data Default | | ! scope="col" style="width: 50px;" |Data Default |
| ! scope="col" style="width: 500px;" |Example Data | | ! scope="col" style="width: 500px;" |Example Data |
− | ! scope="col" style="width: 350px;" | Description | + | ! scope="col" style="width: 350px;" |Description |
| ! scope="col" style="width: 350px;" |Comments | | ! scope="col" style="width: 350px;" |Comments |
| |- | | |- |
Line 1,575: |
Line 1,803: |
| | | | | |
| | | | | |
− | |} | + | | |
− | | + | |- |
− | ===MD_INS_INS_IRC_MEASURES===
| + | | |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| + | | |
− | | + | | |
− | This table holds information that categorizes or "tags" an inspection.
| + | | |
− | {| class="wikitable sortable mw-collapsible"
| + | | |
− | |+
| + | | |
− | ! scope="col" style="width: 350px;" | Column Name
| + | | |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
| |- | | |- |
| | | | | |
Line 1,615: |
Line 1,836: |
| | | | | |
| | | | | |
− | |}
| |
− |
| |
− | === MD_INS_INS_IRC_OBSERVATIONS===
| |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| |
− |
| |
− | This table holds information that categorizes or "tags" an inspection.
| |
− | {| class="wikitable sortable mw-collapsible"
| |
− | |+
| |
− | ! scope="col" style="width: 350px;" | Column Name
| |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
| |- | | |- |
| | | | | |
Line 1,649: |
Line 1,854: |
| |- | | |- |
| | | | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| | | | | |
| | | | | |
Line 1,656: |
Line 1,892: |
| | | | | |
| |} | | |} |
− | | + | |
− | === MD_INS_INS_SITE=== | + | ===MD_INS_INS_INSPECTORLIST=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | This table holds a list of inspectors within the system. |
| + | {| class="wikitable sortable mw-collapsible" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" | Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" | Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" |Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_IRC_ENFORCEMENT=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | 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" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" | Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" | Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" |Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_IRC_MEASURES=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | 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" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" | Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" | Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" |Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_IRC_OBSERVATIONS=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | This table holds the list of observations for the Inspection Report Card posted on the DHPID. |
| + | {| class="wikitable sortable mw-collapsible" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" | Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" | Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" |Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_SITE=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | This table holds the site/company dictionary. This information is migrated from MDS. |
| + | {| class="wikitable sortable mw-collapsible" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" | Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" | Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" |Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_SITE_CONTACT=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | This table holds the site/company contact listing. This information is partially migrated from MDS. |
| + | {| class="wikitable sortable mw-collapsible" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" |Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" |Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" |Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_LICENCE=== |
| + | [[MDCCD Data Warehouse|Return to Home Page.]] |
| + | |
| + | This table holds the establishment licence dictionary. This information is migrated from MDS. |
| + | {| class="wikitable sortable mw-collapsible" |
| + | |+ |
| + | ! scope="col" style="width: 350px;" | Column Name |
| + | ! scope="col" style="width: 100px;" |DataType |
| + | ! scope="col" style="width: 50px;" | Key Type |
| + | ! scope="col" style="width: 50px;" |Nullable |
| + | ! scope="col" style="width: 50px;" |Data Default |
| + | ! scope="col" style="width: 500px;" |Example Data |
| + | ! scope="col" style="width: 350px;" | Description |
| + | ! scope="col" style="width: 350px;" |Comments |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |- |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | | |
| + | |} |
| + | |
| + | ===MD_INS_INS_SITELICENCEACTIVITY=== |
| [[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" |
| |+ | | |+ |
| ! scope="col" style="width: 350px;" | Column Name | | ! scope="col" style="width: 350px;" | Column Name |
| ! scope="col" style="width: 100px;" |DataType | | ! scope="col" style="width: 100px;" |DataType |
− | ! scope="col" style="width: 50px;" |Key Type | + | ! scope="col" style="width: 50px;" | Key Type |
| ! scope="col" style="width: 50px;" |Nullable | | ! scope="col" style="width: 50px;" |Nullable |
| ! scope="col" style="width: 50px;" |Data Default | | ! scope="col" style="width: 50px;" |Data Default |
| ! scope="col" style="width: 500px;" |Example Data | | ! scope="col" style="width: 500px;" |Example Data |
− | ! scope="col" style="width: 350px;" | Description | + | ! scope="col" style="width: 350px;" |Description |
| ! scope="col" style="width: 350px;" |Comments | | ! scope="col" style="width: 350px;" |Comments |
| |- | | |- |
Line 1,689: |
Line 2,933: |
| |- | | |- |
| | | | | |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |}
| |
− |
| |
− | ===MD_INS_INS_SITE_CONTACT===
| |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| |
− |
| |
− | This table holds information that categorizes or "tags" an inspection.
| |
− | {| class="wikitable sortable mw-collapsible"
| |
− | |+
| |
− | ! scope="col" style="width: 350px;" | Column Name
| |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
− | |-
| |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |
| |
− | |-
| |
| | | | | |
| | | | | |
Line 1,735: |
Line 2,948: |
| | | | | |
| | | | | |
− | |}
| |
− |
| |
− | ===MD_INS_INS_LICENCE===
| |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| |
− |
| |
− | This table holds information that categorizes or "tags" an inspection.
| |
− | {| class="wikitable sortable mw-collapsible"
| |
− | |+
| |
− | ! scope="col" style="width: 350px;" | Column Name
| |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
| |- | | |- |
| | | | | |
Line 1,775: |
Line 2,972: |
| | | | | |
| | | | | |
− | |}
| |
− |
| |
− | ===MD_INS_INS_SITELICENCEACTIVITY===
| |
− | [[MDCCD Data Warehouse|Return to Home Page.]]
| |
− |
| |
− | This table holds information that categorizes or "tags" an inspection.
| |
− | {| class="wikitable sortable mw-collapsible"
| |
− | |+
| |
− | ! scope="col" style="width: 350px;" | Column Name
| |
− | ! scope="col" style="width: 100px;" |DataType
| |
− | ! scope="col" style="width: 50px;" |Key Type
| |
− | ! scope="col" style="width: 50px;" |Nullable
| |
− | ! scope="col" style="width: 50px;" |Data Default
| |
− | ! scope="col" style="width: 500px;" |Example Data
| |
− | ! scope="col" style="width: 350px;" | Description
| |
− | ! scope="col" style="width: 350px;" |Comments
| |
| |- | | |- |
| | | | | |
Line 1,808: |
Line 2,989: |
| | | | | |
| |- | | |- |
− | |
| |
| | | | | |
| | | | | |