Database paper - GoogleCode

looneyvillestaticΛογισμικό & κατασκευή λογ/κού

15 Αυγ 2012 (πριν από 5 χρόνια και 2 μήνες)

309 εμφανίσεις

Group Members


Brandon Authement

Andrew Carver

Michael Maley

Joseph Mohr

Sandra Weber





















Meetings

11/7



Discussed

and started building Erwin, Logical and Physical



All where here

11/14



Michael Maley

started working on Interface



Brandon
Authement and Michael Maley were here



Rest meet up during class

11/16



Modified interface, finished logical Erwin,



All five showed up

11/21



Continued to modify Interface, worked on database, and finished physical Erwin



All five meet up

11/23



Worked on data
base
, and documentation



Brandon Authement,
Joseph Mohr
,
Sandra Weber

showed up














Member
Presentation
Respo
ns
ibilities



Brandon Authement
-

Physical structure

Andrew Carver
-

client web site design

Michael Maley
-

menu design

Joseph Mohr
-
, database

system

Sandra Weber
-

schema



















Member Respo
ns
ibilities


Brandon Authement


Helped with Erwin, Printing and keeping Documentation

Andrew Carver
-

Converted NetBeans Database to C
-

Sharp

Michael Maley
-

Made first attempt at Interface with
NetBeans

Joseph Mohr
-

Constructed tables in database, populated tables with records

Sandra Weber
-
Helped with organization and
schema
, CSS styling on web pages





















Description of data entry menu

The Data Entry Menu is web based and will have

six main areas that will be filled out in order. Each
one deals with a part of the patient or the creator of the entry. They are:

1)

General Info


deals with the user and info on creation of the entry.



Name


the name of the logged in user who create the
entry.



date/time


the date and time of when the user created the entry .



county


county the response occurs in.



unit number


the number of the responding unit to be dispatched.

2)

Patient Info


contains the data to store for the patient and their stats.



Age


Age of the patient.



Gender


gender of the patient.



Alert and oriented


a scale of lucidity of the patient



Blood pressure



Pulse



Respirations



O2 Saturation



Category


the type of injury/complaint



Chief Complaint


the problem of the patient



Loss of
Consciousness


notes if the patient has lost consciousness or not



Glasgow Coma Scale



Blood Glucose Level

3)

Vehicular Accident
-




Type


the vehicle involved in the accident



More than one patient


checked if multiple patients came from the same accident



driver restrained



passenger restrained
-

where the patient was located and if they were restrained



speed



ejected



entrapped



rollover



Helmet



Airbag



Packaged

4)

Alerts


specific high priority problems and information on the patient



Trauma
-




stroke



onset



STEMI



Resuscitated



Time issued by rescue



History


prior conditions of the patient



Treatment


prescribed medications



Dispatcher



Notified



ETA


estimated time of arrival of the patient to the hospital

5)

Medical Detail


extra information dealing with the patient and his/her location



Cardiac Red


denotes if the patient is showing signs of heart attack



Medical detail


custom information dealing with the patient and his/her treatment



Level


floor of the location



TC
-
ER
-
PE
DS


location the patient is to be sent to

6)

Medical Control


information dealing with the doctor, prescriptions, and rescuing units



Rescue


unit that was dispatched



Medication


prescribed medicine for the patient



Doctor Signature


electronic signature o
f the attending Doctor



Medical Number
-




Narcotics
-



**All blank entries are simple yes/no entries denoting if they have happened.




















Structure of the attributes used in reporting



Created By
: The user that logs into system with dispatcher account. Last name for the dispatcher 20
characters long. Auto filled from user login.

Created Date
: Date entered from calendar or by user

Created Time
: System time in am or pm

County
: List of counties fo
r selection (LIST)

Unit
: List of unit numbers for each county. The unit list depends on county name. (LIST)

Patient Status

Age
: 3 digits numeric data entry box.

*Age type
: A list of Year, Months and Days with default value year

Sex
: Male or Female (LIST)

A&O X
: Alert and Oriented X’s
-

One digit numeric list box with values of 4, 3, 2, 1, 0 (LIST)

B/P:
Blood Pressure
-

two numeric boxes for blood pressure (3 digits data entry each). First box for
maximum (Systolic) and second box
for minimum (Diastolic) blood pressure

Pulse
: 3 digits numeric data entry box

