Table Description
Daily Attendance Correction: Corrections initiated against daily attendance.

A history of the corrections initiated against daily attendance for a completed roster line item.
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::CPM::Service Layer::Attendance Tracking::Roster::Entity::DailyAttendanceCorrection
Controlling File: CPM\model\Packages\Service Layer\Attendance Tracking\Roster\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (16)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
dailyAttendanceCorrectionIDkeynoThe unique system generated identifier for the daily attendance correction record.DAILY_ATTENDANCE_CORRECTION_ID SVR_INT64
dailyAttendanceIDdetailsyesThe unique system generated identifier for the daily attendance record.DAILY_ATTENDANCE_ID SVR_INT64
prliCorrectionIDdetailsnoThe unique system generated identifier for the provider roster line item record.PRLI_CORRECTION_ID SVR_INT64
serviceDatedetailsnoThe date on which 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>
absenceReasondetailsyesThe reason for the absence.ABSENCE_REASONAttendanceAbsenceReasonSVR_STRING<10>
unitsAttendeddetailsnoThe number of units of the service that were delivered to the client for the day.ATTENDANCE_UNITS SVR_INT16
unitsUnattendeddetailsnoThe number of units of the service that went undelivered to the client for the day.ATTENDANCE_UNITS SVR_INT16
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>
hoursAbsentdetailsyes

Number of hours, that a client missed or did not participate, in a service on a specific date.

ATTENDANCE_HOURSAttendanceTrackingHoursSVR_STRING<10>
minutesAbsentdetailsyes

Number of minutes that a client missed, or did not participate in, a service on a specific date.

ATTENDANCE_MINUTESAttendanceTrackingMinutesSVR_STRING<10>
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
Foreign Keys (2)
ChildParent
DailyAttendanceCorrection.dailyAttendanceIDDailyAttendance.dailyAttendanceID
DailyAttendanceCorrection.prliCorrectionIDPRLICorrection.prliCorrectionID
Indices (2)
Index NameAttributes
DACorrectnPRLICorrectionIDIdxprliCorrectionID
IND__1869291842dailyAttendanceID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: dailyAttendanceCorrectionID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByPRLICorrectionreadmulti Search by PRLI Correction ID 
readread Standard Operation 
Related Pages (14)