Table Description

Medical Expense: A cost incurred by a Household Member for medical treatment or care.

Example

Linda Smith is ill and has been prescribed drugs by her medical care provider. A case worker creates a Medical Expense record for Linda Smith with details of the medical expense she must pay.
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::Expenses::MedicalExpense::MedicalExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\MedicalExpenses\MedicalExpenses_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member for whom the Medical Expense was incurred. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
amountdetails 

The amount of the Medical Expense. The UI field name for this attribute is 'Amount'.

CURAM_AMOUNT SVR_MONEY
medicalExpenseTypedetails 

The type of the Medical Expense. Examples include: Cost of Care Expenses, Dental Care, etc. This is populated from the 'ISPMedicalExpenseType' code table. The UI field name for this attribute is 'Medical Expense Type'.

EVD_MEDICAL_EXPENSE_TYPEISPMedicalExpenseTypeSVR_STRING<10>
frequencyCodedetails 

The frequency of the Medical Expense. Examples include: Weekly, Daily, etc. This is populated from the 'ISPMedicalExpFrequency' code table. The UI field name for this attribute is 'Frequency'.

EVD_MEDICAL_EXPENSE_FREQISPMedicalExpFrequencySVR_STRING<10>
writtenOffAmountdetails 

The amount that has been written off by the provider. The UI field name for this attribute is 'Written Off Amount'.

CURAM_AMOUNT SVR_MONEY
lastPaymentDatedetails 

The last date on which the Medical Expense was paid. The UI field name for this attribute is 'Last Payment Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Additional details related to Medical Expense. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
pvdCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the medical expense provider. The UI field name for this attribute is 'Medical Service Provider Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
reimbursedAmountdetails 

The amount which was reimbursed to the Household Member. The UI field name for this attribute is 'Reimbursed Amount'.

CURAM_AMOUNT SVR_MONEY
reimbursementTypedetails 

The type of expense reimbursement. Examples include: Insurance Company, Product Provider, etc. This is populated from the 'ReimbursementType' code table. The UI field name for this attribute is 'Reimbursement Type'.

EVD_EXPENSE_REIMBURSEMENT_TYPEReimbursementTypeSVR_STRING<10>
startDatedetailsyes

The start date of the Medical expense. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The end date of the Medical expense. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
MedicalExpense.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1505841604caseParticipantRoleID
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 (72)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
New Income Allocation Evidence (EVD_addToCaseIncomeAllocationEvidence_wzSelAllCre)
New Income Allocation Evidence (EVD_addToCaseIncomeAllocationEvidence_wzSelAllCrePAR)
New Income Allocation Evidence (EVD_addToCaseIncomeAllocationEvidence_wzSelAllCrePRE)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Income Allocation Evidence (EVD_createIncomeAllocationEvidence_wzSelAllCre)
New Income Allocation Evidence (EVD_createIncomeAllocationEvidence_wzSelAllCrePAR)
New Income Allocation Evidence (EVD_createIncomeAllocationEvidence_wzSelAllCrePRE)
New Spend Down Medical Expense Evidence Details (EVD_createISPSpendDownMedicalExpenseEvidence_fromCreateMedicalExpense)
New Spend Down Medical Expense Evidence Details (EVD_createISPSpendDownMedicalExpenseProductEvidence)
New Medical Expense Evidence Details: (EVD_createMedicalExpenseEvidence)
New Medical Expense Evidence (EVD_createMedicalExpenseEvidence_sa)
New Medical Expense Payment Evidence (EVD_createMedicalExpensePaymentEvidence_sa)
New Medical Expense Payment Evidence (EVD_createMedicalExpensePaymentEvidence_wzSelAllCre)
Edit Income Allocation Evidence (EVD_incomingModifyIncomeAllocationEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Income Allocation Evidence (EVD_modifyIncomeAllocationEvidence)
Modify Spend Down Medical Expense Evidence Details (EVD_modifyISPSpendDownMedicalExpenseProductEvidence)
Edit Medical Expense Evidence (EVD_modifyMedicalExpenseEvidence)
Edit Medical Expense Payment Evidence (EVD_modifyMedicalExpensePaymentEvidence)
View Income Allocation Evidence (EVD_viewIncomeAllocationEvidence)
View Income Allocation Evidence (EVD_viewIncomeAllocationEvidenceHistRec)
Home (EVD_viewIncomeAllocationEvidenceObject)
View Income Allocation Evidence (EVD_viewIncomeAllocationEvidenceSnapshot)
View Spend Down Medical Expense Evidence Details (EVD_viewISPSpendDownMedicalExpenseProductEvidence)
Related Persons (Intake_listRelatedPerson)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Add Household Member (ISAddMemberWizard_summaryDetails)
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 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
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Home (ISPSpendDown_productHome)
Re-add a Member (ISReAddMemberWizard_submit)