{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Clinical_Services_Request_","Contracting_&_Procurement_Requ","Corporate_Services_Request_","Finance_Request_","Human_Resources_Request_"],"not_rendered":{"images":13},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Clinical_Services_Request_","index":0,"n_rows":46,"n_cols":3,"rows_kept":46,"flags":["formulas_cached_only"]}
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 04","Clinical Services","How many children are on the waiting list to visit the Trusts Children Dental Hospital etc."]
["FOI 07","Clinical Services","AMH inpatient - 5 longest delays, age, reason for admission, reason for delay, date ready for discharge, date discharged. Beds occupied ready for discharge, % overall beds, open extra transitional, Reablement or similar beds to meet the additional demand caused by delayed discharges etc."]
["FOI 19","Clinical Services","Does Trust operate foot protection service (NICE Guideline - diabetes), if yes state number podiatrists/ orthotics etc."]
["FOI 23","Clinical Services","Parent training for ADHD - who provides it, what proportion of children received it, how long after referral was it offered"]
["FOI 24","Clinical Services","Referrals for eating disorders - BMI as a primary indicator, refer patients, what is the threshold, has it changed in the last 5 years, average wait time from GP referral to first appointment"]
["FOI 41","Clinical Services","Community dental service - how many were provided, tendering since 2016, area covered, agreements and contract, public health needs assessments, headcount etc"]
["FOI 46","Clinical Services","Securing the contents of resus trolleys"]
["FOI 52","Clinical Services","OPMH - ratio inpatient/community, number of AHP, bed provisions, last review OPMH"]
["FOI 53","Clinical Services","number of under 25s admitted for mental health related issues in the past 3 years, broken down by month"]
["FOI 57","Clinical Services","136 suite/ places of safety policy & local protocols for exclusion clauses"]
["FOI 78","Clinical Services","supply of insulin pumps to patients with diabetes, if yes what types etc. Last 12 months what % of patients had a pump for the first time"]
["FOI 94","Clinical Services","LD liasion nurses, total number and pay banding, when was 1st one appointed, job descriptions"]
["FOI 99","Clinical Services","Number of deaths per year since 2000 from GA for Dental - age of patients"]
["FOI 100","Clinical Services","List of inpatient mental health wards"]
["FOI 109","Clinical Services","Waiting times for women choosing to have abortions"]
["FOI 120","Clinical Services","X-ray equipment used within the Trust"]
["FOI 124","Clinical Services","The implementation of Routine Enquiry"]
["FOI 127","Clinical Services","Early Intervention in Psychosis services"]
["FOI 141","Clinical Services","Adaptations to the HCR20 risk scoring tool"]
["FOI 151","Clinical Services","Schizophrenia - out of area referrals, to what NHS providers, how many patients, average length of inpatient, cost inccured etc. "]
["FOI 164","Clinical Services","Treatment of headaches and chronic migraines"]
["FOI 167","Clinical Services","Staff working within CAMHS services"]
["FOI 168","Clinical Services","The possible adaptation of the HCR20 and the Prevention Policy"]
["FOI 177","Clinical Services","Prescribing valproate for bipolar disorder"]
["FOI 180","Clinical Services","Dementia Inpatient Services"]
["FOI 182","Clinical Services","Long stay inpatient rehabilitation units"]
["FOI 193","Clinical Services","Chlamydia campaigns"]
["FOI 195","Clinical Services","HIV figures for heterosexual and homosexual males"]
["FOI 196","Clinical Services","Inpatient beds and the total number of patient restraints"]
["FOI 198","Clinical Services","Sending AMH patients out-of-area"]
["FOI 199","Clinical Services","Incidents of restraint and restrictive intervention training"]
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 200","Clinical Services","Mothballed wards"]
["FOI 204","Clinical Services","CAMHS and AMH transfers"]
["FOI 205","Clinical Services","Idiopathic Pulmonary Fibrosis"]
["FOI 213","Clinical Services","CAMHS referral breakdown"]
["FOI 217","Clinical Services","Dictation and audio typing services "]
["FOI 218","Clinical Services","Private patient spend"]
["FOI 219","Clinical Services","CRHT referrals"]
["FOI 228","Clinical Services","Self-referral for children and young people with eating disorders"]
["FOI 257","Clinical Services","Flu vaccinations given in schools"]
["FOI 268","Clinical Services","Bookings made and missed on specific days in February 2018"]
["FOI 271","Clinical Services","Breaches in collections of AMH patients"]
["FOI 287","Clinical Services","General anaesthesia paediatric dental waiting times"]
["FOI 294","Clinical Services","Updated CAMHS referral breakdown"]

