Children Domain ER Diagram#

This view centers on the durable child record and its placement and summary structures after intake becomes operational.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class campus { campusID : Number name : Text accountNumber : Text } class room { roomID : Number name : Text attendanceDateGlobal : Date } class child { childID : Text campusID : Number homeRoomID : Number currScheduleID : Number description : Unknown firstName : Text } class schedule { scheduleID : Number name : Text fridayCount : Number } class childSchedule { childScheduleID : Text childID : Text homeRoomID : Number scheduleID : Number name : Unknown effectiveDate : Date } class childCurrentSchedule { childCurrentScheduleID : Text childID : Text modifyTS : TimeStamp } class childProgress { childProgressID : Text childID : Text createDate : Date } child --> campus : campusID = campusID child --> room : homeRoomID = roomID child --> schedule : currScheduleID = scheduleID childSchedule --> child : childID = childID childSchedule --> room : homeRoomID = roomID childSchedule --> schedule : scheduleID = scheduleID childCurrentSchedule --> child : childID = childID childProgress --> child : childID = childID

Tables#

campus#

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

room#

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

child#

Fields#

Field Data Type Field Type
activities Text Normal
age Text Calculated
dob Date Normal
ageInMonthsDisplay Text Calculated
bDayThisYear Date Calculated
campusID Number Normal
childID Text Normal
constantOne Number Calculated
constantOneCount Number Summary
constantZero Number Calculated
currDate Date Calculated
currRoomID Number Calculated
roomID Unknown Unknown
currScheduleID Number Calculated
scheduleID Unknown Unknown
custodyOrder Number Normal
firstName Text Normal
modifyTS TimeStamp Normal
gender Text Normal
description Unknown Unknown
homeRoomID Number Calculated
immunizationRecordsReligion Number Normal
immunizationRecordsSubmittedToCompany Number Normal
lastDiaperLogID Text Calculated
childDiaperID Unknown Unknown
lastEatingLogID Text Calculated
childEatingID Unknown Unknown
lastHealthCheckIndicator Text Calculated
passedHealthCheckIn Unknown Unknown
lastItemRequestID Text Calculated
childItemRequestID Unknown Unknown
lastName Text Normal
lastSleepLogID Text Calculated
childSleepID Unknown Unknown
lastTimestampIn TimeStamp Calculated
timestampIn Unknown Unknown
lastTimestampOut TimeStamp Calculated
timestampOut Unknown Unknown
childNameFirstLast Text Calculated
nextImmunizationAge Number Calculated
immunizationAge Unknown Unknown
nextImmunizationID Text Calculated
immunizationID Unknown Unknown
noHealthHistory Number Normal
noImmunize Number Normal
primaryDoctorID Text Normal
primaryParentID Number Normal
recentIllnesses Text Normal
registrationDate Date Normal
specialNeeds Text Normal
stillRegistered Number Calculated
subsidyChildID Text Normal
date01Global Date Normal
date02Global Date Normal
allergyNameList Text Calculated
allergen Unknown Unknown
foodRestrictionNameList Text Normal
foodRestriction Unknown Unknown
feedingPracticeNameList Text Calculated
feedingPractice Unknown Unknown
constantAdaptation Text Calculated
constantDevelopmental Text Calculated
childSupportISPIDGlobal Text Normal
childAuthorizationIDGlobal Text Normal
date03Global Date Normal
date04Global Date Normal
childEatingIDGlobal Text Normal
childActionPlanIDGlobal Text Normal
crossJoin Number Normal
date05Global Date Normal
date06Global Date Normal
childProgressIDGlobal Text Normal
date01GlobalMonth Number Calculated
foodSubstituteList Text Calculated
foodAndAllergySubstitute Unknown Unknown
date03GlobalMonth Number Calculated
date05GlobalMonth Number Calculated
timestamp01Global TimeStamp Normal
timestamp02Global TimeStamp Normal
roomAge Text Calculated
emergencyCardAuthorizationTimestamp TimeStamp Normal
childAllergyIDGlobal Text Normal
currTimestamp TimeStamp Calculated
childImmunizationIDGlobal Text Normal
immunize Number Calculated
childFoodRestrictionIDGlobal Text Normal
childFeedingPracticeIDGlobal Text Normal
medicalConditionNameList Text Calculated
medicalCondition Unknown Unknown
specialNeedNameList Text Calculated
specialNeed Unknown Unknown
number01Global Number Normal
childSymptomIDGlobal Text Normal
constantAllergy Text Calculated
constantMedical Text Calculated
constantPhoto Text Calculated
ageInMonths Number Calculated
billableAmountSum Number Calculated
currBillableAmountSum Unknown Unknown
mealIDGlobal Text Normal
incompleteComplaintIllnessIncidentMedCount Number Normal
activeChild Text Calculated
constantSupport Text Calculated
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
tourChildID Text Normal
photoExpired Number Normal
createdOutsideProcess Number Normal
createdOutsideProcessEmailSent Number Normal
defaultMilk Text Normal
dateList01Global Text Normal
dateList02Global Text Normal
dateList03Global Text Normal
foodConstraintNameListFoodLog Text Calculated
middleName Text Normal
childNameFirstMiddleLast Text Calculated
childNameLastFirstMiddle Text Calculated
allergyAndFoodPlanAuthorizationTimestamp TimeStamp Normal
lastDateIn Date Calculated
roomAgeInMonths Number Calculated
foodListHTML Text Normal
allergyListHTML Text Normal
medicalListHTML Text Normal
supportListHTML Text Normal
childNameLastFirst Text Calculated
genderID Text Normal
foodRestrictionNamePlusSubstituteList Text Calculated
foodRestrictionPlusSubstitute Unknown Unknown
allergyNamePlusSubstituteList Text Calculated
allergenNamePlusSubstitute Unknown Unknown
childTransferID Text Normal
allergyAndFoodPlanVerbiage Text Normal
planIndicator Text Calculated
childAllergyIAPID Unknown Unknown
childMedicalIMPID Unknown Unknown
childSupportISPID Unknown Unknown
authorizationTemplateIDGlobal Text Normal

