Table Description
Multidisciplinary Team Sharing: Holds the sharing details of a multidisciplinary team member. Defines that sharing is enabled for a team member for a various type of information.

Example

A teacher role exists and a member created with this role applied. The configured sharing setting for the member for attachments is preselected. An investigation case is created that has collaboration enabled. A multidisciplinary team is added that contains the create member with the teacher role. An attachment attempted to be created. In addition to the attachment details the list of multidisciplinary team members are displayed and those configured for sharing are selectable. The member with the teacher role is selected and the attachment is created. The result is a sharing record created storing the identifier of the member, the attachment.
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::MDT::Entity::MultidisciplinaryTeamSharing::MDTSharing
Controlling File: SocialEnterpriseCollaboration\model\Packages\MDT\Entity\MultidisciplinaryTeamSharing.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
AUDIT_FIELDSyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
mdtSharingIDkeynoThe unique identifier for the Multidisciplinary Team SharingINTERNAL_ID SVR_INT64
relatedTypedetailsnoDescribes the type of record this sharing record is related to, for example attachments. Used in conjunction with the related identifier for look up. COLLABORATION_SHARING_TYPECollaborationSharingTypeSVR_STRING<10>
relatedIDdetailsnoThe unique identifier of the type of record this sharing record is related to, for example attachments. Used in conjunction with the related related type for look up.INTERNAL_ID SVR_INT64
recordStatusdetailsnoThe status of the record, i.e. active or cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
caseIDdetailsnoThe unique identifier of the case this record is in relation to.INTERNAL_ID SVR_INT64
memberIDdetailsnoThe unique identifier for the Multidisciplinary Team member this sharing record is in relation to.INTERNAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
MDTSharing.caseIDCaseHeader.caseID
MDTSharing.memberIDMultidisciplinaryTeamMember.multidisciplinaryTeamMemberID
Indices (3)
Index NameAttributes
MDTSharingRelatedIdxrelatedID
IND_86799371caseID
IND_1139433717memberID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: mdtSharingID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByMemberCaseRelatedTypeAndStatusreadmulti Searches for sharing records of a certain type for a member related to a specific case. This operation can be used to get a list of items if a certain type that a member has access to on a case. 
readByMemberCaseSharingRelatedTypeAndStatusnsread Reads the MDT Sharing record by member, recordstatus, relatedID and relatedType. Can be used to determine if a sharing record already exists for a certain item. 
searchActiveByCaseAndRelatedItemreadmulti Searches for active sharing record based on relatedID and relatedType. This operation can be used to list the members that have access to a particular item on a case. 
searchActiveByRelatedItemreadmulti Searches for active sharing record based on caseID, relatedID and relatedType. This operation can be used to list the members that have access to a particular item on a case. 
Related Pages (8)