Table Description

Meal Group Member: This evidence captures the details of each individual who is a member of a Household Meal Group.

Household Members must be part of the same Household Meal Group to be considered to purchase and prepare meals together.
A Household Meal Group Member record must be associated with a Household Meal Group record.

Example

A case worker creates a Meal Group Member record for Linda and John Smith for the same Meal Group. Linda and John Smith are spouses who purchase and prepare their meals together in the same household.
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::Household::HholdMealsGroupMember::MealGroupMember
Controlling File: Evidence\model\ServiceLayer\entity\Household\HholdMealsGroupMember\HholdMealsGroupMember_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier of the Household Meal Group member. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

The date on which the Household Member became a part of the Household Meal Group. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The last date until which the Household Member was a part of the Household Meal Group. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
commentsdetails 

Additional details related to the Household Meal Group Members. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
MealGroupMember.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_302307947caseParticipantRoleID
Operations (4)
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 
Related Pages (4)