FloodContractFeeAmount 
Base Entity  HAZARD_INSURANCE 
Attribute Name  FloodContractFeeAmount 
Logical Rolename   
ColumnName  FloodContractFeeAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount charged by the provider to obtain the Flood Contract associated with the subject property. 
Note 
 

FloodContractFeeAmount Logical Attribute Properties 
Logical Attribute Name  FloodContractFeeAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

FloodContractFeeAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

FloodContractFeeAmount Bound Attachments 
Name  Current Value 

FloodContractFeeAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

FloodContractFeeAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FloodContractFeeAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FloodContractFeeAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FloodContractFeeAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  HAZARD_INSURANCE 
Attribute Name  SequenceNumber 
Logical Rolename   
ColumnName  SequenceNumber 
RoleName   
Domain  XSD:Integer 
Definition  An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. 
Note 
 

SequenceNumber Logical Attribute Properties 
Logical Attribute Name  SequenceNumber 
Datatype  INTEGER 
Nullable  YES 

SequenceNumber Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SequenceNumber Bound Attachments 
Name  Current Value 

SequenceNumber User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SequenceNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceCoverageAmount 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceCoverageAmount 
Logical Rolename   
ColumnName  HazardInsuranceCoverageAmount 
RoleName   
Domain  MISMOAmount 
Definition  The coverage amount of the property casualty policy on the property securing the loan 
Note 
 

HazardInsuranceCoverageAmount Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceCoverageAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

HazardInsuranceCoverageAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceCoverageAmount Bound Attachments 
Name  Current Value 

HazardInsuranceCoverageAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceCoverageAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceCoverageType 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceCoverageType 
Logical Rolename   
ColumnName  HazardInsuranceCoverageType 
RoleName   
Domain  HazardInsuranceCoverageEnum 
Definition  The type of loss the insurance policy covers.  
Note 
 

HazardInsuranceCoverageType Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceCoverageType 
Datatype  VARCHAR(0) 
Nullable  YES 

HazardInsuranceCoverageType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceCoverageType Reference Value (Bound to Domain) 
Name  ValidationRule200 
Description   
Type  By List 
Value  Value Description 
Earthquake  Earthquake 
FireAndExtendedCoverage  FireAndExtendedCoverage 
Flood  Flood 
Hazard  Hazard 
Homeowners  Homeowners 
Hurricane  Hurricane 
InsectInfestation  InsectInfestation 
Leasehold  Leasehold 
MineSubsidence  MineSubsidence 
Other  Other 
PersonalProperty  PersonalProperty 
Storm  Storm 
Tornado  Tornado 
Volcano  Volcano 
Wind  Wind 

HazardInsuranceCoverageType Bound Attachments 
Name  Current Value 

HazardInsuranceCoverageType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceCoverageType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceCoverageTypeOtherDescription 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceCoverageTypeOtherDescription 
Logical Rolename   
ColumnName  HazardInsuranceCoverageTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to capture the hazard insurance coverage type if Other is selected as the hazard insurance coverage type. 
Note 
 

HazardInsuranceCoverageTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceCoverageTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

HazardInsuranceCoverageTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceCoverageTypeOtherDescription Bound Attachments 
Name  Current Value 

HazardInsuranceCoverageTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceCoverageTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceCoverageTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceEffectiveDate 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceEffectiveDate 
Logical Rolename   
ColumnName  HazardInsuranceEffectiveDate 
RoleName   
Domain  MISMODate 
Definition  The date the hazard insurance went into effect. 
Note 
 

HazardInsuranceEffectiveDate Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceEffectiveDate 
Datatype  DATE 
Nullable  NO 

HazardInsuranceEffectiveDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceEffectiveDate Bound Attachments 
Name  Current Value 

HazardInsuranceEffectiveDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceEffectiveDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceEffectiveDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceEffectiveDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceEffectiveDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceEscrowedIndicator 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceEscrowedIndicator 
Logical Rolename   
ColumnName  HazardInsuranceEscrowedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether hazard is paid by the borrower or the lender 
Note 
 

HazardInsuranceEscrowedIndicator Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceEscrowedIndicator 
Datatype  BIT 
Nullable  NO 

HazardInsuranceEscrowedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceEscrowedIndicator Bound Attachments 
Name  Current Value 

HazardInsuranceEscrowedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceEscrowedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceEscrowedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceEscrowedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceEscrowedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceExpirationDate 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceExpirationDate 
Logical Rolename   
ColumnName  HazardInsuranceExpirationDate 
RoleName   
Domain  MISMODate 
Definition  The date the property casualty policy expires 
Note 
 

HazardInsuranceExpirationDate Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceExpirationDate 
Datatype  DATE 
Nullable  NO 

HazardInsuranceExpirationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceExpirationDate Bound Attachments 
Name  Current Value 

HazardInsuranceExpirationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceExpirationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceExpirationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceExpirationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceExpirationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceNextPremiumDueDate 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceNextPremiumDueDate 
Logical Rolename   
ColumnName  HazardInsuranceNextPremiumDueDate 
RoleName   
Domain  MISMODate 
Definition  The month and year the next property casualty premium is due 
Note 
 

HazardInsuranceNextPremiumDueDate Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceNextPremiumDueDate 
Datatype  DATE 
Nullable  NO 

HazardInsuranceNextPremiumDueDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceNextPremiumDueDate Bound Attachments 
Name  Current Value 

HazardInsuranceNextPremiumDueDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceNextPremiumDueDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNextPremiumDueDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNextPremiumDueDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNextPremiumDueDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceNonStandardPolicyType 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceNonStandardPolicyType 
Logical Rolename   
ColumnName  HazardInsuranceNonStandardPolicyType 
RoleName   
Domain  HazardInsuranceNonStandardPolicyEnum 
Definition  Additional Description of the Hazard Insurance coverage document.  
Note 
 

HazardInsuranceNonStandardPolicyType Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceNonStandardPolicyType 
Datatype  VARCHAR(0) 
Nullable  YES 

HazardInsuranceNonStandardPolicyType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceNonStandardPolicyType Reference Value (Bound to Domain) 
Name  ValidationRule201 
Description   
Type  By List 
Value  Value Description 
Application  Application 
Binder  Binder 
Bridge  Bridge 
Condo  Condo 
CondominiumPUDMasterPolicy  CondominiumPUDMasterPolicy 
FairPlan  FairPlan 
ForcePlaced  ForcePlaced 
Other  Other 

HazardInsuranceNonStandardPolicyType Bound Attachments 
Name  Current Value 

HazardInsuranceNonStandardPolicyType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceNonStandardPolicyType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNonStandardPolicyType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNonStandardPolicyType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNonStandardPolicyType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceNonStandardPolicyTypeOtherDescription 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceNonStandardPolicyTypeOtherDescription 
Logical Rolename   
ColumnName  HazardInsuranceNonStandardPolicyTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  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. 
Note 
 

HazardInsuranceNonStandardPolicyTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceNonStandardPolicyTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

HazardInsuranceNonStandardPolicyTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceNonStandardPolicyTypeOtherDescription Bound Attachments 
Name  Current Value 

HazardInsuranceNonStandardPolicyTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceNonStandardPolicyTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNonStandardPolicyTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNonStandardPolicyTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceNonStandardPolicyTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsurancePolicyCancellationDate 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsurancePolicyCancellationDate 
Logical Rolename   
ColumnName  HazardInsurancePolicyCancellationDate 
RoleName   
Domain  MISMODate 
Definition  The date the insurance company terminates the policy. 
Note 
 

HazardInsurancePolicyCancellationDate Logical Attribute Properties 
Logical Attribute Name  HazardInsurancePolicyCancellationDate 
Datatype  DATE 
Nullable  NO 

HazardInsurancePolicyCancellationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsurancePolicyCancellationDate Bound Attachments 
Name  Current Value 

HazardInsurancePolicyCancellationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsurancePolicyCancellationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePolicyCancellationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePolicyCancellationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePolicyCancellationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsurancePolicyIdentifier 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsurancePolicyIdentifier 
Logical Rolename   
ColumnName  HazardInsurancePolicyIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  The number assigned to the policy by the insurance company 
Note 
 

HazardInsurancePolicyIdentifier Logical Attribute Properties 
Logical Attribute Name  HazardInsurancePolicyIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

HazardInsurancePolicyIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsurancePolicyIdentifier Bound Attachments 
Name  Current Value 

HazardInsurancePolicyIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsurancePolicyIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePolicyIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePolicyIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePolicyIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsurancePremiumAmount 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsurancePremiumAmount 
Logical Rolename   
ColumnName  HazardInsurancePremiumAmount 
RoleName   
Domain  MISMOAmount 
Definition  The projected property casualty premium to be paid. 
Note 
 

HazardInsurancePremiumAmount Logical Attribute Properties 
Logical Attribute Name  HazardInsurancePremiumAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

HazardInsurancePremiumAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsurancePremiumAmount Bound Attachments 
Name  Current Value 

HazardInsurancePremiumAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsurancePremiumAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePremiumAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePremiumAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePremiumAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsurancePremiumMonthsCount 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsurancePremiumMonthsCount 
Logical Rolename   
ColumnName  HazardInsurancePremiumMonthsCount 
RoleName   
Domain  MISMOCount 
Definition  The term expressed in months between each property casualty insurance premium. 
Note 
 

HazardInsurancePremiumMonthsCount Logical Attribute Properties 
Logical Attribute Name  HazardInsurancePremiumMonthsCount 
Datatype  INTEGER 
Nullable  NO 

HazardInsurancePremiumMonthsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsurancePremiumMonthsCount Bound Attachments 
Name  Current Value 

HazardInsurancePremiumMonthsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsurancePremiumMonthsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePremiumMonthsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePremiumMonthsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsurancePremiumMonthsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HazardInsuranceReplacementValueIndicator 
Base Entity  HAZARD_INSURANCE 
Attribute Name  HazardInsuranceReplacementValueIndicator 
Logical Rolename   
ColumnName  HazardInsuranceReplacementValueIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  A code that indicates whether the coverage provides full replacement of the property 
Note 
 

HazardInsuranceReplacementValueIndicator Logical Attribute Properties 
Logical Attribute Name  HazardInsuranceReplacementValueIndicator 
Datatype  BIT 
Nullable  NO 

HazardInsuranceReplacementValueIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HazardInsuranceReplacementValueIndicator Bound Attachments 
Name  Current Value 

HazardInsuranceReplacementValueIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HazardInsuranceReplacementValueIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceReplacementValueIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceReplacementValueIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HazardInsuranceReplacementValueIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description