Entity Insurance Plan Coverage

DescriptionThe coverage to which a subscriber of the insurance plan is entitled. The insurance plan coverage represents a basic set of information about the coverages of an insurance plan known to the healthcare provider.

Attributes
Co-Payment AmtCo-Payment Amt
Co-Payment PctCo-Payment Pct
Coverage LimitCoverage Limit
Coverage TypeCoverage Type

Relationship
Health Plan Coverage_Health Plan_FKHealth Plan Coverage_Health Plan_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Co-Payment Amt
DescriptionThe specific co-payment amount applying to all benefits under the coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Co-Payment Pct
DescriptionThe specific co-payment percentage applying to all benefits for the coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Coverage Limit
DescriptionThe maximum amount that can be received in eligible benefits for the coverage.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Coverage Type
DescriptionIndicates the type of the benefit coverage.

For example:
Dental Coverage
Hospital Indemnity Coverage
Pharmacy Coverage
Well-baby Care
Preventive Care (such as exams)
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Health Plan Coverage_Health Plan_FK
Is Identifying Relationshiptrue
Child TableInsurance Plan Coverage
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableInsurance Plan
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE