Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!

Changes

Jump to navigation Jump to search

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 16:03, 23 May 2024

3,867 bytes added ,  16:03, 23 May 2024
→‎MD_INS_CASE_DESIGNATION
Line 895: Line 895:     
=== MD_INS_CASE_DESIGNATION ===
 
=== MD_INS_CASE_DESIGNATION ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
   −
=== MD_CASE_ESTACTIVITY ===
+
=== MD_INS_CASE_ESTACTIVITY ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== 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
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_CASE_NOTES ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_CASE_OBSERVATIONS ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_CASE_WORKFLOW ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_IID ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_INSPECTORLIST ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_IRC_ENFORCEMENT ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_IRC_MEASURES ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_IRC_OBSERVATIONS ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_SITE ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_SITE_CONTACT ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_LICENCE ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
 +
 
 +
=== MD_INS_INS_SITELICENCEACTIVITY ===
 +
This table holds information that categorizes or "tags" an inspection.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!Data Type
 +
!Key Type
 +
!Nullable
 +
!Example Data
 +
!Description
 +
!Comments
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|-
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|
 +
|}
Jeff.tyndall
71

edits

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

Navigation menu

GCwiki