SUS Ingest Pipeline
Silver Quality 65% Data Engineering Private repository
Organisation: NHS Example Commissioning Support Unit · Project type: Data Pipelines (Automated)
A Python and SQL pipeline that lands the monthly SUS extract, applies standard data quality checks, and loads conformed admitted patient care tables into a local warehouse. Field mappings and DQ rules live in config.
Reusability tier
Silver
Connection details, field mappings, and DQ thresholds are all configuration, with a documented access process and an adaptation guide. Generic loaders are separated but not yet packaged.
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/sus-ingest-pipeline This repository is private; 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 | no |
| Utility | Generic helper functions decoupled from project logic | yes |
| Logic | Bespoke project-specific code, clearly separated | yes |
Details
| Field | Value |
|---|---|
| Category | Data Engineering |
| Language(s) | Python SQL |
| Platform(s) | sql-server azure |
| Tags | sus apc etl data-quality secondary-care |
| Date added | 2026-03-25 |
| Last updated | 2026-05-15 |
Contact
data-engineering@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