Table Description

Annuity: A long-term, interest-paying contract offered through an insurance company or financial institution.

An annuity can be 'long-term' as a means of accumulating income while deferring taxes, or it can be 'immediate' meaning it pays the purchaser income now at fixed or variable interest rates as long as the purchaser is living. The income from an annuity may be paid to the purchaser, or to any named annuitants. The purchaser is the individual who establishes the annuity. An annuitant is an individual or an organization who will benefit either solely or partially from the annuity.

Example

Linda Smith purchases an annuity which pays her income immediately from her local bank. A case worker creates an Annuity record and records Linda Smith as having ownership of the annuity. The Annuity contains the banks details and that Linda Smith is considered the annuitant as she used her funds to set it up by purchasing the annuity.

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

System generated unique identifier for the Annuity

EVIDENCE_ID SVR_INT64
instCaseParticipantRoleIDdetailsyes

The Case Participant Role ID for the institution

CASE_PARTICIPANT_ROLE_ID SVR_INT64
annuityTypedetailsyes

The Annuity type

EVD_ANNUITY_TYPEAnnuityTypeSVR_STRING<10>
sourceOfFunddetailsyes

The source of the Annuity

EVD_SOURCE_OF_FUNDAnnuitySourceOfFundSVR_STRING<10>
annuityValuedetailsyes

The value of an Annuity

CURAM_AMOUNT SVR_MONEY
annuityCategorydetailsyes

The annuity category

EVD_ANNUITY_CATEGORYAnnuityCategorySVR_STRING<10>
recoupmentByStateInddetails 

An indication of whether the State is able to recoup the trust or not

CURAM_INDICATOR SVR_BOOLEAN
institutionTypedetailsyes

The institution type

EVD_ANNUITY_INSTITUTION_TYPEAnnuityInstitutionTypeSVR_STRING<10>
commentsdetails 

Details related to the Annuity

COMMENTS SVR_STRING<300>
endDatedetails 

The end date of the Annuity

CURAM_DATE SVR_DATE
dateEstablisheddetailsyes

The establishment date of the Annuity

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
Annuity.instCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1981782391instCaseParticipantRoleID
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 (52)
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 Annuity Beneficiary Evidence (EVD_createAnnuityBeneficiaryEvidence_sa)
New Annuity Beneficiary Evidence (EVD_createAnnuityBeneficiaryEvidence_wzSelAllCre)
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 Annuity Beneficiary Evidence (EVD_modifyAnnuityBeneficiaryEvidence)
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)