Table Description
Contact Log: A Contact Log is a record of any interaction or meeting that occurs between the case worker and a client.

A Contact Log is any interaction or meeting that occurs between the case worker and a client, which may relate to an investigation case. Contact Logs may occur in many different locations and be conducted face to face or through other media. Each investigation may have one or many Contact Logs which relate to different clients over the case lifecycle.

The details of the meeting or interaction are stored as Notes.

Example

A record of a telephone call between the case worker and a case participant.

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::ContactLog
Controlling File: core\model\Packages\Reference Model\Service Layer\ContactLog\Entity\ContactLog_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contactLogIDkeynoUnique reference number assigned by the system to the contact log record.CONTACT_LOG_ID SVR_INT64
contactLogTypedetails The type of contact made example values would be 'Home Visit' or 'Interview'.CONTACT_LOG_TYPEContactLogTypeSVR_STRING<10>
authordetails The author of this contact log. This will usually be the case worker but might be a clerk who works for the caseworker. The author is recorded as a user.USER_NAME SVR_STRING<64>
createdDateTimedetails The date and time the record of the contact was recorded.CURAM_DATETIME SVR_DATETIME
createdBydetails The user name of the case worker who created this contact log record.USER_NAME SVR_STRING<64>
purposedetails This is the reason the contact was made. Example values would be 'Alleged Victim Contact' or 'Case Planning Entry'. There can be more than 1 purpose entered.CONTACT_LOG_PURPOSE_TAB_LIST SVR_STRING<200>
startDateTimedetails This is the start date and time that the actual contact took place.CURAM_DATETIME SVR_DATETIME
endDateTimedetails This is the date and time that the contact ended. the date will usually be the same but the time element will change.CURAM_DATETIME SVR_DATETIME
methoddetails This is the medium used during the contact. Example values include 'Phone' for a contact made by telephone or 'Face to Face' for a meeting or home visit.CONTACT_LOG_METHODContactLogMethodSVR_STRING<10>
locationdetails This is the physical location where the contact took place. Example values include 'Home' and 'Office'.CONTACT_LOG_LOCATIONContactLogLocationSVR_STRING<10>
locationDescriptiondetails Additional information to describe the location of the contact.CONTACT_LOG_LOCATION_DESCRIPTION SVR_STRING<100>
addendumInddetails This is an indicator to record if there is an addendum to the narrative of this recordCURAM_INDICATOR SVR_BOOLEAN
recordStatusdetails Status of the contact log record. The values are 'Active' or 'Canceled' these are used to support logical deletion of this record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
noteIDdetailsyesThe narrative text associated with a contact log. The narrative will maintain a history of previous text entries for the user to view. This narrative will be added to as the user makes updates.NOTE_ID SVR_INT64
Foreign Keys (4)
ChildParent
ContactLogAttendee.contactLogIDContactLog.contactLogID
ContactLogConcern.contactLogIDContactLog.contactLogID
ContactLogLink.contactLogIDContactLog.contactLogID
ContactLogPurpose.contactLogIDContactLog.contactLogID
Operations (12)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: contactLogID
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Method to create new Contact Log record. 
readread Method to read specified Contact Log details. 
modifymodifyOPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Method to update Contact Log details. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Method to cancel specified Contact Log record. 
validateDetails  Method to validate Contact Log details to be created. 
readStartDateTimensread Method to read start date time details for specified Contact Log. 
searchActiveByLinkIDLinkTypensmultiPRE_DATA_ACCESS: yes
 
@deprecated by searchActiveByLinkIDLinkType1. @deprecated-since V6.0. Method to list active Contact Log details for specified Link id and Link Type. New method returns additional end date time field. SQL
searchContactLogs  @deprecated by searchContactLogs1. @deprecated-since V6.0. Return a list of Contact Logs that match the search criteria. New method returns additional end date time field.  
validateSearchKey  Method to validate contact log search criteria before performing search. 
searchActiveByLinkIDLinkType1nsmultiPRE_DATA_ACCESS: yes
 
