Table Description
Absence Period History: A history of the changes made to absence details.

This table captures the history of changes to Absence Details. An entry is made to this table each time the associated absence period record is changed.

Example

For example, a child was scheduled to receive 80 units of Child Care between 01/05/2008-08/05/2008 but he/she received 60 units of it and 20 units remained unattended due to 'Sickness'. The absence period record is modified so that the absence reason is 'Medical'. An absence 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::Absence Period::Entity::AbsencePeriodHistory
Controlling File: core\model\Packages\Reference Model\Service Layer\Attendance Tracking\Absence Period\Entity\Entity_cat.efx
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
absencePeriodHistoryIDkeynoUnique reference number assigned by the system to the absence period history record.ABSENCEPERIOD_HISTORY_ID SVR_INT64
absencePeriodIDdetailsnoUnique reference number of the absence period associated with this absence period history record.ABSENCEPERIOD_ID SVR_INT64
absenceDatedetails The date on which client was absent.ABSENCE_DATE SVR_DATE
absenceReasondetailsnoThe reason the client was absent.ABSENCE_REASONAttendanceAbsenceReasonSVR_STRING<10>
unitsUnattendeddetailsnoThe number of units of the service that remained unattended due to absence.ATTENDANCE_UNITS SVR_INT16
recordStatusdetailsnoCode value to denote the status of the absence details. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUSRecordStatusSVR_STRING<10>
dateTimeChangeddetailsnoThe date and time of the modification of a roster line item absence details.DATE_TIME_CHANGED SVR_DATETIME
userNamedetailsyesThe user who created/modified the record.USER_NAME SVR_STRING<64>
creationDatedetailsnoThe date the absence period record was created.CURAM_DATE SVR_DATE
createdBySystemdetailsyesIndicates whether the record was created by system.BOOLEAN_TYPE SVR_BOOLEAN
periodStartDatedetailsyesThe start date of the period for which absences have been recorded.CURAM_DATE SVR_DATE
periodEndDatedetailsyesThe end date of the period for which absences have been recorded.CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
AbsencePeriodHistory.absencePeriodIDAbsencePeriod.absencePeriodID
Indices (1)
Index NameAttributes
AbsencePrdHistAbsencePrdIDIdxabsencePeriodID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: absencePeriodHistoryID
Standard Operation 
readread Standard Operation 
searchByAbsencePeriodIDreadmulti Returns the absence details history associated to specific absence details. 
Related Pages (9)