INVESTOR_LOAN_INFORMATION 
EntityType  Dependent 
Logical Entity Name  INVESTOR_LOAN_INFORMATION 
Default Table Name  DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/INVESTOR_LOAN_INFORMATION 
Definition  Data specific to the relationship between the seller and the investor, including the reporting and financial obligations between the seller, the servicer, and the investor. The structure also holds data on the investor’s interest in the Delivery Loan. 
Note 
 

INVESTOR_LOAN_INFORMATION Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
BaseGuarantyFeePercent  MISMOPercent  DECIMAL(0, 2)  NO  The guaranty fee rate prior to applying any adjustments, such as buyup/buydown. This can be specified in a price sheet, commitment, or other agreement. The guaranty fee is a portion of the interest on the loan that is paid to a party to ensure the timely 
ConcurrentServicingTransferIndicator  MISMOIndicator  BIT  NO  Indicates that servicing is transferred concurrent with loan delivery. 
ContractVarianceCode  MISMOCode  VARCHAR(0)  NO  A code assigned by the contracting system identifying a variance from the master contract. 
ContractVarianceCodeIssuerType  ContractVarianceCodeIssuerEnum  VARCHAR(0)  YES  Identifying the party who issued the variance code.
 
ContractVarianceCodeIssuerTypeOtherDescription  MISMOString  VARCHAR(0)  NO  The description of the Contract Variance Code Issuer Type when Other is selected as the option from the enumerated list. 
ExceptionInterestAdjustmentDayMethodType  ExceptionInterestAdjustmentDayMethodEnum  VARCHAR(0)  YES  The day basis on which the exception interest adjustment is computed based on the servicing contract.
 
ExecutionType  ExecutionEnum  VARCHAR(0)  YES  Specifies the type of execution through which the loan was purchased by an investor.
 
ExecutionTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Execution Type. 
FundingInterestAdjustmentDayMethodType  FundingInterestAdjustmentDayMethodEnum  VARCHAR(0)  YES  The day basis on which the funding interest adjustment is computed based on the purchase contract.
 
GuaranteeFeeAddOnIndicator  MISMOIndicator  BIT  NO  Indicates whether an eligible Seller has elected the Add On or Post-Settlement delivery fees for a specific Mortgage. 
GuarantyFeeAfterAlternatePaymentMethodPercent  MISMOPercent  DECIMAL(0, 2)  NO  Contractual guaranty fee (after adjusting for the alternate payment method (APM) remittance cycle, if applicable) for an Mortgage Backed Security (MBS) pool mortgage. 
GuarantyFeePercent  MISMOPercent  DECIMAL(0, 2)  NO  The guaranty fee rate after applying all adjustments to the guaranty fee, such as buyup/buydown. The guaranty fee is a portion of the interest on the loan that is paid to a party to guarantee the timely payment of interest and principal to the holders of 
InterestVarianceToleranceMaximumAmount  MISMOAmount  DECIMAL(0, 2)  NO  The maximum allowed dollar amount variance between the reported and the expected or scheduled interest. 
InvestorCollateralProgramIdentifier  MISMOIdentifier  VARCHAR(0)  NO  Identifies the collateral program associated with the loan as identified by a specific entity. The entity may be referenced using the OwnerURI attribute. 
InvestorCommitmentTakeoutPricePercent  MISMOPercent  DECIMAL(0, 2)  NO  The investors committed takeout price for a loan expressed as a precentage. 
InvestorDealIdentifier  MISMOIdentifier  VARCHAR(0)  NO  The unique identifier assigned by the investor to a single family structured transaction. 
InvestorGroupingIdentifier  MISMOIdentifier  VARCHAR(0)  NO  A unique identifier that segregates loans for a specific investor according to defined characteristics, such as interest rate, service fee, pool, asset group, etc. 
InvestorGuarantyFeeAfterBuyupBuydownPercent  MISMOPercent  DECIMAL(0, 2)  NO  The investor guaranty fee rate after any addition or reduction to the base guaranty fee rate due to a guaranty fee buyup or buydown. The investor guaranty fee is a portion of the interest on the loan that is paid to a party to guarantee the timely payment 
InvestorHeldCollateralPercent  MISMOPercent  DECIMAL(0, 2)  NO  The percentage of the Original Loan Balance that is being held as collateral by the investor for default costs on the loan. 
InvestorInstitutionIdentifier  MISMOIdentifier  VARCHAR(0)  NO  Identifies the secondary mortgage market institution (investor) associated with the lender or trading partner. 
InvestorLoanCommitmentExpirationDate  MISMODate  DATE  NO  The expiration date for acommitment by an investor to acquire a loan. 
InvestorLoanEarlyPayoffPenaltyWaiverIndicator  MISMOIndicator  BIT  NO  Indicates that the investor waives the full prepayment penalties 
InvestorLoanEffectiveDate  MISMODate  DATE  NO  The due date of the first payment to the investor. 
InvestorLoanPartialPrepaymentPenaltyWaiverIndicator  MISMOIndicator  BIT  NO  Indicates that the investor waives the curtailment penalties 
InvestorMasterCommitmentIdentifier  MISMOIdentifier  VARCHAR(0)  NO  The unique identifier of the master commitment that states the terms under which a lender and an investor agree to deliver/receive mortgage loans in exchange for funds or securities. Subordinate commitments with further delineation of conditions are creat 
InvestorOwnershipPercent  MISMOPercent  DECIMAL(0, 2)  NO  Identifies the percentage amount of the loan owned by the investor 
InvestorOwnershipType  InvestorOwnershipEnum  VARCHAR(0)  YES  Identifies the ownership status of the investor.
 
