FEMA Mission Assignment Index

Snowflake table name : CYBERSYN.FEMA_MISSION_ASSIGNMENT_INDEX

View data sources, attributes, and sample queries here.

NameDescriptionTypeExample

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

Last updated

Copyright © 2024 Cybersyn