Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 14:37, 24 May 2024

242 bytes added , 24 May

no edit summary

Line 1,380: Line 1,380:

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

−

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

+

This table holds information about the observations for an inspection.

{| class="wikitable sortable mw-collapsible"

|+

Line 1,623: Line 1,623:

|}

−

===~~MD_INS_INS_SITELICENCEACTIVITY~~===

+

===MD_INS_INS_CASE_WORKFLOW===

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

−

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

+

This table holds information about the workflow of the inspection.

{| class="wikitable sortable mw-collapsible"

|+

Line 1,723: Line 1,723:

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

−

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

+

This table holds the Initial Inspection Deficiency information for an inspection that is posted on the DHPID.

{| class="wikitable sortable mw-collapsible"

|+

Line 1,851: Line 1,851:

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

−

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

+

This table holds a list of inspectors within the system.

{| class="wikitable sortable mw-collapsible"

|+

Line 1,955: Line 1,955:

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

−

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

+

This table holds the list of enforcement actions taken by Health Canada for the Inspection Report Card posted on the DHPID.

{| class="wikitable sortable mw-collapsible"

|+

Line 2,043: Line 2,043:

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

−

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

+

This table holds the list of corrective measures taken by Health Canada for the Inspection Report Card posted on the DHPID.

{| class="wikitable sortable mw-collapsible"

|+

Line 2,131: Line 2,131:

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

−

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

+

This table holds the list of observations for the Inspection Report Card posted on the DHPID.

{| class="wikitable sortable mw-collapsible"

|+

Line 2,291: Line 2,291:

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

−

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

+

This table holds the site/company dictionary. This information is migrated from MDS.

{| class="wikitable sortable mw-collapsible"

|+

Line 2,523: Line 2,523:

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

−

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

+

This table holds the site/company contact listing. This information is partially migrated from MDS.

{| class="wikitable sortable mw-collapsible"

|+

Line 2,707: Line 2,707:

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

−

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

+

This table holds the establishment licence dictionary. This information is migrated from MDS.

{| class="wikitable sortable mw-collapsible"

|+

Line 2,859: Line 2,859:

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

−

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

+

This table holds the establishment licence activity dictionary. This information is migrated from MDS.

{| class="wikitable sortable mw-collapsible"

|+

Jeff.tyndall

71

edits