Table Description
Social Enterprise Folder Case: A case which is added to a social enterprise folder.

A case can be associated with one or more social enterprise folders and a social enterprise folder can have one or more cases added to it. This entity is focused on the details of the cases added to a social enterprise folder and removed from a social enterprise folder. The agency worker is allowed to add cases for any of the social enterprise folder clients and remove cases for these clients. The cases may be managed by Curam or by an external system.

Example

An agency worker creates a Child Welfare social enterprise folder for single parent, Linda Smith and her son Robert Smith, 10. Linda Smith is claiming Child Benefit, Food Stamps and Income Support. These benefits are represented as cases within the agency and are added to the social enterprise folder as they are relevant to the Child Welfare social enterprise folder.

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::SocialEnterpriseCollaboration::SEF::Application::Entity::SocialEnterpriseFolderCasePkg::SocialEnterpriseFolderCase
Controlling File: SocialEnterpriseCollaboration\model\Packages\SEF\Application\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
sefCaseMemberIDkeynoUnique reference number assigned by the system to a social enterprise folder case record.SOCIAL_ENTERPRISE_FOLDER_CASE_MEMBER_ID SVR_INT64
socialEnterpriseFolderIDdetailsyesUnique reference number of a social enterprise folder with which the added case is associated.CASE_ID SVR_INT64
startDatedetails Date that the case was added to a social enterprise folder.CURAM_DATE SVR_DATE
endDatedetails Date that the case was removed from a social enterprise folder.CURAM_DATE SVR_DATE
recordStatusdetails Status of the social enterprise folder case record. Values include 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUSRecordStatusSVR_STRING<10>
caseIDdetailsyesUnique reference number of the added case with which a social enterprise folder is associated.CASEID_STRING SVR_STRING<50>
Foreign Keys (1)
ChildParent
SocialEnterpriseFolderCase.socialEnterpriseFolderIDSocialEnterpriseFolder.caseID
Indices (1)
Index NameAttributes
SEFCaseIdxsocialEnterpriseFolderID, caseID, recordStatus
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: sefCaseMemberID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchBySocialEnterpriseFolderAndStatusreadmulti Returns Social Enterprise Folder Case records by status (Current Case Members) for a Social Enterprise Folder. 
searchByCaseIDAndStatusreadmulti Returns a list of all Social Enterprise Folder Case records for a case, i.e. all the instances where a case is a 'member' of a Social Enterprise Folder. 
searchBySocialEnterpriseFolderreadmulti Returns all Social Enterprise Folder Case records for a Social Enterprise Folder i,e. all the 'case members'. 
searchPotentialCasesByParticipantIDnsmulti Returns all cases that a participant has a case participant role (case participant roles other than those on Social Enterprise Folders) and excluding those that have already been added to this Social Enterprise Folder.SQL
readByCaseSocialEnterpriseFolderAndStatusnsread   
Related Pages (8)