| FloodCertificationIdentifier |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | FloodCertificationIdentifier |
| Logical Rolename | |
| ColumnName | FloodCertificationIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The certification number assigned by the compliance company when an order is received from the submitting / requesting party. |
| Note |
| FloodCertificationIdentifier Logical Attribute Properties |
| Logical Attribute Name | FloodCertificationIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FloodCertificationIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodCertificationIdentifier Bound Attachments |
| Name | Current Value |
| FloodCertificationIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodCertificationIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodCertificationIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodDeterminationLifeOfLoanIndicator |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | FloodDeterminationLifeOfLoanIndicator |
| Logical Rolename | |
| ColumnName | FloodDeterminationLifeOfLoanIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the flood contract with the compliance company is for the Life of the Loan. |
| Note |
| FloodDeterminationLifeOfLoanIndicator Logical Attribute Properties |
| Logical Attribute Name | FloodDeterminationLifeOfLoanIndicator |
| Datatype | BIT |
| Nullable | NO |
| FloodDeterminationLifeOfLoanIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodDeterminationLifeOfLoanIndicator Bound Attachments |
| Name | Current Value |
| FloodDeterminationLifeOfLoanIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodDeterminationLifeOfLoanIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodDeterminationLifeOfLoanIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodDeterminationLifeOfLoanIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodDeterminationLifeOfLoanIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodPartialIndicator |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | FloodPartialIndicator |
| Logical Rolename | |
| ColumnName | FloodPartialIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that a portion of the subject property is in an identified Special Flood Hazard Area (SFHA). |
| Note |
| FloodPartialIndicator Logical Attribute Properties |
| Logical Attribute Name | FloodPartialIndicator |
| Datatype | BIT |
| Nullable | NO |
| FloodPartialIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodPartialIndicator Bound Attachments |
| Name | Current Value |
| FloodPartialIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodPartialIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodPartialIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodPartialIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodPartialIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodProductCertifyDate |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | FloodProductCertifyDate |
| Logical Rolename | |
| ColumnName | FloodProductCertifyDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date on which the flood determination was assessed by the certification provider. |
| Note |
| FloodProductCertifyDate Logical Attribute Properties |
| Logical Attribute Name | FloodProductCertifyDate |
| Datatype | DATE |
| Nullable | NO |
| FloodProductCertifyDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FloodProductCertifyDate Bound Attachments |
| Name | Current Value |
| FloodProductCertifyDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FloodProductCertifyDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodProductCertifyDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodProductCertifyDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FloodProductCertifyDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityFIRMDate |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCommunityFIRMDate |
| Logical Rolename | |
| ColumnName | NFIPCommunityFIRMDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date on which a community received its first Flood Insurance Rate Map. Used by Insurance companies to determine flood rates as to whether the structure is pre or post FIRM. |
| Note |
| NFIPCommunityFIRMDate Logical Attribute Properties |
| Logical Attribute Name | NFIPCommunityFIRMDate |
| Datatype | DATE |
| Nullable | NO |
| NFIPCommunityFIRMDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCommunityFIRMDate Bound Attachments |
| Name | Current Value |
| NFIPCommunityFIRMDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCommunityFIRMDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityFIRMDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityFIRMDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityFIRMDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityIdentifier |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCommunityIdentifier |
| Logical Rolename | |
| ColumnName | NFIPCommunityIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The 6 digit NFIP community number. |
| Note |
| NFIPCommunityIdentifier Logical Attribute Properties |
| Logical Attribute Name | NFIPCommunityIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPCommunityIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCommunityIdentifier Bound Attachments |
| Name | Current Value |
| NFIPCommunityIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCommunityIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityName |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCommunityName |
| Logical Rolename | |
| ColumnName | NFIPCommunityName |
| RoleName | |
| Domain | MISMOString |
| Definition | The complete name of the community in which the building or mobile home is located. |
| Note |
| NFIPCommunityName Logical Attribute Properties |
| Logical Attribute Name | NFIPCommunityName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPCommunityName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCommunityName Bound Attachments |
| Name | Current Value |
| NFIPCommunityName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCommunityName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStartDate |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCommunityParticipationStartDate |
| Logical Rolename | |
| ColumnName | NFIPCommunityParticipationStartDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date on which the community entered the Regular Program of the NFIP. |
| Note |
| NFIPCommunityParticipationStartDate Logical Attribute Properties |
| Logical Attribute Name | NFIPCommunityParticipationStartDate |
| Datatype | DATE |
| Nullable | NO |
| NFIPCommunityParticipationStartDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCommunityParticipationStartDate Bound Attachments |
| Name | Current Value |
| NFIPCommunityParticipationStartDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCommunityParticipationStartDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStartDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStartDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStartDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusType |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCommunityParticipationStatusType |
| Logical Rolename | |
| ColumnName | NFIPCommunityParticipationStatusType |
| RoleName | |
| Domain | NFIPCommunityParticipationStatusEnum |
| Definition | A code indicating the type of flood program |
| Note |
| NFIPCommunityParticipationStatusType Logical Attribute Properties |
| Logical Attribute Name | NFIPCommunityParticipationStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| NFIPCommunityParticipationStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCommunityParticipationStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule318 |
| Description | |
| Type | By List |
| Value | Value Description |
| Emergency | Emergency |
| NonParticipating | In the Flood Response DTD this enumerated value is Non-Participating. This is marked for deprecation for 3.x and will be changed to Non Participating at that time. |
| Other | Other |
| Probation | Probation |
| Regular | Regular |
| Suspended | Suspended |
| Unknown | Unknown |
| NFIPCommunityParticipationStatusType Bound Attachments |
| Name | Current Value |
| NFIPCommunityParticipationStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCommunityParticipationStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusTypeOtherDescription |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCommunityParticipationStatusTypeOtherDescription |
| Logical Rolename | |
| ColumnName | NFIPCommunityParticipationStatusTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the NFIP Community Participation Status Type Other Description if Other is selected. |
| Note |
| NFIPCommunityParticipationStatusTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | NFIPCommunityParticipationStatusTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPCommunityParticipationStatusTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCommunityParticipationStatusTypeOtherDescription Bound Attachments |
| Name | Current Value |
| NFIPCommunityParticipationStatusTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCommunityParticipationStatusTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCommunityParticipationStatusTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCountyName |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPCountyName |
| Logical Rolename | |
| ColumnName | NFIPCountyName |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the county or counties in which the community is located. In unincorporated areas of a county, this would be classified as: unincorporated areas. For independent cities, this would be classified as: independent city. |
| Note |
| NFIPCountyName Logical Attribute Properties |
| Logical Attribute Name | NFIPCountyName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPCountyName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPCountyName Bound Attachments |
| Name | Current Value |
| NFIPCountyName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPCountyName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCountyName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCountyName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPCountyName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodDataRevisionType |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPFloodDataRevisionType |
| Logical Rolename | |
| ColumnName | NFIPFloodDataRevisionType |
| RoleName | |
| Domain | NFIPFloodDataRevisionEnum |
| Definition | Letter of Map Amendment or Revision has been issued by FEMA. |
| Note |
| NFIPFloodDataRevisionType Logical Attribute Properties |
| Logical Attribute Name | NFIPFloodDataRevisionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| NFIPFloodDataRevisionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPFloodDataRevisionType Reference Value (Bound to Domain) |
| Name | ValidationRule319 |
| Description | |
| Type | By List |
| Value | Value Description |
| LOMA | Letter of Map Amendment |
| LOMR | Letter of Map Revision |
| NFIPFloodDataRevisionType Bound Attachments |
| Name | Current Value |
| NFIPFloodDataRevisionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPFloodDataRevisionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodDataRevisionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodDataRevisionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodDataRevisionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodZoneIdentifier |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPFloodZoneIdentifier |
| Logical Rolename | |
| ColumnName | NFIPFloodZoneIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The flood zone covering the building or mobile home. |
| Note |
| NFIPFloodZoneIdentifier Logical Attribute Properties |
| Logical Attribute Name | NFIPFloodZoneIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPFloodZoneIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPFloodZoneIdentifier Bound Attachments |
| Name | Current Value |
| NFIPFloodZoneIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPFloodZoneIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodZoneIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodZoneIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPFloodZoneIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPLetterOfMapDate |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPLetterOfMapDate |
| Logical Rolename | |
| ColumnName | NFIPLetterOfMapDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the letter (LOMA /LOMR) was issued |
| Note |
| NFIPLetterOfMapDate Logical Attribute Properties |
| Logical Attribute Name | NFIPLetterOfMapDate |
| Datatype | DATE |
| Nullable | NO |
| NFIPLetterOfMapDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPLetterOfMapDate Bound Attachments |
| Name | Current Value |
| NFIPLetterOfMapDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPLetterOfMapDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPLetterOfMapDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPLetterOfMapDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPLetterOfMapDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIdentifier |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPMapIdentifier |
| Logical Rolename | |
| ColumnName | NFIPMapIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The 11-digit number shown on the NFIP map that covers the building or mobile home. (Full concatenated version of the National Flood Community Identifier, NFIP Map Panel Identifier, NFIP Map Panel Suffix Identifier) |
| Note |
| NFIPMapIdentifier Logical Attribute Properties |
| Logical Attribute Name | NFIPMapIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPMapIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPMapIdentifier Bound Attachments |
| Name | Current Value |
| NFIPMapIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPMapIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIndicator |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPMapIndicator |
| Logical Rolename | |
| ColumnName | NFIPMapIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the NFIP map covers the area where the building or mobile home is located. |
| Note |
| NFIPMapIndicator Logical Attribute Properties |
| Logical Attribute Name | NFIPMapIndicator |
| Datatype | BIT |
| Nullable | NO |
| NFIPMapIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPMapIndicator Bound Attachments |
| Name | Current Value |
| NFIPMapIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPMapIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelDate |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPMapPanelDate |
| Logical Rolename | |
| ColumnName | NFIPMapPanelDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The map effective date or the map revised date shown on the NFIP map. |
| Note |
| NFIPMapPanelDate Logical Attribute Properties |
| Logical Attribute Name | NFIPMapPanelDate |
| Datatype | DATE |
| Nullable | NO |
| NFIPMapPanelDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPMapPanelDate Bound Attachments |
| Name | Current Value |
| NFIPMapPanelDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPMapPanelDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelIdentifier |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPMapPanelIdentifier |
| Logical Rolename | |
| ColumnName | NFIPMapPanelIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The 4-digit number that describes the panel in which the property is located |
| Note |
| NFIPMapPanelIdentifier Logical Attribute Properties |
| Logical Attribute Name | NFIPMapPanelIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPMapPanelIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPMapPanelIdentifier Bound Attachments |
| Name | Current Value |
| NFIPMapPanelIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPMapPanelIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelSuffixIdentifier |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPMapPanelSuffixIdentifier |
| Logical Rolename | |
| ColumnName | NFIPMapPanelSuffixIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The letter that indicates the current map revision. |
| Note |
| NFIPMapPanelSuffixIdentifier Logical Attribute Properties |
| Logical Attribute Name | NFIPMapPanelSuffixIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPMapPanelSuffixIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPMapPanelSuffixIdentifier Bound Attachments |
| Name | Current Value |
| NFIPMapPanelSuffixIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPMapPanelSuffixIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelSuffixIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelSuffixIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPMapPanelSuffixIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPStateCode |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | NFIPStateCode |
| Logical Rolename | |
| ColumnName | NFIPStateCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | The state in which the community is located, the two-digit state abbreviation. |
| Note |
| NFIPStateCode Logical Attribute Properties |
| Logical Attribute Name | NFIPStateCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| NFIPStateCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NFIPStateCode Bound Attachments |
| Name | Current Value |
| NFIPStateCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NFIPStateCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPStateCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPStateCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NFIPStateCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaDesignationDate |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | ProtectedAreaDesignationDate |
| Logical Rolename | |
| ColumnName | ProtectedAreaDesignationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date of the Coastal Barrier Resources Area (CBRA) or Otherwise Protected Area (OPA). |
| Note |
| ProtectedAreaDesignationDate Logical Attribute Properties |
| Logical Attribute Name | ProtectedAreaDesignationDate |
| Datatype | DATE |
| Nullable | NO |
| ProtectedAreaDesignationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProtectedAreaDesignationDate Bound Attachments |
| Name | Current Value |
| ProtectedAreaDesignationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProtectedAreaDesignationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaDesignationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaDesignationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaDesignationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaIndicator |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | ProtectedAreaIndicator |
| Logical Rolename | |
| ColumnName | ProtectedAreaIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the building/mobile home is within a Coastal Barrier Resources Area (CBRA) or Otherwise Protected Area (OPA). |
| Note |
| ProtectedAreaIndicator Logical Attribute Properties |
| Logical Attribute Name | ProtectedAreaIndicator |
| Datatype | BIT |
| Nullable | NO |
| ProtectedAreaIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProtectedAreaIndicator Bound Attachments |
| Name | Current Value |
| ProtectedAreaIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProtectedAreaIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProtectedAreaIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SpecialFloodHazardAreaIndicator |
| Base Entity | FLOOD_DETERMINATION_DETAIL |
| Attribute Name | SpecialFloodHazardAreaIndicator |
| Logical Rolename | |
| ColumnName | SpecialFloodHazardAreaIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Flag that indicates if any portion of the building/mobile home is in an identified Special Flood Hazard Area (SFHA) and that flood insurance is required. |
| Note |
| SpecialFloodHazardAreaIndicator Logical Attribute Properties |
| Logical Attribute Name | SpecialFloodHazardAreaIndicator |
| Datatype | BIT |
| Nullable | NO |
| SpecialFloodHazardAreaIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SpecialFloodHazardAreaIndicator Bound Attachments |
| Name | Current Value |
| SpecialFloodHazardAreaIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SpecialFloodHazardAreaIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SpecialFloodHazardAreaIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SpecialFloodHazardAreaIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SpecialFloodHazardAreaIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |