Table Description

Coverage: A Household Member who is insured under an insurance policy and who is not the policy holder.

The insurance policy can be either general or medical. The Coverage record includes the Household Member's relationship to the policy holder, and the monetary value of the amount payable for insuring the Household Member.

Example

Linda Smith has medical insurance and is the policyholder. A case worker creates a Coverage record for Susan Smith who is covered under the medical insurance policy.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Resources::Coverage::Coverage
Controlling File: Evidence\model\ServiceLayer\entity\Resources\Coverage\Coverage_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Coverage.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member for whom cover is provided or is available. For example, cover may be available through an employer group scheme but the employee (Household Member) may not have elected to receive this cover.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
relationshipToPolicyHolderdetailsyes

A code table value describing the relationship of the insured individual or the individual for whom cover is available to the policy holder. The insured individual or individual for whom cover is available is a Household Member. The policy holder may or may not be a household member.

EVD_RSHIP_TO_POLICY_HOLDERRshipToPolicyholderSVR_STRING<10>
commentsdetails 

Details related to the Coverage.

COMMENTS SVR_STRING<300>
startDatedetails 

The start date of the Coverage.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Coverage.

CURAM_DATE SVR_DATE
coverageExhaustedInddetails 

Indicates whether the maximum claimed benefit limit under the medical insurance policy has been reached.

CURAM_INDICATOR SVR_BOOLEAN
premiumdetails 

Premium records the monetary value of the amount payable for a Household Member.

CURAM_AMOUNT SVR_MONEY
coverageEndReasondetails 

Coverage end reason records and explanation of why coverage under the medical insurance policy ended for the Household Member.

EVD_COVERAGE_END_REASONCoverageEndReasonSVR_STRING<10>
Foreign Keys (1)
ChildParent
Coverage.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__338780963caseParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
transferEvidence    
Related Pages (3)