Table Description

Spousal Cooperation: This evidence captures details about a community spouse's willingness to cooperate with an institutionalized Household Member.

A Spousal Cooperation record is specifically recorded for a Household Member seeking coverage for Long Term Care Medical Assistance.

An institutionalized Household Member is a person who is in long-term care or receiving waiverable home or community-based services for a continuous period. A community spouse is the spouse of the institutionalized person. A community spouse may refuse to cooperate in making resources or resource information available.

Example

A case worker creates a Spousal Cooperation record for Linda Smith. Linda Smith is an institutionalized Household Member. Linda Smith is separated from her spouse John Smith. Linda and John Smith have joint assets but John Smith is refusing to cooperate with Linda Smith. Linda Smith does not have access to the joint assets so has assigned the rights to the State to pursue John Smith for the assets.

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::Household::SpousalCooperation::SpousalCooperation
Controlling File: Evidence\model\ServiceLayer\entity\Household\SpousalCooperation\SpousalCooperation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Spousal Cooperation. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The case participant role ID of the institutionalized Household Member. The UI field Name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
refuseToCooperateInddetailsyes

Indicates whether or not the community spouse is cooperating with the institutionalized individual, by giving access to assessed resources. The UI field Name for this attribute is 'Spouse Refuse to Co-Operate.

CURAM_INDICATOR SVR_BOOLEAN
spsCaseParticipantRoleIDdetailsyes

The case participant role ID of the community spouse involved in the Spousal Cooperation record. The UI field Name for this attribute is 'Spouse'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
nonComplianceReasondetails 

The non compliance reason. Examples include: Separated, Not in Contact, etc. This is populated from the 'SCNonComplianceReason' code table. The UI field Name for this attribute is 'Non-Compliance Reason'.

EVD_SC_NON_COMPLIANCE_REASONSCNonComplianceReasonSVR_STRING<10>
assignRightsInddetailsyes

Indicates whether or not the individual has assigned rights to the State to pursue the Community Spouse for withheld resources. The UI field Name for this attribute is 'Assign Rights'.

CURAM_INDICATOR SVR_BOOLEAN
startDatedetailsyes

The start date of the Spousal Cooperation. The UI field Name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Spousal Cooperation. The UI field Name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Additional details related to the Spousal Cooperation. The UI field Name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
SpousalCooperation.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
SpousalCooperation.spsCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND__899240843caseParticipantRoleID
IND_544527229spsCaseParticipantRoleID
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 (2)