wiki:Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)

Version 1 (modified by Nick Arnett, 11 years ago) ( diff )

--

Incident Command System

Required in the U.S. for disaster response. This is a bit of brainstorming on what is needed to fit into ICS for use by Citizen Corps programs (CERT, Neighborhood Watch, etc.) Initial version not quite done...

Components

  • Location: address, coordinate, postal info
  • Person: individual
  • Role: hierarchy of structure and command
  • Organization: companies, agencies, etc., with inter-relationships
  • Membership: relationship of people to organizations
  • Incident: deployment, training, exercise, debriefing, etc.
  • Credential: training, certification, vaccinations, etc.
  • Prerequisite: what credentials needed before a person can participate in an incident
  • Event: what happened at a particular time and place; logging
  • Equipment: personal and organizational gear
  • Resource: supplier of equipment, skills, etc.
  • Project: workflow for planning and management
  • Email: contact info
  • Phone: contact info
  • Web page: associated with people, organizations, resources

Functions

  • Add, modify, remove each kind of component
  • Alerting - instant messaging, SMS, printed phone tree generation
  • Export KML data to maps
  • Calendar
  • Dashboards for incidents, teams, resources, projects
  • ICS/NIMS forms
  • Access control
  • MORE TBD

Table structures

PERSON

person_idPK
person_loginCHAR
person_password
person_titleCHAR
first_nameCHAR
person_nicknameCHAR
last_nameCHAR
photoBLOB
web_pageFK page_id
twitterFK page_id
facebookFK page_id
physical_limitationsTEXT
commentsTEXT
genderENUM(m, f)
birthdateDATE
statusENUM(interested, pending, active, related) # related is for people who are in the database but not part of a team
emergency_contactFK person_id

ROLE

role_idPK
ICS_levelENUM(Command, Section, Division, Individual)
ICS_roleENUM(PIO, Safety, Operations, Planning, Logistics, Intelligence, Finance/Admin)
managerENUM(camp, shelter, etc.)??
subordinateENUM(assistant, deputy)
team_roleENUM(division leader, block leader...)
citizen_corps_roleENUM(board member, working group, donor)

LIAISON # perhaps part of logging?

liaison_idPK
person_idFK
organization_id1FK
organization_id2FK
when_assignedDATETIME
when_unassignedDATETIME

ACCESS_CONTROL TBD

PERSON_ROLE

person_idFK
role_idFK
functionENUM (Command, Operations, Planning, Logistics, Finance/Admin, Intelligence/Investigation)
role_assignedDATETIME
reports_toFK person_id

EQUIPMENT

equipment_idPK
equipment_nameCHAR
equipment_typeENUM (HT, mobile radio, antenna, first aid kit, boots, backpack...)
equipment_categoryENUM (communications, PPE, medical, SAR...)

PERSON_EQUIPMENT # Equipment that volunteers have or should have.

person_idPK
equipment_idFK
quantityINT

ADDRESS

address_idPK
address_typeENUM (home, work, incident, organization, company, division)
addressCHAR
address2CHAR
city|CHAR|
countyCHAR
state/provinceCHAR
countryCHAR
postal_codeCHAR
longitude
latitude
last_updated(DATE)

PERSON_ADDRESS

person_idFK
address_idFK
organization_idFK
address_typeENUM(home, work, organization)

PERSON_ORGANIZATION

person_idFK
organization_idFK
activeBOOLEAN
leaderBOOLEAN
titleCHAR
membership_startedDATE
membership_expiresDATE

EMAIL

email_idPK
email_addressCHAR
email_typeENUM(normal, pager)
last_updatedDATE

PERSON_EMAIL

person_idFK
email_idFK

PHONE # Can belong to person, organization, resource

phone_idPK
phone_typeENUM(home, work, mobile, other)
area_codeINT
numberINT
extensionINT
service_providerCHAR
confidentialBOOLEAN
primaryBOOLEAN
24_7BOOLEAN
last_updatedDATE
organization_idFK
resource_idFK
time_of_dayENUM(any, day, night)
commentsTEXT

PERSON_PHONE

person_idFK
phone_idFK

CREDENTIAL # Any kind of certificate, training, other prerequisite associated with a person

