Health Plan Group CategoryIndustry ClassificationSelf Administered Group IndSelf Funded Group Ind
| Business Data Model Data Model |
| Description | A group of people covered under the same health plan product and sponsored by the same group sponsor or plan sponsor. |
| Attributes | |
| Health Plan Group Category |
|
| Industry Classification |
|
| Self Administered Group Ind |
|
| Self Funded Group Ind |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Health Plan Group Category
| Description | Indicates the category of a health benefits plan group according to the size of the account involved. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Industry Classification
| Description | Indicates the organization's or health benefits plan group's main business activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Self Administered Group Ind
| Description | Indicates whether or not the administration of the health benefits plan group is provided by the health benefits plan group itself, or by an outside agency or healthcare insurer. For example: 0 = Not Administered By Group 1 = Administered By Group |
| 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 |
Self Funded Group Ind
| Description | Indicates whether or not the claims funding for the health benefits plan group is provided by the health benefits plan group itself, or by an outside agency or healthcare insurer. For example: 0 = Not Funded By Group 1 = Funded By Group |
| 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 |
Party is benefits consultant for Health Plan Group
| Is Identifying Relationship | false |
| Child Table | Health Plan Group |
| Child Role Name | has benefits consultant of |
| 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 | Party |
| Parent Role Name | is benefits consultant for |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Intermediary is sales intermediary for Health Plan Group
| Is Identifying Relationship | false |
| Child Table | Health Plan Group |
| Child Role Name | has sales intermediary of |
| 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 | Intermediary |
| Parent Role Name | is sales intermediary for |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Organization sponsors Health Plan Group
| Is Identifying Relationship | false |
| Child Table | Health Plan Group |
| Child Role Name | is sponsored by |
| 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 | Organization |
| Parent Role Name | sponsors |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Health Plan Group_Health Plan Product_FK
| Is Identifying Relationship | false |
| Child Table | Health Plan Group |
| 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 |
| Business Data Model Data Model |