...
Purpose
In order for the Statistics team to compile their AKI reports every quarter(really quarter plus two months) to the Clinical Commissioning Group (CCG), the Statistics team need to be able to access the relevant AKI data for report generation.
To facilitate this a data pipeline is required, whose sole main aim is to facilitate the required data access for any AKI data they need to achieve their goal.
Requirements
There are two requirements to this the main requirement is to:
- Build out the infrastructure, mechanisms and processes to allow the Statistics team access to the correct data for their reports.
The above needs to be broken down even further and the text in bold needs defining so what is the "correct data"? This comprises of two aspects a temporal one and a data choice one:
Temporal:
This is relating to what point in time are the CCG and therefore the Statistics team interested in for each of their quarterly reports.
Data Choice:
This relates to the "What data do they need?" question:
| Data Point | Description |
|---|---|
| NHS Number | |
| NHS Number from Patient Tracing | |
| Lab Code | |
| Date of Birth | |
| Date of Birth from Patient Tracing | |
| Gender | |
| Gender from Patient Tracing | |
| Specimen Number | |
| Source of Request | |
| Care Field Indicator | |
| Date of Alert | |
| AKI Warning Test Result | |
| Creatinine | |
| eGFR MDRD | |
| eGFR CKD EPI | |
| Date of Death from Patient Tracing | |
| Postcode | |
| Patient Tracing Response Code |