Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 17:12, 23 May 2024

255 bytes added , 23 May

no edit summary

Line 8: Line 8:

This table holds the main inspection information.

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 796: Line 796:

This table holds information about the corrective action plan for an inspection observation.

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 902: Line 902:

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"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,025: Line 1,025:

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"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,140: Line 1,140:

This table holds a listing of inspectors assigned to an inspection.

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,282: Line 1,282:

This table holds notes related to the inspection.

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,379: Line 1,379:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,419: Line 1,419:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,459: Line 1,459:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,499: Line 1,499:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,539: Line 1,539:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,579: Line 1,579:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,619: Line 1,619:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,659: Line 1,659:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,699: Line 1,699:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,739: Line 1,739:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Line 1,779: Line 1,779:

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

−

{| class="wikitable sortable"

+

{| class="wikitable sortable mw-collapsible"

|+

! scope="col" style="width: 350px;" | Column Name

Jeff.tyndall

67

edits