BorrowerMITerminationDate |
Base Entity | MI_DATA_DETAIL |
Attribute Name | BorrowerMITerminationDate |
Logical Rolename | |
ColumnName | BorrowerMITerminationDate |
RoleName | |
Domain | MISMODate |
Definition | The date that the borrower may request cancellation of MI insurance as identified by HOEPA regulations. |
Note |
BorrowerMITerminationDate Logical Attribute Properties |
Logical Attribute Name | BorrowerMITerminationDate |
Datatype | DATE |
Nullable | NO |
BorrowerMITerminationDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BorrowerMITerminationDate Bound Attachments |
Name | Current Value |
BorrowerMITerminationDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
BorrowerMITerminationDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMITerminationDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMITerminationDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BorrowerMITerminationDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LenderPaidMIInterestRateAdjustmentPercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | LenderPaidMIInterestRateAdjustmentPercent |
Logical Rolename | |
ColumnName | LenderPaidMIInterestRateAdjustmentPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of the mortgage interest rate allocated to fund lender purchased mortgage insurance premiums. |
Note |
LenderPaidMIInterestRateAdjustmentPercent Logical Attribute Properties |
Logical Attribute Name | LenderPaidMIInterestRateAdjustmentPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
LenderPaidMIInterestRateAdjustmentPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LenderPaidMIInterestRateAdjustmentPercent Bound Attachments |
Name | Current Value |
LenderPaidMIInterestRateAdjustmentPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LenderPaidMIInterestRateAdjustmentPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LenderPaidMIInterestRateAdjustmentPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LenderPaidMIInterestRateAdjustmentPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LenderPaidMIInterestRateAdjustmentPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffPercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MI_LTVCutoffPercent |
Logical Rolename | |
ColumnName | MI_LTVCutoffPercent |
RoleName | |
Domain | MISMOPercent |
Definition | LTV cutoff for collection of mortgage insurance. |
Note |
MI_LTVCutoffPercent Logical Attribute Properties |
Logical Attribute Name | MI_LTVCutoffPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MI_LTVCutoffPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MI_LTVCutoffPercent Bound Attachments |
Name | Current Value |
MI_LTVCutoffPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MI_LTVCutoffPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICancellationDate |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICancellationDate |
Logical Rolename | |
ColumnName | MICancellationDate |
RoleName | |
Domain | MISMODate |
Definition | Actual cancellation date of mortgage insurance coverage |
Note |
MICancellationDate Logical Attribute Properties |
Logical Attribute Name | MICancellationDate |
Datatype | DATE |
Nullable | NO |
MICancellationDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICancellationDate Bound Attachments |
Name | Current Value |
MICancellationDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICancellationDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICancellationDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICancellationDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICancellationDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MI_LTVCutoffType |
Logical Rolename | |
ColumnName | MI_LTVCutoffType |
RoleName | |
Domain | MI_LTVCutoffEnum |
Definition | Specifies the basis of the mortgage insurance LTV cutoff |
Note |
MI_LTVCutoffType Logical Attribute Properties |
Logical Attribute Name | MI_LTVCutoffType |
Datatype | VARCHAR(0) |
Nullable | YES |
MI_LTVCutoffType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MI_LTVCutoffType Reference Value (Bound to Domain) |
Name | ValidationRule302 |
Description | |
Type | By List |
Value | Value Description |
AppraisedValue | AppraisedValue |
SalesPrice | SalesPrice |
MI_LTVCutoffType Bound Attachments |
Name | Current Value |
MI_LTVCutoffType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MI_LTVCutoffType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MI_LTVCutoffType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificateIdentifier |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICertificateIdentifier |
Logical Rolename | |
ColumnName | MICertificateIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | The number assigned by the private mortgage insurance company to track a loan. |
Note |
MICertificateIdentifier Logical Attribute Properties |
Logical Attribute Name | MICertificateIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
MICertificateIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICertificateIdentifier Bound Attachments |
Name | Current Value |
MICertificateIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICertificateIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificateIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificateIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificateIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICertificationStatusType |
Logical Rolename | |
ColumnName | MICertificationStatusType |
RoleName | |
Domain | MICertificationStatusEnum |
Definition | Defines the party that will obtain an MI Certificate. |
Note |
MICertificationStatusType Logical Attribute Properties |
Logical Attribute Name | MICertificationStatusType |
Datatype | VARCHAR(0) |
Nullable | YES |
MICertificationStatusType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICertificationStatusType Reference Value (Bound to Domain) |
Name | ValidationRule281 |
Description | |
Type | By List |
Value | Value Description |
LenderToObtain | LenderToObtain |
Other | Other |
SellerOfLoanToObtain | SellerOfLoanToObtain |
MICertificationStatusType Bound Attachments |
Name | Current Value |
MICertificationStatusType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICertificationStatusType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICertificationStatusTypeOtherDescription |
Logical Rolename | |
ColumnName | MICertificationStatusTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for MI Certification Status Type. |
Note |
MICertificationStatusTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MICertificationStatusTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MICertificationStatusTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICertificationStatusTypeOtherDescription Bound Attachments |
Name | Current Value |
MICertificationStatusTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICertificationStatusTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICertificationStatusTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICollectedNumberOfMonthsCount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICollectedNumberOfMonthsCount |
Logical Rolename | |
ColumnName | MICollectedNumberOfMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of months of MI escrow that is collected at settlement. |
Note |
MICollectedNumberOfMonthsCount Logical Attribute Properties |
Logical Attribute Name | MICollectedNumberOfMonthsCount |
Datatype | INTEGER |
Nullable | NO |
MICollectedNumberOfMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICollectedNumberOfMonthsCount Bound Attachments |
Name | Current Value |
MICollectedNumberOfMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICollectedNumberOfMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICollectedNumberOfMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICollectedNumberOfMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICollectedNumberOfMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICompanyNameType |
Logical Rolename | |
ColumnName | MICompanyNameType |
RoleName | |
Domain | MICompanyNameEnum |
Definition | To convey the private MI company short/common name from whom the private mortgage insurance coverage was obtained. |
Note |
MICompanyNameType Logical Attribute Properties |
Logical Attribute Name | MICompanyNameType |
Datatype | VARCHAR(0) |
Nullable | YES |
MICompanyNameType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICompanyNameType Reference Value (Bound to Domain) |
Name | ValidationRule282 |
Description | |
Type | By List |
Value | Value Description |
CMG | CMG |
Essent | Essent |
Genworth | Genworth |
MGIC | MGIC |
Other | Other |
PMI | PMI |
Radian | Radian |
RMIC | RMIC |
Triad | Triad |
UGI | UGI |
MICompanyNameType Bound Attachments |
Name | Current Value |
MICompanyNameType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICompanyNameType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICompanyNameTypeOtherDescription |
Logical Rolename | |
ColumnName | MICompanyNameTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the mortgage insurance company name if Other is selected as the mortgage insurance company name. |
Note |
MICompanyNameTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MICompanyNameTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MICompanyNameTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICompanyNameTypeOtherDescription Bound Attachments |
Name | Current Value |
MICompanyNameTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICompanyNameTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICompanyNameTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIConventionalUpfrontPremiumPercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIConventionalUpfrontPremiumPercent |
Logical Rolename | |
ColumnName | MIConventionalUpfrontPremiumPercent |
RoleName | |
Domain | MISMOPercent |
Definition | Percentage of base loan amount paid to the mortgage insurer for initial up-front premium |
Note |
MIConventionalUpfrontPremiumPercent Logical Attribute Properties |
Logical Attribute Name | MIConventionalUpfrontPremiumPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIConventionalUpfrontPremiumPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIConventionalUpfrontPremiumPercent Bound Attachments |
Name | Current Value |
MIConventionalUpfrontPremiumPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIConventionalUpfrontPremiumPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIConventionalUpfrontPremiumPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIConventionalUpfrontPremiumPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIConventionalUpfrontPremiumPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoverageEffectiveDate |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICoverageEffectiveDate |
Logical Rolename | |
ColumnName | MICoverageEffectiveDate |
RoleName | |
Domain | MISMODate |
Definition | The date the current MI policy went into effect. |
Note |
MICoverageEffectiveDate Logical Attribute Properties |
Logical Attribute Name | MICoverageEffectiveDate |
Datatype | DATE |
Nullable | NO |
MICoverageEffectiveDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICoverageEffectiveDate Bound Attachments |
Name | Current Value |
MICoverageEffectiveDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICoverageEffectiveDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoverageEffectiveDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoverageEffectiveDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoverageEffectiveDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICoveragePercent |
Logical Rolename | |
ColumnName | MICoveragePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of mortgage insurance coverage obtained. |
Note |
MICoveragePercent Logical Attribute Properties |
Logical Attribute Name | MICoveragePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MICoveragePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICoveragePercent Bound Attachments |
Name | Current Value |
MICoveragePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICoveragePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICoveragePlanType |
Logical Rolename | |
ColumnName | MICoveragePlanType |
RoleName | |
Domain | MICoveragePlanEnum |
Definition | Specifies the coverage category of mortgage insurance applicable to the loan. |
Note |
MICoveragePlanType Logical Attribute Properties |
Logical Attribute Name | MICoveragePlanType |
Datatype | VARCHAR(0) |
Nullable | YES |
MICoveragePlanType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICoveragePlanType Reference Value (Bound to Domain) |
Name | ValidationRule283 |
Description | |
Type | By List |
Value | Value Description |
LossLimitCap | LossLimitCap |
Other | Other |
Pool | Pool |
RiskSharing | RiskSharing |
SecondLayer | SecondLayer |
StandardPrimary | StandardPrimary |
MICoveragePlanType Bound Attachments |
Name | Current Value |
MICoveragePlanType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICoveragePlanType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICoveragePlanTypeOtherDescription |
Logical Rolename | |
ColumnName | MICoveragePlanTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the description of the type of MI Coverage Plan if Other is selected as the MICoveragePlanType. |
Note |
MICoveragePlanTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MICoveragePlanTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MICoveragePlanTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICoveragePlanTypeOtherDescription Bound Attachments |
Name | Current Value |
MICoveragePlanTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICoveragePlanTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICoveragePlanTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICurrentAnnualPremiumAmount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICurrentAnnualPremiumAmount |
Logical Rolename | |
ColumnName | MICurrentAnnualPremiumAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The current dollar amount paid per year for mortgage insurance. |
Note |
MICurrentAnnualPremiumAmount Logical Attribute Properties |
Logical Attribute Name | MICurrentAnnualPremiumAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MICurrentAnnualPremiumAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICurrentAnnualPremiumAmount Bound Attachments |
Name | Current Value |
MICurrentAnnualPremiumAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICurrentAnnualPremiumAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICurrentAnnualPremiumAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICurrentAnnualPremiumAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICurrentAnnualPremiumAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICushionNumberOfMonthsCount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MICushionNumberOfMonthsCount |
Logical Rolename | |
ColumnName | MICushionNumberOfMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of months of MI escrow that is to be considered in the cushion for aggregate accounting. |
Note |
MICushionNumberOfMonthsCount Logical Attribute Properties |
Logical Attribute Name | MICushionNumberOfMonthsCount |
Datatype | INTEGER |
Nullable | NO |
MICushionNumberOfMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MICushionNumberOfMonthsCount Bound Attachments |
Name | Current Value |
MICushionNumberOfMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MICushionNumberOfMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICushionNumberOfMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MICushionNumberOfMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MICushionNumberOfMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIDurationType |
Logical Rolename | |
ColumnName | MIDurationType |
RoleName | |
Domain | MIDurationEnum |
Definition | Specifies the period of time for which mortgage insurance coverage has been obtained/paid. |
Note |
MIDurationType Logical Attribute Properties |
Logical Attribute Name | MIDurationType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIDurationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIDurationType Reference Value (Bound to Domain) |
Name | ValidationRule285 |
Description | |
Type | By List |
Value | Value Description |
Annual | Annual |
NotApplicable | NotApplicable |
Other | Other |
PeriodicMonthly | PeriodicMonthly |
SingleLifeOfLoan | SingleLifeOfLoan |
SingleSpecific | SingleSpecific |
SplitPremium | SplitPremium |
MIDurationType Bound Attachments |
Name | Current Value |
MIDurationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIDurationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIDurationTypeOtherDescription |
Logical Rolename | |
ColumnName | MIDurationTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the description of the type of MI Duration if Other is selected as the MIDurationType. |
Note |
MIDurationTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MIDurationTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MIDurationTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIDurationTypeOtherDescription Bound Attachments |
Name | Current Value |
MIDurationTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIDurationTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIDurationTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowedIndicator |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIEscrowedIndicator |
Logical Rolename | |
ColumnName | MIEscrowedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether mortgage insurance premium is being collected by the lender/servicer and deposited into an escrow account from which a future payment will be made. |
Note |
MIEscrowedIndicator Logical Attribute Properties |
Logical Attribute Name | MIEscrowedIndicator |
Datatype | BIT |
Nullable | NO |
MIEscrowedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIEscrowedIndicator Bound Attachments |
Name | Current Value |
MIEscrowedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIEscrowedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIEscrowIncludedInAggregateIndicator |
Logical Rolename | |
ColumnName | MIEscrowIncludedInAggregateIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether Private Mortgage Insurance Escrow is to be included in the cushion for Aggregate Accounting. |
Note |
MIEscrowIncludedInAggregateIndicator Logical Attribute Properties |
Logical Attribute Name | MIEscrowIncludedInAggregateIndicator |
Datatype | BIT |
Nullable | NO |
MIEscrowIncludedInAggregateIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIEscrowIncludedInAggregateIndicator Bound Attachments |
Name | Current Value |
MIEscrowIncludedInAggregateIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIEscrowIncludedInAggregateIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAmount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIInitialPremiumAmount |
Logical Rolename | |
ColumnName | MIInitialPremiumAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Amount of the first premium paid to MI. For monthly plans, one months premium; for all other plans, Initial Premium Rate times Base Loan Amount. |
Note |
MIInitialPremiumAmount Logical Attribute Properties |
Logical Attribute Name | MIInitialPremiumAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIInitialPremiumAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIInitialPremiumAmount Bound Attachments |
Name | Current Value |
MIInitialPremiumAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIInitialPremiumAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIInitialPremiumAtClosingType |
Logical Rolename | |
ColumnName | MIInitialPremiumAtClosingType |
RoleName | |
Domain | MIInitialPremiumAtClosingEnum |
Definition | Specifies whether the initial Mortgage Insurance premium is prepaid upon closing or deferred until first principle payment. |
Note |
MIInitialPremiumAtClosingType Logical Attribute Properties |
Logical Attribute Name | MIInitialPremiumAtClosingType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIInitialPremiumAtClosingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIInitialPremiumAtClosingType Reference Value (Bound to Domain) |
Name | ValidationRule286 |
Description | |
Type | By List |
Value | Value Description |
Deferred | Deferred |
Other | Other |
Prepaid | Prepaid |
MIInitialPremiumAtClosingType Bound Attachments |
Name | Current Value |
MIInitialPremiumAtClosingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIInitialPremiumAtClosingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIInitialPremiumAtClosingTypeOtherDescription |
Logical Rolename | |
ColumnName | MIInitialPremiumAtClosingTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | 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. |
Note |
MIInitialPremiumAtClosingTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MIInitialPremiumAtClosingTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MIInitialPremiumAtClosingTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIInitialPremiumAtClosingTypeOtherDescription Bound Attachments |
Name | Current Value |
MIInitialPremiumAtClosingTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIInitialPremiumAtClosingTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumAtClosingTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRateDurationMonthsCount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIInitialPremiumRateDurationMonthsCount |
Logical Rolename | |
ColumnName | MIInitialPremiumRateDurationMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | Indicates the number of months for which the MI Initial Premium Rate applies. |
Note |
MIInitialPremiumRateDurationMonthsCount Logical Attribute Properties |
Logical Attribute Name | MIInitialPremiumRateDurationMonthsCount |
Datatype | INTEGER |
Nullable | NO |
MIInitialPremiumRateDurationMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIInitialPremiumRateDurationMonthsCount Bound Attachments |
Name | Current Value |
MIInitialPremiumRateDurationMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIInitialPremiumRateDurationMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRateDurationMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRateDurationMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRateDurationMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRatePercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIInitialPremiumRatePercent |
Logical Rolename | |
ColumnName | MIInitialPremiumRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | MI initial premium rate percent used to compute the initial MI premium amount. |
Note |
MIInitialPremiumRatePercent Logical Attribute Properties |
Logical Attribute Name | MIInitialPremiumRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIInitialPremiumRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIInitialPremiumRatePercent Bound Attachments |
Name | Current Value |
MIInitialPremiumRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIInitialPremiumRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIInitialPremiumRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationRatePercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumCalculationRatePercent |
Logical Rolename | |
ColumnName | MIPremiumCalculationRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of the principal balance used to calculate the annual PMI premium. |
Note |
MIPremiumCalculationRatePercent Logical Attribute Properties |
Logical Attribute Name | MIPremiumCalculationRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIPremiumCalculationRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumCalculationRatePercent Bound Attachments |
Name | Current Value |
MIPremiumCalculationRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumCalculationRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumCalculationType |
Logical Rolename | |
ColumnName | MIPremiumCalculationType |
RoleName | |
Domain | MIPremiumCalculationEnum |
Definition | Method by which new PMI premium is calculated. |
Note |
MIPremiumCalculationType Logical Attribute Properties |
Logical Attribute Name | MIPremiumCalculationType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIPremiumCalculationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumCalculationType Reference Value (Bound to Domain) |
Name | ValidationRule288 |
Description | |
Type | By List |
Value | Value Description |
PercentOfCurrentBalance | PercentOfCurrentBalance |
PercentOfOriginalBalance | PercentOfOriginalBalance |
MIPremiumCalculationType Bound Attachments |
Name | Current Value |
MIPremiumCalculationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumCalculationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalculationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalendarYearAmount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumCalendarYearAmount |
Logical Rolename | |
ColumnName | MIPremiumCalendarYearAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of the Mortgage Insurance Premiums that the Borrower has paid for the calendar year. |
Note |
MIPremiumCalendarYearAmount Logical Attribute Properties |
Logical Attribute Name | MIPremiumCalendarYearAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIPremiumCalendarYearAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumCalendarYearAmount Bound Attachments |
Name | Current Value |
MIPremiumCalendarYearAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumCalendarYearAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalendarYearAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalendarYearAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumCalendarYearAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedAmount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumFinancedAmount |
Logical Rolename | |
ColumnName | MIPremiumFinancedAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of the up-front premium that is financed |
Note |
MIPremiumFinancedAmount Logical Attribute Properties |
Logical Attribute Name | MIPremiumFinancedAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIPremiumFinancedAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumFinancedAmount Bound Attachments |
Name | Current Value |
MIPremiumFinancedAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumFinancedAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedIndicator |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumFinancedIndicator |
Logical Rolename | |
ColumnName | MIPremiumFinancedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether mortgage insurance premium has been added to loan amount. |
Note |
MIPremiumFinancedIndicator Logical Attribute Properties |
Logical Attribute Name | MIPremiumFinancedIndicator |
Datatype | BIT |
Nullable | NO |
MIPremiumFinancedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumFinancedIndicator Bound Attachments |
Name | Current Value |
MIPremiumFinancedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumFinancedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFinancedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFromClosingAmount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumFromClosingAmount |
Logical Rolename | |
ColumnName | MIPremiumFromClosingAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Amount of MI premium due from closing. Zero for deferred monthly; otherwise is a months, years or life premium for regular monthly, annual, or life of loan premium plans. |
Note |
MIPremiumFromClosingAmount Logical Attribute Properties |
Logical Attribute Name | MIPremiumFromClosingAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIPremiumFromClosingAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumFromClosingAmount Bound Attachments |
Name | Current Value |
MIPremiumFromClosingAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumFromClosingAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFromClosingAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFromClosingAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumFromClosingAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumPaymentType |
Logical Rolename | |
ColumnName | MIPremiumPaymentType |
RoleName | |
Domain | MIPremiumPaymentEnum |
Definition | Defines the source of premium payments and how they are to be paid. |
Note |
MIPremiumPaymentType Logical Attribute Properties |
Logical Attribute Name | MIPremiumPaymentType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIPremiumPaymentType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumPaymentType Reference Value (Bound to Domain) |
Name | ValidationRule289 |
Description | |
Type | By List |
Value | Value Description |
Escrowed | Funds are collected monthly and places in an escrow account to pay the anual priemium when due. |
Financed | Rolled into mortgage. |
Other | Other |
RatePremium | RatePremium |
Upfront | Upfront |
MIPremiumPaymentType Bound Attachments |
Name | Current Value |
MIPremiumPaymentType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumPaymentType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumPaymentTypeOtherDescription |
Logical Rolename | |
ColumnName | MIPremiumPaymentTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the description of the type of MI Premium Payment if Other is selected as the MIPremiumPaymentType. |
Note |
MIPremiumPaymentTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MIPremiumPaymentTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MIPremiumPaymentTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumPaymentTypeOtherDescription Bound Attachments |
Name | Current Value |
MIPremiumPaymentTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumPaymentTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumPaymentTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumRefundableType |
Logical Rolename | |
ColumnName | MIPremiumRefundableType |
RoleName | |
Domain | MIPremiumRefundableEnum |
Definition | Specifies how the unearned portion of any private mortgage insurance premiums will be treated if the private mortgage insurance coverage is canceled. |
Note |
MIPremiumRefundableType Logical Attribute Properties |
Logical Attribute Name | MIPremiumRefundableType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIPremiumRefundableType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumRefundableType Reference Value (Bound to Domain) |
Name | ValidationRule291 |
Description | |
Type | By List |
Value | Value Description |
NotRefundable | NotRefundable |
Other | Other |
Refundable | Refundable |
RefundableWithLimits | RefundableWithLimits |
MIPremiumRefundableType Bound Attachments |
Name | Current Value |
MIPremiumRefundableType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumRefundableType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumRefundableTypeOtherDescription |
Logical Rolename | |
ColumnName | MIPremiumRefundableTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the description of the type of MI Premium Refundable if Other is selected as the MIPremiumRefundableType. |
Note |
MIPremiumRefundableTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MIPremiumRefundableTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MIPremiumRefundableTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumRefundableTypeOtherDescription Bound Attachments |
Name | Current Value |
MIPremiumRefundableTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumRefundableTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumRefundableTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumSourceType |
Logical Rolename | |
ColumnName | MIPremiumSourceType |
RoleName | |
Domain | MIPremiumSourceEnum |
Definition | Defines the source of the MI premium payment. |
Note |
MIPremiumSourceType Logical Attribute Properties |
Logical Attribute Name | MIPremiumSourceType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIPremiumSourceType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumSourceType Reference Value (Bound to Domain) |
Name | ValidationRule292 |
Description | |
Type | By List |
Value | Value Description |
Borrower | Borrower |
BorrowerAndLender | BorrowerAndLender |
Lender | Lender |
Other | Other |
MIPremiumSourceType Bound Attachments |
Name | Current Value |
MIPremiumSourceType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumSourceType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumSourceTypeOtherDescription |
Logical Rolename | |
ColumnName | MIPremiumSourceTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field to collect MI premium source when Other is selected for MI Premium Source Type. |
Note |
MIPremiumSourceTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | MIPremiumSourceTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MIPremiumSourceTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumSourceTypeOtherDescription Bound Attachments |
Name | Current Value |
MIPremiumSourceTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumSourceTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumSourceTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumTermMonthsCount |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIPremiumTermMonthsCount |
Logical Rolename | |
ColumnName | MIPremiumTermMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of months of mortgage insurance coverage paid for. |
Note |
MIPremiumTermMonthsCount Logical Attribute Properties |
Logical Attribute Name | MIPremiumTermMonthsCount |
Datatype | INTEGER |
Nullable | NO |
MIPremiumTermMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIPremiumTermMonthsCount Bound Attachments |
Name | Current Value |
MIPremiumTermMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIPremiumTermMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumTermMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumTermMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIPremiumTermMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalCalculationType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIRenewalCalculationType |
Logical Rolename | |
ColumnName | MIRenewalCalculationType |
RoleName | |
Domain | MIRenewalCalculationEnum |
Definition | Specifies the way in which the renewal premiums will be calculated. |
Note |
MIRenewalCalculationType Logical Attribute Properties |
Logical Attribute Name | MIRenewalCalculationType |
Datatype | VARCHAR(0) |
Nullable | YES |
MIRenewalCalculationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIRenewalCalculationType Reference Value (Bound to Domain) |
Name | ValidationRule294 |
Description | |
Type | By List |
Value | Value Description |
Constant | Constant |
Declining | Declining |
NoRenewals | NoRenewals |
MIRenewalCalculationType Bound Attachments |
Name | Current Value |
MIRenewalCalculationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIRenewalCalculationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalCalculationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalCalculationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalCalculationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalPremiumRatePercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIRenewalPremiumRatePercent |
Logical Rolename | |
ColumnName | MIRenewalPremiumRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The renewal premium rate that will be applied to calculate the dollar amount of the MI renewal premium. |
Note |
MIRenewalPremiumRatePercent Logical Attribute Properties |
Logical Attribute Name | MIRenewalPremiumRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MIRenewalPremiumRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIRenewalPremiumRatePercent Bound Attachments |
Name | Current Value |
MIRenewalPremiumRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIRenewalPremiumRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalPremiumRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalPremiumRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIRenewalPremiumRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIScheduledTerminationDate |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MIScheduledTerminationDate |
Logical Rolename | |
ColumnName | MIScheduledTerminationDate |
RoleName | |
Domain | MISMODate |
Definition | The projected mandatory date the mortgage insurance must be terminated when a set loan to value percent is reached as identified by HOEPA regulations. Also know as Mandatory MI Termination Date on PMI disclosure forms. |
Note |
MIScheduledTerminationDate Logical Attribute Properties |
Logical Attribute Name | MIScheduledTerminationDate |
Datatype | DATE |
Nullable | NO |
MIScheduledTerminationDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIScheduledTerminationDate Bound Attachments |
Name | Current Value |
MIScheduledTerminationDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIScheduledTerminationDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIScheduledTerminationDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIScheduledTerminationDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIScheduledTerminationDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MISourceType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MISourceType |
Logical Rolename | |
ColumnName | MISourceType |
RoleName | |
Domain | MISourceEnum |
Definition | The source (FHA or Private) of mortgage protection insurance. |
Note |
MISourceType Logical Attribute Properties |
Logical Attribute Name | MISourceType |
Datatype | VARCHAR(0) |
Nullable | YES |
MISourceType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MISourceType Reference Value (Bound to Domain) |
Name | ValidationRule299 |
Description | |
Type | By List |
Value | Value Description |
FHA | FHA |
PMI | PMI |
MISourceType Bound Attachments |
Name | Current Value |
MISourceType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MISourceType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MISourceType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MISourceType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MISourceType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MISplitPremiumUpfrontPercent |
Base Entity | MI_DATA_DETAIL |
Attribute Name | MISplitPremiumUpfrontPercent |
Logical Rolename | |
ColumnName | MISplitPremiumUpfrontPercent |
RoleName | |
Domain | MISMOPercent |
Definition | Reflects the actual up-front MI Premium percent associated with the plan. |
Note |
MISplitPremiumUpfrontPercent Logical Attribute Properties |
Logical Attribute Name | MISplitPremiumUpfrontPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
MISplitPremiumUpfrontPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MISplitPremiumUpfrontPercent Bound Attachments |
Name | Current Value |
MISplitPremiumUpfrontPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MISplitPremiumUpfrontPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MISplitPremiumUpfrontPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MISplitPremiumUpfrontPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MISplitPremiumUpfrontPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonType |
Base Entity | MI_DATA_DETAIL |
Attribute Name | PrimaryMIAbsenceReasonType |
Logical Rolename | |
ColumnName | PrimaryMIAbsenceReasonType |
RoleName | |
Domain | PrimaryMIAbsenceReasonEnum |
Definition | Specifies the reason that primary mortgage insurance is not required or provided. |
Note |
PrimaryMIAbsenceReasonType Logical Attribute Properties |
Logical Attribute Name | PrimaryMIAbsenceReasonType |
Datatype | VARCHAR(0) |
Nullable | YES |
PrimaryMIAbsenceReasonType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PrimaryMIAbsenceReasonType Reference Value (Bound to Domain) |
Name | ValidationRule376 |
Description | |
Type | By List |
Value | Value Description |
CharterParticipation | CharterParticipation |
DelinquencyDisposition | DelinquencyDisposition |
InvestorPurchasedMortgageInsurance | InvestorPurchasedMortgageInsurance |
MICanceledBasedOnCurrentLTV | MICanceledBasedOnCurrentLTV |
NoMIBasedOnOriginalLTV | NoMIBasedOnOriginalLTV |
Other | Other |
PledgedAsset | PledgedAsset |
PoolCoverage | PoolCoverage |
Repurchase | Repurchase |
SelfInsured | SelfInsured |
PrimaryMIAbsenceReasonType Bound Attachments |
Name | Current Value |
PrimaryMIAbsenceReasonType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PrimaryMIAbsenceReasonType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonTypeOtherDescription |
Base Entity | MI_DATA_DETAIL |
Attribute Name | PrimaryMIAbsenceReasonTypeOtherDescription |
Logical Rolename | |
ColumnName | PrimaryMIAbsenceReasonTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Primary MI Absence Reason Type. |
Note |
PrimaryMIAbsenceReasonTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | PrimaryMIAbsenceReasonTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
PrimaryMIAbsenceReasonTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PrimaryMIAbsenceReasonTypeOtherDescription Bound Attachments |
Name | Current Value |
PrimaryMIAbsenceReasonTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PrimaryMIAbsenceReasonTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PrimaryMIAbsenceReasonTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ScheduledAmortizationMidpointDate |
Base Entity | MI_DATA_DETAIL |
Attribute Name | ScheduledAmortizationMidpointDate |
Logical Rolename | |
ColumnName | ScheduledAmortizationMidpointDate |
RoleName | |
Domain | MISMODate |
Definition | Based on scheduled amortization, date at which the loan due date reaches the midpoint of the loans amortization period (e.g., for a 360 month loan, the date of month number 181). |
Note |
ScheduledAmortizationMidpointDate Logical Attribute Properties |
Logical Attribute Name | ScheduledAmortizationMidpointDate |
Datatype | DATE |
Nullable | NO |
ScheduledAmortizationMidpointDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ScheduledAmortizationMidpointDate Bound Attachments |
Name | Current Value |
ScheduledAmortizationMidpointDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ScheduledAmortizationMidpointDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ScheduledAmortizationMidpointDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ScheduledAmortizationMidpointDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ScheduledAmortizationMidpointDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SellerMIPaidToDate |
Base Entity | MI_DATA_DETAIL |
Attribute Name | SellerMIPaidToDate |
Logical Rolename | |
ColumnName | SellerMIPaidToDate |
RoleName | |
Domain | MISMODate |
Definition | The date through which MI has been paid by the seller. |
Note |
SellerMIPaidToDate Logical Attribute Properties |
Logical Attribute Name | SellerMIPaidToDate |
Datatype | DATE |
Nullable | NO |
SellerMIPaidToDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SellerMIPaidToDate Bound Attachments |
Name | Current Value |
SellerMIPaidToDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SellerMIPaidToDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SellerMIPaidToDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SellerMIPaidToDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SellerMIPaidToDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |