wiki

Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 16:24, 23 May 2024

2,399 bytes added ,  23 May
no edit summary
Line 777: Line 777:  
|NULL
 
|NULL
 
|Vanessa Toussaint
 
|Vanessa Toussaint
−
|This identifies the resource that las modified the record.
+
|This identifies the resource that last modified the record.
 
|
 
|
 
|-
 
|-
Line 790: Line 790:  
|}
 
|}
   −
=== 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"
Line 826: Line 826:  
|No
 
|No
 
|NULL
 
|NULL
−
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS  
+
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 881: Line 881:  
|NULL
 
|NULL
 
|Jeff Tyndall
 
|Jeff Tyndall
−
|This identifies the resource that las modified the record.
+
|This identifies the resource that last modified the record.
 
|
 
|
 
|-
 
|-
Line 894: Line 894:  
|}
 
|}
   −
=== 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"
Line 926: Line 926:  
|Foreign
 
|Foreign
 
|No
 
|No
−
|00070-QUART HEALTHCARE INC.  
+
|00070-QUART HEALTHCARE INC.
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|-
 
|-
Line 989: Line 989:  
|Yes
 
|Yes
 
|Jeff Tyndall
 
|Jeff Tyndall
−
|This identifies the resource that las modified the record.
+
|This identifies the resource that last modified the record.
 
|-
 
|-
 
|MODIFIEDON
 
|MODIFIEDON
Line 999: Line 999:  
|}
 
|}
   −
=== MD_INS_CASE_ESTACTIVITY ===
+
===MD_INS_CASE_ESTACTIVITY===
 
This table holds information that categorizes or "tags" an inspection.
 
This table holds information that categorizes or "tags" an inspection.
 
