Table Description

Loan: A loan is a sum of money lent on the condition of being repaid within agreed terms.

Types of loans include: educational loans, promissory notes, and bank loans.
The owner of the loan may or may not be a Household Member. Ownership of the loan is captured via Ownership evidence.

Example

Linda Smith has a loan of type educational loan. A case worker creates a Loan record and captures the repayment terms and adds Linda Smith as the owner of the Loan via Ownership evidence.

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

System generated unique identifier for the Loan.

EVIDENCE_ID SVR_INT64
intCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the institution e.g. the bank which provides the Loan.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
amountOweddetails 

The amount owed on the Loan.

CURAM_AMOUNT SVR_MONEY
loanTypedetails 

The type of the Loan, e.g. educational, promissory note.

EVD_LOAN_TYPELoanTypeSVR_STRING<10>
valuedetails 

The value of the Loan.

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 Loan.

COMMENTS SVR_STRING<300>
dateReceiveddetails 

The date the Loan was received.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Loan.

CURAM_DATE SVR_DATE
repaymentAmountdetails 

The monetary value of the Loan/note repayment amount.

CURAM_AMOUNT SVR_MONEY
termAssuranceInddetails 

Indicator to show whether or not the balance of the Loan/note is cleared on death of the participant.

CURAM_INDICATOR SVR_BOOLEAN
repaymentFrequencydetails 

Drop-down list containing the frequency types, for example: monthly.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
repaymentStartDatedetails 

The date on which the Loan / Note Repayment begins.

CURAM_DATE SVR_DATE
repaymentEndDatedetails 

The date on which the Loan / Note Repayment ends.

CURAM_DATE SVR_DATE
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 (49)
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 Ownership Evidence (EVD_createOwnershipEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_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 Ownership Evidence (EVD_modifyOwnershipEvidence)
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)
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)
Renew TB Product Delivery (TBBCC_RenewProductDelivery)