Table Description
Multidisciplinary Team Member: Holds a list of all the Multidisciplinary Team Members in the system. A Multidisciplinary Team Member is a type of ConcernRole
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::MultidisciplinaryTeamMember::MultidisciplinaryTeamMember
Controlling File: SocialEnterpriseCollaboration\model\Packages\MDT\Entity\MultidisciplinaryTeamMember_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
multidisciplinaryTeamMemberIDkeynoThe unique identifier for the multidisciplinary team member tableMDT_MEMBER_ID SVR_INT64
concernRoleIDdetailsyesForeign key to the concernRole tableCONCERN_ROLE_ID SVR_INT64
primaryAlternateNameIDdetailsyesUnique internal reference number assigned to the primary alternate name for the team member.ALTERNATE_NAME_ID SVR_INT64
typedetailsnoDenotes the type of this member record, i.e. an external member with an external user account or an internal member with an internal user account.MDT_MEMBER_TYPEMDTMemberTypeSVR_STRING<10>
agencydetails The code relating the team member to an agencyMDT_MEMBER_AGENCY_CODEMDTMemberAgencySVR_STRING<10>
roledetailsyesThe role associated with the team member. This has been replaced with mdtMemberRoleID. When a member is created they are now assoicated with a multidisciplinary team member role record.MDT_MEMBER_ROLE_CODEMDTMemberRoleSVR_STRING<10>
recordStatusdetailsnoThe status of the record, i.e. active or cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails General remarks captured about the team memberCOMMENTS SVR_STRING<300>
userNamedetailsnoThe user account username for the team member.SEC_USERNAME SVR_STRING<64>
mdtMemberRoleIDdetailsyesThe unqiue identifier of the multidisciplinary team member role associated with the team member.INTERNAL_ID SVR_INT64
Foreign Keys (7)
ChildParent
MultidisciplinaryTeamMember.primaryAlternateNameIDAlternateName.alternateNameID
MultidisciplinaryTeamMember.concernRoleIDConcernRole.concernRoleID
MultidisciplinaryTeamMember.mdtMemberRoleIDMDTMemberRole.mdtMemberRoleID
CaseTeamLink.leadMemberIDMultidisciplinaryTeamMember.multidisciplinaryTeamMemberID
MDTSharing.memberIDMultidisciplinaryTeamMember.multidisciplinaryTeamMemberID
MultidisciplinaryTeam.leadMemberIDMultidisciplinaryTeamMember.multidisciplinaryTeamMemberID
TeamMembership.multidisciplinaryTeamMemberIDMultidisciplinaryTeamMember.multidisciplinaryTeamMemberID
Indices (4)
Index NameAttributes
MDTMemberUserNameStatusIndexuserName, recordStatus
IND_461317717concernRoleID
IND_1680558124mdtMemberRoleID
IND__274146150primaryAlternateNameID
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: multidisciplinaryTeamMemberID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readAllnkreadmulti Reads all the MDTMembers in the system 
searchConcernRolesByEmailAddressnsmulti Searches for existing concernRoles based on an email addressSQL
readByConcernRoleIDAndStatusnsread Reads a Multidisciplinary Team Member record based on the concernRoleID and record status 
readByUserNameAndStatusnsread Reads the MDT Members details based on a username 
searchByRecordStatusreadmultiORDER_BY: role
Searches for a list of members based on record status 
readByConcernRoleIDnsread Reads a Multidisciplinary Team Member record based on the concernRoleID 
searchUsersByEmailAddressnsmulti Searches for users based on email address. @param key Email address. @return Users that have the email address. SQL
searchByMemberRoleAndRecordStatusreadmultiORDER_BY: role
Searches for a list of members based on the given mdt member role identifier and record status  
Related Pages (34)
New Attendees (Meeting_inviteAttendee)
New Attendees (Meeting_inviteAttendeeFromSEF)
Attendance (MeetingAttendence_modify)
New Invitation (MeetingDetails_addAttendee)
Meeting Details (MeetingDetails_modify)
Details (MeetingDetails_richTextModify)
Meeting Details (MeetingDetails_updateDetailsAndDecisions)
Edit Meeting Details (MeetingDetails_updateRichTextDetailsAndDecisions)
Add Existing Members (MultidisciplinaryTeam_addExistingMember)
Add User To Team (MultidisciplinaryTeam_addExistingUser)
MultidisciplinaryTeamMember_list
Edit Multidisciplinary Team Member (MultidisciplinaryTeamMember_modifyFromAdministrationList)
Edit Multidisciplinary Team Member (MultidisciplinaryTeamMember_modifyFromList)
Edit Multidisciplinary Team Member (MultidisciplinaryTeamMember_modifyFromView)
Multidisciplinary Teams (MultidisciplinaryTeamMember_viewExternalDetails)
Multidisciplinary Teams (MultidisciplinaryTeamMember_viewInternalDetails)
Delete Role (MultidisciplinaryTeamMemberRole_delete)
Change Reporter (SocialEnterpriseFolder_changeIncidentReporter)
Close Incident (SocialEnterpriseFolder_closeIncident)
New Incident (SocialEnterpriseFolder_createIncident)
Create Witness: (SocialEnterpriseFolder_createWitness)
Witnesses: (SocialEnterpriseFolder_listWitness)
Add Members To Team (SocialEnterpriseFolder_mdtAddExistingMemberToCase)
Add User To Team (SocialEnterpriseFolder_mdtAddExistingUserToCase)
Modify Incident: (SocialEnterpriseFolder_modifyIncidentFromList)
Modify Incident: (SocialEnterpriseFolder_modifyIncidentFromView)
Update Reporter (SocialEnterpriseFolder_modifyIncidentReporter)
Modify Witness: (SocialEnterpriseFolder_modifyWitness)
Delete Witness: (SocialEnterpriseFolder_removeWitness)
Incident: (SocialEnterpriseFolder_viewIncident)
Incident: (SocialEnterpriseFolder_viewIncidentTransaction)
User Details (SocialEnterpriseFolder_viewUserDetails)
User Details: (SocialEnterpriseFolder_viewUserDetailsForMinutes)
Witness: (SocialEnterpriseFolder_viewWitness)