InvestorProductPlanIdentifier  MISMOIdentifier  VARCHAR(0)  NO  Specifies the source of the list for identifiers of the adjustable loan product being financed. Used for the Fannie Mae Product Plan, Freddie Mac Product Plan and other investor product plans. 
InvestorRemittanceDay  MISMODay  DATE  NO  The day of the month on which principal and interest for the loan are remitted by the servicer to the investor. 
InvestorRemittanceType  InvestorRemittanceEnum  VARCHAR(0)  YES  This describes the contractual accounting method used to calculate the funds received by the Servicer from the borrower that are due to the investor.
 
InvestorRemittanceTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field used to capture the Investor Remittance Type if Other is selected. 
InvestorReportingMethodType  InvestorReportingMethodEnum  VARCHAR(0)  YES  Specifies the reporting method required by the investor from the servicer.
 
InvestorRequiredMarginPercent  MISMOPercent  DECIMAL(0, 2)  NO  Field used in the pass through calculation when the Bottom Up method is used. 
InvestorServicingFeeAmount  MISMOAmount  DECIMAL(0, 2)  NO  The fixed dollar amount that is paid to the servicer by the investor for servicing the mortgage if the service fee is not expressed as a rate. 
InvestorServicingFeeRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The percentage of interest collected that is paid to the servicer by the investor for servicing the mortgage (gross) 
LastReportedToInvestorPrincipalBalanceAmount  MISMOAmount  DECIMAL(0, 2)  NO  Last principal balance reported to the investor 
LateDeliveryGraceDaysCount  MISMOCount  INTEGER  NO  The number of days allowed for late delivery of the loan, beyond the scheduled delivery date. 
LenderTargetFundingDate  MISMODate  DATE  NO  The date the lender selects to have their Whole Loan purchase funded. Proceeds are typically wired to the lender 24 hours after the purchase of the loan. By selecting this date, the lender manages when the funds are to be wired. 
LoanAcquisitionScheduledUPBAmount  MISMOAmount  DECIMAL(0, 2)  NO  The scheduled unpaid principal balance of the mortgage as of loan acquisition or the issue date of the associated security. 
LoanBuyupBuydownBasisPointNumber  MISMONumeric  DECIMAL(0, 2)  NO  The number of basis points of loan level buyup/buydown selected by the seller for this mortgage. 
LoanBuyupBuydownType  LoanBuyupBuydownEnum  VARCHAR(0)  YES  Specifies the type of buyup or buydown an eligible Seller has elected to exercise for a specific mortgage.
 
LoanBuyupBuydownTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to provide additional information when Other is selected vor Loan Buyup Buydown Type. 
LoanDefaultedReportingFrequencyType  LoanDefaultedReportingFrequencyEnum  VARCHAR(0)  YES  The frequency that the servicer must report for loans that are in default.
 