Relationships#

  • References campus on child.campusID = campus.campusID.
  • References room on child.homeRoomID = room.roomID.
  • References schedule on child.currScheduleID = schedule.scheduleID.
  • Referenced by childSchedule on childSchedule.childID = child.childID.
  • Referenced by childCurrentSchedule on childCurrentSchedule.childID = child.childID.
  • Referenced by childProgress on childProgress.childID = child.childID.

schedule#

Fields#

Field Data Type Field Type
fridayCount Number Calculated
friday Number Normal
mondayCount Number Calculated
monday Number Normal
numDays Number Calculated
tuesdayCount Number Calculated
wednesdayCount Number Calculated
thursdayCount Number Calculated
saturdayCount Number Calculated
sundayCount Number Calculated
saturday Number Normal
sunday Number Normal
thursday Number Normal
tuesday Number Normal
wednesday Number Normal
scheduleID Number Normal
name Text Normal
constantOne Number Calculated
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
carryOverMidnight Number Normal
repetitionEndTimes Text Calculated
repetitionStartTimes Text Calculated
webSiteName Text Normal
showOnWebSite Number Normal
applyEarlyCharges Number Normal

Relationships#

  • Referenced by child on child.currScheduleID = schedule.scheduleID.
  • Referenced by childSchedule on childSchedule.scheduleID = schedule.scheduleID.

childSchedule#

Fields#

