ODS Organisation Reference Schema
Baseline Quality 65% Data Architecture Internal repository
Organisation: NHS Example Commissioning Support Unit · Project type: Database Schemas
SQL DDL and load scripts for a local reference schema of NHS organisations from the ODS quarterly release, including site hierarchies and successor organisation mappings.
Reusability tier
Baseline
Shared as-is from an internal project. Table names and file paths assume the authoring trust's environment; contact the team before reusing.
Links
Synthetic example
This entry is test data for the demo. The links below do not lead to real code, and any resemblance to real projects or packages is coincidental.
- Repository: https://github.com/nhs-example-org/ods-reference-schema This repository is internal; contact the maintainer below to request access.
Quality score
This entry scores 65 of 100 for metadata quality. The score measures how complete and current the catalogue entry is, not the code itself; the reusability tier covers the code. Improving the metadata raises the score.
| Criterion | Points | Met |
|---|---|---|
| Description of 100 characters or more | 10 | yes |
| Two or more tags | 10 | yes |
| Tier rationale provided | 10 | yes |
| SUL layers declared | 10 | yes |
| Updated within the last 18 months | 15 | yes |
| Platforms listed | 5 | yes |
| Owning organisation named | 5 | yes |
| Documentation link | 15 | no |
| Public repository | 10 | no |
| Installable package link | 10 | no |
SUL principle
How this entry maps to the SUL principle:
| Element | Description | Included |
|---|---|---|
| Structural | Templates, folder structures, project skeletons | yes |
| Utility | Generic helper functions decoupled from project logic | no |
| Logic | Bespoke project-specific code, clearly separated | yes |
Details
| Field | Value |
|---|---|
| Category | Data Architecture |
| Language(s) | SQL |
| Platform(s) | sql-server |
| Tags | ods reference-data organisations schemas |
| Date added | 2025-12-08 |
| Last updated | 2025-12-08 |
Contact
data-architecture@example-csu.nhs.uk
Spotted a problem with this entry? Request an update or withdrawal.
Back to the catalogue · More from NHS Example Commissioning Support Unit