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	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.

Please ignore this field

Did this page help you?

Last updated Fri Feb 21 2025