TimeDepAcctHist
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)
| Provider | Element | Element Description | Reference File | Reference Field | Field Type | Length | Digits | Decimal Places |
|---|---|---|---|---|---|---|---|---|
| Core Director | Dlt | Delete record flag | 1 | |||||
| Core Director | SrcKey | Unique Record Key | HISTRY.ISM | HIST_FULL_KEY | 32 | |||
| Core Director | FornKey | Account Key | HISTRY.ISM | HIST_KEY | 18 | |||
| Core Director | AcctId | Account Number | HISTRY.ISM | HIST_ACCT | 16 | |||
| Core Director | AcctType | Account Type | HISTRY.ISM | HIST_ACCT_TYPE | 2 | |||
| Core Director | TrnCodeCode | Tran Code | HISTRY.ISM | HIST_TRAN_CODE | 3 | |||
| Core Director | TrnCodeDesc | Tran Code Description | TDESCR.DDF | TCDESC | 25 | |||
| Core Director | PostDt | Tran Date | HISTRY.ISM | HIST_TRAN_DATE | 8 | |||
| Core Director | Amt | Tran Amount | HISTRY.ISM | HIST_TRAN_AMT | 12 | 2 | ||
| Core Director | SeqNum | Sequence Number | HISTRY.ISM | HIST_PROOF_SEQ | 6 | |||
| Core Director | SrcCodeDesc | Source Code Description | HISTRY.ISM | Calculated based on HIST_TRAN_SOURCE | 60 | |||
| Core Director | TrnType | Transaction Type | TDESCR.DDF | TCDRCR (if TCDRCR blank, determined from TCADD) | 1 | |||
| Core Director | AffCode | Rate Change | HISTRY.ISM | Calculated base on Rate Change Tran Codes | 15 | |||
| Core Director | ImgNum | Image number | HISTRY.ISM | HIST_DSI_ITEM_SEQ | 16 | |||
| Core Director | EffDt | Posted Date | HISTRY.ISM | HIST_POSTED_DATE | 8 | |||
| Core Director | OldRate | Old Interest Rate | HISTRY.ISM | HIST_TRAN_AMT | 7 | 4 | ||
| Core Director | NewRate | New Interest Rate | HISTRY.ISM | HIST_TRAN_AMT | 7 | 4 | ||
| Core Director | TellerNum | Teller Number | HISTRY.ISM | HIST_TELLER_NO | 4 | |||
| Core Director | TrnStat | Do Not Show Transaction | HISTRY.ISM | Calculated based on HIST_NOSHOW | 1 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Developer Office Hours
where we answer technical Q&A from the audience.
Did this page help you?
Last updated Fri Feb 21 2025