Table Description
Food Stamps Household Expense: An expense incurred by a household member.
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::Sample::Service Layer::Food Stamps Assessment::entity::FS Household Expenses::FSHouseholdExpenses
Controlling File: sample\model\Sample.emx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fsHouseholdExpensesIDkeynoSystem generated unique identifier for the FSHouseholdExpense recordFS_HOUSEHOLD_EXPENSES_ID SVR_INT64
concernRoleIDdetailsnoThe ID of the household member who incurred the expenseCONCERN_ROLE_ID SVR_INT64
expenseCategoryCodedetails The category of the expense e.g. medical, shelter.EXPENSE_CATEGORY_CODEExpenseCategoryCodeSVR_STRING<10>
expenseTypeCodedetails The type of expense incurred by the household member.CODETABLE_CODE SVR_STRING<10>
expenseFrequencyCodedetails The frequency of the expenseFREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
expenseAmountdetails The expense amountCURAM_AMOUNT SVR_MONEY
currMthlyExpenseAmountdetails The monthly expense amountCURAM_AMOUNT SVR_MONEY
serviceSupplierIDdetailsyesThe ID of the supplier of the service for which the household member has incurred the expense.SERVICE_SUPPLIER_ID SVR_INT64
propertyAddressdetails The address of the property at which the expense was incurred. This will not be populated for certain expense types e.g. medical expenses.ADDRESS_STRING SVR_STRING<131072>
statusCodedetails The status code of the FSHouseholdExpenses recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
FSHouseholdExpenses.concernRoleIDConcernRole.concernRoleID
FSHouseholdExpenses.serviceSupplierIDServiceSupplier.concernRoleID
Indices (1)
Index NameAttributes
FSHExpensesIdxserviceSupplierID, concernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fsHouseholdExpensesID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByKeyConcernRoleIDnsread To retrieve all FSHouseholdExpense records for a concern role. This is necessary as there can be multiple FSHouseholdExpense evidence records for each concern role. 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To update the status of the fsHouseholdExpenses record 
Related Pages (13)