wiki

Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 15:10, 28 August 2024

1,970 bytes added ,  15:10, 28 August 2024
no edit summary
Line 1: Line 1:  +
{{Delete|reason=Moved to internal Health Canada wiki. Internal database structure should not be public.}}
 
== Overview ==
 
== Overview ==
 
This page provides a data dictionary for each table that is held within the [[MDCCD Data Warehouse]].
 
This page provides a data dictionary for each table that is held within the [[MDCCD Data Warehouse]].
Line 1,380: Line 1,381:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds information about the observations for an inspection.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,417: Line 1,418:  
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
 
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
 
|This is the unique record identifier for the parent inspection.
 
|This is the unique record identifier for the parent inspection.
−
|
+
|Use to join with MD_INS_CASE.INSP_ID.
 
|-
 
|-
 
|INSP_NUM
 
|INSP_NUM
Line 1,623: Line 1,624:  
|}
 
|}
   −
===MD_INS_INS_SITELICENCEACTIVITY===
+
===MD_INS_INS_CASE_WORKFLOW===
 
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds information about the workflow of the inspection.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,638: Line 1,639:  
! scope="col" style="width: 350px;" |Comments
 
! scope="col" style="width: 350px;" |Comments
 
|-
 
|-
 +
|WF_ID
 +
|VARCHAR2(36 CHAR)
 +
|Primary
 +
|No
 +
|NULL
 +
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
 +
|This is the unique record identifier for the workflow.
 
|
 
|
 +
|-
 +
|WF_NAME
 +
|VARCHAR2(50 BYTE)
 
|
 
|
 +
|Yes
 +
|NULL
 +
|Inspection Business Process
 +
|This is the name of the workflow.
 
|
 
|
 +
|-
 +
|INSP_ID
 +
|VARCHAR2(36 CHAR)
 +
|Foreign
 +
|No
 +
|NULL
 +
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
 +
|This is the unique record identifier for the parent inspection.
 +
|Use to join with MD_INS_CASE.INSP_ID.
 +
|-
 +
|INSP_NUM
 +
|VARCHAR2(200 CHAR)
 
|
 
|
 +
|No
 +
|NULL
 +
|00070-MDCCD HEALTHCARE INC
 +
|This is the parent inspection number.
 
|
 
|
 +
|-
 +
|ACTIVESTAGEID
 +
|VARCHAR2(36 CHAR)
 
|
 
|
 +
|No
 +
|NULL
 +
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
 +
|This is the unique record identifier for the current stage of the workflow.
 
|
 
|
 
|-
 
|-
 +
|STAGE_NAME_EN
 +
|VARCHAR2(50 BYTE)
 
|
 
|
 +
|Yes
 +
|NULL
 +
|Start Of Inspection
 +
|This is the name of the current workflow stage in English.
 
|
 
|
 +
|-
 +
|STAGE_NAME_FR
 +
|VARCHAR2(50 BYTE)
 
|
 
|
 +
|Yes
 +
|NULL
 +
|Début de l'inspection
 +
|This is the name of the current workflow stage in French.
 
|
 
|
 +
|-
 +
|STAGE_START_DATE
 +
|DATE
 
|
 
|
−
|
+
|Yes
 +
|NULL
 +
|23-11-09
 +
|This is the date that the current workflow stage was started.
 
|
 
|
 
|-
 
|-
 +
|WF_COMPLETE_DATE
 +
|DATE
 
|
 
|
 +
|Yes
 +
|NULL
 +
|23-11-09
 +
|This is the date the workflow was completed.
 
|
 
|
 +
|-
 +
|WF_DURATION
 +
|NUMBER(4,0)
 
|
 
|
 +
|Yes
 +
|NULL
 +
|42
 +
|This identifies how many days the workflow was active.
 
|
 
|
 +
|-
 +
|CREATEDBYNAME
 +
|VARCHAR2(100 CHAR)
 
|
 
|
 +
|Yes
 +
|NULL
 +
|John Smith
 +
|This identifies the resource that created the record.
 
|
 
|
 +
|-
 +
|CREATEDON
 +
|DATE
 
|
 
|
−
|
+
|Yes
 +
|NULL
 +
|22-08-26
 +
|This identifies the date that record was created.
 
|-
 
|-
 +
|MODIFIEDBYNAME
 +
|VARCHAR2(100 CHAR)
 
|
 
|
 +
|Yes
 +
|NULL
 +
|John Smith
 +
|This identifies the resource that last modified the record.
 
|
 
|
 +
|-
 +
|MODIFIEDON
 +
|DATE
 
|
 
|
−
|
+
|Yes
−
|
+
|NULL
−
|
+
|22-08-26
−
|
+
|This identifies the date that record was last modified.
−
|-
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|-
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|-
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|-
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|-
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|
  −
|-
  −
|
  −
|
  −
|
  −
|
  −
|
   
|
 
|
 
|}
 
|}
Line 1,723: Line 1,769:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the Initial Inspection Deficiency information for an inspection that is posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,851: Line 1,897:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds a list of inspectors within the system.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 1,955: Line 2,001:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the list of enforcement actions taken by Health Canada for the Inspection Report Card posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,043: Line 2,089:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the list of corrective measures taken by Health Canada for the Inspection Report Card posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,131: Line 2,177:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the list of observations for the Inspection Report Card posted on the DHPID.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,291: Line 2,337:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the site/company dictionary. This information is migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,523: Line 2,569:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the site/company contact listing. This information is partially migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,707: Line 2,753:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the establishment licence dictionary. This information is migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Line 2,859: Line 2,905:  
[[MDCCD Data Warehouse|Return to Home Page.]]
 
[[MDCCD Data Warehouse|Return to Home Page.]]
   −
This table holds information that categorizes or "tags" an inspection.
+
This table holds the establishment licence activity dictionary. This information is migrated from MDS.
 
{| class="wikitable sortable mw-collapsible"
 
{| class="wikitable sortable mw-collapsible"
 
|+
 
|+
Jeff.tyndall
71

edits

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