wiki

Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 13:53, 24 May 2024

545 bytes removed ,  24 May
no edit summary
Line 1: Line 1:  
== 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 ==
Line 42: Line 44:  
|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.
 
|
 
|
Line 51: Line 53:  
|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.
 
|
 
|
Line 60: Line 62:  
|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.
Line 69: Line 71:  
|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.
Line 78: Line 80:  
|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.
 
|
 
|
Line 132: Line 134:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
| Vanessa Toussaint
+
| John Smith
 
|This is the name of the lead inspector.
 
|This is the name of the lead inspector.
 
|
 
|
Line 141: Line 143:  
|Yes
 
|Yes
 
| NULL
 
| NULL
−
|54355335
+
|9988776
 
|This is the badge number of the lead inspector.
 
|This is the badge number of the lead inspector.
 
|
 
|
Line 150: Line 152:  
|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.
 
|
 
|
Line 159: Line 161:  
|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.
 
|
 
|
Line 330: Line 332:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
|Vanessa Toussaint
+
|John Smith
 
|This indicates who amended the inspection.
 
|This indicates who amended the inspection.
 
|
 
|
Line 393: Line 395:  
|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.
 
|
 
|
Line 402: Line 404:  
|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.
 
|
 
|
Line 411: Line 413:  
|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.
 
|
 
|
Line 420: Line 422:  
|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.
 
|-
 
|-
Line 428: Line 430:  
|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.
 
|
 
|
Line 437: Line 439:  
|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.
 
|
 
|
Line 446: Line 448:  
| 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.
 
|
 
|
Line 455: Line 457:  
|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.
 
|-
 
|-
Line 463: Line 465:  
| 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.
 
|
 
|
Line 472: Line 474:  
|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.
 
|
 
|
Line 481: Line 483:  
|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.
 
|
 
|
Line 508: Line 510:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
|TORONTO
+
|OTTAWA
 
|This is the city of the company being inspected.
 
|This is the city of the company being inspected.
 
|-
 
|-
Line 525: Line 527:  
|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.
 
|
 
|
Line 543: Line 545:  
| 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.
 
|
 
|
Line 552: Line 554:  
|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.
 
|
 
|
Line 561: Line 563:  
|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.
 
|
 
|
Line 579: Line 581:  
|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.
 
|
 
|
Line 588: Line 590:  
|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.
 
|
 
|
Line 689: Line 691:  
|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.
 
|
 
|
Line 707: Line 709:  
|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.
 
|
 
|
Line 725: Line 727:  
|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.
 
|-
 
|-
Line 742: Line 744:  
|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.
 
|
 
|
Line 760: Line 762:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
|Vanessa Toussaint
+
|John Smith
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 778: Line 780:  
|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.
 
|
 
|
Line 812: Line 814:  
|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.
 
|
 
|
Line 821: Line 823:  
|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.
Line 830: Line 832:  
|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.
 
|
 
|
Line 839: Line 841:  
|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.
 
|
 
|
Line 857: Line 859:  
|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.
 
|
 
|
Line 866: Line 868:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
| Jeff Tyndall
+
| John Smith
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 884: Line 886:  
|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.
 
|
 
|
Line 918: Line 920:  
|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.
 
|
 
|
Line 927: Line 929:  
|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.
Line 936: Line 938:  
|No
 
|No
 
|NULL
 
|NULL
−
| 00070-QUART HEALTHCARE INC.
+
| MDCCD Healthcare
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 945: Line 947:  
|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.
 
|
 
|
Line 989: Line 991:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
| Jeff Tyndall
+
| John Smith
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,007: Line 1,009:  
|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.
 
|
 
|
Line 1,041: Line 1,043:  
|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.
 
|
 
|
Line 1,050: Line 1,052:  
|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.
Line 1,059: Line 1,061:  
|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.
 
|
 
|
Line 1,068: Line 1,070:  
|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.
 
|
 
|
Line 1,104: Line 1,106:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
| Jeff Tyndall
+
| John Smith
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,122: Line 1,124:  
|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.
 
|
 
|
Line 1,156: Line 1,158:  
|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.
 
|
 
|
Line 1,165: Line 1,167:  
|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.
Line 1,174: Line 1,176:  
|No
 
|No
 
|NULL
 
|NULL
−
|00093-ROCHE DIAGNOSTICS
+
|MDCCD Healthcare
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 1,183: Line 1,185:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
|Jeff Tyndall
+
|John Smith
 
|This is the name of the inspector.
 
|This is the name of the inspector.
 
|
 
|
Line 1,246: Line 1,248:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
| Jeff Tyndall
+
| John Smith
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,264: Line 1,266:  
|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.
 
|
 
|
Line 1,298: Line 1,300:  
|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.
 
|
 
|
Line 1,307: Line 1,309:  
|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.
Line 1,316: Line 1,318:  
|No
 
|No
 
| NULL
 
| NULL
−
|00027-FUTURE HEALTH TECHNOLOGIES
+
|MDCCD Healthcare
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 1,343: Line 1,345:  
|Yes
 
|Yes
 
|NULL
 
|NULL
−
| Jeff Tyndall
+
| John Smith
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,361: Line 1,363:  
|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.
 
|
 
|
Jeff.tyndall
71

edits

Retrieved from "https://wiki.gccollab.ca/Special:MobileDiff/120649"