Developer Programs

Learn

Docs
Important notification about upcoming changes to the DMZ environment. Please read.

TimeDepAcct

Operational Data Integration (ODI) > ODI Extracts > Silverlake > TimeDepAcct

Extract to provide time deposit account master file information

Silverlake Dlt Delete Record Flag 1 SrcKey Unique Record Key 17 AcctId Account Number CDMAST ACCTNO 9 16 AcctType Account Type ACTYPE FornKey Customer Key CurBal Current Balance CBAL 6 11 2 AccrInt Accrued Interest ACCINT 7 13 5 CustId Customer Id 8 PenAmt Penalty For Early Redeem PENAMT BrCode Branch BR# 3 BrDesc Bank/branch name JHDATA JDNAME 30 ProdCode C.D. Type Code TYPE ProdDesc Type Description CDPAR2 PDESC 20 AcctStatDesc Status Description JHPARHV HVDESC 40 OffCode Officer OFFCR OffDesc Officer name JHOFFR JHONAM AcctClsfCode Class CLASS AcctClsfDesc Class description JHCLAS JHCDES 15 LastActDt Date Last Active ACTVDT 4 PlnCode IRA plan Code PLAN AcctStat Status PlnDesc Description CDPAR6 P6DESC 35 OpenDt Date Issued ISSDT ClsDt Redemption Date RDMDT LastConDt Date Last Contact CONTDT MatDt Maturity Date MATDT CDTerm C.D. Term CDTERM CDTermUnits C.D. Term Code CDTCOD OrigBal Original Amount ORGBAL CertifId CD Number CDNUM SalesPerson Sales Associate SALESAC TINCode Tax ID type code CFMAST CFSSCD TINDesc CFPART TXDESC TaxId Tax ID number CFSSNO AbbName Short Name SNAME IntRate Interest Rate RATE PrevYTDIntPaid Previous YTD Interest PREYTD YTDInt Year to Date Interest YTDINT IntDisp Disposition DISP IntTerm Interest Term INTERM IntTermUnits Interest Term Code ITCODE CallRptCode Call Report Code CALREPT AccrMeth Accrual Method PMETHD AccrMethDesc Method Decription 25 RenCode Renewal Code RENEW RenDesc Renewal Description CRACenTract Census Tract CENSUS ClsRsnCode Closed reason Code CDCLOSEDRS ClsRsnDesc Closed Description CDPAR5 P5CLOSEDDS SrcFundsCode Original Src Of Funds ORGSRC SrcFundsDesc Funds Source Description CDPAR4 CP4DSC 60 LastDepDt Date Last Deposit LDEPDT LastRenDt Last Renewal Date RENDT NxtPayDt Next Pay Date NPDAT HldAmt Hold Amount HOLD LastRenAmt Bal at Last Renewal PRVBAL LastDepAmt Amount Last Deposit LSTDEP LastInt Amount Last Interest AMTLIN LastPayDt Last Pay Date LPDAT StmtBal Balance Last Stmt STMBAL LastStmtDt Date Last Statement STMDT OrigAcctId Original Account Id MonthAvgBalAmt Monthly Average Balance GroupCode Group Code GLProdCode GL Product Code RateRevTerm Rate Review Term RateRevTermUnits Rate Review Term Units MTDIntPaid MTD Interest Paid LastRePriceDt Last Reprice Date IntDispAcctId Deposit Acct Number RateRevDt Rate Review Date IntDispAcctType Deposit Acct Number Type RateType Rate Type AnnPctYield Annual Pct Yield MTDAvgColBal MTD Average Collected Balance StateWithCode State WithHolding Code PrimeRateIdx Variable Rate Number RateVar Rate Variance RateVarCode Rate Variance Code EstbPersonName Name of person opening account EstbPersonTitle Title of person opening account 70 BrandCode Brand Code 10 BrandDesc Brand Description 50

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