TimeDepAcctHist
Operational Data Integration (ODI)
>
ODI Extracts
>
Core Director
>
TimeDepAcctHist
Extract to provide Time deposit account history details (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
Rate Change
Calculated base on Rate Change Tran Codes
15
ImgNum
Image number
HIST_DSI_ITEM_SEQ
Int64
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