Interpretation Loans RPTSA_LoanId,System.Int32 LoanId,System.Int32 BorrowerId,System.Int32 LoanName,System.String BrytState,System.String ClosingDate,System.DateTime InServiceOn,System.DateTime InPreServiceOn,System.DateTime CancelledOn,System.DateTime PaidOffOn,System.DateTime InDefaultOn,System.DateTime PaymentFrequency,System.String ProrateAmount,System.Decimal DaysLate,System.Int32 TotalDueWithPastAndLates,System.Decimal MaturityDate,System.DateTime LastDayInterestPaid,System.DateTime LenderCount,System.String LoanTypeId,System.Int32 LoanType,System.String ReferringVendorId,System.Int32 Title1VendorId,System.Int32 Title2VendorId,System.Int32 NextPaymentAmount,System.Decimal NextPaymentDueOn,System.DateTime NextPaymentInterestDue,System.Decimal NextPaymentPrincipalDue,System.Decimal NextPaymentLateDue,System.Decimal CreatedByUser,System.String FundingMethod,System.Int32 FirstPayinDate,System.DateTime 9d7e71b21c2f4f9cadd25830a757875d Loans Tables.Loans Worksheets RPTSA_WorksheetId,System.Int32 LoanId,System.Int32 WSLoanAmount,System.Decimal WSTotalClosing,System.Decimal WSTotalProceeds,System.Decimal WSPayment,System.Decimal CLTV,System.Decimal Balloon,System.Decimal Amortization,System.Double WSInterestRate,System.Decimal WSTerm,System.Int32 WSLoanPayoff,System.Decimal Valuation,System.Decimal SecuredBy,System.String LoanPosition,System.String ClosingDate,System.DateTime FundedAmount,System.Decimal FundingMethod,System.Int32 9618dc56bac34169bfcf3e0951bf948e Worksheets Tables.Worksheets Investments RPTSA_InvestmentId,System.Int32 LoanId,System.Int32 LenderId,System.Int32 InvestmentId,System.Int32 StartDate,System.DateTime EndDate,System.DateTime LenderName,System.String PayPeriodAmount,System.Decimal DailyShare,System.Double ServicingChargeMethod,System.Int32 InvestmentServingFee,System.Decimal InvestmentServicingRate,System.Decimal 8472fc8f4ded406f89acbf78d29c32d8 Investments Tables.Investments Borrowers RPTSA_BorrowerId,System.Int32 BorrowerId,System.Int32 Vesting,System.String FullName,System.String First,System.String Last,System.String Organization,System.String Title,System.String Signer,System.Boolean Signature,System.String Street1,System.String Street2,System.String City,System.String State,System.String Zip,System.String PhoneNumber,System.String EmailAddress,System.String DefaultBankName,System.String DefaultBankAccount,System.String DefaultBankRouting,System.String 33db570a48fb491098f64de9c19a50ac Borrowers Tables.Borrowers Lenders RPTSA_LenderId,System.Int32 LenderId,System.Int32 Vesting,System.String FullName,System.String First,System.String Last,System.String Organization,System.String Title,System.String Signer,System.Boolean Signature,System.String Street1,System.String Street2,System.String City,System.String State,System.String Zip,System.String PhoneNumber,System.String EmailAddress,System.String DefaultBankName,System.String DefaultBankAccount,System.String DefaultBankRouting,System.String PortfolioTarget,System.Decimal 00d2fd5a002249749265bec3e1200fe6 Lenders Tables.Lenders Udfs RPTSA_UdfId,System.Int32 Category,System.String TextValue,System.String IntegerValue,System.Int32 DecimalValue,System.Decimal DateValue,System.DateTime LoanId,System.Int32 PropertyId,System.Int32 BorrowerId,System.Int32 LenderId,System.Int32 FormattedValue,System.String FieldName,System.String 57fab60e67ea48469a62cfc7af19693e Udfs Tables.Udfs PeriodicLoanSummaries RPTSA_PeriodicLoanSummaryId,System.Int32 AsOfDate,System.DateTime LoanId,System.Int32 CurrentInterestRate,System.Decimal DailyInterestRate360,System.Decimal DailyDefaultInterestRate360,System.Decimal PeriodicInterestRate,System.Decimal PeriodicDefaultInterestRate,System.Decimal DailyInterestAmount360,System.Decimal DailyDefaultInterestAmount360,System.Decimal PeriodicInterestAmount,System.Decimal PeriodicDefaultInterestAmount,System.Decimal FullLoanAmount,System.Decimal ActiveLoanAmount,System.Decimal PrincipalBalance,System.Decimal PrincipalPaid,System.Decimal InterestAccrued,System.Decimal InterestPaid,System.Decimal InterestBalance,System.Decimal LateFeesTotalDue,System.Decimal LateFeesPaid,System.Decimal LateFeesBalance,System.Decimal ManagementFeesTotalDue,System.Decimal ManagementFeesPaid,System.Decimal ManagementFeesBalance,System.Decimal ImpoundFeesCollected,System.Decimal ImpoundFeesPaidOut,System.Decimal ImpoundFeesBalance,System.Decimal LenderAdvancesInterestAccrued,System.Decimal LenderAdvancesInterestPaid,System.Decimal LenderAdvancesInterestBalance,System.Decimal LenderAdvancesPrincipalAccrued,System.Decimal LenderAdvancesPrincipalPaid,System.Decimal LenderAdvancesPrincipalBalance,System.Decimal LenderExpensesTotalDue,System.Decimal LenderExpensesPaid,System.Decimal LenderExpensesBalance,System.Decimal LenderCommissionsTotalDue,System.Decimal LenderCommissionsPaid,System.Decimal LenderCommissionsBalance,System.Decimal TotalLoanBalance,System.Decimal HoldBackReserve,System.Decimal PostPaidAccruedInterest,System.Decimal PostPaidAccruedStdFormLateFees,System.Decimal LoanName,System.String d8686c5588d9487aa1428d269a99e75b PeriodicLoanSummaries Tables.PeriodicLoanSummaries PeriodicInvestmentDetails RPTSA_PeriodicInvestmentDetailsId,System.Int32 AsOfDate,System.DateTime InvestmentId,System.Int32 LoanId,System.Int32 LenderId,System.Int32 LoanName,System.String InvestmentAmount,System.Decimal OwnershipPercentage,System.Double StartDate,System.DateTime EndDate,System.DateTime CalulatedEndDate,System.DateTime PrincipalBalance,System.Decimal InterestEarned,System.Decimal InterestRate,System.Decimal DaysLate,System.Int32 BorrowerName,System.String PeriodicPaidOutInterest,System.Decimal PeriodicPaidOutLates,System.Decimal PeriodicPaidOutPrincipal,System.Decimal PeriodicPaidOutTotal,System.Decimal 24ebbbc6fc804a448ff119198cd14ec5 PeriodicInvestmentDetails Tables.PeriodicInvestmentDetails PayIns RPTSA_PayInId,System.Int32 LoanId,System.Int32 PayInId,System.Int32 PayPeriodId,System.Int32 PayInType,System.Int32 PayInState,System.Int32 TotalAmountPaid,System.Decimal InterestPaid,System.Decimal PrincipalPaid,System.Decimal LateFeesPaid,System.Decimal ImpoundFeesPaid,System.Decimal OutstandingInterestPaid,System.Decimal OutstandingLateFeesPaid,System.Decimal OutstandingManagementFeesPaid,System.Decimal OutstandingLenderAdvancesPaid,System.Decimal OutstandingLenderExpensesPaid,System.Decimal OutstandingLenderCommissionsPaid,System.Decimal ReturnToBorrower,System.Decimal TotalAmountDue,System.Decimal InterestDue,System.Decimal PrincipalDue,System.Decimal LateFeesDue,System.Decimal ImpoundFeesDue,System.Decimal PaidOnDate,System.DateTime EnteredOn,System.DateTime ReadyOn,System.DateTime ProcessedOn,System.DateTime ReconciledOn,System.DateTime CheckNumber,System.String Note,System.String TransferFundsBy,System.Int32 IgnoreHoldPeriod,System.Boolean Source,System.Int32 d4c1442478dd437293d06b367a519aca PayIns Tables.PayIns PayOuts RPTSA_PayOutId,System.Int32 PayOutId,System.Int32 PayInId,System.Int32 LoanId,System.Int32 PayOutType,System.Int32 GeneratedOn,System.DateTime HoldEndsOn,System.DateTime ProcessedOn,System.DateTime ReconciledOn,System.DateTime IgnoreHoldPeriod,System.Boolean InvestmentId,System.Int32 TransferFundsBy,System.Int32 BorrowerId,System.Int32 CheckNumber,System.String PayOutState,System.Int32 VendorId,System.Int32 Amount,System.Decimal Principal,System.Decimal Interest,System.Decimal Late,System.Decimal LenderAdvancePrincipal,System.Decimal LenderAdvanceInterest,System.Decimal LenderExpense,System.Decimal LenderCommission,System.Decimal 02d368daf246481098e209fdd5a33cbd PayOuts Tables.PayOuts PayPeriods RPTSA_PayPeriodId,System.Int32 PayPeriodId,System.Int32 LoanId,System.Int32 InterestRate,System.Decimal LoanAmount,System.Decimal FirstDayOfPeriod,System.DateTime LastDayOfPeriod,System.DateTime DueDate,System.DateTime RequestedPayment,System.Decimal Term,System.Int32 Amortization,System.Double AdditionalPrincipalDue,System.Decimal IsProratePeriod,System.Boolean State,System.Int32 ExtensionIndex,System.Int32 PayPeriodType,System.Int32 4424e9e13f414b9492d3808c38f770e6 PayPeriods Tables.PayPeriods LoanDebits RPTSA_LoanDebitId,System.Int32 LoanDebitEntryId,System.Int32 LoanId,System.Int32 EffectiveOn,System.DateTime EnteredOn,System.DateTime Amount,System.Decimal Note,System.String InvestmentId,System.Int32 VendorId,System.Int32 Target,System.Int32 DailyFundedDebitIntent,System.Int32 CheckNumber,System.String TransferMethod,System.Int32 State,System.Int32 ProcessedOn,System.DateTime ReconciledOn,System.DateTime ReadyOn,System.DateTime RegisterOption,System.Int32 949d08c8c0d04da884c727bf5875a5cc LoanDebits Tables.LoanDebits LoanCredits RPTSA_LoanCreditId,System.Int32 LoanCreditEntryId,System.Int32 LoanId,System.Int32 EffectiveOn,System.DateTime EnteredOn,System.DateTime PayPeriodId,System.Int32 Amount,System.Decimal Note,System.String CreditSource,System.Int32 InvestmentId,System.Int32 VendorId,System.Int32 PayPeriodFundedCreditIntent,System.Int32 CheckNumber,System.String TransferMethod,System.Int32 State,System.Int32 ProcessedOn,System.DateTime ReconciledOn,System.DateTime ReadyOn,System.DateTime RegisterOption,System.Int32 a21bc34d54134409a33a93e42fb5ad88 LoanCredits Tables.LoanCredits Properties RPTSA_PropertyId,System.Int32 PropertyId,System.Int32 LoanId,System.Int32 APN,System.String TypeConstruction,System.String Address1,System.String Address2,System.String City,System.String State,System.String Zip,System.String FullAddress,System.String SquareFeet,System.Int32 Age,System.Int32 Description,System.String LegalDescription,System.String Note,System.String TaxDate,System.DateTime DeedRecordingNumber,System.String DeedRecordingDate,System.DateTime DeedRecordingCounty,System.String Encumbered,System.Boolean 0ac82561b8a6472f9ddaeb75f53d75a4 Properties Tables.Properties Udfs_Investments LoanId Udfs_Investments Udfs_Investments LoanId Borrower_Loans BorrowerId Borrower_Loans Borrower_Loans BorrowerId Lender_Investment LenderId Lender_Investment Lender_Investment LenderId PID_Invest LoanId PID_Invest PID_Invest LoanId Loan_Investment LoanId Loan_Investment Loan_Investment LoanId Properties_Loans LoanId Properties_Loans Properties_Loans LoanId PLSumm_Loans LoanId PLSumm_Loans PLSumm_Loans LoanId Udfs_Loans LoanId Udfs_Loans Udfs_Loans LoanId WS_Loans LoanId WS_Loans WS_Loans LoanId Loans_Borrowers BorrowerId Loans_Borrowers Loans_Borrowers BorrowerId EngineV2 842f4aaa4e3f4a7694f0909ed2900cf3 None;Black;2;Solid;False;4;Black Transparent Transparent 0,7.42,10.22,0.3 pf.Page1 PageFooterBand1 Transparent True 0,0.2,10.22,0.3 h.ap.Page1 Transparent True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_LoanId LoanId Black ,,,,WordWrap=True,A=0 Center Transparent True True 0.6,0,1.6,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_LoanName LoanName Black ,,,,WordWrap=True,A=0 Center Transparent True True 2.3,0,1.5,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_Address1 Address1 Black ,,,,WordWrap=True,A=0 Center Transparent True True 3.9,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_City City Black ,,,,WordWrap=True,A=0 Center Transparent True True 4.5,0,0.4,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_State State Black ,,,,WordWrap=True,A=0 Center Transparent True True 5,0,0.4,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_Properties_Loans_Zip Zip Black ,,,,WordWrap=True,A=0 Center Transparent True True 5.5,0,1,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_PLSumm_Loans_PrincipalBalance PrincipalBalance Black ,,,,WordWrap=True,A=0 Center Transparent True True 6.6,0,0.9,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_WS_Loans_WSLoanAmount WSLoanAmount Black ,,,,WordWrap=True,A=0 Center Transparent True True 7.6,0,1,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_PLSumm_Loans_HoldBackReserve HoldBackReserve Black ,,,,WordWrap=True,A=0 Center Transparent True True 8.7,0,0.8,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_PLSumm_Loans_ImpoundFeesBalance ImpoundFeesBalance Black ,,,,WordWrap=True,A=0 Center Transparent True True 9.6,0,0.6,0.3 h.ap.HeaderLoans Arial,10,Bold 0,0,0,0 HeaderLoans_WS_Loans_WSInterestRate WSInterestRate Black ,,,,WordWrap=True,A=0 Center Transparent True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 60609c0cdb9c4c4a94b1428e0f2f961e 0,0,0,0 Text1 LoanId Black ,,,,WordWrap=True,A=0 Center Transparent True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold a285358333b145b5a5efab51e935f692 0,0,0,0 Text2 LoanId Black ,,,,WordWrap=True,A=0 Center Transparent True True 0,0,0.5,0.3 h.ap.HeaderLoans Arial,10,Bold 930175eeea3f49cb902f4bc2440b8e8a 0,0,0,0 Text3 LoanId Black ,,,,WordWrap=True,A=0 Center HeaderLoans None;[0:0:0];1;Solid;False;4;[0:0:0] [222:235:246] True 0,0.9,10.22,0.3 d.Page1 Transparent True True 0,0,0.5,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_LoanId {Loans.LoanId} Black ,,,,WordWrap=True,A=0 Center Transparent True True 0.6,0,1.6,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_LoanName {Loans.LoanName} Black ,,,,WordWrap=True,A=0 Center Transparent True True 2.3,0,1.5,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_Address1 {Loans.Properties_Loans.Address1} Black ,,,,WordWrap=True,A=0 Center Transparent True True 3.9,0,0.5,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_City {Loans.Properties_Loans.City} Black ,,,,WordWrap=True,A=0 Center Transparent True True 4.5,0,0.4,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_State {Loans.Properties_Loans.State} Black ,,,,WordWrap=True,A=0 Center Transparent True True 5,0,0.4,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_Properties_Loans_Zip {Loans.Properties_Loans.Zip} Black ,,,,WordWrap=True,A=0 Center Transparent True True 5.5,0,1,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_PLSumm_Loans_PrincipalBalance {Loans.PLSumm_Loans.PrincipalBalance} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Center Transparent True True 6.6,0,0.9,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_WS_Loans_WSLoanAmount {Loans.WS_Loans.WSLoanAmount} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Center Transparent True True 7.6,0,1,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_PLSumm_Loans_HoldBackReserve {Loans.PLSumm_Loans.HoldBackReserve} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Expression Center Transparent True True 8.7,0,0.8,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_PLSumm_Loans_ImpoundFeesBalance {Loans.PLSumm_Loans.ImpoundFeesBalance} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Center Transparent True True 9.6,0,0.6,0.3 d.DataLoans Arial,8 0,0,0,0 DataLoans_WS_Loans_WSInterestRate {Loans.WS_Loans.WSInterestRate/100} Black 2 , 0 0 % ,,,,WordWrap=True,A=0 Expression Center Odd8 Loans _x007B_Loans.BrytState_x003D__x003D__x0022_InService_x0022__x007D_ DataLoans ASC LoanName Transparent True 0,1.6,10.22,0.3 f.Page1 Transparent True True 0,0,1,0.3 f.FooterLoans Arial,10,Bold Center 0,0,0,0 FooterLoans_LoanId #ofLoans {Count(DataLoans)} Black ,,,,WordWrap=True,A=0 Expression Center Transparent True True 5.5,0,1,0.3 f.FooterLoans Arial,10,Bold 0,0,0,0 FooterLoans_PLSumm_Loans_PrincipalBalance {Sum(Loans.PLSumm_Loans.PrincipalBalance)} Black 2 , 0 0 ,,,,WordWrap=True,A=0 Expression Center Transparent True 9.1,0,1.1,0.3 f.FooterLoans Arial,10,Bold Right 0,0,0,0 FooterLoans_WS_Loans_WSInterestRate Black ,,,,WordWrap=True,A=0 Center FooterLoans Transparent 0,2.3,10.22,0.3 h.ap.Page1 Transparent 7.1,0,2.7,0.3 h.ap.HeaderLoans2 Arial,10,Bold 0,0,0,0 HeaderLoans_LoanName2 UPB AS PERCENT OF CURRENT FUND Black ,,,,WordWrap=True,A=0 Expression Center Transparent 5.7,0,1.2,0.3 h.ap.HeaderLoans2 Arial,10,Bold 0,0,0,0 HeaderLoans_PLSumm_Loans_PrincipalBalance2 PrincipalBalance Black ,,,,WordWrap=True,A=0 Center Transparent -0,0,2.9,0.3 h.ap.HeaderLoans2 Arial,10,Bold 921c07853a074bc1b57ddb43aa615611 0,0,0,0 Text6 Category Black ,,,,WordWrap=True,A=0 Expression Center Transparent 4.3,0,1.2,0.3 h.ap.HeaderLoans2 Arial,10,Bold e9c6694c5c644d6b94f6b3e2cb9b9f97 0,0,0,0 Text7 Limit Black ,,,,WordWrap=True,A=0 Expression Center HeaderLoans2 True False Top, Bottom;[0:0:0];1;Solid;False;4;[0:0:0] [242:242:242] 0,3,10.22,0.3 gh.Page1 Transparent 4.3,0,1.2,0.3 gh.GroupHeaderBand2 Arial,9 Center 0,0,0,0 Text8 {CountIf(DataLoans2, Loans.Udfs_Loans.FormattedValue==Udfs.FormattedValue)} Black Expression Center Transparent True -0,0,1.4,0.3 gh.GroupHeaderBand2 Arial,9 Center 0,0,0,0 DataBorrowers_First {Udfs.FieldName} Black ,,,,WordWrap=True,A=0 DataColumn Center {Udfs.FieldName} GroupHeaderBand2 Transparent 0,3.7,10.22,0 d.Page1 Udfs _x007B_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Construction_x0020_Loan_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_New_x0020_Construction_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Subdivision_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Multi-Family_x0020__x0028_2_x002B__x0020_units_x0029__x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Commercial_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Land_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Group_x0020_Home_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_Outside_x0020_Maricopa_x0020_County_x0022__x007C__x007C_Udfs.FieldName.ToString_x0028__x0029__x003D__x003D__x0022_100_x0025__x0020_Loans_x0020_with_x0020_Profit_x0020_Split_x0022__x007D_ FormattedValue,EqualTo,true,,Boolean DataUdfs Transparent 0,4.1,10.22,0 gf.Page1 GroupFooterBand1 Transparent 0,4.5,10.22,0.3 d.Page1 Transparent True 0,0,10.2,0.3 d.DataLoans2 Arial,8 0,0,0,0 DataLoans_LoanName2 {Loans.LoanName} Black ,,,,WordWrap=True,A=0 Center Loans _x007B_Loans.LoanId_x003D__x003D_Udfs.LoanId_x007D_ _x007B_Loans.BrytState_x003D__x003D__x0022_InService_x0022__x007D_ DataLoans2 9dc46a11e7c340c481eaa30cd290d507 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll ExposureLimitsTest_[IN_PROG]_v3.1 12/14/2020 10:33:56 PM 12/14/2020 10:33:56 PM 2cca10bf7bea45eb9b92ad59fdd76d7e ExposureLimitsTest_[IN_PROG]_v3.1 Inches 2020.5.1.0 CSharp None;[0:0:0];1;Solid;False;4;[0:0:0] [222:235:246] Arial,8 Odd8 [255:0:0] [0:0:0] None;[0:0:0];1;Solid;False;4;[0:0:0] [242:242:242] Arial,8 Even8 [255:0:0] [0:0:0]