Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 17:12, 23 May 2024

1,102 bytes added , 23 May

no edit summary

Line 5: Line 5:

=== MD_INS_CASE ===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds the main inspection information.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 14: Line 16:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 46: Line 48:

|SITE_NAME

|

−

|VARCHAR2(160 CHAR)

+

| VARCHAR2(160 CHAR)

|Yes

|NULL

Line 53: Line 55:

|

|-

−

| LICENCE_NO

+

|LICENCE_NO

−

|Foreign

+

| Foreign

|NUMBER(6,0)

|Yes

|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.

|-

Line 73: Line 75:

|REG_FILE_NUMBER

|

−

| VARCHAR2(250 BYTE)

+

|VARCHAR2(250 BYTE)

|Yes

|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

|

−

|VARCHAR2(50 CHAR)

+

| VARCHAR2(50 CHAR)

−

|Yes

+

| Yes

|NULL

|East

Line 94: Line 96:

|Yes

|NULL

−

| Est

+

|Est

| This is the operational centre assigned to the inspection in French.

|

Line 100: Line 102:

|INSP_TYPE_EN

|

−

|VARCHAR2(100 CHAR)

+

| VARCHAR2(100 CHAR)

−

|Yes

+

| Yes

−

|NULL

+

| NULL

|Domestic - New - Onsite

|This is the type of inspection in English.

Line 112: Line 114:

|Yes

|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 130: Line 132:

|Yes

|NULL

−

|Vanessa Toussaint

+

| Vanessa Toussaint

|This is the name of the lead inspector.

|

Line 136: Line 138:

|LEAD_INSPECTOR_BADGE

|

−

|VARCHAR2(50 BYTE)

+

| VARCHAR2(50 BYTE)

|Yes

−

|NULL

+

| NULL

|54355335

|This is the badge number of the lead inspector.

Line 145: Line 147:

|SUPERVISOR_ID

|Foreign

−

| VARCHAR2(36 CHAR)

+

|VARCHAR2(36 CHAR)

|Yes

|NULL

Line 154: Line 156:

|SUPERVISOR

|

−

|VARCHAR2(200 CHAR)

+

| VARCHAR2(200 CHAR)

|Yes

|NULL

−

|Ada Lai

+

| Ada Lai

|This is the name of the supervisor for the inspection.

|

Line 167: Line 169:

|NULL

|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)

|Yes

|NULL

−

|Ouvert

+

| Ouvert

|This is the status of the inspection in French.

|

Line 190: Line 192:

|COMP_STANDARD_FR

|

−

| VARCHAR2(100 CHAR)

+

|VARCHAR2(100 CHAR)

|Yes

|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.

|

Line 199: Line 201:

|DRAFT_REPORT_RATING_EN

|

−

|VARCHAR2(100 CHAR)

+

| VARCHAR2(100 CHAR)

|Yes

−

| NULL

+

|NULL

|Compliant

|This is the draft inspection rating in English.

Line 210: Line 212:

|VARCHAR2(100 CHAR)

|Yes

−

| NULL

+

|NULL

|Conforme

|This is the draft inspection rating in French.

Line 219: Line 221:

|DATE

|Yes

−

|NULL

+

| NULL

|24-03-21

|This is the date that the draft inspection rating was issued.

Line 226: Line 228:

|FINAL_REPORT_RATING_EN

|

−

|VARCHAR2(100 CHAR)

+

| VARCHAR2(100 CHAR)

|Yes

−

| NULL

+

|NULL

|Compliant

|This is the final inspection rating in English.

Line 244: Line 246:

|FINAL_REPORT_ISSUE_DATE

|

−

| DATE

+

|DATE

−

|Yes

+

| Yes

|NULL

−

| 24-03-21

+

|24-03-21

|This is the date that the final inspection rating was issued.

|

Line 255: Line 257:

|DATE

|Yes

−

| NULL

+

|NULL

|24-03-22

|This is the date that an amended inspection report was issued to the company.

