Table Description
Contact Log Link: The link between a Contact Log and any type of case or participant is recorded here.

When a Contact Log is created it is generally associated with a case or participant. The identifier for the linked entity is stored here along with the Contact Log identifier. This is used to record the link between the two entities.

Example

An Investigation case that includes a Contact Log.
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::Core::Reference Model::Service Layer::ContactLog::Entity::ContactLogLink
Controlling File: core\model\Packages\Reference Model\Service Layer\ContactLog\Entity\ContactLog_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contactLogLinkIDkeynoUnique reference number assigned by the system to the contact log link record.CONTACT_LOG_LINK_ID SVR_INT64
contactLogIDdetailsnoThe contact log to link the other entity to.CONTACT_LOG_ID SVR_INT64
linkIDdetailsnoThe unique identifier for the entity that the contact log is linked to. An example would be the case ID for an investigation case.INTERNAL_ID SVR_INT64
recordStatusdetailsnoStatus of the contact log link record. The values are 'Active' or 'Canceled' these are used to support logical deletion of this record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
linkTypedetails  CONTACT_LOG_LINK_TYPEContactLogLinkTypeSVR_STRING<10>
Foreign Keys (1)
ChildParent
ContactLogLink.contactLogIDContactLog.contactLogID
Indices (2)
Index NameAttributes
ContactLogIDRecordStatusIdxcontactLogID, recordStatus
ContactLogLinkLinkIDIdxlinkID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: contactLogLinkID
PRE_DATA_ACCESS: yes
Method to create new Contact Log Link record. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method to cancel specified Contact Log Link record. 
countActiveByLinkIDLinkTypeNotContactLogIDConcernRoleIDnsPRE_DATA_ACCESS: yes
 		Method to count active Contact Log Link records for specified Link id, Link Type and Attendee Concern Role id which exist for other that specified Contact Log id.SQL
searchActiveByContactLogIDnsmultiPRE_DATA_ACCESS: yes
 		Method to list active Contact Log Link details for specified Link id.SQL
countActiveByLinkIDLinkTypeNotContactLogIDConcernConcernRoleIDnsPRE_DATA_ACCESS: yes
 		Method to count active Contact Log Link records for specified Link id, Link Type and Concern Concern Role id which exist for other that specified Contact Log id.SQL
searchActiveLinkIDAndTypeByContactLogIDnsreadmultiPRE_DATA_ACCESS: yes
Method to list active link id and link type for specified contact log d. 
searchByContactLogIDLinkTypeAndStatusnsreadmulti Lists active Contact Log Link details for specified Contactlog id, linktype and status. 
readread Standard Operation 
Related Pages (84)
Edit Document (Appeal_controlMSWord)
Edit Decision Attachment (Appeal_modifyDecisionAttachment)
Edit Microsoft Word Decision Attachment (Appeal_modifyInternalAttachment)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromList)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromListIC)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromView)
Edit Transcription Request Details (Appeal_modifyTranscriptionFromViewIC)
Match Client (Application_matchClientConfirmation)
Edit Recorded Communication (ApplicationParticipant_modifyRecordedCommunicationFromList)
Edit Attachment Details (ApplicationVerificationApplication_modifyAttachmentDetails)
Edit Attachment (Attachment_modify)
Edit Attachment (CalendarMeetingMinutes_modifyAttachmentFromList)
Delete Contact (Case_cancelContactLog)
New Contact Log (Case_createContactLog)
New Contact (Case_createContactLog1)
edit Attachment (Case_modifyAttachmentFromList)
Edit Attachment (Case_modifyAttachmentFromList1)
edit Attachment (Case_modifyAttachmentFromView)
Edit Attachment (Case_modifyAttachmentFromView1)
Edit Contact (Case_modifyContactLogFromList)
Edit Contact (Case_modifyContactLogFromView)
Delete Contact Participant (Case_removeContactLogAttendee)
Add Contact Attachment (CaseContactLog_addAttachment)
New Contact (CaseContactLogWizard_addAttachments)
New Contact (CaseContactLogWizard_addNarrative)
New Contact Participant (CaseContactLogWizard_addParticipants)
Add Contact Log Attachment (ContactLog_createAttachment)
Add Contact Attachment (ContactLog_createAttachment1)
Edit Educational Institute (EducationalInstitute_modify)
Edit Employer (Employer_modifyEmployer)
Edit Recorded Communication (ExternalParty_modifyRecordedCommunicationFromView)
Edit Recorded Communication (ExternalParty_modifyRecordedCommunicationFromView1)
Opening Microsoft Word Document (HomeStudy_controlMSWord)
Delete Contact Log: (IncidentContactLog_cancelContactLog)
Delete Contact (IncidentContactLog_cancelContactLog1)
New Contact Log: (IncidentContactLog_createContactLog)
New Contact (IncidentContactLog_createContactLog1)
New Contact (IncidentContactLogWizard_addAttachments)
New Contact (IncidentContactLogWizard_addNarrative)
New Contact Participant (IncidentContactLogWizard_addParticipants)
Edit Information Provider (InformationProvider_modifyInformationProvider)
Edit Decision Attachment (LegalAction_modifyDecisionAttachment)
Edit Microsoft Word Decision Attachment (LegalAction_modifyInternalAttachment)
Save Microsoft Word Decision Attachment (LegalAction_saveMSWord)
Edit Attachment (MeetingMinutes_modifyAttachmentFromList)
Edit Attachment (MeetingMinutes_modifyAttachmentFromListFromAgenda)
Edit Attachment (MeetingMinutes_modifySingleAttachment)
Edit Attachment (Participant_modifyAttachmentFromList)
Edit Attachment (Participant_modifyAttachmentFromView)
Edit Email Communication (Participant_modifyDraftEmailCommunication)
Edit Pro Forma Communication (Participant_modifyDraftProFormaCommunication)
Edit Recorded Communication (Participant_modifyRecordedCommunicationFromList)
Edit Recorded Communication (Participant_modifyRecordedCommunicationFromList1)
Edit Recorded Communication (Participant_modifyRecordedCommunicationFromView)
Edit Recorded Communication (Participant_modifyRecordedCommunicationFromView1)
Edit Person (Person_evidenceModify)
Edit Client Details (Person_evidenceModifyClient)
Edit Person (Person_modifyPerson)
Edit Product Provider (ProductProvider_modifyProductProvider)
Delete Contact Log (ProviderManagement_cancelContactLog)
New Contact Log (ProviderManagement_createIncidentContactLog)
Edit Attachment (ProviderManagement_modifyIncidentAttachment)
New Contact (ProviderManagementContactLogWizard_addAttachments)
New Contact (ProviderManagementContactLogWizard_addNarrative)
New Contact (ProviderManagementContactLogWizard_addParticipants)
Edit Representative (Representative_modifyRepresentative)
Edit Representative (Representative_modifyRepresentativeDetails)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
Edit Planned Item Attachment (ServicePlanDelivery_modifyAttachmentFromView)
Edit Contract (ServicePlanDelivery_modifyContractFromList)
Edit Contract (ServicePlanDelivery_modifyContractFromView)
Edit Attachment (ServicePlanDelivery_modifyPlannedItemAttachmentFromList)
Edit Service Supplier (ServiceSupplier_modifyServiceSupplier)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromList)
Edit Attachment (SocialEnterpriseFolder_modifyAttachmentFromView)
Modify File: (SocialEnterpriseFolder_modifyIncidentFileFromList)
Modify File: (SocialEnterpriseFolder_modifyIncidentFileFromView)
Edit Recorded Communication (SocialEnterpriseFolder_modifyRecordedCommunication)
Modify Recorded Communication: (SocialEnterpriseFolder_modifyRecordedCommunicationFromView)
Edit Utility (Utility_modifyUtility)
Edit Attachment Details (VerificationApplication_modifyAttachmentDetails)
Edit Attachment Details: (VerificationApplication_modifyAttachmentDetailsEvidenceDetails)
Edit Attachment Details (VerificationApplication_modifyAttachmentDetailsFromList)