DownPaymentAmount |
Base Entity | DOWN_PAYMENT |
Attribute Name | DownPaymentAmount |
Logical Rolename | |
ColumnName | DownPaymentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount of the borrowers Down Payment Type. This may be collected on the URLA in Section II (Source of Down Payment). |
Note |
DownPaymentAmount Logical Attribute Properties |
Logical Attribute Name | DownPaymentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
DownPaymentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DownPaymentAmount Bound Attachments |
Name | Current Value |
DownPaymentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DownPaymentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber |
Base Entity | DOWN_PAYMENT |
Attribute Name | SequenceNumber |
Logical Rolename | |
ColumnName | SequenceNumber |
RoleName | |
Domain | XSD:Integer |
Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
Note |
SequenceNumber Logical Attribute Properties |
Logical Attribute Name | SequenceNumber |
Datatype | INTEGER |
Nullable | YES |
SequenceNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SequenceNumber Bound Attachments |
Name | Current Value |
SequenceNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SequenceNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsType |
Base Entity | DOWN_PAYMENT |
Attribute Name | DownPaymentFundsType |
Logical Rolename | |
ColumnName | DownPaymentFundsType |
RoleName | |
Domain | DownPaymentFundsEnum |
Definition | Monetary sources commonly used for the down payment on a mortgage loan transaction.SOURCE Collected on URLA Section II (Source of Down Payment). |
Note |
DownPaymentFundsType Logical Attribute Properties |
Logical Attribute Name | DownPaymentFundsType |
Datatype | VARCHAR(0) |
Nullable | YES |
DownPaymentFundsType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DownPaymentFundsType Reference Value (Bound to Domain) |
Name | ValidationRule139 |
Description | |
Type | By List |
Value | Value Description |
BridgeLoan | BridgeLoan |
CashOrOtherEquity | CashOrOtherEquity |
CashOnHand | CashOnHand |
CheckingSavings | CheckingSavings |
Contribution | Contribution |
CreditCard | CreditCard |
DepositOnSalesContract | DepositOnSalesContract |
EquityOnPendingSale | EquityOnPendingSale |
EquityOnSoldProperty | EquityOnSoldProperty |
EquityOnSubjectProperty | EquityOnSubjectProperty |
ForgivableSecuredLoan | ForgivableSecuredLoan |
GiftFunds | GiftFunds |
HousingRelocation | HousingRelocation |
LifeInsuranceCashValue | LifeInsuranceCashValue |
LotEquity | LotEquity |
Other | Other |
PledgedCollateral | PledgedCollateral |
PremiumFunds | PremiumFunds |
RentWithOptionToPurchase | RentWithOptionToPurchase |
RetirementFunds | RetirementFunds |
SaleOfChattel | SaleOfChattel |
SalesPriceAdjustment | SalesPriceAdjustment |
SecondaryFinancing | SecondaryFinancing |
SecuredBorrowedFunds | SecuredBorrowedFunds |
StocksAndBonds | StocksAndBonds |
SweatEquity | SweatEquity |
TradeEquity | TradeEquity |
TrustFunds | TrustFunds |
UnsecuredBorrowedFunds | UnsecuredBorrowedFunds |
DownPaymentFundsType Bound Attachments |
Name | Current Value |
DownPaymentFundsType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DownPaymentFundsType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsTypeOtherDescription |
Base Entity | DOWN_PAYMENT |
Attribute Name | DownPaymentFundsTypeOtherDescription |
Logical Rolename | |
ColumnName | DownPaymentFundsTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Down Payment Funds Type. |
Note |
DownPaymentFundsTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | DownPaymentFundsTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
DownPaymentFundsTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DownPaymentFundsTypeOtherDescription Bound Attachments |
Name | Current Value |
DownPaymentFundsTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DownPaymentFundsTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentFundsTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionType |
Base Entity | DOWN_PAYMENT |
Attribute Name | DownPaymentOptionType |
Logical Rolename | |
ColumnName | DownPaymentOptionType |
RoleName | |
Domain | DownPaymentOptionEnum |
Definition | Specifies the type of option used to facilitate the borrowers down payment. |
Note |
DownPaymentOptionType Logical Attribute Properties |
Logical Attribute Name | DownPaymentOptionType |
Datatype | VARCHAR(0) |
Nullable | YES |
DownPaymentOptionType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DownPaymentOptionType Reference Value (Bound to Domain) |
Name | ValidationRule140 |
Description | |
Type | By List |
Value | Value Description |
FivePercentOption | FivePercentOption |
FNM97Option | FNM97Option |
Other | Other |
ThreeTwoOption | ThreeTwoOption |
DownPaymentOptionType Bound Attachments |
Name | Current Value |
DownPaymentOptionType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DownPaymentOptionType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionTypeOtherDescription |
Base Entity | DOWN_PAYMENT |
Attribute Name | DownPaymentOptionTypeOtherDescription |
Logical Rolename | |
ColumnName | DownPaymentOptionTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Down Payment Option Type. |
Note |
DownPaymentOptionTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | DownPaymentOptionTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
DownPaymentOptionTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DownPaymentOptionTypeOtherDescription Bound Attachments |
Name | Current Value |
DownPaymentOptionTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
DownPaymentOptionTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DownPaymentOptionTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceType |
Base Entity | DOWN_PAYMENT |
Attribute Name | FundSourceType |
Logical Rolename | |
ColumnName | FundSourceType |
RoleName | |
Domain | FundSourceEnum |
Definition | The party providing the associated funds. |
Note |
FundSourceType Logical Attribute Properties |
Logical Attribute Name | FundSourceType |
Datatype | VARCHAR(0) |
Nullable | YES |
FundSourceType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FundSourceType Reference Value (Bound to Domain) |
Name | ValidationRule185 |
Description | |
Type | By List |
Value | Value Description |
Borrower | Party who incurred the obligation for the mortgage loan. |
Builder | Party who constructed the property serving as collateral for the mortgage loan. |
CommunityNonProfit | A nonprofit organization with no religious affiliation |
Employer | Party who provides income to the Borrower in exchange for work. |
FederalAgency | A department of the national government responsible for the oversight and administration of a specific function. |
Lender | Party funding the mortgage loan. |
LocalAgency | An administrative authority over areas that are smaller than a state, for example, counties, cities, or townships. |
NonParentRelative | An individual related to the borrower that is not the borrower's legal parent or guardian. |
Other | Other |
Parent | Borrower's mother or father |
PropertySeller | Party from whom the borrower purchased the property serving as collateral for the mortgage loan. |
ReligiousNonProfit | A nonprofit organization affiliated with a religion. |
StateAgency | An administrative authority one of the fifty states making up the United States. |
Unknown | Party providing the funding is not known. |
UnrelatedFriend | Party having a non-familial relationship to the Borrower |
FundSourceType Bound Attachments |
Name | Current Value |
FundSourceType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
FundSourceType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceTypeOtherDescription |
Base Entity | DOWN_PAYMENT |
Attribute Name | FundSourceTypeOtherDescription |
Logical Rolename | |
ColumnName | FundSourceTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | Used to collect additional information when Other is selected for Fund Source Type. |
Note |
FundSourceTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | FundSourceTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
FundSourceTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FundSourceTypeOtherDescription Bound Attachments |
Name | Current Value |
FundSourceTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
FundSourceTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FundSourceTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertySellerFundingIndicator |
Base Entity | DOWN_PAYMENT |
Attribute Name | PropertySellerFundingIndicator |
Logical Rolename | |
ColumnName | PropertySellerFundingIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether some or all of the down payment was funded by the Property Seller either directly or indirectly through a community or religious non profit. |
Note |
PropertySellerFundingIndicator Logical Attribute Properties |
Logical Attribute Name | PropertySellerFundingIndicator |
Datatype | BIT |
Nullable | NO |
PropertySellerFundingIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertySellerFundingIndicator Bound Attachments |
Name | Current Value |
PropertySellerFundingIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertySellerFundingIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertySellerFundingIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertySellerFundingIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertySellerFundingIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |