DHS Power Insight Reports for COVID-19

Firstnet Disaster Quick Registration
Data Dictionary
This Power Insight report counts the number of disaster patients arriving to the emergency departments and FirstNet urgent cares each day.
Inclusion criteria:

FirstNet patient
"Disaster Tracking" field in the ED Quick Registration or Urgent Care Quick Registration field is not blank

User-selectable prompts

Date of arrival
Tracking group
Value in "Disaster Tracking" field
ED Disposition
ARRIVAL MODE
Instructions

In Power Insight → ED Urgent Care Folder

In the "Disaster Tracking" field, choose the disaster of interest (eg "Disaster 1" or "COVID Possible") If you choose "All", you will see all ED patients, not just those marked as Disaster Here is a sample of prompt entries that will return all HAR patients registered to the Disaster 1 and COVID Possible disaster for yesterday and today:


Three sheets, in excel format:
"Summary All" one row per date of arrival, sorted by date of arrival, with total number at bottom

Number of patients Number of discharges: This will include patients with the following dispositions

Percent discharged
Number admitted: This will include patients with the following disposition:
Admit as Inpatient-This Hospital
Percent admitted
Number Transferred: This will include patients with the following dispositions
Acute Care Hospital-Transfer
Children's or Cancer Hospital

Percent transferred
Number with no ED disposition
Percent with no ED disposition
Number of patients by each "arrival mode", bucketed in the following groups:
Transported
Ambulance
Helicopter
Law Enforcement
SelfArrival
Auto
Other
Public Transportation
Unknown
Walked
Wheelchair
Number of patients by each choice in the "Disaster Tracking" field

"Summary by Location": same as above but a separate section for each tracking group

Details": One row per included patient
MRN
FIN
Date/Time of Arrival
Contents of "Disaster Tracking:" field [Last if more than one update]
Contents of "Prehospital Disaster Tag Number" field [Last if more than one update]
Contents of "Hospital Disaster Tag Number" fIeld [Last if more than one update]
ED Disposition [Based on collapsed categories described above]
Date/Time of ED/Departure
Tracking Group
ARRIVAL MODE
Arrival group (SELFARRIVAL vs TRANSPORTED]
Medical Service (Last)
Age in years at time of visit
Downtime Quick Reg? [Yes or no?]
Name of person performing the conversation
Picture of the ED Quick Registration Conversation

Report created 3/25/2020
Data dictionary updated 4/1/2020
Rfleischman@dhs.lacounty.gov