Table Description

Liquid Resources: An asset which is cash or can be readily converted to cash. Types of liquid resources include: cash on hand and U.S. Savings bonds.

The owner of a liquid resource may or may not be a Household Member. Ownership of the liquid resource is captured via Ownership evidence. A participant may have resource income associated with the Liquid Resource record. Resource income evidence captures regular payments made from a resource. For example, interest and dividends earned on a liquid resource.

Example

Linda Smith has a checking account from which she can withdraw cash. A case worker creates a Liquid Resource evidence for the value of the checking account and adds Linda Smith as the owner of the liquid resource via Ownership evidence.

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

System generated unique identifier for the Liquid resource.

EVIDENCE_ID SVR_INT64
liquidResourceTypedetails 

The type of the Liquid Resource, e.g. cash, checking account.

EVD_LIQUID_RESOURCE_TYPELiquidResourceTypeSVR_STRING<10>
valuedetails 

The value of the monetary resource.

CURAM_AMOUNT SVR_MONEY
bankAccountIDdetailsyes

Relates this resource to a bank account if one exists.

BANK_ACCOUNT_ID SVR_INT64
commentsdetails 

Details related to the Liquid Resource.

COMMENTS SVR_STRING<300>
intCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the institution e.g. company the shares are held in.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
numberOfSharesdetails 

The number of shares held by the member.

EVD_NUMBER_OF_SHARES SVR_INT32
noOfSavingsCertificateUnitsdetails 

The number of savings certificate units held by the member.

EVD_NUMBER_OF_SAVINGS_CERTIFICATE_UNITS SVR_INT32
savingsCertificateIssueNumberdetails 

The issue number of the savings certificate.

EVD_SAVINGS_CERTIFICATE_ISSUE_NUMBER SVR_INT64
dateReceiveddetails 

The date the Liquid Resource was received.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Liquid Resource.

CURAM_DATE SVR_DATE
amountOweddetails 

The amount owed on a monetary resource.

CURAM_AMOUNT SVR_MONEY
Foreign Keys (2)
ChildParent
LiquidResources.bankAccountIDBankAccount.bankAccountID
LiquidResources.intCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND_74383254bankAccountID
IND_1073372795intCaseParticipantRoleID
Operations (5)
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 
transferEvidence    
Related Pages (63)
Check Eligibility (CheckEligibility)
Check Eligibility (CheckMAEligibility)
Check Eligibility (CheckMAEligibilityFromIC)
Renew Chip Product Delivery (Chip_RenewProductDelivery)
New Ownership Evidence (EVD_addToCaseOwnershipEvidence_sa)
New Ownership Evidence (EVD_addToCaseOwnershipEvidence_wzSelAllCre)
New Transfer Reversal Evidence (EVD_addToCaseTransferReversalEvidence_sa)
New Transfer Reversal Evidence (EVD_addToCaseTransferReversalEvidence_wzSelAllCre)
New Transfer To Individual Evidence (EVD_addToCaseTransferToIndividualEvidence_sa)
New Transfer To Individual Evidence (EVD_addToCaseTransferToIndividualEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePRE)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_wzSelAllCre)
New Resource Income Evidence (EVD_createResourceIncomeEvidence_sa)
New Resource Income Evidence (EVD_createResourceIncomeEvidence_wzSelAllCre)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_sa)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_wzSelAllCre)
New Transfer To Individual Evidence (EVD_createTransferToIndividualEvidence_sa)
New Transfer To Individual Evidence (EVD_createTransferToIndividualEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePRE)
Edit Ownership Evidence (EVD_incomingModifyOwnershipEvidence)
Edit Transfer Reversal Evidence (EVD_incomingModifyTransferReversalEvidence)
Edit Transfer To Individual Evidence (EVD_incomingModifyTransferToIndividualEvidence)
Edit Transfer To Trust Evidence (EVD_incomingModifyTransferToTrustEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Ownership Evidence (EVD_modifyOwnershipEvidence)
Edit Resource Income Evidence (EVD_modifyResourceIncomeEvidence)
Edit Transfer Reversal Evidence (EVD_modifyTransferReversalEvidence)
Edit Transfer To Individual Evidence (EVD_modifyTransferToIndividualEvidence)
Edit Transfer To Trust Evidence (EVD_modifyTransferToTrustEvidence)
View Ownership Evidence (EVD_viewOwnershipEvidence)
View Ownership Evidence (EVD_viewOwnershipEvidenceHistRec)
Home (EVD_viewOwnershipEvidenceObject)
View Ownership Evidence (EVD_viewOwnershipEvidenceSnapshot)
View Transfer To Individual Evidence (EVD_viewTransferToIndividualEvidence)
View Transfer To Individual Evidence (EVD_viewTransferToIndividualEvidenceHistRec)
Home (EVD_viewTransferToIndividualEvidenceObject)
View Transfer To Individual Evidence (EVD_viewTransferToIndividualEvidenceSnapshot)
View Transfer To Trust Evidence (EVD_viewTransferToTrustEvidence)
View Transfer To Trust Evidence (EVD_viewTransferToTrustEvidenceHistRec)
Home (EVD_viewTransferToTrustEvidenceObject)
View Transfer To Trust Evidence (EVD_viewTransferToTrustEvidenceSnapshot)
Related Persons (Intake_listRelatedPerson)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Add Household Member (ISAddMemberWizard_summaryDetails)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromICHome)
Check Retroactive Medical Assistance Eligibility (ISP_checkRetroactiveEligibility_fromPDHome)
Resource Transfer Sanction Details: (ISP_listResourceTransferSanctionEvidence)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibility)
Renew Long Term Care Eligibility (ISP_renewProductDeliveryEligibilityFromMenu)
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Renew TB Product Delivery (TBBCC_RenewProductDelivery)