Daily Care And Attendance ER Diagram#

This view captures the live operational records created during the child’s day in care.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class child { childID : Text description : Unknown firstName : Text lastName : Text } class room { roomID : Number name : Text attendanceDateGlobal : Date } class mealSchedule { mealScheduleID : Text mealDate : Date campusID : Number } class childAttendance { childAttendanceID : Text childID : Text roomID : Number } class childEating { childEatingID : Text childID : Text effectiveDate : Date name : Unknown calendarEventName : Unknown } class childSleep { childSleepID : Text childID : Text roomID : Number } class childDiaper { childDiaperID : Text childID : Text timestampChanged : TimeStamp } class childAbsentDay { childAbsentDayID : Text childID : Text roomID : Number } class childIncident { childIncidentID : Text childID : Text roomID : Number description : Unknown dateOccurred : Date } class childIllness { childIllnessID : Text childID : Text roomID : Number message : Unknown dateOccurred : Date } childAttendance --> child : childID = childID childAttendance --> room : roomID = roomID childEating --> child : childID = childID childEating --> mealSchedule : effectiveDate = mealDate childSleep --> child : childID = childID childSleep --> room : roomID = roomID childDiaper --> child : childID = childID childAbsentDay --> child : childID = childID childAbsentDay --> room : roomID = roomID childIncident --> child : childID = childID childIncident --> room : roomID = roomID childIllness --> child : childID = childID childIllness --> room : roomID = roomID

Tables#

child#

Primary table details live in child under Children Domain ER Diagram.

room#

Primary table details live in room under Organization And Capacity ER Diagram.

mealSchedule#

Fields#

Field Data Type Field Type
campusID Number Normal
mealDate Date Normal
mealScheduleID Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
childAllergenIDList Text Normal
childFoodRestrictionIDList Text Normal
listLastUpdateDate Date Normal

Relationships#

  • Referenced by childEating on childEating.effectiveDate = mealSchedule.mealDate.

childAttendance#

Fields#

Field Data Type Field Type
currDate Date Calculated
error Number Calculated
timestampOut TimeStamp Normal
dateIn Date Calculated
timestampIn TimeStamp Normal
childID Text Normal
notes Text Normal
childNameFirstLast Unknown Unknown
passedHealthCheckIn Number Normal
roomID Number Normal
constantOne Number Calculated
timestampOutMax TimeStamp Calculated
childAttendanceID Text Normal
passedHealthCheckInDisplay Text Calculated
timeOut Time Calculated
campusID Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
dateInUnix Text Calculated
timeIn Time Calculated

Relationships#

  • References child on childAttendance.childID = child.childID.
  • References room on childAttendance.roomID = room.roomID.

childEating#

Fields#

Field Data Type Field Type
currDate Date Calculated
childID Text Normal
effectiveDate Date Normal
milkUnits Text Normal
comments Text Normal
activityIDList Text Normal
modifyTS TimeStamp Normal
programTaskAreaID Unknown Unknown
waterUnits Text Normal
frenchComments Text Normal
jumparooComments Text Normal
mondayDate Date Calculated
stemComments Text Normal
childEatingID Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
effectiveDateUnix Text Calculated
activityDescriptionList Text Calculated
name Unknown Unknown
calendarEventName Unknown Unknown
emergencyAction Unknown Unknown
calendarEventIDList Text Normal
calendarEventID Unknown Unknown
emergencyActionIDList Text Normal
emergencyActionID Unknown Unknown

Relationships#

  • References child on childEating.childID = child.childID.
  • References mealSchedule on childEating.effectiveDate = mealSchedule.mealDate.

childSleep#

Fields#

Field Data Type Field Type
childID Text Normal
sleepTimestamp TimeStamp Normal
wakeTimestamp TimeStamp Normal
currDate Date Calculated
sleepDate Date Calculated
sleepDuration Time Calculated
roomID Number Normal
constantOne Number Calculated
wakeTimestampMax TimeStamp Calculated
comments Text Normal
constantOneCount Number Summary
childSleepID Text Normal
nameFirstLast Text Normal
childNameFirstLast Unknown Unknown
commentOnly Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
sleepDateUnix Text Calculated

Relationships#

  • References child on childSleep.childID = child.childID.
  • References room on childSleep.roomID = room.roomID.

childDiaper#

Fields#

Field Data Type Field Type
childID Text Normal
timestampChanged TimeStamp Normal
wetOrBM Text Normal
currDate Date Calculated
dateChanged Date Calculated
timeChanged Time Calculated
childDiaperID Text Normal
creamType Text Normal
creamApplied Number Normal
text01Global Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
dateChangedUnix Text Calculated
crossJoin Number Normal
staffSignatureMethod Text Normal
staffSignatureName Text Normal
isLocked Number Normal

