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_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.