Line 263: Line 265:

|

|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 276: Line 278:

|24-01-30

|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

|

−

|DATE

+

| DATE

|Yes

−

| NULL

+

|NULL

|24-01-30

|This indicates when the inspection was finished.

Line 292: Line 294:

|Yes

|NULL

−

|23-11-15

+

| 23-11-15

|This indicates when the inspector had the closing meeting with the company.

|

Line 298: Line 300:

|NEXT_INSPECTION_DATE

|

−

|DATE

+

| DATE

−

| Yes

+

|Yes

−

|NULL

+

| NULL

|24-03-15

|This indicates when the company is due for its next inspection

Line 308: Line 310:

|

|VARCHAR2(5 CHAR)

−

| Yes

+

|Yes

|NULL

|Yes

Line 332: Line 334:

|

|-

−

| AMENDED_DATE

+

|AMENDED_DATE

|

−

|DATE

+

| DATE

|Yes

| NULL

Line 344: Line 346:

|

|DATE

−

| Yes

+

|Yes

|NULL

|24-02-21

Line 368: Line 370:

|

|-

−

| FIRST_COMM_MODE_FR

+

|FIRST_COMM_MODE_FR

|

|VARCHAR2(100 CHAR)

Line 379: Line 381:

|EMERGENCY_CONTACT_NAME

|

−

|VARCHAR2(100 CHAR)

+

| VARCHAR2(100 CHAR)

|Yes

|NULL

Line 392: Line 394:

|NULL

|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

−

| Foreign

+

|Foreign

|VARCHAR2(36 CHAR)

−

| Yes

+

|Yes

|NULL

|31175da9-efdf-ee11-904c-000d3a847fce

Line 410: Line 412:

|NULL

|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 417: Line 419:

|VARCHAR2(100 CHAR)

|Yes

−

|NULL

+

| NULL

|G.M.

|This is the job title of the senior official for the company at the time of inspection.

Line 442: Line 444:

|

|VARCHAR2(100 CHAR)

−

|Yes

+

| Yes

|NULL

|MANAGER, COMMERCIAL QUALITY & REG EU & CAN

Line 452: Line 454:

|VARCHAR2(100 CHAR)

|Yes

−

|NULL

+

| NULL

|416-765-0345

|This is the phone number of the contact of the company at the time of inspection.

Line 459: Line 461:

|

|VARCHAR2(100 CHAR)

−

|Yes

+

| Yes

|NULL

−

|514-123-4567

+

| 514-123-4567

|This is the fax of the contact of the company at the time of inspection.

|

Line 471: Line 473:

|NULL

|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.

|

|-

Line 479: Line 481:

|Yes

|NULL

−

|36 NORTHLINE ROAD, SUITE 9

+

| 36 NORTHLINE ROAD, SUITE 9

|This is the address of the company being inspected.

|

Line 488: Line 490:

|Yes

|NULL

−

|Suite 101

+

| Suite 101

|This is secondary the address of the company being inspected.

|

|-

−

| SITE_ADDRESS_3

+

|SITE_ADDRESS_3

|

|VARCHAR2(250 CHAR)

Line 518: Line 520:

|

|-

−

| SITE_POSTALCODE

+

|SITE_POSTALCODE

|

|VARCHAR2(20 CHAR)

−

| Yes

+

|Yes

| NULL

|M4B 3E2

−

| This is the postal code of the company being inspected.

+

|This is the postal code of the company being inspected.

|

|-

Line 539: Line 541:

|

|CLOB

−

|Yes

+

| Yes

|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).

Line 550: Line 552:

|Yes

|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.

|

|-

−

| REPORT_DELIVERED_TO

+

|REPORT_DELIVERED_TO

|

−

|VARCHAR2(200 CHAR)

+

| VARCHAR2(200 CHAR)

|Yes

|NULL

−

|MARILU ALEJANDRA VALERIANO

+

| MARILU ALEJANDRA VALERIANO

