| MI_PRODUCT |
| EntityType | Dependent |
| Logical Entity Name | MI_PRODUCT |
| Default Table Name | DEAL/SERVICES/SERVICE/MI/MI_APPLICATION_REQUEST/MI_REQUEST/MI_PRODUCT |
| Definition | |
| Note |
| MI_PRODUCT Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| MICoveragePercent | MISMOPercent | DECIMAL(0, 2) | NO | The percentage of mortgage insurance coverage obtained. |
| MIDurationType | MIDurationEnum | VARCHAR(0) | YES | Specifies the period of time for which mortgage insurance coverage has been obtained/paid. |
| MIDurationTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to capture the description of the type of MI Duration if Other is selected as the MIDurationType. |
| MIInitialPremiumAtClosingType | MIInitialPremiumAtClosingEnum | VARCHAR(0) | YES | Specifies whether the initial Mortgage Insurance premium is prepaid upon closing or deferred until first principle payment. |
| MIInitialPremiumAtClosingTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to capture the description of the type of MI Initial Premium At Closing if Other is selected as the MIInitialPremiumAtClosingType. |
| MILenderSpecialProgramDescription | MISMOString | VARCHAR(0) | NO | To convey information describing a certain class of lender loans. Not to be confused with Mortgage Insurance Special Pricing Description. |
| MIPremiumFinancedIndicator | MISMOIndicator | BIT | NO | Indicates whether mortgage insurance premium has been added to loan amount. |
| MIPremiumPaymentType | MIPremiumPaymentEnum | VARCHAR(0) | YES | Defines the source of premium payments and how they are to be paid. |
| MIPremiumPaymentTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to capture the description of the type of MI Premium Payment if Other is selected as the MIPremiumPaymentType. |
| MIPremiumRatePlanType | MIPremiumRatePlanEnum | VARCHAR(0) | YES | Specifies pattern of Mortgage Insurance premium rates charged over the life of the coverage. |
| MIPremiumRatePlanTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to capture the description of the type of MI Premium Rate Plan if Other is selected as the MIPremiumRatePlanType. |
| MIPremiumRefundableType | MIPremiumRefundableEnum | VARCHAR(0) | YES | Specifies how the unearned portion of any private mortgage insurance premiums will be treated if the private mortgage insurance coverage is canceled. |
| MIPremiumRefundableTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to capture the description of the type of MI Premium Refundable if Other is selected as the MIPremiumRefundableType. |
| MIPremiumSourceType | MIPremiumSourceEnum | VARCHAR(0) | YES | Defines the source of the MI premium payment. |
| MIPremiumSourceTypeOtherDescription | MISMOString | VARCHAR(0) | NO | A free-form text field to collect MI premium source when Other is selected for MI Premium Source Type. |
| MIPremiumTermMonthsCount | MISMOCount | INTEGER | NO | The number of months of mortgage insurance coverage paid for. |
| MIRenewalCalculationType | MIRenewalCalculationEnum | VARCHAR(0) | YES | Specifies the way in which the renewal premiums will be calculated. |
| MISpecialPricingDescription | MISMOString | VARCHAR(0) | NO | To convey information about a special pricing option or special deal number associated with a certain class of lender loans. |
| MISplitPremiumUpfrontPercent | MISMOPercent | DECIMAL(0, 2) | NO | Reflects the actual up-front MI Premium percent associated with the plan. |
| MISubPrimeProgramType | MISubPrimeProgramEnum | VARCHAR(0) | YES | To convey the loan is processed as sub prime. |
| MISubPrimeProgramTypeOtherDescription | MISMOString | VARCHAR(0) | NO | The description of the MI Sub Prime Program Type when Other is selected as the option from the enumerated list. |
| MI_PRODUCT Keys |
| Key Name | Key Type | Keys |
| MI_PRODUCT Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| MI_VALIDATION_RESPONSE | Non-Identifying | Zero or One to Zero or One | NO | ||||
| MI_REQUEST | Identifying | One to Zero or One | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| MI_PRODUCT Check Constraints |
| Check Constraint Name | CheckConstraint |
| MI_PRODUCT Bound Attachments |
| Name | Current Value |
| MI_PRODUCT User-Defined Mappings |
| Model | Name | Description |
| MI_PRODUCT Data Movement Rules |
| Name | Type | Rule Text/Value |