/* Created07/07/2005 Modified07/07/2005 ProjectEMS National Dataset (NEMSIS) AuthorWes Bowden DatabaseMS SQL 2000 --------------------------------------------------------------------- Updated 12/13/2007 Jorge Rojas Changes: Some NEMSIS elements were missing some of the NEMSIS Common NULL Values. These were add in. Also the column DataElementVariableCode was changed from data type smallint to float because there are some codes that have a decimal --------------------------------------------------------------------- Description: This script will generate a table, create a view, and populate the lookup values necessary to cross reference the data element values with their descriptions. !!! WARNING !!! This script will drop the objects if they are already created. Please be sure you are applying it to the correct database! */ -- Create TABLE: Element_to_Variable PRINT 'Checking for Table: [Element_to_Variable]' if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Element_to_Variables]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Element_to_Variables] GO PRINT 'Done' PRINT '' PRINT 'Creating Table: [Element_to_Variable]' CREATE TABLE [dbo].[Element_to_Variables] ( [DataElementID] [int] IDENTITY (1, 1) NOT NULL , [DataElementNumber] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DataElementName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DataElementVariableCode] float NULL , [DataElementVariableName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO PRINT 'Done' PRINT '' PRINT 'Creating Constraints for Table: [Element_to_Variable]' ALTER TABLE [dbo].[Element_to_Variables] WITH NOCHECK ADD CONSTRAINT [PK_Element_to_Variables] PRIMARY KEY CLUSTERED ( [DataElementID] ) ON [PRIMARY] GO PRINT 'Done' PRINT '' -- Create LookupValues View PRINT 'Checking for View: [LookupValues]' if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LookupValues]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[LookupValues] GO PRINT 'Done' PRINT '' SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO PRINT 'Creating View: [LookupValues]' GO CREATE VIEW dbo.LookupValues AS SELECT DISTINCT DataElementVariableCode, DataElementVariableName FROM dbo.Element_to_Variables WHERE (NOT (DataElementVariableCode IS NULL)) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO PRINT 'Done' PRINT '' -- Populate Values into Element_to_Variables Table SET NOCOUNT ON PRINT 'Inserting 2576 records into Table: [Element_to_Variables]' -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5610 ,'911 Response (Scene) with Transport Capability') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5620 ,'911 Response (Scene) without Transport Capability') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5630 ,'Air Medical') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5640 ,'Hazmat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5650 ,'Medical Transport (Convalescent)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5660 ,'Paramedic Intercept') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5670 ,'Rescue') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_05 ','Primary Type of Service', 5680 ,'Specialty Care Transport') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5690 ,'911 Response (Scene) with Transport Capability') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5700 ,'911 Response (Scene) without Transport Capability') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5710 ,'Air Medical') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5720 ,'Hazmat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5730 ,'Medical Transport (Convalescent)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5740 ,'Paramedic Intercept') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5750 ,'Rescue') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_06 ','Other Types of Service', 5760 ,'Specialty Care Transport') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_07 ','Level of Service', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_07 ','Level of Service', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_07 ','Level of Service', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_07 ','Level of Service', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_07 ','Level of Service', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_07 ','Level of Service', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_08 ','Organizational Type', 5810 ,'Community, Non-Profit') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_08 ','Organizational Type', 5820 ,'Fire Department') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_08 ','Organizational Type', 5830 ,'Governmental, Non-Fire') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_08 ','Organizational Type', 5840 ,'Hospital') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_08 ','Organizational Type', 5850 ,'Private, Non_Hospital') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_08 ','Organizational Type', 5860 ,'Tribal') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_09 ','Organization Status', 5870 ,'Mixed') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_09 ','Organization Status', 5880 ,'Non-Volunteer') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_09 ','Organization Status', 5890 ,'Volunteer') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_11 ','Other Agencies In Area', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_11 ','Other Agencies In Area', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_11 ','Other Agencies In Area', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_11 ','Other Agencies In Area', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_11 ','Other Agencies In Area', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5900 ,'GMT-11:00 Midway Island, Samoa') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5910 ,'GMT-10:00 Hawaii') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5920 ,'GMT-09:00 Alaska') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5930 ,'GMT-08:00 Pacific Time') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5940 ,'GMT-07:00 Mountain Time') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5950 ,'GMT-06:00 Central Time') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5960 ,'GMT-05:00 Eastern Time') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_19 ','EMS Agency Time Zone', 5970 ,'GMT-04:00 Atlantic Time') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_20 ','EMS Agency Daylight Savings Time Use', 0 ,'No') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_20 ','EMS Agency Daylight Savings Time Use', 1 ,'Yes') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_21 ','National Provider Identifier', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_21 ','National Provider Identifier', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_21 ','National Provider Identifier', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_21 ','National Provider Identifier', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D01_21 ','National Provider Identifier', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_02 ','Agency Contact Middle Name/Initial', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_02 ','Agency Contact Middle Name/Initial', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_02 ','Agency Contact Middle Name/Initial', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_02 ','Agency Contact Middle Name/Initial', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_02 ','Agency Contact Middle Name/Initial', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_03 ','Agency Contact First Name', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_03 ','Agency Contact First Name', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_03 ','Agency Contact First Name', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_03 ','Agency Contact First Name', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_03 ','Agency Contact First Name', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_04 ','Agency Contact Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_04 ','Agency Contact Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_04 ','Agency Contact Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_04 ','Agency Contact Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_04 ','Agency Contact Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_05 ','Agency Contact City', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_05 ','Agency Contact City', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_05 ','Agency Contact City', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_05 ','Agency Contact City', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_05 ','Agency Contact City', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_06 ','Agency Contact State', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_06 ','Agency Contact State', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_06 ','Agency Contact State', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_06 ','Agency Contact State', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_06 ','Agency Contact State', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_08 ','Agency Contact Telephone Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_08 ','Agency Contact Telephone Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_08 ','Agency Contact Telephone Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_08 ','Agency Contact Telephone Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_08 ','Agency Contact Telephone Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_09 ','Agency Contact Fax Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_09 ','Agency Contact Fax Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_09 ','Agency Contact Fax Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_09 ','Agency Contact Fax Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_09 ','Agency Contact Fax Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_10 ','Agency Contact Email Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_10 ','Agency Contact Email Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_10 ','Agency Contact Email Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_10 ','Agency Contact Email Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_10 ','Agency Contact Email Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_11 ','Agency Contact Web Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_11 ','Agency Contact Web Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_11 ','Agency Contact Web Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_11 ','Agency Contact Web Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D02_11 ','Agency Contact Web Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_02 ','Agency Medical Director Middle Name/Initial', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_02 ','Agency Medical Director Middle Name/Initial', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_02 ','Agency Medical Director Middle Name/Initial', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_02 ','Agency Medical Director Middle Name/Initial', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_02 ','Agency Medical Director Middle Name/Initial', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_03 ','Agency Medical Director First Name', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_03 ','Agency Medical Director First Name', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_03 ','Agency Medical Director First Name', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_03 ','Agency Medical Director First Name', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_03 ','Agency Medical Director First Name', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_04 ','Agency Medical Director Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_04 ','Agency Medical Director Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_04 ','Agency Medical Director Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_04 ','Agency Medical Director Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_04 ','Agency Medical Director Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_05 ','Agency Medical Director City', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_05 ','Agency Medical Director City', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_05 ','Agency Medical Director City', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_05 ','Agency Medical Director City', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_05 ','Agency Medical Director City', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_06 ','Agency Medical Director State', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_06 ','Agency Medical Director State', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_06 ','Agency Medical Director State', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_06 ','Agency Medical Director State', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_06 ','Agency Medical Director State', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_08 ','Agency Medical Director Telephone Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_08 ','Agency Medical Director Telephone Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_08 ','Agency Medical Director Telephone Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_08 ','Agency Medical Director Telephone Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_08 ','Agency Medical Director Telephone Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_09 ','Agency Medical Director Fax Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_09 ','Agency Medical Director Fax Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_09 ','Agency Medical Director Fax Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_09 ','Agency Medical Director Fax Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_09 ','Agency Medical Director Fax Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 5980 ,'Anesthesiology') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 5990 ,'Cardiology') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6000 ,'Emergency Medicine') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6010 ,'Family Practice') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6020 ,'General Practice (not board certified)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6030 ,'Internal Medicine') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6040 ,'Obstetrics and Gynecology') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6050 ,'Orthopedics') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6060 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6070 ,'Pediatrics') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_10 ','Agency Medical Directors Medical Specialty', 6080 ,'Surgery') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_11 ','Agency Medical Director Email Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_11 ','Agency Medical Director Email Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_11 ','Agency Medical Director Email Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_11 ','Agency Medical Director Email Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D03_11 ','Agency Medical Director Email Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_01 ','State Certification Licensure Levels', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_01 ','State Certification Licensure Levels', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_01 ','State Certification Licensure Levels', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_01 ','State Certification Licensure Levels', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_01 ','State Certification Licensure Levels', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_01 ','State Certification Licensure Levels', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_05 ','Personnel Level Permitted to Use the Procedure', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_05 ','Personnel Level Permitted to Use the Procedure', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_05 ','Personnel Level Permitted to Use the Procedure', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_05 ','Personnel Level Permitted to Use the Procedure', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_05 ','Personnel Level Permitted to Use the Procedure', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_05 ','Personnel Level Permitted to Use the Procedure', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_07 ','Personnel Level Permitted to Use the Medication', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_07 ','Personnel Level Permitted to Use the Medication', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_07 ','Personnel Level Permitted to Use the Medication', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_07 ','Personnel Level Permitted to Use the Medication', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_07 ','Personnel Level Permitted to Use the Medication', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_07 ','Personnel Level Permitted to Use the Medication', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6720 ,'Abdominal Pain') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6730 ,'Airway, Adult') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6740 ,'Airway, Adult-Failed') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6750 ,'Airway, Pediatric') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6760 ,'Airway, RSI') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6770 ,'Allergic Reaction') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6780 ,'Altered Mental Status') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6790 ,'Asystole') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6800 ,'Back Pain') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6810 ,'Behavioral') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6820 ,'Bites and Envenomations') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6830 ,'Bradycardia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6840 ,'Burns') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6850 ,'Cardiac Arrest') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6860 ,'Chest Pain / Suspected Cardiac Event') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6870 ,'Childbirth / Labor') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6880 ,'Dental Problems') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6890 ,'Drowning / Near Drowning') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6900 ,'Electrical Injuries') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6910 ,'Epistaxis') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6920 ,'Extremity Trauma') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6930 ,'Fever') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6940 ,'Head Trauma') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6950 ,'Hypertension') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6960 ,'Hyperthermia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6970 ,'Hypotension / Shock (Non-Trauma)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6980 ,'Hypothermia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 6990 ,'IV Access') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7000 ,'Multiple Trauma') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7010 ,'Newly Born') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7020 ,'Obstetrical Emergencies') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7030 ,'Overdose / Toxic Ingestion') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7040 ,'Pain Control') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7050 ,'Pediatric Bradycardia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7060 ,'Pediatric Head Trauma') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7070 ,'Pediatric Hypotension') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7080 ,'Pediatric Multiple Trauma') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7090 ,'Pediatric Pulseless Arrest') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7100 ,'Pediatric Respiratory Distress') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7110 ,'Pediatric Seizure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7120 ,'Pediatric Supraventricular Tachycardia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7130 ,'Post Resuscitation') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7140 ,'Pulmonary Edema') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7150 ,'Pulseless Electrical Activity (PEA)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7160 ,'Respiratory Distress') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7170 ,'Seizure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7180 ,'Spinal Immobilization Clearance') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7190 ,'Supraventricular Tachycardia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7200 ,'Suspected Stroke') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7210 ,'Syncope') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7220 ,'Universal Patient Care Protocol') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7230 ,'Ventricular Fibrillation / Pulseless V-Tach') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7240 ,'Ventricular Tachycardia') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7250 ,'Vomiting and Diarrhea') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_08 ','Protocol', 7260 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_09 ','Personnel Level Permitted to Use the Protocol', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_09 ','Personnel Level Permitted to Use the Protocol', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_09 ','Personnel Level Permitted to Use the Protocol', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_09 ','Personnel Level Permitted to Use the Protocol', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_09 ','Personnel Level Permitted to Use the Protocol', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_09 ','Personnel Level Permitted to Use the Protocol', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_10 ','Billing Status', 0 ,'No') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_10 ','Billing Status', 1 ,'Yes') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_12 ','Hospital Facility Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_12 ','Hospital Facility Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_12 ','Hospital Facility Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_12 ','Hospital Facility Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_12 ','Hospital Facility Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_14 ','Destination Facility Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_14 ','Destination Facility Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_14 ','Destination Facility Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_14 ','Destination Facility Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_14 ','Destination Facility Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7270 ,'Home') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7280 ,'Hospital') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7290 ,'Medical Office/Clinic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7300 ,'Morgue') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7320 ,'Nursing Home') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7330 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7340 ,'Other EMS Responder (air)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7350 ,'Other EMS Responder (ground)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D04_15 ','Destination Type', 7360 ,'Police/Jail') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_02 ','Station Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_02 ','Station Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_02 ','Station Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_02 ','Station Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_02 ','Station Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_05 ','Station Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_05 ','Station Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_05 ','Station Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_05 ','Station Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_05 ','Station Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_06 ','Station City', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_06 ','Station City', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_06 ','Station City', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_06 ','Station City', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_06 ','Station City', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_07 ','Station State', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_07 ','Station State', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_07 ','Station State', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_07 ','Station State', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_07 ','Station State', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_09 ','Station Telephone Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_09 ','Station Telephone Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_09 ','Station Telephone Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_09 ','Station Telephone Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D05_09 ','Station Telephone Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7370 ,'Ambulance') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7380 ,'ATV') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7390 ,'Bicycle') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7400 ,'Boat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7410 ,'Fire Truck') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7420 ,'Fixed Wing') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7430 ,'Motorcycle') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7440 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7450 ,'Private Vehicle') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7460 ,'Quick Response Vehicle (Non-Transport Vehicle other than Fire Truck') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7470 ,'Rescue') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_03 ','Vehicle Type', 7480 ,'Rotor Craft') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_04 ','State Certification/Licensure Levels', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_04 ','State Certification/Licensure Levels', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_04 ','State Certification/Licensure Levels', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_04 ','State Certification/Licensure Levels', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_04 ','State Certification/Licensure Levels', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_04 ','State Certification/Licensure Levels', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_09 ','Annual Vehicle Hours', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_09 ','Annual Vehicle Hours', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_09 ','Annual Vehicle Hours', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_09 ','Annual Vehicle Hours', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_09 ','Annual Vehicle Hours', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_10 ','Annual Vehicle Miles', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_10 ','Annual Vehicle Miles', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_10 ','Annual Vehicle Miles', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_10 ','Annual Vehicle Miles', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D06_10 ','Annual Vehicle Miles', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_03 ','Personnels Employment Status', 7490 ,'Full Time Paid Employee') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_03 ','Personnels Employment Status', 7500 ,'Full Time Unpaid Employee') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_03 ','Personnels Employment Status', 7510 ,'Part Time Paid and Part Time Unpaid Employee') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_03 ','Personnels Employment Status', 7520 ,'Part Time Paid Employee') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_03 ','Personnels Employment Status', 7530 ,'Part Time Unpaid Employee') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_05 ','Personnels Level of Certification/Licensure for Agency', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_05 ','Personnels Level of Certification/Licensure for Agency', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_05 ','Personnels Level of Certification/Licensure for Agency', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_05 ','Personnels Level of Certification/Licensure for Agency', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_05 ','Personnels Level of Certification/Licensure for Agency', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D07_05 ','Personnels Level of Certification/Licensure for Agency', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_02 ','EMS Personnels Middle Name/Initial', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_02 ','EMS Personnels Middle Name/Initial', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_02 ','EMS Personnels Middle Name/Initial', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_02 ','EMS Personnels Middle Name/Initial', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_02 ','EMS Personnels Middle Name/Initial', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_03 ','EMS Personnels First Name', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_03 ','EMS Personnels First Name', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_03 ','EMS Personnels First Name', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_03 ','EMS Personnels First Name', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_03 ','EMS Personnels First Name', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_04 ','EMS Personnels Mailing Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_04 ','EMS Personnels Mailing Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_04 ','EMS Personnels Mailing Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_04 ','EMS Personnels Mailing Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_04 ','EMS Personnels Mailing Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_05 ','EMS Personnels City of Residence', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_05 ','EMS Personnels City of Residence', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_05 ','EMS Personnels City of Residence', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_05 ','EMS Personnels City of Residence', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_05 ','EMS Personnels City of Residence', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_06 ','EMS Personnels State', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_06 ','EMS Personnels State', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_06 ','EMS Personnels State', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_06 ','EMS Personnels State', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_06 ','EMS Personnels State', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_08 ','EMS Personnels Work Telephone', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_08 ','EMS Personnels Work Telephone', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_08 ','EMS Personnels Work Telephone', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_08 ','EMS Personnels Work Telephone', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_08 ','EMS Personnels Work Telephone', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_09 ','EMS Personnels Home Telephone', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_09 ','EMS Personnels Home Telephone', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_09 ','EMS Personnels Home Telephone', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_09 ','EMS Personnels Home Telephone', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_09 ','EMS Personnels Home Telephone', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_10 ','EMS Personnels Email Address', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_10 ','EMS Personnels Email Address', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_10 ','EMS Personnels Email Address', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_10 ','EMS Personnels Email Address', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_10 ','EMS Personnels Email Address', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', 650 ,'Male') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_12 ','EMS Personnels Gender', 655 ,'Female') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_13 ','EMS Personnels Race', 660 ,'American Indian or Alaska Native') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_13 ','EMS Personnels Race', 665 ,'Asian') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_13 ','EMS Personnels Race', 670 ,'Black or African American') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_13 ','EMS Personnels Race', 675 ,'Native Hawaiian or Other Pacific Islander') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_13 ','EMS Personnels Race', 680 ,'White') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_13 ','EMS Personnels Race', 685 ,'Other Race') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_14 ','EMS Personnels Ethnicity', 690 ,'Hispanic or Latino') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_14 ','EMS Personnels Ethnicity', 695 ,'Not Hispanic or Latino') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_15 ','State EMS Certification Licensure Level', 6090 ,'EMT-Basic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_15 ','State EMS Certification Licensure Level', 6100 ,'EMT-Intermediate') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_15 ','State EMS Certification Licensure Level', 6110 ,'EMT-Paramedic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_15 ','State EMS Certification Licensure Level', 6111 ,'Nurse') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_15 ','State EMS Certification Licensure Level', 6112 ,'Physician') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_15 ','State EMS Certification Licensure Level', 6120 ,'First Responder') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', 0 ,'No') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' D08_16 ','National Registry Credentialed', 1 ,'Yes') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E00 ','Common Null Values', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E00 ','Common Null Values', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E00 ','Common Null Values', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E00 ','Common Null Values', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E00 ','Common Null Values', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_02 ','Incident Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_02 ','Incident Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_02 ','Incident Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_02 ','Incident Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_02 ','Incident Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_03 ','EMS Unit (Vehicle) Response Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_03 ','EMS Unit (Vehicle) Response Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_03 ','EMS Unit (Vehicle) Response Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_03 ','EMS Unit (Vehicle) Response Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_03 ','EMS Unit (Vehicle) Response Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_04 ','Type of Service Requested', 30 ,'911 Response (Scene)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_04 ','Type of Service Requested', 35 ,'Intercept') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_04 ','Type of Service Requested', 40 ,'Interfacility Transfer') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_04 ','Type of Service Requested', 45 ,'Medical Transport') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_04 ','Type of Service Requested', 50 ,'Mutual Aid') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_04 ','Type of Service Requested', 55 ,'Standby') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_05 ','Primary Role of the Unit', 60 ,'Non-Transport') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_05 ','Primary Role of the Unit', 65 ,'Rescue') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_05 ','Primary Role of the Unit', 70 ,'Supervisor') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_05 ','Primary Role of the Unit', 75 ,'Transport') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 100 ,'No Units Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 105 ,'None') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 110 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 115 ,'Scene Safety (Not Secure for EMS)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 120 ,'Technical Failure (Computer, Phone etc.)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 80 ,'Caller (Uncooperative)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 85 ,'High Call Volume') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 90 ,'Language Barrier') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_06 ','Type of Dispatch Delay', 95 ,'Location (Inability to Obtain)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 125 ,'Crowd') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 130 ,'Directions') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 135 ,'Distance') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 140 ,'Diversion') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 145 ,'HazMat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 150 ,'None') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 155 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 160 ,'Safety') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 165 ,'Staff Delay') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 170 ,'Traffic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 175 ,'Vehicle Crash') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 180 ,'Vehicle Failure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_07 ','Type of Response Delay', 185 ,'Weather') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 190 ,'Crowd') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 195 ,'Directions') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 200 ,'Distance') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 205 ,'Diversion') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 210 ,'Extrication >20 min.') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 215 ,'HazMat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 220 ,'Language Barrier') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 225 ,'None') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 230 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 235 ,'Safety') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 240 ,'Staff Delay') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 245 ,'Traffic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 250 ,'Vehicle Crash') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 255 ,'Vehicle Failure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_08 ','Type of Scene Delay', 260 ,'Weather') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 265 ,'Crowd') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 270 ,'Directions') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 275 ,'Distance') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 280 ,'Diversion') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 285 ,'HazMat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 290 ,'None') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 295 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 300 ,'Safety') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 305 ,'Staff Delay') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 310 ,'Traffic') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 315 ,'Vehicle Crash') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 320 ,'Vehicle Failure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_09 ','Type of Transport Delay', 325 ,'Weather') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 330 ,'Clean-up') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 335 ,'Decontamination') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 340 ,'Documentation') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 345 ,'ED Overcrowding') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 350 ,'Equipment Failure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 355 ,'Equipment Replenishment') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 360 ,'None') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 365 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 370 ,'Staff Delay') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_10 ','Type of Turn-Around Delay', 375 ,'Vehicle Failure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_11 ','EMS Unit/Vehicle Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_11 ','EMS Unit/Vehicle Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_11 ','EMS Unit/Vehicle Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_11 ','EMS Unit/Vehicle Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_11 ','EMS Unit/Vehicle Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_13 ','Vehicle Dispatch Location', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_13 ','Vehicle Dispatch Location', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_13 ','Vehicle Dispatch Location', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_13 ','Vehicle Dispatch Location', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_13 ','Vehicle Dispatch Location', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_14 ','Vehicle Dispatch Zone', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_14 ','Vehicle Dispatch Zone', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_14 ','Vehicle Dispatch Zone', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_14 ','Vehicle Dispatch Zone', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_14 ','Vehicle Dispatch Zone', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_20 ','Response Mode to Scene', 380 ,'Initial Lights and Sirens, Downgraded to No Lights or Sirens') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_20 ','Response Mode to Scene', 385 ,'Initial No Lights or Sirens, Upgraded to Lights and Sirens') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_20 ','Response Mode to Scene', 390 ,'Lights and Sirens') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E02_20 ','Response Mode to Scene', 395 ,'No Lights or Sirens') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 400 ,'Abdominal Pain') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 405 ,'Allergies') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 410 ,'Animal Bite') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 415 ,'Assault') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 420 ,'Back Pain') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 425 ,'Breathing Problem') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 430 ,'Burns') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 435 ,'CO Poisoning/Hazmat') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 440 ,'Cardiac Arrest') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 445 ,'Chest Pain') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 450 ,'Choking') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 455 ,'Convulsions/Seizure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 460 ,'Diabetic Problem') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 465 ,'Drowning') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 470 ,'Electrocution') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 475 ,'Eye Problem') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 480 ,'Fall Victim') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 485 ,'Headache') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 490 ,'Heart Problems') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 495 ,'Heat/Cold Exposure') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 500 ,'Hemorrhage/Laceration') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 505 ,'Industrial Accident/Inaccessible Incident/Other Entrapments (non-vehicle)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 510 ,'Ingestion/Poisoning') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 515 ,'Pregnancy/Childbirth') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 520 ,'Psychiatric Problem') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 525 ,'Sick Person') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 530 ,'Stab/Gunshot Wound') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 535 ,'Stroke/CVA') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 540 ,'Traffic Accident') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 545 ,'Traumatic Injury') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 550 ,'Unconscious/Fainting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 555 ,'Unknown Problem Man Down') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 560 ,'Transfer/Interfacility/Palliative Care') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_01 ','Complaint Reported by Dispatch', 565 ,'MCI (Mass Casualty Incident)') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', 0 ,'No') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', 570 ,'Yes, With Pre-Arrival Instructions') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_02 ','EMD Performed', 575 ,'Yes, Without Pre-Arrival Instructions') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_03 ','EMD Card Number', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_03 ','EMD Card Number', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_03 ','EMD Card Number', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_03 ','EMD Card Number', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E03_03 ','EMD Card Number', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_01 ','Crew Member ID', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_01 ','Crew Member ID', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_01 ','Crew Member ID', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_01 ','Crew Member ID', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_01 ','Crew Member ID', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', -15 ,'Not Reporting') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', -20 ,'Not Recorded') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', -25 ,'Not Applicable') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', -5 ,'Not Available') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', 580 ,'Driver') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', 585 ,'Primary Patient Caregiver') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', 590 ,'Secondary Patient Caregiver') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', 595 ,'Third Patient Caregiver') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_02 ','Crew Member Role', 600 ,'Other') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_03 ','Crew Member Level', -10 ,'Not Known') INSERT INTO Element_to_Variables ( DataElementNumber,DataElementName ,DataElementVariableCode,DataElementVariableName ) VALUES (' E04_03 ','Crew Member Level', -15 ,'Not Reporting') INSERT INTO Element_to_Variables (