The JAR Reconciliation Files provides a granular breakdown of hospital activity (TFC/HRG Level), based on national planning logic. This script runs the activity views and then outputs files, complete with three tabs (APC, OP, AE) for each provider and system.
📝 National JAR methodology - Accident and Emergency Attendance - Provider - PAT
📝 National JAR methodology - Admitted patient care script - Provider - PAT
📝 National JAR methodology - Outpatient Attendance script - Provider - PAT
The PAT and FasterSUS scripts are ran using National Planning logic, the below applies to both APC and OP scripts:
- Acute Provider Only
- Consultant led Specific Acute activity only
- Treatment Function Code 360 and 812 (op) is excluded
- Excluding Private patients
🚑 Accident and Emergency Attendance script
This script covers Emergency Care attendances, sourced from the National PAT Intermediate EC SUS table
🏥 Admitted patient care script
This script covers both elective and non-elective hospital activity, sourced from the National PAT Intermediate Admitted Patient Care SUS table
👨⚕️ Outpatient Attendance script
This script covers Outpatient attendances, sourced from the National PAT Intermediate OP SUS table
🛢️DataBricks 🛢️UDAL
🛢️ Pat_intermediate_OPA 🛢️ Pat_intermediate_APC 🛢️ Pat_intermediate_AE
To find out more about the South West Intelligence and Insights Team visit our South West Intelligence and Insights Team Futures Page) or get in touch at england.southwestanalytics@nhs.net. Alternatively, Please feel free to reach out to me directly:
📧 Email: Destiny.Bradley@nhs.net
💬 Teams: Join my Teams
Thanks to Bernardo Detanico for his ongoing support in applying National Logic and Miles Filton for his support with getting started on Databricks