Difference between revisions of "MDCCD Data Warehouse Data Dictionary"
Jeff.tyndall (talk | contribs) |
Jeff.tyndall (talk | contribs) |
||
| Line 14: | Line 14: | ||
!Description | !Description | ||
|- | |- | ||
| + | |CAPA_ID | ||
| + | |VARCHAR2(36 CHAR) | ||
| + | |No | ||
| + | |NULL | ||
| + | |ad5e55f6-8b21-ee11-9966-000d3ae86452 | ||
| | | | ||
| + | |- | ||
| + | |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 |
| | | | ||
|} | |} | ||
Revision as of 14:55, 14 May 2024
Overview
This page provides a data dictionary for each table that is held within the MDCCD Data Warehouse.
Medical DevicesEdit source
MD_INS_CASE_CAPA
| Column Name | Data Type | Nullable | Data Default | Example Data | Description |
|---|---|---|---|---|---|
| CAPA_ID | VARCHAR2(36 CHAR) | No | NULL | ad5e55f6-8b21-ee11-9966-000d3ae86452 | |
| 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 |
