LnAcctHist

ODI Extracts > Core Director > LnAcctHist

Extract to provide loan 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	String	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		HISTRY.ISM	Calculated based on HIST_TRAN_CODE	String	15
Core Director	ImgNum	Image Number	HISTRY.ISM	HIST_DSI_ITEM_SEQ	String	16
Core Director	EffDt	Posted Date	HISTRY.ISM	HIST_POSTED_DATE	DateTime	8
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	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