- Create a sub-report to identify patients for the Phase 1/2 worklist
Highlight the 'Remediation - Under safeguarding' report, click Copy
Rename the report 'Remediation - Phase 1/2 Worklist' and select the same category and sub category as previously Within Report Joining:
- Join the report to 'Remediation - Self-identified Cases' & 'Remediation - Under Safeguarding' with a join type of 'Report on patients found in either of the selected reports'

- Click ok
- Create a sub-report to identify patients for the Phase 3/4 worklist
Highlight the 'Remediation - Phase 1/2 Worklist' report, click Copy
Rename the report 'Remediation - Phase 3/4 Worklist' and select the same category and sub category as previously Within Report Joining:
- Join the report to 'Document Exists' & 'Remediation - Phase 1/2 Worklist' with a join type of 'Report on patients found in report one but not in report two'

- Click ok
- Create a sub-report to identify patients who have online access to their full clinical record
Highlight the 'Remediation - Phase 3/4 Worklist' report, click Copy
Rename the report 'Remediation - Online Access to Full Clinical Record from before 30/01/25' and select the same category and sub category as previously Within Registration:
Select Online Services and tick 'Registered for online services'
Tick 'Access to full clinical record'
Tick 'Services granted'
Use the dropdown to select Before and enter the date 30/01/25

Within Report Joining:
- Clear the joined reports, select 'Join to one report'
- Join to 'Document Exists' with the join type of 'Only report on patients found in the 'Document Exists (PPARS/Remediation)' report
- Click ok
- Create a worklist report to identify patients for the Phase 1 worklist
Highlight the 'Remediation - Phase 1/2 Worklist' report, click Copy
Rename the report 'Remediation - Phase 1 Worklist - Have Online Access' and select the same category and sub category as previously Within Report Joining:
- Join the report to 'Remediation - Online Access to Full Clinical Record from before 30/01/25' & 'Remediation - Phase 1/2 Worklist' with a join type of 'Report on patients found in both the selected reports'

- Click ok
- Create a worklist report to identify patients for the Phase 2 worklist
Highlight the 'Remediation - Phase 1/2 Worklist' report, click Copy
Rename the report 'Remediation - Phase 2 Work List - Does Not Have Online Access' and select the same category and sub category as previously Within Report Joining:
- Join the report to 'Remediation - Online Access to Full Clinical Record from before 30/01/25' & 'Remediation - Phase 1/2 Worklist' with a join type of 'Report on patients found in report two but not in report one'

- Click ok
- Create a worklist report to identify patients for the Phase 3 worklist
Highlight the 'Remediation - Phase 3/4 Worklist' report, click Copy
Rename the report 'Remediation - Phase 3 Worklist - Have Online Access' and select the same category and sub category as previously Within Report Joining:
- Join the report to 'Remediation - Online Access to Full Clinical Record from before 30/01/25' & 'Remediation - Phase 3/4 Worklist' with a join type of 'Report on patients found in both the selected reports'

- Click ok
- Create a worklist report to identify patients for the Phase 4 worklist
Highlight the 'Remediation - Phase 3/4 Worklist' report, click Copy
Rename the report 'Remediation - Phase 4 Work List - Does Not Have Online Access' and select the same category and sub category as previously Within Report Joining:
- Join the report to 'Remediation - Online Access to Full Clinical Record from before 30/01/25' & 'Remediation - Phase 3/4 Worklist' with a join type of 'Report on patients found in report two but not in report one'
- Click ok
You will end up with 10 reports, you may wish to add 'z' in front of the sub-reports to clearly identify the worklists as below. The remediation work will be undertaken for:
- Remediation - Phase 1 Work List - Have Online Access
- Remediation - Phase 2 Work List - Does Not Have Online Access
- Remediation - Phase 3 Work List - Have Online Access
- Remediation - Phase 4 Work List - Does Not Have Online Access