|This is the name of the contact of the company who received the final inspection report.

|

Line 566: Line 568:

|

|DATE

−

| Yes

+

|Yes

|NULL

|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 581: Line 583:

|

|-

−

|PERSONNEL_CHANGES

+

| PERSONNEL_CHANGES

|

|VARCHAR2(2000 BYTE)

Line 593: Line 595:

|

|VARCHAR2(50 CHAR)

−

| Yes

+

|Yes

|NULL

−

| In Progress

+

|In Progress

|This indicates the status of the IID in English.

|DHPID Transparency IID

|-

−

|IID_STATUS_FR

+

| IID_STATUS_FR

|

|VARCHAR2(50 CHAR)

|Yes

|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

|-

Line 613: Line 615:

|Yes

|NULL

−

|24-03-15

+

| 24-03-15

|This indicates the status date of the IID.

−

| DHPID Transparency IID

+

|DHPID Transparency IID

|-

|IID_REVISION_LOG

Line 623: Line 625:

|NULL

|Updated deficiency.

−

|This indicates any revisions carried out to the IID.

+

| This indicates any revisions carried out to the IID.

|DHPID Transparency IID

|-

Line 630: Line 632:

|VARCHAR2(50 CHAR)

|Yes

−

| NULL

+

|NULL

|IRC Ready For Publication

|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

|NULL

Line 673: Line 675:

|DHPID Transparency IRC

|-

−

| INSP_OUTCOME_FR

+

|INSP_OUTCOME_FR

|

|VARCHAR2(2000 CHAR)

−

| Yes

+

|Yes

|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

Line 682: Line 684:

|DHPID Transparency IRC

|-

−

| INSP_REPORT_WAITING

+

|INSP_REPORT_WAITING

|

|VARCHAR2(200 CHAR)

Line 693: Line 695:

|INSP_REPORT_WAITING_DATE

|

−

|DATE

+

| DATE

|Yes

|NULL

Line 711: Line 713:

|INSP_REPORT_APPROVED_BY_DATE

|

−

|DATE

+

| DATE

|Yes

−

|NULL

+

| NULL

|23-11-27

|This is the date the supervisor approved the inspection report in the record log.

|

|-

−

| INSP_CLOSED_WAITING

+

|INSP_CLOSED_WAITING

|

|VARCHAR2(200 CHAR)

|Yes

−

| NULL

+

|NULL

|Jeff Tyndall

|This is the inspector's name who sent the inspection for closure in the record log.

Line 728: Line 730:

|INSP_CLOSED_WAITING_DATE

|

−

|DATE

+

| DATE

|Yes

|NULL

Line 749: Line 751:

|Yes

|NULL

−

| 23-11-29

+

|23-11-29

|This is the date the supervisor approved the inspection for closure in the record log.

|

Line 758: Line 760:

|Yes

|NULL

−

| Vanessa Toussaint

+

|Vanessa Toussaint

|This identifies the resource that created the record.

|

Line 771: Line 773:

|

|-

−

| MODIFIEDBYNAME

+

|MODIFIEDBYNAME

|

|VARCHAR2(100 CHAR)

|Yes

|NULL

−

|Vanessa Toussaint

+

| Vanessa Toussaint

−

|This identifies the resource that last modified the record.

+

| This identifies the resource that last modified the record.

|

|-

Line 791: Line 793:

===MD_INS_CASE_CAPA===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information about the corrective action plan for an inspection observation.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 800: Line 804:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

−

|CAPA_ID

+

| CAPA_ID

|VARCHAR2(36 CHAR)

|Primary

|No

|NULL

−

| ad5e55f6-8b21-ee11-9966-000d3ae86452

+

|ad5e55f6-8b21-ee11-9966-000d3ae86452

|This is the unique record identifier for the CAPA.

|

Line 815: Line 819:

|VARCHAR2(36 CHAR)

|Foreign

−

| No

+

|No

|NULL

