Add a model to store Friends and Family Test data

[stevenday]

Part of #1213

Summary data from surveys conducted monthly at each Trust and each Hospital, in the A&E and In-Patient departments, will be uploaded via CSV files by NHS Superusers.

We will have to potentially store:

• 1 A&E survey
• 1 In-Patient survey
• 1 Maternity ward survey (in the future)

Per month, per organisation or trust

The data for each survey looks like:

Per site CSV looks like:

Area Team Code,Code,Name,Site Code,Site Name,Total Responses,Total Eligible,Response Rate,Friends and Family Test Score,,Extremely Likely,Likely,Neither,Unlikely,Extremely Unlikely,Don't Know
Q44,RJR,COUNTESS OF CHESTER HOSPITAL NHS FOUNDATION TRUST,RJR05,Countess Of Chester Hospital - RJR05,498,"1,303",38.20%,79,,346,79,6,0,0,67

Per Trust CSV looks like:

Area Team Code,Code,Name,Total Responses,Total Eligible,Response Rate,Friends and Family Test Score,,Extremely Likely,Likely,Neither,Unlikely,Extremely Unlikely,Don't Know,,SMS/Text / Smartphone App,Electronic tablet/kiosk at point of discharge,Paper / postcard at point of discharge,"Paper survey, sent to the patients home",Telephone survey once patient is home,Online survey once patient is home,Other
Q44,RJR,COUNTESS OF CHESTER HOSPITAL NHS FOUNDATION TRUST,498,"1,303",38.20%,79,,346,79,6,0,0,67,,0,0,497,0,0,0,1

The key fields here being:

• Friends and family test score (the overall score)
• Extremely Likely
• Likely
• Neither Likely or Unlikely
• Extremely Unlikely
• Don't Know

As well as the Month, the org or trust it's about, and where it was conducted (A&E, In-Patient, Maternity, etc).

The following fields are extra info:

• Total responses
• Total eligible
• Response rate

And the following fields seem only to be present on survey's of Trusts, to determine how the subject responded:

• SMS/Text / Smartphone App
• Electronic tablet/kiosk at point of discharge
• Paper / postcard at point of discharge
• Paper survey, sent to the patients home
• Telephone survey once patient is home
• Online survey once patient is home,
• Other

This would seem like a good case for using: https://docs.djangoproject.com/en/dev/ref/contrib/contenttypes/ to connect individual surveys to either an org or a trust from a single field.

Questions

• Do we need to store the extra info or survey method data?
• Do we definitely need to store individual surveys per month, per department, or do we need to combine them ourselves so that there's just one survey per org per month?

[Lynne2]

There is no need to show how the person is repsonding but would like a link to the NHS England website where the full data set sits so people can see this if they’d like more info.

We would like to sub divide the tab to separate data for A&E and In-Patient surveys, to have a select box so the person can choose in-patient or A&E – this will also include maternity in the new year.

[stevenday]

Hi @Lynne2,

Thanks for answering the main question, with regards linking to the NHSE website, can you tell me what the url will be? It'll be easy to link to a single page that doesn't change, but it might be tricky to link to the specific page for a given survey, since that info isn't in the spreadsheet. Unless it's easy to work it out from the survey itself?

[Lynne2]

Hi, URL will be http://www.england.nhs.uk/statistics/statistical-work-areas/friends-and-family-test/ it's the main page, users can then select other information they may wish to view