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