FEMA Mission Assignment Index
Snowflake table name : CYBERSYN.FEMA_MISSION_ASSIGNMENT_INDEX
Last updated
Snowflake table name : CYBERSYN.FEMA_MISSION_ASSIGNMENT_INDEX
Last updated
Copyright © 2024 Cybersyn
Name | Description | Type | Example |
---|---|---|---|
FEMA_RECORD_ID
Unique record identifier from FEMA for the mission assignment.
VARCHAR
12daf6d4-4de7-40f7-9830-a7fe725765da
MISSION_ASSIGNMENT_ID
Identifier for request, used to aggregate funding across multiple days.
VARCHAR
3345EMWVCOELRD01
AMENDMENT_ID
Obligation requests may be modified to adjust or add funds. This number identifies those amendments. The value is 0 if there are no amendments.
NUMBER
0
DISASTER_ID
Sequentially FEMA-assigned number used to designate an event or incident declared as a disaster.
VARCHAR
3345
REQUESTING_AGENCY
Name of the entity requesting assistance.
VARCHAR
COE-LRD
REQUESTED_DATE
Date a State or Tribe requested assistance.
DATE
2012-07-01
OBLIGATION_DATE
Date the Mission Assignment was obligated.
DATE
2012-07-01
PROJECTED_COMPLETION_DATE
Estimated end of the mission. Subject to revision.
DATE
2012-07-05
STATE_COST_SHARE_AMOUNT
Dollar amount of the cost for which the state or tribal government is responsible.
FLOAT
0.0
STATE_COST_SHARE_PERCENT
Percentage of the cost for which the state or tribal government is responsible.
FLOAT
0.0
FEDERAL_COST_SHARE_AMOUNT
Dollar amount of the cost for which FEMA is responsible.
FLOAT
20000.0
FEDERAL_COST_SHARE_PERCENT
Percentage of the cost for which FEMA is responsible.
FLOAT
1.0
REQUESTED_AMOUNT
Total cost in dollars, as requested by state or tribal government.
FLOAT
10000.0
OBLIGATION_AMOUNT
Total dollars amount obligated.
FLOAT
0.0
REQUESTED_ASSISTANCE_DESCRIPTION
Additional information about the assistance request.
VARCHAR
Deploy and provide Temporary Emergency Power SME's to State and/...
STATEMENT_OF_WORK
Description of the requested assistance.
VARCHAR
In support of COVID-19 Operations, HHS in Coordination with FEMA...
CITY
Place of performance if available.
VARCHAR
Tamuning
STATE_GEO_ID
Cybersyn's unique identifier for a state, joinable to GEOGRAPHY_INDEX.
VARCHAR
geoId/42
ZIP_GEO_ID
Cybersyn's unique identifier for a zip code, joinable to GEOGRAPHY_INDEX.
VARCHAR
zip/19143