Table Description

Spend Down Medical Expense: The obligated amount that a Household Member should pay for a medical expense incurred. The medical expense could be for a service received by the Household Member, or for a non-member, provided that the Household Member has the responsibility to pay for his/her expense.

Spend Down is a Medical Assistance term which refers to the payment that a Household Member has to make in order to meet the eligibility criteria for Medical Assistance. This is only applicable for households where income is above the threshold for the State's designated medically needy criteria, but are below this threshold when medical expenses are factored in. An individual can meet the Spend Down amount by submitting allowed medical expenses to reduce/meet the Spend Down amount.

Example

Linda Smith has a child, Susan Smith. Susan Smith is ill and has received medical treatment for her condition. A Medical Expense is incurred for the care the hospital provided while she was ill. As Susan Smith is a child her mother, Linda Smith is responsible for paying the expense. A case worker creates a Medical Expense record for Linda Smith with details of the hospital Susan Smith attended and the care Susan Smith received. Linda Smith is only obligated to pay a portion of the Medical Expense. A case worker creates a Spend Down Medical Expense with details of the obligated amount and Susan Smith as she is the person in receipt of the medical services. The Spend Down Medical Expense record is associated with the corresponding Medical Expense.

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::SpendDown::ISPSpendDownMedicalExpense::ISPSpendDownMedicalExpense
Controlling File: ISProduct\model\Service Layer\entity\SpendDown\ISPSpendDownMedicalExpense\ISPSpendDownMedicalExpense_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Spend Down Medical Expense. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
obligationAmountdetails 

The amount of the medical expense, for which the client has the responsibility (obligation) to pay. The UI field name for this attribute is 'Client Obligated Amount'.

CURAM_AMOUNT SVR_MONEY
commentsdetails 

Additional details related to medical expenses. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
medicalExpenseIDdetails 

Unique reference number of the Medical Expense record, to which this Spend Down Medical Expense record relates. There is no UI field for this attribute.

EVD_MEDICAL_EXPENSE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the participant who is in receipt of a medical service for which a medical expense was incurred. This may or may not be a Household Member. The UI field name for this attribute is 'Person in Receipt of Service Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
livingAtHomeInddetails 

Indicates if the person receiving the medical service lives at home with the participant who is responsible for payment of the medical expense. The UI field name for this attribute is 'Living at Home

CURAM_INDICATOR SVR_BOOLEAN
tplInddetails 

Indicates if there is a TPL (Third Party Liability) associated with this expense. Based on this the case worker can follow up with TPL regarding the client's actual obligation on an expense, if unclear. The UI field name for this attribute is 'TPL'.

CURAM_INDICATOR SVR_BOOLEAN
hmoInddetails 

Indicates if there is a HMO (Health maintenance organizations) associated with this expense, necessary for classification of expense, and for automatic determination if the expense can be used. The UI field name for this attribute is 'HMO'.

CURAM_INDICATOR SVR_BOOLEAN
medNecessaryInddetails 

Indicates whether an expense is medically necessary or not. Necessary for automatic classification, and filtering of expenses, it's always defined by a case worker on entry or modification of an expense. The UI field name for this attribute is 'Medically Necessary'.

CURAM_INDICATOR SVR_BOOLEAN
stateProvidedInddetails 

Indicates if an expense is covered by the State or not. The UI field name for this attribute is 'State Provided'.

CURAM_INDICATOR SVR_BOOLEAN
medAssistCovInddetails 

Indicates if an expense is covered by Medicaid or not. The UI field name for this attribute is 'Covered By Medical Assistance'.

CURAM_INDICATOR SVR_BOOLEAN
classifTypedetails 

The type of expense. Examples include: Deductible, Incurred, etc. This is populated from the 'ISPSdMedExpClassifictn' code table. The UI field name for this attribute is 'Expense Classification'.

ISP_SPENDDOWN_MED_EXP_CLASS_TYPE_CODEISPSdMedExpClassifictnSVR_STRING<10>
holdInddetails 

