67
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + Line 42:
Line 44: − + Line 51:
Line 53: − + Line 60:
Line 62: − + Line 69:
Line 71: − + Line 78:
Line 80: − + Line 132:
Line 134: − + Line 141:
Line 143: − + Line 150:
Line 152: − + Line 159:
Line 161: − + Line 330:
Line 332: − + Line 393:
Line 395: − + Line 402:
Line 404: − + Line 411:
Line 413: − + Line 420:
Line 422: − + Line 428:
Line 430: − + Line 437:
Line 439: − + Line 446:
Line 448: − + Line 455:
Line 457: − + Line 463:
Line 465: − + Line 472:
Line 474: − + Line 481:
Line 483: − + Line 508:
Line 510: − + Line 525:
Line 527: − + Line 543:
Line 545: − + Line 552:
Line 554: − + Line 561:
Line 563: − + Line 579:
Line 581: − + Line 588:
Line 590: − + Line 689:
Line 691: − + Line 707:
Line 709: − + Line 725:
Line 727: − + Line 742:
Line 744: − + Line 760:
Line 762: − + Line 778:
Line 780: − + Line 812:
Line 814: − + Line 821:
Line 823: − + Line 830:
Line 832: − + Line 839:
Line 841: − + Line 857:
Line 859: − + Line 866:
Line 868: − + Line 884:
Line 886: − + Line 918:
Line 920: − + Line 927:
Line 929: − + Line 936:
Line 938: − + Line 945:
Line 947: − + Line 989:
Line 991: − + Line 1,007:
Line 1,009: − + Line 1,041:
Line 1,043: − + Line 1,050:
Line 1,052: − + Line 1,059:
Line 1,061: − + Line 1,068:
Line 1,070: − + Line 1,104:
Line 1,106: − + Line 1,122:
Line 1,124: − + Line 1,156:
Line 1,158: − + Line 1,165:
Line 1,167: − + Line 1,174:
Line 1,176: − + Line 1,183:
Line 1,185: − + Line 1,246:
Line 1,248: − + Line 1,264:
Line 1,266: − + Line 1,298:
Line 1,300: − + Line 1,307:
Line 1,309: − + Line 1,316:
Line 1,318: − + Line 1,343:
Line 1,345: − + Line 1,361:
Line 1,363: − +
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 ==
|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.
|
|
|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.
|
|
|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.
|
|
|Yes
|Yes
|NULL
|NULL
| Vanessa Toussaint
| John Smith
|This is the name of the lead inspector.
|This is the name of the lead inspector.
|
|
|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.
|
|
|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
|Vanessa Toussaint
|John Smith
|This indicates who amended the inspection.
|This indicates who amended the inspection.
|
|
|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.
|
|
|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.
|
|
| 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.
|
|
|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.
|-
|-
| 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
|TORONTO
|OTTAWA
|This is the city of the company being inspected.
|This is the city of the company being inspected.
|-
|-
|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.
|
|
| 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.
|
|
|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.
|
|
|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.
|
|
|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.
|
|
|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.
|
|
|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.
|-
|-
|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.
|
|
|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.
|
|
|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
|MDCCD Healthcare
|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
|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.
|
|
|No
|No
|NULL
|NULL
|dca846bf-cc2f-ee11-bdf4-002248b32010
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the designation.
|This is the unique record identifier for the designation.
|
|
|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
| 00070-QUART HEALTHCARE INC.
| MDCCD Healthcare
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|No
|No
|NULL
|NULL
|ea30c0ef-5214-ee11-9cbe-002248af8a65
|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.
|
|
|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.
|
|
|No
|No
|NULL
|NULL
|7a743745-5fec-ee11-a1fd-002248af8802
|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.
|
|
|No
|No
|NULL
|NULL
|4c1aa941-ff7d-4e44-9238-82f4ad624d7e
|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
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
|MDCCD Healthcare
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|No
|No
|NULL
|NULL
|d7ce3513-4d14-ee11-9cbe-002248af8a65
|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.
|
|
|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.
|
|
|No
|No
|NULL
|NULL
|10cd1617-e303-ef11-9f89-002248b15d0c
|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.
|
|
|No
|No
|NULL
|NULL
|19c5e07e-63cd-49e6-9cdc-ac0f318f4752
|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
|00093-ROCHE DIAGNOSTICS
|MDCCD Healthcare
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
|John Smith
|This is the name of the inspector.
|This is the name of 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.
|
|
|No
|No
|NULL
|NULL
|d2fa45bc-f953-8e06-8fc1-e116086f174f
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the note.
|This is the unique record identifier for the note.
|
|
|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
|00027-FUTURE HEALTH TECHNOLOGIES
|MDCCD Healthcare
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|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.
|
|
