Table Description
Client Diary: This entity stores details of actions, services, referrals and activities recorded for a client.

Any time an action, service, referral or activity is created for a client, an event is raised and a record is stored on this entity to make it easier to access all activities a client is associated with.

Example

James Smith was assessed for substance abuse issues and as a result the case worker scheduled 10 sessions of counseling from 01/01/2011 to 02/15/2011 provided by Dr. John Kelly. A record of this service is stored on this entity as well as the service entity.

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::ClientDiary::Entity::ClientDiary
Controlling File: core\model\Packages\Reference Model\Service Layer\ClientDiary\Entity\ClientDiary.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
clientDiaryIDkeynoThe unique identifier of the client diary record.INTERNAL_ID SVR_INT64
concernRoleIDdetailsnoThe unique identifer of the client this record refers to.CONCERN_ROLE_ID SVR_INT64
relatedIDdetailsnoThe unique identifier of the Action, Service, Referral or Activity this record refers to.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of the related record. This can be one of Action, Service, Referral or Activity.CLIENT_DIARY_RELATED_TYPEClientDiaryRelatedTypeSVR_STRING<10>
startDatedetailsnoThe start date of the client diary record.CURAM_DATE SVR_DATE
endDatedetailsyesThe end date of the client diary record.CURAM_DATE SVR_DATE
recordStatusdetailsnoThe status of the client diary record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ClientDiary.concernRoleIDConcernRole.concernRoleID
Indices (4)
Index NameAttributes
ClientDiaryCRoleDateRangeIdxconcernRoleID, startDate, endDate, recordStatus
ClientDiaryCRoleRelIDTypeIdxconcernRoleID, relatedID, relatedType, recordStatus
ClientDiaryCRoleStartDateIdxconcernRoleID, startDate, recordStatus
CDRelIDTypeStIdxrelatedID, relatedType, recordStatus
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: clientDiaryID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByConcernRoleRelatedIDTypeAndStatusreadmultiORDER_BY: startDate
Returns a list of Client Diary records with the given concern role ID, related ID, related type and status. The list is ordered by start date. 
searchByConcernRoleDateRangeAndStatusreadmultiORDER_BY: startDate
WHERE: concernRoleID = :concernRoleID AND recordStatus = :recordStatus AND ( startDate <= :endDate AND (endDate >= :startDate OR endDate IS NULL) )
Returns a list of Client Diary records with the given concern role ID, date range and status. The list is ordered by start date. Both start and end date should contain a valid date. 
searchByConcernRoleStartDateAndStatusreadmultiORDER_BY: startDate
WHERE: concernRoleID = :concernRoleID AND recordStatus = :recordStatus AND ( startDate >= :startDate OR endDate IS NULL )
Returns a list of Client Diary records with the given concern role ID, start date and status. The list is ordered by start date. 
searchByRelatedIDTypeAndStatusreadmulti Returns a list of Client Diary records with the given related ID, related type and status. 
Related Pages (118)
Accept Invitation (Activity_acceptRecurringInvitation)
Accept Invitation (Activity_acceptStandardInvitation)
Remove Attendee (Activity_cancelInvitationFromRecurringActivity)
Remove Attendee (Activity_cancelInvitationFromStandardActivity)
New Recurring Activity (Activity_createRecurringActivityForUser)
New Recurring Activity (Activity_createRecurringUserActivity)
New Activity (Activity_createStandardUserActivity)
Invite Attendee (Activity_inviteAttendeeToRecurringActivityFromCreate)
Invite Attendee (Activity_inviteAttendeeToRecurringActivityFromView)
Invite Attendee (Activity_inviteAttendeeToStandardActivityFromCreate)
Invite Attendee (Activity_inviteAttendeeToStandardActivityFromView)
Edit Recurring Activity (Activity_modifyRecurringUserActivity)
Edit Recurring Activity (Activity_modifyRecurringUserActivity1)
Edit Activity (Activity_modifyStandardUserActivity)
Edit Activity (Activity_modifyStandardUserActivity1)
Reject Invitation (Activity_rejectRecurringInvitation)
Reject Invitation (Activity_rejectStandardInvitation)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Hearing Review (Appeal_confirmHearing_HearingReviewForIC)
Confirm Hearing Review (Appeal_confirmHearingReviewHearing)
Confirm Hearing Review (Appeal_confirmHearingReviewHearingForIC)
Confirm Home Hearing (Appeal_confirmHomeHearing)
Confirm Home Hearing (Appeal_confirmHomeHearingIC)
Confirm Home Hearing (Appeal_confirmHomeHearingType)
Confirm Home Hearing (Appeal_confirmHomeHearingTypeIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearing)
Confirm Phone Hearing (Appeal_confirmPhoneHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearingType)
Confirm Phone Hearing (Appeal_confirmPhoneHearingTypeIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearing)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearingForIC)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearing)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearingIC)
Confirm Reschedule Location Hearing (Appeal_confirmRescheduleLocationHearing)
Reschedule Hearing (Appeal_confirmRescheduleLocationHearingIC)
Confirm Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleReviewHearingDateTimeForIC)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Remove Attendee (CalendarMeeting_cancelInvitation)
New Meeting (CalendarMeeting_createMeeting)
New Meeting (CalendarMeeting_createMeetingFromUserCalendar)
New Recurring Activity (Case_createRecurringActivity)
New Activity (Case_createStandardActivity)
New Action (CreateActionWizard_owner)
New Action (CreateActionWizard_schedule)
Add Action (CreateActionWizard_sharing)
New Service (CreateServiceDeliveryWizard_schedule)
New Activity (DefaultICProduct_createActivity)
New Recurring Activity (DefaultICProduct_createRecurringActivity)
New Member Activity (ICMember_createMemberActivity)
New Recurring Member Activity (ICMember_createRecurringMemberActivity)
New Participant Activity (ICParticipant_createParticipantActivity)
New Recurring Participant Activity (ICParticipant_createRecurringParticipantActivity)
New Activity (ICProductSample_createActivity)
New Recurring Activity (ICProductSample_createRecurringActivity)
New Activity (ICSportingGrantSample_createActivity)
New Recurring Activity (ICSportingGrantSample_createRecurringActivity)
New Interview (Intake_createInterview)
Delete Attendee (Intake_deleteAttendee)
Invite Attendees (Intake_inviteAttendee)
New Activity (IntegratedCase_createActivity)
New Recurring Activity (IntegratedCase_createRecurringActivity)
Create Integrated Case Product Activity (ISPProduct_createActivity)
Create Integrated Case Product Recurring Activity (ISPProduct_createRecurringActivity)
Schedule Hearing (LegalAction_scheduleHearing)
Remove Attendee (Meeting_cancelInvitation)
New Meeting (Meeting_createMeeting)
New Attendees (Meeting_inviteAttendee)
New Attendees (Meeting_inviteAttendeeFromSEF)
Add Clients (OutcomePlan_addClientsToAction)
New Note (OutcomePlan_addNoteToAction)
Delete Action (OutcomePlan_cancelAction)
Edit Action (OutcomePlan_editAction)
Edit Reason (OutcomePlan_editActionReason)
Update Completion Details (OutcomePlan_editCompletedAction)
Remove Client (OutcomePlan_removeClientFromAction)
Edit Action (OutcomePlan_updateAction)
New Referral (OutcomePlanCollaborationPreselectedReferralWizard_details)
New Referral: (OutcomePlanCollaborationPreselectedReferralWizard_factors)
New Referral (OutcomePlanCollaborationPreselectedReferralWizard_notification)
OutcomePlanCollaborationPreselectedReferralWizard_provider
OutcomePlanCollaborationPreselectedReferralWizard_sharing
New Referral (OutcomePlanCollaborationReferralWizard_details)
New Referral (OutcomePlanCollaborationReferralWizard_factors)
New Referral (OutcomePlanCollaborationReferralWizard_notification)
OutcomePlanCollaborationReferralWizard_provider
New Referral (OutcomePlanCollaborationReferralWizard_service)
OutcomePlanCollaborationReferralWizard_sharing
New Referral (OutcomePlanPreselectedReferralWizard_details)
New Referral: (OutcomePlanPreselectedReferralWizard_factors)
New Referral (OutcomePlanPreselectedReferralWizard_notification)
OutcomePlanPreselectedReferralWizard_provider
New Referral (OutcomePlanReferralWizard_details)
New Referral (OutcomePlanReferralWizard_factors)
New Referral (OutcomePlanReferralWizard_notification)
OutcomePlanReferralWizard_provider
New Referral (OutcomePlanReferralWizard_service)
New Attachment (ProviderManagement_createReferralAttachment)
Edit Referral (ProviderManagement_editReferralNotificationsNotSent)
Edit Referral (ProviderManagement_editReferralNotificationsSent)
New Referral (ProviderManagement_referralWizardAddDetails)
New Referral (ProviderManagement_referralWizardAddNotification)
ProviderManagement_referralWizardAddProvider
New Referral (ProviderManagement_referralWizardAddService)
ProviderManagement_referralWizardLinkAddProvider
ProviderManagement_specifyReferralProviderCPMService
ProviderManagement_specifyReferralProviderCPMServiceLink
Specify Provider (ProviderManagement_specifyReferralProviderUnregisteredService)
New Recurring Activity (ServicePlanDelivery_createRecurringActivity)
SimpleCreateAction