TimeDepAcct

ODI Extracts > Core Director > TimeDepAcct

Extract to provide time deposit account master file information

Provider	Element	Element Description	Reference File	Reference Field	Length	Decimal Places
Core Director	Dlt	Delete record flag			1
Core Director	SrcKey	Unique Record Key	MASTER.ISM	COM_MASTER_PRIMARY_KEY	18
Core Director	FornKey	Account Key	MASTER.ISM		18
Core Director	AcctId	Account Number	MASTER.ISM	3	16
Core Director	AcctType	Account Type	MASTER.ISM	2	2
Core Director	CustId	CIF Number	MASTER.ISM	1	9
Core Director	CurBal	Current Balance	MASTER.ISM	126 (CD, IRA)	16	2
Core Director	AccrInt	YTD Contributions	MASTER.ISM	142 (CD) 155 (IRA)	14	4
Core Director	PenAmt	LYr Contributions	MASTER.ISM	143 (CD) 152 (IRA)	10	2
Core Director	BrCode	Branch Code	MASTER.ISM	16	2
Core Director	BrDesc	Branch Description	USRCOD.ISM/BRCCON.ISM	USER_DESCRIPTION (if blank, BRCH_RECORD_NAME)	40
Core Director	ProdCode	Product Code	MASTER.ISM	38	6
Core Director	ProdDesc	Product Description	WDSTRG.ISM	DSDSC	40
Core Director	AcctStat	Account Status	MASTER.ISM	20	1
Core Director	AcctStatDesc	Account Status Desc		Calculated based on field 20	40
Core Director	OffCode	Officer Initials	MASTER.ISM	14	3
Core Director	OffDesc	Officer Description	USRCOD.ISM	USER_DESCRIPTION	40
Core Director	AcctClsfCode	Class Code	MASTER.ISM	132 (CD)	3
Core Director	AcctClsfDesc	Class Description		Calculated based on field 132	40
Core Director	PlnCode	Type of IRA	MASTER.ISM	188 (IRA)	1
Core Director	PlnDesc	Description		Calculated based on field 188	40
Core Director	OpenDt	Date Opened	MASTER.ISM	17	8
Core Director	ClsDt	Closing Date	MASTER.ISM	48	8
Core Director	LastConDt	Last Contact Date	MASTER.ISM	28	8
Core Director	MatDt	Maturity Date	MASTER.ISM	140 (CD) 149 (IRA)	8
Core Director	CDTerm	Term	MASTER.ISM	130 (CD) 129 (IRA)	3
Core Director	CDTermUnits	Mo/Day Flag	MASTER.ISM	Calculated	11
Core Director	OrigBal	Original Balance	MASTER.ISM	127 (CD) 207 (IRA)	16	2
Core Director	CertifId	Account Number	MASTER.ISM	3	16
Core Director	TINCode	Tax ID Code	MASTER.ISM	92	1
Core Director	TINDesc	Tax ID Description		Calculated based on field 92	40
Core Director	TaxId	SSN/EIN	MASTER.ISM	13	10
Core Director	AbbName	Short Name	MASTER.ISM	36	17
Core Director	IntRate	Interest Rate	MASTER.ISM	135 (CD) 132 (IRA)	7	4
Core Director	PrevYTDIntPaid	Prior Year Int Paid	MASTER.ISM	64	12	2
Core Director	YTDInt	YTD Interest Paid	MASTER.ISM	141 (CD) 204 (IRA)	12	2
Core Director	IntDisp	Apply Interest Code	MASTER.ISM	Based on 136 (CD), Based on 135 (IRA)	15
Core Director	IntTermUnits	Interest Freq Code	MASTER.ISM	Based on 134 (CD), Based on 134 (IRA)	11
Core Director	AccrMeth	Comp/Simp	MASTER.ISM	146 (CD) 150 (IRA)	1
Core Director	AccrMethDesc	Descriptin	MASTER.ISM	Based on 146 (CD), Based on 150 (IRA)	8
Core Director	RenCode	Renewal Code	MASTER.ISM	133 (CD, IRA)	2
Core Director	RenCodeDesc	Renewal Code Description	MASTER.ISM	Calculated based on 133 (CD, IRA)	13
Core Director	CRACenTract	Census Tract	MASTER.ISM	49	12	2
Core Director	LastDepDt	Last Contrib Date	MASTER.ISM	169 (IRA)	8
Core Director	LastRenDt	Prior Maturity Date	MASTER.ISM	147 (CD) 186 (IRA)	8
Core Director	HldAmt	Total Hold Amount	MASTER.ISM	188 (CD) 259 (IRA)	12	2
Core Director	LastRenAmt	Renewal Balance	MASTER.ISM	149 (CD) 206 (IRA)	16	2
Core Director	LastInt	Last Int Paid Amt	MASTER.ISM	144 (CD) 187 (IRA)	12	2
Core Director	LastPayDt	Date Intr Last Paid	MASTER.ISM	129 (CD) 163 (IRA)	8
Core Director	LastStmtDt	Date Last Statement	MASTER.ISM	162 (IRA)	8
Core Director	LastDepAmt	Last Deposit Amount	HISTRY.ISM	HIST_TRAN_AMT (CD)	12	2
Core Director	NxtPayDt	Date Interest Next	MASTER.ISM	138 (CD) 148 (IRA)	8
Core Director	StateWithCode	State Withhold Flag	MASTER.ISM	283 (IRA)	1
Core Director	GroupCode	G/L Code	MASTER.ISM	25	3
Core Director	RateType	Rate Code	MASTER.ISM	151 (CD) 176 (IRA)	5
Core Director	EstbPersonName	CDD Person Opening	MASTER.ISM	944	30
Core Director	EstbPersonTitle	CDD Person Title	MASTER.ISM	945	10

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