Table Description

Beneficiary: An individual or an organization who will benefit either solely or partially from a trust.

A beneficiary may or may not be a Household Member.

Example

Susan Smith is Linda Smith's dependent child. Linda Smith has written a will which establishes a trust. The trust was set up to transfer a right of funds to a trustee to be held and used for the benefit of the beneficiary. A case worker creates a Beneficiary record for Susan Smith relating to Linda Smith's trust. Susan Smith is considered the beneficiary of Linda Smith's trust. The relationship between Susan Smith and Linda Smith is recorded on the beneficiary record.

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

System generated unique identifier for the Beneficiary

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Beneficiary. This may or may not be a Household Member

CASE_PARTICIPANT_ROLE_ID SVR_INT64
relGranToBeneficdetails 

Code table value describing the relationship of the grantor to the beneficiary. For example, the grantor could be the beneficiary's parent or guardian

EVD_REL_GRANTOR_TO_BENEFICIARY_TYPERelGrantorToBeneficiarySVR_STRING<10>
accessibleValuedetails 

The portion of the trust that is available to the Beneficiary

CURAM_AMOUNT SVR_MONEY
commentsdetails 

Details related to the Beneficiary record

COMMENTS SVR_STRING<300>
startDatedetails 

The start date of the Beneficiary record

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Beneficiary record

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
Beneficiary.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1716927014caseParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readBeneficiaryByTrustIncomeIDns Reads the BefeficiaryID based on the trust income id.SQL
Related Pages (18)