Table Description

Trust Income: A regular payment made from a trust to a beneficiary of the trust.

A regular payment includes interest, dividends and royalties earned from a trust or regular income withdrawals from the trust. A beneficiary is an individual or an organization who will benefit either solely or partially from the trust.

Example

Linda Smith has written a will that establishes a revocable trust. Linda Smith is the grantor of the trust. The trust was set up to transfer a right of funds to a trustee to be held and used for the benefit of a beneficiary. The beneficiary is Linda Smith's dependent child Susan Smith. The trust earns interest which is paid monthly as Trust Income to Susan Smith. A caseworker creates a Trust record for Linda Smith detailing the value of the trust. A case worker creates a Beneficiary record for Susan Smith and a Trust Income record for the interest that the trust is earning and is paid to the beneficiary Susan Smith.

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

The system generated unique identifier for the Trust Income.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID for the associated beneficiary.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
trustIncomeTypedetails 

A code table value describing the type of income paid from the trust.

EVD_TRUST_INCOME_TYPETrustIncomeTypeSVR_STRING<10>
amountdetails 

The Trust Income amount being paid.

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency of which the Trust Income amount is to be paid.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
commentsdetails 

Details relating to the Trust Income.

COMMENTS SVR_STRING<300>
startDatedetails 

The start date of the Trust Income.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Trust Income.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
TrustIncome.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_259318806caseParticipantRoleID
Operations (4)
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 
Related Pages (3)