Method to list active Contact Log details for specified Link id and Link Type.SQL
searchContactLogs1  Return a list of Contact Logs that match the search criteria. 
getContactLogSearchSQLString  Method to format contact log search SQL string. 
Related Pages (125)
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)
Add Contact Log Attendee (Case_addContactLogAttendee)
Add Contact Participant (Case_addContactLogAttendee1)
Delete Contact (Case_cancelContactLog)
New Contact Log (Case_createContactLog)
New Contact (Case_createContactLog1)
Contact Log (Case_listContactLog)
Contact Log (Case_listContactLog1)
edit Attachment (Case_modifyAttachmentFromList)
Edit Attachment (Case_modifyAttachmentFromList1)
edit Attachment (Case_modifyAttachmentFromView)
Edit Attachment (Case_modifyAttachmentFromView1)
Edit Contact (Case_modifyContactLogFromList)
Edit Contact (Case_modifyContactLogFromView)
Preview Contact Log Details (Case_previewContactLogs)
Preview Contact Log Details (Case_previewContactLogs1)
Preview Contact Log Details (Case_previewContactLogView)
Delete Contact Participant (Case_removeContactLogAttendee)
Search Contacts (Case_searchContactLog)
Search (Case_searchContactLog1)
View Contact (Case_viewContactLog)
View Contact (Case_viewContactLog1)
View Contact Log (Case_viewContactLogTransaction)
Add Contact Attachment (CaseContactLog_addAttachment)
View Contact Narrative (CaseContactLog_viewNarrative)
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)
Contact Log (ICInvestigationSample_listContactLog)
Contact Log (ICInvestigationSample_listContactLog1)
- (Incident_viewIncidentTabDetail)
Incident_viewIncidentTabDetailPreview
Delete Contact Log: (IncidentContactLog_cancelContactLog)
Delete Contact (IncidentContactLog_cancelContactLog1)
New Contact Log: (IncidentContactLog_createContactLog)
New Contact (IncidentContactLog_createContactLog1)
List Contact Logs For Incident (IncidentContactLog_listByIncident)
All Contact (IncidentContactLog_listByIncident1)
Edit Contact Log (IncidentContactLog_modifyContactLogFromList)
Edit Contact (IncidentContactLog_modifyContactLogFromList1)
Edit Contact Log (IncidentContactLog_modifyContactLogFromView)
Edit Contact (IncidentContactLog_modifyContactLogFromView1)
Preview Contact Log Details (IncidentContactLog_previewContactLogs)
Preview Contact Log Details (IncidentContactLog_previewContactLogsView)
Contact Search (IncidentContactLog_searchContactLog)
View Contact Log (IncidentContactLog_viewContactLog)
View Contact: (IncidentContactLog_viewContactLog1)
View Contact Narrative (IncidentContactLog_viewNarrative)
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)
Contact Log (OutcomePlan_listContacts)
Preview Contact Log Details (OutcomePlan_previewContactLogView)
Search (OutcomePlan_searchContactLog)
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)
Contact Logs: (ProviderInvestigation_listContactLog)
Delete Contact Log (ProviderManagement_cancelContactLog)
New Contact Log (ProviderManagement_createIncidentContactLog)
Contact Logs (ProviderManagement_listIncidentContactLogs)
Contact Logs (ProviderManagement_listIncidentContactLogsForPG)
Edit Contact Log (ProviderManagement_modifyContactLogFromList)
Edit Contact Log (ProviderManagement_modifyContactLogFromView)
Edit Attachment (ProviderManagement_modifyIncidentAttachment)
Contact Search (ProviderManagement_searchContactLog)
View Contact Log For Incident: # BEGIN, CR00321084, GA (ProviderManagement_viewContactLog)
View Contact Log For Incident: (ProviderManagement_viewContactLogNarrative)
- (ProviderManagement_viewProviderIncidentTabDetails)
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)