Table Description

Life Insurance: A type of insurance that pays a benefit upon the death of an insured person.

The owner of a life insurance policy pays premiums to an insurance company that provides insurance for a person, the insured. The insurance company agrees to pay a specified sum to a designated beneficiary upon the death of the insured person. The insured may or may not be a Household Member. The owners of the life insurance policy is captured via Ownership.
For certain programs, a life insurance policy is a resource if it generates a cash surrender value (CSV). A CSV is a form of equity value that it acquires over time. Its value as a resource is the amount of the CSV. Face value is the amount of basic death benefit contracted for at the time the policy is purchased.

Example

John Smith purchases an life insurance policy from an insurance company for Linda Smith. A case worker creates a Life Insurance record with John Smith as the policy owner and Linda Smith as the insured participant. On Linda Smith's death, John Smith will receive the face value of the 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::LifeInsurance::LifeInsurance
Controlling File: Evidence\model\ServiceLayer\entity\Resources\LifeInsurance\LifeInsurance_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Life Insurance.

EVIDENCE_ID SVR_INT64
insCaseParticipantRoleIDdetailsno

The Case Participant Role ID of the insured party for whom the Life Insurance details are being recorded.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
policyNumberdetails 

The policy number of the Life Insurance.

EVD_POLICY_NUMBER SVR_STRING<30>
faceValuedetails 

The face value of the policy.

CURAM_AMOUNT SVR_MONEY
cashValuedetails 

The cash value of the policy.

CURAM_AMOUNT SVR_MONEY
lifeInsuranceDescriptiondetails 

Free text describing any other details of the policy.

EVD_LIFE_INSURANCE_DESCRIPTION SVR_STRING<225>
commentsdetails 

Details related to the Life Insurance.

COMMENTS SVR_STRING<300>
comCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the Life Insurance company.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

Date on which the Life Insurance record commences.

CURAM_DATE SVR_DATE
endDatedetails 

Date on which the Life Insurance record ceases.

CURAM_DATE SVR_DATE
fullyPaidInddetails 

Indicates whether the Life Insurance has been fully paid or not.

CURAM_INDICATOR SVR_BOOLEAN
assignToStateInddetails 

Indicates whether the Life Insurance has been assigned to the State or not.

CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (2)
ChildParent
LifeInsurance.insCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
LifeInsurance.comCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND_1216814727insCaseParticipantRoleID
IND__2087911724comCaseParticipantRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
transferEvidence    
Related Pages (39)
New Transfer To Individual Evidence (EVD_addToCaseTransferToIndividualEvidence_sa)
New Transfer To Individual Evidence (EVD_addToCaseTransferToIndividualEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePRE)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_wzSelAllCre)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_sa)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_wzSelAllCre)
New Transfer To Individual Evidence (EVD_createTransferToIndividualEvidence_sa)
New Transfer To Individual Evidence (EVD_createTransferToIndividualEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePRE)
Edit Transfer To Individual Evidence (EVD_incomingModifyTransferToIndividualEvidence)
Edit Transfer To Trust Evidence (EVD_incomingModifyTransferToTrustEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Life Insurance Evidence (EVD_modifyLifeInsuranceEvidence)
Edit Ownership Evidence (EVD_modifyOwnershipEvidence)
Edit Transfer To Individual Evidence (EVD_modifyTransferToIndividualEvidence)
Edit Transfer To Trust Evidence (EVD_modifyTransferToTrustEvidence)
View Transfer To Individual Evidence (EVD_viewTransferToIndividualEvidence)
View Transfer To Individual Evidence (EVD_viewTransferToIndividualEvidenceHistRec)
Home (EVD_viewTransferToIndividualEvidenceObject)
View Transfer To Individual Evidence (EVD_viewTransferToIndividualEvidenceSnapshot)
View Transfer To Trust Evidence (EVD_viewTransferToTrustEvidence)
View Transfer To Trust Evidence (EVD_viewTransferToTrustEvidenceHistRec)
Home (EVD_viewTransferToTrustEvidenceObject)
View Transfer To Trust Evidence (EVD_viewTransferToTrustEvidenceSnapshot)
Related Persons (Intake_listRelatedPerson)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Add Household Member (ISAddMemberWizard_summaryDetails)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)