Table Description

General Insurance: A general insurance including automobile, homeowners, and travel, that provides payment to a Household Member depending on the loss from a particular financial event.

A Household Member may have his or her own general insurance policy or be covered under someone else's policy. For example, children in a household may be covered by a non-custodial parent's general insurance policy.

Example

Linda Smith intends to travel abroad during the year for a period of time. Linda Smith purchases travel liability from an insurance company for a monthly premium. A case worker creates a General Insurance record for Linda Smith who is the policy holder.

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::Chip::GeneralInsurance::GeneralInsurance
Controlling File: Evidence\model\ServiceLayer\entity\Chip\GeneralInsurance\GeneralInsurance_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the General Insurance

EVIDENCE_ID SVR_INT64
generalInsuranceTypedetails 

Type of General Insurance

EVD_GENERAL_INSURANCE_TYPEGeneralInsuranceTypeSVR_STRING<10>
plchdrCaseParticipantRoleIDdetailsno

The Case Participant Role ID of the policyholder

CASE_PARTICIPANT_ROLE_ID SVR_INT64
policyNumberdetails 

The General Insurance policy or certificate number

EVD_POLICY_NUMBER SVR_STRING<30>
policyStartDatedetails 

The date on which coverage begins under the policy

CURAM_DATE SVR_DATE
policyEndDatedetails 

The date on which coverage ends under the policy

CURAM_DATE SVR_DATE
insCaseParticipantRoleIDdetailsno

The Case Participant Role ID of the insurance company

CASE_PARTICIPANT_ROLE_ID SVR_INT64
premiumdetails 

The monetary value of the amount payable for the general insurance cover

CURAM_AMOUNT SVR_MONEY
frequencydetails 

The frequency with which the premium will be paid

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
commentsdetails 

Details related to the General Insurance

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
GeneralInsurance.plchdrCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__809174120plchdrCaseParticipantRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified generalInsuranceID 
transferEvidence    
Related Pages (8)