TimeDepAcct
Operational Data Integration (ODI)
>
ODI Extracts
>
CIF2020
>
TimeDepAcct
Extract to provide time deposit account master file information
CIF2020
Dlt
Delete Record Flag
1
SrcKey
Unique Record Key
17
FornKey
Customer Key
9
AcctId
Account Number
16
AcctType
Account Type
CustId
Customer Id
8
CurBal
Current Balance
6
11
2
AccrInt
Accrued Interest
7
13
5
PenAmt
Penalty For Early Redeem
BrCode
Branch
3
BrDesc
Bank/branch name
30
ProdCode
C.D. Type Code
ProdDesc
Type Description
20
AcctStat
Status
AcctStatDesc
Status Description
40
OffCode
Officer
OffDesc
Officer name
AcctClsfCode
Class
AcctClsfDesc
Class description
15
LastActDt
Date Last Active
4
PlnCode
IRA plan Code
PlnDesc
Description
35
OpenDt
Date Issued
ClsDt
Redemption Date
LastConDt
Date Last Contact
MatDt
Maturity Date
CDTerm
C.D. Term
CDTermUnits
C.D. Term Code
OrigBal
Original Amount
CertifId
CD Number
SalesPerson
Sales Associate
TINCode
Tax ID type code
TINDesc
TaxId
Tax ID number
AbbName
Short Name
IntRate
Interest Rate
PrevYTDIntPaid
Previous YTD Interest
YTDInt
Year to Date Interest
IntDisp
Disposition
IntTerm
Interest Term
IntTermUnits
Interest Term Code
CallRptCode
Call Report Code
AccrMeth
Accrual Method
AccrMethDesc
Method Decription
25
RenCode
Renewal Code
RenDesc
Renewal Description
CRACenTract
Census Tract
ClsRsnCode
Closed reason Code
ClsRsnDesc
Closed Description
SrcFundsCode
Original Src Of Funds
SrcFundsDesc
Funds Source Description
60
LastDepDt
Date Last Deposit
LastRenDt
Last Renewal Date
NxtPayDt
Next Pay Date
HldAmt
Hold Amount
LastRenAmt
Bal at Last Renewal
LastDepAmt
Amount Last Deposit
LastInt
Amount Last Interest
LastPayDt
Last Pay Date
StmtBal
Balance Last Stmt
LastStmtDt
Date Last Statement
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
RateRevDt
Rate Review Date
RateType
Rate Type
MTDAvgColBal
MTD Average Collected Balance
IntDispAcctId
Deposit Acct Number
IntDispAcctType
Deposit Acct Number Type
AnnPctYield
Annual Pct Yield
ProjCurBal
Value After Interest
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
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