67
edits
Changes
no edit summary
This section outlines the IT systems that have their data included in the Data Warehouse.
This section outlines the IT systems that have their data included in the Data Warehouse.
'''Systems Included by Program'''
=== '''Medical Device Compliance Program''' ===
===== ''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 ==
== Tables ==
=== '''Table Naming Convention''' ===
Tables are named using a
== Contacts ==
== Contacts ==