LnAcctHist
Operational Data Integration (ODI)
>
ODI Extracts
>
Core Director
>
LnAcctHist
Extract to provide loan account history information (shows rows that have been deleted since the last extract was created)
Core Director
Dlt
Delete record flag
String
1
SrcKey
Unique record key
HISTRY.ISM
HIST_FULL_KEY
32
FornKey
Account Key
HIST_KEY
18
AcctId
Account Number
HIST_ACCT
16
AcctType
Account Type
HIST_ACCT_TYPE
2
TrnCodeCode
Tran Code
HIST_TRAN_CODE
Int32
3
TrnCodeDesc
Tran Code Description
TDESCR.DDF
TCDESC
25
PostDt
Tran Date
HIST_TRAN_DATE
DateTime
8
Amt
Tran Amount
HIST_TRAN_AMT
Decimal
12
SeqNum
Sequence number
HIST_PROOF_SEQ
6
SrcCodeDesc
Source Code Description
Calculated based on HIST_TRAN_SOURCE
60
TrnType
Transaction Type
TCDRCR (if TCDRCR blank, determined from TCADD)
AffCode
Calculated based on HIST_TRAN_CODE
15
ImgNum
Image Number
HIST_DSI_ITEM_SEQ
EffDt
Posted Date
HIST_POSTED_DATE
OldRate
Old Interest Rate
7
4
NewRate
New Interest Rate
TellerNum
Teller number
HIST_TELLER_NO
TrnStat
Do Not Show Transaction
Calculated based on HIST_NOSHOW
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