Deposit Control
Overview
The Deposit Control (DEPOSIT CTL) subject area manages the lifecycle of customer deposits, including their creation, tracking, reconciliation, and closure. Each deposit is recorded with a unique Deposit Control ID (DEP_CTL_ID) and includes attributes such as amount, currency, tender source type, and status.
The Deposit Control subject area integrates with payment and refund processes, ensuring that deposits are properly accounted for in scenarios such as adjustments, reversals, and refunds.
Conforming Layers
The only conforming layer of this subject area is DEPOSIT_CTL_OBJ.
DEPOSIT_CTL_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| DEP_CTL_ID | Unique identifier for the deposit control record. | VARCHAR | 10 |
| TNDR_SRCE_TYPE_FLG | Flag classifying deposits based on the type of tender source. | VARCHAR | 4 |
| DEP_CTL_STATUS_FLG | Status of the deposit control. | VARCHAR | 2 |
| CRE_DTTM | Date and time when the deposit control record was created. | TIMESTAMP | |
| USER_ID | User who created the deposit control record. | VARCHAR | 8 |
| BALANCED_USER_ID | User who balanced the deposit. | VARCHAR | 8 |
| BALANCED_DTTM | Date and time when the deposit was balanced. | TIMESTAMP | |
| END_BALANCE | Ending balance amount of the deposit control. | DECIMAL | 15 |
| CURRENCY_CD | ISO code for the currency in which the deposit control is recorded. | VARCHAR | 3 |
| TNDR_DEP_ID | Unique identifier for the tender deposit associated with the control record. | VARCHAR | 10 |
| BANK_ACCT_KEY | Identifier for the bank account tied to the deposit. It is used to map deposits to external bank accounts. | VARCHAR | 30 |
| BANK_CD | Code for the bank associated with the deposit. | VARCHAR | 15 |
| DEPOSIT_AMT | Total amount deposited in the bank. | DECIMAL | 15 |
| REFERENCE_ID | External reference or identifier for the deposit. It is often used to store transaction numbers or bank reference codes. | VARCHAR | 50 | CDC_FLAG | Flag specifying the type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | TIMESTAMP | |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| COMPOSITE_KEY | Unique identifier in the DEP_CTL_ID format. This is the primary key. |
VARCHAR | 10 |