National Academies Press: OpenBook

Affordability of National Flood Insurance Program Premiums: Report 2 (2016)

Chapter: Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version

« Previous: Appendix G: American Community Survey 5-Year Data Products
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×

Appendix H

Tables of Data Fields Found in the NFIP Policy Database October 2013 Version

TABLE H-1 Summary of NFIP Policy Database Field Completeness

Policy Data Category Data Assessment
Building Characteristics Data available for most of the policy records
Elevation Data Up to 60% of records have null values for some fields
General Policy Info Data available for most of the policy records
Location Data available for most of the policy records. Some secondary fields in this category are not well populated
Miscellaneous Data are very well populated. Some secondary fields in this category are not well populated
Policy Term Info Data available for most of the policy records
Premium / Coverage Info Data available for most of the policy records. Some secondary fields in this category are not well populated
Risk Rating Factor Data available for most of the policy records. Some secondary fields in this category are not well populated

Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×

TABLE H-2 NFIP Policy Database Field Completeness

Policy Field Name Policy Feed Description Comments on Policy Field Values Data Category
COMPANY_CD Insurance Company Code All records populated but approx. 2% of records have invalid values General Policy Info
POL_NO Policy Number All records populated General Policy Info
END_EFF_DT Endorsement Effective Date All records populated Policy Term Info
T_PREMIUM Total Annual Premium Almost all records populated; less than 1% null Premium / Coverage Info
N_EXP_CST Expense Constant—NFIP Calculated All records populated Miscellaneous
POLICY_FEE Federal Policy fee All records populated Miscellaneous
PREM_PAY_I Premium Payment Indicator Approx. 73% of records have null values Miscellaneous
POL_EFF_DT Policy Effective Date All records populated Policy Term Info
N_POL_TERM NFIP Number of Policy Terms Almost all records populated; less than 1% null Policy Term Info
W_POL_TERM Write Your Own Number of Policy Terms Almost all records populated; less than 1% null Policy Term Info
POL_STATUS Policy Status All records populated General Policy Info
REGION FEMA Region All records populated Location
PROGRAM Community’s Program Type (Regular or Emergency) All records populated General Policy Info
OCCUPANCY Occupancy Type All records populated Risk Rating Factor
T_COV_BLDG Total Amount of Insurance Coverage for Building All records populated Premium / Coverage Info
T_COV_CONT Total Amount of Insurance Coverage for Contents All records populated Premium / Coverage Info
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Policy Field Name Policy Feed Description Comments on Policy Field Values Data Category
ROLLOVER Rollover Indicator Almost all records populated; less than 1% null and/or invalid General Policy Info
ORG_NB_DT Original Policy Effective Date (New Business Date) All records populated Policy Term Info
CUR_POL_EF Current Policy Effective Date All records populated Policy Term Info
COMMUNITY Concatenated Number of Community No. + Panel + Suffix All records populated Location
PANEL_SUF DFIRM Panel Suffix Almost all records populated; less than 1% null and/or invalid Location
CONDO_UNIT Number of units covered by condo policy All records populated Building Characteristics
RATE_METHO Type of Risk Rating Method Almost all records populated; less than 1% null and/or invalid Risk Rating Factor
POL_EXP_DT Policy Expiration Date All records populated Policy Term Info
FIRST_NAME Policy Holder First Name Almost all records populated; less than 1% null General Policy Info
LAST_NAME Policy Holder Last Name All records populated General Policy Info
NAME Name (N) or Descriptive (D) Property Information Almost all records populated; less than 1% null General Policy Info
ADDRESS1 Secondary Address Field Approx. 94% of records have null values Location
ADDRESS2 Primary Address Field Almost all records populated; less than 1% null and/or invalid Location
CITY City Almost all records populated; less than 1% null and/or invalid Location
STATE State (2 Letter Abbreviation) All records populated Location
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Policy Field Name Policy Feed Description Comments on Policy Field Values Data Category
ZIP1 7 Digit Zip All records populated Location
ZIP2 4 Digit Zip Extension Approx. 7% have null and/or invalid records Location
ADDRESSKEY Address Key Almost all records populated; less than 1% null and/or invalid Location
N_ZIP_CODE FEMA Geocoded 5 Digit Zipcode (9 Digit Zipcode in Some Cases) Almost all records populated; less than 1% null and/or invalid Location
FLOOD_ZONE Flood Zone on DFIRM Almost all records populated; less than 1% null and/or invalid Risk Rating Factor
POST_FIRM Is the Parcel Post-FIRM (Yes/No) Almost all records populated; less than 1% null and/or invalid Risk Rating Factor
DEDUCT_BLD Deductible for Building Almost all records populated; less than 1% null and/or invalid Premium / Coverage Info
DEDUCT_CON Deductible for Contents Approx. 11% of records have null values Premium / Coverage Info
ELEV_DIFF Elevation Difference Between Lowest Floor and BFE No null records but a lot of invalid attributes (ex. elevation differences of ± 1,000 feet) Elevation
AS_OF_DT As of Date (Currentness of Policy Database) All records populated General Policy Info
ORIG_CONST Original Construction Date / Substantial Almost all records populated; less than 1% null and/or invalid Building Characteristics
BUILDING Building Number of Floors / Building Type Almost all records populated; less than 1% null and/or invalid Building Characteristics
BASEMENT Type of Basement or Enclosure Almost all records populated; less than 1% null and/or invalid Building Characteristics
SMALL_BUS Small Business Indicator All records populated Miscellaneous
CONDO Indicates If Condo Type All records populated Risk Rating Factor
FILE_IND File Indicator All records are null Miscellaneous
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Policy Field Name Policy Feed Description Comments on Policy Field Values Data Category
BASE_FLOOD Base Flood Elevation All records populated, but approx. 64% had invalid values Elevation
LOW_FLOOR Elevation of Lowest Floor All records populated, but approx. 64% had invalid values Elevation
ELEV_BLDG Is the Building Elevated (Yes/No) All records populated Building Characteristics
LOC_CONT Location of Contents About 30% of records are null Premium / Coverage Info
INS_VAL_IN Insurance to Value Indicator Approx. 58% of records have null values Premium / Coverage Info
OBSTRUCTIO Obstruction Approx. 78% of records have null values Risk Rating Factor
ELEV_CERT FEMA Elevation Certificate Indicator Approx. 58% of records have null values Elevation
POST_V_CER Post V Zone Certification Indicator Approx. 18% of records have null values Risk Rating Factor
COMM_PROB Community Probation Surcharge Amount All records populated Miscellaneous
CRS_CLASS Community Rating System Class All records populated Risk Rating Factor
CRSE_CONST Course of Construction Indicator All records populated; less than 1% null and/ or invalid Building Characteristics
STATE_OWN State Owned Indicator Almost all records populated; less than 1% null and/or invalid Miscellaneous
DIS_ASST Disaster Assistance Type All records populated General Policy Info
FLOOD_PROO Flood-Proofed Indicator Almost all records populated; less than 1% null and/or invalid Building Characteristics
RLTRGTGP_I Repetitive Loss Target Group Indicator All records are null Risk Rating Factor
DIAGRAM_NO Elevation Certificate Diagram Number Approx. 53% of records have null values Elevation
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Policy Field Name Policy Feed Description Comments on Policy Field Values Data Category
LOWADJ_GRA Lowest Adjacent Grade All records populated, but approx. 69% had invalid values Elevation
N_PREM_ICC NFIP Premium ICC Coverage All records populated Premium / Coverage Info
N_COV_ICC NFIP ICC Coverage All records populated Premium / Coverage Info
ADDR_UP_DT Address Update Date Almost all records populated; less than 1% null and/or invalid Location
GIS_LONGI GIS Longitude of Property Almost all records populated; less than 1% null and/or invalid Location
GIS_LATI GIS Latitude of Property Almost all records populated; less than 1% null and/or invalid Location
GIS_GEORES FEMA GIS Geocode Result All records populated Location
GIS_GEOCEN FEMA GIS Geocoded Census Block Almost all records populated; less than 1% null records but an additional 3% with invalid data Location
PRINCIPAL Principal Residence Indicator All records populated Risk Rating Factor
BW12 Biggert-Waters 12 Values All records populated Risk Rating Factor
CBGFIPS Census Block Group FIPS (Taken from GIS_ GEOCEN Field) Almost all records populated; less than 1% null records but an additional 3% with invalid data Location
STCO_FIPS State, County FIPS (Taken from GIS_ GEOCEN Field) Almost all records populated; less than 1% null records but an additional 3% with invalid data Location
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Page 127
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Page 128
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Page 129
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Page 130
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Page 131
Suggested Citation:"Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version." National Academies of Sciences, Engineering, and Medicine. 2016. Affordability of National Flood Insurance Program Premiums: Report 2. Washington, DC: The National Academies Press. doi: 10.17226/21848.
×
Page 132
Next: Appendix I: Task Statements for Affordability of National Flood Insurance Program Premiums - Report 1 and Report 2 »
Affordability of National Flood Insurance Program Premiums: Report 2 Get This Book
×
Buy Paperback | $49.00 Buy Ebook | $39.99
MyNAP members save 10% online.
Login or Register to save!
Download Free PDF

