Table Description
Daily Attendance: Detailed information about attendance and actual units delivered per day for a service to a client.

This table stores detailed information about attendance and actual units delivered per day for a service to a client.

Example

For example, a child was scheduled to receive 8 units of Child Care everyday for the period 01/05/2008-08/05/2008 but he/she received 7 units of it on 07/05/2008.

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::AttendanceTracking::Daily Attendance::Entity::DailyAttendance
Controlling File: core\model\Packages\Reference Model\Service Layer\Attendance Tracking\Daily Attendance\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (26)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
dailyAttendanceIDkeynoUnique reference number assigned by the system to the daily attendance record.DAILY_ATTENDANCE_ID SVR_INT64
rosterLineItemIDdetailsyesThe unique identifier of the Roster Line Item record associated with this daily attendance.ROSTER_LINE_ITEM_ID SVR_INT64
concernRoleIDdetailsyesConcernRoleID of the ConcernRole in respect of which this record was entered.CONCERN_ROLE_ID SVR_INT64
serviceDatedetailsnoThe date on which the service was delivered and for which attendance information is entered.SERVICE_DATE SVR_DATE
attendancedetailsyesAttendance information for a client for a service for a particular day.ATTENDANCEAttendanceSVR_STRING<10>
absenceReasondetails The reason for the absence example: hospitalizationABSENCE_REASONAttendanceAbsenceReasonSVR_STRING<10>
unitsAttendeddetails The number of units of the service that were actually delivered to the client for the day.ATTENDANCE_UNITS SVR_INT16
unitsUnattendeddetails The number of units of the service that remain undelivered to the client for the day.ATTENDANCE_UNITS SVR_INT16
progressdetails Denotes the progress information about the client's participation.PROGRESSAttendanceProgressSVR_STRING<10>
progressReasondetails Textual information regarding the reason for the progress value captured.PROGRESS_REASON SVR_STRING<300>
recordStatusdetailsnoThe status of the daily attendance.RECORD_STATUSRecordStatusSVR_STRING<10>
expectedUnitsdetailsyesNumber of units of a service which are expected to be delivered to a client on that day.ATTENDANCE_UNITS SVR_INT16
createdBySystemdetailsyesIndicates whether the record was created by system.BOOLEAN_TYPE SVR_BOOLEAN
commentsdetailsyesComments recorded by a user relating to daily attendance record.COMMENTS SVR_STRING<300>
totalHoursdetailsyesNumber of hours that a client received, or participated in, a service on a specific date.ATTENDANCE_HOURSAttendanceTrackingHoursSVR_STRING<10>
totalMinutesdetailsyesNumber of minutes that a client received, or participated in, a service on a specific date.ATTENDANCE_MINUTESAttendanceTrackingMinutesSVR_STRING<10>
hoursAbsentdetailsyesNumber of hours that a client has not received, or participated in, a service on a specific date.ATTENDANCE_HOURSAttendanceTrackingHoursSVR_STRING<10>
minutesAbsentdetailsyesNumber of minutes that a client has not received, or participated in, a service on a specific date.ATTENDANCE_MINUTESAttendanceTrackingMinutesSVR_STRING<10>
caseIDdetailsyesUnique reference number of the related case.CASE_ID SVR_INT64
creationDatedetailsnoThe date the daily attendance record was created.CURAM_DATE SVR_DATE
numHoursAttendeddetailsyesThe number of attended hours stored as a number.NUMBER_OF_HOURS SVR_INT32
numMinutesAttendeddetailsyesThe number of attended minutes stored as a number.NUMBER_OF_MINUTES SVR_INT32
numHoursAbsentdetailsyesThe number of hours that the client was absent for, stored as a number.NUMBER_OF_HOURS SVR_INT32
numMinutesAbsentdetailsyesThe number of minutes that the client was absent for, stored as a number.NUMBER_OF_MINUTES SVR_INT32
relatedIDdetailsyesID of the related item that the daily attendance details have been captured for.INTERNAL_ID SVR_INT64
relatedTypedetailsyesThe type of the related item that the daily attendance record is related to. This attribute is used along with the relatedID attribute to retrieve the details of the item that the attendance details have been recorded for. An example of a related item would be a Service, Planned Activity, etc...ATTENDANCE_RELATED_TYPEAttendanceRelatedTypeSVR_STRING<10>
Foreign Keys (7)
ChildParent
DailyAttendance.caseIDCaseHeader.caseID
DailyAttendance.concernRoleIDConcernRole.concernRoleID
DailyAttendance.rosterLineItemIDRosterLineItem.rosterLineItemID
DACorrectionHistory.dailyAttendanceIDDailyAttendance.dailyAttendanceID
DailyAttendanceCorrection.dailyAttendanceIDDailyAttendance.dailyAttendanceID
DailyAttendanceHistory.dailyAttendanceIDDailyAttendance.dailyAttendanceID
PIDailyAttendanceLink.dailyAttendanceIDDailyAttendance.dailyAttendanceID
Indices (4)
Index NameAttributes
relatedIDTypeStatusIdxrelatedID, relatedType, recordStatus
DailyAttendRosterLineItmIDIdxrosterLineItemID
IND_922291560caseID
IND_460395284concernRoleID
Operations (18)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: dailyAttendanceID
PRE_DATA_ACCESS: yes
Inserts a Daily Attendance record into the database. 
readread Reads details of a Daily Attendance record. 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies a Daily Attendance record. 
searchByRosterLineItemIDreadmulti Returns the daily attendances associated with specific roster line item. 
removeremove Standard Operation 
searchByRosterLineItemIDServiceDateRangereadmultiORDER_BY: dailyAttendanceID
WHERE: rosterLineItemID = :rosterLineItemID AND (serviceDate >= :serviceFrom AND serviceDate <=:serviceTo)
  
modifyStatusnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Changes the status of the daily attendance record. 
validateInsert  Method to validate the daily attendance details being inserted. 
validateModify  Method to validate the daily attendance details being modified. 
validateModifyStatus  Method to validate the status being modified. 
validateDetails  Method to validate the common daily attendance details. 
readVersionNonsread Returns the version number for a daily attendance record. 
readRecordStatusnsread Method to read the status of a daily attendance record. 
searchSummaryDetailsByCaseIDAndStatusnsmulti Gets a list of attendances, dates and total times for case and status specified.SQL
validateProgress  Validates the progress and progress reason fields. 
validateAbsenceReason  Validates the absence reason field. 
validateTimeEntered  Validates the time entered as participated or absent. 
searchByRelatedAndStatusreadmulti Searches for daily attendance records based on relatedID, relatedType and record status. 
Related Pages (158)
New Action (CreateActionWizard_owner)
Add Action (CreateActionWizard_sharing)
New Service (CreateServiceDeliveryWizard_factors)
New Service (CreateServiceDeliveryWizard_schedule)
New Service (CreateServiceDeliveryWizard_sharing)
New Note (OutcomePlan_addNoteToAction)
Delete Action (OutcomePlan_cancelAction)
Delete Participation (OutcomePlan_cancelParticipation)
Edit Action (OutcomePlan_editAction)
Edit Reason (OutcomePlan_editActionReason)
Update Completion Details (OutcomePlan_editCompletedAction)
Edit Daily Participation (OutcomePlan_editParticipation)
Edit Daily Participation (OutcomePlan_editParticipation1)
Record Absence Period (OutcomePlan_recordAbsencePeriod)
Record Absence Period (OutcomePlan_recordAbsencePeriodForActivity)
Record Participation (OutcomePlan_recordActivityParticipation)
Record Daily Participation (OutcomePlan_recordParticipation)
Record Scheduled Attendance (OutcomePlan_recordScheduleAttendanceForActivity)
Record Scheduled Attendance (OutcomePlan_recordScheduledAttendance)
Remove Client (OutcomePlan_removeClientFromAction)
Edit Action (OutcomePlan_updateAction)
Participation (OutcomePlan_viewActivityParticipationCalendar)
Activity Participation Calendar (OutcomePlan_viewActivityParticipationCalendarSummary)
Participation (OutcomePlan_viewActivityParticipationList)
Participation (OutcomePlan_viewActivityParticipationListSummary)
Activity Participation Calendar (OutcomePlanService_viewParticipationCalendar)
Record Attendance (ProviderManagement_addDailyAttendance)
Record Attendance (ProviderManagement_addDailyAttendanceCorrection)
Record Attendance (ProviderManagement_addDailyAttendanceForFacilityManager)
Daily Attendance Details (ProviderManagement_addDailyAttendanceForPRLI)
Daily Attendance Details (ProviderManagement_addDailyAttendanceForPRLIReporting)
Record Attendance (ProviderManagement_addDailyAttendanceForReporting)
Daily Attendance Details (ProviderManagement_addDailyAttendanceFromExceptionTask)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
Daily Attendance Details (ProviderManagement_addServiceDailyAttendanceForPRLI)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve All Line Items (ProviderManagement_approveAllRosterLineItems)
Approve Line Item (ProviderManagement_approvePRLICorrectionFromView)
Approve Provider Roster Line Item Correction (ProviderManagement_approvePRLICorrections)
Approve Roster Line Item (ProviderManagement_approveRosterLineItem)
Approve Roster Line Item (ProviderManagement_approveRosterLineItemFromTask)
Delete Service Authorization Line Item: (ProviderManagement_cancelServiceAuthorizationLineItem)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm delete rows from daily attendance roster (ProviderManagement_confirmDeleteDARosterRows)
Confirm delete rows from daily attendance roster (ProviderManagement_confirmDeleteDARosterRowsFrmET)
Confirm delete rows from daily attendance roster (ProviderManagement_confirmDeleteRowsForDARoster)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Roster (ProviderManagement_confirmSubmitRoster)
Submit Roster (ProviderManagement_confirmSubmitRosterForFacilityManager)
Submit Line Item (ProviderManagement_confirmSubmitRosterLineItem)
Edit Line Item (ProviderManagement_correctAttendancePRLIWithMultipleClients)
Correct Roster Line Item (ProviderManagement_correctPRLI)
Edit Line Item (ProviderManagement_correctPRLIWithMultipleClients)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Delete Placement (ProviderManagement_deleteSamplePlacement)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Attendance (ProviderManagement_listServiceAttendance)
Record Attendance (ProviderManagement_maintainDailyAttendanceCorrectionForAttendanceMethod)
Edit Client (ProviderManagement_modifyClientInPRLI)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Update Roster Line Item (ProviderManagement_modifyPRLIFromExceptionTask)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitPRLICorrection)
Submit Roster Line Item (ProviderManagement_submitPRLIFromExceptionTask)
Submit Roster (ProviderManagement_submitRoster)
Submit Roster (ProviderManagement_submitRosterForFacilityManager)
Submit Line Item (ProviderManagement_submitRosterLineItem)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Edit Line Item (ProviderManagement_updateAttendancePRLICorrection)
Edit Line Item (ProviderManagement_updateAttendanceRosterLineItem)
Edit Line Item (ProviderManagement_updatePRLICorrection)
Edit Line Item (ProviderManagement_updateRLIClientInfo)
Update Roster Line Item (ProviderManagement_updateRLIClientInfoFrmET)
Edit Line Item (ProviderManagement_updateRosterLineItem)
Update Roster Line Item (ProviderManagement_updateRosterLineItemFrmET)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Daily Attendance History (ProviderManagement_viewDACorrectionHistoryForReporting)
View Daily Attendance (ProviderManagement_viewDailyAttendance)
View Daily Attendance (ProviderManagement_viewDailyAttendanceCorrection)
Daily Attendance History (ProviderManagement_viewDailyAttendanceCorrectionHistory)
View Daily Attendance (ProviderManagement_viewDailyAttendanceDetailsForReporting)
View Completed Line Item (ProviderManagement_viewDailyAttendanceForCompletedAttendanceRLI)
View Completed Line Item (ProviderManagement_viewDailyAttendanceForCompletedRLI)
View Daily Attendance: (ProviderManagement_viewDailyAttendanceFrmET)
Daily Attendance History (ProviderManagement_viewDailyAttendanceHistory)
Daily Attendance History (ProviderManagement_viewDailyAttendanceHistoryForReporting)
View Daily Attendance: (ProviderManagement_viewSampleDailyAttendance)
Attendance (ServiceDelivery_listServiceAttendance)
Record Client Participation (ServicePlanDelivery_addClientParticipationDefaultPlanItem)
Record Client Participation (ServicePlanDelivery_addClientParticipationSelectPlanItem)
Record Client Participation (ServicePlanDelivery_addClientParticipationServicePlanItem)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Delete Client Participation (ServicePlanDelivery_cancelClientParticipation_fromCaseClientParticipationDailyList)
Delete Client Participation (ServicePlanDelivery_cancelClientParticipation_fromCaseClientParticipationList)
Delete Client Participation (ServicePlanDelivery_cancelClientParticipation_fromCaseClientParticipationListForWeek)
Delete Client Participation (ServicePlanDelivery_cancelClientParticipation_fromPlannedItemClientParticipationList)
Delete Client Participation (ServicePlanDelivery_cancelClientParticipation_fromPlannedItemClientParticipationListForWeek)
Delete Client Participation (ServicePlanDelivery_cancelClientParticipationServicePlanItem)
Weekly Participation (ServicePlanDelivery_caseClientParticipationWeeklyList)
Clone Service Plan (ServicePlanDelivery_clone)
Service Plan Home: (ServicePlanDelivery_home)
Home (ServicePlanDelivery_home1)
Edit Client Participation (ServicePlanDelivery_modifyClientParticipation)
Edit Client Participation (ServicePlanDelivery_modifyClientParticipationServicePlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Delete Plan Item : (ServicePlanDelivery_removePlanItem)
Tracking Gantt (ServicePlanDelivery_trackingGantt)
View Client Participation Details (ServicePlanDelivery_viewClientParticipation_from_PlanItemClientParticipationList)
View Client Participation Details (ServicePlanDelivery_viewClientParticipation_from_PlanItemClientParticipationListForWeek)
View Client Participation Details (ServicePlanDelivery_viewClientParticipation_from_ServicePlanClientParticipationList)
View Client Participation Details (ServicePlanDelivery_viewClientParticipation_from_ServicePlanClientParticipationListForDay)
View Client Participation Details (ServicePlanDelivery_viewClientParticipation_from_ServicePlanClientParticipationListForWeek)
View Client Participation Details: (ServicePlanDelivery_viewClientParticipationServicePlanItem)
View Client Participation Details (ServicePlanDelivery_viewWeeklyClientParticipationServicePlanItem)
Service Plan Home: (ServicePlanDeliveryDetails_home)
SimpleCreateAction