67
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + + + − + − + − + − + − !Nullable+ − + − + − + − + Line 31:
Line 35: − + Line 40:
Line 44: − + Line 46:
Line 50: − + − + − + − + Line 67:
Line 71: − + Line 76:
Line 80: − + Line 82:
Line 86: − + − + Line 95:
Line 99: − + − + − + − + Line 112:
Line 116: − + Line 130:
Line 134: − + Line 136:
Line 140: − + − + − + Line 148:
Line 152: − + Line 154:
Line 158: − + − + Line 175:
Line 179: − + Line 185:
Line 189: − + Line 193:
Line 197: − + − + − + Line 219:
Line 223: − + Line 226:
Line 230: − + Line 245:
Line 249: − + Line 263:
Line 267: − + − + − + Line 276:
Line 280: − + − + Line 289:
Line 293: − + − + Line 298:
Line 302: − + − + Line 328:
Line 332: − + Line 334:
Line 338: − + − + Line 379:
Line 383: − + Line 391:
Line 395: − + Line 400:
Line 404: − + Line 409:
Line 413: − + − + Line 417:
Line 421: − + − + Line 426:
Line 430: − + Line 435:
Line 439: − + Line 442:
Line 446: − + − + Line 452:
Line 456: − + − + Line 459:
Line 463: − + − + Line 470:
Line 474: − + Line 479:
Line 483: − + Line 488:
Line 492: − + Line 506:
Line 510: − + Line 522:
Line 526: − + − + Line 539:
Line 543: − + − + Line 550:
Line 554: − + Line 556:
Line 560: − + − + Line 577:
Line 581: − + − + − + − + Line 599:
Line 603: − + Line 613:
Line 617: − + Line 623:
Line 627: − + Line 637:
Line 641: − + Line 687:
Line 691: − + Line 693:
Line 697: − + Line 705:
Line 709: − + Line 711:
Line 715: − + − + Line 723:
Line 727: − + − + Line 740:
Line 744: − + Line 758:
Line 762: − + Line 764:
Line 768: − + Line 776:
Line 780: − + − + Line 791:
Line 795: + + − + − + − + − + − + − + − + − + − + − + − + Line 817:
Line 823: − + Line 826:
Line 832: − + Line 835:
Line 841: − + Line 843:
Line 849: − + Line 849:
Line 855: − + − + Line 862:
Line 868: − + Line 880:
Line 886: − + − + Line 895:
Line 901: + + − + − + − + − + − + − + − + − + + Line 910:
Line 919: − + + Line 918:
Line 928: − + + Line 926:
Line 937: − + + + Line 933:
Line 946: − + + − + + Line 946:
Line 961: − + + − | Line 957:
Line 972: + Line 962:
Line 978: − + − + + Line 973:
Line 990: − + + Line 981:
Line 999: + + Line 988:
Line 1,008: − + − + + + Line 995:
Line 1,017: + + + + − + − + − + − + − + − + − + − + + Line 1,015:
Line 1,042: − + + − + − + + Line 1,031:
Line 1,060: − + + Line 1,039:
Line 1,069: − + + − + − + + Line 1,054:
Line 1,086: − + + Line 1,063:
Line 1,096: − + + Line 1,071:
Line 1,105: − + + Line 1,079:
Line 1,114: + − + − + − + + Line 1,095:
Line 1,132: + Line 1,101:
Line 1,139: + + − + − + − + − + − + − + − + − + + Line 1,116:
Line 1,157: − + + Line 1,124:
Line 1,166: − + + Line 1,132:
Line 1,175: − + + Line 1,140:
Line 1,184: − + + − + − + + Line 1,153:
Line 1,199: − + − + + Line 1,162:
Line 1,209: − + + Line 1,170:
Line 1,218: − + − + + Line 1,178:
Line 1,227: − + + − + − + + Line 1,196:
Line 1,247: − + + Line 1,204:
Line 1,256: + Line 1,212:
Line 1,265: − + − + + Line 1,220:
Line 1,274: + Line 1,226:
Line 1,281: + + − + − + − + − + − + − + − + − + + Line 1,241:
Line 1,299: − + + Line 1,249:
Line 1,308: − + + Line 1,257:
Line 1,317: − + + Line 1,265:
Line 1,326: + − + − + + Line 1,281:
Line 1,344: − + + Line 1,289:
Line 1,353: + Line 1,297:
Line 1,362: − + − + + Line 1,305:
Line 1,371: + Line 1,311:
Line 1,378: − + − + + + − + − + − + − + − + − + − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − + − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − |} − − ===MD_INS_CASE_WORKFLOW=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − ! Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments + + + + + + + + + + + + + + + + − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Line 1,372:
Line 2,787: − | − | − |- − | − | − | − | − | − | − | − |} − − ===MD_INS_INS_IID=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments − |- − | − | − | − | − | − | Line 1,419:
Line 2,804: − |} − − ===MD_INS_INS_INSPECTORLIST=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments Line 1,456:
Line 2,828: − |} − − ===MD_INS_INS_IRC_ENFORCEMENT=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments Line 1,493:
Line 2,852: − |} − − ===MD_INS_INS_IRC_MEASURES=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − ! Column Name − !Data Type − ! Key Type − !Nullable − ! Example Data − !Description − !Comments Line 1,530:
Line 2,876: − |} − − ===MD_INS_INS_IRC_OBSERVATIONS=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − ! Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments Line 1,566:
Line 2,899: − + − + + + − ===MD_INS_INS_SITE===+ − + − − + − + − + − + − + − + − + + Line 1,598:
Line 2,933: − | − | − | − | − | − | − |} − − ===MD_INS_INS_SITE_CONTACT=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments − |- − | − | − | − | − | − | − | − |- Line 1,641:
Line 2,948: − |} − − ===MD_INS_INS_LICENCE=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − ! Example Data − !Description − !Comments Line 1,678:
Line 2,972: − |} − − ===MD_INS_INS_SITELICENCEACTIVITY=== − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments Line 1,708:
Line 2,989: − |
no edit summary
== Overview ==
== Overview ==
This page provides a data dictionary for each table that is held within the [[MDCCD Data Warehouse]].
This page provides a data dictionary for each table that is held within the [[MDCCD Data Warehouse]].
'''DISCLAIMER''': All data in the "Example Data" column is fictitious and does not represent parties authorized under the ''Food and Drugs Act'' and/or the ''Medical Device Regulations''.
== Medical Devices ==
== Medical Devices ==
=== MD_INS_CASE ===
=== MD_INS_CASE ===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds the main inspection information.
This table holds the main inspection information.
{| class="wikitable"
{| class="wikitable sortable mw-collapsible"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Key Type
! scope="col" style="width: 100px;" |DataType
!DataType
! scope="col" style="width: 50px;" |Key Type
! scope="col" style="width: 50px;" |Nullable
!Data Default
! scope="col" style="width: 50px;" |Data Default
!Example Data
! scope="col" style="width: 500px;" |Example Data
!Description
! scope="col" style="width: 350px;" | Description
!Comments
! scope="col" style="width: 350px;" |Comments
|-
|-
|INSP_ID
|INSP_ID
|No
|No
|NULL
|NULL
|00070-QUART HEALTHCARE INC.
|00070-MDCCD HEALTHCARE INC
|This is the inspection number.
|This is the inspection number.
|
|
|No
|No
|NULL
|NULL
|7b06cddd-12d5-ee11-904d-002248b0a560
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the company inspected.
|This is the unique record identifier for the company inspected.
|
|
|SITE_NAME
|SITE_NAME
|
|
|VARCHAR2(160 CHAR)
| VARCHAR2(160 CHAR)
|Yes
|Yes
|NULL
|NULL
|QUART HEALTHCARE INC.
|MDCCD HEALTHCARE INC
|This is the name of the company insepcted.
|This is the name of the company insepcted.
|
|
|-
|-
|LICENCE_NO
|LICENCE_NO
|Foreign
| Foreign
|NUMBER(6,0)
|NUMBER(6,0)
|Yes
|Yes
|NULL
|NULL
|2027
| 1234
|This is the establishment licence number of the company inspected.
|This is the establishment licence number of the company inspected.
|Use to join with MDS table ESTABLISHMENT.ESTABLISHMENT_ID.
|Use to join with MDS table ESTABLISHMENT.ESTABLISHMENT_ID.
|Yes
|Yes
|NULL
|NULL
|107232
|123456
|This is the internal Health Canada company identifier.
|This is the internal Health Canada company identifier.
|Use to join with MDS table ESTABLISHMENT.COMPANY_ID or COMPANY.COMPANY_ID.
|Use to join with MDS table ESTABLISHMENT.COMPANY_ID or COMPANY.COMPANY_ID.
|Yes
|Yes
|NULL
|NULL
|HC6-61-123/IM
|HC1-11-11IM
|This is the internal program based file identifier.
|This is the internal program based file identifier.
|
|
|REGION_CD_EN
|REGION_CD_EN
|
|
|VARCHAR2(50 CHAR)
| VARCHAR2(50 CHAR)
|Yes
| Yes
|NULL
|NULL
|East
|East
|NULL
|NULL
|Est
|Est
|This is the operational centre assigned to the inspection in French.
| This is the operational centre assigned to the inspection in French.
|
|
|-
|-
|INSP_TYPE_EN
|INSP_TYPE_EN
|
|
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|Yes
| Yes
|NULL
| NULL
|Domestic - New - Onsite
|Domestic - New - Onsite
|This is the type of inspection in English.
|This is the type of inspection in English.
|Yes
|Yes
|NULL
|NULL
|Domestique - Nouvelle - Sur place
| Domestique - Nouvelle - Sur place
|This is the type of inspection in French.
|This is the type of inspection in French.
|
|
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
| John Smith
|This is the name of the lead inspector.
|This is the name of the lead inspector.
|
|
|LEAD_INSPECTOR_BADGE
|LEAD_INSPECTOR_BADGE
|
|
|VARCHAR2(50 BYTE)
| VARCHAR2(50 BYTE)
|Yes
|Yes
|NULL
| NULL
|54355335
|9988776
|This is the badge number of the lead inspector.
|This is the badge number of the lead inspector.
|
|
|Yes
|Yes
|NULL
|NULL
|ed91a4cf-777a-ee11-8179-002248b32010
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier of the supervisor for the inspection.
|This is the unique record identifier of the supervisor for the inspection.
|
|
|SUPERVISOR
|SUPERVISOR
|
|
|VARCHAR2(200 CHAR)
| VARCHAR2(200 CHAR)
|Yes
|Yes
|NULL
|NULL
|Ada Lai
| John Smith
|This is the name of the supervisor for the inspection.
|This is the name of the supervisor for the inspection.
|
|
|Yes
|Yes
|NULL
|NULL
|Ouvert
| Ouvert
|This is the status of the inspection in French.
|This is the status of the inspection in French.
|
|
|NULL
|NULL
|Food & Drugs Act, Medical Device Regulations
|Food & Drugs Act, Medical Device Regulations
|This is the compliance standard that the site was inspected against in English. Either the FDA or MDR.
|This is the compliance standard that the site was inspected against in English. Either the FDA or MDR.
|
|
|-
|-
|Yes
|Yes
|NULL
|NULL
|Loi sur les aliments et drogues, Règlement sur les instruments médicaux
| Loi sur les aliments et drogues, Règlement sur les instruments médicaux
|This is the compliance standard that the site was inspected against in French. Either the FDA or MDR.
|This is the compliance standard that the site was inspected against in French. Either the FDA or MDR.
|
|
|-
|-
|DRAFT_REPORT_RATING_EN
|DRAFT_REPORT_RATING_EN
|
|
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
|NULL
|DATE
|DATE
|Yes
|Yes
|NULL
| NULL
|24-03-21
|24-03-21
|This is the date that the draft inspection rating was issued.
|This is the date that the draft inspection rating was issued.
|FINAL_REPORT_RATING_EN
|FINAL_REPORT_RATING_EN
|
|
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
|NULL
|
|
|DATE
|DATE
|Yes
| Yes
|NULL
|NULL
|24-03-21
|24-03-21
|
|
|VARCHAR2(2000 CHAR)
|VARCHAR2(2000 CHAR)
|Yes
| Yes
|NULL
| NULL
|None
| None
|This indicates if any samples were taken during the inspection.
|This indicates if any samples were taken during the inspection.
|
|
|24-01-30
|24-01-30
|This indicates when the inspection was started.
|This indicates when the inspection was started.
|Use this to calculate the number of inspections per month for the dashboard.
| Use this to calculate the number of inspections per month for the dashboard.
|-
|-
|INSP_END_DATE
|INSP_END_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|CLOSING_MEETING_DATE
|CLOSING_MEETING_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|23-11-15
| 23-11-15
|This indicates when the inspector had the closing meeting with the company.
|This indicates when the inspector had the closing meeting with the company.
|
|
|NEXT_INSPECTION_DATE
|NEXT_INSPECTION_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
| NULL
|24-03-15
|24-03-15
|This indicates when the company is due for its next inspection
|This indicates when the company is due for its next inspection
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
|John Smith
|This indicates who amended the inspection.
|This indicates who amended the inspection.
|
|
|AMENDED_DATE
|AMENDED_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
| NULL
|24-03-01
|24-03-01
|This indicates when the report was amended.
|This indicates when the report was amended.
|EMERGENCY_CONTACT_NAME
|EMERGENCY_CONTACT_NAME
|
|
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
|NULL
|Yes
|Yes
|NULL
|NULL
|514-123-4566
|613-123-4567
|This is the phone number of the emergency contact for the company at the time of inspection.
|This is the phone number of the emergency contact for the company at the time of inspection.
|
|
|Yes
|Yes
|NULL
|NULL
|31175da9-efdf-ee11-904c-000d3a847fce
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier of the senior official of the company at the time of insepction.
|This is the unique record identifier of the senior official of the company at the time of insepction.
|
|
|Yes
|Yes
|NULL
|NULL
|SVEN LILLEDRU
|John Smith
|This is the name of the senior official for the company at the time of inspection.
| This is the name of the senior official for the company at the time of inspection.
|
|
|-
|-
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
| NULL
|G.M.
|General Manager
|This is the job title of the senior official for the company at the time of inspection.
|This is the job title of the senior official for the company at the time of inspection.
|-
|-
|Yes
|Yes
|NULL
|NULL
|c1d2e077-eddf-ee11-904d-002248b0ad37
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier of the contact of the company at the time of inspection.
|This is the unique record identifier of the contact of the company at the time of inspection.
|
|
|Yes
|Yes
|NULL
|NULL
|SVEN LILLEORU
|John Smith
|This is the name of the contact of the company at the time of inspection.
|This is the name of the contact of the company at the time of inspection.
|
|
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
| Yes
|NULL
|NULL
|MANAGER, COMMERCIAL QUALITY & REG EU & CAN
|Manger, Quality Assurance
|This is the job title of the contact of the company at the time of inspection.
|This is the job title of the contact of the company at the time of inspection.
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
| NULL
|416-765-0345
|613-123-4567
|This is the phone number of the contact of the company at the time of inspection.
|This is the phone number of the contact of the company at the time of inspection.
|-
|-
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
| Yes
|NULL
|NULL
|514-123-4567
| 613-123-4567
|This is the fax of the contact of the company at the time of inspection.
|This is the fax of the contact of the company at the time of inspection.
|
|
|Yes
|Yes
|NULL
|NULL
|sven@quarthealthcare.com
|john@mdccdhealthcare.com
|This is the e-mail of the contact of the company at the time of inspection.
|This is the e-mail of the contact of the company at the time of inspection.
|
|
|Yes
|Yes
|NULL
|NULL
|36 NORTHLINE ROAD, SUITE 9
| 123 Main St
|This is the address of the company being inspected.
|This is the address of the company being inspected.
|
|
|Yes
|Yes
|NULL
|NULL
|Suite 101
| Suite 101
|This is secondary the address of the company being inspected.
|This is secondary the address of the company being inspected.
|
|
|Yes
|Yes
|NULL
|NULL
|TORONTO
|OTTAWA
|This is the city of the company being inspected.
|This is the city of the company being inspected.
|-
|-
|VARCHAR2(20 CHAR)
|VARCHAR2(20 CHAR)
|Yes
|Yes
|NULL
| NULL
|M4B 3E2
|A1B 2C3
|This is the postal code of the company being inspected.
|This is the postal code of the company being inspected.
|
|
|
|
|CLOB
|CLOB
|Yes
| Yes
|NULL
|NULL
|La réunion d'ouverture a eu lieu le 29 mars 2023 à distance (via VidCruiter) en présence de Éric Simard (Vice-Président et Secrétaire Trésorier de 1164250921 Quebec Inc Dba Kasla Entreprise Inc.) et My Din Phan (Inspecteur de Santé Canada).
|The meeting occured on March 1, 1994 with John Smith (Manager at MDCCD Healthcare and Mohamed Ali (Inspector at Health Canada)
|This is the inspectors summary of the inspection.
|This is the inspectors summary of the inspection.
|
|
|Yes
|Yes
|NULL
|NULL
|c7e5bef2-ecdf-ee11-904c-6045bd60a7a2
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier of the contact of the company who received the final inspection report.
|This is the unique record identifier of the contact of the company who received the final inspection report.
|
|
|REPORT_DELIVERED_TO
|REPORT_DELIVERED_TO
|
|
|VARCHAR2(200 CHAR)
| VARCHAR2(200 CHAR)
|Yes
|Yes
|NULL
|NULL
|MARILU ALEJANDRA VALERIANO
| Mohamed Ali
|This is the name of the contact of the company who received the final inspection report.
|This is the name of the contact of the company who received the final inspection report.
|
|
|Yes
|Yes
|NULL
|NULL
|20230406 Inspector spoke with company to schedule inspection. Follow-up email sent to company
|20230406 Inspector spoke with company to schedule inspection. Follow-up email sent to company.
|This is the inspector's internal comments and recommendations after the completion of the inspection.
|This is the inspector's internal comments and recommendations after the completion of the inspection.
|
|
|-
|-
|PERSONNEL_CHANGES
| PERSONNEL_CHANGES
|
|
|VARCHAR2(2000 BYTE)
|VARCHAR2(2000 BYTE)
|Yes
|Yes
|NULL
| NULL
|Change in Regulatory affairs department. Ms. Pace now in charge of complaint handling.
|Change in Regulatory Affairs department. Mr. Smith now in charge of complaint handling.
|This indicates any personnel changes at the company inspected since their previous inspection.
|This indicates any personnel changes at the company inspected since their previous inspection.
|
|
|DHPID Transparency IID
|DHPID Transparency IID
|-
|-
|IID_STATUS_FR
| IID_STATUS_FR
|
|
|VARCHAR2(50 CHAR)
|VARCHAR2(50 CHAR)
|Yes
|Yes
|NULL
|NULL
|24-03-15
| 24-03-15
|This indicates the status date of the IID.
|This indicates the status date of the IID.
|DHPID Transparency IID
|DHPID Transparency IID
|NULL
|NULL
|Updated deficiency.
|Updated deficiency.
|This indicates any revisions carried out to the IID.
| This indicates any revisions carried out to the IID.
|DHPID Transparency IID
|DHPID Transparency IID
|-
|-
|IRC_STATUS_FR
|IRC_STATUS_FR
|
|
|VARCHAR2(50 CHAR)
| VARCHAR2(50 CHAR)
|Yes
|Yes
|NULL
|NULL
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
|John Smith
|This is the inspector's name who sent the inspection report for approval in the record log.
|This is the inspector's name who sent the inspection report for approval in the record log.
|
|
|INSP_REPORT_WAITING_DATE
|INSP_REPORT_WAITING_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
|John Smith
|This is the supervisor's name who approved the inspection report in the record log.
|This is the supervisor's name who approved the inspection report in the record log.
|
|
|INSP_REPORT_APPROVED_BY_DATE
|INSP_REPORT_APPROVED_BY_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
| NULL
|23-11-27
|23-11-27
|This is the date the supervisor approved the inspection report in the record log.
|This is the date the supervisor approved the inspection report in the record log.
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
|John Smith
|This is the inspector's name who sent the inspection for closure in the record log.
|This is the inspector's name who sent the inspection for closure in the record log.
|-
|-
|INSP_CLOSED_WAITING_DATE
|INSP_CLOSED_WAITING_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
|John Smith
|This is the supervisor's name who approved the inspection for closure in the record log.
|This is the supervisor's name who approved the inspection for closure in the record log.
|
|
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
|John Smith
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|CREATEDON
|CREATEDON
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
| John Smith
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
===MD_INS_CASE_CAPA===
===MD_INS_CASE_CAPA===
[[MDCCD Data Warehouse|Return to Home Page.]]
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.
{| class="wikitable"
{| class="wikitable sortable mw-collapsible"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Data Default
! scope="col" style="width: 50px;" |Data Default
!Example Data
! scope="col" style="width: 500px;" |Example Data
!Description
! scope="col" style="width: 350px;" | Description
!Comments
! scope="col" style="width: 350px;" |Comments
|-
|-
|CAPA_ID
| CAPA_ID
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Primary
|Primary
|No
|No
|NULL
|NULL
|ad5e55f6-8b21-ee11-9966-000d3ae86452
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the CAPA.
|This is the unique record identifier for the CAPA.
|
|
|No
|No
|NULL
|NULL
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the parent inspection.
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|Use to join with MD_INS_CASE.INSP_ID.
|No
|No
|NULL
|NULL
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS
|00070-MDCCD HEALTHCARE INC
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|No
|No
|NULL
|NULL
|07244e35-fbf1-ee11-a1fe-6045bd6005cc
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the parent observation the CAPA is linked to.
|This is the unique record identifier for the parent observation the CAPA is linked to.
|
|
|
|
|Yes
|Yes
|NULL
| NULL
|Follow Up Plan
|Follow Up Plan
|This is a free text field used to identify the type of CAPA.
|This is a free text field used to identify the type of CAPA.
|-
|-
|CAPA_PLAN
|CAPA_PLAN
|VARCHAR2(2000 CHAR)
| VARCHAR2(2000 CHAR)
|
|
|Yes
|Yes
|NULL
|NULL
|The inspector sent follow-up letter to address Physio-controls response--the manufacturer can have more than one ID on the label as long as it clearly marks what the device identifier is and that this identifier matches what is in the MDALL. March 6, 2024 The company sent follow-up from manufacturer. The manufacturer has sent in a fax back to Health Canada to include the device ID (11141-000165) under their license. This adequately addresses the observation.
|The manufacturer sent an email to the inspector to indicate that the program has been solved.
|This is the CAPA as inputted by the inspector.
|This is the CAPA as inputted by the inspector.
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| John Smith
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| John Smith
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
===MD_INS_CASE_DESIGNATION===
===MD_INS_CASE_DESIGNATION===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds information that categorizes or "tags" an inspection. These are flexible codes used to capture information if a designated field does not exist.
This table holds information that categorizes or "tags" an inspection. These are flexible codes used to capture information if a designated field does not exist.
{| class="wikitable"
{| class="wikitable sortable mw-collapsible"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" | Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|INSP_DESIGNATION_ID
|INSP_DESIGNATION_ID
|Primary
|Primary
|No
|No
|dca846bf-cc2f-ee11-bdf4-002248b32010
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the designation.
|This is the unique record identifier for the designation.
|
|
|Foreign
|Foreign
|No
|No
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the parent inspection.
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|Use to join with MD_INS_CASE.INSP_ID.
|Foreign
|Foreign
|No
|No
|00070-QUART HEALTHCARE INC.
|NULL
| 00070-MDCCD HEALTHCARE INC
|This is the parent inspection number.
|This is the parent inspection number.
|
|-
|-
|DESIGNATION_ID
|DESIGNATION_ID
|Foreign
|Foreign
|No
|No
|ea30c0ef-5214-ee11-9cbe-002248af8a65
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the designation code.
|This is the unique record identifier for the designation code.
|
|
|-
|-
|DESIGNATION_CODE
|DESIGNATION_CODE
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|NULL
|5006
|5006
|This is the designation code.
|This is the designation code.
|-
|-
|DESIGNATION_NAME
|DESIGNATION_NAME
|VARCHAR2(250 CHAR)
| VARCHAR2(250 CHAR)
|
|
|Yes
|Yes
|NULL
|Covid
|Covid
|This is the name of the designation code.
|This is the name of the designation code.
|-
|-
|DESIGNATION_DECODE_EN
|DESIGNATION_DECODE_EN
|
|
|Yes
|Yes
|NULL
|Covid
|Covid
|This is the name of the designation code in English.
|This is the name of the designation code in English.
|-
|-
|DESIGNATION_DECODE_FR
|DESIGNATION_DECODE_FR
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|Covid
|NULL
| Covid
|This is the name of the designation code in French.
|This is the name of the designation code in French.
|
|
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
| John Smith
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|
|-
|-
|MODIFIEDBYNAME
|MODIFIEDBYNAME
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
|This identifies the resource that last modified the record.
| John Smith
| This identifies the resource that last modified the record.
|
|-
|-
|MODIFIEDON
|MODIFIEDON
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
|
|}
|}
===MD_INS_CASE_ESTACTIVITY===
===MD_INS_CASE_ESTACTIVITY===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds information on the activities conducted by the company at the time of the inspection as recorded by the inspector.
This table holds information on the activities conducted by the company at the time of the inspection as recorded by the inspector.
{| class="wikitable"
{| class="wikitable sortable mw-collapsible"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" | Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|INSP_ACTIVITY_ID
|INSP_ACTIVITY_ID
|Primary
|Primary
|No
|No
|7a743745-5fec-ee11-a1fd-002248af8802
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the establishment activity.
|This is the unique record identifier for the establishment activity.
|
|
|-
|-
| INSP_ID
|INSP_ID
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Foreign
|Foreign
|No
|No
|4c1aa941-ff7d-4e44-9238-82f4ad624d7e
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the parent inspection.
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|Use to join with MD_INS_CASE.INSP_ID.
|Foreign
|Foreign
|No
|No
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
|NULL
|00070-MDCCD HEALTHCARE INC
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|Foreign
|Foreign
|No
|No
|d7ce3513-4d14-ee11-9cbe-002248af8a65
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the activity value.
|This is the unique record identifier for the activity value.
|
|
|-
|-
|ACTIVITY_NAME
|ACTIVITY_NAME
|VARCHAR2(205 CHAR)
| VARCHAR2(205 CHAR)
|
|
|Yes
| Yes
|NULL
|Importateur - Classe 2
|Importateur - Classe 2
|This is the establishment activity.
|This is the establishment activity.
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
| Yes
|NULL
|Importer - Class 2
|Importer - Class 2
|This is the name of the establishment activity in English.
|This is the name of the establishment activity in English.
|
|
|Yes
|Yes
|Importateur - Classe 2
|NULL
| Importateur - Classe 2
|This is the name of the establishment activity in French.
|This is the name of the establishment activity in French.
|
|
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
| John Smith
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|
|
|-
|-
| MODIFIEDBYNAME
|MODIFIEDBYNAME
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
|This identifies the resource that last modified the record.
| John Smith
| This identifies the resource that last modified the record.
|
|
|-
|-
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
===MD_INS_CASE_INSPECTORS===
===MD_INS_CASE_INSPECTORS===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds a listing of inspectors assigned to an inspection.
This table holds a listing of inspectors assigned to an inspection.
{| class="wikitable"
{| class="wikitable sortable mw-collapsible"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
! Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
! Comments
! scope="col" style="width: 350px;" | Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|BK_ID
|BK_ID
|Primary
|Primary
|No
|No
|10cd1617-e303-ef11-9f89-002248b15d0c
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the inspector listing.
|This is the unique record identifier for the inspector listing.
|
|
|Foreign
|Foreign
|No
|No
|19c5e07e-63cd-49e6-9cdc-ac0f318f4752
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the parent inspection.
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|Use to join with MD_INS_CASE.INSP_ID.
|Foreign
|Foreign
|No
|No
|00093-ROCHE DIAGNOSTICS
|NULL
|00070-MDCCD HEALTHCARE INC
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
|John Smith
|This is the name of the inspector.
|This is the name of the inspector.
|
|
|-
|-
|LEADINSPECTOR_EN
|LEADINSPECTOR_EN
| VARCHAR2(3 CHAR)
|VARCHAR2(3 CHAR)
|
|
|Yes
| Yes
|NULL
|Yes
|Yes
|This indicates if the inspector is the lead inspector on the inspection in English.
|This indicates if the inspector is the lead inspector on the inspection in English.
|-
|-
|LEADINSPECTOR_FR
|LEADINSPECTOR_FR
| VARCHAR2(3 CHAR)
|VARCHAR2(3 CHAR)
|
|
|Yes
| Yes
|NULL
|Oui
|Oui
|This indicates if the inspector is the lead inspector on the inspection in French.
|This indicates if the inspector is the lead inspector on the inspection in French.
|ASSIGNSTATUS_EN
|ASSIGNSTATUS_EN
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|NULL
|Scheduled
|Scheduled
|**Not used by program.**
|**Not used by program.**
|ASSIGNSTATUS_FR
|ASSIGNSTATUS_FR
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
| Yes
|NULL
|
|
|**Not used by program.**
|**Not used by program.**
|STARTTIME
|STARTTIME
|DATE
|DATE
|
|
|Yes
|Yes
|NULL
|23-10-20
|23-10-20
|**Not used by program.**
|**Not used by program.**
|Contains default system information.
|Contains default system information.
|-
|-
| ENDTIME
|ENDTIME
|DATE
|DATE
|
|
|Yes
|Yes
|NULL
|23-10-20
|23-10-20
|**Not used by program.**
|**Not used by program.**
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
| John Smith
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
|This identifies the resource that last modified the record.
| John Smith
| This identifies the resource that last modified the record.
|
|
|-
|-
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
===MD_INS_CASE_NOTES===
===MD_INS_CASE_NOTES===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds notes related to the inspection.
This table holds notes related to the inspection.
{| class="wikitable"
{| class="wikitable sortable mw-collapsible"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" | Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|ANNOTATION_ID
|ANNOTATION_ID
|Primary
|Primary
|No
|No
|d2fa45bc-f953-8e06-8fc1-e116086f174f
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the note.
|This is the unique record identifier for the note.
|
|
|Foreign
|Foreign
|No
|No
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the parent inspection.
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|Use to join with MD_INS_CASE.INSP_ID.
|Foreign
|Foreign
|No
|No
|00027-FUTURE HEALTH TECHNOLOGIES
| NULL
|00070-MDCCD HEALTHCARE INC
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|
|
|Yes
|Yes
|NULL
|Talked to client and set out inspection plan.
|Talked to client and set out inspection plan.
|This is the subject of the note.
|This is the subject of the note.
|
|
|-
|-
|NOTETEXT
| NOTETEXT
|CLOB
|CLOB
|
|
|Yes
|Yes
|Communication with company on 2023-09-01.
|NULL
| Communication with company on 2023-09-01.
|This is the body of the note.
|This is the body of the note.
|
|
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
| John Smith
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|
|
|Yes
|Yes
|Jeff Tyndall
|NULL
|This identifies the resource that last modified the record.
| John Smith
| This identifies the resource that last modified the record.
|
|
|-
|-
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
===MD_INS_CASE_OBSERVATIONS===
===MD_INS_CASE_OBSERVATIONS===
This table holds information that categorizes or "tags" an inspection.
[[MDCCD Data Warehouse|Return to Home Page.]]
{| class="wikitable"
This table holds information about the observations for an inspection.
{| class="wikitable sortable mw-collapsible"
|+
|+
! Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" | Description
! 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
|VARCHAR2(3 CHAR)
|
|
|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_CASE_WORKFLOW===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds information about the workflow of the 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_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
|23-11-09
|This is the date that the current workflow stage was started.
|
|-
|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_IID===
[[MDCCD Data Warehouse|Return to Home Page.]]
This table holds the Initial Inspection Deficiency information for an inspection that is 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_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.]]
This table holds the establishment licence activity dictionary. This information is migrated from MDS.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable sortable mw-collapsible"
{| class="wikitable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" | Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" | Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
|-
|-
|
|
|
|
|
|
|
|
|
|
|-
|-
|
|
|
|
|
|
|-
|-
|
|
|
|
|-
|-
|
|
|
|
