Developer Programs

Learn

Docs

accounts_fct_cdd

Pipelined Data Sets > Account Services > accounts_fct_cdd

Column nameDescriptionModeTypeLength
IdThis attribute defines the unique account identifier.REQUIREDSTRING
InstitutionUniversalIdThis attribute defines a unique identifier to establish the identity of an Institution/Environment/Brand combination.REQUIREDSTRING
AccountNumberThis attribute defines the account number assigned to an account.REQUIREDSTRING
AccountTypeThis attribute defines whether the account is a checking or savings account.REQUIREDSTRING
ProductIdThis attribute defines the productId of a product assigned to an account. Attributes that can be defined are: cycle day, OD/NSF charges, fees, dormant days, accrual methods if interest is paid, etc.REQUIREDSTRING
AccountStatusThis attribute defines the status of the account.REQUIREDSTRING
OfficerIdThis attribute defines the FI officer assigned to an account.REQUIREDSTRING
CycleDayThis attribute defines the day of the month when all account activity will be cycled to assess services charges, pay interest (if applicable), and generate an account statement.REQUIREDINTEGER
OpenedDateThis attribute defines the date the account was opened.REQUIREDTIMESTAMP
ClosedDateThis attribute defines the date the account was closed.NULLABLETIMESTAMP
DormantDateThis attribute defines the date the account status changed to dormant.NULLABLETIMESTAMP
ChargedOffDateThis attribute defines the date the account was charged off.NULLABLETIMESTAMP
ChargedOffAmountThis attribute defines the amount charged off.REQUIREDNUMERIC
OverdraftLimitThis attribute defines the overdraft limit amount value.REQUIREDNUMERIC
AutoCloseThis attribute defines if the account will automatically close when brought to a zero balance. This attribute will work in conjunction with the number of days at a zero balance before closing.REQUIREDBOOLEAN
RegEOptInThis attribute defines whether the Entity agrees to accept transactions that could take them into the negative balance resulting in an overdraft charge. This is a regulatory item.REQUIREDSTRING
CurrencyTypeThis attribute defines the ISO 4217 three character currency type. USD is the default value.REQUIREDSTRING
WaiveOdNsfFeesThis attribute defines if an account is set to waive all OD/NSF fees.REQUIREDBOOLEAN
BranchIdThis attribute defines the branch an account belongs to. The branch can be a physical or non-physical location.REQUIREDSTRING
WaiveServiceChargeThis attribute defines whether service charges can be waived on an account.REQUIREDBOOLEAN
WaiveServiceChargeReasonThis attribute defines the reason an account is set to waive service charges.REQUIREDSTRING
InterestPaymentMethodThis attribute defines how interest will be paid to an account.REQUIREDSTRING
InterestPaymentAccountIdThis attribute defines the account where interest payments should be deposited.REQUIREDSTRING
FederalWithholdingFlagThis attribute defines whether federal withholding should be taken from interest payments.NULLABLEBOOLEAN
StateWithholdingFlagThis attribute defines whether state withholding should be taken from interest payments.NULLABLEBOOLEAN
InterestRateThis attribute defines the interest rate used for calculating interest payments.REQUIREDNUMERIC
CreatedDateThis attribute defines the date the record was created.REQUIREDTIMESTAMP
CreatedByThis attribute defines the user who created the record.NULLABLESTRING
ModifiedDateThis attribute defines the date the record was modified.REQUIREDTIMESTAMP
ModifiedByThis attribute defines the user who modified the record.NULLABLESTRING
EscheatDateThis attribute defines the date the account went into escheat status.NULLABLETIMESTAMP
InactiveDateThis attribute defines the date the account went into inactive status.NULLABLETIMESTAMP


Have a Question?

Did this page help you?

Last updated Wed Mar 4 2026