Table Description

Utility Expense: A cost incurred by a household for the usage of basic services.

Example

Linda Smith is living in her own home with her dependent child. Linda Smith uses gas to heat her home, which is provided by the local gas company. A case worker creates a Utility Expense record for the household. A case worker creates a Contributor record for Linda Smith as she is paying the gas expense for the household. The Contributor record is associated with the household's Utility 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::Evidence::Service Layer::Entity::Expenses::UtilityExpense::UtilityExpense
Controlling File: Evidence\model\ServiceLayer\entity\Expenses\UtilityExpense\UtilityExpense_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
utilityExpenseAmountdetails 

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

CURAM_AMOUNT SVR_MONEY
utilityExpenseTypedetails 

The type of Utility Expense. Examples include: Cooking Fuel, Electric, etc. This is populated from the 'UtilityExpenseType' code table. The UI field name for this attribute is 'Utility Expense Type'.

EVD_UTILITY_EXPENSE_TYPEUtilityExpenseTypeSVR_STRING<10>
expenseFrequencydetails 

The frequency of the Utility Expense. 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 Utility Expense. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
utilityCaseParticipantRoleIDdetailsno

The Case Participant Role ID of the individual/organization providing the utility. The UI field name for this attribute is 'Utility Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
lieapInddetails 

Indicates if the Energy Assistance Payments for low income households are being received. The UI field name for this attribute is 'Low Income Energy Assistance Payments'.

CURAM_INDICATOR SVR_BOOLEAN
reimbursedAmountdetails 

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

CURAM_AMOUNT SVR_MONEY
reimbursementTypedetails 

The types of reimbursement for this expense. Examples include: Product Provider, Insurance Company, etc. This is populated from the 'ReimbursementType' code table.

EVD_EXPENSE_REIMBURSEMENT_TYPEReimbursementTypeSVR_STRING<10>
startDatedetails 

The date from which the Utility Expense is incurred. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The date until which the Utility Expense is incurred. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
UtilityExpense.utilityCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_1904458683utilityCaseParticipantRoleID
Operations (5)
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 
transferEvidence    
Related Pages (3)