Table Description

Burial Plan: An agreement between a funeral home or an insurance company and a participant to provide funeral services and merchandise at the time of the Household Member's death.

A participant may or may not be a Household Member. The actual cost of the burial, when the participant dies, may be a lump sum payment or paid in installments. This is the face value of the burial plan. The cash value is the monetary value the participant receives if the burial plan is cancelled.

Example

Linda Smith has purchased a burial plan with a funeral home to provide funeral services upon her death. A case worker creates a Burial Plan record for Linda Smith which details the agreement between Linda Smith and the funeral home.

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::BurialPlan::BurialPlan
Controlling File: Evidence\model\ServiceLayer\entity\Resources\BurialPlan\BurialPlan_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Burial Plan

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Cole ID of the Burial Plan

CASE_PARTICIPANT_ROLE_ID SVR_INT64
cashValuedetails 

The cash value of the Burial Plan

CURAM_AMOUNT SVR_MONEY
faceValuedetails 

The fair market value of the Burial Plan

CURAM_AMOUNT SVR_MONEY
descriptiondetails 

Textual description of the Burial Plan

EVD_BURIAL_PLAN_DESCRIPTION SVR_STRING<225>
commentsdetails 

Details related to the Burial Plan

COMMENTS SVR_STRING<300>
funCaseParticipantRoleIDdetailsyes

The Case Participant Role ID for the funeral home

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

The start date of the Burial plan

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Burial plan

CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
BurialPlan.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
BurialPlan.funCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND__1317803341caseParticipantRoleID
IND__455467946funCaseParticipantRoleID
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 
readCaseParticipantsByEvidenceIDnsread Method to return any case participant Role ID associated with the entity. 
Related Pages (13)