Field Data Type Field Type
costChangeIndicator Text Calculated
newCost Number Calculated
lastAmount Number Normal
cost Number Normal
lastProgram Text Normal
name Unknown Unknown
lastSchedule Text Normal
newProgram Number Normal
newSchedule Number Normal
numDays Number Normal
modifyTS TimeStamp Normal
sundaySum Number Calculated
mondaySum Number Calculated
tuesdaySum Number Calculated
wednesdaySum Number Calculated
thursdaySum Number Calculated
fridaySum Number Calculated
saturdaySum Number Calculated
parentBiWeeklyCost Number Calculated
parentDailyCost Number Normal
applyCWELCCAdjustment Unknown Unknown
parentDailyCostCWELCC Number Calculated
parentDailyCostRegular Number Calculated
scheduleChangeIndicator Text Calculated
subsidyBiWeekly Number Calculated
subsidyCost Number Normal
tillDate Date Normal
totalDailyCost Number Calculated
childID Text Normal
comments Text Normal
costCWELCC Number Normal
costRegular Number Normal
effectiveDate Date Normal
homeRoomID Number Normal
isSubsidy Number Normal
otherDiscountPct Number Normal
constantOneCount Number Summary
constantOne Number Calculated
scheduleID Number Normal
siblingDiscount Number Normal
staffDiscount Number Normal
subsidyCostCWELCC Number Calculated
subsidyCostRegular Number Calculated
subsidyParentDailyContribution Number Normal
subsidyParentDailyCost Number Normal
childScheduleID Text Normal
programGroupID Number Normal
currentProgramGroupID Unknown Unknown
childDateIDGlobal Text Normal
monday Number Normal
tuesday Number Normal
wednesday Number Normal
thursday Number Normal
friday Number Normal
weekStartGlobal Date Normal
mondayGlobal Date Calculated
tuesdayGlobal Date Calculated
wednesdayGlobal Date Calculated
thursdayGlobal Date Calculated
fridayGlobal Date Calculated
number01Global Number Normal
lastHomeRoomID Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
homeRoomIDChanged Number Normal
childWithdrawalReasonCodeID Text Normal
childNamePlusChildWithdrawalReasonCode Text Calculated
childName Text Normal
reasonCode Text Normal
childNameFirstLast Unknown Unknown
saturday Number Normal
saturdayGlobal Date Calculated
sunday Number Normal
sundayGlobal Date Calculated
isYounger Text Calculated
roomAgeInMonths Unknown Unknown
minAgeInMonths Unknown Unknown
otherDiscountDollars Number Normal
constantZero Number Calculated
subsidyDailyCostCWELCC Unknown Unknown
subsidyTwoDayCostCWELCC Unknown Unknown
subsidyThreeDayCostCWELCC Unknown Unknown
subsidyFourDayCostCWELCC Unknown Unknown
subsidyFiveDayCostCWELCC Unknown Unknown
dailyCostCWELCC Unknown Unknown
twoDayCostCWELCC Unknown Unknown
threeDayCostCWELCC Unknown Unknown
fourDayCostCWELCC Unknown Unknown
fiveDayCostCWELCC Unknown Unknown
subsidyDailyCost Unknown Unknown
subsidyTwoDayCost Unknown Unknown
subsidyThreeDayCost Unknown Unknown
subsidyFourDayCost Unknown Unknown
subsidyFiveDayCost Unknown Unknown
dailyCost Unknown Unknown
twoDayCost Unknown Unknown
threeDayCost Unknown Unknown
fourDayCost Unknown Unknown
fiveDayCost Unknown Unknown
archiveTransactionsCreated Number Normal
updateSource Text Normal
constantChildScheduleDetails Text Calculated

Relationships#

  • References child on childSchedule.childID = child.childID.
  • References room on childSchedule.homeRoomID = room.roomID.
  • References schedule on childSchedule.scheduleID = schedule.scheduleID.

childCurrentSchedule#

Fields#

Field Data Type Field Type
childID Text Normal
childCurrentScheduleID Text Normal
modifyTS TimeStamp Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
childScheduleID Text Normal
scheduleID Number Normal
homeRoomID Number Normal

Relationships#

  • References child on childCurrentSchedule.childID = child.childID.

childProgress#

Fields#

Field Data Type Field Type
childID Text Normal
createDate Date Normal
complete Number Calculated
staffSignatureName Text Normal
areasToImprove Text Normal
goals Text Normal
strengths Text Normal
childProgressID Text Normal
roomProgramElectDomainIDGlobal Text Normal
staffSignatureDate Date Normal
modifyTS TimeStamp Normal
constantOne Number Calculated
constantOneCount Number Summary
eMailSent Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
roomProgramElectGoalIDGlobal Text Normal
roomProgramElectIDGlobal Text Normal
programGroupID Number Calculated
currentProgramGroupID Unknown Unknown
finishDate Date Normal
crossJoin Number Normal
staffSignatureMethod Text Normal

Relationships#

  • References child on childProgress.childID = child.childID.

Notes#

  • The legacy schema includes many report and date-filtered child occurrences; those were collapsed here into the durable child spine.
  • Health, daily care, and family access tables are intentionally separated into their own domain diagrams even though many of them reference child directly.