|3d7a309e-ce46-40c5-a6c2-f3ea80971d48

Line 824: Line 828:

|VARCHAR2(200 CHAR)

|Foreign

−

| No

+

|No

|NULL

|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS

Line 840: Line 844:

|-

|CAPA_TYPE

−

| VARCHAR2(100 CHAR)

+

|VARCHAR2(100 CHAR)

|

|Yes

−

|NULL

+

| NULL

|Follow Up Plan

|This is a free text field used to identify the type of CAPA.

Line 849: Line 853:

|-

|CAPA_PLAN

−

|VARCHAR2(2000 CHAR)

+

| VARCHAR2(2000 CHAR)

|

|Yes

Line 862: Line 866:

|Yes

|NULL

−

|Jeff Tyndall

+

| Jeff Tyndall

|This identifies the resource that created the record.

|

Line 880: Line 884:

|Yes

|NULL

−

|Jeff Tyndall

+

| Jeff Tyndall

−

|This identifies the resource that last modified the record.

+

| This identifies the resource that last modified the record.

|

|-

Line 895: Line 899:

===MD_INS_CASE_DESIGNATION===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

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 sortable"

+

{| 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: 50px;" |Key Type

Line 904: Line 910:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

−

| INSP_DESIGNATION_ID

+

|INSP_DESIGNATION_ID

|VARCHAR2(36 CHAR)

|Primary

Line 922: Line 928:

|NULL

|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.

|-

Line 930: Line 936:

|No

|NULL

−

|00070-QUART HEALTHCARE INC.

+

| 00070-QUART HEALTHCARE INC.

|This is the parent inspection number.

|

Line 944: Line 950:

|-

|DESIGNATION_CODE

−

|VARCHAR2(100 CHAR)

+

| VARCHAR2(100 CHAR)

|

|Yes

−

| NULL

+

|NULL

|5006

|This is the designation code.

|

|-

−

| DESIGNATION_NAME

+

|DESIGNATION_NAME

−

|VARCHAR2(250 CHAR)

+

| VARCHAR2(250 CHAR)

|

|Yes

Line 965: Line 971:

|Yes

|NULL

−

| Covid

+

|Covid

|This is the name of the designation code in English.

|

|-

|DESIGNATION_DECODE_FR

−

|VARCHAR2(100 CHAR)

+

| VARCHAR2(100 CHAR)

|

|Yes

|NULL

−

|Covid

+

| Covid

|This is the name of the designation code in French.

|

Line 983: Line 989:

|Yes

|NULL

−

|Jeff Tyndall

+

| Jeff Tyndall

|This identifies the resource that created the record.

|

|-

−

| CREATEDON

+

|CREATEDON

|DATE

|

Line 1,001: Line 1,007:

|Yes

|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,016: Line 1,022:

===MD_INS_CASE_ESTACTIVITY===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information on the activities conducted by the company at the time of the inspection as recorded by the inspector.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,025: Line 1,033:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,065: Line 1,073:

|-

|ACTIVITY_NAME

−

|VARCHAR2(205 CHAR)

+

| VARCHAR2(205 CHAR)

|

−

|Yes

+

| Yes

−

| NULL

+

|NULL

|Importateur - Classe 2

|This is the establishment activity.

Line 1,076: Line 1,084:

|VARCHAR2(100 CHAR)

|

−

|Yes

+

| Yes

|NULL

|Importer - Class 2

Line 1,082: Line 1,090:

|

|-

−

| ACTIVITY_DECODE_FR

+

|ACTIVITY_DECODE_FR

|VARCHAR2(100 CHAR)

|

|Yes

|NULL

−

|Importateur - Classe 2

+

| Importateur - Classe 2

|This is the name of the establishment activity in French.

|

Line 1,096: Line 1,104:

|Yes

|NULL

−

|Jeff Tyndall

+

| Jeff Tyndall

|This identifies the resource that created the record.

|

Line 1,103: Line 1,111:

|DATE

|

−

| Yes

+

|Yes

|NULL

|22-08-26

Line 1,114: Line 1,122:

|Yes

|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,128: Line 1,136:

|}

