Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
== Aperçu ==
+
{{Delete|reason=Moved to internal Health Canada wiki. Internal database structure should not be public.}}
 +
==Aperçu==
 
Cette page fournit un dictionnaire de données pour chaque table contenue dans le fichier [[Entrepôt de données d'DCMMMC]].
 
Cette page fournit un dictionnaire de données pour chaque table contenue dans le fichier [[Entrepôt de données d'DCMMMC]].
   −
== Instruments médicaux ==
+
==Instruments médicaux==
   −
=== MD_INS_CASE ===
+
===MD_INS_CASE===
 
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   Line 10: Line 11:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 16: Line 17:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 48: Line 49:  
|SITE_NAME
 
|SITE_NAME
 
|
 
|
| VARCHAR2(160 CHAR)
+
|VARCHAR2(160 CHAR)
 
|Yes
 
|Yes
 
|NULL
 
|NULL
 
|QUART HEALTHCARE INC.
 
|QUART 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
+
|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.
Line 84: Line 85:  
|REGION_CD_EN
 
|REGION_CD_EN
 
|
 
|
| VARCHAR2(50 CHAR)
+
|VARCHAR2(50 CHAR)
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|East
 
|East
Line 97: Line 98:  
|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.
Line 114: Line 115:  
|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.
 
|
 
|
Line 132: Line 133:  
|Yes
 
|Yes
 
|NULL
 
|NULL
| Vanessa Toussaint
+
|Vanessa Toussaint
 
|This is the name of the lead inspector.
 
|This is the name of the lead inspector.
 
|
 
|
Line 138: Line 139:  
|LEAD_INSPECTOR_BADGE
 
|LEAD_INSPECTOR_BADGE
 
|
 
|
| VARCHAR2(50 BYTE)
+
|VARCHAR2(50 BYTE)
 
|Yes
 
|Yes
 
| NULL
 
| NULL
Line 149: Line 150:  
|VARCHAR2(36 CHAR)
 
|VARCHAR2(36 CHAR)
 
|Yes
 
|Yes
|NULL
+
| NULL
 
|ed91a4cf-777a-ee11-8179-002248b32010
 
|ed91a4cf-777a-ee11-8179-002248b32010
 
|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 156: Line 157:  
|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.
 
|
 
|
Line 175: Line 176:  
|
 
|
 
|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.
 
|
 
|
Line 184: Line 185:  
|
 
|
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
|Yes
+
| Yes
 
|NULL
 
|NULL
 
|Food & Drugs Act, Medical Device Regulations
 
|Food & Drugs Act, Medical Device Regulations
Line 195: Line 196:  
|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.
 
|
 
|
Line 201: Line 202:  
|DRAFT_REPORT_RATING_EN
 
|DRAFT_REPORT_RATING_EN
 
|
 
|
| VARCHAR2(100 CHAR)
+
|VARCHAR2(100 CHAR)
 
|Yes
 
|Yes
 
|NULL
 
|NULL
Line 221: Line 222:  
|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.
Line 228: Line 229:  
|FINAL_REPORT_RATING_EN
 
|FINAL_REPORT_RATING_EN
 
|
 
|
| VARCHAR2(100 CHAR)
+
|VARCHAR2(100 CHAR)
 
|Yes
 
|Yes
 
|NULL
 
|NULL
Line 247: Line 248:  
|
 
|
 
|DATE
 
|DATE
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|24-03-21
 
|24-03-21
Line 253: Line 254:  
|
 
|
 
|-
 
|-
|AMENDED_REPORT_ISSUE_DATE
+
| AMENDED_REPORT_ISSUE_DATE
 
|
 
|
 
|DATE
 
|DATE
Line 265: Line 266:  
|
 
|
 
|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.
 
|
 
|
Line 274: Line 275:  
|
 
|
 
|DATE
 
|DATE
|Yes
+
| Yes
 
|NULL
 
|NULL
 
|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
Line 291: Line 292:  
|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
 
|
 
|
Line 336: Line 337:  
|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.
Line 381: Line 382:  
|EMERGENCY_CONTACT_NAME
 
|EMERGENCY_CONTACT_NAME
 
|
 
|
| VARCHAR2(100 CHAR)
+
|VARCHAR2(100 CHAR)
 
|Yes
 
|Yes
 
|NULL
 
|NULL
Line 401: Line 402:  
|VARCHAR2(36 CHAR)
 
|VARCHAR2(36 CHAR)
 
|Yes
 
|Yes
|NULL
+
| NULL
 
|31175da9-efdf-ee11-904c-000d3a847fce
 
|31175da9-efdf-ee11-904c-000d3a847fce
 
|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 412: Line 413:  
|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.
 
|
 
|
 
|-
 
|-
Line 419: Line 420:  
|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.
Line 444: Line 445:  
|
 
|
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|MANAGER, COMMERCIAL QUALITY & REG EU & CAN
 
|MANAGER, COMMERCIAL QUALITY & REG EU & CAN
Line 454: Line 455:  
|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.
Line 461: Line 462:  
|
 
|
 
|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.
 
|
 
|
Line 481: Line 482:  
|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.
 
|
 
|
Line 490: Line 491:  
|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.
 
|
 
|
Line 516: Line 517:  
|Yes
 
|Yes
 
|NULL
 
|NULL
|ON
+
| ON
 
|This is the province of the company being inspected.
 
|This is the province of the company being inspected.
 
|
 
|
Line 524: Line 525:  
|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.
Line 538: Line 539:  
|
 
|
 
|-
 
|-
|INSPECTION_SUMMARY
+
| INSPECTION_SUMMARY
 
|
 
|
 
|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).   
 
|This is the inspectors summary of the inspection.
 
|This is the inspectors summary of the inspection.
Line 558: Line 559:  
|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.
 
|
 
|
Line 571: Line 572:  
|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.
 
|
 
|
 
|-
 
|-
Line 579: Line 580:  
|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. Ms. Pace 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 598: Line 599:  
|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)
Line 615: Line 616:  
|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
Line 625: Line 626:  
|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_EN
+
| IRC_STATUS_EN
 
|
 
|
 
|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
 
|IRC prêt pour la publication
 
|IRC prêt pour la publication
|This indicates the status of the IRC in French.
+
| This indicates the status of the IRC in French.
 
|DHPID Transparency IRC
 
|DHPID Transparency IRC
 
|-
 
|-
 
|INSP_RATING_EN
 
|INSP_RATING_EN
 
|
 
|
|VARCHAR2(100 CHAR)
+
| VARCHAR2(100 CHAR)
 
|Yes
 
|Yes
 
|NULL
 
|NULL
Line 662: Line 663:  
|NULL
 
|NULL
 
|Conforme
 
|Conforme
|This indicates the final inspection report rating for the IRC in French.
+
| This indicates the final inspection report rating for the IRC in French.
 
|DHPID Transparency IRC.  
 
|DHPID Transparency IRC.  
 
Matches the FINAL_REPORT_RATING_FR value.
 
Matches the FINAL_REPORT_RATING_FR value.
 
|-
 
|-
|INSP_OUTCOME_EN
+
| INSP_OUTCOME_EN
 
|
 
|
 
|VARCHAR2(2000 CHAR)
 
|VARCHAR2(2000 CHAR)
 
|Yes
 
|Yes
|NULL
+
| NULL
 
|The inspection resulted in a ‘compliant’ inspection rating. A compliant inspection rating allows a company to keep their licence and continue conducting business.  A compliant rating does not mean that there were no observations during the inspection.  If a company receives a compliant inspection rating and if observations were noted, the company is required to develop a plan to correct the observations to prevent them from occurring again.
 
|The inspection resulted in a ‘compliant’ inspection rating. A compliant inspection rating allows a company to keep their licence and continue conducting business.  A compliant rating does not mean that there were no observations during the inspection.  If a company receives a compliant inspection rating and if observations were noted, the company is required to develop a plan to correct the observations to prevent them from occurring again.
 
|This is a standard line related to the INSP_RATING_EN value.
 
|This is a standard line related to the INSP_RATING_EN value.
Line 679: Line 680:  
|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
 
|This is a standard line related to the INSP_RATING_FR value.
 
|This is a standard line related to the INSP_RATING_FR value.
|DHPID Transparency IRC
+
| DHPID Transparency IRC
 
|-
 
|-
 
|INSP_REPORT_WAITING
 
|INSP_REPORT_WAITING
Line 688: Line 689:  
|VARCHAR2(200 CHAR)
 
|VARCHAR2(200 CHAR)
 
|Yes
 
|Yes
|NULL
+
| NULL
 
|Jeff Tyndall
 
|Jeff Tyndall
 
|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
 
|23-11-27
 
|23-11-27
Line 702: Line 703:  
|
 
|
 
|-
 
|-
|INSP_REPORT_APPROVED_BY
+
| INSP_REPORT_APPROVED_BY
 
|
 
|
 
|VARCHAR2(200 CHAR)
 
|VARCHAR2(200 CHAR)
Line 713: Line 714:  
|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.
Line 728: Line 729:  
|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
Line 740: Line 741:  
|
 
|
 
|VARCHAR2(200 CHAR)
 
|VARCHAR2(200 CHAR)
|Yes
+
| Yes
 
|NULL
 
|NULL
 
|Vanessa Toussaint
 
|Vanessa Toussaint
Line 766: Line 767:  
|CREATEDON
 
|CREATEDON
 
|
 
|
| DATE
+
|DATE
 
|Yes
 
|Yes
 
|NULL
 
|NULL
Line 778: Line 779:  
|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.
 
|
 
|
 
|-
 
|-
Line 798: Line 799:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 804: Line 805:  
! 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
Line 821: Line 822:  
|No
 
|No
 
|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.
Line 846: Line 847:  
|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.
Line 853: Line 854:  
|-
 
|-
 
|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 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.
|This is the CAPA as inputted by the inspector.
+
| This is the CAPA as inputted by the inspector.
 
|
 
|
 
|-
 
|-
Line 866: Line 867:  
|Yes
 
|Yes
 
|NULL
 
|NULL
| Jeff Tyndall
+
|Jeff Tyndall
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 884: Line 885:  
|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.
 
|
 
|
 
|-
 
|-
Line 904: Line 905:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 910: Line 911:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 927: Line 928:  
|No
 
|No
 
|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.
Line 936: Line 937:  
|No
 
|No
 
|NULL
 
|NULL
| 00070-QUART HEALTHCARE INC.
+
|00070-QUART HEALTHCARE INC.
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 950: Line 951:  
|-
 
|-
 
|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
Line 966: Line 967:  
|This is the name of the designation code.
 
|This is the name of the designation code.
 
|-
 
|-
|DESIGNATION_DECODE_EN
+
| DESIGNATION_DECODE_EN
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 
|
 
|
Line 976: Line 977:  
|-
 
|-
 
|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.
 
|
 
|
 
|-
 
|-
Line 989: Line 990:  
|Yes
 
|Yes
 
|NULL
 
|NULL
| Jeff Tyndall
+
|Jeff Tyndall
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,007: Line 1,008:  
|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.
 
|
 
|
 
|-
 
|-
Line 1,027: Line 1,028:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,033: Line 1,034:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,039: Line 1,040:  
|VARCHAR2(36 CHAR)
 
|VARCHAR2(36 CHAR)
 
|Primary
 
|Primary
|No
+
| No
 
|NULL
 
|NULL
 
|7a743745-5fec-ee11-a1fd-002248af8802
 
|7a743745-5fec-ee11-a1fd-002248af8802
Line 1,050: Line 1,051:  
|No
 
|No
 
|NULL
 
|NULL
|4c1aa941-ff7d-4e44-9238-82f4ad624d7e
+
| 4c1aa941-ff7d-4e44-9238-82f4ad624d7e
 
|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,057: Line 1,058:  
|VARCHAR2(200 CHAR)
 
|VARCHAR2(200 CHAR)
 
|Foreign
 
|Foreign
|No
+
| No
 
|NULL
 
|NULL
 
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
 
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
Line 1,073: Line 1,074:  
|-
 
|-
 
|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.
 
|
 
|
 
|-
 
|-
Line 1,084: Line 1,085:  
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 
|
 
|
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|Importer - Class 2
 
|Importer - Class 2
Line 1,095: Line 1,096:  
|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.
 
|
 
|
Line 1,104: Line 1,105:  
|Yes
 
|Yes
 
|NULL
 
|NULL
| Jeff Tyndall
+
|Jeff Tyndall
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,122: Line 1,123:  
|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.
 
|
 
|
 
|-
 
|-
Line 1,142: Line 1,143:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,148: Line 1,149:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,165: Line 1,166:  
|No
 
|No
 
|NULL
 
|NULL
|19c5e07e-63cd-49e6-9cdc-ac0f318f4752
+
| 19c5e07e-63cd-49e6-9cdc-ac0f318f4752
 
|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,190: Line 1,191:  
|VARCHAR2(3 CHAR)
 
|VARCHAR2(3 CHAR)
 
|
 
|
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|Yes
 
|Yes
Line 1,199: Line 1,200:  
|VARCHAR2(3 CHAR)
 
|VARCHAR2(3 CHAR)
 
|
 
|
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|Oui
 
|Oui
Line 1,211: Line 1,212:  
|NULL
 
|NULL
 
|Scheduled
 
|Scheduled
|**Not used by program.**
+
| **Not used by program.**
 
|Contains default system information.
 
|Contains default system information.
 
|-
 
|-
Line 1,217: Line 1,218:  
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 
|
 
|
| Yes
+
|Yes
 
|NULL
 
|NULL
 
|
 
|
Line 1,246: Line 1,247:  
|Yes
 
|Yes
 
|NULL
 
|NULL
| Jeff Tyndall
+
|Jeff Tyndall
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,264: Line 1,265:  
|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.
 
|
 
|
 
|-
 
|-
Line 1,284: Line 1,285:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,290: Line 1,291:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,307: Line 1,308:  
|No
 
|No
 
|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.
Line 1,317: Line 1,318:  
| NULL
 
| NULL
 
|00027-FUTURE HEALTH TECHNOLOGIES
 
|00027-FUTURE HEALTH TECHNOLOGIES
|This is the parent inspection number.
+
| This is the parent inspection number.
 
|
 
|
 
|-
 
|-
 
|SUBJECT
 
|SUBJECT
|VARCHAR2(500 CHAR)
+
| VARCHAR2(500 CHAR)
 
|
 
|
 
|Yes
 
|Yes
Line 1,329: Line 1,330:  
|
 
|
 
|-
 
|-
| 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.
|
+
|
|-
+
|-
|CREATEDBYNAME
+
|CREATEDBYNAME
|VARCHAR2(100 CHAR)
+
|VARCHAR2(100 CHAR)
|
+
|
|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
|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
|NULL
+
|NULL
| Jeff Tyndall
+
|Jeff Tyndall
| This identifies the resource that last modified the record.
+
|This identifies the resource that last modified the record.
 
|
 
|
 
|-
 
|-
Line 1,381: Line 1,382:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,387: Line 1,388:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,421: Line 1,422:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,427: Line 1,428:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,461: Line 1,462:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,467: Line 1,468:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,501: Line 1,502:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,507: Line 1,508:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,541: Line 1,542:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,547: Line 1,548:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
+
! scope="col" style="width: 350px;" | Comments
 
|-
 
|-
 
|
 
|
Line 1,581: Line 1,582:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,587: Line 1,588:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
+
! scope="col" style="width: 350px;" | Comments
 
|-
 
|-
 
|
 
|
Line 1,615: Line 1,616:  
|}
 
|}
   −
