Table Description

Assigned Income: A Household Member's income that is attributed to an Income Trust Schedule.

Example

Linda Smith has unearned income which she has agreed to place in an income trust. A case worker creates an Assigned Income record for Linda Smith which is associated with a trust and selects a portion of her unearned income to be assigned to the trust income.

Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Resources::AssignedIncome::AssignedIncome
Controlling File: Evidence\model\ServiceLayer\entity\Resources\AssignedIncome\AssignedIncome_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Assigned Income

EVIDENCE_ID SVR_INT64
linkedIncomeTypedetailsyes

Income type e.g. Benefit, Unearned Income, etc.

EVD_INCOME_ALLOCATION_LINKED_INCOME_TYPEIALinkedIncomeTypeSVR_STRING<10>
linkedIncomeIDdetailsyes

The linkedIncomeID of the Assigned Income

EVIDENCE_ID SVR_INT64
assignedAmountdetailsyes

The amount of income assigned to an Income Trust Schedule

CURAM_AMOUNT SVR_MONEY
startDatedetailsyes

The start date of the income assigned to an Income Trust Schedule

CURAM_DATE SVR_DATE
endDatedetailsyes

The end date for the income assigned to an Income Trust Schedule

CURAM_DATE SVR_DATE
commentsdetailsyes

Details related to the Assigned Income

COMMENTS SVR_STRING<300>
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByLinkedIncomeIDAndLinkedIncomeTypensmulti search AssignedIncome by the linkedIncomeID and the linkedIncomeTypeSQL
Related Pages (25)
New Assigned Income Evidence (EVD_addToCaseAssignedIncomeEvidence_wzSelAllCre)
New Assigned Income Evidence (EVD_addToCaseAssignedIncomeEvidence_wzSelAllCrePAR)
New Assigned Income Evidence (EVD_addToCaseAssignedIncomeEvidence_wzSelAllCrePRE)
New Income Trust Schedule Evidence (EVD_addToCaseIncomeTrustScheduleEvidence_sa)
New Income Trust Schedule Evidence (EVD_addToCaseIncomeTrustScheduleEvidence_wzSelAllCre)
New Assigned Income Evidence (EVD_createAssignedIncomeEvidence_wzSelAllCre)
New Assigned Income Evidence (EVD_createAssignedIncomeEvidence_wzSelAllCrePAR)
New Assigned Income Evidence (EVD_createAssignedIncomeEvidence_wzSelAllCrePRE)
New Income Trust Schedule Evidence (EVD_createIncomeTrustScheduleEvidence_sa)
New Income Trust Schedule Evidence (EVD_createIncomeTrustScheduleEvidence_wzSelAllCre)
Edit Assigned Income Evidence (EVD_incomingModifyAssignedIncomeEvidence)
Edit Income Trust Schedule Evidence (EVD_incomingModifyIncomeTrustScheduleEvidence)
Assign Income from Benefit To Income Trust (EVD_listBenefitEvidenceForAssignedIncomeEvidence)
Assign Income from Gross Receipt To Income Trust (EVD_listGrossReceiptEvidenceForAssignedIncomeEvidence)
Assign Income from Unearned Income To Income Trust (EVD_listUnearnedIncomeEvidenceForAssignedIncomeEvidence)
Edit Assigned Income Evidence (EVD_modifyAssignedIncomeEvidence)
Edit Income Trust Schedule Evidence (EVD_modifyIncomeTrustScheduleEvidence)
View Assigned Income Evidence (EVD_viewAssignedIncomeEvidence)
View Assigned Income Evidence (EVD_viewAssignedIncomeEvidenceHistRec)
Home (EVD_viewAssignedIncomeEvidenceObject)
View Assigned Income Evidence (EVD_viewAssignedIncomeEvidenceSnapshot)
View Income Trust Schedule Evidence (EVD_viewIncomeTrustScheduleEvidence)
View Income Trust Schedule Evidence (EVD_viewIncomeTrustScheduleEvidenceHistRec)
Home (EVD_viewIncomeTrustScheduleEvidenceObject)
View Income Trust Schedule Evidence (EVD_viewIncomeTrustScheduleEvidenceSnapshot)