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