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