Table Description
Food Stamps Household Resource: A resource 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 Resources::FSHouseholdResources
Controlling File: sample\model\Sample.emx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fsHouseholdResourcesIDkeynoSystem generated unique identifier for the FSHouseholdResource record.FS_HOUSEHOLD_RESOURCES_ID SVR_INT64
concernRoleIDdetailsnoThe ID of the household member to who owns the resourceCONCERN_ROLE_ID SVR_INT64
assetTypeCodedetails The type of assetASSET_TYPE_CODEAssetTypeCodeSVR_STRING<10>
totalValuedetails The value of the resourceCURAM_AMOUNT SVR_MONEY
totalOweddetails The amount owed on the resourceCURAM_AMOUNT SVR_MONEY
assetUsagedetails What the resource is used for.ASSET_USAGE_CODEAssetUsageCodeSVR_STRING<10>
dateAquireddetails The date the resource was acquiredCURAM_DATE SVR_DATE
dateDisposeddetails The date the asset was disposed of/transferredCURAM_DATE SVR_DATE
disposalReasonCodedetails The reason for the disposal/transfer of the asset.ASSET_DISPOSAL_REASONAssetDisposalReasonSVR_STRING<10>
amountReceiveddetails The disposal/transfer amount received for the assetCURAM_AMOUNT SVR_MONEY
statusCodedetails The status of the FSHouseholdResources recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FSHouseholdResources.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
FSHResourcesIdxconcernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fsHouseholdResourcesID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByKeyConcernRoleIDnsread Operation to retrieve the FSHouseholdResource records by concern role. This is necessary as there can be multiple FSHouseholdResource evidence records stored per concern role. 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To update the status of a FSHouseholdResources record 
Related Pages (8)