Enterprise Solutions

LnAcct

Operational Data Integration (ODI) > ODI Extracts > CIF2020 > LnAcct

Extract to provide loan master file details

CIF2020 Dlt Delete Record Flag 1 SrcKey Unique Record Key 17 FornKey Customer Key 9 AcctId Account Number 16 AcctType Account Type CustId Customer Id 8 NxtPayOffAmt Next Month Payoff 7 13 2 PmtCode Payment Code PmtCodeDesc Payment Code Desc 25 IntBasis Interest Base IntBasisDesc IBase Description DailyAccrAmt Daily Accrual 5 CurPayOff Current Month Payoff CurBal Current Balance BrCode Branch Number 3 BrDesc Bank/branch name 30 AcctStat Status AcctStatDesc Status Description 20 AccrInt Accrued Interest 15 ProdCode Loan Type ProdDesc Type Description UnusedCrAccr Un-used Line Charge UEInsurAccr Unemployment Ins Fee TermCnt Loan Term TermUnits Loan Term Code SemiDay2 Semi Mnthly 2nd day SemiDay1 Semi Mnthly 1st day RemPmtCnt Remaining Term PmtTermUnits Payment Freq Code PmtTerm Payment Frequency PmtDayOfMonth Pymt Day of Month PmtAmtDue Payment Amount Due 6 11 PmtAmt Payment Amount PIAmt Princ & int pmt amt PayoffGoodThruDt Pymt Good Thru Date 4 PastDueAmt Total Amt Due PartPmtAmt Partial Pymt Amt OrigBal Original Balance OpenDt Original Loan Date NxtSchedPmtDt Next Sched Pymt Date NxtPayDt Next Pymt Due Date MatDt Maturity Date LateChgAmt Assessed Late Charges LastPmtDt Last Pymt Date IntRate Note Rate CrLifeInsurAccr Credit Life Charge AvailCr Avalible Credit AHInsurAccr A & H Charge AccrBal Accrual Balance SalesPerson Sales Associate AcctLvlSecCode Account Level Security OddDaysIntBasis Accrue Odd Days at 365 Ibase ShortPmtCode Roll Short on Pcode 6 ShortPmtDesc Short Pmt Code Desc 50 TINCode Tax ID type code TINDesc Description TaxId Tax ID number PrtcpCode Participation Code PrtcpDesc Part Id Description 100 AbbName Short Name AcctClsfCode Class Code PastDue10YTD Times Past Due 10-29 PastDue30YTD Times Past Due 30-59 PastDue60YTD Times Past Due 60-89 PastDue90YTD Times Past Due 90-119 PastDue120YTD Times Past Due 120-149 PastDue150YTD Times Past Due 150-179 PastDue180YTD Times Past Due 180 + CallRptCode Call Report Code CallRptDesc Call Report Description 60 CollatCode Collateral Code CollatDesc Collateral Description StdIndustCode Standard Industry Code StdIndustDesc Standard Industry Desc CRACenTract Census Tract 1 LOCCycleAcctId CYCLE acct no PtPaid Points Paid OrigFeesYTD Origination Fees YTD GroupCode Group Code GroupDesc Group description 40 BilIntAmt Billed Int Amt BallPmtAmt Balloon Payment CrScoreId CREDIT SCORE CRASMSACode SMSA Number CRASMSADesc ChgdOffAmt Charge Off Amount LOCCode Credit Line Code LOCDesc LOC Type Description PurpCode Purpose Code PurpDesc Purpose Description AcctConvDt Conversion Date CRALoc CRA Location AflLnPartType Affiliate Loan Y/N State State Code PrevExtDt Date Previous Extension NxtRvwDt Next Review Date EscrwCurBal Escrow balance FirstPmtDt 1st Pymt Date GLCostCtr GL Cost Center IntPaidYTD Interest Paid YTD IntPaidPYTD Int Paid Last Year PastDueOthChgAmt Other chg Due PastDueLateChgAmt Late chgs Due PastDuePrincAmt Principal Due PastDueIntAmt Interest Due PastDueDays Days Past Due RateIdxNum Rate Number RateVar Rate Variance RateVarCode Rate Variance Code RateCapUp Rate Cap Upwards RateCapDown Rate Cap Downwards RateCeil Rate Ceiling RateFlr Rate Floor RateRevTerm Rate Review Term RateRevTermUnits Rate Review Term Code LastAdvaAmt Last Advance LastAdvaDt Last Advance Date LastActDt Last Activity Date LastPmtAmt Last Pymt Amount RateRevDt Rate Review Date LastRenDt Date Last Renewed LastRenBal Renew/Ext Balance LastMainDt Last Maint Date IncrAdvaAmt INCREMENTS OF ExtMonthsLTD Months Extended LTD SecdMtgCode Second mortgage flag SecdMtgDesc Secondary Mortgage Desc FHLBPurpCode Loan Purpose FHLBPurpDesc Purpose Code Desc FHLBPropCode Property type FHLBPropDesc Property type dscription AggCycleDay Aggregate days NAICSCode NAICS Code NAICSDesc 2002 DESCRIPTION LOCOrigAmt Original Line Amount OrigMatDt Original Maturity Date PartIdNum Participation ID number RelAcctId Related Acct Num RelAcctType Related Acct Type ClsDt Date paid off PrePmtPenDesc Penalty Description NumPmtsExtLastYr Pymt # Extended Last Yr IntRebate Interest Rebate RewriteToLnAcctId Rewrite to Loan # RenCntLTD Times Renewed L-T-D PrePmtPenCode Prepayment Penalty Code CrRatingCode Credit Rating Code CrRatingDesc SBAGuarId SBA Assigned GP Number 10 TierBlendRate Tiered Rate Type? NonAccrDt Nonaccrual Date HldMailCode Hold Mail Code HldMailDesc Hold mail description 35 AdvaMTDAmt MTD Advances LastExtDt Last Extension Date StudentLnCode Demand/Student Loan Code StudentLnDesc Student Loan Desc EscrwPmtAmt Escrow Payment Amt LOCAvg Current Avg Usage ShareNatCrLn Shared National Credit PledgeLnCode FHLB Institution Code PledgeLnDesc FHLB Institution Name DaysBeforeRateChg Notice Pre-Days LnConvDt Loan Conversion Date NumPmtsExtYTD Times Extended Y-T-D ApprVal Appraised Value DlqTimesQTD # Delin Curr Quarter DlqTimesPrevQtr # Delin Quarter 2 DlqTimes3Qtr # Delin Quarter 3 DlqTimes4Qtr # Delin Quarter 4 DeptCode Department Code NewPrevRateChgDt New Rate Effective Date IntPaidLTD Int Paid Life to Date LateChgPaidPrevYTD LC paid Last Year LateChgCode Late Charge Type UnpaidChgs Unpaid Charges PastDue10LTD Life Time Past Due 10-29 PastDue30LTD Life Time Past Due 30-59 PastDue60LTD Life Time Past Due 60-89 PastDue90LTD Life Time Past Due 90-119 CurLnToValRatio Loan to value ratio PastDue10LastYr Last Year Past Due 10-29 PastDue30LastYr Last Year Past Due 30-59 PastDue60LastYr Last Year Past Due 60-89 PastDue90LastYr Last Year Past Due 90-119 OrigPartPct Participation Percent NetCurBal Query Balance SoldBal Sold Balances LateChgPaidYTD Late chgs Paid YTD PrincPaidYTD Principal Paid YTD PartIdName Participation ID name OffCode Officer OffDesc Officer short name BorwFICOId Borrower FICO LOCLmt LastIntPmtDt Last Interest Date AmtLastIntPd Last Interest Amount LastStmtBal Balance Last Stmt LastStmtDt Date Last Statement ProtAcctId Protected Acct # ProtAcctType Protected Acct Type OrigAcctId Original Account Id ChgdOffDt Charge Off Date DlqRate Delinquent Rate SecdAccr Secondary Accrued Interest RestructedDr Restructured Flag SubPrimeLnCode Sub-Prime Lending WatchListCode Watch List Code WatchListDt Watch List Date ExmnrClsfDt Examiner Classification Date PrevRenDt Previous Renewal Date ApprDt Appraisal Date RateRevDayOfMonth Rate Review Day of Month RegSeniorLienCode Senior Lien Code LnCapRate Loan Cap Rate SBAGuarPct SBA Guarantee Percent OccupCode Occupancy Code AcctClsfDesc ChgOffAcctId Part / Chg off Acct ID LnShdwPrincAmt Shadow Loan Principal Balance CurDebtSvcRatio Ratio of Amount for Debt Service CurNetOperIncmAmt Net Operating Income BilEscrwAmt Billed Escrow Amount CurrencyCode Currency Type CurrencyDesc Currency Description LnShdwType Shadow Loan RiskRateCode Risk Rate Code RiskRateDesc Risk Rate Description MtgInsurPct Mortgage Insurance Percentage FHLBDocCode Documentation Type FHLBDocDesc Documentation Description PropPostalCode Property Zip PropState Property State CombLTV Combined LTV LnShdwIntAmt Shadow Interest Amount ForeClosureDt Foreclosure Date MonthAvgBalAmt Monthy Average Balance GLProdCode GL Product code LastRePriceDt Repricing date OrigRate Original Rate RateType Rate Type StateWithCode State WithHolding Code MTDAccrInt MTD Accrued LnShdwChgOffInt Shadow Charged Off Interest PrincPaidMTD MTD Principal EstbPersonName Name of person opening account EstbPersonTitle Title of person opening account 70 DlrId Dealer number VehicleId Vehicle ID number PrtcpAcctId Participation Account Id PrtcpAcctType Participation/Charge Off Acct Type LOCAcctId Credit Line Number ChgdOffType Charged Off Type TotDebtPct Total Debt Ratio YrBuilt Year Built NumUnit Number of Units CommOccupPct CRE Occupancy Fraction PropCondRmk CRE Property Condition PenIncmAmt Loan Penalty Income NonPenIncmAmt Loan Non Penalty Income InitARMFixPeriodCnt Adjustable Rate Fixed Period IntOnlyExpDt Int only end date BallCallDt Balloon call date PMIPmtAmt PMI Payment Amount PmtGraceDays #days for Billing Notice PmtReAmrtzPeriod Reamortization Frequency PmtReAmrtzPeriodCode Reamortization Frequency (Units) PmtReAmrtzFreq Reamortization Term PmtReAmrtzFreqCode Reamortization Term code NewPrevRate New Rate ExtFeesYTD Extension Fees YTD ExtFeesLTD Extension Fees LTD OrigIdxVal Original Index PrtcpIntPmtPct Participation Interest Payment Split Percentage PrtcpSeqId Participation Sequence Number ReAmrtzPmtDt Payment Reamortization Date ReAmrtzPmt Reamortize Payment AmrtzPmtSusp Payment Suspense Amount Req1098 Requires 1098 RightToCureNotCnt Number of Right to Cure Notices Sent RightToCureDt Right to Cure Date CurIdx Current Index

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024