When Congress authorized the National Flood Insurance Program (NFIP) in 1968, it intended for the program to encourage community initiatives in flood risk management, charge insurance premiums consistent with actuarial pricing principles, and encourage the purchase of flood insurance by owners of flood prone properties, in part, by offering affordable premiums. The NFIP has been reauthorized many times since 1968, most recently with the Biggert-Waters Flood Insurance Reform Act of 2012 (BW 2012). In this most recent reauthorization, Congress placed a particular emphasis on setting flood insurance premiums following actuarial pricing principles, which was motivated by a desire to ensure future revenues were adequate to pay claims and administrative expenses. BW 2012 was designed to move the NFIP towards risk-based premiums for all flood insurance policies. The result was to be increased premiums for some policyholders that had been paying less than NFIP risk-based premiums and to possibly increase premiums for all policyholders.

Recognition of this possibility and concern for the affordability of flood insurance is reflected in sections of the Homeowner Flood Insurance Affordability Act of 2014 (HFIAA 2014). These sections called on FEMA to propose a draft affordability framework for the NFIP after completing an analysis of the efforts of possible programs for offering “means-tested assistance” to policyholders for whom higher rates may not be affordable.

BW 2012 and HFIAA 2014 mandated that FEMA conduct a study, in cooperation with the National Academies of Sciences, Engineering, and Medicine, which would compare the costs of a program of risk-based rates and means-tested assistance to the current system of subsidized flood insurance rates and federally funded disaster relief for people without coverage. Production of two reports was agreed upon to fulfill this mandate. This second report proposes alternative approaches for a national evaluation of affordability program policy options and includes lessons for the design of a national study from a proof-of-concept pilot study.

  1. ×

    Welcome to OpenBook!

    You're looking at OpenBook, NAP.edu's online reading room since 1999. Based on feedback from you, our users, we've made some improvements that make it easier than ever to read thousands of publications on our website.

    Do you want to take a quick tour of the OpenBook's features?

    No Thanks Take a Tour »
  2. ×

    Show this book's table of contents, where you can jump to any chapter by name.

    « Back Next »
  3. ×

    ...or use these buttons to go back to the previous chapter or skip to the next one.

    « Back Next »
  4. ×

    Jump up to the previous page or down to the next one. Also, you can type in a page number and press Enter to go directly to that page in the book.

    « Back Next »
  5. ×

    Switch between the Original Pages, where you can read the report as it appeared in print, and Text Pages for the web version, where you can highlight and search the text.

    « Back Next »
  6. ×

    To search the entire text of this book, type in your search term here and press Enter.

    « Back Next »
  7. ×

    Share a link to this book page on your preferred social network or via email.

    « Back Next »
  8. ×

    View our suggested citation for this chapter.

    « Back Next »
  9. ×

    Ready to take your reading offline? Click here to buy this book in print or download it as a free PDF, if available.

    « Back Next »
Stay Connected!