A&E Daily Attendance Extract
Baseline Quality 65% Data Engineering Private repository
Organisation: NHS Example Trust · Project type: Ad Hoc Extractions
SQL scripts to extract daily A&E attendance and four-hour performance data from a trust's local SUS mirror. Written to answer a one-off operational question but shared so others can see the approach and adapt the queries.
Reusability tier
Baseline
Code is shared and findable, but contains hardcoded table names and lacks a dependency file. Contact the author to request access and discuss adaptation.
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/ae-daily-extract 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 | no |
| Logic | Bespoke project-specific code, clearly separated | yes |
Details
| Field | Value |
|---|---|
| Category | Data Engineering |
| Language(s) | SQL |
| Platform(s) | sql-server |
| Tags | a-and-e sus ed four-hour-standard emergency-care |
| Date added | 2026-05-10 |
| Last updated | 2026-05-10 |
Contact
Spotted a problem with this entry? Request an update or withdrawal.