Difference between revisions of "MDCCD Data Warehouse Data Dictionary"
Jeff.tyndall (talk | contribs) |
Jeff.tyndall (talk | contribs) |
||
| Line 2: | Line 2: | ||
This page provides a data dictionary for each table that is held within the [[MDCCD Data Warehouse]]. | This page provides a data dictionary for each table that is held within the [[MDCCD Data Warehouse]]. | ||
| − | == Medical Devices | + | == Medical Devices == |
=== MD_INS_CASE_CAPA === | === MD_INS_CASE_CAPA === | ||
| Line 20: | Line 20: | ||
|NULL | |NULL | ||
|ad5e55f6-8b21-ee11-9966-000d3ae86452 | |ad5e55f6-8b21-ee11-9966-000d3ae86452 | ||
| − | | | + | |This is the unique record identifier for the CAPA. |
|- | |- | ||
|INSP_ID | |INSP_ID | ||
Revision as of 14:58, 14 May 2024
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 | February 13, 2024 The company is having the manufacturer of the rescue
kits provide labels. The manufacturer (Physio Control Inc) of the lifepakbatteries felt that they did not need to address the labelling as theywere under the understanding that as a replacement the battery fell underthe original kit.February 19, 2024 The inspector sent follow-up letter to addressPhysio-controls response--the manufacturer can have more than one ID onthe label as long as it clearly marks what the device identifier is andthat this identifier matches what is in the MDALL.March 6, 2024 The company sent follow-up from manufacturer. Themanufacturer has sent in a fax back to Health Canada to include the deviceID (11141-000165) under their license. This adequately addresses theobservation |
|
| 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 |
