Discovery Remote Subscriber Database Familiarisation - Revision history

AdminJo: /* Remote Subscriber Database User Forum */

2025-08-19T10:50:52Z

Remote Subscriber Database User Forum

← Older revision		Revision as of 10:50, 19 August 2025
Line 6:		Line 6:
	== End User Acceptance Testing ==		== End User Acceptance Testing ==
	[[Remote Subscriber Database Testing and Assurance\|Follow this link]] to go to the article that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.		[[Remote Subscriber Database Testing and Assurance\|Follow this link]] to go to the article that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.

	~~== Remote Subscriber Database User Forum ==~~
	~~All organisations accessing DDS on remote subscriber database are invited to a user forum to share knowledge and learning from their experience using the product.~~

	~~[https://endeavourhealth.atlassian.net/secure/RapidBoard.jspa?rapidView=43 Follow this link] to access our Extract & Queries Forum.~~

	~~[[Extract & Queries Forum and Issue Logging\|Follow this link]] for our user guide to our Extract & Queries Forum.~~

	== Data Mapping ==		== Data Mapping ==

AdminJo: /* Current Schema */

2025-08-19T09:34:12Z

Current Schema

← Older revision		Revision as of 09:34, 19 August 2025
Line 18:		Line 18:

	=== Current Schema ===		=== Current Schema ===
	[[Compass 2.1 Schema Documentation~~\|Compass 2.1 Schema~~]]		[[Compass 2.3.0 Schema Documentation]]

	=== Retired Schema ===		=== Retired Schema ===
Line 24:		Line 24:

	[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]		[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]

			[[Compass 2.1 Schema Documentation\|Compass 2.1 Schema]]



	This is an example of a schema table. [[File:Schema table example.jpg\|none\|thumb\|Schema table example]]		This is an example of a schema table. [[File:Schema table example.jpg\|none\|thumb\|Schema table example]]

JoshuA at 10:10, 22 December 2022

2022-12-22T10:10:46Z

← Older revision		Revision as of 10:10, 22 December 2022
Line 17:		Line 17:
	The links below take you to our schemas which list the contents and references for each table in the Compass databases.		The links below take you to our schemas which list the contents and references for each table in the Compass databases.

	=== ~~'''~~Current Schema~~'''~~ ===		=== Current Schema ===
	[[Compass 2.1 Schema Documentation\|Compass 2.1 Schema]]		[[Compass 2.1 Schema Documentation\|Compass 2.1 Schema]]

JoshuA at 10:10, 22 December 2022

2022-12-22T10:10:05Z

← Older revision		Revision as of 10:10, 22 December 2022
Line 17:		Line 17:
	The links below take you to our schemas which list the contents and references for each table in the Compass databases.		The links below take you to our schemas which list the contents and references for each table in the Compass databases.

			=== '''Current Schema''' ===
			[[Compass 2.1 Schema Documentation\|Compass 2.1 Schema]]

			=== Retired Schema ===
	[[Remote Subscriber Database (RSD) Schema (Compass 1)\|Compass 1 Schema]]		[[Remote Subscriber Database (RSD) Schema (Compass 1)\|Compass 1 Schema]]

	[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]		[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]

	~~Compass 2.1 Schema~~		This is an example of a schema table. [[File:Schema table example.jpg\|none\|thumb\|Schema table example]]

	This is an example of a schema table.
	[[File:Schema table example.jpg\|none\|thumb\|Schema table example]]

	== Remote Discovery Database SQL Guides ==		== Remote Discovery Database SQL Guides ==

JoshuA: /* Data Mapping */

2022-12-22T10:02:29Z

Data Mapping

← Older revision		Revision as of 10:02, 22 December 2022
Line 20:		Line 20:

	[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]		[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]

			Compass 2.1 Schema

	This is an example of a schema table.		This is an example of a schema table.

JoshuA: /* Data Mapping */

2022-12-22T09:59:51Z

Data Mapping

← Older revision		Revision as of 09:59, 22 December 2022
Line 19:		Line 19:
	[[Remote Subscriber Database (RSD) Schema (Compass 1)\|Compass 1 Schema]]		[[Remote Subscriber Database (RSD) Schema (Compass 1)\|Compass 1 Schema]]

	[[~~Remote Subscriber Database (RSD)~~ Schema ~~(Compass 2)~~\|Compass 2 Schema]]		[[Compass V2.1 Schema Documentation\|Compass 2 Schema]]

	This is an example of a schema table.		This is an example of a schema table.

JoshuA at 13:10, 2 July 2021

2021-07-02T13:10:30Z

← Older revision		Revision as of 13:10, 2 July 2021
Line 2:		Line 2:
	The purpose of this article is to assist users of the DDS Remote Subscriber Database in testing understanding and maximising the benefits of the system.		The purpose of this article is to assist users of the DDS Remote Subscriber Database in testing understanding and maximising the benefits of the system.

	It includes testing guidance, hints and tips from ~~LHS~~ developers who have experience with the system and guidance on how to use tools share knowledge and record issues.		It includes testing guidance, hints and tips from developers who have experience with the system, and guidance on how to use tools share knowledge and record issues.

	== End User Acceptance Testing ==		== End User Acceptance Testing ==
Line 8:		Line 8:

	== Remote Subscriber Database User Forum ==		== Remote Subscriber Database User Forum ==
	All organisations accessing DDS on remote subscriber database are invited to a user forum to share knowledge and learning from their experience using the product~~. The forum communicates using our Jira board and a regular conference call which will be attended by a developer who is experienced at creating SQL queries on data held in the DDS from LHS~~.		All organisations accessing DDS on remote subscriber database are invited to a user forum to share knowledge and learning from their experience using the product.

	[https://endeavourhealth.atlassian.net/secure/RapidBoard.jspa?rapidView=43 Follow this link] to access our Extract & Queries Forum.		[https://endeavourhealth.atlassian.net/secure/RapidBoard.jspa?rapidView=43 Follow this link] to access our Extract & Queries Forum.

Jay at 13:13, 4 August 2020

2020-08-04T13:13:55Z

← Older revision		Revision as of 13:13, 4 August 2020
Line 15:		Line 15:

	== Data Mapping ==		== Data Mapping ==
	The links below take you to our schemas for the Compass ~~1 and Compass 2~~ databases ~~respectively~~.		The links below take you to our schemas which list the contents and references for each table in the Compass databases.

	[[Remote Subscriber Database (RSD) Schema (Compass 1)\|Compass 1 Schema]]		[[Remote Subscriber Database (RSD) Schema (Compass 1)\|Compass 1 Schema]]
Line 24:		Line 24:
	[[File:Schema table example.jpg\|none\|thumb\|Schema table example]]		[[File:Schema table example.jpg\|none\|thumb\|Schema table example]]

	== Remote Discovery Database SQL ~~Guide~~ ==		== Remote Discovery Database SQL Guides ==
	The articles below were written by our developers, who are experts with the DDS, to introduce you to how they create cohorts, build datasets and call store procedures.		The articles below were written by our developers, who are experts with the DDS, to introduce you to how they create cohorts, build datasets and call store procedures.

Jay at 13:12, 4 August 2020

2020-08-04T13:12:14Z

← Older revision		Revision as of 13:12, 4 August 2020
Line 21:		Line 21:
	[[Remote Subscriber Database (RSD) Schema (Compass 2)\|Compass 2 Schema]]		[[Remote Subscriber Database (RSD) Schema (Compass 2)\|Compass 2 Schema]]

	This is an example of a table ~~from that document~~.		This is an example of a schema table.
	[[File:Schema table example.jpg\|none\|thumb\|Schema table example]]		[[File:Schema table example.jpg\|none\|thumb\|Schema table example]]

Jay at 12:59, 4 August 2020

2020-08-04T12:59:43Z

← Older revision		Revision as of 12:59, 4 August 2020
Line 1:		Line 1:
	== Overview ==		== Overview ==
	The purpose of this ~~page~~ is to assist users of the DDS Remote Subscriber Database in testing understanding and maximising the benefits of the system.		The purpose of this article is to assist users of the DDS Remote Subscriber Database in testing understanding and maximising the benefits of the system.

	It includes testing guidance, hints and tips from LHS developers who have experience with the system and guidance on how to use tools share knowledge and record issues.		It includes testing guidance, hints and tips from LHS developers who have experience with the system and guidance on how to use tools share knowledge and record issues.

	== End User Acceptance Testing ==		== End User Acceptance Testing ==
	[[Remote Subscriber Database Testing and Assurance\|Follow this link]] to go to the ~~page~~ that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.		[[Remote Subscriber Database Testing and Assurance\|Follow this link]] to go to the article that outlines the strategy to be used for end user testing and assurance of data published to a remote data distribution service.

	== Remote Subscriber Database User Forum ==		== Remote Subscriber Database User Forum ==
Line 25:		Line 25:

	== Remote Discovery Database SQL Guide ==		== Remote Discovery Database SQL Guide ==
	The ~~pages~~ below were written by our developers, who are experts with the DDS, to introduce you to how they create cohorts, build datasets and call store procedures.		The articles below were written by our developers, who are experts with the DDS, to introduce you to how they create cohorts, build datasets and call store procedures.

	[[Remote Subscriber Database (RSD) SQL guide (Compass 1)\|Compass 1 SQL Guide]]		[[Remote Subscriber Database (RSD) SQL guide (Compass 1)\|Compass 1 SQL Guide]]

	[[Remote Subscriber Database (RSD) SQL guide (Compass 2)\|Compass 2 SQL Guide]]		[[Remote Subscriber Database (RSD) SQL guide (Compass 2)\|Compass 2 SQL Guide]]