Participant Settlement Data Element
Participant Settlements represent the foundational data construct that defines and manages how payments are distributed among participating parties. It consists of a PARTICIPANT_SETTLEMENT table, which captures the high-level settlement details such as type, override indicators, and comments, and a PARTICIPANT_SETTLEMENT_ITEM table, which defines the specific allocations, commission details, and links to related payment records.
The PARTICIPANT_SETTLEMENT table serves as the central record for each settlement, while PARTICIPANT_SETTLEMENT_ITEM specifies the distribution of amounts, including commission percentages and flat rate indicators, across the relevant participants. Together, these tables provide a complete framework for managing settlement calculations, ensuring proper attribution of payments, and supporting downstream financial and accounting processes.
PARTICIPANT_SETTLEMENT
| Field | Type | Comment |
|---|---|---|
| PARTICIPANT_SETTLEMENT_ID | Number | Unique identifier for the Participant Settlement |
| PARTICIPANT_SETTLEMENT_TYPE_CD | String | Code Master for Participant_Settlement_Type_Cd |
| PARTICIPANT_SETTLEMENT_OVERRIDED_IND | Boolean | Indicator if the split has been overriden from the deal |
| PARTICIPANT_SETTLEMENT_COMMENT | String | Comment for the settlement |
| CREATED_BY | String | User who created the record |
| CREATED_DT | Timestamp | Timestamp when the record was created |
| UPDATED_BY | String | User who last updated the record |
| UPDATED_DT | Timestamp | Timestamp when the record was last updated |
PARTICIPANT_SETTLEMENT CODE MASTER
| Code_Master_Cd | Code_Master_Desc | Code_Master_Type |
|---|---|---|
| D | Draft | PARTICIPANT_SETTLEMENT_TYPE_CD |
| S | Submitted | PARTICIPANT_SETTLEMENT_TYPE_CD |
| A | Approved | PARTICIPANT_SETTLEMENT_TYPE_CD |
| Code Master Type | Code | Attribute | Value | Description |
|---|---|---|---|---|
PARTICIPANT_SETTLEMENT_ITEM
| Field | Type | Comment |
|---|---|---|
| PARTICIPANT_SETTLEMENT_ITEM_ID | Number | Unique identifier for the Participant Settlement Item |
| PARTICIPANT_SETTLEMENT_ID | Number | FK for the Settlement Header |
| PAYMENT_PARTY_ID | Number | FK for Party |
| PAYMENT_PARTY_BANK_ID | Number | FK to bank account of party |
| PARTICIPANT_SETTLEMENT_COMMISSION_FLAT_IND | Boolean | Indicator if commission is flat or % based |
| PARTICIPANT_SETTLMENT_COMMISSION_PERC | Number | % of commission off of net amt |
| PARTICIPANT_SETTLEMENT_COMMISSION_AMT | Number | Total Commission |
| PARTICIPANT_SETTLEMENT_ITEM_COMMENT | String | Comment for the settlement Item |
| PAYMENT_ITEM_ID | Number | FK to payment Item |
| CREATED_BY | String | User who created the record |
| CREATED_DT | Timestamp | Timestamp when the record was created |
| UPDATED_BY | String | User who last updated the record |
| UPDATED_DT | Timestamp | Timestamp when the record was last updated |