Changes

Jump to navigation Jump to search

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 15:03, 23 May 2024

3,867 bytes added ,  23 May
→‎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