Table Description
DA Correction History.: History of corrections initiated against daily attendance correction.

A history of the corrections initiated against daily attendance correction 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::DACorrectionHistory
Controlling File: CPM\model\Packages\Service Layer\Attendance Tracking\Roster\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (18)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
dailyAttendanceHistryCorrectIDkeynoThe unique system generated identifier for the daily attendance correction history 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 correction 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.NUMBER_OF_HOURS SVR_INT32
totalMinutesdetailsyesNumber of minutes that a client received, or participated in, a service on a specific date.NUMBER_OF_MINUTES SVR_INT32
hoursAbsentdetailsyes

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

NUMBER_OF_HOURS SVR_INT32
minutesAbsentdetailsyes

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

NUMBER_OF_MINUTES SVR_INT32
dailyAttendanceCorrectionIDdetailsyesThe unique system generated identifier for the daily attendance correction record.DAILY_ATTENDANCE_CORRECTION_ID SVR_INT64
dateTimeChangeddetailsnoThe date and time of the modification of a daily attendance correction 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 correction record was submitted into the system.CURAM_DATE SVR_DATE
createdBySystemdetailsyesIndicates whether the record was created by system.BOOLEAN_TYPE SVR_BOOLEAN
recordStatusdetailsyesCode value to denote the status of the attendance details. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
DACorrectionHistory.dailyAttendanceIDDailyAttendance.dailyAttendanceID
DACorrectionHistory.prliCorrectionIDPRLICorrection.prliCorrectionID
Indices (3)
Index NameAttributes
DACorrHistPRLICorrectionIDIdxprliCorrectionID
DACorrHistryDACorrectionIDIdxdailyAttendanceCorrectionID
IND__2071910377dailyAttendanceID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: dailyAttendanceHistryCorrectID
Standard Operation 
searchByPRLICorrectionreadmulti Search by PRLI Correction ID 
readread Standard Operation 
searchByDailyAttendanceCorrectionreadmulti Search by PRLI Correction ID 
Related Pages (4)