67
edits
Changes
no edit summary
=== MD_INS_CASE ===
=== MD_INS_CASE ===
This table holds the main inspection information.
This table holds the main inspection information.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Key Type
! scope="col" style="width: 100px;" |DataType
!DataType
! scope="col" style="width: 50px;" |Key Type
! scope="col" style="width: 50px;" |Nullable
!Data Default
! scope="col" style="width: 50px;" |Data Default
!Example Data
! scope="col" style="width: 500px;" |Example Data
!Description
! scope="col" style="width: 350px;" |Description
!Comments
! scope="col" style="width: 350px;" |Comments
|-
|-
|INSP_ID
|INSP_ID
|
|
|-
|-
|LICENCE_NO
| LICENCE_NO
|Foreign
|Foreign
|NUMBER(6,0)
|NUMBER(6,0)
|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.
|
|
|-
|-
|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.
|
|
|-
|-
|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.
|
|
|-
|-
|SUPERVISOR_ID
|SUPERVISOR_ID
|Foreign
|Foreign
|VARCHAR2(36 CHAR)
| VARCHAR2(36 CHAR)
|Yes
|Yes
|NULL
|NULL
|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)
|NULL
|NULL
|Food & Drugs Act, Medical Device Regulations
|Food & Drugs Act, Medical Device Regulations
|This is the compliance standard that the site was inspected against in English. Either the FDA or MDR.
|This is the compliance standard that the site was inspected against in English. Either the FDA or MDR.
|
|
|-
|-
|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.
|
|
|-
|-
|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.
|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.
|NULL
|NULL
|None
|None
|This indicates if any samples were taken during the inspection.
| This indicates if any samples were taken during the inspection.
|
|
|-
|-
|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.
|CLOSING_MEETING_DATE
|CLOSING_MEETING_DATE
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|
|
|DATE
|DATE
|Yes
| Yes
|NULL
|NULL
|24-03-15
|24-03-15
|
|
|VARCHAR2(5 CHAR)
|VARCHAR2(5 CHAR)
|Yes
| Yes
|NULL
|NULL
|Yes
|Yes
|
|
|-
|-
|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.
|
|
|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)
|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@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.
|
|
|-
|-
|
|
|-
|-
|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.
|
|
|-
|-
|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.
|
|
|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)
|
|
|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.
|
|
|-
|-
|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.
|
|
|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
|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
|-
|-
|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
|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)
|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_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.
|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.
|
|
|CREATEDON
|CREATEDON
|
|
|DATE
| DATE
|Yes
|Yes
|NULL
|NULL
|
|
|-
|-
|MODIFIEDBYNAME
| MODIFIEDBYNAME
|
|
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
===MD_INS_CASE_CAPA===
===MD_INS_CASE_CAPA===
This table holds information about the corrective action plan for an inspection observation.
This table holds information about the corrective action plan for an inspection observation.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Data Default
! scope="col" style="width: 50px;" |Data Default
!Example Data
! scope="col" style="width: 500px;" |Example Data
!Description
! scope="col" style="width: 350px;" |Description
!Comments
! scope="col" style="width: 350px;" |Comments
|-
|-
|CAPA_ID
|CAPA_ID
|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
===MD_INS_CASE_DESIGNATION===
===MD_INS_CASE_DESIGNATION===
This table holds information that categorizes or "tags" an inspection. These are flexible codes used to capture information if a designated field does not exist.
This table holds information that categorizes or "tags" an inspection. These are flexible codes used to capture information if a designated field does not exist.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|INSP_DESIGNATION_ID
| INSP_DESIGNATION_ID
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Primary
|Primary
|No
|No
|NULL
|dca846bf-cc2f-ee11-bdf4-002248b32010
|dca846bf-cc2f-ee11-bdf4-002248b32010
|This is the unique record identifier for the designation.
|This is the unique record identifier for the designation.
|Foreign
|Foreign
|No
|No
|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.
|-
|-
|Foreign
|Foreign
|No
|No
|NULL
|00070-QUART HEALTHCARE INC.
|00070-QUART HEALTHCARE INC.
|This is the parent inspection number.
|This is the parent inspection number.
|
|-
|-
|DESIGNATION_ID
|DESIGNATION_ID
|Foreign
|Foreign
|No
|No
|NULL
|ea30c0ef-5214-ee11-9cbe-002248af8a65
|ea30c0ef-5214-ee11-9cbe-002248af8a65
|This is the unique record identifier for the designation code.
|This is the unique record identifier for the designation code.
|
|
|Yes
|Yes
| NULL
|5006
|5006
|This is the designation code.
|This is the designation code.
|
|
|-
|-
|DESIGNATION_NAME
| DESIGNATION_NAME
|VARCHAR2(250 CHAR)
|VARCHAR2(250 CHAR)
|
|
|Yes
|Yes
|NULL
|Covid
|Covid
|This is the name of the designation code.
|This is the name of the designation code.
|-
|-
|DESIGNATION_DECODE_EN
|DESIGNATION_DECODE_EN
|
|
|Yes
|Yes
|Covid
|NULL
| Covid
|This is the name of the designation code in English.
|This is the name of the designation code in English.
|
|
|
|
|Yes
|Yes
|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
|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
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|
|-
|-
|MODIFIEDBYNAME
|MODIFIEDBYNAME
|
|
|Yes
|Yes
|NULL
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that last modified the record.
|This identifies the resource that last modified the record.
|
|-
|-
|MODIFIEDON
|MODIFIEDON
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
|
|}
|}
===MD_INS_CASE_ESTACTIVITY===
===MD_INS_CASE_ESTACTIVITY===
This table holds information on the activities conducted by the company at the time of the inspection as recorded by the inspector.
This table holds information on the activities conducted by the company at the time of the inspection as recorded by the inspector.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|INSP_ACTIVITY_ID
|INSP_ACTIVITY_ID
|Primary
|Primary
|No
|No
|NULL
|7a743745-5fec-ee11-a1fd-002248af8802
|7a743745-5fec-ee11-a1fd-002248af8802
|This is the unique record identifier for the establishment activity.
|This is the unique record identifier for the establishment activity.
|
|
|-
|-
| INSP_ID
|INSP_ID
|VARCHAR2(36 CHAR)
|VARCHAR2(36 CHAR)
|Foreign
|Foreign
|No
|No
|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.
|Foreign
|Foreign
|No
|No
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
|NULL
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|Foreign
|Foreign
|No
|No
|NULL
|d7ce3513-4d14-ee11-9cbe-002248af8a65
|d7ce3513-4d14-ee11-9cbe-002248af8a65
|This is the unique record identifier for the activity value.
|This is the unique record identifier for the activity value.
|
|
|Yes
|Yes
| NULL
|Importateur - Classe 2
|Importateur - Classe 2
|This is the establishment activity.
|This is the establishment activity.
|
|
|Yes
|Yes
|NULL
|Importer - Class 2
|Importer - Class 2
|This is the name of the establishment activity in English.
|This is the name of the establishment activity in English.
|
|
|-
|-
|ACTIVITY_DECODE_FR
| ACTIVITY_DECODE_FR
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|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
|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
|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
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that last modified the record.
|This identifies the resource that last modified the record.
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
|}
|}
===MD_INS_CASE_INSPECTORS===
=== MD_INS_CASE_INSPECTORS===
This table holds a listing of inspectors assigned to an inspection.
This table holds a listing of inspectors assigned to an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
! Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
! Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|BK_ID
|BK_ID
|Primary
|Primary
|No
|No
|NULL
|10cd1617-e303-ef11-9f89-002248b15d0c
|10cd1617-e303-ef11-9f89-002248b15d0c
|This is the unique record identifier for the inspector listing.
|This is the unique record identifier for the inspector listing.
|Foreign
|Foreign
|No
|No
|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.
|Foreign
|Foreign
|No
|No
|00093-ROCHE DIAGNOSTICS
|NULL
|00093-ROCHE DIAGNOSTICS
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|
|
|Yes
|Yes
| NULL
|Jeff Tyndall
|Jeff Tyndall
|This is the name of the inspector.
|This is the name of the inspector.
|-
|-
|LEADINSPECTOR_EN
|LEADINSPECTOR_EN
| VARCHAR2(3 CHAR)
|VARCHAR2(3 CHAR)
|
|
|Yes
|Yes
|NULL
|Yes
|Yes
|This indicates if the inspector is the lead inspector on the inspection in English.
|This indicates if the inspector is the lead inspector on the inspection in English.
|-
|-
|LEADINSPECTOR_FR
|LEADINSPECTOR_FR
| VARCHAR2(3 CHAR)
|VARCHAR2(3 CHAR)
|
|
|Yes
|Yes
|NULL
|Oui
|Oui
|This indicates if the inspector is the lead inspector on the inspection in French.
|This indicates if the inspector is the lead inspector on the inspection in French.
|ASSIGNSTATUS_EN
|ASSIGNSTATUS_EN
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
| NULL
|Scheduled
|Scheduled
|**Not used by program.**
|**Not used by program.**
|ASSIGNSTATUS_FR
|ASSIGNSTATUS_FR
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
|Yes
|NULL
|
|
|**Not used by program.**
|**Not used by program.**
|STARTTIME
|STARTTIME
|DATE
|DATE
|
|
|Yes
|Yes
|NULL
|23-10-20
|23-10-20
|**Not used by program.**
|**Not used by program.**
|Contains default system information.
|Contains default system information.
|-
|-
| ENDTIME
|ENDTIME
|DATE
|DATE
|
|
|Yes
|Yes
|NULL
|23-10-20
|23-10-20
|**Not used by program.**
|**Not used by program.**
|
|
|Yes
|Yes
|NULL
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
| Yes
|NULL
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that last modified the record.
|This identifies the resource that last modified the record.
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
===MD_INS_CASE_NOTES===
===MD_INS_CASE_NOTES===
This table holds notes related to the inspection.
This table holds notes related to the inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|ANNOTATION_ID
|ANNOTATION_ID
|Primary
|Primary
|No
|No
|NULL
|d2fa45bc-f953-8e06-8fc1-e116086f174f
|d2fa45bc-f953-8e06-8fc1-e116086f174f
|This is the unique record identifier for the note.
|This is the unique record identifier for the note.
|Foreign
|Foreign
|No
|No
|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.
|Foreign
|Foreign
|No
|No
|00027-FUTURE HEALTH TECHNOLOGIES
|NULL
|00027-FUTURE HEALTH TECHNOLOGIES
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|
|
|Yes
|Yes
|NULL
|Talked to client and set out inspection plan.
|Talked to client and set out inspection plan.
|This is the subject of the note.
|This is the subject of the note.
|
|
|Yes
|Yes
|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
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was created.
|This identifies the date that record was created.
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|
|Yes
| Yes
|NULL
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that last modified the record.
|This identifies the resource that last modified the record.
|
|
|Yes
|Yes
|NULL
|22-08-26
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
===MD_INS_CASE_OBSERVATIONS===
===MD_INS_CASE_OBSERVATIONS===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
! Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" | Nullable
!Example Data
! scope="col" style="width: 50px;" | Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
|}
|}
===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"
{| class="wikitable sortable"
|+
|+
! Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_IID===
===MD_INS_INS_IID===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_INSPECTORLIST===
===MD_INS_INS_INSPECTORLIST===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_IRC_ENFORCEMENT===
===MD_INS_INS_IRC_ENFORCEMENT===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_IRC_MEASURES===
===MD_INS_INS_IRC_MEASURES===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
! Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
! Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
! Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===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"
{| class="wikitable sortable"
|+
|+
! Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===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"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_SITE_CONTACT===
===MD_INS_INS_SITE_CONTACT===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_LICENCE===
===MD_INS_INS_LICENCE===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
! Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|
===MD_INS_INS_SITELICENCEACTIVITY===
===MD_INS_INS_SITELICENCEACTIVITY===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable sortable"
|+
|+
!Column Name
! scope="col" style="width: 350px;" |Column Name
!Data Type
! scope="col" style="width: 100px;" |DataType
!Key Type
! scope="col" style="width: 50px;" |Key Type
!Nullable
! scope="col" style="width: 50px;" |Nullable
!Example Data
! scope="col" style="width: 50px;" |Data Default
!Description
! scope="col" style="width: 500px;" |Example Data
!Comments
! scope="col" style="width: 350px;" |Description
! scope="col" style="width: 350px;" |Comments
|-
|-
|
|