Table Description
Discussion: A topic raised for discussion.

A case can include a discussion forum. A discussion forum can contain one or more discussions. This gives agency workers and multidisciplinary team members a forum to discuss any aspect of a case. Discussions can be watched by multiple users, both internal and external. Watching a discussion means that an email will be sent to the watcher when any new posting is made to the discussion. By default, all multidisciplinary team members are automatically added as watchers when a new discussion is created. A discussion is created automatically when an incident is created.

Example

Linda Smith, James Smith and their three children Robert, Lisa and Susan are added to a Child Welfare social enterprise folder so that they can be managed together as a family. Incidents of Child Neglect have been recorded for Robert, Lisa and Susan. A discussion is automatically created on incident creation. A predefined multidisciplinary team is assigned to the social enterprise folder to allow them to assess and manage the families needs. This team consists of a police officer, a doctor and child services agency worker.

This entity stores the detail of the discussion created as a result of incident creation.

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::Discussions::Entity::Discussion
Controlling File: SocialEnterpriseCollaboration\model\Packages\Discussions\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
discussionIDkeynoUnique reference number assigned by the system to a discussion record.DISCUSSION_ID SVR_INT64
subjectdetailsnoDescription or headline summary of the topic being discussed.DISCUSSION_SUBJECT SVR_STRING<200>
recordStatusdetails Status of the discussion record. Values include 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUSRecordStatusSVR_STRING<10>
discussionHeaderPostIDdetailsyesUnique reference number of the initial comment added on discussion creation which is stored as a discussion post. Every discussion has one primary post which is the comment from the discussion creator. POST_ID SVR_INT64
discussionForumIDdetailsnoUnique reference number of the forum to which the discussion belongs.INTERNAL_ID SVR_INT64
sensitivityCodedetailsnoSensitivity level associated with the discussion. A user must have at least an equivalent sensitivity level to view, edit or delete a discussion.SENSITIVITY_CODESensitivitySVR_STRING<10>
Foreign Keys (5)
ChildParent
Discussion.discussionForumIDDiscussionForum.discussionForumID
Discussion.discussionHeaderPostIDDiscussionPost.postID
DiscussionPost.discussionIDDiscussion.discussionID
DiscussionReader.discussionIDDiscussion.discussionID
DiscussionWatcher.discussionIDDiscussion.discussionID
Indices (2)
Index NameAttributes
DiscussionIdxrecordStatus, discussionForumID
IND_451409095discussionHeaderPostID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: discussionID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByStatusreadmulti Search Discussions by status. 
searchByForumreadmulti   
searchByForumAndStatusreadmulti   
Related Pages (10)