MDCCD Data Warehouse Data Dictionary
Revision as of 15:33, 14 May 2024 by Jeff.tyndall (talk | contribs)
Overview
This page provides a data dictionary for each table that is held within the MDCCD Data Warehouse.
Medical Devices
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 | |
| INSP_NUM | VARCHAR2(200 CHAR) | No | NULL | 00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS | |
| OBS_ID | VARCHAR2(36 CHAR) | No | NULL | 07244e35-fbf1-ee11-a1fe-6045bd6005cc | |
| CAPA_TYPE | VARCHAR2(100 CHAR) | Yes | NULL | Follow Up Plan | |
| 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. | |
| CREATEDBYNAME | VARCHAR2(100 CHAR) | Yes | NULL | Jeff Tyndall | |
| CREATEDON | DATE | Yes | NULL | 22-08-26 | |
| MODIFIEDBYNAME | VARCHAR2(100 CHAR) | Yes | NULL | Jeff Tyndall | |
| MODIFIEDON | DATE | Yes | NULL | 22-08-26 |