Indicates if the client has requested to hold an expense from use towards Spend Down, until further notification. The UI field name for this attribute is 'Hold'.

CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (2)
ChildParent
ISPSpendDownMedicalExpense.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
ISPSpendDownMedicalExpenseLink.spenddownMedicalExpenseIDISPSpendDownMedicalExpense.evidenceID
Indices (1)
Index NameAttributes
IND_541842070caseParticipantRoleID
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 (44)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
New Spend Down Medical Expense Evidence Details (EVD_createISPSpendDownMedicalExpenseEvidence_fromCreateMedicalExpense)
New Spend Down Medical Expense Evidence Details (EVD_createISPSpendDownMedicalExpenseProductEvidence)
Modify Spend Down Medical Expense Evidence Details (EVD_modifyISPSpendDownMedicalExpenseProductEvidence)
View Spend Down Medical Expense Evidence Details (EVD_viewISPSpendDownMedicalExpenseProductEvidence)
New Spend Down Medical Expense Evidence (ISP_addToCaseISPSpendDownMedicalExpenseProductEvidence_sa)
New Spend Down Medical Expense Evidence (ISP_addToCaseISPSpendDownMedicalExpenseProductEvidence_wzSelAllCre)
Assign Expenses (ISP_applyFromExistingMedicalExpense)
Assign Existing Spend Down Evidence Errors (ISP_applyFromExistingSpendDownEvidenceError)
Assign Existing Spend Down Evidence Warning (ISP_applyFromExistingSpendDownEvidenceMedExpWarning)
Assign Existing Spend Down Evidence Warning (ISP_applyFromExistingSpendDownEvidencePayInWarning)
Assign New Expense (ISP_applyFromNewMedicalExpense)
Apply To Period (ISP_ApplyToPeriod)
Approve Spend Down Period Errors (ISP_applyTowardsSpendDownError)
New Spend Down Medical Expense Evidence (ISP_createISPSpendDownMedicalExpenseProductEvidence_sa)
New Spend Down Medical Expense Evidence (ISP_createISPSpendDownMedicalExpenseProductEvidence_wzSelAllCre)
Edit Spend Down Medical Expense Evidence (ISP_incomingModifyISPSpendDownMedicalExpenseProductEvidence)
ISP_listAssignedExpenses
ISP_listAssignedPayIns
Spend Down Periods (ISP_listCurrentSpendDown)
Unassign Expenses (ISP_listExpensesForUnassign)
ISP_listReadOnlyAssignedExpenses
ISP_listReadOnlyAssignedPayIns
Edit Assigned Expense (ISP_modifyAppliedExpense)
Edit Spend Down Medical Expense Evidence (ISP_modifyISPSpendDownMedicalExpenseProductEvidence)
Unassign Expense (ISP_noAssignedMedicalExpense)
Unassign Expense (ISP_undoAppliedMedicalExpense)
Unassign Pay In (ISP_undoAppliedPayIn)
Confirm Undo Apply To Spend Down Period (ISP_undoApplyToPeriodConfirmation)
Unassign All (ISP_undoApplyTowardsSpendDown)
Assign Expenses (ISP_viewAppliedMedicalExpensesForSpendDown)
View Spend Down Medical Expense Evidence (ISP_viewISPSpendDownMedicalExpenseProductEvidence)
View Spend Down Medical Expense Evidence (ISP_viewISPSpendDownMedicalExpenseProductEvidenceHistRec)
Home (ISP_viewISPSpendDownMedicalExpenseProductEvidenceObject)
View Spend Down Medical Expense Evidence (ISP_viewISPSpendDownMedicalExpenseProductEvidenceSnapshot)
View Assigned Expense (ISP_viewISPSpendDownMedicalExpenseSpendDownEvidence)
Spend Down Details (ISP_viewReadOnlySpendDownDetails)
ISP_viewReadOnlySpendDownDetails1
Spend Down Details (ISP_viewSpendDownDetails)
ISP_viewSpendDownDetails1
Home (ISPSpendDown_productHome)