Compass V2.1 Schema Documentation - Revision history

DavidHesketh at 16:46, 6 January 2023

2023-01-06T16:46:25Z

← Older revision		Revision as of 16:46, 6 January 2023
Line 57:		Line 57:
	<tr>		<tr>
	<td>clinical_effective_date</td>		<td>clinical_effective_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The date the clinical code is recorded for'</td>		<td> 'The date the clinical code is recorded for'</td>
Line 165:		Line 165:
	<tr>		<tr>
	<td>start_date</td>		<td>start_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The start date of the appointment'</td>		<td> 'The start date of the appointment'</td>
Line 694:		Line 694:
	<tr>		<tr>
	<td>clinical_effective_date</td>		<td>clinical_effective_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The date the clinical code is recorded for'</td>		<td> 'The date the clinical code is recorded for'</td>
Line 764:		Line 764:
	<tr>		<tr>
	<td>end_date</td>		<td>end_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The end date of the encounter'</td>		<td> 'The end date of the encounter'</td>
Line 970:		Line 970:
	<tr>		<tr>
	<td>end_date</td>		<td>end_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The end date of the encounter'</td>		<td> 'The end date of the encounter'</td>
Line 1,302:		Line 1,302:
	<tr>		<tr>
	<td>clinical_effective_date</td>		<td>clinical_effective_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The date the medication order was issued'</td>		<td> 'The date the medication order was issued'</td>
Line 1,459:		Line 1,459:
	<tr>		<tr>
	<td>clinical_effective_date</td>		<td>clinical_effective_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The date the medication was clinical relevant'</td>		<td> 'The date the medication was clinical relevant'</td>
Line 1,616:		Line 1,616:
	<tr>		<tr>
	<td>clinical_effective_date</td>		<td>clinical_effective_date</td>
	<td>~~date~~</td>		<td>datetime</td>
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'The date the observation was identified by a clinician'</td>		<td> 'The date the observation was identified by a clinician'</td>
Line 2,610:		Line 2,610:
	</tr>		</tr>
	<tr>		<tr>
	<td>~~Skid~~</td>		<td>skid</td>
	<td>varchar(255)</td>		<td>varchar(255)</td>
	<td>NOT NULL</td>		<td>NOT NULL</td>
Line 3,292:		Line 3,292:
	<tr>		<tr>
	<td>2.1</td>		<td>2.1</td>
	<td>2023-01-06T16:37:30.~~087718500~~</td>		<td>2023-01-06T16:46:00.566742300</td>
	</tr></table>		</tr></table>

DavidHesketh at 16:38, 6 January 2023

2023-01-06T16:38:22Z

← Older revision		Revision as of 16:38, 6 January 2023
Line 1:		Line 1:
	<h1 id="firstHeading" class="firstHeading" lang="en-GB">Remote Subscriber Database (RSD) Schema Compass 2.1</h1>		<h1 id="firstHeading" class="firstHeading" lang="en-GB">Remote Subscriber Database (RSD) Schema (Compass 2) Version: 2.1</h1>

	<div id="bodyContent" class="mw-body-content">		<div id="bodyContent" class="mw-body-content">
Line 445:		Line 445:
	<td>DEFAULT NULL</td>		<td>DEFAULT NULL</td>
	<td> 'date that the version was made outdated'</td>		<td> 'date that the version was made outdated'</td>
			<td>No Foreign Key reference</td>
			</tr>
			<tr>
			<td>wiki_page</td>
			<td>varchar(255)</td>
			<td>DEFAULT NULL</td>
			<td> 'the wiki page where this database structure is found'</td>
	<td>No Foreign Key reference</td>		<td>No Foreign Key reference</td>
	</tr>		</tr>
	<tr>		<tr>
	<td colspan="5">Unique index name: `valid_to_uq` Index Columns: (valid_to)</td> </tr> <tr>		<td colspan="5">Unique index name: `valid_to_uq` Index Columns: (valid_to)</td> </tr> <tr>
	<td colspan="5">PRIMARY KEY CONSTRAINT(s) (`valid_from`)</td> </tr> </table>		<td colspan="5">PRIMARY KEY CONSTRAINT(s) (`valid_from`,`version`)</td> </tr> </table>
	<h1><span class="mw-headline" id="Sortable_tables">diagnostic_order</span></h1>		<h1><span class="mw-headline" id="Sortable_tables">diagnostic_order</span></h1>
	<table class="mw-collapsible" border="1" style="border-collapse:collapse">		<table class="mw-collapsible" border="1" style="border-collapse:collapse">
Line 3,284:		Line 3,291:
	</tr>		</tr>
	<tr>		<tr>
	<td>V2.1</td>		<td>2.1</td>
	<td>~~2022~~-12-~~15T17~~:05:49.~~557~~</td>		<td>2023-01-06T16:37:30.087718500</td>
	</tr></table>		</tr></table>

JoshuA at 10:00, 22 December 2022

2022-12-22T10:00:53Z

← Older revision		Revision as of 10:00, 22 December 2022
Line 1:		Line 1:
	<h1 id="firstHeading" class="firstHeading" lang="en-GB">Remote Subscriber Database (RSD) Schema (Compass 2~~) Version: V2~~.1</h1>		<h1 id="firstHeading" class="firstHeading" lang="en-GB">Remote Subscriber Database (RSD) Schema Compass 2.1</h1>

	<div id="bodyContent" class="mw-body-content">		<div id="bodyContent" class="mw-body-content">

DavidHesketh: Created page with "

Remote Subscriber Database (RSD) Schema (Compass 2) Version: V2.1

2022-12-15T17:06:51Z

Created page with " <h1 id="firstHeading" class="firstHeading" lang="en-GB">Remote Subscriber Database (RSD) Schema (Compass 2) Version: V2.1</h1> <div id="bodyContent" class="mw-body-content..."

Show changes