Developer Programs

Learn

Docs
Important notification about upcoming changes to the DMZ environment. Please read.

LnAcct

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

Extract to provide loan master file details

Silverlake Dlt Delete Record Flag 1 SrcKey Unique Record Key 17 FornKey Customer Key 7 AcctId Account Number LNMAST ACCTNO 9 16 AcctType Account Type ACTYPE CustId CIF Number CIFNO NxtPayOffAmt Next Month Payoff NXTPO 13 2 PmtCode Payment Code PMTCOD PmtCodeDesc Payment Code Desc 25 IntBasis Interest Base IBASE IntBasisDesc IBase Description DailyAccrAmt Daily Accrual PDIEM 5 CurPayOff Current Month Payoff CURPO CurBal Current Balance CBAL BrCode Branch Number BR# 3 BrDesc Bank/branch name JHDATA JDNAME 30 AcctStat Status STATUS AcctStatDesc Status Description 20 AccrInt Accrued Interest ACCINT 8 15 ProdCode Loan Type TYPE ProdDesc Type Description LNPAR2 PTYDSC UnusedCrAccr Un-used Line Charge LNFACC LNFACR UEInsurAccr Unemployment Ins Fee TermCnt Loan Term TERM TermUnits Loan Term Code TMCODE SemiDay2 Semi Mnthly 2nd day SEMDY2 SemiDay1 Semi Mnthly 1st day SEMDY1 RemPmtCnt Remaining Term REMTRM PmtTermUnits Payment Freq Code FRCODE PmtTerm Payment Frequency FREQ PmtDayOfMonth Pymt Day of Month NPDAY PmtAmtDue Payment Amount Due PMTAMT 6 11 PmtAmt Payment Amount PIAmt Princ & int pmt amt PIAMT PayoffGoodThruDt Pymt Good Thru Date THRUDT 4 PastDueAmt Total Amt Due LNPDUE PDITOT PartPmtAmt Partial Pymt Amt PRTPMT OrigBal Original Balance ORGAMT OpenDt Original Loan Date ORGDT NxtSchedPmtDt Next Sched Pymt Date NSPDT NxtPayDt Next Pymt Due Date NPDT MatDt Maturity Date MATDT LateChgAmt Assessed Late Charges ASSLC LastPmtDt Last Pymt Date LPDT IntRate Note Rate RATE CrLifeInsurAccr Credit Life Charge AvailCr Avalible Credit AHInsurAccr A & H Charge AccrBal Accrual Balance ACBAL SalesPerson Sales Associate SALESAC AcctLvlSecCode Account Level Security SECURE OddDaysIntBasis Accrue Odd Days at 365 Ibase ODIBAS ShortPmtCode Roll Short on Pcode 6 RSHTPC6 ShortPmtDesc Short Pmt Code Desc 50 TINCode Tax ID type code CFMAST CFSSCD TINDesc Description CFPART TXDESC TaxId Tax ID number CFSSNO PrtcpCode Participation Code PARTID PrtcpDesc Part Id Description 100 AbbName Short Name SNAME AcctClsfCode Class Code CLASS PastDue10YTD Times Past Due 10-29 CPD10 PastDue30YTD Times Past Due 30-59 CPD30 PastDue60YTD Times Past Due 60-89 CPD60 PastDue90YTD Times Past Due 90-119 CPD90 PastDue120YTD Times Past Due 120-149 CPD120 PastDue150YTD Times Past Due 150-179 CPD150 PastDue180YTD Times Past Due 180 + CPD180 CallRptCode Call Report Code CALREP CollatCode Collateral Code COLCOD CallRptDesc Call Report Description LNPAR7 LP7DSC 60 StdIndustCode Standard Industry Code INDCOD CollatDesc Collateral Description LNPAR8 LP8DES CRACenTract Census Tract 1 CENSUS StdIndustDesc Standard Industry Desc CFSICC CFSINA LOCCycleAcctId CYCLE acct no LNCYCL CYCYAC PtPaid Points Paid PNTPD OrigFeesYTD Origination Fees YTD ORGFEE GroupCode Group Code GROUP GroupDesc Group description GLPAR5 P5DESC 40 BilIntAmt Billed Int Amt BILINT BallPmtAmt Balloon Payment BALLON CrScoreId CREDIT SCORE LNSMTG CREDSCR CRASMSACode SMSA Number SMSA CRASMSADesc LNPAR5 L5DESC ChgdOffAmt Charge Off Amount CHGOFF LOCCode Credit Line Code CLCODE LOCDesc LOC Type Description JHPARHV HVDESC PurpCode Purpose Code PURCOD PurpDesc Purpose Description LNPAR9 LP9DES AcctConvDt Conversion Date CNVDT7 CRALoc CRA Location CRALOC AflLnPartType Affiliate Loan Y/N AFFILIATE State State Code STATE PrevExtDt Date Previous Extension EXTPDT NxtRvwDt Next Review Date NREVDT EscrwCurBal Escrow balance LNEANB EBAL FirstPmtDt 1st Pymt Date FPDT GLCostCtr GL Cost Center GLCOST IntPaidYTD Interest Paid YTD YTDINT IntPaidPYTD Int Paid Last Year INTPRE PastDueOthChgAmt Other chg Due PDIOTH PastDueLateChgAmt Late chgs Due PDILC PastDuePrincAmt Principal Due PDIPRN PastDueIntAmt Interest Due PDIINT PastDueDays Days Past Due PDDAYS RateIdxNum Rate Number PRATE# RateVar Rate Variance PVARI RateVarCode Rate Variance Code PVCODE RateCapUp Rate Cap Upwards ECAPUP RateCapDown Rate Cap Downwards ECAPDN RateCeil Rate Ceiling PCEIL RateFlr Rate Floor PFLOOR RateRevTerm Rate Review Term PRTERM RateRevTermUnits Rate Review Term Code PRCODE LastAdvaAmt Last Advance LSTADV LastAdvaDt Last Advance Date LSTAD7 LastActDt Last Activity Date ACTIV7 LastPmtAmt Last Pymt Amount LSTPMT RateRevDt Rate Review Date PREVDT LastRenDt Date Last Renewed RENDT LastRenBal Renew/Ext Balance RENBAL LastMainDt Last Maint Date LFMDT ExtMonthsLTD Months Extended LTD EXTMTH IncrAdvaAmt INCREMENTS OF P2INCR SecdMtgCode Second mortgage flag SECMTG FHLBPurpCode Loan Purpose LOANPURP SecdMtgDesc Secondary Mortgage Desc FHLBPurpDesc Purpose Code Desc FHLBPropCode Property type PROPTY FHLBPropDesc Property type dscription LNSPRO PROPRD AggCycleDay Aggregate days CYAGGD NAICSCode NAICS Code NAICSC NAICSDesc 2002 DESCRIPTION LNNAIC NAIDSC LOCOrigAmt Original Line Amount LNLINE LNLORG OrigMatDt Original Maturity Date ORGMDT PartIdNum Participation ID number PARTID# RelAcctId Related Acct Num RLACC# RelAcctType Related Acct Type RLACTP ClsDt Date paid off DTPDO7 PrePmtPenDesc Penalty Description LNPARP LPDESC NumPmtsExtLastYr Pymt # Extended Last Yr EXTPRE IntRebate Interest Rebate INTREB RewriteToLnAcctId Rewrite to Loan # REWLN# RenCntLTD Times Renewed L-T-D RENLTD CrRatingCode Credit Rating Code RATCOD CrRatingDesc LNPARR LRDESC SBAGuarId SBA Assigned GP Number SBAGP# 10 TierBlendRate Tiered Rate Type? LNTIER NonAccrDt Nonaccrual Date NACDT HldMailCode Hold Mail Code HMAIL HldMailDesc Hold mail description JHMAIL JHMDES 35 AdvaMTDAmt MTD Advances MTDADV LastExtDt Last Extension Date EXTDT StudentLnCode Demand/Student Loan Code DEMSTU StudentLnDesc Student Loan Desc EscrwPmtAmt Escrow Payment Amt LOCAvg Current Avg Usage LNLINW LNLAVG ShareNatCrLn Shared National Credit SHRNTLCRD PledgeLnCode FHLB Institution Code PLGCOD PledgeLnDesc FHLB Institution Name LNPRPL PLINAM DaysBeforeRateChg Notice Pre-Days ENPDYS LnConvDt Loan Conversion Date HECNV7 NumPmtsExtYTD Times Extended Y-T-D EXTYTD ApprVal Appraised Value APRAMT DlqTimesQTD # Delin Curr Quarter DELIN1 DlqTimesPrevQtr # Delin Quarter 2 DELIN2 DlqTimes3Qtr # Delin Quarter 3 DELIN3 DlqTimes4Qtr # Delin Quarter 4 DELIN4 DeptCode Department Code DEPTCD NewPrevRateChgDt New Rate Effective Date ENWRDT IntPaidLTD Int Paid Life to Date INTLTD LateChgPaidPrevYTD LC paid Last Year LCPRE LateChgCode Late Charge Type LCTYPE UnpaidChgs Unpaid Charges LNUCHG PastDue10LTD Life Time Past Due 10-29 LPD10 PastDue30LTD Life Time Past Due 30-59 LPD30 PastDue60LTD Life Time Past Due 60-89 LPD60 PastDue90LTD Life Time Past Due 90-119 LPD90 PastDue10LastYr Last Year Past Due 10-29 PPD10 PastDue30LastYr Last Year Past Due 30-59 PPD30 PastDue60LastYr Last Year Past Due 60-89 PPD60 PastDue90LastYr Last Year Past Due 90-119 PPD90 OrigPartPct Participation Percent PRTPCT NetCurBal Query Balance QRYBAL SoldBal Sold Balances SLDBAL LateChgPaidYTD Late chgs Paid YTD YTDLC PrincPaidYTD Principal Paid YTD YTDPRN PartIdName Participation ID name LNPRTI LPNAME OffCode Officer OFFCR OffDesc Officer short name JHOFFR JHOSNA BorwFICOId Borrower FICO BORRFICO LOCLmt LastIntPmtDt Last Interest Date LNHIST LHPSTD AmtLastIntPd Last Interest Amount LHAMT LastStmtBal Balance Last Stmt STMBAL LastStmtDt Date Last Statement STMDT PrePmtPenCode Prepayment Penalty Code CurLnToValRatio Current Loan to value ratio ProtAcctId Protected Acct # OrigAcctId Original Account Id ProtAcctType Protected Acct Type 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 Current Cap Rate SBAGuarPct SBA Guarantee Percent OccupCode Occupancy Code AcctClsfDesc Account Classification Description ChgOffAcctId Part/Chg Off Acct Number LnShdwType Shadow Loan LnShdwAccrType Shadow Accrued Interest LnShdwPrincAmt Shadow Loan Principal Balance CurDebtSvcRatio Current DSC Ratio CurNetOperIncmAmt Current Actual NOI BilEscrwAmt Billed Escrow Amount CurrencyCode Currency Type CurrencyDesc Currency Description 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 group code LastRePriceDt Repricing date LnShdwStat Shadow Status OrigRate Original Rate LnShdwStatDesc Shadow Status Description RateType Rate Type LnShdwChgOff Shadow Report as C/O LnShdwChgOffInt Shadow Charged Off Interest PrincPaidMTD MTD Principal PropVacRate Curr Vacancy Rate LnShdwCaplzeFee Shadow Capitalized Fees EstbPersonName Name of person opening account EstbPersonTitle Title of person opening account 70 DlrId Dealer number VehicleId Vehicle ID number RestructuredDt Restructured Date PrtcpAcctId Participation Account Id PrtcpAcctType Participation/Charge Off Acct Type LOCAcctId Credit Line Number PayoffPend Payoff Pending Flag PayoffPendExpDt Payoff Pending Expiration Date RateCapRevTerm Rate Cap Period RateCapRevTermUnits Rate Cap Period Code MonthIntIncmAmt Profit Period Int Earned BrandCode Brand Code ChgdOffType Charged Off Type BrandDesc Brand Description TotDebtPct Total Debt Ratio CommPropSqFt Land SQFT YrBuilt Year Built PropListAmt Listing Amount NumUnit Number of Units CurSeniorLienAmt Current Senior Lien Amount OrigNetOperIncmAmt Original Actual NOI 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 RiskRateDt Risk Rating Date PmtReAmrtzPeriod Reamortization Term (Period) PmtReAmrtzPeriodCode Reamortization Term code (Units) MultiLvlLndType Multi Level Lending Type MasterAcctId MLL Master Account Id MasterAcctType MLL Master Account Type PrincPmtMthd Principle Payment NewPrevRate New Rate ExtFeesYTD Extension Fees YTD ExtFeesLTD Extension Fees LTD FundLmt Participation Funding Limit FundSeqId Participation Funding Sequence NewPrinIntPmt New P&I Amount OrigIdxVal Original Index OrigFeesLTD Org Fees Life to Date PrtcpIntPmtPct Participation Interest Payment split PrtcpSeqId Participation Sequence Number ReAmrtzPmtDt Payment Reamortization Date ReAmrtzPmt Reamortize Payment Amt AmrtzPmtSusp Payment Suspense Amount Req1098 Requires 1098 RightToCureNotCnt Number of Right to Cure Notices Sent OrigLnToValRatio Loan to value ratio LTVRAT RightToCureDt Right to Cure Date LnShdwProcDt Shadow Processing Date RightToCureYTD Right to Cures YTD CurIdx Current index RightToCureLTD Right to Cures LTD

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