MDCCD Data Warehouse Data Dictionary

Overview

This page provides a data dictionary for each table that is held within the MDCCD Data Warehouse.

Medical Devices

MD_INS_CASE

MD_INS_CASE_CAPA

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

Column Name Data Type Nullable Data Default Example Data Description
CAPA_ID VARCHAR2(36 CHAR) No NULL ad5e55f6-8b21-ee11-9966-000d3ae86452 This is the unique record identifier for the CAPA.
INSP_ID VARCHAR2(36 CHAR) No NULL 3d7a309e-ce46-40c5-a6c2-f3ea80971d48 This is the unique record identifier for the parent inspection.
INSP_NUM VARCHAR2(200 CHAR) No NULL 00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS This is the parent inspection number.
OBS_ID VARCHAR2(36 CHAR) No NULL 07244e35-fbf1-ee11-a1fe-6045bd6005cc This is the unique record identifier for the parent observation the CAPA is linked to.
CAPA_TYPE VARCHAR2(100 CHAR) Yes NULL Follow Up Plan This is a free text field used to identify the type of CAPA.
CAPA_PLAN VARCHAR2(2000 CHAR) Yes NULL The inspector sent follow-up letter to address Physio-controls response--the manufacturer can have more than one ID on the label as long as it clearly marks what the device identifier is and that this identifier matches what is in the MDALL. March 6, 2024 The company sent follow-up from manufacturer.  The manufacturer has sent in a fax back to Health Canada to include the device ID (11141-000165) under their license. This adequately addresses the observation. This is the CAPA as inputted by the inspector.
CREATEDBYNAME VARCHAR2(100 CHAR) Yes NULL Jeff Tyndall This identifies the resource that created the record.
CREATEDON DATE Yes NULL 22-08-26 This identifies the date that record was created.
MODIFIEDBYNAME VARCHAR2(100 CHAR) Yes NULL Jeff Tyndall This identifies the resource that las modified the record.
MODIFIEDON DATE Yes NULL 22-08-26 This identifies the date that record was last modified.

MD_INS_CASE_DESIGNATION

MD_CASE_ESTACTIVITY