Enterprise Solutions

TimeDepAcct

Operational Data Integration (ODI) > ODI Extracts > Core Director > TimeDepAcct

Extract to provide time deposit account master file information

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

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024