Entity Coverage Type

DescriptionA list of coverage types to which a member is entitled and the range of dates during which the coverage is valid.

Attributes
Co-Payment AmtCo-Payment Amt
Co-Payment PctCo-Payment Pct
Coverage LimitCoverage Limit
Coverage TypeCoverage Type
Coverage Type End DateCoverage Type End Date
Coverage Type Start DateCoverage Type Start Date

Relationship
Coverage Type_Coverage Eligibility_FKCoverage Type_Coverage Eligibility_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



 Coverage Type End Date
DescriptionThe date upon which the coverage ends for the plan member.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Coverage Type Start Date
DescriptionThe date upon which coverage begins for the plan member.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Coverage Type_Coverage Eligibility_FK
Is Identifying Relationshiptrue
Child TableCoverage Type
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCoverage Eligibility
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE