HAZARD_INSURANCE Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
FloodContractFeeAmount	MISMOAmount	DECIMAL(0, 2)	NO	The amount charged by the provider to obtain the Flood Contract associated with the subject property.
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
HazardInsuranceCoverageAmount	MISMOAmount	DECIMAL(0, 2)	NO	The coverage amount of the property casualty policy on the property securing the loan
HazardInsuranceCoverageType	HazardInsuranceCoverageEnum	VARCHAR(0)	YES	The type of loss the insurance policy covers.
HazardInsuranceCoverageTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the hazard insurance coverage type if Other is selected as the hazard insurance coverage type.
HazardInsuranceEffectiveDate	MISMODate	DATE	NO	The date the hazard insurance went into effect.
HazardInsuranceEscrowedIndicator	MISMOIndicator	BIT	NO	Indicates whether hazard is paid by the borrower or the lender
HazardInsuranceExpirationDate	MISMODate	DATE	NO	The date the property casualty policy expires
HazardInsuranceNextPremiumDueDate	MISMODate	DATE	NO	The month and year the next property casualty premium is due
HazardInsuranceNonStandardPolicyType	HazardInsuranceNonStandardPolicyEnum	VARCHAR(0)	YES	Additional Description of the Hazard Insurance coverage document.
HazardInsuranceNonStandardPolicyTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the Hazard Insurance Non Standard Policy Type if Other is selected as the Hazard Insurance Non Standard Policy Type.
HazardInsurancePolicyCancellationDate	MISMODate	DATE	NO	The date the insurance company terminates the policy.
HazardInsurancePolicyIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The number assigned to the policy by the insurance company
HazardInsurancePremiumAmount	MISMOAmount	DECIMAL(0, 2)	NO	The projected property casualty premium to be paid.
HazardInsurancePremiumMonthsCount	MISMOCount	INTEGER	NO	The term expressed in months between each property casualty insurance premium.
HazardInsuranceReplacementValueIndicator	MISMOIndicator	BIT	NO	A code that indicates whether the coverage provides full replacement of the property

HAZARD_INSURANCE Keys

Key Name

Key Type

Keys

HAZARD_INSURANCE Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
HAZARD_INSURANCES	Identifying	One To Zero or More					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

HAZARD_INSURANCE Check Constraints

Check Constraint Name

CheckConstraint

HAZARD_INSURANCE Bound Attachments

Name	Current Value

HAZARD_INSURANCE User-Defined Mappings

Model

Name

Description

HAZARD_INSURANCE Data Movement Rules

Name

Type

Rule Text/Value