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