Resp
: Respirations
-

2 digits numeric data entry box

O2 Sat%
: Oxygen Saturation %
-

three digits numeric list box with values (100 to 70) (LIST)

*Category
: List of category m
ay be fifty characters. (LIST) Values are similar to the Excel sheet category
values with data entry options.

*CC
: Chief Complaint
-

List of text values may be 100 characters. (LIST) Values are similar to the Eexcel
sheet CC with the option of data entry.

Second group of repeated control boxes are the same as above B/P, Pulse, Resp and O2 Sat%

B/P:
Blood Pressure
-

two numeric boxes for blood pressure (3 digits data entry each). First box for
maximum (Systolic) and second box for minimum (Diastolic) blood pressure

Pulse
: 3 digits numeric data entry box

Resp
: Respirations
-

2 digits numeric data entry box

O2 Sat%
:

Oxygen Saturation %
-

three digits numeric list box with values (100 to 70) (LIST)

LOC
: Loss of Consciousness
-

text list box with values (Yes, No, or Unknown) (LIST)

CGS
: Glasgow Coma Scale
-

two digits numeric list box with values of 15, 14, ... 3 (LI
ST)

BGL#1
: Blood Glucose Level
-

3 digits numeric data entry box

BGL#2
: Blood Glucose Level
-

3 digits numeric data entry box

Vehicular Accident

List of category may be fifteen characters long with values of: MVC, MCC, ATV, Bicycle, Pedestrian, Boat
/
JetSki (LIST)

Multiple Patient Screening
: New tab with a list with values Yes or No (Check List)

Driver
: A list with values Unrestrained or Restrained (LIST)

Passenger
: A list with values Front Unrestrained, Front Restrained, Rear Unrestrained or Rear R
estrained
(LIST)

Speed
: 3 digits numeric data entry box

Ejected
: A list with values Yes or No (Check List)

Entrapped
: A list with values Yes or No (Check List)

Rollover
: A list with values Yes or No (Check List)

Helmet
: A list with values Yes or No (C
heck List)

Airbag
: A list with values Yes or No (Check List)

Packaged
: A list with values Yes or No (Check List)

ALERTS Area

Trauma Alert
: A list with values Yes or No (Check List)

Stroke Alert
: A list with values Yes or No (Check List)

Onset
: The time for the first incident of Stroke
-

Time in am or pm as data entry

STEMI
: A list with values Yes or No (Check List)

*Resus:
Resuscitation of the injured person with values Yes or No (Check List)

Time Issued by Rescue
: The time that STEMI is ca
lled
-

Time in am or pm as data entry

History
: List of problems may be seven characters long with values of: Asthma, COPD, CARDIAC, HTN,
DM, SZ, CVA, or CA (LIST)

Treatment
: List of care may be five characters long with values of: O2, NEB, D50, NITRO, AS
A, or IV (LIST)

Disp
: Dispatcher
-

name of the dispatcher logged into the system. The name of dispatcher in this box can
be changed by the name of the other dispatchers logged on to the system at the same time if there is a
special case.

*Notified
: A lis
t with values Yes or No (Check List)

*ETA
: Estimated Time of Arrival
-

two digits numeric list box with values of 0, 1, ..., 60 minutes or
seconds (LIST) A new list with values of minutes (default) and seconds can be created next to 0 to 60
with default v
alue minutes.

MEDICAL DETAIL Area

Add a new drop down list with the title
Cardiac Red
.

*Cardiac Red
: A list with values Yes or No (Check List)

Medical Detail
: A text area with memo or 255 characters to enter medical information

Level
: One position cha
racter as list with values of: 1, 2, 3 and T (LIST)

TC
-
ER
-
PEDS
: A combined field for a drop down list with values of ER, TC, PEDS, Cath Lab, L&D, or Floor
(LIST)

Rescue
: Unit number described above

*Meds
: Medication


the names of medications as list an
d data entry (50) characters

Dr. Sign
: The name of the doctor typed in a text data entry field of 20 characters

*DEA#
: Medical number typed in a text data entry field of 15 characters

NARC
: A list with values Yes or No (Check List)




















Erwin Diagrams




SQL Create Statements