{| class="wikitable"
 
{| class="wikitable"
Line 1,005: Line 1,005:  
!Column Name
 
!Column Name
 
!Data Type
 
!Data Type
−
!Key Type
+
! Key Type
 
!Nullable
 
!Nullable
 
!Example Data
 
!Example Data
Line 1,011: Line 1,011:  
!Comments
 
!Comments
 
|-
 
|-
 +
|INSP_ACTIVITY_ID
 +
|VARCHAR2(36 CHAR)
 +
|Primary
 +
|No
 
|
 
|
 +
|This is the unique record identifier for the establishment activity.
 
|
 
|
 +
|-
 +
|INSP_ID
 +
|VARCHAR2(36 CHAR)
 +
|Foreign
 +
|No
 
|
 
|
 +
|This is the unique record identifier for the parent inspection.
 +
|Use to join with MD_INS_CASE.INSP_ID.
 +
|-
 +
|INSP_NUM
 +
|VARCHAR2(200 CHAR)
 +
|Foreign
 +
|No
 
|
 
|
 +
|This is the parent inspection number.
 
|
 
|
 +
|-
 +
|ACTIVITY_ID
 +
|VARCHAR2(36 CHAR)
 +
|Foreign
 +
|No
 
|
 
|
 +
|This is the unique record identifier for the activity value.
 
|
 
|
 
|-
 
|-
 +
|ACTIVITY_NAME
 +
|VARCHAR2(205 CHAR)
 
|
 
|
 +
| Yes
 
|
 
|
 +
|This is the establishment activity.
 
|
 
|
 +
|-
 +
|ACTIVITY_DECODE_EN
 +
|VARCHAR2(100 CHAR)
 
|
 
|
 +
|Yes
 
|
 
|
−
|
+
|This is the name of the establishment activity in English.
 
|
 
|
 
|-
 
|-
 +
|ACTIVITY_DECODE_FR
 +
|VARCHAR2(100 CHAR)
 
|
 
|
 +
|Yes
 
|
 
|
 +
|This is the name of the establishment activity in French.
 
|
 
|
 +
|-
 +
|CREATEDBYNAME
 +
|VARCHAR2(100 CHAR)
 
|
 
|
 +
|Yes
 
|
 
|
−
|
+
|This identifies the resource that created the record.
−
|
   
|
 
|
 
|-
 
|-
 +
|CREATEDON
 +
|DATE
 
|
 
|
 +
|Yes
 
|
 
|
 +
|This identifies the date that record was created.
 
|
 
|
 +
|-
 +
|MODIFIEDBYNAME
 +
|VARCHAR2(100 CHAR)
 
|
 
|
 +
|Yes
 
|
 
|
−
|
+
| This identifies the resource that last modified the record.
 
|
 
|
 
|-
 
|-
 +
|MODIFIEDON
 +
|DATE
 
|
 
|
 +
|Yes
 
|
 
|
 +
|This identifies the date that record was last modified.
 
|
 
|
 +
|}
 +
 +
===MD_INS_CASE_INSPECTORS===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|BK_ID
 +
|VARCHAR2(36 CHAR)
 +
|No
 
|
 
|
 
|
 
|
−
|
+
|This is the unique record identifier for the inspector listing.
 
|
 
|
 
|-
 
|-
 +
|INSP_ID
 +
|VARCHAR2(36 CHAR)
 +
|No
 
|
 
|
 
|
 
|
 +
|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
 
|
 
|
 
|
 
|
−
|
+
|This is the parent inspection number.
−
|
   
|
 
|
 
|-
 
|-
 +
|INSPECTOR_NAME
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
 +
|This is the name of the inspector.
 
|
 
|
 +
|-
 +
|LEADINSPECTOR_EN
 +
|VARCHAR2(3 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
−
|
+
|This indicates if the inspector is the lead inspector on the inspection in English.
 
|
 
|
 
|-
 
|-
 +
|LEADINSPECTOR_FR
 +
|VARCHAR2(3 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
 +
|This indicates if the inspector is the lead inspector on the inspection in French.
 
|
 
|
 +
|-
 +
|ASSIGNSTATUS_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
 +
|**Not used by program.**
 +
|Contains default system information.
 +
|-
 +
|ASSIGNSTATUS_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
 +
|**Not used by program.**
 +
|Contains default system information.
 
|-
 
|-
 +
|STARTTIME
 +
|DATE
 +
|Yes
 
|
 
|
 
|
 
|
−
|
+
|**Not used by program.**
−
|
+
|Contains default system information.
−
|
  −
|
  −
|
   
|-
 
|-
 +
|ENDTIME
 +
|DATE
 +
|Yes
 
|
 
|
 
|
 
|
−
|
+
|**Not used by program.**
−
|
+
|Contains default system information.
−
|
  −
|
  −
|
   
|-
 
|-
 +
|CREATEDBYNAME
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
 +
|This identifies the resource that created the record.
 
|
 
|
−
|
  −
|
  −
|
  −
|}
  −
  −
=== MD_INS_CASE_INSPECTORS ===
  −
This table holds information that categorizes or "tags" an inspection.
  −
{| class="wikitable"
  −
|+
  −
!Column Name
  −
!Data Type
  −
!Key Type
  −
!Nullable
  −
!Example Data
  −
!Description
  −
!Comments
   
|-
 
|-
 +
|CREATEDON
 +
|DATE
 +
|Yes
 
|
 
|
 
|
 
|
−
|
+
|This identifies the date that record was created.
−
|
  −
|
  −
|
   
|
 
|
 
|-
 
|-
 +
|MODIFIEDBYNAME
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 
|
 
|
 
|
 
|
−
|
+
|This identifies the resource that last modified the record.
−
|
  −
|
  −
|
   
|
 
|
 
|-
 
|-
 +
|MODIFIEDON
 +
|DATE
 +
|Yes
 
|
 
|
 
|
 
|
−
|
+
|This identifies the date that record was last modified.
−
|
  −
|
  −
|
   
|
 
|
 
|}
 
|}
   −
=== MD_INS_CASE_NOTES ===
+
===MD_INS_CASE_NOTES===
 
This table holds information that categorizes or "tags" an inspection.
 
This table holds information that categorizes or "tags" an inspection.
 
{| class="wikitable"
 
{| class="wikitable"
Line 1,174: Line 1,262:  
|}
 
|}
   −
=== 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"
Line 1,184: Line 1,272:  
!Example Data
 
!Example Data
 
!Description
 
!Description
−
!Comments
+
! Comments
 
|-
 
|-
 
|
 
|
Line 1,211: Line 1,299:  
|}
 
|}
   −
=== 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"
 
|+
 
|+
−
!Column Name
+
! Column Name
 
!Data Type
 
!Data Type
 
!Key Type
 
!Key Type
Line 1,248: Line 1,336:  
|}
 
|}
   −
=== 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"
 
|+
 
|+
 
!Column Name
 
!Column Name
−
!Data Type
+
! Data Type
 
!Key Type
 
!Key Type
 
!Nullable
 
!Nullable
−
!Example Data
+
! Example Data
 
!Description
 
!Description
 
!Comments
 
!Comments
Line 1,285: Line 1,373:  
|}
 
|}
   −
=== 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"
Line 1,322: Line 1,410:  
|}
 
|}
   −
=== 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"
Line 1,331: Line 1,419:  
!Nullable
 
!Nullable
 
!Example Data
 
!Example Data
−
!Description
+
! Description
 
!Comments
 
!Comments
 
|-
 
|-
Line 1,359: Line 1,447:  
|}
 
|}
   −
=== 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"
Line 1,396: Line 1,484:  
|}
 
|}
   −
=== 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"
Line 1,433: Line 1,521:  
|}
 
|}
   −
=== 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"
Line 1,470: Line 1,558:  
|}
 
|}
   −
=== 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"
Line 1,507: Line 1,595:  
|}
 
|}
   −
=== 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"
Line 1,544: Line 1,632:  
|}
 
|}
   −
=== 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"
Jeff.tyndall
67

edits

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