=== MD_INS_INS_IRC_OBSERVATIONS===
+
===MD_INS_INS_IRC_OBSERVATIONS===
 
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   Line 1,621: Line 1,622:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,627: Line 1,628:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,655: Line 1,656:  
|}
 
|}
   −
=== MD_INS_INS_SITE===
+
===MD_INS_INS_SITE===
 
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   Line 1,661: Line 1,662:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,667: Line 1,668:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
+
! scope="col" style="width: 350px;" | Comments
 
|-
 
|-
 
|
 
|
Line 1,701: Line 1,702:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,707: Line 1,708:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,741: Line 1,742:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,747: Line 1,748:  
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 50px;" |Data Default
 
! scope="col" style="width: 500px;" |Example Data
 
! scope="col" style="width: 500px;" |Example Data
! scope="col" style="width: 350px;" | Description
+
! scope="col" style="width: 350px;" |Description
 
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
Line 1,781: Line 1,782:  
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
! scope="col" style="width: 350px;" | Column Name
+
! scope="col" style="width: 350px;" |Column Name
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 100px;" |DataType
 
! scope="col" style="width: 50px;" |Key Type
 
! scope="col" style="width: 50px;" |Key Type
Line 1,787: Line 1,788:  
! 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
 
|-
 
|-
71

edits

Navigation menu

GCwiki