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