Changes

MDCCD Data Warehouse (view source)

343 bytes added , 14 May

Line 63: Line 63:

** ''Medical Device Inspection Database (MDID)''

*** This system holds Medical Device Inspection records.

+

== Schemas ==

+

The MDCCD Data Warehouse contains two database schemas:

+

* MDCCD_DM_OWNER

+

** Holds all tables and views used for reporting & analysis.

+

* MDCCD_STG_OWNER

+

** Holds all tables used for staging as part of the ETL process to populate tables held in the MDCCD_DM_OWNER schema.

== Tables ==

+

'''Table Naming Convention'''

+

Tables are named using a

== Contacts ==

71

edits