Spreadsheet: 165218d1341097813-creating-a-calendar-between-2-variable-dates-to-a-specific-format-database-example
Sheet: Sheet2

Database Identifier | Surname | First Name | Hospital Number | NHS Number | Date of Birth | Age |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total number of ward transfers | Total number of Consultant transfers | Analysis
 |  |  |  |  |  | 41097
Database Identifier | Date of Admission | Admission Time | Day of Admission | Length of Stay | Source of admission | Admitted via | Number of previous emergency admissions in a year | Duration of symptoms at home
0 | 07/06/2012 |  | Thu | 30
Database Identifier | Admitting Consultant | Admitting Specialty | Admitting Subspeciality | Admitting Directorate | Ward transfer 1 | Date of Transfer 1 | Transferred Consultant 1 | Transferred Specialty 1 | Transferred Sub-specialty 1 | Transferred Directorate 1 | Ward transfer 2 | Date of Transfer 2 | Transferred Consultant 2 | Transferred Specialty 2 | Transferred Sub-Specialty 2 | Transferred Directorate 2 | Ward transfer 3 | Date of Transfer 3 | Transferred Consultant 3 | Transferred Specialty 3 | Transferred Sub-Specialty 3 | Transferred Directorate 3 | Ward transfer 4 | Date of Transfer 4 | Transferred Consultant 4 | Transferred Specialty 4 | Transferred Sub-specialty 4 | Transferred Directorate 4 | Ward transfer 5 | Date of Transfer 5 | Transferred Consultant 5 | Transferred Specialty 5 | Transferred Sub-Specialty 5 | Transferred Directorate 5 | Ward transfer 6 | Date of Transfer 6 | Transferred Consultant 6 | Transferred Specialty 6 | Transferred Sub-Specialty 6 | Transferred Directorate 6
0
Database Identifier | [NAME] triggered | A&E clerking quality | Senior Review made | Senior Review Impression | Senior Review Management | Referred to: | Time referred:
0
Database Identifier | A&E Diagnosis 1 | A&E Diagnosis 2 | A&E Diagnosis 3 | A&E Diagnosis 4 | A&E Treatment 1 | A&E Treatment 2 | A&E Treatment 3 | A&E Treatment 4
0
Database Identifier | Speciality time seen: | If on Integrated Care Pathway state which | Speciality clerking quality | Investigations documented (Bloods, Xray, ECG, ABG, Urinalysis) | Senior Review made | Senior Review Impression | Senior Review Management
0
Database Identifier | Specialty diagnosis 1 | Specialty diagnosis 2 | Specialty diagnosis 3 | Specialty diagnosis 4 | Specialty treatment 1 | Specialty treatment 2 | Specialty treatment 3 | Specialty treatment 4
0
Database Identifier | Time seen on Consultant PTWR | Consultant impression | Consultant management
0
Database Identifier | Comorbidity 1 | Comorbidity 2 | Comorbidity 3 | Comorbidity 4 | Comorbidity 5 | Comorbidity 6 | Comorbidity 7 | Comorbidity: other
0
Database Identifier | Notable events, investigations and treatments
0
Database Identifier | Drug Charts Comments |  |  |  | Observation Charts Comments
0
Database Identifier | Communication and Documentation comments
0
Database Identifier | Admission for Palliative Care | Appropriate for Palliative Care | Referred to Palliative Care Team | Date Referred to Palliative Care Team | Seen by Palliative Care Team | Date Seen by Palliative Care Team
0
Database Identifier | LCP started? | LCP not started but suitable | LCP incomplete? | How is LCP incomplete? | LCP date commenced | LCP time commenced | Name of Healthcare professional documenting the LCP MDT decision | Grade of Doctor signing LCP | Endorsed by Senior Healthcare professional responsible for patient's care | How long after starting LCP did patient die?
0 |  |  |  |  | 27/06/2012  21:18:00 | 12:00:00 |  |  |  | 9 days 17  hours 45 minutes
Database Identifier | DNAR status | DNAR Patient made not for intubation and ventilation/ITU by ITU team | DNAR ceiling of care applied | Date of DNAR | DNAR Number of days to DNAR being completed | DNAR Decision Name of Doctor | DNAR Decision grade of doctor | DNAR Decision Specialty | Discussion with patient/carers/other healthcare members | DNAR Grade of other member of health team discussed with | DNAR Grade of doctor completing | DNAR Review and endorsement completed | DNAR Documentation in notes of decision and discussion | DNAR comments
0 |  |  |  | 29/06/2012 | 22
Database Identifier | Date of death | Time of death | Death cert 1a | Death cert 1b | Death cert 1c | Death cert 2 | Death discussed with Coroner | For Coroner's PM | For Hospital PM | [NAME] | Review cause of death | Coding | Review coding suggestion | Coding for final admission | Avoidable Death? | Concerns re death
0 | 07/07/2012 | 05:45:00
 |  |  |  |  |  |  | #REF!