Database Paper

guitarchanceSoftware and s/w Development

Aug 15, 2012 (5 years and 6 days ago)

343 views

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 for 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 may 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 (LIST)

BGL#1
: Blood Glucose Level
-

3 digits numeric data entry box

BGL#2
: Blood Glucose Level
-

3 digits numeric data entry box

Vehicular Accid
ent

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 Re
strained (LIST)

Passenger
: A list with values Front Unrestrained, Front Restrained, Rear Unrestrained or Rear Restrained
(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 (Check 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 called
-

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, ASA, 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 t
he other dispatchers logged on to the system at the same time if there is a
special case.

*Notified
: A list 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 value 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)

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

Level
: One position character 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 and 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 te
xt 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 TA
BLE [dbo].[County](


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


[CountyName] [varchar](36) 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].[ChiefComplaint](


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


[ChiefComplaintName] [varchar](50) NULL,


CONSTRAINT [PK_ChiefComplaint] PRIMARY KEY CL
USTERED

(


[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](


[HistoryID] [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_NORECOM
PUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]





CREATE TABLE [dbo].[VehicleAccident](


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


[VehicleName] [varchar](50) NULL,


CONSTR
AINT [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] [va
rchar](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 NULL,


[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] N
OT NULL,


[CreatedDate] [date] NOT NULL,


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


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


[Age] [numeric](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] [varch
ar](18) NULL,


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


[Ejected] [bit] NULL,


[Entrapped] [bit] NULL,


[Rollover] [bit] NULL,


[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] NUL
L,


[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] [bit] NULL,


CONSTRAINT [PK__Report__D5BD48055535A963] PRIMARY KEY CLUSTERED

(


[ReportId] ASC

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

) ON [PRIMARY]


CREATE TABLE [dbo].[Destination](


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


[DestinationName] [varchar](20) NULL,


CONSTRAINT [PK_Destinat
ion] PRIMARY KEY CLUSTERED

(


[DestinationID] 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].[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_P
AGE_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')

INSERT [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 (CAST(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] ([HistoryID], [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].[Destina
tion] OFF


SET IDENTITY_INSERT [dbo].[County] ON

INSERT [dbo].[County] ([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_INSER
T [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].[ChiefComplaint] ([ChiefComplaintID], [ChiefComplaintName]) VALUES (CAST(3 AS Numeric(18, 0)), N'Laceration')

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

INSERT [dbo].[ChiefComplaint] ([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].[ChiefComplaint] ([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] ([CategoryID], [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].[Catego
ry] ([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 Nu
meric(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] ([Cate
goryID], [CategoryName]) VALUES (CAST(11 AS Numeric(18, 0)), N'GSW')

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')

INSE
RT [dbo].[Treatment] ([TreatmentID], [TreatmentName]) VALUES (CAST(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].[Treatment] ([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 IDENTI
TY_INSERT [dbo].[Treatment] OFF


SET IDENTITY_INSERT [dbo].[VehicleAccident] 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] ([VehicleAccidentID], [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')

S
ET IDENTITY_INSERT [dbo].[VehicleAccident] OFF

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

', 0, N'Excel', N'Excel', N'N/A')

INSERT [dbo].[User] ([UserId], [UserType], [UserName], [Password], [LoggedIn], [FirstName], [LastName], [Email]) VALUES (N'69
d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', 0, N'Admin', N'password

', 0, N'Admin', N'Admin', N'Admin@qmcienc.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]) VA
LUES (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]) VALU
ES (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]) VALU
ES (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]) VA
LUES (CAST(33 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 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], [UnitNa
me]) VALUES (CAST(39 AS Numeric(18, 0)), CAST(1 AS 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], [Unit
Name]) 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], [Un
itName]) 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)), CAST(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], [UnitCoun
ty], [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], [UnitCo
unty], [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], [Unit
County], [UnitName]) VALUES (CAST(55 AS Numeric(18, 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], [U
nitCounty], [UnitName]) VALUES (CAST(57 AS Numeric(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 Numeric(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] ([UnitI
D], [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] ([Uni
tID], [UnitCounty], [UnitName]) VALUES (CAST(63 AS 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] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [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], [AwakeOriented]) VALUES (N'00000000
-
0000
-
0000
-
0000
-
00000
0000000', 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], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastol
ic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComplaint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[Trauma
Alert], [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'831d7d69
-
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(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], [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'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', 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'bec6b8cf
-
c9a5
-
43ce
-
a596
-
1bb4e8de89b8', N'a8d99d35
-
a
94f
-
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], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2
], [Respiration1], [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],
[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, CAS
T(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(0x00E0880000000000
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], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [Ch
iefComplaint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [T
reatment], [Dispatcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'12a1fafc
-
b100
-
4766
-
acb8
-
2296e8aaa365', N'69
d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', CAST(0x03350B00 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)), CAS
T(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(0x004C0E0000000000 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. Ha
hn', N'', NULL, 1, 0, 0, 1, NULL, 1)

INSERT [dbo].[Report] ([ReportId], [CreatedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2
Sat1], [O2Sat2], [Category], [ChiefComplaint], [GCS],
[VehicleAccident], [MultiPatient], [Driver], [Passenger], [Speed], [Ejected], [Entrapped], [Rollover], [Helmet], [Airbag], [P
ackaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [Ti
meIssuedByRescue], [History], [Treatment], [Dispatcher], [ETA],
[CardiacRed], [MedicalDetail], [Level], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'f7ec9928
-
0d
31
-
4b2d
-
8328
-
65227b5ae757', N'69d3fe01
-
3b46
-
4784
-
9ca5
-
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,
CAST(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(0x000C8A
0000000000 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], [Cre
atedBy], [CreatedDate], [County], [Unit], [Age], [Sex], [AOX], [BP1Systolic], [BP1Diastolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComp
laint], [GCS],
[VehicleAccident], [Mu
ltiPatient], [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], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'f6578d3f
-
5dbe
-
4c38
-
9265
-
6f5ac45f8cd0', N'a8d99d35
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a', CAST(0x
8D340B00 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], [BP1Systolic], [BP1Dias
tolic],
[BP2Systolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [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], [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 Nu
meric(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, NU
LL, 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],
[BP2Sy
stolic], [BP2Diastolic], [Pulse1], [Pulse2], [Respiration1], [Respiration2], [O2Sat1], [O2Sat2], [Category], [ChiefComplaint]
, [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], [AgeYears], [A
geMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) 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, NU
LL, 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], [Packaged],
[TraumaAlert], [StrokeAlert], [Onset], [STEMI], [Resuscitated], [TimeIssuedByRescue], [History], [Treatment], [Dispatcher], [
ETA],
[CardiacRed], [MedicalDetail], [Le
vel], [TCERPEDS], [Medication], [DrSignature], [DEANo], [NARC], [AgeYears], [AgeMonths],
[AgeWeeks], [Notified], [LOC], [AwakeOriented]) VALUES (N'd7f07ede
-
8f81
-
4202
-
a31d
-
d8179ed28acd', N'69d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87', CAST(0x03350B00 AS Date), NUL
L, 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 Numeri
c(2, 0)), CAST(23 AS Numeric(3, 0)), CAST(23 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(12 AS Numeric(3, 0)), 1, 1,
NULL, 0, 0, 0, NULL, NULL, CAST(0x007C830000000000 AS Tim
e), 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] ([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'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 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'f
7dfc5c2
-
e220
-
4942
-
b2ae
-
f25c72865298', N'a8d99d35
-
a94f
-
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(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)

/****** 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])


































Select Statements

Category


SELECT Category.* FROM
Category
;

ChiefComplaint


SELECT ChiefComplaint.* FROM
ChiefComplaint;

County


SELECT County.* FROM County;

Destination


SELECT Destination.* FROM Destination;

History


SELECT History.* FROM History;

Medication


SELECT Medication.* FROM Medication;

Report

SELECT Medication.* FROM Medication;

Treatment


SELECT
Treatment.* FROM Treatment;

Unit


SELECT Unit.* FROM Unit;

User


SELECT User.* FROM User;

VehicleAccident


SELECT VehicleAccident.* FROM VehicleAccident;





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
:

UnitID

UnitCounty

UnitName

1


1


R
-
1

2


1


R
-
2

4


1


R
-
4

5


1


R
-
5

6


1


R
-
6

8


1


R
-
7

9


1


R
-
8



User
:

UserID




UserType
UserName

Password LoggedIn
FirstName

LastName

Email


a8d99d3
5
-
a94f
-
4a20
-
bf1d
-
217ccd5e7d1a

0

ExcelImportUser

password

False

Excel

Excel

N/A


69d3fe01
-
3b46
-
4784
-
9ca5
-
2b275771cc87

1

Admin

password

False

Admin


Admin


Admin@qmcienc.alecml
























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