Difference between revisions of "MDCCD Data Warehouse Data Dictionary"
Jump to navigation
Jump to search
Jeff.tyndall (talk | contribs) |
Jeff.tyndall (talk | contribs) |
||
| Line 29: | Line 29: | ||
|NULL | |NULL | ||
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48 | |3d7a309e-ce46-40c5-a6c2-f3ea80971d48 | ||
| − | | | + | |This is the unique record identifier for the parent inspection. |
|- | |- | ||
|INSP_NUM | |INSP_NUM | ||
| Line 36: | Line 36: | ||
|NULL | |NULL | ||
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS | |00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS | ||
| − | | | + | |This is the parent inspection number. |
|- | |- | ||
|OBS_ID | |OBS_ID | ||
| Line 43: | Line 43: | ||
|NULL | |NULL | ||
|07244e35-fbf1-ee11-a1fe-6045bd6005cc | |07244e35-fbf1-ee11-a1fe-6045bd6005cc | ||
| − | | | + | |This is the unique record identifier for the parent observation the CAPA is linked to. |
|- | |- | ||
|CAPA_TYPE | |CAPA_TYPE | ||
| Line 50: | Line 50: | ||
|NULL | |NULL | ||
|Follow Up Plan | |Follow Up Plan | ||
| − | | | + | |This is a free text field used to identify the type of CAPA. |
|- | |- | ||
|CAPA_PLAN | |CAPA_PLAN | ||
| Line 57: | Line 57: | ||
|NULL | |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. | |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 | |CREATEDBYNAME | ||
| Line 64: | Line 64: | ||
|NULL | |NULL | ||
|Jeff Tyndall | |Jeff Tyndall | ||
| − | | | + | |This identifies the resource that created the record. |
|- | |- | ||
|CREATEDON | |CREATEDON | ||
| Line 71: | Line 71: | ||
|NULL | |NULL | ||
|22-08-26 | |22-08-26 | ||
| − | | | + | |This identifies the date that record was created. |
|- | |- | ||
|MODIFIEDBYNAME | |MODIFIEDBYNAME | ||
| Line 78: | Line 78: | ||
|NULL | |NULL | ||
|Jeff Tyndall | |Jeff Tyndall | ||
| − | | | + | |This identifies the resource that las modified the record. |
|- | |- | ||
|MODIFIEDON | |MODIFIEDON | ||
| Line 85: | Line 85: | ||
|NULL | |NULL | ||
|22-08-26 | |22-08-26 | ||
| − | | | + | |This identifies the date that record was last modified. |
|} | |} | ||
Revision as of 13:53, 23 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
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. |
