CurrentFirstMortgageHolderType |
Base Entity | REFINANCE |
Attribute Name | CurrentFirstMortgageHolderType |
Logical Rolename | |
ColumnName | CurrentFirstMortgageHolderType |
RoleName | |
Domain | CurrentFirstMortgageHolderEnum |
Definition | Specifies the investor holding the first mortgage that is being refinanced. |
Note |
CurrentFirstMortgageHolderType Logical Attribute Properties |
Logical Attribute Name | CurrentFirstMortgageHolderType |
Datatype | VARCHAR(0) |
Nullable | YES |
CurrentFirstMortgageHolderType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CurrentFirstMortgageHolderType Reference Value (Bound to Domain) |
Name | ValidationRule123 |
Description | |
Type | By List |
Value | Value Description |
FNM | Fannie Mae |
FRE | Freddie Mac |
Other | Other |
Unknown | Unknown |
CurrentFirstMortgageHolderType Bound Attachments |
Name | Current Value |
CurrentFirstMortgageHolderType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CurrentFirstMortgageHolderType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderTypeOtherDescription |
Base Entity | REFINANCE |
Attribute Name | CurrentFirstMortgageHolderTypeOtherDescription |
Logical Rolename | |
ColumnName | CurrentFirstMortgageHolderTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Current First Mortgage Holder Type. |
Note |
CurrentFirstMortgageHolderTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | CurrentFirstMortgageHolderTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
CurrentFirstMortgageHolderTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CurrentFirstMortgageHolderTypeOtherDescription Bound Attachments |
Name | Current Value |
CurrentFirstMortgageHolderTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CurrentFirstMortgageHolderTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CurrentFirstMortgageHolderTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EstimatedCashOutAmount |
Base Entity | REFINANCE |
Attribute Name | EstimatedCashOutAmount |
Logical Rolename | |
ColumnName | EstimatedCashOutAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The estimated amount of cash that the borrower may receive at closing based on a calculation agreed to by the parties to the transaction. |
Note |
EstimatedCashOutAmount Logical Attribute Properties |
Logical Attribute Name | EstimatedCashOutAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EstimatedCashOutAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EstimatedCashOutAmount Bound Attachments |
Name | Current Value |
EstimatedCashOutAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EstimatedCashOutAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EstimatedCashOutAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EstimatedCashOutAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EstimatedCashOutAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NonStructuralAlterationsConventionalAmount |
Base Entity | REFINANCE |
Attribute Name | NonStructuralAlterationsConventionalAmount |
Logical Rolename | |
ColumnName | NonStructuralAlterationsConventionalAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of non-structural alterations, improvements and repairs. |
Note |
NonStructuralAlterationsConventionalAmount Logical Attribute Properties |
Logical Attribute Name | NonStructuralAlterationsConventionalAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
NonStructuralAlterationsConventionalAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NonStructuralAlterationsConventionalAmount Bound Attachments |
Name | Current Value |
NonStructuralAlterationsConventionalAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
NonStructuralAlterationsConventionalAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NonStructuralAlterationsConventionalAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NonStructuralAlterationsConventionalAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NonStructuralAlterationsConventionalAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceAssetsAcquiredAmount |
Base Entity | REFINANCE |
Attribute Name | RefinanceAssetsAcquiredAmount |
Logical Rolename | |
ColumnName | RefinanceAssetsAcquiredAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount applied to assets aquired with the proceeds from a refinance transaction. |
Note |
RefinanceAssetsAcquiredAmount Logical Attribute Properties |
Logical Attribute Name | RefinanceAssetsAcquiredAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RefinanceAssetsAcquiredAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinanceAssetsAcquiredAmount Bound Attachments |
Name | Current Value |
RefinanceAssetsAcquiredAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinanceAssetsAcquiredAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceAssetsAcquiredAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceAssetsAcquiredAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceAssetsAcquiredAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutAmount |
Base Entity | REFINANCE |
Attribute Name | RefinanceCashOutAmount |
Logical Rolename | |
ColumnName | RefinanceCashOutAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of cash the borrower will receive at the closing of the loan on a refinance transaction. |
Note |
RefinanceCashOutAmount Logical Attribute Properties |
Logical Attribute Name | RefinanceCashOutAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RefinanceCashOutAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinanceCashOutAmount Bound Attachments |
Name | Current Value |
RefinanceCashOutAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinanceCashOutAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutDeterminationType |
Base Entity | REFINANCE |
Attribute Name | RefinanceCashOutDeterminationType |
Logical Rolename | |
ColumnName | RefinanceCashOutDeterminationType |
RoleName | |
Domain | RefinanceCashOutDeterminationEnum |
Definition | Specifies how the lender has classified a refinanced loan. |
Note |
RefinanceCashOutDeterminationType Logical Attribute Properties |
Logical Attribute Name | RefinanceCashOutDeterminationType |
Datatype | VARCHAR(0) |
Nullable | YES |
RefinanceCashOutDeterminationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinanceCashOutDeterminationType Reference Value (Bound to Domain) |
Name | ValidationRule420 |
Description | |
Type | By List |
Value | Value Description |
CashOut | CashOut |
LimitedCashOut | LimitedCashOut |
NoCashOut | NoCashOut |
Unknown | Unknown |
RefinanceCashOutDeterminationType Bound Attachments |
Name | Current Value |
RefinanceCashOutDeterminationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinanceCashOutDeterminationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutDeterminationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutDeterminationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutDeterminationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutPercent |
Base Entity | REFINANCE |
Attribute Name | RefinanceCashOutPercent |
Logical Rolename | |
ColumnName | RefinanceCashOutPercent |
RoleName | |
Domain | MISMOPercent |
Definition | Percentage of Base Loan Amount that will be dispersed as cash to the borrower. |
Note |
RefinanceCashOutPercent Logical Attribute Properties |
Logical Attribute Name | RefinanceCashOutPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RefinanceCashOutPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinanceCashOutPercent Bound Attachments |
Name | Current Value |
RefinanceCashOutPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinanceCashOutPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceCashOutPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceDebtReductionAmount |
Base Entity | REFINANCE |
Attribute Name | RefinanceDebtReductionAmount |
Logical Rolename | |
ColumnName | RefinanceDebtReductionAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount applied to debt reduction from the proceeds from refinance transaction. |
Note |
RefinanceDebtReductionAmount Logical Attribute Properties |
Logical Attribute Name | RefinanceDebtReductionAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RefinanceDebtReductionAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinanceDebtReductionAmount Bound Attachments |
Name | Current Value |
RefinanceDebtReductionAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinanceDebtReductionAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceDebtReductionAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceDebtReductionAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceDebtReductionAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceHomeImprovementAmount |
Base Entity | REFINANCE |
Attribute Name | RefinanceHomeImprovementAmount |
Logical Rolename | |
ColumnName | RefinanceHomeImprovementAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount applied to home improvements from the proceeds from a refinance transaction. |
Note |
RefinanceHomeImprovementAmount Logical Attribute Properties |
Logical Attribute Name | RefinanceHomeImprovementAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RefinanceHomeImprovementAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinanceHomeImprovementAmount Bound Attachments |
Name | Current Value |
RefinanceHomeImprovementAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinanceHomeImprovementAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceHomeImprovementAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceHomeImprovementAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinanceHomeImprovementAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeType |
Base Entity | REFINANCE |
Attribute Name | RefinancePrimaryPurposeType |
Logical Rolename | |
ColumnName | RefinancePrimaryPurposeType |
RoleName | |
Domain | RefinancePrimaryPurposeEnum |
Definition | Specifies the primary purpose of the refinance. |
Note |
RefinancePrimaryPurposeType Logical Attribute Properties |
Logical Attribute Name | RefinancePrimaryPurposeType |
Datatype | VARCHAR(0) |
Nullable | YES |
RefinancePrimaryPurposeType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinancePrimaryPurposeType Reference Value (Bound to Domain) |
Name | ValidationRule422 |
Description | |
Type | By List |
Value | Value Description |
AssetAcquisition | AssetAcquisition |
CapitalizedInterestTaxesInsuranceOrFees | CapitalizedInterestTaxesInsuranceOrFees |
Cash | Cash |
Convenience | Convenience |
DebtConsolidation | DebtConsolidation |
Education | Education |
EquityBuyout | EquityBuyout |
HomeImprovement | HomeImprovement |
InterestRateReduction | To decrease the Note Rate Percent |
Medical | Medical |
MortgageTermReduction | To shorten the maturity period of the note |
Other | Other |
PayoffLeaseholdInterest | PayoffLeaseholdInterest |
PrimaryLienPayoff | PrimaryLienPayoff |
SecondaryLienPayoff | SecondaryLienPayoff |
SpecialPurpose | SpecialPurpose |
UnsecuredLienPayoff | UnsecuredLienPayoff |
Unspecified | Unspecified |
RefinancePrimaryPurposeType Bound Attachments |
Name | Current Value |
RefinancePrimaryPurposeType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinancePrimaryPurposeType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeTypeOtherDescription |
Base Entity | REFINANCE |
Attribute Name | RefinancePrimaryPurposeTypeOtherDescription |
Logical Rolename | |
ColumnName | RefinancePrimaryPurposeTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Refinance Primary Purpose Type. |
Note |
RefinancePrimaryPurposeTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | RefinancePrimaryPurposeTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
RefinancePrimaryPurposeTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RefinancePrimaryPurposeTypeOtherDescription Bound Attachments |
Name | Current Value |
RefinancePrimaryPurposeTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RefinancePrimaryPurposeTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RefinancePrimaryPurposeTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SecondaryFinancingRefinanceIndicator |
Base Entity | REFINANCE |
Attribute Name | SecondaryFinancingRefinanceIndicator |
Logical Rolename | |
ColumnName | SecondaryFinancingRefinanceIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether a subordinate mortgage will be paid off by the refinance and rolled into the new first mortgage balance. Used for refinances. |
Note |
SecondaryFinancingRefinanceIndicator Logical Attribute Properties |
Logical Attribute Name | SecondaryFinancingRefinanceIndicator |
Datatype | BIT |
Nullable | NO |
SecondaryFinancingRefinanceIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SecondaryFinancingRefinanceIndicator Bound Attachments |
Name | Current Value |
SecondaryFinancingRefinanceIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SecondaryFinancingRefinanceIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SecondaryFinancingRefinanceIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SecondaryFinancingRefinanceIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SecondaryFinancingRefinanceIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructuralAlterationsConventionalAmount |
Base Entity | REFINANCE |
Attribute Name | StructuralAlterationsConventionalAmount |
Logical Rolename | |
ColumnName | StructuralAlterationsConventionalAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of structural alterations, improvements, and repairs. |
Note |
StructuralAlterationsConventionalAmount Logical Attribute Properties |
Logical Attribute Name | StructuralAlterationsConventionalAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
StructuralAlterationsConventionalAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
StructuralAlterationsConventionalAmount Bound Attachments |
Name | Current Value |
StructuralAlterationsConventionalAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
StructuralAlterationsConventionalAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructuralAlterationsConventionalAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
StructuralAlterationsConventionalAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
StructuralAlterationsConventionalAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPayoffAmount |
Base Entity | REFINANCE |
Attribute Name | TotalPriorLienPayoffAmount |
Logical Rolename | |
ColumnName | TotalPriorLienPayoffAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total dollar amount of the refinance proceeds that is applied to liens on the subject property. CALCULATED RESULTS FIELD |
Note |
TotalPriorLienPayoffAmount Logical Attribute Properties |
Logical Attribute Name | TotalPriorLienPayoffAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TotalPriorLienPayoffAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TotalPriorLienPayoffAmount Bound Attachments |
Name | Current Value |
TotalPriorLienPayoffAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TotalPriorLienPayoffAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPayoffAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPayoffAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPayoffAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPrepaymentPenaltyAmount |
Base Entity | REFINANCE |
Attribute Name | TotalPriorLienPrepaymentPenaltyAmount |
Logical Rolename | |
ColumnName | TotalPriorLienPrepaymentPenaltyAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total dollar amount of the prepayment penalty that is incurred for all liens being paid off as a result of the refinance. |
Note |
TotalPriorLienPrepaymentPenaltyAmount Logical Attribute Properties |
Logical Attribute Name | TotalPriorLienPrepaymentPenaltyAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TotalPriorLienPrepaymentPenaltyAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TotalPriorLienPrepaymentPenaltyAmount Bound Attachments |
Name | Current Value |
TotalPriorLienPrepaymentPenaltyAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TotalPriorLienPrepaymentPenaltyAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPrepaymentPenaltyAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPrepaymentPenaltyAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPriorLienPrepaymentPenaltyAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |