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

Version 4 (modified by Nick Arnett, 10 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... still thinking about best way to organize people, roles, incidents, schedules... NDA

Because one of the principles of ICS is that it can be used for all sorts of "incidents," including training, exercises, etc., this model treats everything it possibly can as an incident, using incident types to distinguish. Part of the intent is to encourage teams to use ICS regularly.

Components

  • Location: address, coordinate, postal info
  • Person: individual
  • Role: hierarchy of structure and command
  • Organization: companies, teams, agencies, etc., with inter-relationships
  • Membership: relationship of people to organizations
  • Incident: deployment, training, exercise, debriefing, etc.
  • Credential: training, skill, 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
  • Generate lists of each kind of component
  • Print identification cards/badges
  • Select individuals by various criteria, then send notifications
  • Interface to calendar, recurring automatic emails for meeting notifications
  • Issue training certificate
  • Alerting - instant messaging, SMS, printed phone tree generation
  • Export KML data for mapping, with symbols
  • Dashboards for incidents, teams, resources, projects
  • Training reports - who needs which courses, what expires soon?
  • ICS/NIMS forms
  • Access control
  • Automatic data dump to forms suitable for laptops, mobile - cache critical data for when network is down.
  • Data import
  • MORE TBD

Table structures

PERSON

person_idPK
person_loginCHAR
person_password
person_titleCHAR
first_nameCHAR
person_nicknameCHAR
last_nameCHAR
photoBLOB
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...)
reports_toFK person_id
citizen_corps_roleENUM(board member, working group, donor)

LIAISON # perhaps part of logging?

liaison_idPK, FK
person_idPK, FK
organization_id1PK, FK
organization_id2PK, FK
when_assignedDATETIME
when_unassignedDATETIME

ACCESS_CONTROL TBD

PERSON_ROLE

person_idFK
role_idFK
role_assignedDATETIME

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, FK
equipment_idPK, FK
quantity_neededINT
quantity_on_handINT

LOCATION

location_idPK
location_typeENUM (home, work, incident, organization, company, division)
street_addressCHAR
street_address2CHAR
city|CHAR|
countyCHAR
state/provinceCHAR
countryCHAR
postal_codeCHAR
longitude
latitude
last_updated(DATE)

PERSON_ADDRESS

person_idPK, FK
address_idPK, FK
address_typeENUM(home, work, organization)

PERSON_ORGANIZATION

# Tracks people's membership in an organization

person_idPK, FK
organization_idPK, FK
activeBOOLEAN
leaderBOOLEAN
titleCHAR
membership_startedDATE
membership_expiresDATE

EMAIL

email_idPK
email_addressCHAR
email_typeENUM(normal, pager)
last_updatedDATE

PERSON_EMAIL

person_idPK, FK
email_idPK, FK

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_idPK, FK
phone_idPK, FK

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_idPK, FK
credential_idPK, FK
issuing_organization_idPK, FK
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_PAGE

person_idPK, FK
page_idPK, FK
page_typeENUM(Personal, Twitter, Facebook, YouTube, other

PERSON_INCIDENT

# This belongs with logging...

person_idPK, FK
incident_idPK, FK
notifiedDATETIME
committedDATETIME
committed_byFK person_id
arrivedDATETIME
departedDATETIME
met_requirementsBOOLEAN
verified_byFK person_id

INCIDENT_ROLE

# Volunteer slots to be filled

incident_idPK, FK
role_idPK, FK
shift_idPK, INT
startingDATETIME
endingDATETIME
people_neededINT

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

ROLE_PREREQUISITE

# qualifications, training, etc.

incident_idPK, FK
role_idPK, FK
prerequisite_idFK
requiredENUM(True, recommended)

CURRICULUM

# Series of classes that typically would be taken together # Curriculum itself becomes a prerequisite

curriculum_idPK
curriculum_nameCHAR
incident_idFK
recommended_sequenceINT
requiredENUM(Yes, Recommended

ASSIGNMENT

assignment_idPK
incident_idPK, FK
assignment_descriptionTEXT

ASSIGNMENT_PERSON

# Move into logging...

assignment_idPK, FK
person_idPK, FK
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

ORGANIZATION_PAGE

organization_idPK, FK
page_idPK, FK
descriptionTEXT

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_LOCATION

resource_idPK, FK
location_idPK, FK

RESOURCE_PERSON

resource_idPK, FK
person_idPK, FK
primary_contactBOOLEAN

RESOURCE_ORGANIZATION

resource_idPK, FK
organization_idPK, FK

DIVISION

# this needs to be generalized to include neighborhood teams?

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.