CREATE TABLE [dbo].[Medication](


[MedicationID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[MedicationName] [varchar](20) NULL,


CONSTRAINT [PK_Medication] PRIMARY KEY CLUSTERED

(


[MedicationID] ASC

)WITH
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



CREATE TABLE [dbo].[County](


[CountyID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[CountyName] [varchar](3
6) NULL,


CONSTRAINT [PK_County] PRIMARY KEY CLUSTERED

(


[CountyID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]


CREATE TABLE [dbo].[ChiefCom
plaint](


[ChiefComplaintID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[ChiefComplaintName] [varchar](50) NULL,


CONSTRAINT [PK_ChiefComplaint] PRIMARY KEY CLUSTERED

(


[ChiefComplaintID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_
DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



CREATE TABLE [dbo].[Category](


[CategoryID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[CategoryName] [varchar](50) NULL,


CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED

(


[CategoryID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]


CREATE TABLE [dbo].[History](


[H
istoryID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[HistoryName] [varchar](20) NULL,


CONSTRAINT [PK_History] PRIMARY KEY CLUSTERED

(


[HistoryID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, AL
LOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]





CREATE TABLE [dbo].[VehicleAccident](


[VehicleAccidentID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[VehicleName] [varchar](50) NULL,


CONSTRAINT [PK_VehicleAccident] PRIMARY KEY CLUSTERED

(


[VehicleAccidentID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



CREATE TABLE [dbo].[User](


[UserId] [uniqueidentifier] NOT NULL,


[UserType]

[int] NOT NULL,


[UserName] [varchar](20) NOT NULL,


[Password] [char](40) NOT NULL,


[LoggedIn] [bit] NOT NULL,


[FirstName] [varchar](20) NOT NULL,


[LastName] [varchar](20) NOT NULL,


[Email] [varchar](36) NOT NULL,


CONSTRAINT [PK_User_1] PRIMARY KEY
CLUSTERED

(


[UserId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]


CREATE TABLE [dbo].[Unit](


[UnitID] [numeric](18, 0) IDENTITY(1,1) NOT NUL
L,


[UnitCounty] [numeric](18, 0) NOT NULL,


[UnitName] [varchar](20) NULL,


CONSTRAINT [PK_Unit] PRIMARY KEY CLUSTERED

(


[UnitID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS
= ON) ON [PRIMARY]

) ON [PRIMARY]






CREATE TABLE [dbo].[Report](


[ReportId] [uniqueidentifier] NOT NULL,


[CreatedBy] [uniqueidentifier] NOT NULL,


[CreatedDate] [date] NOT NULL,


[County] [numeric](18, 0) NULL,


[Unit] [numeric](18, 0) NULL,


[Age] [n
umeric](3, 0) NULL,


[Sex] [varchar](50) NULL,


[AOX] [numeric](1, 0) NULL,


[BP1Systolic] [numeric](3, 0) NULL,


[BP1Diastolic] [numeric](3, 0) NULL,


[BP2Systolic] [numeric](3, 0) NULL,


[BP2Diastolic] [numeric](3, 0) NULL,


[Pulse1] [numeric](3, 0) NULL
,


[Pulse2] [numeric](3, 0) NULL,


[Respiration1] [numeric](2, 0) NULL,


[Respiration2] [numeric](2, 0) NULL,


[O2Sat1] [numeric](3, 0) NULL,


[O2Sat2] [numeric](3, 0) NULL,


[Category] [numeric](18, 0) NULL,


[ChiefComplaint] [numeric](18, 0) NULL,


[GCS]

[numeric](2, 0) NULL,


[VehicleAccident] [numeric](18, 0) NULL,


[MultiPatient] [bit] NULL,


[Driver] [varchar](12) NULL,


[Passenger] [varchar](18) NULL,


[Speed] [numeric](3, 0) NULL,


[Ejected] [bit] NULL,


[Entrapped] [bit] NULL,


[Rollover] [bit] NUL
L,


[Helmet] [bit] NULL,


[Airbag] [bit] NULL,


[Packaged] [bit] NULL,


[TraumaAlert] [bit] NULL,


[StrokeAlert] [bit] NULL,


[Onset] [time](0) NULL,


[STEMI] [bit] NULL,


[Resuscitated] [bit] NULL,


[TimeIssuedByRescue] [time](0) NULL,


[History] [numeric
](18, 0) NULL,


[Treatment] [numeric](18, 0) NULL,


[Dispatcher] [uniqueidentifier] NULL,


[ETA] [numeric](2, 0) NULL,


[CardiacRed] [bit] NULL,


[MedicalDetail] [varchar](255) NULL,


[Level] [varchar](1) NULL,


[TCERPEDS] [numeric](18, 0) NULL,


[Medication] [numeric](18, 0) NULL,


[DrSignature] [varchar](20) NULL,


[DEANo] [varchar](15) NULL,


[NARC] [bit] NULL,


[AgeYears] [bit] NULL,


[AgeMonths] [bit] NULL,


[AgeWeeks] [bit] NULL,


[Notified] [bit] NULL,


[LOC] [bit] NULL,


[AwakeOriented] [bi
t] NULL,


CONSTRAINT [PK__Report__D5BD48055535A963] PRIMARY KEY CLUSTERED

(


[ReportId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]


CREATE TA
BLE [dbo].[Destination](


[DestinationID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[DestinationName] [varchar](20) NULL,


CONSTRAINT [PK_Destination] PRIMARY KEY CLUSTERED

(


[DestinationID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGN
ORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]


CREATE TABLE [dbo].[Treatment](


[TreatmentID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,


[TreatmentName] [varchar](20) NULL,


CONSTRAINT [PK_Treatment] PRIMARY KEY CLUSTERED

(


[TreatmentID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]




SQL Inserts


SET
IDENTITY_INSERT [dbo].[Medication] ON

INSERT [dbo].[Medication] ([MedicationID], [MedicationName]) VALUES (CAST(1 AS Numeric(18, 0)), N'Tylenol')

INSERT [dbo].[Medication] ([MedicationID], [MedicationName]) VALUES (CAST(2 AS Numeric(18, 0)), N'Morphine')

I
NSERT [dbo].[Medication] ([MedicationID], [MedicationName]) VALUES (CAST(3 AS Numeric(18, 0)), N'Adrenaline')

SET IDENTITY_INSERT [dbo].[Medication] OFF


SET IDENTITY_INSERT [dbo].[History] ON

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAS
T(1 AS Numeric(18, 0)), N'Asthma')

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAST(2 AS Numeric(18, 0)), N'COPD')

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAST(3 AS Numeric(18, 0)), N'CARDIAC')

INSERT [dbo].[History] ([H
istoryID], [HistoryName]) VALUES (CAST(4 AS Numeric(18, 0)), N'HTN')

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAST(5 AS Numeric(18, 0)), N'DM')

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAST(6 AS Numeric(18, 0)), N'SZ')

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAST(7 AS Numeric(18, 0)), N'CVA')

INSERT [dbo].[History] ([HistoryID], [HistoryName]) VALUES (CAST(8 AS Numeric(18, 0)), N'CA')

SET IDENTITY_INSERT [dbo].[History] OFF


SET IDENTITY_INSERT [dbo]
.[Destination] ON

INSERT [dbo].[Destination] ([DestinationID], [DestinationName]) VALUES (CAST(1 AS Numeric(18, 0)), N'ER')

INSERT [dbo].[Destination] ([DestinationID], [DestinationName]) VALUES (CAST(2 AS Numeric(18, 0)), N'TC')

INSERT [dbo].[Destination]

([DestinationID], [DestinationName]) VALUES (CAST(3 AS Numeric(18, 0)), N'PEDS')

INSERT [dbo].[Destination] ([DestinationID], [DestinationName]) VALUES (CAST(4 AS Numeric(18, 0)), N'Cath Lab')

INSERT [dbo].[Destination] ([DestinationID], [DestinationName]
) VALUES (CAST(5 AS Numeric(18, 0)), N'L&D')

INSERT [dbo].[Destination] ([DestinationID], [DestinationName]) VALUES (CAST(6 AS Numeric(18, 0)), N'Floor')

SET IDENTITY_INSERT [dbo].[Destination] OFF


SET IDENTITY_INSERT [dbo].[County] ON

INSERT [dbo].[Count
y] ([CountyID], [CountyName]) VALUES (CAST(1 AS Numeric(18, 0)), N'Duval')

INSERT [dbo].[County] ([CountyID], [CountyName]) VALUES (CAST(2 AS Numeric(18, 0)), N'Nassau')

SET IDENTITY_INSERT [dbo].[County] OFF


SET IDENTITY_INSERT [dbo].[ChiefComplaint] ON

INSERT [dbo].[ChiefComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(1 AS Numeric(18, 0)), N'Pain')

INSERT [dbo].[ChiefComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(2 AS Numeric(18, 0)), N'Swelling')

INSERT [dbo].[Chie
fComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(3 AS Numeric(18, 0)), N'Laceration')

INSERT [dbo].[ChiefComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(4 AS Numeric(18, 0)), N'Chest Tightness
')

INSERT [dbo].[ChiefComp
laint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(5 AS Numeric(18, 0)), N'Unresponsive')

INSERT [dbo].[ChiefComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(6 AS Numeric(18, 0)), N'Shoulder Injury
')

INSERT [dbo].[ChiefComplai
nt] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(7 AS Numeric(18, 0)), N'Head Injury')

INSERT [dbo].[ChiefComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(8 AS Numeric(18, 0)), N'Back Injury')

INSERT [dbo].[ChiefComplaint]
([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(9 AS Numeric(18, 0)), N'Short of Breath')

SET IDENTITY_INSERT [dbo].[ChiefComplaint] OFF


SET IDENTITY_INSERT [dbo].[Category] ON

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(1
AS Numeric(18, 0)), N'Medical')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(2 AS Numeric(18, 0)), N'MVC')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(3 AS Numeric(18, 0)), N'Fall')

INSERT [dbo].[Category] ([C
ategoryID], [CategoryName]) VALUES (CAST(4 AS Numeric(18, 0)), N'OB')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(5 AS Numeric(18, 0)), N'Cardiac')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(6 AS Numeric(18,

0)), N'Burn')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(7 AS Numeric(18, 0)), N'Assault')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(8 AS Numeric(18, 0)), N'Sports')

INSERT [dbo].[Category] ([CategoryID],

[CategoryName]) VALUES (CAST(9 AS Numeric(18, 0)), N'MCC')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(10 AS Numeric(18, 0)), N'Trauma')

INSERT [dbo].[Category] ([CategoryID], [CategoryName]) VALUES (CAST(11 AS Numeric(18, 0)), N'G
SW')

SET IDENTITY_INSERT [dbo].[Category] OFF


SET IDENTITY_INSERT [dbo].[Treatment] ON

INSERT [dbo].[Treatment] ([TreatmentID], [TreatmentName]) VALUES (CAST(1 AS Numeric(18, 0)), N'O2')

INSERT [dbo].[Treatment] ([TreatmentID], [TreatmentName]) VALUES (CA
ST(2 AS Numeric(18, 0)), N'NEB')

INSERT [dbo].[Treatment] ([TreatmentID], [TreatmentName]) VALUES (CAST(3 AS Numeric(18, 0)), N'D50')

INSERT [dbo].[Treatment] ([TreatmentID], [TreatmentName]) VALUES (CAST(4 AS Numeric(18, 0)), N'NITRO')

INSERT [dbo].[Treat
ment] ([TreatmentID], [TreatmentName]) VALUES (CAST(5 AS Numeric(18, 0)), N'ASA')

INSERT [dbo].[Treatment] ([TreatmentID], [TreatmentName]) VALUES (CAST(6 AS Numeric(18, 0)), N'IV')

SET IDENTITY_INSERT [dbo].[Treatment] OFF


SET IDENTITY_INSERT [dbo].[Vehi
cleAccident] ON

INSERT [dbo].[VehicleAccident] ([VehicleAccidentID], [VehicleName]) VALUES (CAST(1 AS Numeric(18, 0)), N'MVC')

INSERT [dbo].[VehicleAccident] ([VehicleAccidentID], [VehicleName]) VALUES (CAST(2 AS Numeric(18, 0)), N'MCC')

INSERT
[dbo].[VehicleAccident] ([VehicleAccidentID], [VehicleName]) VALUES (CAST(3 AS Numeric(18, 0)), N'ATV')

INSERT [dbo].[VehicleAccident] ([VehicleAccidentID], [VehicleName]) VALUES (CAST(4 AS Numeric(18, 0)), N'Bicycle')

INSERT [dbo].[VehicleAccident] ([Vehi
cleAccidentID], [VehicleName]) VALUES (CAST(5 AS Numeric(18, 0)), N'Pedestrian')

INSERT [dbo].[VehicleAccident] ([VehicleAccidentID], [VehicleName]) VALUES (CAST(6 AS Numeric(18, 0)), N'Boat / JetSki')

SET IDENTITY_INSERT [dbo].[VehicleAccident] OFF

INSERT

[dbo].[User] ([UserId], [UserType], [UserName], [Password], [LoggedIn], [FirstName], [LastName], [Email]) VALUES (N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', 0, N'ExcelImportUser', N'password ', 0, N'Excel', N'Excel', N'N/A')

I
NSERT [dbo].[User] ([UserId], [UserType], [UserName], [Password], [LoggedIn], [FirstName], [LastName], [Email]) VALUES (N'69d
3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', 0, N'Admin', N'password ', 0, N'Admin', N'Admin', N'Admin@qmcien
c.alecml')

/****** Object: Table [dbo].[Unit] Script Date: 11/27/2011 15:16:09 ******/

SET ANSI_NULLS ON


SET IDENTITY_INSERT [dbo].[Unit] ON

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(
18, 0)), N'R
-
1')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(2 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
2')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(4 AS Numeric(18, 0)), CAST(1 AS Numeric(18
, 0)), N'R
-
4')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(5 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
5')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(6 AS Numeric(18, 0)), CAST(1 AS Numeric(18,
0)), N'R
-
6')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(8 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
7')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(9 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)
), N'R
-
8')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(11 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
10')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(14 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0
)), N'R
-
13')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(15 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
15')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(30 AS Numeric(18, 0)), CAST(1 AS Numeric(18,

0)), N'R
-
17')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(31 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
19')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(33 AS Numeric(18, 0)), CAST(1 AS Numeric(1
8, 0)), N'R
-
20')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(34 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
21')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(35 AS Numeric(18, 0)), CAST(1 AS Numeric
(18, 0)), N'R
-
22')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(36 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
23')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(37 AS Numeric(18, 0)), CAST(1 AS
Numeric(18, 0)), N'R
-
24')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(38 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
25')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(39 AS Numeric(18, 0)), CAST(1 A
S Numeric(18, 0)), N'R
-
27')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(40 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
28')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(41 AS Numeric(18, 0)), CAST(1

AS Numeric(18, 0)), N'R
-
30')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(42 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
31')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(43 AS Numeric(18, 0)), CAST
(1 AS Numeric(18, 0)), N'R
-
32')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(44 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
34')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(45 AS Numeric(18, 0)), CA
ST(1 AS Numeric(18, 0)), N'R
-
36')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(46 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
42')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(47 AS Numeric(18, 0)),
CAST(1 AS Numeric(18, 0)), N'R
-
49')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(48 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
50')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(49 AS Numeric(18, 0))
, CAST(1 AS Numeric(18, 0)), N'R
-
51')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(50 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
52')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(51 AS Numeric(18, 0
)), CAST(1 AS Numeric(18, 0)), N'R
-
55')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(52 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
57')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(53 AS Numeric(18,

0)), CAST(1 AS Numeric(18, 0)), N'R
-
58')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(54 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
59')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(55 AS Numeric(1
8, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
70')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(56 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
103')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(57 AS Numeri
c(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
104')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(58 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'R
-
105')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(59 AS Nu
meric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
20')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(60 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
30')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(61 AS
Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
40')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(62 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
50')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(63 A
S Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
60')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(64 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
70')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(65

AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
90')

INSERT [dbo].[Unit] ([UnitID], [UnitCounty], [UnitName]) VALUES (CAST(66 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'R
-
101')

SET IDENTITY_INSERT [dbo].[Unit] OFF


INSERT [dbo].[Report] ([ReportI
d], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccide
nt], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[Car
diacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'00000000
-
0000
-
0000
-
0000
-
000000000000', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a',

CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeri
c(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respirat
ion2], [O2Sat1], [O2Sat2], [Category], [ChiefComplaint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscit
ated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'8
31d7d69
-
ad82
-
48e8
-
8d9e
-
03a9e5d10595', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(1
06 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Dias
tolic]
,
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [
Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYe
ars], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'cfc05349
-
58e4
-
45a6
-
ba21
-
0cbb005c9f0c', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NU
LL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [Crea
tedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [MultiPatient], [
Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [MedicalDeta
il], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'bec6b8cf
-
c9a5
-
43ce
-
a596
-
1bb4e8de89b8', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Da
te), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3

AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NU
LL, NULL, NULL, 0, NULL)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sa
t2], [Category], [ChiefComplaint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRe
scue], [History], [Treatment], [Dispatcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'2473620e
-
bae8
-
4507
-
ba45
-
1e3073ead8c2', N'69d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', CAST(0x03350B00 AS Date), NULL, NULL, CAST(23 AS Numeric(3, 0)), N'Male', NULL, CAST(43 AS Numeric(3, 0)),
CAST(34 AS Numeric(3, 0)), NULL, NULL, CAST(45 AS Numeric(3, 0)), NULL, CAST(43 AS Numeric(2
, 0)), NULL, CAST(2 AS
Numeric(3, 0)), NULL, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), NULL, CAST(1 AS Numeric(18, 0)), 0, NULL, NULL,
CAST(400 AS Numeric(3, 0)), 1, 0, NULL, 0, 0, 0, NULL, NULL, CAST(0x00F0960000000000 AS Time), 1, 0, CAST(0x0
0E0880000000000
AS Time), CAST(4 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), NULL, CAST(43 AS Numeric(2, 0)), NULL, NULL, NULL, NULL,
CAST(2 AS Numeric(18, 0)), N'InsertTest', N'', NULL, 1, 0, 0, 1, NULL, 1)

INSERT [dbo].[Report] ([ReportId], [CreatedBy
], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [MultiPat
ient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [Med
icalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'12a1fafc
-
b100
-
4766
-
acb8
-
2296e8aaa365', N'69d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', CAST(0x03350B
00 AS Date), NULL, NULL, CAST(32 AS Numeric(3, 0)), N'Male', NULL, CAST(100 AS Numeric(3, 0)),
CAST(43 AS Numeric(3, 0)), CAST(32 AS Numeric(3, 0)), CAST(23 AS Numeric(3, 0)), CAST(12 AS Numeric(3, 0)), CAST(32 AS
Numeric(3, 0)), CAST(32 AS Numeric(2, 0)),

CAST(32 AS Numeric(2, 0)), CAST(23 AS Numeric(3, 0)), CAST(32 AS Numeric(3, 0)),
CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), NULL, CAST(1 AS Numeric(18, 0)), 0, NULL, NULL, CAST(234 AS Numeric(3,
0)), 0, 0, NULL, 0, 0, 0, NULL, NULL, CAST(0x004C
0E0000000000 AS Time), 0, 0, CAST(0x004C0E0000000000 AS Time), CAST(4 AS
Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), NULL, CAST(45 AS Numeric(2, 0)), 1, NULL, NULL, NULL, CAST(1 AS Numeric(18, 0)),
N'Dr. Hahn', N'', NULL, 1, 0, 0, 1, NULL, 1)

INSERT [dbo].
[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GC
S],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispat
cher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'f7ec9928
-
0d31
-
4b2d
-
8328
-
65227b5ae757', N'69d3fe01
-
3b46
-
4784
-
9
ca5
-
2b275771cc87', CAST(0x03350B00 AS Date), NULL, NULL, CAST(32 AS Numeric(3, 0)), N'Male', NULL, CAST(43 AS Numeric(3, 0)),
CAST(32 AS Numeric(3, 0)), NULL, CAST(44 AS Numeric(3, 0)), CAST(242 AS Numeric(3, 0)), NULL, CAST(23 AS Numeric(2, 0)), NULL
,
CAS
T(33 AS Numeric(3, 0)), NULL, CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), NULL, CAST(1 AS Numeric(18, 0)), 0,
NULL, NULL, CAST(434 AS Numeric(3, 0)), 1, 0, NULL, 0, 0, 0, NULL, NULL, CAST(0x000C8A0000000000 AS Time), 0, 1,
CAST(0x000C8A0000000000

AS Time), CAST(4 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), NULL, NULL, 0, NULL, NULL, NULL,
CAST(2 AS Numeric(18, 0)), N'Test5', N'', NULL, 1, 0, 0, 1, NULL, 1)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [
Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejec
ted], [Entrapped], [Rollover], [Helmet], [Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medicatio
n], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'f6578d3f
-
5dbe
-
4c38
-
9265
-
6f5ac45f8cd0', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric(18, 0))
, CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 A
S Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INSERT [dbo
].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [
GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Disp
atcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'64f8eaed
-
26f3
-
4f9a
-
b658
-
99ce1c22d95a', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NUL
L, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NU
LL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Resp
iration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComplaint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset]
, [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOr
iented]) VALUES (N'462a6a50
-
9dc6
-
4506
-
9096
-
c40a44a48617', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0))
, NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systo
lic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Ro
llover], [Helmet], [Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DE
ANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'd7f07ede
-
8f81
-
4202
-
a31d
-
d8179ed28acd', N'69d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', CAST(0x03350B00 AS Date), NULL, NULL, CAST(23 AS Numeric(3, 0)), N'Male', NULL,

CAST(323 AS Numeric(3, 0)),
CAST(21 AS Numeric(3, 0)), CAST(3 AS Numeric(3, 0)), CAST(23 AS Numeric(3, 0)), CAST(232 AS Numeric(3, 0)), CAST(2 AS Numeric
(3,
0)), CAST(23 AS Numeric(2, 0)), CAST(3 AS Numeric(2, 0)), CAST(23 AS Numeric(3, 0)), CAST(23 AS Nu
meric(3, 0)), CAST(1 AS
Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), NULL, CAST(1 AS Numeric(18, 0)), 0, NULL, NULL, CAST(12 AS Numeric(3, 0)), 1, 1,
NULL, 0, 0, 0, NULL, NULL, CAST(0x007C830000000000 AS Time), 1, 0, CAST(0x007C830000000000 AS Time), CAST(2

AS Numeric(18,
0)), CAST(2 AS Numeric(18, 0)), NULL, CAST(23 AS Numeric(2, 0)), NULL, NULL, NULL, NULL, CAST(2 AS Numeric(18, 0)), N'test',
N'34', NULL, 0, 0, 0, 1, NULL, 0)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit],
[Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed
], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [M
edication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'e3237a97
-
021c
-
40ed
-
b495
-
e2457c5eedfc', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x8D340B00 AS Date), NULL, CAST(1 AS Numeric
(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, C
AST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

INS
ERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastol
ic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
l
aint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment
], [Dispatcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'f7dfc5c2
-
e220
-
4942
-
b2ae
-
f25c72865298', N'a8d99d35
-
a
94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x02350B00 AS Date), NULL, CAST(1 AS Numeric(18, 0)), CAST(31 AS Numeric(3, 0)), N'Female', NULL,
CAST(100 AS Numeric(3, 0)), CAST(160 AS Numeric(3, 0)), NULL, NULL, CAST(106 AS Numeric(3, 0)), NULL, CAST(18 AS Numeric(2,
0)), NULL, CAST(98 AS Numeric(3, 0)), NULL, CAST(3 AS Numeric(18, 0)), NULL, CAST(15 AS Numeric(2, 0)), NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(3
AS Numeric(2, 0)), NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL)

