Table Description

Income Trust Schedule: A list of income and the assigned portion that a participant has agreed to place in an Income Trust in order to be income eligible under certain medical programs.

Example

Linda Smith has unearned income which she has agreed to place in an income trust. A case worker creates an Income Trust Schedule record for Linda Smith and assigns a portion of unearned income to it on a monthly basis.

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

System generated unique identifier for the Income Trust Schedule.

EVIDENCE_ID SVR_INT64
bankAccountIDdetailsyes

The bank account for the Income Trust Schedule.

BANK_ACCOUNT_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the grantor - not to be confused with grantorParticipantRoleID.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

The date on which the Income Trust Schedule was established.

CURAM_DATE SVR_DATE
endDatedetails 

The date on which the Income Trust Schedule was terminated.

CURAM_DATE SVR_DATE
commentsdetails 

Details related to the Income Trust Schedule.

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
IncomeTrustSchedule.bankAccountIDBankAccount.bankAccountID
Indices (1)
Index NameAttributes
IND_1740424819bankAccountID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
Related Pages (3)