Table Description
Food Stamps Household Benefit: A benefit that a household member is receiving.
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 Benefits::FSHouseholdBenefits
Controlling File: sample\model\Sample.emx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fsHouseholdBenefitsIDkeynoSystem generated unique identifier of the FSHouseholdBenefits record.FS_HOUSEHOLD_BENEFITS_ID SVR_INT64
concernRoleIDdetailsnoThe IDof the household member receiving benefits.CONCERN_ROLE_ID SVR_INT64
benefitTypeCodedetails The benefit type the household member is receiving e.g. SSIBENEFIT_TYPE_CODEBenefitTypeCodeSVR_STRING<10>
benefitClaimNodetails The claim number of the benefit that the household member is receiving.REFERENCE_NUMBER SVR_STRING<20>
statusCodedetails The status of the FSHouseholdBenefits recordRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
FSHouseholdBenefits.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
FSHBenefitsIdxconcernRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fsHouseholdBenefitsID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByKeyConcernRoleIDnsread To retrieve all FSHouseholdBenefit records for a concern role. This is necessary as there can be multiple FSHouseholdBenefit records per concern role. 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
To update the status of a fsHouseholdBenefits record 
Related Pages (6)