<html class="client-nojs" lang="en-GB" dir="ltr">
<head>
<meta charset="UTF-8"/>
<title>Discovery Data Service Compass v1.2.1 Database Dump</title>
<script>document.documentElement.className="client-js";RLCONF={"wgCanonicalNamespace":"","wgCanonicalSpecialPageName":!1,"wgNamespaceNumber":0,"wgPageName":"Remote_Subscriber_Database_(RSD)_Schema_(Compass_2)","wgTitle":"Remote Subscriber Database (RSD) Schema (Compass 2)","wgCurRevisionId":4947,"wgRevisionId":4947,"wgArticleId":212,"wgIsArticle":!0,"wgIsRedirect":!1,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":[],"wgBreakFrames":!1,"wgPageContentLanguage":"en-gb","wgPageContentModel":"wikitext","wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgMonthNamesShort":["","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"],"wgRelevantPageName":"Remote_Subscriber_Database_(RSD)_Schema_(Compass_2)","wgRelevantArticleId":212,"wgRequestId":"3ac15e2d918841776f5009c5",
"wgCSPNonce":!1,"wgIsProbablyEditable":!1,"wgRelevantPageIsProbablyEditable":!1,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgPopupsReferencePreviews":!0,"wgPopupsConflictsWithNavPopupGadget":!1,"wgVisualEditor":{"pageLanguageCode":"en-GB","pageLanguageDir":"ltr","pageVariantFallbacks":"en-gb"},"wgEditSubmitButtonLabelPublish":!1};RLSTATE={"site.styles":"ready","noscript":"ready","user.styles":"ready","user":"ready","user.options":"loading","user.tokens":"loading","mediawiki.legacy.shared":"ready","mediawiki.legacy.commonPrint":"ready","jquery.tablesorter.styles":"ready","jquery.makeCollapsible.styles":"ready","mediawiki.toc.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","mediawiki.skinning.interface":"ready","skins.vector.styles":"ready"};RLPAGEMODULES=["site","mediawiki.page.startup","mediawiki.page.ready","jquery.tablesorter","jquery.makeCollapsible","mediawiki.toc","mediawiki.searchSuggest","ext.SimpleTooltip","ext.popups",
"ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","skins.vector.js"];</script>
<script>(RLQ=window.RLQ||[]).push(function(){mw.loader.implement("user.options@qpjou",function($,jQuery,require,module){/*@nomin*/mw.user.options.set({"variant":"en-gb"});
});mw.loader.implement("user.tokens@tffin",function($,jQuery,require,module){/*@nomin*/mw.user.tokens.set({"editToken":"+\\","patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"});
});});</script>
<link rel="stylesheet" href="/load.php?lang=en-gb&modules=ext.visualEditor.desktopArticleTarget.noscript%7Cjquery.makeCollapsible.styles%7Cjquery.tablesorter.styles%7Cmediawiki.legacy.commonPrint%2Cshared%7Cmediawiki.skinning.interface%7Cmediawiki.toc.styles%7Cskins.vector.styles&only=styles&skin=vector"/>
<script async="" src="/load.php?lang=en-gb&modules=startup&only=scripts&raw=1&skin=vector"></script>
<meta name="ResourceLoaderDynamicStyles" content=""/>
<link rel="stylesheet" href="/load.php?lang=en-gb&modules=site.styles&only=styles&skin=vector"/>
<meta name="generator" content="MediaWiki 1.34.1"/>
<link rel="shortcut icon" href="/favicon.ico"/>
<link rel="search" type="application/opensearchdescription+xml" href="/opensearch_desc.php" title="Discovery Data Service (en-gb)"/>
<link rel="EditURI" type="application/rsd+xml" href="https://wiki.discoverydataservice.org/api.php?action=rsd"/>
<link rel="alternate" type="application/atom+xml" title="Discovery Data Service Atom feed" href="/index.php?title=Special:RecentChanges&feed=atom"/>
</head>
<body class="mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-Remote_Subscriber_Database_RSD_Schema_Compass_2 rootpage-Remote_Subscriber_Database_RSD_Schema_Compass_2 skin-vector action-view">
<a id="top"></a>
Remote Subscriber Database (RSD) Schema (Compass 2) Version: v1.2.1
From Discovery Data Service
Allergy_intolerance
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the allergy', |
id bigint NOT NULL COMMENT 'Unique Id of the allergy', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the allergy', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the allergy', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter this allergy was record in', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter this allergy was record in', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age the patient was at the time of this event', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age the patient was at the time of this event', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the allergy', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the allergy', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| date_recorded |
datetime |
NOT NULL |
COMMENT 'The date the allergy was recorded', |
date_recorded datetime NOT NULL COMMENT 'The date the allergy was recorded', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the clinical code is recorded for', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the clinical code is recorded for', |
| is_review |
tinyint(1) |
NOT NULL |
COMMENT 'Is this instance of the code a review of a previous encounter', |
is_review tinyint(1) NOT NULL COMMENT 'Is this instance of the code a review of a previous encounter', |
Appointment
<tbody>
</tbody>
| patient_wait |
int |
DEFAULT NULL |
COMMENT 'How long the patient waited from being marked as arrived to being sent in', |
patient_wait int DEFAULT NULL COMMENT 'How long the patient waited from being marked as arrived to being sent in', |
| schedule_id |
bigint |
DEFAULT NULL |
COMMENT 'The schedule the patient was put on to book multiple appointments. ID unique to the applied schedule', |
schedule_id bigint DEFAULT NULL COMMENT 'The schedule the patient was put on to book multiple appointments. ID unique to the applied schedule', |
| appointment_status_concept_id |
int |
DEFAULT NULL |
COMMENT 'The status of the appointment e.g. arrived/sent in/left/DNA', |
appointment_status_concept_id int DEFAULT NULL COMMENT 'The status of the appointment e.g. arrived/sent in/left/DNA', |
| date_time_sent_in |
datetime |
DEFAULT NULL |
COMMENT 'Date and time the patient was sent into the practitioner', |
date_time_sent_in datetime DEFAULT NULL COMMENT 'Date and time the patient was sent into the practitioner', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| date_time_left |
datetime |
DEFAULT NULL |
COMMENT 'Date and time the patient left the practitioner', |
date_time_left datetime DEFAULT NULL COMMENT 'Date and time the patient left the practitioner', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the appointment', |
id bigint NOT NULL COMMENT 'Unique Id of the appointment', |
| start_date |
date |
DEFAULT NULL |
COMMENT 'The start date of the appointment', |
start_date date DEFAULT NULL COMMENT 'The start date of the appointment', |
| patient_delay |
int |
DEFAULT NULL |
COMMENT 'How long the patient was delayed for', |
patient_delay int DEFAULT NULL COMMENT 'How long the patient was delayed for', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| source_id |
varchar(36) |
DEFAULT NULL |
COMMENT 'Unique reference to the source of the appointment', |
source_id varchar(36) DEFAULT NULL COMMENT 'Unique reference to the source of the appointment', |
| planned_duration |
int |
DEFAULT NULL |
COMMENT 'The time allocated for the appointment, not necessarily the actual duration always in minutes', |
planned_duration int DEFAULT NULL COMMENT 'The time allocated for the appointment, not necessarily the actual duration always in minutes', |
| actual_duration |
int |
DEFAULT NULL |
COMMENT 'Time between sent in and left always in minutes', |
actual_duration int DEFAULT NULL COMMENT 'Time between sent in and left always in minutes', |
| cancelled_date |
datetime |
DEFAULT NULL |
COMMENT 'The date the appointment was cancelled', |
cancelled_date datetime DEFAULT NULL COMMENT 'The date the appointment was cancelled', |
Appointment_additional
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'same as the id column on the patient table ', |
id bigint NOT NULL COMMENT 'same as the id column on the patient table ', |
| json_value |
json |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id, just raw JSON', |
json_value json DEFAULT NULL COMMENT 'where there is no mapped value_id, just raw JSON', |
| text_value |
varchar(255) |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id or raw JSON, just a basic text value (i.e. GP Practitioner number)', |
text_value varchar(255) DEFAULT NULL COMMENT 'where there is no mapped value_id or raw JSON, just a basic text value (i.e. GP Practitioner number)', |
| property_id |
int |
NOT NULL |
COMMENT 'IM reference (e.g. appointment type)', |
property_id int NOT NULL COMMENT 'IM reference (e.g. appointment type)', |
| value_id |
int |
DEFAULT NULL |
COMMENT 'IM reference (e.g. Appointment Type)', |
value_id int DEFAULT NULL COMMENT 'IM reference (e.g. Appointment Type)', |
Concept
<tbody>
</tbody>
| Name |
varchar(255) |
DEFAULT NULL |
COMMENT 'Short name', |
Name varchar(255) DEFAULT NULL COMMENT 'Short name', |
| updated |
datetime |
NOT NULL |
COMMENT 'The timestamp of the last update to the concept', |
updated datetime NOT NULL COMMENT 'The timestamp of the last update to the concept', |
| Draft |
tinyint(1) |
NOT NULL |
COMMENT 'Whether its draft/autocreated or confirmed as a "proper" concept', |
Draft tinyint(1) NOT NULL COMMENT 'Whether its draft/autocreated or confirmed as a "proper" concept', |
| Description |
varchar(400) |
DEFAULT NULL |
COMMENT 'Full name (or term for ontological concepts)', |
Description varchar(400) DEFAULT NULL COMMENT 'Full name (or term for ontological concepts)', |
| dbid |
int |
NOT NULL |
COMMENT 'Unique Id of the concept', |
dbid int NOT NULL COMMENT 'Unique Id of the concept', |
| Document |
int |
NOT NULL |
COMMENT 'Concept grouping construct, deprecated', |
Document int NOT NULL COMMENT 'Concept grouping construct, deprecated', |
| Id |
varchar(150) |
NOT NULL |
COMMENT 'Unique concept identifier', |
Id varchar(150) NOT NULL COMMENT 'Unique concept identifier', |
| Scheme |
bigint |
DEFAULT NULL |
COMMENT 'The coding scheme for the code (Read, CTV3, SNOMED etc)', |
Scheme bigint DEFAULT NULL COMMENT 'The coding scheme for the code (Read, CTV3, SNOMED etc)', |
| Code |
varchar(40) |
DEFAULT NULL |
COMMENT 'The code (non-unique unless coupled with a scheme)', |
Code varchar(40) DEFAULT NULL COMMENT 'The code (non-unique unless coupled with a scheme)', |
Concept_map
<tbody>
</tbody>
| updated |
datetime |
NOT NULL |
COMMENT 'Timestamp the map was last updated/added', |
updated datetime NOT NULL COMMENT 'Timestamp the map was last updated/added', |
| core |
int |
NOT NULL |
COMMENT 'the core (snomed, discovery) concept that the legacy concept maps to', |
core int NOT NULL COMMENT 'the core (snomed, discovery) concept that the legacy concept maps to', |
| legacy |
int |
NOT NULL |
COMMENT 'the legacy (read 2, ctv3, icd10, opcs4, emis local, etc) concept', |
legacy int NOT NULL COMMENT 'the legacy (read 2, ctv3, icd10, opcs4, emis local, etc) concept', |
Diagnostic_order
<tbody>
</tbody>
| is_problem |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the observation is marked as a problem', |
is_problem tinyint(1) NOT NULL COMMENT 'Whether the observation is marked as a problem', |
| result_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the result', |
result_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the result', |
| problem_end_date |
date |
DEFAULT NULL |
COMMENT 'The end date of the problem', |
problem_end_date date DEFAULT NULL COMMENT 'The end date of the problem', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| episodicity_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the episodicity of the problem eg First, review, flare', |
episodicity_concept_id int DEFAULT NULL COMMENT 'Reference to the episodicity of the problem eg First, review, flare', |
| result_date |
date |
DEFAULT NULL |
COMMENT 'The date of the result', |
result_date date DEFAULT NULL COMMENT 'The date of the result', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the observation', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the observation', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| result_value_units |
varchar(50) |
DEFAULT NULL |
COMMENT 'The units of the result of the observation', |
result_value_units varchar(50) DEFAULT NULL COMMENT 'The units of the result of the observation', |
| is_primary |
tinyint(1) |
DEFAULT NULL |
COMMENT 'Whether the diagnostic order is a primary order', |
is_primary tinyint(1) DEFAULT NULL COMMENT 'Whether the diagnostic order is a primary order', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the diagnostic order was identified by a clinician', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the diagnostic order was identified by a clinician', |
| is_review |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the observation is a review of an existing problem', |
is_review tinyint(1) NOT NULL COMMENT 'Whether the observation is a review of an existing problem', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter the observation was recorded at', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter the observation was recorded at', |
| result_value |
double |
DEFAULT NULL |
COMMENT 'The value of the result of the observation', |
result_value double DEFAULT NULL COMMENT 'The value of the result of the observation', |
| parent_observation_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the parent observation in a complex observation eg systolic and diastolic blood pressures will have a parent observation of Blood pressure', |
parent_observation_id bigint DEFAULT NULL COMMENT 'Reference to the parent observation in a complex observation eg systolic and diastolic blood pressures will have a parent observation of Blood pressure', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the diagnostic order', |
id bigint NOT NULL COMMENT 'Unique Id of the diagnostic order', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the observation', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the observation', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age of the patient at the time of the observation', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age of the patient at the time of the observation', |
Encounter
<tbody>
</tbody>
| end_date |
date |
DEFAULT NULL |
COMMENT 'The end date of the encounter', |
end_date date DEFAULT NULL COMMENT 'The end date of the encounter', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the type of encounter', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the type of encounter', |
| appointment_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the appointment this encounter took part on', |
appointment_id bigint DEFAULT NULL COMMENT 'Reference to the appointment this encounter took part on', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age the patient was when this encounter took place', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age the patient was when this encounter took place', |
| date_recorded |
datetime |
DEFAULT NULL |
COMMENT 'The date the encounter was recorded', |
date_recorded datetime DEFAULT NULL COMMENT 'The date the encounter was recorded', |
| admission_method |
varchar(40) |
DEFAULT NULL |
COMMENT 'The admission method of the encounter', |
admission_method varchar(40) DEFAULT NULL COMMENT 'The admission method of the encounter', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the encounter', |
id bigint NOT NULL COMMENT 'Unique Id of the encounter', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| service_provider_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the service provider organisation', |
service_provider_organization_id bigint DEFAULT NULL COMMENT 'Reference to the service provider organisation', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the type of encounter', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the type of encounter', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the clinical code is recorded for', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the clinical code is recorded for', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the precision of the date of the encounter', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Reference to the precision of the date of the encounter', |
| episode_of_care_id |
bigint |
DEFAULT NULL |
COMMENT 'Is this instance of the code a review of a previous encounter', |
episode_of_care_id bigint DEFAULT NULL COMMENT 'Is this instance of the code a review of a previous encounter', |
Encounter_additional
<tbody>
</tbody>
| value_id |
int |
DEFAULT NULL |
COMMENT 'IM concept id reference (i.e. Emergency admission)', |
value_id int DEFAULT NULL COMMENT 'IM concept id reference (i.e. Emergency admission)', |
| json_value |
json |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id, just raw JSON (i.e. birth delivery details)', |
json_value json DEFAULT NULL COMMENT 'where there is no mapped value_id, just raw JSON (i.e. birth delivery details)', |
| property_id |
int |
NOT NULL |
COMMENT 'IM concept id reference (i.e. Admission method)', |
property_id int NOT NULL COMMENT 'IM concept id reference (i.e. Admission method)', |
| text_value |
varchar(255) |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id, or raw JSON, just a basic text value (i.e. FIN number)', |
text_value varchar(255) DEFAULT NULL COMMENT 'where there is no mapped value_id, or raw JSON, just a basic text value (i.e. FIN number)', |
| id |
bigint |
NOT NULL |
COMMENT 'same as the id column on the encounter table', |
id bigint NOT NULL COMMENT 'same as the id column on the encounter table', |
Encounter_event
<tbody>
</tbody>
| end_date |
date |
DEFAULT NULL |
COMMENT 'The end date of the encounter', |
end_date date DEFAULT NULL COMMENT 'The end date of the encounter', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age of the patient at the time of the encounter', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age of the patient at the time of the encounter', |
| encounter_id |
bigint |
NOT NULL |
COMMENT 'Reference to the parent encounter record', |
encounter_id bigint NOT NULL COMMENT 'Reference to the parent encounter record', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the type of encounter', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the type of encounter', |
| clinical_effective_date |
datetime |
DEFAULT NULL |
COMMENT 'The date the encounter took place', |
clinical_effective_date datetime DEFAULT NULL COMMENT 'The date the encounter took place', |
| appointment_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the appointment this encounter took part on', |
appointment_id bigint DEFAULT NULL COMMENT 'Reference to the appointment this encounter took part on', |
| person_id |
bigint |
NOT NULL |
COMMENT 'The person this event belongs to', |
person_id bigint NOT NULL COMMENT 'The person this event belongs to', |
| date_recorded |
datetime |
DEFAULT NULL |
COMMENT 'The date the encounter was recorded', |
date_recorded datetime DEFAULT NULL COMMENT 'The date the encounter was recorded', |
| admission_method |
varchar(40) |
DEFAULT NULL |
COMMENT 'The admission method of the encounter', |
admission_method varchar(40) DEFAULT NULL COMMENT 'The admission method of the encounter', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| service_provider_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the service provider organisation', |
service_provider_organization_id bigint DEFAULT NULL COMMENT 'Reference to the service provider organisation', |
| finished |
tinyint(1) |
DEFAULT NULL |
COMMENT 'Whether the encounter is finished', |
finished tinyint(1) DEFAULT NULL COMMENT 'Whether the encounter is finished', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the encounter event', |
id bigint NOT NULL COMMENT 'Unique Id of the encounter event', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the type of encounter', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the type of encounter', |
| institution_location_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the institution the encounter took place at', |
institution_location_id bigint DEFAULT NULL COMMENT 'Reference to the institution the encounter took place at', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The patient this event belongs to', |
patient_id bigint NOT NULL COMMENT 'The patient this event belongs to', |
| episode_of_care_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the episode of care this encounter belongs to', |
episode_of_care_id bigint DEFAULT NULL COMMENT 'Reference to the episode of care this encounter belongs to', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the precision of the date of the encounter', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Reference to the precision of the date of the encounter', |
Episode_of_care
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the episode of care', |
id bigint NOT NULL COMMENT 'Unique Id of the episode of care', |
| registration_status_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the registration status of the patient', |
registration_status_concept_id int DEFAULT NULL COMMENT 'Reference to the registration status of the patient', |
| date_registered |
date |
DEFAULT NULL |
COMMENT 'The date the registration was started for this episode of care', |
date_registered date DEFAULT NULL COMMENT 'The date the registration was started for this episode of care', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| usual_gp_practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the usual GP for this episode of care', |
usual_gp_practitioner_id bigint DEFAULT NULL COMMENT 'Reference to the usual GP for this episode of care', |
| date_registered_end |
date |
DEFAULT NULL |
COMMENT 'The date the registration was ended for this episode of care', |
date_registered_end date DEFAULT NULL COMMENT 'The date the registration was ended for this episode of care', |
| registration_type_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the registration type of the patient', |
registration_type_concept_id int DEFAULT NULL COMMENT 'Reference to the registration type of the patient', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
Event_log
<tbody>
</tbody>
| dt_change |
datetime(3) |
NOT NULL |
COMMENT 'date time the change was made to this DB', |
dt_change datetime(3) NOT NULL COMMENT 'date time the change was made to this DB', |
| change_type |
tinyint |
NOT NULL |
COMMENT 'type of transaction 0=insert, 1=update, 2=delete', |
change_type tinyint NOT NULL COMMENT 'type of transaction 0=insert, 1=update, 2=delete', |
| table_id |
tinyint |
NOT NULL |
COMMENT 'identifier of the table changed', |
table_id tinyint NOT NULL COMMENT 'identifier of the table changed', |
| record_id |
bigint |
NOT NULL |
COMMENT 'id of the record changed' |
record_id bigint NOT NULL COMMENT 'id of the record changed' |
Flag
<tbody>
</tbody>
| effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the flag was entered onto the patients record', |
effective_date date DEFAULT NULL COMMENT 'The date the flag was entered onto the patients record', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| is_active |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the flag is active or not', |
is_active tinyint(1) NOT NULL COMMENT 'Whether the flag is active or not', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the flag', |
id bigint NOT NULL COMMENT 'Unique Id of the flag', |
Location
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the location', |
id bigint NOT NULL COMMENT 'Unique Id of the location', |
| type_code |
varchar(50) |
DEFAULT NULL |
COMMENT 'The type of location', |
type_code varchar(50) DEFAULT NULL COMMENT 'The type of location', |
| name |
varchar(255) |
DEFAULT NULL |
COMMENT 'The name of a location set by the publisher. E.g. ward, clinic, domiciliary', |
name varchar(255) DEFAULT NULL COMMENT 'The name of a location set by the publisher. E.g. ward, clinic, domiciliary', |
| type_desc |
varchar(255) |
DEFAULT NULL |
COMMENT 'Textual description of the type of location eg GP Practice', |
type_desc varchar(255) DEFAULT NULL COMMENT 'Textual description of the type of location eg GP Practice', |
| postcode |
varchar(10) |
DEFAULT NULL |
COMMENT 'The postcode of the location', |
postcode varchar(10) DEFAULT NULL COMMENT 'The postcode of the location', |
| managing_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the managing organisation of the location', |
managing_organization_id bigint DEFAULT NULL COMMENT 'Reference to the managing organisation of the location', |
Medication_order
<tbody>
</tbody>
| medication_statement_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the medication statement. A medication statement can have many medication orders', |
medication_statement_id bigint DEFAULT NULL COMMENT 'Reference to the medication statement. A medication statement can have many medication orders', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the medication', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the medication', |
| quantity_unit |
varchar(255) |
DEFAULT NULL |
COMMENT 'The unit of the medication that was prescribed eg tablets', |
quantity_unit varchar(255) DEFAULT NULL COMMENT 'The unit of the medication that was prescribed eg tablets', |
| duration_days |
int |
DEFAULT NULL |
COMMENT 'How many days the medication is prescribed for', |
duration_days int DEFAULT NULL COMMENT 'How many days the medication is prescribed for', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age the patient was at the time of this event', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age the patient was at the time of this event', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter the medication order was issued in', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter the medication order was issued in', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| quantity_value |
double |
DEFAULT NULL |
COMMENT 'The value of the medication that was prescribed eg 50', |
quantity_value double DEFAULT NULL COMMENT 'The value of the medication that was prescribed eg 50', |
| estimated_cost |
double |
DEFAULT NULL |
COMMENT 'The estimated cost of the medication', |
estimated_cost double DEFAULT NULL COMMENT 'The estimated cost of the medication', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the medication order was issued', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the medication order was issued', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| dose |
varchar(1000) |
DEFAULT NULL |
COMMENT 'Textual description of the dose', |
dose varchar(1000) DEFAULT NULL COMMENT 'Textual description of the dose', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the medication order', |
id bigint NOT NULL COMMENT 'Unique Id of the medication order', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the medication', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the medication', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| bnf_reference |
varchar(6) |
DEFAULT NULL |
COMMENT 'A reference to the drug in the BNF dictionary', |
bnf_reference varchar(6) DEFAULT NULL COMMENT 'A reference to the drug in the BNF dictionary', |
Medication_statement
<tbody>
</tbody>
| cancellation_date |
date |
DEFAULT NULL |
COMMENT 'The date the medication was cancelled', |
cancellation_date date DEFAULT NULL COMMENT 'The date the medication was cancelled', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the medication', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the medication', |
| quantity_unit |
varchar(255) |
DEFAULT NULL |
COMMENT 'The unit of the medication that was prescribed eg tablets', |
quantity_unit varchar(255) DEFAULT NULL COMMENT 'The unit of the medication that was prescribed eg tablets', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age the patient was at the time of this event', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age the patient was at the time of this event', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter this medication was recorded in', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter this medication was recorded in', |
| quantity_value |
double |
DEFAULT NULL |
COMMENT 'The value of the medication that was prescribed eg 50', |
quantity_value double DEFAULT NULL COMMENT 'The value of the medication that was prescribed eg 50', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the medication', |
id bigint NOT NULL COMMENT 'Unique Id of the medication', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the medication was clinical relevant', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the medication was clinical relevant', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| dose |
varchar(1000) |
DEFAULT NULL |
COMMENT 'Texual description of the dose of the medication', |
dose varchar(1000) DEFAULT NULL COMMENT 'Texual description of the dose of the medication', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the medication', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the medication', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| authorisation_type_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the authorisation type', |
authorisation_type_concept_id int DEFAULT NULL COMMENT 'Reference to the authorisation type', |
| is_active |
tinyint(1) |
DEFAULT NULL |
COMMENT 'Whether the medication is active or not', |
is_active tinyint(1) DEFAULT NULL COMMENT 'Whether the medication is active or not', |
| bnf_reference |
varchar(6) |
DEFAULT NULL |
COMMENT 'A reference to the drug in the BNF dictionary', |
bnf_reference varchar(6) DEFAULT NULL COMMENT 'A reference to the drug in the BNF dictionary', |
Observation
<tbody>
</tbody>
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the observation was identified by a clinician', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the observation was identified by a clinician', |
| is_problem |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the observation is marked as a problem', |
is_problem tinyint(1) NOT NULL COMMENT 'Whether the observation is marked as a problem', |
| result_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the result', |
result_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the result', |
| problem_end_date |
date |
DEFAULT NULL |
COMMENT 'The end date of the problem', |
problem_end_date date DEFAULT NULL COMMENT 'The end date of the problem', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the observation', |
id bigint NOT NULL COMMENT 'Unique Id of the observation', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| episodicity_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the episodicity of the problem eg First, review, flare', |
episodicity_concept_id int DEFAULT NULL COMMENT 'Reference to the episodicity of the problem eg First, review, flare', |
| is_primary |
tinyint(1) |
DEFAULT NULL |
COMMENT 'Whether the observation is a primary observation', |
is_primary tinyint(1) DEFAULT NULL COMMENT 'Whether the observation is a primary observation', |
| date_recorded |
datetime |
DEFAULT NULL |
COMMENT 'The date the observation was recorded in the system', |
date_recorded datetime DEFAULT NULL COMMENT 'The date the observation was recorded in the system', |
| result_date |
date |
DEFAULT NULL |
COMMENT 'The date of the result', |
result_date date DEFAULT NULL COMMENT 'The date of the result', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the observation', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the observation', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| result_value_units |
varchar(50) |
DEFAULT NULL |
COMMENT 'The units of the result of the observation', |
result_value_units varchar(50) DEFAULT NULL COMMENT 'The units of the result of the observation', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| is_review |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the observation is a review of an existing problem', |
is_review tinyint(1) NOT NULL COMMENT 'Whether the observation is a review of an existing problem', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter the observation was recorded at', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter the observation was recorded at', |
| result_value |
double |
DEFAULT NULL |
COMMENT 'The value of the result of the observation', |
result_value double DEFAULT NULL COMMENT 'The value of the result of the observation', |
| parent_observation_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the parent observation in a complex observation eg systolic and diastolic blood pressures will have a parent observation of Blood pressure', |
parent_observation_id bigint DEFAULT NULL COMMENT 'Reference to the parent observation in a complex observation eg systolic and diastolic blood pressures will have a parent observation of Blood pressure', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the observation', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the observation', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age of the patient at the time of the observation', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age of the patient at the time of the observation', |
Observation_additional
<tbody>
</tbody>
| value_id |
int |
DEFAULT NULL |
COMMENT 'IM reference (i.e. minor, significant)', |
value_id int DEFAULT NULL COMMENT 'IM reference (i.e. minor, significant)', |
| json_value |
json |
DEFAULT NULL |
COMMENT 'the JSON data itself ', |
json_value json DEFAULT NULL COMMENT 'the JSON data itself ', |
| id |
bigint |
NOT NULL |
COMMENT 'same as the id column on the observation table', |
id bigint NOT NULL COMMENT 'same as the id column on the observation table', |
| property_id |
int |
NOT NULL |
COMMENT 'IM reference (i.e. significance)', |
property_id int NOT NULL COMMENT 'IM reference (i.e. significance)', |
| text_value |
varchar(255) |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id or raw JSON, just a basic text value', |
text_value varchar(255) DEFAULT NULL COMMENT 'where there is no mapped value_id or raw JSON, just a basic text value', |
Organization
<tbody>
</tbody>
| type_desc |
varchar(255) |
DEFAULT NULL |
COMMENT 'Textual description of the type of organisation eg GP Practice', |
type_desc varchar(255) DEFAULT NULL COMMENT 'Textual description of the type of organisation eg GP Practice', |
| Postcode |
varchar(10) |
DEFAULT NULL |
COMMENT 'The postcode of the organisation', |
Postcode varchar(10) DEFAULT NULL COMMENT 'The postcode of the organisation', |
| ods_code |
varchar(50) |
DEFAULT NULL |
COMMENT 'ODS Code of the organisation', |
ods_code varchar(50) DEFAULT NULL COMMENT 'ODS Code of the organisation', |
| type_code |
varchar(50) |
DEFAULT NULL |
COMMENT 'The type of organisation', |
type_code varchar(50) DEFAULT NULL COMMENT 'The type of organisation', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the organisation', |
id bigint NOT NULL COMMENT 'Unique Id of the organisation', |
| parent_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'The id of the parent organisation', |
parent_organization_id bigint DEFAULT NULL COMMENT 'The id of the parent organisation', |
| Name |
varchar(255) |
DEFAULT NULL |
COMMENT 'Name of the organisation', |
Name varchar(255) DEFAULT NULL COMMENT 'Name of the organisation', |
Organization_metadata
<tbody>
</tbody>
| publishing_software |
varchar(50) |
NOT NULL |
COMMENT 'software name of publishing system, i.e. SystmOne', |
publishing_software varchar(50) NOT NULL COMMENT 'software name of publishing system, i.e. SystmOne', |
| last_data_to_dds |
datetime |
DEFAULT NULL |
COMMENT 'date time data was last sent to DDS', |
last_data_to_dds datetime DEFAULT NULL COMMENT 'date time data was last sent to DDS', |
| last_data_cutoff |
datetime |
DEFAULT NULL |
COMMENT 'cutoff date time of the last extract from the publishing system', |
last_data_cutoff datetime DEFAULT NULL COMMENT 'cutoff date time of the last extract from the publishing system', |
| id |
bigint |
NOT NULL |
COMMENT 'organisation ID, corresponds to same ID in the organizaton table', |
id bigint NOT NULL COMMENT 'organisation ID, corresponds to same ID in the organizaton table', |
Patient
<tbody>
</tbody>
| date_of_birth |
date |
DEFAULT NULL |
COMMENT 'The date of birth of the patient', |
date_of_birth date DEFAULT NULL COMMENT 'The date of birth of the patient', |
| nhs_number |
varchar(255) |
DEFAULT NULL |
COMMENT 'The NHS number of the patient', |
nhs_number varchar(255) DEFAULT NULL COMMENT 'The NHS number of the patient', |
| ethnic_code_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the ethnicity of the patient', |
ethnic_code_concept_id int DEFAULT NULL COMMENT 'Reference to the ethnicity of the patient', |
| gender_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the gender of the patient', |
gender_concept_id int DEFAULT NULL COMMENT 'Reference to the gender of the patient', |
| current_address_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the current address of the patient', |
current_address_id bigint DEFAULT NULL COMMENT 'Reference to the current address of the patient', |
| first_names |
varchar(255) |
DEFAULT NULL |
COMMENT 'The first names of the patient', |
first_names varchar(255) DEFAULT NULL COMMENT 'The first names of the patient', |
| date_of_death |
date |
DEFAULT NULL |
COMMENT 'The date of death of the patient', |
date_of_death date DEFAULT NULL COMMENT 'The date of death of the patient', |
| registered_practice_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the organisation the patient is registered at', |
registered_practice_organization_id bigint DEFAULT NULL COMMENT 'Reference to the organisation the patient is registered at', |
| title |
varchar(255) |
DEFAULT NULL |
COMMENT 'The title of the patient', |
title varchar(255) DEFAULT NULL COMMENT 'The title of the patient', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the patient', |
id bigint NOT NULL COMMENT 'Unique Id of the patient', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| last_name |
varchar(255) |
DEFAULT NULL |
COMMENT 'The last name of the patient', |
last_name varchar(255) DEFAULT NULL COMMENT 'The last name of the patient', |
Patient_additional
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'same as the id column on the patient table ', |
id bigint NOT NULL COMMENT 'same as the id column on the patient table ', |
| json_value |
json |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id, just raw JSON', |
json_value json DEFAULT NULL COMMENT 'where there is no mapped value_id, just raw JSON', |
| text_value |
varchar(255) |
DEFAULT NULL |
COMMENT 'where there is no mapped value_id or raw JSON, just a basic text value (i.e. GP Practitioner number)', |
text_value varchar(255) DEFAULT NULL COMMENT 'where there is no mapped value_id or raw JSON, just a basic text value (i.e. GP Practitioner number)', |
| value_id |
int |
DEFAULT NULL |
COMMENT 'IM reference (e.g. COVID)', |
value_id int DEFAULT NULL COMMENT 'IM reference (e.g. COVID)', |
| property_id |
int |
NOT NULL |
COMMENT 'IM reference (e.g. Cause of death)', |
property_id int NOT NULL COMMENT 'IM reference (e.g. Cause of death)', |
Patient_address
<tbody>
</tbody>
| address_line_3 |
varchar(255) |
DEFAULT NULL |
COMMENT 'The third line of the address', |
address_line_3 varchar(255) DEFAULT NULL COMMENT 'The third line of the address', |
| lsoa_2011_code |
varchar(9) |
DEFAULT NULL |
COMMENT 'A reference to the LSOA_2011 code', |
lsoa_2011_code varchar(9) DEFAULT NULL COMMENT 'A reference to the LSOA_2011 code', |
| postcode |
varchar(255) |
DEFAULT NULL |
COMMENT 'The postcode', |
postcode varchar(255) DEFAULT NULL COMMENT 'The postcode', |
| use_concept_id |
int |
NOT NULL |
COMMENT 'use of address (e.g. home, temporary)', |
use_concept_id int NOT NULL COMMENT 'use of address (e.g. home, temporary)', |
| msoa_2001_code |
varchar(9) |
DEFAULT NULL |
COMMENT 'A reference to the MSOA_2001 code', |
msoa_2001_code varchar(9) DEFAULT NULL COMMENT 'A reference to the MSOA_2001 code', |
| address_line_4 |
varchar(255) |
DEFAULT NULL |
COMMENT 'The fourth line of the address', |
address_line_4 varchar(255) DEFAULT NULL COMMENT 'The fourth line of the address', |
| start_date |
date |
NOT NULL |
COMMENT 'The start date of this address being relevant', |
start_date date NOT NULL COMMENT 'The start date of this address being relevant', |
| lsoa_2001_code |
varchar(9) |
DEFAULT NULL |
COMMENT 'A reference to the LSOA_2001 code', |
lsoa_2001_code varchar(9) DEFAULT NULL COMMENT 'A reference to the LSOA_2001 code', |
| address_line_1 |
varchar(255) |
DEFAULT NULL |
COMMENT 'The first line of the address', |
address_line_1 varchar(255) DEFAULT NULL COMMENT 'The first line of the address', |
| Id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the address', |
Id bigint NOT NULL COMMENT 'Unique Id of the address', |
| city |
varchar(255) |
DEFAULT NULL |
COMMENT 'The city', |
city varchar(255) DEFAULT NULL COMMENT 'The city', |
| end_date |
date |
DEFAULT NULL |
COMMENT 'The end date of this address being relevant', |
end_date date DEFAULT NULL COMMENT 'The end date of this address being relevant', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| ward_code |
varchar(9) |
DEFAULT NULL |
COMMENT 'The ward the address belongs to', |
ward_code varchar(9) DEFAULT NULL COMMENT 'The ward the address belongs to', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| local_authority_code |
varchar(9) |
DEFAULT NULL |
COMMENT 'The local authority the address belongs to', |
local_authority_code varchar(9) DEFAULT NULL COMMENT 'The local authority the address belongs to', |
| address_line_2 |
varchar(255) |
DEFAULT NULL |
COMMENT 'The second line of the address', |
address_line_2 varchar(255) DEFAULT NULL COMMENT 'The second line of the address', |
| msoa_2011_code |
varchar(9) |
DEFAULT NULL |
COMMENT 'A reference to the MSOA_2011 code', |
msoa_2011_code varchar(9) DEFAULT NULL COMMENT 'A reference to the MSOA_2011 code', |
Patient_address_match
<tbody>
</tbody>
| Column Name |
Type |
Constraint |
Comment |
Sql |
Patient_address_ralf
<tbody>
</tbody>
| Column Name |
Type |
Constraint |
Comment |
Sql |
Patient_contact
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the patient contact', |
id bigint NOT NULL COMMENT 'Unique Id of the patient contact', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| end_date |
date |
DEFAULT NULL |
COMMENT 'The end date of the contact being valid', |
end_date date DEFAULT NULL COMMENT 'The end date of the contact being valid', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| use_concept_id |
int |
DEFAULT NULL |
COMMENT 'use of contact (e.g. mobile, home,work', |
use_concept_id int DEFAULT NULL COMMENT 'use of contact (e.g. mobile, home,work', |
| start_date |
date |
DEFAULT NULL |
COMMENT 'The start date of the contact being valid', |
start_date date DEFAULT NULL COMMENT 'The start date of the contact being valid', |
| value |
varchar(255) |
DEFAULT NULL |
COMMENT 'The value of the contact information eg phone number, email address', |
value varchar(255) DEFAULT NULL COMMENT 'The value of the contact information eg phone number, email address', |
| type_concept_id |
int |
DEFAULT NULL |
COMMENT 'type of contact (e.g. phone, email)', |
type_concept_id int DEFAULT NULL COMMENT 'type of contact (e.g. phone, email)', |
Patient_pseudo_id
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the patient pseudo id', |
id bigint NOT NULL COMMENT 'Unique Id of the patient pseudo id', |
| is_nhs_number_valid |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the nhs number is valid', |
is_nhs_number_valid tinyint(1) NOT NULL COMMENT 'Whether the nhs number is valid', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'Reference to the patient this registration status history belongs to', |
patient_id bigint NOT NULL COMMENT 'Reference to the patient this registration status history belongs to', |
| is_nhs_number_verified_by_publisher |
tinyint(1) |
NOT NULL |
COMMENT 'Whether the nhs number has been verified by the publisher', |
is_nhs_number_verified_by_publisher tinyint(1) NOT NULL COMMENT 'Whether the nhs number has been verified by the publisher', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Reference to the person this registration status history belongs to', |
person_id bigint NOT NULL COMMENT 'Reference to the person this registration status history belongs to', |
| Skid |
varchar(255) |
NOT NULL |
COMMENT '"Secure Key IDentifier" - the pseudonymised ID generated for this patient using the salt specified in the salt_name column. Typically generated from patient NHS number, but is configurable on a case by case basis (e.g. may include date of birth)', |
Skid varchar(255) NOT NULL COMMENT '"Secure Key IDentifier" - the pseudonymised ID generated for this patient using the salt specified in the salt_name column. Typically generated from patient NHS number, but is configurable on a case by case basis (e.g. may include date of birth)', |
| salt_name |
varchar(50) |
NOT NULL |
COMMENT 'The name of the salt used to create the pseudo id', |
salt_name varchar(50) NOT NULL COMMENT 'The name of the salt used to create the pseudo id', |
Patient_uprn
<tbody>
</tbody>
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
Person
<tbody>
</tbody>
| current_address_id |
bigint |
NOT NULL |
COMMENT 'Reference to the current address of the person', |
current_address_id bigint NOT NULL COMMENT 'Reference to the current address of the person', |
| first_names |
varchar(255) |
DEFAULT NULL |
COMMENT 'The first names of the person', |
first_names varchar(255) DEFAULT NULL COMMENT 'The first names of the person', |
| gender_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the gender of the person', |
gender_concept_id int DEFAULT NULL COMMENT 'Reference to the gender of the person', |
| nhs_number |
varchar(255) |
DEFAULT NULL |
COMMENT 'The NHS number of the person', |
nhs_number varchar(255) DEFAULT NULL COMMENT 'The NHS number of the person', |
| ethnic_code_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the ethnicity of the person', |
ethnic_code_concept_id int DEFAULT NULL COMMENT 'Reference to the ethnicity of the person', |
| registered_practice_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the organisation the person is registered at', |
registered_practice_organization_id bigint DEFAULT NULL COMMENT 'Reference to the organisation the person is registered at', |
| title |
varchar(255) |
DEFAULT NULL |
COMMENT 'The title of the person', |
title varchar(255) DEFAULT NULL COMMENT 'The title of the person', |
| date_of_death |
date |
DEFAULT NULL |
COMMENT 'The date of death of the person', |
date_of_death date DEFAULT NULL COMMENT 'The date of death of the person', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| date_of_birth |
date |
DEFAULT NULL |
COMMENT 'The date of birth of the person', |
date_of_birth date DEFAULT NULL COMMENT 'The date of birth of the person', |
| last_name |
varchar(255) |
DEFAULT NULL |
COMMENT 'The last name of the person', |
last_name varchar(255) DEFAULT NULL COMMENT 'The last name of the person', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the person', |
id bigint NOT NULL COMMENT 'Unique Id of the person', |
Practitioner
<tbody>
</tbody>
| name |
varchar(1024) |
DEFAULT NULL |
COMMENT 'Name of the practitioner', |
name varchar(1024) DEFAULT NULL COMMENT 'Name of the practitioner', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the practitioner', |
id bigint NOT NULL COMMENT 'Unique Id of the practitioner', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| role_code |
varchar(50) |
DEFAULT NULL |
COMMENT 'The code representing the role of the practitioner', |
role_code varchar(50) DEFAULT NULL COMMENT 'The code representing the role of the practitioner', |
| gmc_code |
varchar(50) |
DEFAULT NULL |
COMMENT 'The GMC code of the practitioner', |
gmc_code varchar(50) DEFAULT NULL COMMENT 'The GMC code of the practitioner', |
| role_desc |
varchar(255) |
DEFAULT NULL |
COMMENT 'Textual description of the role of the practitioner eg General Medical Practitioner', |
role_desc varchar(255) DEFAULT NULL COMMENT 'Textual description of the role of the practitioner eg General Medical Practitioner', |
Procedure_request
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the procedure', |
id bigint NOT NULL COMMENT 'Unique Id of the procedure', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter the procedure was administered at', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter the procedure was administered at', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age of the patient at the time of the procedure', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age of the patient at the time of the procedure', |
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the procedure', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the procedure', |
| date_precision_concept_id |
int |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id int DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the procedure was administered by a clinician', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the procedure was administered by a clinician', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| date_recorded |
datetime |
DEFAULT NULL |
COMMENT 'The date the procedure was recorded in the source system', |
date_recorded datetime DEFAULT NULL COMMENT 'The date the procedure was recorded in the source system', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| status_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the status of the procedure', |
status_concept_id int DEFAULT NULL COMMENT 'Reference to the status of the procedure', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the procedure', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the procedure', |
Referral_request
<tbody>
</tbody>
| core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the referral', |
core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the referral', |
| non_core_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the clinical coding of the referral', |
non_core_concept_id int DEFAULT NULL COMMENT 'Reference to the clinical coding of the referral', |
| requester_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the organisation that made the refereral request', |
requester_organization_id bigint DEFAULT NULL COMMENT 'Reference to the organisation that made the refereral request', |
| encounter_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the encounter the referral was made in', |
encounter_id bigint DEFAULT NULL COMMENT 'Reference to the encounter the referral was made in', |
| referral_request_type_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the type of referral request', |
referral_request_type_concept_id int DEFAULT NULL COMMENT 'Reference to the type of referral request', |
| outgoing_referral |
tinyint(1) |
DEFAULT NULL |
COMMENT 'Whether this is an outgoing referral', |
outgoing_referral tinyint(1) DEFAULT NULL COMMENT 'Whether this is an outgoing referral', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the referral', |
id bigint NOT NULL COMMENT 'Unique Id of the referral', |
| referral_request_priority_concept_id |
smallint |
DEFAULT NULL |
COMMENT 'Reference to the priority of the referral', |
referral_request_priority_concept_id smallint DEFAULT NULL COMMENT 'Reference to the priority of the referral', |
| is_review |
tinyint(1) |
DEFAULT NULL |
COMMENT 'Whether this referral is a review', |
is_review tinyint(1) DEFAULT NULL COMMENT 'Whether this referral is a review', |
| Mode |
varchar(50) |
DEFAULT NULL |
COMMENT 'The mode of the referral', |
Mode varchar(50) DEFAULT NULL COMMENT 'The mode of the referral', |
| age_at_event |
decimal(5,2) |
DEFAULT NULL |
COMMENT 'The age of the patient at the time of the referral', |
age_at_event decimal(5,2) DEFAULT NULL COMMENT 'The age of the patient at the time of the referral', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'The clinician the activity is recorded against', |
practitioner_id bigint DEFAULT NULL COMMENT 'The clinician the activity is recorded against', |
| date_recorded |
datetime |
DEFAULT NULL |
COMMENT 'The date the referral request was added to the source system', |
date_recorded datetime DEFAULT NULL COMMENT 'The date the referral request was added to the source system', |
| date_precision_concept_id |
smallint |
DEFAULT NULL |
COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
date_precision_concept_id smallint DEFAULT NULL COMMENT 'Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14)', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
patient_id bigint NOT NULL COMMENT 'The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times', |
| clinical_effective_date |
date |
DEFAULT NULL |
COMMENT 'The date the referral was made', |
clinical_effective_date date DEFAULT NULL COMMENT 'The date the referral was made', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Unique individual across all organisations', |
person_id bigint NOT NULL COMMENT 'Unique individual across all organisations', |
| recipient_organization_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the organization receiving the referral', |
recipient_organization_id bigint DEFAULT NULL COMMENT 'Reference to the organization receiving the referral', |
Registration_status_history
<tbody>
</tbody>
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the registration status history', |
id bigint NOT NULL COMMENT 'Unique Id of the registration status history', |
| end_date |
datetime |
DEFAULT NULL |
COMMENT 'The end date for the period this registration status history was valid', |
end_date datetime DEFAULT NULL COMMENT 'The end date for the period this registration status history was valid', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| patient_id |
bigint |
NOT NULL |
COMMENT 'Reference to the patient this registration status history belongs to', |
patient_id bigint NOT NULL COMMENT 'Reference to the patient this registration status history belongs to', |
| person_id |
bigint |
NOT NULL |
COMMENT 'Reference to the person this registration status history belongs to', |
person_id bigint NOT NULL COMMENT 'Reference to the person this registration status history belongs to', |
| start_date |
datetime |
DEFAULT NULL |
COMMENT 'The start date for the period this registration status history was valid', |
start_date datetime DEFAULT NULL COMMENT 'The start date for the period this registration status history was valid', |
| episode_of_care_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the episode of care this status history belongs to', |
episode_of_care_id bigint DEFAULT NULL COMMENT 'Reference to the episode of care this status history belongs to', |
| registration_status_concept_id |
int |
DEFAULT NULL |
COMMENT 'Reference to the registration status', |
registration_status_concept_id int DEFAULT NULL COMMENT 'Reference to the registration status', |
Schedule
<tbody>
</tbody>
| start_date |
date |
DEFAULT NULL |
COMMENT 'The start date of the schedule', |
start_date date DEFAULT NULL COMMENT 'The start date of the schedule', |
| name |
varchar(150) |
DEFAULT NULL |
COMMENT 'The name of the schedule', |
name varchar(150) DEFAULT NULL COMMENT 'The name of the schedule', |
| organization_id |
bigint |
NOT NULL |
COMMENT 'Owning organisation (i.e. publisher)', |
organization_id bigint NOT NULL COMMENT 'Owning organisation (i.e. publisher)', |
| type |
varchar(255) |
DEFAULT NULL |
COMMENT 'The type of schedule eg Timed Appointments', |
type varchar(255) DEFAULT NULL COMMENT 'The type of schedule eg Timed Appointments', |
| location |
varchar(255) |
DEFAULT NULL |
COMMENT 'Textual description of the location the schedule was held at', |
location varchar(255) DEFAULT NULL COMMENT 'Textual description of the location the schedule was held at', |
| practitioner_id |
bigint |
DEFAULT NULL |
COMMENT 'Reference to the practitioner who owns the schedule', |
practitioner_id bigint DEFAULT NULL COMMENT 'Reference to the practitioner who owns the schedule', |
| id |
bigint |
NOT NULL |
COMMENT 'Unique Id of the schedule', |
id bigint NOT NULL COMMENT 'Unique Id of the schedule', |