accounts_fct_cdd
Pipelined Data Sets
>
Account Services
>
accounts_fct_cdd
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| Id | This attribute defines the unique account identifier. | REQUIRED | STRING | |
| InstitutionUniversalId | This attribute defines a unique identifier to establish the identity of an Institution/Environment/Brand combination. | REQUIRED | STRING | |
| AccountNumber | This attribute defines the account number assigned to an account. | REQUIRED | STRING | |
| AccountType | This attribute defines whether the account is a checking or savings account. | REQUIRED | STRING | |
| ProductId | This 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. | REQUIRED | STRING | |
| AccountStatus | This attribute defines the status of the account. | REQUIRED | STRING | |
| OfficerId | This attribute defines the FI officer assigned to an account. | REQUIRED | STRING | |
| CycleDay | This 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. | REQUIRED | INTEGER | |
| OpenedDate | This attribute defines the date the account was opened. | REQUIRED | TIMESTAMP | |
| ClosedDate | This attribute defines the date the account was closed. | NULLABLE | TIMESTAMP | |
| DormantDate | This attribute defines the date the account status changed to dormant. | NULLABLE | TIMESTAMP | |
| ChargedOffDate | This attribute defines the date the account was charged off. | NULLABLE | TIMESTAMP | |
| ChargedOffAmount | This attribute defines the amount charged off. | REQUIRED | NUMERIC | |
| OverdraftLimit | This attribute defines the overdraft limit amount value. | REQUIRED | NUMERIC | |
| AutoClose | This 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. | REQUIRED | BOOLEAN | |
| RegEOptIn | This 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. | REQUIRED | STRING | |
| CurrencyType | This attribute defines the ISO 4217 three character currency type. USD is the default value. | REQUIRED | STRING | |
| WaiveOdNsfFees | This attribute defines if an account is set to waive all OD/NSF fees. | REQUIRED | BOOLEAN | |
| BranchId | This attribute defines the branch an account belongs to. The branch can be a physical or non-physical location. | REQUIRED | STRING | |
| WaiveServiceCharge | This attribute defines whether service charges can be waived on an account. | REQUIRED | BOOLEAN | |
| WaiveServiceChargeReason | This attribute defines the reason an account is set to waive service charges. | REQUIRED | STRING | |
| InterestPaymentMethod | This attribute defines how interest will be paid to an account. | REQUIRED | STRING | |
| InterestPaymentAccountId | This attribute defines the account where interest payments should be deposited. | REQUIRED | STRING | |
| FederalWithholdingFlag | This attribute defines whether federal withholding should be taken from interest payments. | NULLABLE | BOOLEAN | |
| StateWithholdingFlag | This attribute defines whether state withholding should be taken from interest payments. | NULLABLE | BOOLEAN | |
| InterestRate | This attribute defines the interest rate used for calculating interest payments. | REQUIRED | NUMERIC | |
| CreatedDate | This attribute defines the date the record was created. | REQUIRED | TIMESTAMP | |
| CreatedBy | This attribute defines the user who created the record. | NULLABLE | STRING | |
| ModifiedDate | This attribute defines the date the record was modified. | REQUIRED | TIMESTAMP | |
| ModifiedBy | This attribute defines the user who modified the record. | NULLABLE | STRING | |
| EscheatDate | This attribute defines the date the account went into escheat status. | NULLABLE | TIMESTAMP | |
| InactiveDate | This attribute defines the date the account went into inactive status. | NULLABLE | TIMESTAMP |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on StackOverflow.
- Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026