How To Understand The Frequency Of PAHT Reports
| Frequency | Original Producer | Email Title | SSIS Solution | SQL Agent Job | Output Folder | Source Code |
| Daily | Polly Ridgwell-Cook/
Colin Braybrook |
DNA Report | DailyDNA | SSIS_DAILYDNA | \\SR-STAGINGDW\SSRS_Ouputs$\CASS\DailyReportOutputs\DNA | \\SR-STAGINGDW\SSRS_Ouputs$\00 - Visual Studio Solutions\CSS\Dailies\01 - Daily DNA Report |
| Daily | Polly Ridgwell-Cook/
Colin Braybrook |
RAPA Report | SSIS_DAILYRAPA | \\SR-STAGINGDW\SSRS_Ouputs$\00 - Visual Studio Solutions\CSS\Dailies\02 - Daily RAPA Report | ||
| Daily | Polly Ridgwell-Cook/
Colin Braybrook |
AE Attendances MS Daily Report | SSIS_DAILYAEMS | \\SR-STAGINGDW\SSRS_Ouputs$\00 - Visual Studio Solutions\CSS\Dailies\03 - Daily AEMS Report | ||
| Daily | Polly Ridgwell-Cook/
Colin Braybrook |
Daily Cancer Attenders | SSIS_DAILYCANCER | \\SR-STAGINGDW\SSRS_Ouputs$\00 - Visual Studio Solutions\CSS\Dailies\04 - Daily Cancer Attenders Report | ||
| Daily | Colin Braybrook | FFT Attendances | SSIS_DAILYFFT | |||
| Daily | Colin Braybrook | Daily Discharges Report | SSIS_DAILYDISCHARGES | |||
| Daily | Colin Braybrook | Care Homes report Inpatient - Swab details | SSIS_DAILYCAREHOME | |||
| Daily | Srishti | Tobacco Dependence Data Daily | SSIS_DAILYTOBACCO | |||
| Daily | Srishti | Respiratory Attendances From A&E | SSIS_DAILYRESPIRATORY | |||
| Weekly | Colin Braybrook | TARN | SSIS_WEEKLYTARN | |||
| Weekly | Colin Braybrook | HCG Summary | SSIS_WEEKLYHCG | |||
| Weekly | Srishti | Weekly JXPET_JXPEU_JXPVT | ||||
| Weekly | Srishti | Mental Health Disorder |