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 |