{"sheet":"Contracting_&_Procurement_Requ","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"flags":["formulas_cached_only"]}
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 26","Contracting & Procurement","Total amount spent on contracts with The Priory Group by year 2012, spend on contracts with groups/ consortia including The Priory Group."]
["FOI 145","Contracting & Procurement","The structure of Solent’s organisation"]
["FOI 238","Contracting & Procurement","Board approved GS1 and PEPPOL adoption plan"]
["FOI 289","Contracting & Procurement","EPR and Finance software"]

{"sheet":"Corporate_Services_Request_","index":2,"n_rows":112,"n_cols":3,"rows_kept":112,"flags":["formulas_cached_only"]}
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 08","Corporate Services","What patient administration systems do you use, plans to replace, integration software for third parties, data warehouse for activity informatics"]
["FOI 11","Corporate Services","Details of all clinical service incidents caused by estates and infrastructure failure at the Trust 2016/17"]
["FOI 15","Corporate Services","System used to manage FOI requests, solution contract and annual costs. "]
["FOI 17","Corporate Services","Details of the contents of the courses that are undertaken by security staff and any restraints that security staff and any restraints that security staff have put upon them  with regards to the handling of patients "]
["FOI 21","Corporate Services","IT systems and suppliers - pharmacy, electronic patient record, patient administration and electronic prescribing system"]
["FOI 22","Corporate Services","IT team and infrastructure information"]
["FOI 30","Corporate Services","Has the trust appointed a  DPO, if yes job description, if no has there been discussions and what papers have been sent to teams plus copy of these papers"]
["FOI 31","Corporate Services","Organisation energy efficiency - EPC certificate, floor area, energy consumed, energy cost"]
["FOI 32","Corporate Services","has the contract for refurbishment to block B, St Marys Community Health Campus tendered 12/08/2016 been awarded and if so who?"]
["FOI 33","Corporate Services","Webfiltering solution, who is it purchased through, how many users, contract value, web filtering contract expiry etc."]
["FOI 34","Corporate Services","Name (CCIO/ CSO), decives affected by recent cyber attack, prevention of attacks, is there a managed service etc."]
["FOI 35","Corporate Services","WannaCry Ramsomeware - did the Trust shut down any IT systems, how many were affected, any planned appointments/opreations cancelled, SI in relation to the attach, impact on clinical care, patch information"]
["FOI 36","Corporate Services","what is the contract in place for Adult Mental health Services and the quality and level of service being paid for on behalf of Portsmouth residents?"]
["FOI 37","Corporate Services","Eating disorder inpatient service, CAMHS, Adults, how many beds, how far from Trust area"]
["FOI 39","Corporate Services","Total amount spent on upgrading computers for Wannacry ransomware, computers that are running on Windowns XP"]
["FOI 40","Corporate Services","Full name, title and email address of ICT manager/ service manager within Patient Technologies or ICT Technology departments"]
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 42","Corporate Services","Medicine useage for specifics last 5 years, quantity used and pack size"]
["FOI 45","Corporate Services","Name of Head of Research and Head of Performance"]
["FOI 48","Corporate Services","The total number of Serious Incidents "]
["FOI 59","Corporate Services","contact email for purchasing department"]
["FOI 60","Corporate Services","Gifts and hospitality register"]
["FOI 62","Corporate Services","Car parking sites, spaces, managed by, patterns of use etc"]
["FOI 71","Corporate Services","Patients aged 65+ discharged between 22:00-06:00 each month 1st Jan 16 - 31st Dec 2016, number of patients discharged to their homes, nursing home, rehab etc. "]
["FOI 72","Corporate Services","Car parking charges at the Western and Moorgreen hospital"]
["FOI 73","Corporate Services","Reams of paper procured 2016/17, NHS supply chain information"]
["FOI 75","Corporate Services","Bed days lost 16/17 for decontamination, hydrogen perozide vaporising fogging machines used, decontamination regularity, down time post decontamination"]
["FOI 76","Corporate Services","Number of assaults (on staff, patients, staff on patient, staff on staff) for the years 2012-2017 with decription of assault"]
["FOI 77","Corporate Services","name of procurement manager and IT manager"]
["FOI 79","Corporate Services","Status of pharmacy provisions"]
["FOI 80","Corporate Services","Who supplies us with labels, contract information and spend"]
["FOI 83","Corporate Services","Data on repairs and servicing of alternating mattress systems"]
["FOI 86","Corporate Services","Name of IT and information security lead and person responsible for GDPR, number on contractors in these areas"]
["FOI 87","Corporate Services","Solent NHS Trust's fleet of vehicles and related information"]
["FOI 93","Corporate Services","Name and email of specific individuals (directors)"]
["FOI 95","Corporate Services","Contract information relating to courier services"]
["FOI 101","Corporate Services","Use of physical restraint, impact of restraint, etc. "]
["FOI 105","Corporate Services","Copy of IG structure (bandings), SLA, policy for SAR/ FOI etc"]
["FOI 108","Corporate Services","Mobile phone usage and airtime"]
["FOI 110","Corporate Services","Management and contract of print services"]
["FOI 112","Corporate Services","Data or supplier information from Procurement to Pay, Accounts Payable and Contract Repository sources "]
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 118","Corporate Services","Details on staff members responsible for processing requests made under DPA and FOI Acts"]
["FOI 119","Corporate Services","Compliance with NHS Improvement Letter, and fire safety checks since Grenfell Tower"]
["FOI 121","Corporate Services","Searches on inpatients and incidents involving weapons and sharps."]
["FOI 123","Corporate Services","ATM contracts"]
["FOI 129","Corporate Services","Disability and Mobility suppliers"]
["FOI 133","Corporate Services","How many endpoints in the Trust are using Windows XP etc"]
["FOI 140","Corporate Services","Levels of security currently on mobile devices"]
["FOI 144","Corporate Services","Types of contracts"]
["FOI 146","Corporate Services","Contract information relating to courier services"]
["FOI 147","Corporate Services","Tender details"]
["FOI 149","Corporate Services","Does the Trust have a policy on patient requesting a second opinion from another Trust, or guidelines when discharging a patient from secondary care back to primary care"]
["FOI 150","Corporate Services","CAMHS 2015-16/ 2016/17: referrals etc. - overall CAMHS budget and waiting time "]
["FOI 152","Corporate Services","Haemostat product useage"]
["FOI 154","Corporate Services","IT service management, contract info, ITSM tool cost, etc"]
["FOI 156","Corporate Services","Revenue from charging of hospital car parking in 2016"]
["FOI 161","Corporate Services","Aggressive and violent incidents information"]
["FOI 162","Corporate Services","Violent incidents involving lone workers"]
["FOI 163","Corporate Services","Clinical coding"]
["FOI 165","Corporate Services","Mental Health Inpatient beds"]
["FOI 169","Corporate Services","CIO and CCIO positions"]
["FOI 170","Corporate Services","Details on trust fires"]
["FOI 175","Corporate Services","Waiting times for mental health services"]
["FOI 183","Corporate Services","Use and funding of health apps"]
["FOI 185","Corporate Services","Communications contracts"]
["FOI 187","Corporate Services","Incidents and reports in relation to care at the Sexual Assault Referral Centre"]
["FOI 188","Corporate Services","Tender opportunities"]
["FOI 189","Corporate Services","Cyber security"]
["FOI 190","Corporate Services","Purchasing paint"]
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 192","Corporate Services","Update and validation of data already held"]
["FOI 201","Corporate Services","Information on medical equipment"]
["FOI 202","Corporate Services","The Director of Estates and/or Sustainability"]
["FOI 208","Corporate Services","Security seals and tamper-evident products"]
["FOI 211","Corporate Services","Portal and system uses"]
["FOI 212","Corporate Services","Assault figures"]
["FOI 214","Corporate Services","Super Recognisers International' company or subsidiaries"]
["FOI 215","Corporate Services","Fixed telecommunications and internet services"]
["FOI 221","Corporate Services","Contracts with Acquascience"]
["FOI 222","Corporate Services","Trust's facilites and contracts"]
["FOI 223","Corporate Services","The Trust's procurement function"]
["FOI 224","Corporate Services","Fax machines"]
["FOI 225","Corporate Services","Cloud First policy and public cloud uses"]
["FOI 235","Corporate Services","Equipment for bariatric patients"]
["FOI 236","Corporate Services","A breakdown of the high-risk and significant-risk backlog maintenance logs"]
["FOI 237","Corporate Services","The HHR/CHIE process of uploading data "]
["FOI 241","Corporate Services","Complaints about technology"]
["FOI 245","Corporate Services","Contact details of staff fulfilling certain roles"]
["FOI 246","Corporate Services","Digital dictation and voice recognition technology"]
["FOI 247","Corporate Services","Electricity, gas and water suppliers"]
["FOI 249","Corporate Services","Social media spend"]
["FOI 250","Corporate Services","EPR Systems"]
["FOI 251","Corporate Services","Cyber Security"]
["FOI 254","Corporate Services","Clinical waste bags"]
["FOI 255","Corporate Services","Incidents involving staff"]
["FOI 256","Corporate Services","Copies of Operations Policy for Self-Harm and Suicide, and Clinical Risk Assessment Policy"]
["FOI 259","Corporate Services","Print services"]
["FOI 270","Corporate Services","Complaints made by the LGBT community"]
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 273","Corporate Services","Income generated from hospital parking"]
["FOI 274","Corporate Services","Procurement legal challenges"]
["FOI 275","Corporate Services","Pharmacy supplier details"]
["FOI 276","Corporate Services","Elections to the Trust's Concil of Governors"]
["FOI 277","Corporate Services","Names and email addresses of senior members of staff"]
["FOI 278","Corporate Services","EPR Systems"]
["FOI 282","Corporate Services","Number of disposable drinking cups purchased in the last 5 years"]
["FOI 286","Corporate Services","Medical Records digitisation process"]
["FOI 290","Corporate Services","Walking frame purchases"]
["FOI 292","Corporate Services","Risk, Training and Compliance systems used"]
["FOI 293","Corporate Services","Surveillance cameras"]

{"sheet":"Finance_Request_","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"flags":["formulas_cached_only"]}
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 02","Finance","The cost of treating accident victims, including the process for recovering money owed from third parties"]
["FOI 06","Finance","Patients who are fit to leave hospital but are unable to be discharged safely, delayed care packages due to lack of staffing in community, agency spend between March 2016 to date for nursing services within the community. "]
["FOI 18","Finance","Contract information - Banking services, audit services and card processing services"]
["FOI 20","Finance","List of nursing agencies currently utilised for nursing care staff, spend data for agencies, off framework agencies supplied staff FY16/17"]
["FOI 66","Finance","Frequently asked questions - Staffing/ EPS/ Agency spend"]
["FOI 68","Finance","Agency spend May 2016 - present for cardiology department"]
["FOI 88","Finance","Solent NHS Trust's overall financial spend"]
["FOI 97","Finance","Itemise each supplier and fees for consultancy services"]
["FOI 130","Finance","Losses and special payments"]
["FOI 131","Finance","Agency spend 2016/17"]
["FOI 160","Finance","Numbers of and cost of apprenticeships"]
["FOI 166","Finance","HR and Finance business systems"]
["FOI 171","Finance","Mental healthcare agency staff spend"]
["FOI 197","Finance","Cost of producing and printing annual reports and accounts"]
["FOI 239","Finance","Finance information and recruitment of nurses"]
["FOI 240","Finance","Amount of income received from CCGs and NHS England"]
["FOI 253","Finance","Radiography reporting"]
["FOI 263","Finance","Spend on locum staff in the last two years"]
["FOI 266","Finance","Spend on locum staff from 2016-2017"]
["FOI 281","Finance","Trust transactions over £25,000 from May 2017 to January 2018"]
["FOI 285","Finance","Broken-down total costs of employment"]

{"sheet":"Human_Resources_Request_","index":4,"n_rows":29,"n_cols":3,"rows_kept":29,"flags":["formulas_cached_only"]}
["Referrance Number  ","Publication Scheme categories","FOI Description"]
["FOI 12","HR","Start and finish dates 2014-2017 - Chair, CE, Finance, Medical, Nursing Directors, COO"]
["FOI 58","HR","Confirm leadership roles"]
["FOI 81","HR","Staff short/ long term sick due to mental health issues 2012 - date, staff leavers total and leavers due to mental health issues"]
["FOI 82","HR","How many illegal immigrants do we employ (nationality, position, length of employment)"]
["FOI 89","HR","Trust expediture on recruitment advertising"]
["FOI 96","HR","Staff car parking, 5 highest paid members of staff (wages and job titles), spend on marketing and public relations 15-17"]
["FOI 104","HR","Individuals working off payroll via their own limited company, etc"]
["FOI 115","HR","Facilities and esates information and staff information"]
["FOI 122","HR","Nursing shifts sent to agencies "]
["FOI 139","HR","Recruitment of nurses in calendar year 2016"]
["FOI 143","HR","Nursing staff sick days and staffing numbers"]
["FOI 148","HR","Unfilled shifts and locum expenditure for last 3 financial years "]
["FOI 158","HR","Staff sick leave for stress-related illnesses"]
["FOI 172","HR","Permanent and non-permanent staff figures"]
["FOI 173","HR","Sexual harassment figures"]
["FOI 178","HR","HR and payroll systems"]
["FOI 179","HR","NMC approved mentor preparation programmes"]
["FOI 181","HR","Non mandatory training and apprenticeships"]
["FOI 220","HR","Banding and personnel data"]
["FOI 227","HR","Advanced job titles"]
["FOI 229","HR","Bank suppliers"]
["FOI 232","HR","Organisation's structural chart and managers"]
["FOI 234","HR","Specialising enhanced care services"]
["FOI 242","HR","Frameworks for sourcing agency staff"]
["FOI 264","HR","Bank staff IT and roster providers"]
["FOI 272","HR","NHS whisteblower empowerment support schemes"]
["FOI 280","HR","Staff compliance with appraisals and staff vacancies available for the last 12 months"]
["FOI 284","HR","Speak Up Guardians"]