LoanDefaultLossPartyType  LoanDefaultLossPartyEnum  VARCHAR(0)  YES  Indicates the party that bears the default loss for the loan.
 
LoanDelinquencyAdvanceDaysCount  MISMOCount  INTEGER  NO  The number of days after which a servicer can stop advancing funds on a delinquent loan. 
LoanFundingAdvancedAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount disbursed under a loan agreement in advance of full funding. 
LoanPriorOwnerName  MISMOString  VARCHAR(0)  NO  The name of the legal entity from which the seller acquired the loan. 
LoanPurchaseDiscountAmount  MISMOAmount  DECIMAL(0, 2)  NO  The difference between the dollar price paid for the loan and its UPB at the time of purchase when the UPB is less than price paid. 
LoanPurchasePremiumAmount  MISMOAmount  DECIMAL(0, 2)  NO  The difference between the dollar price paid for the loan and its UPB at the time of purchase when the UPB is more than price paid. 
LoanServicingFeeBasisPointNumber  MISMONumeric  DECIMAL(0, 2)  NO  The number of basis points of servicing fee selected for this mortgage. 
LoanServicingIndicator  MISMOIndicator  BIT  NO  Indicates whether the seller will identify specific loan level servicing values for this mortgage. 
LoanServicingRightsPurchaseOnlyIndicator  MISMOIndicator  BIT  NO  Indicates that the transaction on the Investors side is a Purchase of servicing rights rather than the purchase of an asset. 
LoanYieldSpreadPremiumAmount  MISMOAmount  DECIMAL(0, 2)  NO  A premium, expressed as a dollar amount, calculated based upon the difference between the interest rate of the loan and the market rate at the time of funding. 
PassThroughCalculationMethodType  PassThroughCalculationMethodEnum  VARCHAR(0)  YES  Determines what formula is used to calculate the investor pass through rate as defined in the investor contract.
 
PassThroughCeilingRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  Investor rate ceiling used in bottom up calculations. 
PassThroughRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The rate at which interest is passed by the servicer to the investor. It equals the note rate less the service fee rate and excess service fee rate. 
PrincipalVarianceToleranceMaximumAmount  MISMOAmount  DECIMAL(0, 2)  NO  The maximum allowed dollar amount variance between the reported and the expected or scheduled principal. 
RelatedInvestorLoanIdentifier  MISMOIdentifier  VARCHAR(0)  NO  Identifier of a loan from a related or original transaction. May be used for modifications and conversion of existing loans. 
RelatedLoanInvestorType  RelatedLoanInvestorEnum  VARCHAR(0)  YES  Specifies the investor of the associated loan.
 
RelatedLoanInvestorTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Related Loan investor Type. 
REOMarketingPartyType  REOMarketingPartyEnum  VARCHAR(0)  YES  Identifies the party responsible for marketing the property in case of default.
 
REOMarketingPartyTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for REO Marketing Party Type. 
ServicingFeeMinimumRatePercent  MISMOPercent  DECIMAL(0, 2)  NO  The minimum service fee rate, expressed as a percent, to be earned by the servicer. 
ThirdPartyLoanAcquisitionPriceAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount that was paid by the seller to acquire the loan from a third party. 
UPBVarianceToleranceMaximumAmount  MISMOAmount  DECIMAL(0, 2)  NO  The maximum allowed dollar amount variance between the reported and the expected or scheduled unpaid principal balance (UPB). 
WarehouseAdvanceAmount  MISMOAmount  DECIMAL(0, 2)  NO  The dollar amount of the advance against a warehouse line of credit. 
WarehouseCommitmentSubcategoryIdentifier  MISMOIdentifier  VARCHAR(0)  NO  Uniquely identifies a subcategory of a warehouse commitment. 

INVESTOR_LOAN_INFORMATION Keys 
Key Name  Key Type  Keys 

INVESTOR_LOAN_INFORMATION Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
LOAN  Identifying  One to Zero or One          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

INVESTOR_LOAN_INFORMATION Check Constraints 
Check Constraint Name  CheckConstraint 

INVESTOR_LOAN_INFORMATION Bound Attachments 
Name  Current Value 

INVESTOR_LOAN_INFORMATION User-Defined Mappings 
Model  Name  Description 

INVESTOR_LOAN_INFORMATION Data Movement Rules 
Name  Type  Rule Text/Value