Table Description

Living Expense: A living cost incurred by a household.

Example

Linda Smith must purchase food on a weekly basis for her household. A case worker creates a Living Expense record with details of the expense and the amount.

Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Expenses::LivingExpense::LivingExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\LivingExpenses\LivingExpenses_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
livingExpenseTypedetails 

The type of Living Expense incurred. Examples include: Food, Clothing, etc. This is populated from the 'LivingExpenseType' code table. The UI field name for this attribute is 'Living Expense Type'.

EVD_LIVING_EXPENSE_TYPELivingExpenseTypeSVR_STRING<10>
amountdetails 

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

CURAM_AMOUNT SVR_MONEY
frequencyCodedetails 

The frequency of the Living Expense payments. Examples include: Weekly, Monthly, etc. This is populated from the 'FrequencyCode' code table. The UI field name for this attribute is 'Frequency'.

FREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
commentsdetails 

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

COMMENTS SVR_STRING<300>
startDatedetails 

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

CURAM_DATE SVR_DATE
endDatedetails 

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

CURAM_DATE SVR_DATE
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Creates a new living expense evidence record. 
readread Reads for the details of a living expense evidence record. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Updates the details for a living expense evidence record. 
removeremove Logically deletes the Living Expense Evidence record. This method is not needed and not used when the evidence forms part of an evidence tree. 
transferEvidence    
Related Pages (5)