Relationships#

  • References child on childDiaper.childID = child.childID.

childAbsentDay#

Fields#

Field Data Type Field Type
childID Text Normal
dateAbsent Date Normal
notes Text Normal
dateAbsentCount Number Summary
roomID Number Normal
homeRoomID Unknown Unknown
reason Text Normal
dateAbsentYear Number Calculated
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
dateAbsentUnix Text Calculated
childAbsentDayID Text Normal
reasonIsUnresolved Number Calculated
showAsUnresolved Number Normal
childAbsentReasonID Text Normal

Relationships#

  • References child on childAbsentDay.childID = child.childID.
  • References room on childAbsentDay.roomID = room.roomID.

childIncident#

Fields#

Field Data Type Field Type
actionTaken Text Normal
modifyTS TimeStamp Normal
childIncidentActionTakenID Unknown Unknown
childIncidentActionTakenIDList Text Normal
actionTakenOther Text Normal
awakeChildren Number Normal
complete Number Normal
staffCheckedIn Number Normal
totalChildrenCheckedIn Number Normal
childID Text Normal
comments Text Normal
completeEMailSent Number Normal
equipment Text Normal
childIncidentEquipmentID Unknown Unknown
childIncidentEquipmentIDList Text Normal
equipmentOther Text Normal
endDateGlobal Date Normal
startDateGlobal Date Normal
incident Text Normal
description Unknown Unknown
childIncidentDescriptionID Unknown Unknown
childIncidentDescriptionIDList Text Normal
incidentOther Text Normal
location Text Normal
locationOther Text Normal
roomID Number Normal
seriousOccurrence Number Normal
timestampOccurred TimeStamp Normal
constantOne Number Calculated
inComplete Number Calculated
constantOneCount Number Summary
childIncidentID Text Normal
dateOccurred Date Calculated
dateCompleted Date Normal
yearOccurred Number Calculated
incidentPlusDate Text Calculated
incidentComplete Text Calculated
actionTakenComplete Text Calculated
locationComplete Text Calculated
isPlayground Number Calculated
childIncidentLocationID Text Normal
isLocked Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
initialEMailSent Number Normal
followUp Text Normal
childIncidentFollowUpID Unknown Unknown
childIncidentFollowUpIDList Text Normal
followUpOther Text Normal
incidentList Text Calculated
locationList Text Calculated
dateCreated Date Calculated
crossJoin Number Normal
dateOccurredUnix Text Calculated
signedBySupervisor Number Calculated
supervisorSignatureName Text Normal
staffSignatureMethod Text Normal
staffSignatureName Text Normal
supervisorSignatureMethod Text Normal

Relationships#

  • References child on childIncident.childID = child.childID.
  • References room on childIncident.roomID = room.roomID.

childIllness#

Fields#

Field Data Type Field Type
actionTaken Text Normal
modifyTS TimeStamp Normal
childIllnessActionTakenID Unknown Unknown
childIllnessActionTakenIDList Text Normal
actionTakenOther Text Normal
complete Number Normal
childID Text Normal
detail Text Normal
completeEMailSent Number Normal
endDateGlobal Date Normal
startDateGlobal Date Normal
illnessObserved Text Normal
symptom Unknown Unknown
childIllnessSymptomID Unknown Unknown
childIllnessSymptomIDList Text Normal
illnessObservedOther Text Normal
pickupChild Number Normal
roomID Number Normal
seriousOccurrence Number Normal
timestampOccurred TimeStamp Normal
constantOne Number Calculated
inComplete Number Calculated
constantOneCount Number Summary
childIllnessID Text Normal
temperatureList Text Calculated
temperature Unknown Unknown
dateOccurred Date Calculated
dateCompleted Date Normal
isLocked Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
initialEMailSent Number Normal
illnessObservedList Text Calculated
dateCreated Date Calculated
crossJoin Number Normal
actionTakenList Text Calculated
dateOccurredUnix Text Calculated
signedBySupervisor Number Calculated
supervisorSignatureName Text Normal
detailCSS Text Calculated
message Unknown Unknown
staffSignatureMethod Text Normal
staffSignatureName Text Normal
supervisorSignatureMethod Text Normal

Relationships#

  • References child on childIllness.childID = child.childID.
  • References room on childIllness.roomID = room.roomID.

Notes#

  • The operational model uses additional filtered occurrences for date windows, room occupancy, and unresolved-status views. Those were intentionally collapsed here.
  • childEating is linked to mealSchedule through the exported date-based relationship, which is why the edge label uses both fields.