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