Enterprise Solutions

LnAcct

Operational Data Integration (ODI) > ODI Extracts > Core Director > LnAcct

Extract to provide loan master file details

Core Director Dlt Delete record flag String 1 SrcKey Unique record key MASTER.ISM COMMON_MASTER_PRIMARY_KEY 18 FornKey Account Key AcctId Account Number 3 16 AcctType Account Type 2 CustId CIF Number 9 PmtCode Pmt Split Prior Flg 350 PmtCodeDesc Description USERCOD.ISM USER_DESCRIPTION 40 IntBasis Days Base 165 Int32 IntBasisDesc DailyAccrAmt Daily Intrst Factor 328 Decimal 11 4 CurPayOff Today's Payoff 316 15 CurBal Current Balance 163 BrCode Branch code BrDesc Branch description AcctStat Account Status 20 AcctStatDesc Account Status Desc AccrInt Accrued Interest 128-153 13 ProdCode Product Code 38 6 ProdDesc Product Code Desc WDSTRG.ISM DSDSC 31 TermCnt Term 152 TermUnits Term Units Calculated PmtTermUnits Payment Freq Code 140 PmtTerm PmtDayOfMonth Pymnt Day of Month 224 PmtAmtDue Total Amount Due 456 PmtAmt Reg/Prin Payment 137 PIAmt P&I Payment 368 PayoffGoodThruDt Payoff Good Thru Date DateTime 8 PastDueAmt Amount Past Due 329 PartPmtAmt Partial Payment 138 OrigBal Original Loan Amount 151 OpenDt Date Opened 17 NxtPayDt Reg/Prin Due Date 129 MatDt Maturity Date 130 LateChgAmt Late Charge Adj 326 LastPmtDt Date Last Payment 139 IntRate Interest Rate 146 7 CrLifeInsurAccr DB C/L Earned 133 AvailCr Unused Credit/Comt 317 NewPrevRate Prior Interest Rate 243 NewPrinIntPmt New Payment Amount 244 ReAmrtzPmt Pymt/Mat Flag 205 ReAmrtzPmtDt Payment Recalc Date 477 Req1098 Mortgage Int Flag 202 OrigLnToValRatio Loan to Value Ratio 422 CurIdx Current Base Rate 240 TINCode Tax ID Code 92 TINDesc Tax ID Description Calculated based on TINCode TaxId SSN/EIN 10 PrtcpCode Participation Code 155 PrtcpDesc Participation Desc AcctClsfCode Class 127 PastDue30YTD Times Delq >30 days 142 PastDue60YTD Times Delq >60 days 143 PastDue90YTD Times Delq >90 days 144 CallRptCode Report Code 126 CallRptDesc Report Description CollatCode Collateral Code 185 CollatDesc Collateral Description 161 StdIndustCode SIC Code 53 StdIndustDesc SIC Code Desc CRACenTract Census Tract 49 12 PtPaid Points Collected 254 CRASMSACode MSA Code 50 5 CRASMSADesc MSA Code Desc ChgdOffAmt Chargeoff Balance 222 LOCCode Major Cred Line Flg 239 (PIF) LOCDesc State EscrwCurBal Escrow Balance 209 IntPaidYTD YTD Interest Paid 249 IntPaidPYTD Prior Year Int Paid 64 PastDueDays Days Late 164 RateIdxNum Variable Rate Code 178 RateVar Variable Rate Adj 179 RateVarCode Rate Var Code Calculated based on field 179 RateCapUp Max Rt Inc Each Occ 360 RateCapDown Max Rt Dec Each Occ 361 RateCeil Max Lifetime Increase 191 RateFlr Max Lifetime Decrease 192 RateRevTermUnits Calculated based on field 180 LastAdvaAmt Last Advance Amount HISTRY.ISM HIST_TRAN_AMT LastAdvaDt Last Advance Date HIST_TRAN_DATE LastPmtAmt Amount Last Paid 141 RateRevDt Repricing Date 181 LastRenDt Date Loan Lst Renew 289 LastRenBal Bal Loan Lst Renew 290 LastMainDt Date Last Change 91 SecdMtgCode Second Mkt Loan Typ 298 SecdMtgDesc Second Mkt Loan Type Desc LOCOrigAmt Amount Orig Commit 240 (PIF) OrigMatDt Orig Maturity Date 301 ClsDt Closing Date 48 NonAccrDt Date NonAccr 218 HldMailCode Mail Code HldMailDesc Mail Code Desc LastExtDt Date Last Extension 208 StudentLnCode Student Loan Type 212 StudentLnDesc Student Loan Type Desc EscrwPmtAmt Escrow Payment Amt 340 DaysBeforeRateChg Adv Days for Rate 269 IntPaidLTD Interest Earned 128 LateChgCode Late Charge Code 268 CurLnToValRatio OffCode Officer Code 14 OffDesc Officer Code Desc LOCLmt Credit Limit 216 LastIntPmtDt AmtLastIntPd LastStmtBal Bal Last Loan Stmt 276 LastStmtDt Date Last Statement 204 ProtAcctId OD Protection Account Number ProtAcctType OD Protection Account Type NetCurBal PurpCode Purpose Code 24 PurpDesc Purpose Code Description GroupCode GL Code 25 GroupDesc GL Code Description GLNASS.ISM GL_XREF_DESC CrRatingCode Risk Code 193 CrRatingDesc Risk Code Desc OrigRate Original Interest Rate 187 RateType Calculated based on 178 ChgdOffDt Date Prin Charged Off 221 OccupCode Dwelling Indicator 501 PrtcpAcctId Participation Master Loan # 183 PrtcpAcctType MonthAvgBalAmt MTD Avg Balance 536 ChgdOffType NonAcc/Chgoff Flag Calculated based on 184 MonthIntIncmAmt MTD Int Paid CECL 946 DebtProtPlnCode Calculated based on 134, 136 or 195 >0 PrincPaidMTD TotDebtPct Debt/Income Ratio CIF 299 EstbPersonName CDD Person Opening 944 30 EstbPersonTitle CDD Person Title 945 PartIdName Participant Bank Description IntOnlyExpDt Interest Only End Dt 564 BallCallDt Balloon Call Date if 565 Balloon Note=Y, set to 130 Maturity Date InitARMFixPeriodCnt Fixed Rate Period 566 InitARMFixPeriodUnits Fixed Rate Period Units "Months" OrigNetOperIncAmt Net Operating Income CIF 281 CommOccupPct Occupancy Percent COL 204 PropCondRmk Property Condition COL 205 SBAGuarPct Guaranteed Port % 283 Custom.ACCOUNT_CHARGED_OFF Charged Off 184

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