DepAcctHist
ODI Extracts
>
Core Director
>
DepAcctHist
Extract to provide deposit account history information (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 | String | 1 | ||||
| Core Director | SrcKey | Unique record key | HISTRY.ISM | HIST_FULL_KEY | String | 32 | ||
| Core Director | FornKey | Account key | HISTRY.ISM | HIST_KEY | String | 18 | ||
| Core Director | AcctId | Account Number | HISTRY.ISM | HIST_ACCT | String | 16 | ||
| Core Director | AcctType | Account Type | HISTRY.ISM | HIST_ACCT_TYPE | String | 2 | ||
| Core Director | TrnCodeCode | Tran Code | HISTRY.ISM | HIST_TRAN_CODE | Int32 | 3 | ||
| Core Director | TrnCodeDesc | Tran Code Description | TDESCR.DDF | TCDESC | String | 25 | ||
| Core Director | PostDt | Tran Date | HISTRY.ISM | HIST_TRAN_DATE | DateTime | 8 | ||
| Core Director | Amt | Tran Amount | HISTRY.ISM | HIST_TRAN_AMT | Decimal | 12 | 2 | |
| Core Director | SeqNum | Sequence Number | HISTRY.ISM | HIST_PROOF_SEQ | Int32 | 6 | ||
| Core Director | SrcCodeDesc | Source Code Description | HISTRY.ISM | Calculated based on HIST_TRAN_SOURCE | String | 60 | ||
| Core Director | TrnType | Transaction Type | TDESCR.DDF | TCDRCR (if TCDRCR blank, determined from TCADD) | String | 1 | ||
| Core Director | AffCode | Rate Change | HISTRY.ISM | Calculated base on Rate Change Tran Codes | String | 15 | ||
| Core Director | ImgNum | Image number | HISTRY.ISM | HIST_DSI_ITEM_SEQ | Int64 | 16 | ||
| Core Director | EffDt | Posted Date | HISTRY.ISM | HIST_POSTED_DATE | DateTime | 8 | ||
| Core Director | ChkNum | Check Number | HISTRY.ISM | HIST_CHECK_NUMBER | Int64 | 10 | ||
| Core Director | ACHStdEntryClass | Secondary Source of Transaction | HISTRY.ISM | HIST_TRAN_SECONDARY_SOURCE | String | 3 | ||
| Core Director | StmtPasCode | Passbook flag | HISTRY.ISM | Calculated based on 282 (SAV) | String | 4 | ||
| Core Director | OldRate | Old Interest Rate | HISTRY.ISM | HIST_TRAN_AMT | Decimal | 7 | 4 | |
| Core Director | NewRate | New Interest Rate | HISTRY.ISM | HIST_TRAN_AMT | Decimal | 7 | 4 | |
| Core Director | TellerNum | Teller Number | HISTRY.ISM | HIST_TELLER_NO | Int32 | 4 | ||
| Core Director | PayeeName | Payee | HISTRY.ISM | Calculated based on HIST_EXTEND_DESCRIPTION_1, _2, _3 | String | 105 | ||
| Core Director | TrnStat | Do Not Show Transaction | HISTRY.ISM | Calculated based on HIST_NOSHOW | String | 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