Table Description
Daily Attendance History: A history of the changes made to daily attendance.

This table captures the history of changes to Daily Attendance. An entry is made to this table each time a daily attendance record is changed.

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. The daily attendance record is modified so that the units attended is 8. A daily attendance history record is created to capture this change.

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::DailyAttendanceHistory
Controlling File: core\model\Packages\Reference Model\Service Layer\Attendance Tracking\Daily Attendance\Entity\Entity_cat.efx
Attributes (19)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
dailyAttendanceHistoryIDkeynoUnique reference number assigned by the system to the daily attendance history record.DAILY_ATTENDANCE_HISTORY_ID SVR_INT64
dailyAttendanceIDdetailsnoUnique reference number of the daily attendance associated with this daily attendance history record.DAILY_ATTENDANCE_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>
dateTimeChangeddetailsnoThe date and time of the modification of a roster line item attendance details.DATE_TIME_CHANGED SVR_DATETIME
userNamedetailsyesThe user who created/modified the record.USER_NAME SVR_STRING<64>
creationDatedetailsnoThe date on which the daily attendance record was submitted into the system.CURAM_DATE SVR_DATE
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>
hoursAbsentdetails Number of hours that a client has not received, or participated in, a service on a specific date.ATTENDANCE_HOURSAttendanceTrackingHoursSVR_STRING<10>
minutesAbsentdetails Number of minutes that a client has not received, or participated in, a service on a specific date.ATTENDANCE_MINUTESAttendanceTrackingMinutesSVR_STRING<10>
Foreign Keys (1)
ChildParent
DailyAttendanceHistory.dailyAttendanceIDDailyAttendance.dailyAttendanceID
Indices (1)
Index NameAttributes
DailyAttendHisDailyAttenIDIdxdailyAttendanceID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: dailyAttendanceHistoryID
Standard Operation 
readread Standard Operation 
searchByDailyAttendanceIDreadmulti Returns the daily attendance history associated to specific daily attendance. 
Related Pages (4)