Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 16:09, 23 May 2024

752 bytes added , 23 May

no edit summary

Line 793: 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"

Line 897: 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"

Line 1,018: 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"

Line 1,131: Line 1,137:

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

Line 1,271: 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"

Line 1,366: 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"

Line 1,404: Line 1,416:

===MD_INS_CASE_WORKFLOW===

+

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

+

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

{| class="wikitable sortable"

Line 1,442: 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"

Line 1,480: 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"

Line 1,518: 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"

Line 1,556: 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"

Line 1,594: Line 1,616:

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

Line 1,632: Line 1,656:

=== MD_INS_INS_SITE===

+

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

+

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

{| class="wikitable sortable"

Line 1,670: 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"

Line 1,708: 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"

Line 1,746: 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"

Jeff.tyndall

71

edits