Skip to main content

Currently Skimming:

Appendix H: Tables of Data Fields Found in the NFIP Policy Database October 2013 Version
Pages 127-132

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.


From page 127...
... 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.
From page 128...
... 73% of records Miscellaneous Indicator have null values POL_EFF_DT Policy Effective Date All records populated Policy Term Info N_POL_TERM NFIP Number of Policy Almost all records Policy Term Terms populated; less than Info 1% null W_POL_TERM Write Your Own Almost all records Policy Term Number of Policy Terms populated; less than Info 1% null POL_STATUS Policy Status All records populated General Policy Info REGION FEMA Region All records populated Location PROGRAM Community's Program All records populated General Policy Type (Regular or Info Emergency) OCCUPANCY Occupancy Type All records populated Risk Rating Factor T_COV_BLDG Total Amount of All records populated Premium / Insurance Coverage for Coverage Info Building T_COV_CONT Total Amount of All records populated Premium / Insurance Coverage for Coverage Info Contents
From page 129...
... + Panel + Suffix PANEL_SUF DFIRM Panel Suffix Almost all records Location populated; less than 1% null and/or invalid CONDO_UNIT Number of units All records populated Building covered by condo policy Characteristics RATE_METHO Type of Risk Rating Almost all records Risk Rating Method populated; less than 1% Factor null and/or invalid POL_EXP_DT Policy Expiration Date All records populated Policy Term Info FIRST_NAME Policy Holder First Almost all records General Policy Name populated; less than Info 1% null LAST_NAME Policy Holder Last  All records populated General Policy Name Info NAME Name (N) or Almost all records General Policy Descriptive (D)
From page 130...
... AS_OF_DT As of Date (Currentness All records populated General Policy of Policy Database) Info ORIG_CONST Original Construction Almost all records Building Date / Substantial populated; less than 1% Characteristics null and/or invalid BUILDING Building Number of Almost all records Building Floors / Building Type populated; less than 1% Characteristics null and/or invalid BASEMENT Type of Basement or Almost all records Building Enclosure populated; less than 1% Characteristics null and/or invalid 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
From page 131...
... 58% of records Elevation Certificate Indicator have null values POST_V_CER Post V Zone Approx. 18% of records Risk Rating Certification Indicator have null values Factor COMM_PROB Community Probation All records populated Miscellaneous Surcharge Amount CRS_CLASS Community Rating All records populated Risk Rating System Class Factor CRSE_CONST Course of Construction All records populated; Building Indicator less than 1% null and/ Characteristics or invalid STATE_OWN State Owned Indicator Almost all records Miscellaneous populated; less than 1% null and/or invalid DIS_ASST Disaster Assistance Type All records populated General Policy Info FLOOD_PROO Flood-Proofed Indicator Almost all records Building populated; less than 1% Characteristics null and/or invalid RLTRGTGP_I Repetitive Loss Target All records are null Risk Rating Group Indicator Factor DIAGRAM_NO Elevation Certificate Approx.
From page 132...
... 1% null records but an additional 3% with invalid data STCO_FIPS State, County FIPS Almost all records Location (Taken from GIS_ populated; less than GEOCEN Field) 1% null records but an additional 3% with invalid data


This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More information on Chapter Skim is available.