Commission EarnedCommission Rate SacrificedCommission WithheldNumber Of Payments MadePre-issue Commission Ind
| Business Data Model Data Model |
| Description | An agreement defining the way in which an intermediary can act on behalf of a healthcare insurer. For example: Broker agreement between Broker ABC and Acme Insurance Company. |
| Attributes | |
| Commission Earned |
|
| Commission Rate Sacrificed |
|
| Commission Withheld |
|
| Number Of Payments Made |
|
| Pre-issue Commission Ind |
|
| Relationship | |
 Intermediary Agreement_Health Plan Product_FK |
|
| Generalization | |
 Intermediary Agreement_Agreement_Gen |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Commission Earned
| Description | Sum of commission earned under the terms of the agreement. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Commission Rate Sacrificed
| Description | Rate representing the portion of commission given up by the sales entity to enhance the terms for their client. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Commission Withheld
| Description | Sum of that part of the commissions which are not paid out to the sales entity, but kept as compensation for contracts which are prematurely terminated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Number Of Payments Made
| Description | The number of commission payments made. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pre-issue Commission Ind
| Description | Indicates whether (1) or not (0) the pre-issue of commission applies to the agreement. Under this process, commission is paid to the intermediary's or sales rep's current account because he issued a new application for insurance. The pre-issue commission will be reversed when the commission for the new business comes on the books. When the new policy does not come on the books, the pre-issue commission will be recovered. This usually happens at a set point in time. The reason for allocating pre-issue commission is that it may take several weeks before the underwriting process (especially medical underwriting) can be completed. Without pre-issue commission, the intermediary would have to wait all this time before they receive the commission. Pre-issue commission is optional, as the health plan may or may not want to do this process. For example: 0 = Pre-Issue Commission Does Not Apply 1 = Pre-Issue Commission Applies |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Intermediary Agreement_Health Plan Product_FK
| Is Identifying Relationship | false |
| Child Table | Intermediary Agreement |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Health Plan Product |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Intermediary Agreement_Agreement_Gen
| Supertype | Agreement |
| Subtype | Intermediary Agreement |
| Transform As | TABLE |
| Business Data Model Data Model |