credential_idPK
credential_nameCHAR
credential_descriptionTEXT
credential_typeENUM(communications, ICS, EMS, SAR, CERT, vaccination...)

PERSON_CREDENTIAL

person_idFK
credential_idFK
issuing_organization_idFK
completion_dateDATE
verified_byFK person_id
verified_dateDATE
credential_expiresDATE
credential_certificate_idCHAR

INCIDENT

incident_idPK
incident_nameTEXT
plannedBOOLEAN
incident_descriptionTEXT
incident_commentsTEXT
activation_codeCHAR
incident_contactFK person_id
incident_type_idFK
location_idFK
address_idFK
incident_pageFK page_id
twitter_hashtag

INCIDENT_TYPES

incident_type_idPK
incident_categoryENUM (preparedness, response)
incident_typeENUM(fire, flood, earthquake, medical, evacuation, terrorism, other emergency, critical incident debrief, operational debrief, class, seminar, workshop, game, training, table-top exercise, functional exercise, full-scale exercise)
incident_geographyENUM(neighborhood, city, county, region, state, national, global)

PAGE # web pages

page_idPK
URLCHAR
titleCHAR
descriptionTEXT
last_reviewedDATE

PERSON_INCIDENT

person_idFK
incident_idFK
notifiedDATETIME
committedDATETIME
committed_byFK person_id
arrivedDATETIME
departedDATETIME
met_requirementsBOOLEAN
verified_byFK person_id

INCIDENT_EVENT # Logging - most of this will probably happen on paper, then transcribed

event_idPK
event_typeENUM(person, resource, objective, assessment, situation report, status_report, strategy, intelligence, incident location, incident command, incident base, joint information center)
incident_idFK
person_idFK
person_eventENUM (notified, en-route, checked_in, assigned, rehab, demobilized, available)
role_idFK
address_idFK
resource_idFK
authorityFK person_id
incident_timestampDATETIME
publicBOOLEAN
incident_communications_primaryCHAR
incident_communications_secondaryCHAR
commentTEXT

INCIDENT_PREREQUISITE # qualifications, training, etc.

incident_idFK
prerequisite_idFK
requiredENUM(True, recommended)

ASSIGNMENT

assignment_idPK
incident_idFK
assignment_descriptionTEXT

ASSIGNMENT_PERSON

assignment_idFK
person_idFK
assigned_whenDATETIME
removed_whenDATETIME

ORGANIZATION # Companies, government agencies, etc. - association or group of people with like objectives

organization_idPK
organization_nameCHAR
organization_phoneFK
organization_pageFK
organization_typeENUM(company, foundation, government agency, NGO, responder)
organization_purposeENUM(medical, supplies, elder care, child care, church, shelter, school, public works, communications, transportation, firefighting, emergency management, mass care/emergency assistance/housing/human services, logistics, public health, SAR, hazardous materials, agriculture/natural resources, energy, law enforcement, long-term recovery)
vulnerable_populationENUM (children, elderly, disabled)
donorBOOLEAN
parent_organizationFK organization_id
organization_scopeENUM(neighborhood, city, county, state, national, global)

ORGANIZATION_SERVICE_AREA # Geographic description of areas that an organization serves: TBD

RESOURCE

resource_idPK
resource_nameCHAR
resource_pageFK page_id
resource_typeENUM(web site, park, storage, fire station, gas station, atm, water)
resource_scopeENUM(neighborhood, city, county, state, national, global)
categoryENUM(training, operations, discussion, communications)

RESOURCE_ADDRESS

resource_idFK
address_idFK

RESOURCE_PERSON

resource_idFK
person_idFK
primary_contactBOOLEAN

RESOURCE_ORGANIZATION

resource_idFK
organization_idFK

PROJECT

project_idPK
project_nameCHAR
project_categoryENUM(planning, supplies, finance, logistics...)

PROJECT_PERSON

project_idFK
project_nameTEXT

DIVISION

division_idPK
division_number
division_nameCHAR
division_command_address_idFK
primary_frs_channel
primary_frs_pl
tactical_frs_channel
tactical_frs_pl

Attachments (3)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.