Table Description

Resource Transfer: A transfer by a Household Member of an asset that was previously owned but which was never recorded in the system.

Example

Linda Smith transferred a liquid resource two months ago to her mother who is not a member of her household. A case worker creates a Resource Transfer record for Linda Smith detailing the transfer and the uncompensated value for which the resource was transferred for.

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

System generated unique identifier for the Resource Transfer.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Resource Transfer.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
recipientCaseParticipantRoleIDdetailsyes

The Case Participant Role ID for the recipient of the resource from the transfer.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
transferDatedetailsyes

The date that the transfer occurred.

CURAM_DATE SVR_DATE
transferReasondetailsyes

The reason that the transfer was made.

EVD_TRANSFER_REASONTransferReasonSVR_STRING<10>
itemTypedetailsyes

The type of resource item which was transferred.

EVD_RESOURCE_TRANSFER_ITEM_TYPEItem TypeSVR_STRING<10>
fairMarketValuedetailsyes

The fair market value of the resource.

CURAM_AMOUNT SVR_MONEY
uncompensatedValuedetailsyes

The portion of the fair market value which was not compensated by the transfer.

CURAM_AMOUNT SVR_MONEY
amountReceiveddetailsyes

The amount received for the transfer.

CURAM_AMOUNT SVR_MONEY
commentsdetails 

Details related to the Resource Transfer.

COMMENTS SVR_STRING<300>
resourceTypedetailsyes

The resource type.

EVD_RESOURCE_TRANSFER_RESOURCE_TYPEResource TypeSVR_STRING<10>
endDatedetails 

The end date of the Resource Transfer.

CURAM_DATE SVR_DATE
actingOnBehalfInddetails 

Indicates if the resource has been transferred by another individual on behalf of the participant who owns the resource.

CURAM_INDICATOR SVR_BOOLEAN
attemptedToRegainPossessionInddetails 

Indicates if the participant has reasonably tried to regain possession of a resource which has previously been transferred.

CURAM_INDICATOR SVR_BOOLEAN
legalBindDocInPlaceInddetails 

Indicator to show that there is a legally binding document in place for this transfer. The UI field name for this attribute is 'Legally Binding Document in Place'.

CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (2)
ChildParent
ResourceTransfer.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
ResourceTransfer.recipientCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
searchDupRTransIdxcaseParticipantRoleID, itemType, transferDate, recipientCaseParticipantRoleID
Operations (7)
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 
readResourceTransferOwnerDetailsns Reads the primary owner details of the resource transfer.SQL
readCaseParticipantsByEvidenceIDnsread Method to return any case participant Role ID associated with the entity. 
readResourceTransferAndParticipantRoleDetailsns Method for reading resource transfer evidence and the participantRoleID of the recipient of the resource transfer.SQL
Related Pages (13)