Table Description
Spousal Impoverishment: A benefit provided to a couple when only one spouse resides in a medical institution or in a Home and Community Based Waiver program and the other spouse is in the community.

The purpose of this provision is to allow the community spouse to keep additional resources. The provision protects a person whose husband or wife has become institutionalized from having to deplete all the couple's resources in order for the institutionalized spouse to qualify for Medical Assistance Programs with a Long Term Care component.

The system automatically creates the spousal impoverishment details record for a Long Term Care Medical Assistance product delivery when the product delivery is created for a case that has spousal impoverishment conditions.
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::Income Support Product::Service Layer::entity::Case::ISPSpousalImpoverishment::ISPSpousalImpoverishment
Controlling File: ISProduct\model\Service Layer\entity\Case\ISPSpousalImpoverishment\ISPSpousalImpoverishment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
spousalImpIDkeynoSystem generated unique identifier for the spousal impoverishment.ISP_SPOUSAL_IMP_ID SVR_INT64
concernRoleIDdetailsnoThe concernRoleID of the household member.CONCERN_ROLE_ID SVR_INT64
maxSpousalSharedetails The maximum resource amount, determined at the assessment that the spouse at home may have when eligibility is established.CURAM_AMOUNT SVR_MONEY
minSpousalSharedetails The minimum resource amount, determined at the assessment that the community spouse must have when eligibility is established.CURAM_AMOUNT SVR_MONEY
spousalShareAmtdetails This is calculated as the 50% share of the combined assets of the institutionalized/waiver individual and the community spouse. This is calculated when the individual has been institutionalized and first applied for Medical Assistance coverage. This is a once off determination and is not recalculated.CURAM_AMOUNT SVR_MONEY
totalTransferAmtdetails The value of the assets which the institutionalized/waiver individual must transfer to their community spouse in order to retain coverage under the Long Term Care Medical Assistance Program.CURAM_AMOUNT SVR_MONEY
protPeriodStartDatedetails The protected period is the period of time during which an institutionalized/waiver spouse may exceed the asset limit pending a transfer of assets to the community spouse. The protected period start date is from the date the institutionalized or waiver individual applied for Medical Assistance Coverage.CURAM_DATE SVR_DATE
protPeriodEndDatedetails The protected time ends immediately upon the last required resource transfer, or on the due date of the next regularly scheduled review; whichever is first.CURAM_DATE SVR_DATE
remainingTransferAmtdetails The amount which the institutionalized/waiver individual has yet to transfer to the community spouse in order to retain Medical Assistance with Long Term Care coverage.CURAM_AMOUNT SVR_MONEY
statusdetails Status of the spousal impoverishment within the system current or superseded.ISP_STATUS_CODEISPStatusCodeSVR_STRING<10>
commentsdetails Details related to the spousal impoverishment.COMMENTS SVR_STRING<300>
caseIDdetailsnoSystem generated unique identifier of the product delivery case.CASE_ID SVR_INT64
assessmentDatedetails The date determined by rules within the system on which the asset assessment was made. It is the later of the date the institutionalized individual was first institutionalized or the date of marriage to the current spouse.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
ISPSpousalImpoverishment.caseIDCaseHeader.caseID
ISPSpousalImpoverishment.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
IND__329423879caseID
IND__919967901concernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: spousalImpID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
searchByCasensreadmulti Returns all spousal impoverishment records for a case. 
modifyStatusnsmodifyOPTIMISTIC_LOCKING: no
Modifies the status of a spousal impoverishment record., 
Related Pages (26)