Table Description
Social Enterprise Folder: A type of social enterprise folder which can be used by an organization to manage a group of clients and cases. All other data in relation to the social enterprise folder can be stored on the case header entity.

A social enterprise folder is a case that allows agency workers and multidisciplinary team members to securely share information and work together to ensure that benefits and services are delivered in an integrated manner to achieve a desired outcome for a collection of one or more clients. The social enterprise folder types and the type of multidisciplinary team (either predefined or ad hoc) to be used with the social enterprise folder are defined within the Administration application.

A social enterprise folder is a case type and as such can use some of the existing case entities to store data relating to the social enterprise folder. This entity provides additional fields not captured on the case header entity relating to the social enterprise folder such as the type of social enterprise folder and the outcome when the social enterprise folder is closed.

Example

Linda Smith is a 31 year old single parent. She has a 10 year old son, Robert Smith. Linda Smith is out of work and is having difficulty finding a job, as a result she claims of being stressed and not having enough money to provide for herself and her child. Robert Smith is frequently absent from school and teachers have notified the social welfare agency regarding their concerns over the child's absence and the fact that occasionally they have seen bruises on the child's body. An agency worker makes contact with the family and creates a Child Welfare social enterprise folder adding Linda Smith and Robert Smith as clients. Linda Smith is claiming Child Benefit, Food Stamps and Income Support, these cases are also added to the social enterprise folder (SEF). The multidisciplinary team to be added to the Child Welfare SEF is specified as ad-hoc which means that the multidisciplinary team members are defined when the Child Welfare SEF is created. Robert Smith's teacher, an agency worker and a psychologist are added as multidisciplinary team members to the Child Welfare SEF. The SEF is utilized as a collaborative tool whereby team members can communicate and share information using social enterprise components such as meetings, discussions and incidents.

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::SocialEnterpriseFolderPkg::SocialEnterpriseFolder
Controlling File: SocialEnterpriseCollaboration\model\Packages\SEF\Application\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseIDkeynoUnique reference number assigned by the system to a social enterprise folder record.CASE_ID SVR_INT64
typedetails Type of social enterprise folder. Values include 'Child Welfare', 'Fraud Investigation'.SEF_TYPE_CODESEFTypeSVR_STRING<10>
outcomedetails Textual description of the outcome of the social enterprise folder upon closure .SOCIAL_ENTERPRISE_FOLDER_OUTCOME SVR_STRING<50>
sefAdminIDdetailsyesUnique identifier of the Social Enterprise Folder Administration record the Social Enterprise Folder is related to.INTERNAL_ID SVR_INT64
Foreign Keys (3)
ChildParent
SocialEnterpriseFolder.caseIDCaseHeader.caseID
SocialEnterpriseFolder.sefAdminIDSocialEnterpriseFolderAdmin.sefAdminID
SocialEnterpriseFolderCase.socialEnterpriseFolderIDSocialEnterpriseFolder.caseID
Indices (1)
Index NameAttributes
IND_10846457sefAdminID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByTypeAndStatusnsmulti Retrieves a list of Social Enterprise Folder records based on the key.SQL
searchByClientMDTStatusTypensmulti Retrieves a list of Social Enterprise Folder records based on the key.SQL
readLatestCaseTransactionLogns  SQL
searchByClientAndStatusnsmulti Searches for all active case participant roles that a participant has on a Social Enterprise Folder.SQL
searchBySEFAdminAndStatusnsmulti Retrieves a list of Social Enterprise Folder records based on the key.SQL
Related Pages (140)
Add Attachment (Discussion_addAttachment)
Add Comment (Discussion_addComment)
Add Comment (Discussion_addRichTextComment)
Change Moderator (Discussion_changeModerator)
Close Discussion (Discussion_close)
Delete Discussion (Discussion_delete)
Edit Discussion (Discussion_modify)
Edit Discussion (Discussion_modifyRichText)
Remove Attachment (Discussion_removeAttachment)
Reopen Discussion (Discussion_reopen)
Discussion_viewDiscussion
Add Attachment (DiscussionPost_addAttachment)
Delete Discussion Post (DiscussionPost_delete)
Modify Discussion Post: (DiscussionPost_modify)
Edit Discussion Post (DiscussionPost_modifyRichText)
Remove Attachment (DiscussionPost_removeAttachment)
Discussions (ICInvestigationCase_listDiscussion)
Edit Sharing (MDTCollaboration_editActivitySharing)
Edit Sharing (MDTCollaboration_editSharing)
New Meeting (Meeting_createMeeting)
Create Meeting: (Meeting_createRichTextMeeting)
New Attendees (Meeting_inviteAttendee)
New Attendees (Meeting_inviteAttendeeFromSEF)
Meeting Actions (MeetingActions_modify)
Attendance (MeetingAttendence_modify)
Meeting Cases (MeetingCases_modify)
Meeting Cases (MeetingCases_update)
Related Cases (MeetingCases_view)
Meeting Decisions (MeetingDecisions_modify)
Meeting Decisions (MeetingDecisions_richTextModify)
New Invitation (MeetingDetails_addAttendee)
Edit Attendance (MeetingDetails_editAttendee)
Meeting Minutes (MeetingDetails_listMeetingsForSEF)
Meeting Details (MeetingDetails_modify)
Delete Meeting Minutes (MeetingDetails_remove)
Remove Meeting Attendee (MeetingDetails_removeAttendee)
Details (MeetingDetails_richTextModify)
Meeting Details (MeetingDetails_updateDetailsAndDecisions)
Meeting Minutes: (MeetingDetails_updateNotes)
Edit Meeting Details (MeetingDetails_updateRichTextDetailsAndDecisions)
Edit Notes (MeetingDetails_updateRichTextNotes)
Meeting Minutes: (MeetingDetails_viewAttendance)
Meeting Minutes: (MeetingDetails_viewAttendanceNotFromCase)
Meeting Minutes: (MeetingDetails_viewCases)
Meeting Minutes: (MeetingDetails_viewCasesNotFromCase)
Meeting Files (MeetingMinutes_addAttachmentsFromList)
New Attachment (MeetingMinutes_addAttachmentsFromView)
New Action (MeetingMinutes_createAction)
Edit Action (MeetingMinutes_editActionFromList)
Edit Action (MeetingMinutes_editActionFromListFromAgenda)
Action: (MeetingMinutes_editActionFromView)
Action: (MeetingMinutes_editActionFromViewFromAgenda)
Edit Attendance (MeetingMinutes_editAttendeeFromAgenda)
Issue Meeting Minutes (MeetingMinutes_issueMinutes)
Edit Attachment (MeetingMinutes_modifyAttachmentFromList)
Edit Attachment (MeetingMinutes_modifyAttachmentFromListFromAgenda)
Edit Attachment (MeetingMinutes_modifySingleAttachment)
Delete Attachment (MeetingMinutes_removeAttachment)
Delete Meeting Attachment (MeetingMinutes_removeAttachmentFromListFromAgenda)
Delete Meeting Attendee (MeetingMinutes_removeAttendeeFromAgenda)
Meeting Minutes Summary (MeetingMinutes_viewSummary)
Meeting Notes (MeetingNotes_modify)
Notes (MeetingNotes_richTextModify)
Discussions (OutcomePlan_listDiscussion)
Discussions (ParticipantInvestiagtionCase_listDiscussion)
Discussions (SEF_listDiscussion)
Incident: (SocialEnterpriseFolder_addAffectedClient)
Add Cases (SocialEnterpriseFolder_addCaseMultipleClients)
Add Affected Client: (SocialEnterpriseFolder_addIncidentConcern)
Delete Attachment (SocialEnterpriseFolder_cancelAttachment)
Delete Related SEF (SocialEnterpriseFolder_cancelCaseRelationship)
Delete Note (SocialEnterpriseFolder_cancelNote)
Change Reporter (SocialEnterpriseFolder_changeIncidentReporter)
Close (SocialEnterpriseFolder_close)
SocialEnterpriseFolder_contextPanel
New Social Enterprise Folder (SocialEnterpriseFolder_create)
New Attachment (SocialEnterpriseFolder_createAttachment)
New Related SEF (SocialEnterpriseFolder_createCaseRelationship)
Add Client (SocialEnterpriseFolder_createClient)
Add Client (SocialEnterpriseFolder_createClientFromClientView)
New Discussion (SocialEnterpriseFolder_createDiscussion)
New Email Communication (SocialEnterpriseFolder_createEmailCommunication)
New Incident (SocialEnterpriseFolder_createIncident)
New MS Word Communication (SocialEnterpriseFolder_createMSWordCommunication)
New Note (SocialEnterpriseFolder_createNote)
New Pro Forma Communication (SocialEnterpriseFolder_createProFormaCommunication)
New Discussion (SocialEnterpriseFolder_createRichTextDiscussion)
Create Witness: (SocialEnterpriseFolder_createWitness)
New Social Enterprise Folder (SocialEnterpriseFolder_enhancedCreate)
Calendar (SocialEnterpriseFolder_eventCalendar)
Home (SocialEnterpriseFolder_home)
Attachments (SocialEnterpriseFolder_listAttachment)
SocialEnterpriseFolder_listByOwner
Add Cases (SocialEnterpriseFolder_listCaseAddCaseMultipleClients)
Communications (SocialEnterpriseFolder_listCommunication)
Cases (SocialEnterpriseFolder_listCurrentCases)
Clients (SocialEnterpriseFolder_listCurrentClients)
Discussions (SocialEnterpriseFolder_listDiscussion)
Incidents (SocialEnterpriseFolder_listIncident)
Interactions (SocialEnterpriseFolder_listInteraction)
Notes (SocialEnterpriseFolder_listNote)
Related SEFs (SocialEnterpriseFolder_listRelatedSEF)
Cases (SocialEnterpriseFolder_listRemovedCases)
Clients (SocialEnterpriseFolder_listRemovedClients)
Status History (SocialEnterpriseFolder_listStatusHistory)
User Roles (SocialEnterpriseFolder_listUserRoles)
Add Members To Team (SocialEnterpriseFolder_mdtAddExistingMemberToCase)
Add User To Team (SocialEnterpriseFolder_mdtAddExistingUserToCase)
New Multidisciplinary Team Member (SocialEnterpriseFolder_mdtAddNewMemberToCase)
Multidisciplinary Team (SocialEnterpriseFolder_mdtListActiveMembers)
Modify Social Enterprise Folder: (SocialEnterpriseFolder_modify)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromList)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromView)
New Owner (SocialEnterpriseFolder_modifyCaseOwner)
Edit Related SEF (SocialEnterpriseFolder_modifyCaseRelationshipFromList)
Edit Related SEF (SocialEnterpriseFolder_modifyCaseRelationshipFromView)
New Supervisor (SocialEnterpriseFolder_modifyCaseSupervisor)
Update Reporter (SocialEnterpriseFolder_modifyIncidentReporter)
Edit Note (SocialEnterpriseFolder_modifyNoteFromList)
Edit Note (SocialEnterpriseFolder_modifyNoteFromView)
Multidisciplinary Team (SocialEnterpriseFolder_predefinedMDTListActiveMembers)
Remove Multidisciplinary Team (SocialEnterpriseFolder_predefinedMDTRemove)
Record Communication (SocialEnterpriseFolder_recordCommunication)
Remove Case (SocialEnterpriseFolder_removeCase)
Remove Client (SocialEnterpriseFolder_removeClient)
Reopen (SocialEnterpriseFolder_reopen)
Social Enterprise Folder Search (SocialEnterpriseFolder_searchCasePopup)
Transaction History (SocialEnterpriseFolder_viewAllTransactions)
View Attachment: (SocialEnterpriseFolder_viewAttachment)
View Attachment: (SocialEnterpriseFolder_viewAttachmentTransaction)
View Social Enterprise Folder Relationship (SocialEnterpriseFolder_viewCaseRelationship)
View Discussion: (SocialEnterpriseFolder_viewDiscussionTransaction)
View Email Communication: (SocialEnterpriseFolder_viewDraftEmailCommunication)
View Discussion: (SocialEnterpriseFolder_viewIncidentDiscussion)
MDT Member Sensitivity Details (SocialEnterpriseFolder_viewMDTSensitivityDetails)
Meeting Minutes Summary: (SocialEnterpriseFolder_viewMeetingMinutesTransaction)
View Communication (SocialEnterpriseFolder_viewMSWordCommunication)
View Pro Forma Communication: (SocialEnterpriseFolder_viewProFormaCommunication)
View Communication: (SocialEnterpriseFolder_viewRecordedCommunication)
Delete Social Enterprise Folder (SocialEnterpriseFolderAdministration_cancelSEFType)