Table Description
Food Stamps Household Income: Income of 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 Income::FSHouseholdIncome
Controlling File: sample\model\Sample.emx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fsHouseholdIncomeIDkeynoSystem generated unique identifier for the FSHouseholdIncome record.FS_HOUSEHOLD_INCOME_ID SVR_INT64
concernRoleIDdetailsnoThe ID of the household member to whom the income refers.CONCERN_ROLE_ID SVR_INT64
incomeTypeCodedetails The type of income e.g. wages/salaries, pensions.INCOME_TYPE_CODEIncomeTypeCodeSVR_STRING<10>
incomeFrequencyCodedetails The frequency at which income is receivedFREQUENCY_CODE_STATICFrequencyCodeSVR_STRING<10>
incomeAmountdetails The amount of income receivedCURAM_AMOUNT SVR_MONEY
currMonthlyAmountdetails The monthly income amount received.CURAM_AMOUNT SVR_MONEY
statusCodedetails The status of the FSHouseholdIncome recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FSHouseholdIncome.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
FSHIncomeIdxfsHouseholdIncomeID, concernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fsHouseholdIncomeID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByKeyConcernRoleIDnsread To retrieve all FSHouseholdIncome records for each concern role. This is necessary as there can be multiple FSHouseholdIncome evidence records for each concern role. 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To update the status of a FSHouseholdIncome record. 
Related Pages (8)