−

=== MD_INS_CASE_INSPECTORS===

+

===MD_INS_CASE_INSPECTORS===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds a listing of inspectors assigned to an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,138: Line 1,148:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,172: Line 1,182:

|

|Yes

−

| NULL

+

|NULL

|Jeff Tyndall

|This is the name of the inspector.

Line 1,180: Line 1,190:

|VARCHAR2(3 CHAR)

|

−

|Yes

+

| Yes

|NULL

|Yes

Line 1,189: Line 1,199:

|VARCHAR2(3 CHAR)

|

−

|Yes

+

| Yes

|NULL

|Oui

Line 1,199: Line 1,209:

|

|Yes

−

| NULL

+

|NULL

|Scheduled

|**Not used by program.**

Line 1,207: Line 1,217:

|VARCHAR2(100 CHAR)

|

−

|Yes

+

| Yes

|NULL

|

Line 1,236: Line 1,246:

|Yes

|NULL

−

|Jeff Tyndall

+

| Jeff Tyndall

|This identifies the resource that created the record.

|

Line 1,252: Line 1,262:

|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.

|

|-

Line 1,269: Line 1,279:

===MD_INS_CASE_NOTES===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds notes related to the inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,278: Line 1,290:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,303: Line 1,315:

|Foreign

|No

−

|NULL

+

| NULL

|00027-FUTURE HEALTH TECHNOLOGIES

|This is the parent inspection number.

Line 1,317: Line 1,329:

|

|-

−

|NOTETEXT

+

| NOTETEXT

|CLOB

|

|Yes

|NULL

−

|Communication with company on 2023-09-01.

+

| Communication with company on 2023-09-01.

|This is the body of the note.

|

Line 1,331: Line 1,343:

|Yes

|NULL

−

|Jeff Tyndall

+

| Jeff Tyndall

|This identifies the resource that created the record.

|

Line 1,347: Line 1,359:

|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.

|

|-

Line 1,364: Line 1,376:

===MD_INS_CASE_OBSERVATIONS===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 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: 350px;" |Description

+

! scope="col" style="width: 350px;" | Description

! scope="col" style="width: 350px;" |Comments

|-

Line 1,401: Line 1,415:

|}

−

=== MD_INS_CASE_WORKFLOW===

+

===MD_INS_CASE_WORKFLOW===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,411: Line 1,427:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,440: Line 1,456:

===MD_INS_INS_IID===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,449: Line 1,467:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,478: Line 1,496:

===MD_INS_INS_INSPECTORLIST===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,487: Line 1,507:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,516: Line 1,536:

===MD_INS_INS_IRC_ENFORCEMENT===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,525: Line 1,547:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,554: Line 1,576:

===MD_INS_INS_IRC_MEASURES===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,563: Line 1,587:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,591: Line 1,615:

|}

−

===MD_INS_INS_IRC_OBSERVATIONS===

+

=== MD_INS_INS_IRC_OBSERVATIONS===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,601: Line 1,627:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,629: Line 1,655:

|}

−

===MD_INS_INS_SITE===

+

=== MD_INS_INS_SITE===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,639: Line 1,667:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,668: Line 1,696:

===MD_INS_INS_SITE_CONTACT===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,677: Line 1,707:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,706: Line 1,736:

===MD_INS_INS_LICENCE===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,715: Line 1,747:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Line 1,744: Line 1,776:

===MD_INS_INS_SITELICENCEACTIVITY===

+

[[MDCCD Data Warehouse|Return to Home Page.]]

+

This table holds information that categorizes or "tags" an inspection.

−

{| class="wikitable sortable"

+

{| 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: 50px;" |Key Type

Line 1,753: Line 1,787:

! scope="col" style="width: 50px;" |Data Default

! 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

|-

Jeff.tyndall

67

edits