/****** Object: ForeignKey [FK_Report_Category] Script Date: 11/27/2011 15:16:09 ******/

ALTER TABLE [dbo].[Report] WITH CHECK ADD CONSTRAINT [FK_Report_Category] FOREIGN KEY(
[Category])

REFERENCES [dbo].[Category] ([CategoryID])



































Tables and Records


Category
:




ChiefComplaint
:


ChiefComplaintId ChiefComplainName

1


Pain

2


Swelling

3


Laceration

4


Chest Tightness

5


Unresponsive

6


Shoulder Injury

7


Head Injury

8


Back Injury

9


Short of Breath


County
:

CountyId


CountyName

1


Duval

2


Nassau


Medication
:

MedicationId

MedicationName

1


Tylenol

2



Morphine

3


Adrenaline



Report
:



Unit


User


VehicleAccident
:


VehicleAccidentID

Vehicle
Name

1

MVC

2

MCC

3

ATV

4

Bicycle

5

Pedestrian

6

Boat/JetSki






















How to access and use system


1.

Open web browser

2.

Type in:

http://crux.ccec.unf.edu/cop4710fall11dma5/LoginScreen.aspx

3.

Enter username and password

4.

Click Submit

5.

Select choice from menu

a.

Create report

Create a new report

b.

View monthly report (admin only)


View stats from reports from month

c.

Excel


Import (admin only)
-

import data from Excel spreadsheet