71
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: + + − + Line 14:
Line 16: − + Line 46:
Line 48: − + Line 53:
Line 55: − + − + − + − + Line 73:
Line 75: − + − + − + − + − + Line 94:
Line 96: − + Line 100:
Line 102: − + − + − + Line 112:
Line 114: − + − + Line 130:
Line 132: − + Line 136:
Line 138: − + − + Line 145:
Line 147: − + Line 154:
Line 156: − + − + Line 167:
Line 169: − + − + − + Line 190:
Line 192: − + − + Line 199:
Line 201: − + − + Line 210:
Line 212: − + Line 219:
Line 221: − + Line 226:
Line 228: − + − + Line 244:
Line 246: − + − + − + Line 255:
Line 257: − + Line 263:
Line 265: − + − + − + − + Line 276:
Line 278: − + − + − + Line 292:
Line 294: − + Line 298:
Line 300: − + − + − + Line 308:
Line 310: − + Line 332:
Line 334: − + − + Line 344:
Line 346: − + Line 368:
Line 370: − + Line 379:
Line 381: − + Line 392:
Line 394: − + − + − + Line 410:
Line 412: − + Line 417:
Line 419: − + Line 442:
Line 444: − + Line 452:
Line 454: − + Line 459:
Line 461: − + − + Line 471:
Line 473: − + Line 479:
Line 481: − + Line 488:
Line 490: − + − + Line 518:
Line 520: − + − + − + Line 539:
Line 541: − + Line 550:
Line 552: − + − + − + − + Line 566:
Line 568: − + − + Line 581:
Line 583: − + Line 593:
Line 595: − + − + − + − + − + Line 613:
Line 615: − + − + Line 623:
Line 625: − + Line 630:
Line 632: − + − + − + − + Line 673:
Line 675: − + − + Line 682:
Line 684: − + Line 693:
Line 695: − + Line 711:
Line 713: − + − + − + − + Line 728:
Line 730: − + Line 749:
Line 751: − + Line 758:
Line 760: − + Line 771:
Line 773: − + − + − + Line 794:
Line 796: − + Line 800:
Line 802: − + − + − + Line 815:
Line 817: − + Line 824:
Line 826: − + Line 840:
Line 842: − + − + Line 849:
Line 851: − + Line 862:
Line 864: − + Line 880:
Line 882: − + − + Line 898:
Line 900: − + Line 904:
Line 906: − + − + Line 922:
Line 924: − + Line 930:
Line 932: − + Line 944:
Line 946: − + − + − + − + Line 965:
Line 967: − + − + − + Line 983:
Line 985: − + − + Line 1,001:
Line 1,003: − + − + Line 1,019:
Line 1,021: − + Line 1,025:
Line 1,027: − + Line 1,065:
Line 1,067: − + − + − + Line 1,076:
Line 1,078: − + Line 1,082:
Line 1,084: − + − + Line 1,096:
Line 1,098: − + Line 1,103:
Line 1,105: − + Line 1,114:
Line 1,116: − + − + Line 1,128:
Line 1,130: − + − + Line 1,138:
Line 1,140: − + Line 1,172:
Line 1,174: − + Line 1,180:
Line 1,182: − + Line 1,189:
Line 1,191: − + Line 1,199:
Line 1,201: − + Line 1,207:
Line 1,209: − + Line 1,236:
Line 1,238: − + Line 1,252:
Line 1,254: − + − + − + Line 1,272:
Line 1,274: − + Line 1,278:
Line 1,280: − + Line 1,303:
Line 1,305: − + Line 1,317:
Line 1,319: − + − + Line 1,331:
Line 1,333: − + Line 1,347:
Line 1,349: − + − + − + Line 1,367:
Line 1,369: − + − + − + − + Line 1,401:
Line 1,403: − + − + Line 1,411:
Line 1,413: − + Line 1,443:
Line 1,445: − + Line 1,449:
Line 1,451: − + Line 1,481:
Line 1,483: − + Line 1,487:
Line 1,489: − + Line 1,519:
Line 1,521: − + Line 1,525:
Line 1,527: − + Line 1,557:
Line 1,559: − + Line 1,563:
Line 1,565: − + Line 1,591:
Line 1,593: − + − + Line 1,601:
Line 1,603: − + Line 1,629:
Line 1,631: − + − + Line 1,639:
Line 1,641: − + Line 1,671:
Line 1,673: − + Line 1,677:
Line 1,679: − + Line 1,709:
Line 1,711: − + Line 1,715:
Line 1,717: − + Line 1,747:
Line 1,749: − + Line 1,753:
Line 1,755: − +
no edit summary
=== 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 sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|SITE_NAME
|SITE_NAME
|
|
|VARCHAR2(160 CHAR)
| VARCHAR2(160 CHAR)
|Yes
|Yes
|NULL
|NULL
|
|
|-
|-
| LICENCE_NO
|LICENCE_NO
|Foreign
| Foreign
|NUMBER(6,0)
|NUMBER(6,0)
|Yes
|Yes
|NULL
|NULL
|2027
| 2027
| 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.
|-
|-
|REG_FILE_NUMBER
|REG_FILE_NUMBER
|
|
| VARCHAR2(250 BYTE)
|VARCHAR2(250 BYTE)
|Yes
|Yes
|NULL
|NULL
| HC6-61-123/IM
|HC6-61-123/IM
| 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
|Yes
|Yes
|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
| Vanessa Toussaint
|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
|54355335
|This is the badge number of the lead inspector.
|This is the badge number of the lead inspector.
|SUPERVISOR_ID
|SUPERVISOR_ID
|Foreign
|Foreign
| VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Yes
|Yes
|NULL
|NULL
|SUPERVISOR
|SUPERVISOR
|
|
|VARCHAR2(200 CHAR)
| VARCHAR2(200 CHAR)
|Yes
|Yes
|NULL
|NULL
|Ada Lai
| Ada Lai
|This is the name of the supervisor for the inspection.
|This is the name of the supervisor for the inspection.
|
|
|NULL
|NULL
|Open
|Open
| This is the status of the inspection in English.
|This is the status of the inspection in English.
|
|
|-
|-
| INSP_STATUS_FR
|INSP_STATUS_FR
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
|NULL
|Ouvert
| Ouvert
|This is the status of the inspection in French.
|This is the status of the inspection in French.
|
|
|COMP_STANDARD_FR
|COMP_STANDARD_FR
|
|
| VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|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
|Compliant
|Compliant
|This is the draft inspection rating in English.
|This is the draft inspection rating in English.
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
|Yes
| NULL
|NULL
|Conforme
|Conforme
|This is the draft inspection rating in French.
|This is the draft inspection rating in French.
|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
|Compliant
|Compliant
|This is the final inspection rating in English.
|This is the final inspection rating in English.
|FINAL_REPORT_ISSUE_DATE
|FINAL_REPORT_ISSUE_DATE
|
|
| DATE
|DATE
|Yes
| Yes
|NULL
|NULL
| 24-03-21
|24-03-21
|This is the date that the final inspection rating was issued.
|This is the date that the final inspection rating was issued.
|
|
|DATE
|DATE
|Yes
|Yes
| NULL
|NULL
|24-03-22
|24-03-22
|This is the date that an amended inspection report was issued to the company.
|This is the date that an amended inspection report was issued to the company.
|
|
|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
|24-01-30
|24-01-30
|This indicates when the inspection was finished.
|This indicates when the inspection was finished.
|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
|
|
|VARCHAR2(5 CHAR)
|VARCHAR2(5 CHAR)
| Yes
|Yes
|NULL
|NULL
|Yes
|Yes
|
|
|-
|-
| AMENDED_DATE
|AMENDED_DATE
|
|
|DATE
| DATE
|Yes
|Yes
| NULL
| NULL
|
|
|DATE
|DATE
| Yes
|Yes
|NULL
|NULL
|24-02-21
|24-02-21
|
|
|-
|-
| FIRST_COMM_MODE_FR
|FIRST_COMM_MODE_FR
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|EMERGENCY_CONTACT_NAME
|EMERGENCY_CONTACT_NAME
|
|
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
|NULL
|NULL
|NULL
|514-123-4566
|514-123-4566
| 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.
|
|
|-
|-
|SENIOR_OFFICIAL_OFFICIAL_ID
|SENIOR_OFFICIAL_OFFICIAL_ID
| Foreign
|Foreign
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
| Yes
|Yes
|NULL
|NULL
|31175da9-efdf-ee11-904c-000d3a847fce
|31175da9-efdf-ee11-904c-000d3a847fce
|NULL
|NULL
|SVEN LILLEDRU
|SVEN LILLEDRU
|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.
|G.M.
|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.
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
| Yes
|NULL
|NULL
|MANAGER, COMMERCIAL QUALITY & REG EU & CAN
|MANAGER, COMMERCIAL QUALITY & REG EU & CAN
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
| NULL
|416-765-0345
|416-765-0345
|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
| 514-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.
|
|
|NULL
|NULL
|sven@quarthealthcare.com
|sven@quarthealthcare.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
| 36 NORTHLINE ROAD, SUITE 9
|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.
|
|
|-
|-
| SITE_ADDRESS_3
|SITE_ADDRESS_3
|
|
|VARCHAR2(250 CHAR)
|VARCHAR2(250 CHAR)
|
|
|-
|-
| SITE_POSTALCODE
|SITE_POSTALCODE
|
|
|VARCHAR2(20 CHAR)
|VARCHAR2(20 CHAR)
| Yes
|Yes
| NULL
| NULL
|M4B 3E2
|M4B 3E2
| 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).
|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).
|Yes
|Yes
|NULL
|NULL
| c7e5bef2-ecdf-ee11-904c-6045bd60a7a2
|c7e5bef2-ecdf-ee11-904c-6045bd60a7a2
|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
| MARILU ALEJANDRA VALERIANO
|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.
|
|
|
|
|DATE
|DATE
| Yes
|Yes
|NULL
|NULL
|24-02-28
|24-02-28
| This is the date that Health Canada is expecting a response from the company about information captured in the final inspection report.
|This is the date that Health Canada is expecting a response from the company about information captured in the final inspection report.
|
|
|-
|-
|
|
|-
|-
|PERSONNEL_CHANGES
| PERSONNEL_CHANGES
|
|
|VARCHAR2(2000 BYTE)
|VARCHAR2(2000 BYTE)
|
|
|VARCHAR2(50 CHAR)
|VARCHAR2(50 CHAR)
| Yes
|Yes
|NULL
|NULL
| In Progress
|In Progress
|This indicates the status of the IID in English.
|This indicates the status of the IID in English.
|DHPID Transparency IID
|DHPID Transparency IID
|-
|-
|IID_STATUS_FR
| IID_STATUS_FR
|
|
|VARCHAR2(50 CHAR)
|VARCHAR2(50 CHAR)
|Yes
|Yes
|NULL
|NULL
| En cours
|En cours
| This indicates the status of the IID in French.
|This indicates the status of the IID in French.
|DHPID Transparency IID
|DHPID Transparency IID
|-
|-
|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
|-
|-
|IID_REVISION_LOG
|IID_REVISION_LOG
|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
|-
|-
|VARCHAR2(50 CHAR)
|VARCHAR2(50 CHAR)
|Yes
|Yes
| NULL
|NULL
|IRC Ready For Publication
|IRC Ready For Publication
|This indicates the status of the IRC in English.
|This indicates the status of the IRC in English.
| DHPID Transparency IRC
|DHPID Transparency IRC
|-
|-
| IRC_STATUS_FR
|IRC_STATUS_FR
|
|
|VARCHAR2(50 CHAR)
| VARCHAR2(50 CHAR)
|Yes
|Yes
|NULL
|NULL
|DHPID Transparency IRC
|DHPID Transparency IRC
|-
|-
| INSP_OUTCOME_FR
|INSP_OUTCOME_FR
|
|
|VARCHAR2(2000 CHAR)
|VARCHAR2(2000 CHAR)
| Yes
|Yes
|NULL
|NULL
|Une cote « conforme » a été émise aux termes de l’inspection. \r\n\r\nUne cote d’inspection « conforme » permet à une entreprise de conserver sa licence et de poursuivre ses activités. Une cote « conforme » ne signifie toutefois pas qu’aucune observation n’a été relevée pendant l’inspection. Si une entreprise reçoit une cote d’inspection « conforme » et si des observations ont été relevées, elle doit élaborer un plan pour corriger ces observations et éviter qu’elles ne se reproduisent
|Une cote « conforme » a été émise aux termes de l’inspection. \r\n\r\nUne cote d’inspection « conforme » permet à une entreprise de conserver sa licence et de poursuivre ses activités. Une cote « conforme » ne signifie toutefois pas qu’aucune observation n’a été relevée pendant l’inspection. Si une entreprise reçoit une cote d’inspection « conforme » et si des observations ont été relevées, elle doit élaborer un plan pour corriger ces observations et éviter qu’elles ne se reproduisent
|DHPID Transparency IRC
|DHPID Transparency IRC
|-
|-
| INSP_REPORT_WAITING
|INSP_REPORT_WAITING
|
|
|VARCHAR2(200 CHAR)
|VARCHAR2(200 CHAR)
|INSP_REPORT_WAITING_DATE
|INSP_REPORT_WAITING_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|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.
|
|
|-
|-
| INSP_CLOSED_WAITING
|INSP_CLOSED_WAITING
|
|
|VARCHAR2(200 CHAR)
|VARCHAR2(200 CHAR)
|Yes
|Yes
| NULL
|NULL
|Jeff Tyndall
|Jeff Tyndall
|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
| 23-11-29
|23-11-29
|This is the date the supervisor approved the inspection for closure in the record log.
|This is the date the supervisor approved the inspection for closure in the record log.
|
|
|Yes
|Yes
|NULL
|NULL
| Vanessa Toussaint
|Vanessa Toussaint
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|
|
|-
|-
| MODIFIEDBYNAME
|MODIFIEDBYNAME
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|Yes
|Yes
|NULL
|NULL
|Vanessa Toussaint
| Vanessa Toussaint
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|CAPA_ID
| CAPA_ID
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Primary
|Primary
|No
|No
|NULL
|NULL
| ad5e55f6-8b21-ee11-9966-000d3ae86452
|ad5e55f6-8b21-ee11-9966-000d3ae86452
|This is the unique record identifier for the CAPA.
|This is the unique record identifier for the CAPA.
|
|
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Foreign
|Foreign
| No
|No
|NULL
|NULL
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|VARCHAR2(200 CHAR)
|VARCHAR2(200 CHAR)
|Foreign
|Foreign
| No
|No
|NULL
|NULL
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS
|-
|-
|CAPA_TYPE
|CAPA_TYPE
| VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|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
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
| INSP_DESIGNATION_ID
|INSP_DESIGNATION_ID
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Primary
|Primary
|NULL
|NULL
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
| 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.
| 00070-QUART HEALTHCARE INC.
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|-
|-
|DESIGNATION_CODE
|DESIGNATION_CODE
|VARCHAR2(100 CHAR)
| VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
| NULL
|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
|Yes
|Yes
|NULL
|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
|NULL
|NULL
|Covid
| Covid
|This is the name of the designation code in French.
|This is the name of the designation code in French.
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|-
|-
| CREATEDON
|CREATEDON
|DATE
|DATE
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|-
|-
|ACTIVITY_NAME
|ACTIVITY_NAME
|VARCHAR2(205 CHAR)
| VARCHAR2(205 CHAR)
|
|
|Yes
| Yes
| NULL
|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
|NULL
|Importer - Class 2
|Importer - Class 2
|
|
|-
|-
| ACTIVITY_DECODE_FR
|ACTIVITY_DECODE_FR
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|NULL
|NULL
|Importateur - Classe 2
| 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
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|DATE
|DATE
|
|
| Yes
|Yes
|NULL
|NULL
|22-08-26
|22-08-26
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
|}
|}
=== MD_INS_CASE_INSPECTORS===
===MD_INS_CASE_INSPECTORS===
This table holds a listing of inspectors assigned to an inspection.
This table holds a listing of inspectors assigned to an inspection.
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|
|
|Yes
|Yes
| NULL
|NULL
|Jeff Tyndall
|Jeff Tyndall
|This is the name of the inspector.
|This is the name of the inspector.
|VARCHAR2(3 CHAR)
|VARCHAR2(3 CHAR)
|
|
|Yes
| Yes
|NULL
|NULL
|Yes
|Yes
|VARCHAR2(3 CHAR)
|VARCHAR2(3 CHAR)
|
|
|Yes
| Yes
|NULL
|NULL
|Oui
|Oui
|
|
|Yes
|Yes
| NULL
|NULL
|Scheduled
|Scheduled
|**Not used by program.**
|**Not used by program.**
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
| Yes
|NULL
|NULL
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
| Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|Foreign
|Foreign
|No
|No
|NULL
| NULL
|00027-FUTURE HEALTH TECHNOLOGIES
|00027-FUTURE HEALTH TECHNOLOGIES
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|-
|-
|NOTETEXT
| NOTETEXT
|CLOB
|CLOB
|
|
|Yes
|Yes
|NULL
|NULL
|Communication with company on 2023-09-01.
| Communication with company on 2023-09-01.
|This is the body of the note.
|This is the body of the note.
|
|
|Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
| Yes
|Yes
|NULL
|NULL
|Jeff Tyndall
| Jeff Tyndall
|This identifies the resource that last modified the record.
| This identifies the resource that last modified the record.
|
|
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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
|-
|-
|}
|}
=== MD_INS_CASE_WORKFLOW===
===MD_INS_CASE_WORKFLOW===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|}
|}
===MD_INS_INS_IRC_OBSERVATIONS===
=== MD_INS_INS_IRC_OBSERVATIONS===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
|}
|}
===MD_INS_INS_SITE===
=== MD_INS_INS_SITE===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
{| class="wikitable sortable"
{| class="wikitable sortable"
|+
|+
! 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;" |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
|-
|-
