Digital CHC Reportal

Digital CHC Reportal

The reports are as follows:

Reports for a Single CCG

• Referrals Received (YTD). All graphs on this report are over the last 12months and can be broken down by month or quarter. The graphs are:

• Referrals by Outcomes

• Screened Referrals Received (whether the referral was screened in/out)

• Total Referrals Received

• Referrals Conversion Rates (YTD). This is based on report CHC-07 (still needs to be finished)

• No of Referrals at Stage. These graphs are broken down by workflow.

• No of Referrals at Stage by Team

• Total No of Referrals at Stage

• Location of DST. The graph on this report is over the last 12 months and can be broken down by month or quarter. It can also be filtered by Team.

• No of Incomplete Referrals, Exceeding 28 Days. The graph on this report is over the last 12 months and can be broken down by month or quarter. It can also be filtered by Team.

Single CCG Reporting

Click on the arrow, you are then presented with 7 tabs of reports:

1. Referrals Received (YTD)

All graphs on this report are over the last 12 months and can be broken down by month or quarter. The graphs are:

· Referrals by Outcomes

· Screened Referrals Received (whether the referral was screened in/out)

· Total Referrals Received

All graphs use the following columns:

• Assessment – Is Eligible.

• CCG – Name.

• Checklist – Abandoned On Date.

• Checklist – CCG Key – used to find the allocated CCG

• Checklist - Created On Date – used to calculate the month / quarter the checklist was created in.

• Checklist – Is Eligible.

• Checklist – Outcome.

2. Referrals Received Cumulative

All graphs use the following columns:

• Assessment – Is Eligible.

• CCG – Name.

• Checklist – Abandoned On Date.

• Checklist – CCG Key – used to find the allocated CCG

• Checklist - Created On Date – used to calculate the month / quarter the checklist was created in.

• Checklist – Is Eligible.

• Checklist – Outcome.

3. Referrals at State

These graphs are broken down by workflow:

· No of Referrals at Stage by Team

· Total No of Referrals at Stage

The graph uses the following columns:

• CCG – Name.

• Checklist – Is At Hospital.

• Team – Name.

• Workflow Configuration – Name.

• Workflow Configuration State – Name.

• Workflow Configuration State – Target Duration.

• Workflow Configuration State – Target Duration Unit.

• Workflow Instance – Abandoned By.

• Workflow Instance – Abandoned On Date and Time.

• Workflow Instance – Abandoned Reason.

• Workflow Instance – CCG Key – CCG Key – used to find the allocated CCG.

• Workflow Instance – Completed By.

• Workflow Instance – Completed On Date and Time.

• Workflow Instance – Created By.

• Workflow Instance – Created On Date and Time.

• Workflow Instance Link – Assigned Team Key.

• Workflow Instance State – Completed By.

• Workflow Instance State – Completed On Date and Time.

• Workflow Instance State – Started By.

• Workflow Instance State – Started On Date and Time.

• Workflow Instance Payload – CCG Decision.

4. Location of DST

The graph on this report is over the last 12 months and can be broken down by month or quarter. It can also be filtered by Team.

The graph uses the following columns:

• Case – Is At Hospital.

• Case – Start Date and Time.

• CCG – Name.

• Team – Name.

• Workflow Configuration – Name.

• Workflow Configuration State – Name.

• Workflow Instance – Completed On Date and Time.

• Workflow Instance – Created On Date and Time.

• Workflow Instance State – Minimum Started On Date and Time.

5. Number of Incomplete Referrals Exceeding 28 Days

The graph on this report is over the last 12 months and can be broken down by month or quarter. It can also be filtered by Team.

The graph uses the following columns:

• Case – Started On Date and Time.

• CCG – Name.

• Team – Name.

• Workflow Configuration – Name.

• Workflow Configuration State – Name.

• Workflow Instance – Assessment Abandoned On Date and Time.

• Workflow Instance – Completed On Date and Time.

• Workflow Instance – Created On Date and Time.

• Workflow Instance Link – CCGKey.

• Workflow Instance Link - Assigned Team Key.

• Workflow Instance State – Started On Date and Time.

• Workflow Instance State – Using Minimum Started On Date and Time calculate the number of days since started.

6. Quarterly Export

The table uses the following columns

• Assessment – Created By.

• Assessment – Created On Date and Time.

• Assessment – Individual Involvement.

• Assessment – Is At Hospital.

• Assessment – Is At Permanent Address.

• Assessment – Is Complete.

• Assessment – Is Eligible.

• Assessment – Representative Attended.

• Assessment – Representative Invited.

• Case – Created On Date and Time.

• Case – Date of Birth.

• Case – Nurse.

• Case – Reference.

• CCG – Name.

• Checklist – Completed On Date and Time.

• Checklist – Consent.

• Checklist – Created By.

• Checklist – Created On Date and Time.

• Checklist – General Practice CCG Name.

• Checklist – General Practice, Practice Name.

• Checklist – Individual Involvement.

• Checklist – Is Eligible.

• Checklist – Is At Hospital.

• Checklist – Is At Permanent Address.

• Checklist – Is Complete.

• Checklist – Outcome.

• Checklist – Representative Attended.

• Checklist – Representative Invited.

• Domain Assessment – Score is used for :

• • Checklist Behaviour Score,

  • Checklist Cognition Score,

  • Checklist Psychological Emotional Score,

  • Checklist Communication Score,

  • Checklist Mobility Score,

  • Checklist Nutrition Score,

  • Checklist Continence Score,

  • Checklist Skin Integrity Score,

  • Checklist Breathing Score,

  • Checklist Drug Therapies Score,

  • Checklist Asoc Score,

  • Assessment Behaviour Score,

  • Assessment Cognition Score,

  • Assessment Psychological Emotional Score,

  • Assessment Communication Score,

  • Assessment Mobility Score,

  • Assessment Nutrition Score,

  • Assessment Continence Score,

  • Assessment Skin Integrity Score,

  • Assessment Breathing Score,

  • Assessment Drug Therapies Score,

  • Assessment Asoc Score.

• Equality – Disability.

• Equality – Ethnic Group includes Others.

• Equality – Gender.

• Equality – Religion includes Others.

• Equality – Sexual Orientation.

• Organisation – Name, used for the Assessment and Checklist organisation name.

• Patient – Date of Birth – used to calculate the age

• Workflow Instance Payload – CCG Decision.

• Workflow Instance State – Trigger ID used to decided whether the checklist was positive or negative.

7. Number of Incomplete Referrals under 28 Days

The table uses the following columns:

• CCG – Name.

• Team – Name.

• Workflow Configuration – Name.

• Workflow Configuration State – Name.

• Workflow Instance State - Started On - Has no completed on or abandoned on date and the Start Date is last than 28 days from the current date.

8. Assessor Response Times

The table uses the following columns:

• CCG – Name.

• Team – Name.

• Workflow Configuration – Name.

• Workflow Configuration State – Name.

• Information Request – Document Type

• Information Request – CompletedOn – Used to decide with the Information

• Information Request - Start Date

• Information Request – Number of days – This is either

• Information Request - Count of the No of Information request

9. Open Stages by Coordinator

The table uses the following columns:

• CCG – Name.

• MDT Meeting – Coordinator Name

• Team – Name.

• Workflow Configuration – Name.

• Workflow Configuration State – Name.

• Workflow Instance State – Started On