Entity Relationship Overview#

This overview groups the legacy FileMaker schema into five larger slices. Each diagram links to a detailed table section in this document, and the per-domain set expands the same model in smaller focused documents.

Per-Domain Sets#

Core Childcare Operations#

This overview section groups the operational child, room, schedule, and daily care records that drive placement and attendance.

Included Tables#

`campus`
`room`
`programGroup`
`roomProgramGroup`
`child`
`schedule`
`mealSchedule`
`childSchedule`
`childCurrentSchedule`
`childAttendance`
`childEating`
`childSleep`
`childDiaper`
`childAbsentDay`
`childIncident`
`childIllness`

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class campus { campusID : Number name : Text accountNumber : Text } class room { roomID : Number campusID : Number name : Text } class programGroup { programGroupID : Number name : Text modifyTS : TimeStamp } class roomProgramGroup { roomProgramGroupID : Text roomID : Number programGroupID : Number name : Unknown } class child { childID : Text campusID : Number homeRoomID : Number currScheduleID : Number description : Unknown firstName : Text } class schedule { scheduleID : Number name : Text fridayCount : Number } class mealSchedule { mealScheduleID : Text campusID : Number mealDate : Date } class childSchedule { childScheduleID : Text childID : Text homeRoomID : Number scheduleID : Number name : Unknown effectiveDate : Date } class childCurrentSchedule { childCurrentScheduleID : Text childID : Text modifyTS : TimeStamp } 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 } room --> campus : campusID = campusID roomProgramGroup --> room : roomID = roomID roomProgramGroup --> programGroup : programGroupID = programGroupID child --> campus : campusID = campusID child --> room : homeRoomID = roomID child --> schedule : currScheduleID = scheduleID mealSchedule --> campus : campusID = campusID childSchedule --> child : childID = childID childSchedule --> room : homeRoomID = roomID childSchedule --> schedule : scheduleID = scheduleID childCurrentSchedule --> child : childID = childID 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

Family And Billing#

This section links household structure, parent-facing access, and the receivable models that connect children, parents, and campuses.

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class campus { campusID : Number name : Text accountNumber : Text } class child { childID : Text description : Unknown firstName : Text lastName : Text } class parent { parentID : Text firstName : Text lastName : Text } class childParent { childParentID : Text childID : Text parentID : Text familialRelationshipID : Text parentalRoleID : Text mobileAppPermissionLevelID : Text } class familialRelationship { familialRelationshipID : Text description : Text createTS : TimeStamp } class parentalRole { parentalRoleID : Text description : Text createAccount : Text } class mobileAppPermissionLevel { mobileAppPermissionLevelID : Text description : Text createTS : TimeStamp } class mobileAppUserAccount { mobileAppUserAccountID : Text parentID : Text accountName : Text } class parentAccount { parentAccountID : Text parentID : Text childID : Text } class subsidyAccount { subsidyAccountID : Text parentID : Text childID : Text } class subsidyReceivable { subsidyReceivableID : Text subsidyAccountIDGlobal : Text campusIDGlobal : Number childIDGlobal : Text } class eftReceivable { eftReceivableID : Text parentID : Text firstName : Text lastName : Text } childParent --> child : childID = childID childParent --> parent : parentID = parentID childParent --> familialRelationship : familialRelationshipID = familialRelationshipID childParent --> parentalRole : parentalRoleID = parentalRoleID childParent --> mobileAppPermissionLevel : mobileAppPermissionLevelID = mobileAppPermissionLevelID mobileAppUserAccount --> parent : parentID = parentID mobileAppUserAccount --> childParent : parentID = parentID parentAccount --> parent : parentID = parentID parentAccount --> child : childID = childID subsidyAccount --> parent : parentID = parentID subsidyAccount --> child : childID = childID subsidyReceivable --> subsidyAccount : subsidyAccountIDGlobal = subsidyAccountID subsidyReceivable --> campus : campusIDGlobal = campusID subsidyReceivable --> child : childIDGlobal = childID eftReceivable --> parent : parentID = parentID

Health And Authorizations#

This section groups the child health, allergy, support, and medication administration records that sit around the primary child record.

Included Tables#

`child`
`doctor`
`allergen`
`childAllergy`
`childMedicalCondition`
`childSpecialNeed`
`childMedAuthorization`
`childMedAdministration`
`staff`

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class child { childID : Text primaryDoctorID : Text description : Unknown firstName : Text lastName : Text } class doctor { doctorID : Text firstName : Text lastName : Text } class allergen { allergenID : Text allergenName : Text modifyTS : TimeStamp } class childAllergy { childAllergyID : Text childID : Text allergenID : Text } class childMedicalCondition { childMedicalConditionID : Text childID : Text description : Unknown } class childSpecialNeed { childSpecialNeedID : Text childID : Text description : Unknown } class childMedAuthorization { childMedAuthorizationID : Text childID : Text administrationInstruction : Text } class childMedAdministration { childMedAdministrationID : Text childMedAuthorizationID : Number staffID : Text } class staff { staffID : Text description : Unknown firstName : Text lastName : Text } child --> doctor : primaryDoctorID = doctorID childAllergy --> child : childID = childID childAllergy --> allergen : allergenID = allergenID childMedicalCondition --> child : childID = childID childSpecialNeed --> child : childID = childID childMedAuthorization --> child : childID = childID childMedAdministration --> childMedAuthorization : childMedAuthorizationID = childMedAuthorizationID childMedAdministration --> staff : staffID = staffID

Workforce And Reviews#

This section covers staff placement, access, time, and review structures that shape workforce administration.

Included Tables#

`campus`
`room`
`staff`
`staffPortalPermissionLevel`
`staffPortalUserAccount`
`staffPortalUserVerificationCode`
`staffAttendance`
`staffShiftAssignment`
`staffTimeOffRequest`
`review`
`reviewType`
`reviewAnswer`

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class campus { campusID : Number name : Text accountNumber : Text } class room { roomID : Number name : Text attendanceDateGlobal : Date } class staff { staffID : Text campusID : Number primaryRoomID : Number staffPortalPermissionLevelID : Text description : Unknown firstName : Text } class staffPortalPermissionLevel { staffPortalPermissionLevelID : Text description : Text createTS : TimeStamp } class staffPortalUserAccount { staffPortalUserAccountID : Text staffID : Text accountName : Text } class staffPortalUserVerificationCode { staffPortalUserVerificationCodeID : Text staffID : Text createTS : TimeStamp } class staffAttendance { staffAttendanceID : Text staffID : Text roomID : Number } class staffShiftAssignment { staffShiftAssignmentID : Text staffID : Text roomID : Number description : Text firstName : Unknown } class staffTimeOffRequest { staffTimeOffRequestID : Text staffID : Text approved : Number } class review { reviewID : Number staffID : Text reviewTypeID : Text roomID : Number } class reviewType { reviewTypeID : Text reviewType : Text modifyTS : TimeStamp } class reviewAnswer { reviewAnswerID : Text reviewID : Number answer : Number } staff --> campus : campusID = campusID staff --> room : primaryRoomID = roomID staff --> staffPortalPermissionLevel : staffPortalPermissionLevelID = staffPortalPermissionLevelID staffPortalUserAccount --> staff : staffID = staffID staffPortalUserVerificationCode --> staff : staffID = staffID staffAttendance --> staff : staffID = staffID staffAttendance --> room : roomID = roomID staffShiftAssignment --> staff : staffID = staffID staffShiftAssignment --> room : roomID = roomID staffTimeOffRequest --> staff : staffID = staffID review --> staff : staffID = staffID review --> reviewType : reviewTypeID = reviewTypeID review --> room : roomID = roomID reviewAnswer --> review : reviewID = reviewID

Facilities And Communications#

This section brings together communication records and the health, safety, repair, and kitchen structures tied to campuses and rooms.

Included Tables#

`campus`
`room`
`child`
`staff`
`communication`
`email`
`emailAttachment`
`repairOrder`
`healthSafetyMeeting`
`healthSafetyMeetingStaff`
`healthSafetyChecklist`
`healthSafetyChecklistItem`
`mealSchedule`

%%{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 description : Unknown firstName : Text lastName : Text } class staff { staffID : Text description : Unknown firstName : Text lastName : Text } class communication { communicationID : Text childIDList : Text roomIDList : Text originatingStaffID : Text name : Unknown message : Text } class email { emailID : Number childIDList : Text staffIDList : Text } class emailAttachment { emailAttachmentID : Text emailID : Number filename : Text } class repairOrder { repairOrderID : Text campusID : Number roomID : Number reportedByStaffID : Text name : Unknown description : Unknown } class healthSafetyMeeting { healthSafetyMeetingID : Text campusID : Number callToOrderTimestamp : TimeStamp } class healthSafetyMeetingStaff { healthSafetyMeetingStaffID : Text healthSafetyMeetingID : Text staffID : Text } class healthSafetyChecklist { healthSafetyChecklistID : Text campusID : Number checklistFrequency : Text } class healthSafetyChecklistItem { healthSafetyChecklistItemID : Text healthSafetyChecklistID : Text repairOrderID : Text description : Text } class mealSchedule { mealScheduleID : Text campusID : Number mealDate : Date } communication --> child : childIDList = childID communication --> room : roomIDList = roomID communication --> staff : originatingStaffID = staffID email --> child : childIDList = childID email --> staff : staffIDList = staffID emailAttachment --> email : emailID = emailID repairOrder --> campus : campusID = campusID repairOrder --> room : roomID = roomID repairOrder --> staff : reportedByStaffID = staffID healthSafetyMeeting --> campus : campusID = campusID healthSafetyMeetingStaff --> healthSafetyMeeting : healthSafetyMeetingID = healthSafetyMeetingID healthSafetyMeetingStaff --> staff : staffID = staffID healthSafetyChecklist --> campus : campusID = campusID healthSafetyChecklistItem --> healthSafetyChecklist : healthSafetyChecklistID = healthSafetyChecklistID healthSafetyChecklistItem --> repairOrder : repairOrderID = repairOrderID mealSchedule --> campus : campusID = campusID

Tables#

campus#

Fields#

Field	Data Type	Field Type
accountNumber	Text	Normal
address	Text	Normal
branchNumber	Text	Normal
currDate	Date	Calculated
processDate	Text	Calculated
processDateDate	Date	Calculated
eftDate	Date	Normal
name	Text	Normal
totalAmount	Number	Normal
transitNumber	Text	Normal
campusType	Text	Calculated
campusTypeTrans	Number	Calculated
currAccountName	Text	Calculated
constantOne	Number	Calculated
currPrivilegeSet	Text	Calculated
currTimestamp	TimeStamp	Calculated
campusID	Number	Normal
text01Global	Text	Normal
unreconciledSubsidyImportCount	Number	Normal
emailMode	Text	Normal
deleteEmailAfter	Number	Normal
date01Global	Date	Normal
date01GlobalWeekStart	Date	Calculated
date01GlobalWeekEnd	Date	Calculated
staffQualificationReportHeader	Text	Normal
date02Global	Date	Normal
number01Global	Number	Normal
devModeEmailAddress	Text	Normal
testModeEmailAddress	Text	Normal
date01GlobalMonth	Number	Calculated
allFailedToggle	Text	Normal
constantQuality	Text	Calculated
disallowSiblingDiscount	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
capacityForecastMonths	Number	Normal
registrationFeeSibling	Number	Normal
date03Global	Date	Normal
masterCampus	Number	Normal
maxGoodAboveRatioPct	Number	Normal
maxCautionAboveRatioPct	Number	Normal
maxUnpaidLeaveDays	Number	Normal
dateList01Global	Text	Normal
allowNonHomeRoomLogin	Number	Normal
crossJoin	Number	Normal
minGoodUtilizationPct	Number	Normal
minCautionUtilizationPct	Number	Normal
maxHealthScreeningMins	Number	Normal
requireHealthScreening	Text	Normal
phone	Text	Normal
website	Text	Normal
facilityType	Text	Normal
drinkingWaterSystemNo	Text	Normal
defaultEmailName	Text	Normal
companyNameShort	Text	Normal
companyNameLong	Text	Normal
billingAnchorDate	Date	Normal
emailCSS	Text	Normal
emailHeader	Text	Normal
emailHeaderImageURL	Text	Normal
emailFooter	Text	Normal
emailFooterImageURL	Text	Normal
healthCheckPromptHealthy	Text	Normal
healthCheckPromptNotHealthy	Text	Normal
disableDailyReportEmailPrompt	Number	Normal
daysOfOperation	Text	Normal
allowMobileParentUpdate	Number	Normal
allowMobileMessaging	Number	Normal
registrationFeeRegular	Number	Normal
maxFoodFromKitchenToClassroomTime	Number	Normal
daysToPerformWaterFlush	Text	Normal
disableDashboardEntryForNewChildRegistration	Number	Normal
clearNewRegistrationDashboardEntriesAfterDays	Number	Normal
deleteCommunicationsAfter	Number	Normal
twilioAccountSID	Text	Normal
twilioMessagingServiceSID	Text	Normal
twilioAuthToken	Text	Normal
twilioPhoneNumber	Text	Normal
applyCWELCCAdjustment	Number	Normal
allowVacationDiscounts	Number	Normal
massEmailPrivSetList	Text	Normal
minExpectedHours	Number	Normal
maxExpectedHours	Number	Normal
minTimeOffRequestLeadDays	Number	Normal
allowWebStaffUpdate	Number	Normal
eftProvider	Text	Normal
scotiaBankCustomerRef	Text	Normal
chefSpecialIngredientDeleteDays	Number	Normal

Relationships#

Referenced by room on room.campusID = campus.campusID.
Referenced by child on child.campusID = campus.campusID.
Referenced by mealSchedule on mealSchedule.campusID = campus.campusID.
Referenced by subsidyReceivable on subsidyReceivable.campusIDGlobal = campus.campusID.
Referenced by staff on staff.campusID = campus.campusID.
Referenced by repairOrder on repairOrder.campusID = campus.campusID.
Referenced by healthSafetyMeeting on healthSafetyMeeting.campusID = campus.campusID.
Referenced by healthSafetyChecklist on healthSafetyChecklist.campusID = campus.campusID.
Referenced by mealSchedule on mealSchedule.campusID = campus.campusID.

room#

Fields#

Field	Data Type	Field Type
attendanceDateGlobal	Date	Normal
currDate	Date	Calculated
email	Text	Normal
roomID	Number	Normal
maxCapacity	Number	Calculated
capacity	Unknown	Unknown
name	Text	Normal
modifyTS	TimeStamp	Normal
zeros	Number	Normal
attendingChildIDList	Text	Calculated
constantOne	Number	Calculated
currTimestamp	TimeStamp	Calculated
timestampFloor	TimeStamp	Calculated
campusID	Number	Normal
currentProgramGroupID	Number	Calculated
programGroupID	Unknown	Unknown
childIDGlobal	Text	Normal
mealIDGlobal	Text	Normal
date01Global	Date	Normal
timestamp01Global	TimeStamp	Normal
timestamp02Global	TimeStamp	Normal
capacityEndDateGlobal	Date	Normal
capacityStartDateGlobal	Date	Normal
timestampListGlobal	Text	Normal
time01Global	Time	Normal
monday	Number	Calculated
childID	Unknown	Unknown
tuesday	Number	Calculated
wednesday	Number	Calculated
thursday	Number	Calculated
friday	Number	Calculated
mondayMax	Number	Calculated
tuesdayMax	Number	Calculated
wednesdayMax	Number	Calculated
thursdayMax	Number	Calculated
fridayMax	Number	Calculated
childDiaperIDGlobal	Text	Normal
childSleepIDGlobal	Text	Normal
childItemRequestIDGlobal	Text	Normal
currTime	Time	Calculated
staffCheckedIn	Number	Calculated
childrenCheckedIn	Number	Calculated
programSpecialtyGlobal	Text	Normal
text01Global	Text	Normal
date02Global	Date	Normal
crossJoin	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
childRoom	Number	Normal
childRoomValue	Text	Calculated
maxStaff	Number	Normal
constantYes	Text	Calculated
dateList01Global	Text	Normal
checkedInChildIDList	Text	Calculated
assignedCheckedInChildIDList	Text	Calculated
number01Global	Number	Normal
phoneExtension	Text	Normal
reqdStaff	Number	Normal
roomShiftResponsibilityShiftList	Text	Normal
currentDayName	Text	Calculated
constantChildNotice	Text	Calculated
constantParent	Text	Calculated
constantEducator	Text	Calculated
constantSupervisor	Text	Calculated
roomIDPlusZero	Text	Calculated
saturday	Number	Calculated
saturdayMax	Number	Calculated
sunday	Number	Calculated
sundayMax	Number	Calculated
date01GlobalMonth	Number	Calculated
roomIDListGlobal	Text	Normal
sort	Number	Normal
calendarMonthIDGlobal	Text	Normal
childrenSleeping	Number	Calculated
roomTransferID	Text	Normal
hideOnOrgChart	Number	Normal

Relationships#

References campus on room.campusID = campus.campusID.
Referenced by roomProgramGroup on roomProgramGroup.roomID = room.roomID.
Referenced by child on child.homeRoomID = room.roomID.
Referenced by childSchedule on childSchedule.homeRoomID = room.roomID.
Referenced by childAttendance on childAttendance.roomID = room.roomID.
Referenced by childSleep on childSleep.roomID = room.roomID.
Referenced by childAbsentDay on childAbsentDay.roomID = room.roomID.
Referenced by childIncident on childIncident.roomID = room.roomID.
Referenced by childIllness on childIllness.roomID = room.roomID.
Referenced by staff on staff.primaryRoomID = room.roomID.
Referenced by staffAttendance on staffAttendance.roomID = room.roomID.
Referenced by staffShiftAssignment on staffShiftAssignment.roomID = room.roomID.
Referenced by review on review.roomID = room.roomID.
Referenced by communication on communication.roomIDList = room.roomID.
Referenced by repairOrder on repairOrder.roomID = room.roomID.

programGroup#

Fields#

Field	Data Type	Field Type
programGroupID	Number	Normal
name	Text	Normal
modifyTS	TimeStamp	Normal
numRooms	Number	Normal
sleepCheckInterval	Time	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
transitionEmailInventoryID	Text	Normal
minAgeInMonths	Number	Normal
maxAgeInMonths	Number	Normal
date01Global	Date	Normal
date02Global	Date	Normal
prevAgeGroupProgramGroupID	Number	Normal
number01Global	Number	Normal
number02Global	Number	Normal
followUpEmailInventoryID	Text	Normal
dateList01Global	Text	Normal
omitFromForecast	Number	Normal
hideInScheduleDetail	Number	Normal
nameNotHidden	Text	Calculated
requireSleepCheck	Number	Normal
constantOne	Number	Calculated
infoSessionEmailInventoryID	Text	Normal

Relationships#

Referenced by roomProgramGroup on roomProgramGroup.programGroupID = programGroup.programGroupID.

roomProgramGroup#

Fields#

Field	Data Type	Field Type
roomProgramGroupID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
roomID	Number	Normal
programGroupID	Number	Normal
startDate	Date	Normal
endDate	Date	Normal
capacity	Number	Normal
programGroupNameStartDateEndDateDisplay	Text	Calculated
name	Unknown	Unknown

Relationships#

References room on roomProgramGroup.roomID = room.roomID.
References programGroup on roomProgramGroup.programGroupID = programGroup.programGroupID.

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 childAttendance on childAttendance.childID = child.childID.
Referenced by childEating on childEating.childID = child.childID.
Referenced by childSleep on childSleep.childID = child.childID.
Referenced by childDiaper on childDiaper.childID = child.childID.
Referenced by childAbsentDay on childAbsentDay.childID = child.childID.
Referenced by childIncident on childIncident.childID = child.childID.
Referenced by childIllness on childIllness.childID = child.childID.
Referenced by childParent on childParent.childID = child.childID.
Referenced by parentAccount on parentAccount.childID = child.childID.
Referenced by subsidyAccount on subsidyAccount.childID = child.childID.
Referenced by subsidyReceivable on subsidyReceivable.childIDGlobal = child.childID.
References doctor on child.primaryDoctorID = doctor.doctorID.
Referenced by childAllergy on childAllergy.childID = child.childID.
Referenced by childMedicalCondition on childMedicalCondition.childID = child.childID.
Referenced by childSpecialNeed on childSpecialNeed.childID = child.childID.
Referenced by childMedAuthorization on childMedAuthorization.childID = child.childID.
Referenced by communication on communication.childIDList = child.childID.
Referenced by email on email.childIDList = 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.

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#

References campus on mealSchedule.campusID = campus.campusID.
Referenced by childEating on childEating.effectiveDate = mealSchedule.mealDate.
References campus on mealSchedule.campusID = campus.campusID.

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.

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.

parent#

Fields#

Field	Data Type	Field Type
bankAccount	Text	Normal
bankNumber	Text	Normal
bankTimestamp	TimeStamp	Normal
bankTransit	Text	Normal
businessName	Text	Normal
amountDue	Number	Calculated
amountNet	Unknown	Unknown
amountDueNoRound	Number	Calculated
autoCharge	Number	Calculated
bankAuthorization	Unknown	Unknown
childrenNameList	Text	Calculated
childNameFirstLast	Unknown	Unknown
nameFirstLast	Text	Calculated
firstName	Text	Normal
lastName	Text	Normal
processDate	Date	Calculated
taxAmount	Number	Calculated
amountReceivedSum	Unknown	Unknown
txnCode	Text	Calculated
txnType	Text	Calculated
amountNetSum	Unknown	Unknown
cellPhone	Text	Normal
email	Text	Normal
modifyTS	TimeStamp	Normal
constantPersonal	Text	Calculated
homeAddress	Text	Normal
homePhone	Text	Normal
homeProvince	Text	Normal
homeZip	Text	Normal
parentID	Text	Normal
nameOnTax	Text	Normal
taxYear	Number	Normal
workAddress	Text	Normal
workPhone	Text	Normal
workProvince	Text	Normal
workZip	Text	Normal
constantOne	Number	Calculated
taxYearStart	Date	Calculated
taxYearEnd	Date	Calculated
homeCity	Text	Normal
workCity	Text	Normal
amountToDate	Number	Calculated
number01Global	Number	Normal
taxNumber	Number	Calculated
referenceID	Text	Calculated
subsidyAmountDue	Number	Calculated
total	Unknown	Unknown
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
crossJoin	Number	Normal
date01Global	Date	Normal
date02Global	Date	Normal
dateList01Global	Text	Normal
cellPhoneNumeric	Text	Calculated
homePhoneNumeric	Text	Calculated
workPhoneNumeric	Text	Calculated
amountDueNoRoundAbs	Number	Calculated
processDateCredit	Date	Calculated

Relationships#

Referenced by childParent on childParent.parentID = parent.parentID.
Referenced by mobileAppUserAccount on mobileAppUserAccount.parentID = parent.parentID.
Referenced by parentAccount on parentAccount.parentID = parent.parentID.
Referenced by subsidyAccount on subsidyAccount.parentID = parent.parentID.
Referenced by eftReceivable on eftReceivable.parentID = parent.parentID.

childParent#

Fields#

Field	Data Type	Field Type
childID	Text	Normal
parentID	Text	Normal
comment	Text	Normal
currBillableAmount	Number	Normal
modifyTS	TimeStamp	Normal
billableAmount	Unknown	Unknown
currBillableAmountSum	Number	Summary
childParentID	Text	Normal
relationship	Text	Normal
description	Unknown	Unknown
canPickup	Number	Normal
currDate	Date	Calculated
receiveEmail	Number	Normal
billDate	Date	Calculated
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
mobileAppPermissions	Text	Normal
role	Text	Normal
crossJoin	Number	Normal
familialRelationshipID	Text	Normal
mobileAppPermissionLevelID	Text	Normal
parentalRoleID	Text	Normal
billingZeroDate	Date	Normal

Relationships#

References child on childParent.childID = child.childID.
References parent on childParent.parentID = parent.parentID.
References familialRelationship on childParent.familialRelationshipID = familialRelationship.familialRelationshipID.
References parentalRole on childParent.parentalRoleID = parentalRole.parentalRoleID.
References mobileAppPermissionLevel on childParent.mobileAppPermissionLevelID = mobileAppPermissionLevel.mobileAppPermissionLevelID.
Referenced by mobileAppUserAccount on mobileAppUserAccount.parentID = childParent.parentID.

familialRelationship#

Fields#

Field	Data Type	Field Type
familialRelationshipID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
description	Text	Normal
sort	Number	Normal
descriptionCSS	Text	Calculated

Relationships#

Referenced by childParent on childParent.familialRelationshipID = familialRelationship.familialRelationshipID.

parentalRole#

Fields#

Field	Data Type	Field Type
createAccount	Text	Normal
createTS	TimeStamp	Normal
description	Text	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
parentalRoleID	Text	Normal

Relationships#

Referenced by childParent on childParent.parentalRoleID = parentalRole.parentalRoleID.

mobileAppPermissionLevel#

Fields#

Field	Data Type	Field Type
mobileAppPermissionLevelID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
description	Text	Normal

Relationships#

Referenced by childParent on childParent.mobileAppPermissionLevelID = mobileAppPermissionLevel.mobileAppPermissionLevelID.

mobileAppUserAccount#

Fields#

Field	Data Type	Field Type
mobileAppUserAccountID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
accountName	Text	Normal
parentID	Text	Normal
registrationParentID	Text	Normal

Relationships#

References parent on mobileAppUserAccount.parentID = parent.parentID.
References childParent on mobileAppUserAccount.parentID = childParent.parentID.

parentAccount#

Fields#

Field	Data Type	Field Type
amountReceived	Number	Normal
billDate	Date	Normal
dateIssued	Date	Normal
campusParentAccountBillingAnchorDate	Date	Calculated
amountLastPeriod	Number	Normal
amountNetSum	Number	Summary
showInReport	Number	Calculated
billingAnchorDate	Unknown	Unknown
amountCurrentPeriod	Number	Calculated
tillDate	Date	Normal
comment	Text	Normal
parentID	Text	Normal
paymentType	Text	Normal
amountCharged	Number	Normal
constantOne	Number	Calculated
fromDate	Date	Normal
parentAccountID	Text	Normal
childID	Text	Normal
regularOrExceptionBilling	Text	Normal
regularOrException	Unknown	Unknown
dateIssuedUnix	Text	Calculated
isLocked	Number	Normal
crossJoin	Number	Normal
billingTypeID	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
amountNet	Number	Calculated
amountReceivedSum	Number	Summary
amountChargedSum	Number	Summary
curPersistentID	Text	Calculated
isEFT	Number	Normal
creditReasonCodeID	Text	Normal
constantZero	Number	Calculated
countsAsFirstEFT	Number	Normal
registrationFeePaidID	Text	Normal

Relationships#

References parent on parentAccount.parentID = parent.parentID.
References child on parentAccount.childID = child.childID.

subsidyAccount#

Fields#

Field	Data Type	Field Type
isCredit	Number	Calculated
paymentType	Text	Normal
amount	Number	Normal
comment	Text	Normal
dateIssued	Date	Normal
constantZero	Number	Calculated
creditReceivedIndicator	Text	Calculated
total	Number	Calculated
charged	Number	Calculated
received	Number	Calculated
parentID	Text	Normal
childID	Text	Normal
childName	Text	Normal
childNameLastFirstMiddle	Unknown	Unknown
netAmount	Number	Normal
monthYearIssued	Text	Calculated
monthIssuedStart	Date	Calculated
monthIssuedEnd	Date	Calculated
amountSum	Number	Summary
constantOne	Number	Calculated
parentName	Text	Normal
nameFirstLast	Unknown	Unknown
subsidyAccountID	Text	Normal
campusID	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
crossJoin	Number	Normal

Relationships#

References parent on subsidyAccount.parentID = parent.parentID.
References child on subsidyAccount.childID = child.childID.
Referenced by subsidyReceivable on subsidyReceivable.subsidyAccountIDGlobal = subsidyAccount.subsidyAccountID.

subsidyReceivable#

Fields#

Field	Data Type	Field Type
ChildID	Text	Normal
ChildName	Text	Normal
AgeGroup	Text	Normal
ParentFeeA	Text	Normal
FDPaid	Text	Normal
PDPaid	Text	Normal
NetAmount	Number	Normal
subsidyAccountIDGlobal	Text	Normal
CareCode	Text	Normal
campusIDGlobal	Number	Normal
dateImported	Date	Normal
childIDGlobal	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
crossJoin	Number	Normal
subsidyReceivableID	Text	Normal

Relationships#

References subsidyAccount on subsidyReceivable.subsidyAccountIDGlobal = subsidyAccount.subsidyAccountID.
References campus on subsidyReceivable.campusIDGlobal = campus.campusID.
References child on subsidyReceivable.childIDGlobal = child.childID.

eftReceivable#

Fields#

Field	Data Type	Field Type
eftReceivableID	Text	Normal
processDate	Date	Normal
responseDate	Date	Normal
firstName	Text	Normal
lastName	Text	Normal
bankResponse	Text	Normal
status	Text	Normal
amount	Number	Normal
type	Text	Normal
invoice	Text	Normal
enteredBy	Text	Normal
reference	Text	Normal
systemChecked	Number	Normal
parentID	Text	Calculated
isParent	Number	Calculated
lastProcessDate	Date	Normal
bankResponseNumeric	Number	Calculated
transactionID	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
parentIDGlobal	Text	Normal
approver	Text	Normal

Relationships#

References parent on eftReceivable.parentID = parent.parentID.

doctor#

Fields#

Field	Data Type	Field Type
doctorID	Text	Normal
fullName	Text	Calculated
firstName	Text	Normal
lastName	Text	Normal
address	Text	Normal
city	Text	Normal
province	Text	Normal
zip	Text	Normal
workPhone	Text	Normal
email	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
workPhoneNumeric	Text	Calculated
addressCSS	Text	Calculated
cityCSS	Text	Calculated
emailCSS	Text	Calculated
firstNameCSS	Text	Calculated
lastNameCSS	Text	Calculated
provinceCSS	Text	Calculated
workPhoneCSS	Text	Calculated
zipCSS	Text	Calculated

Relationships#

Referenced by child on child.primaryDoctorID = doctor.doctorID.

allergen#

Fields#

Field	Data Type	Field Type
allergenID	Text	Normal
allergenName	Text	Normal
modifyTS	TimeStamp	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
isFoodRelated	Number	Normal
allergenNameFood	Text	Calculated
allowSubstitute	Number	Normal
allergenNameCSS	Text	Calculated
useForMilk	Number	Normal

Relationships#

Referenced by childAllergy on childAllergy.allergenID = allergen.allergenID.

childAllergy#

Fields#

Field	Data Type	Field Type
allergenID	Text	Normal
allergen	Text	Normal
allergenName	Unknown	Unknown
childID	Text	Normal
details	Text	Normal
modifyTS	TimeStamp	Normal
strategyToReduceRisk	Unknown	Unknown
constantOne	Number	Calculated
currDate	Date	Calculated
severity	Text	Normal
childAllergyID	Text	Normal
childIDListOf	Text	Summary
childSymptomIDGlobal	Text	Normal
childAllergySymptomIDGlobal	Text	Normal
childMedAuthorizationIDGlobal	Text	Normal
symptomList	Text	Calculated
symptom	Unknown	Unknown
crossJoin	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
constantIAP	Text	Calculated
isFoodRelated	Number	Normal
allergenNamePlusSubstitute	Text	Calculated
foodAndAllergySubstitute	Unknown	Unknown
allergenPlusActions	Text	Calculated
emergencyActionList	Text	Calculated
childAllergyCausativeAgentIDGlobal	Text	Normal
milk	Number	Normal
useForMilk	Unknown	Unknown
foodSubstituteDisplay	Text	Calculated
childAllergySubstituteID	Unknown	Unknown

Relationships#

References child on childAllergy.childID = child.childID.
References allergen on childAllergy.allergenID = allergen.allergenID.

childMedicalCondition#

Fields#

Field	Data Type	Field Type
medicalConditionID	Text	Normal
childID	Text	Normal
details	Text	Normal
modifyTS	TimeStamp	Normal
strategyToReduceRisk	Unknown	Unknown
constantOne	Number	Calculated
childMedicalConditionID	Text	Normal
symptomList	Text	Calculated
symptom	Unknown	Unknown
comments	Text	Normal
severity	Text	Normal
medicalCondition	Text	Normal
description	Unknown	Unknown
childMedicalConditionSymptomIDGlobal	Text	Normal
childMedAuthorizationIDGlobal	Text	Normal
childSymptomIDGlobal	Text	Normal
crossJoin	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
constantIMP	Text	Calculated
childMedicalConditionCausativeAgentIDGlobal	Text	Normal

Relationships#

References child on childMedicalCondition.childID = child.childID.

childSpecialNeed#

Fields#

Field	Data Type	Field Type
specialNeedID	Text	Normal
childID	Text	Normal
constantOne	Number	Calculated
childSpecialNeedID	Text	Normal
symptomList	Text	Calculated
symptom	Unknown	Unknown
comments	Text	Normal
severity	Text	Normal
specialNeed	Text	Normal
description	Unknown	Unknown
stepsToReduceWorsening	Text	Normal
modifyTS	TimeStamp	Normal
strategyToReduceRisk	Unknown	Unknown
crossJoin	Number	Normal
childSymptomIDGlobal	Text	Normal
childSpecialNeedSymptomIDGlobal	Text	Normal
childMedAuthorizationIDGlobal	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
childSupportISPID	Text	Normal
constantISP	Text	Calculated
childSpecialNeedCausativeAgentIDGlobal	Text	Normal

Relationships#

References child on childSpecialNeed.childID = child.childID.

childMedAuthorization#

Fields#

Field	Data Type	Field Type
administrationInstruction	Text	Normal
complete	Number	Normal
parentSignatureName	Text	Normal
supervisorSignatureName	Text	Normal
finished	Number	Normal
childID	Text	Normal
doctor	Text	Normal
doctorAddress	Text	Normal
dosageAmount	Text	Normal
endDate	Date	Normal
endDateGlobal	Date	Normal
startDateGlobal	Date	Normal
childMedAuthorizationID	Text	Normal
medication	Text	Normal
modifyTS	TimeStamp	Normal
medicationName	Unknown	Unknown
parentTakeMedHomeDaily	Text	Normal
prescription	Number	Normal
startDate	Date	Normal
storageInstruction	Text	Normal
storageInstructionOther	Text	Normal
constantOne	Number	Calculated
inComplete	Number	Calculated
constantOneCount	Number	Summary
nextTimestampDue	TimeStamp	Normal
approved	Number	Normal
currTime	Time	Calculated
expiryDate	Date	Normal
adminTimeList	Text	Calculated
dosageAdminTime	Unknown	Unknown
storageInstructionCombined	Text	Calculated
dateCompleted	Date	Normal
childIDListOf	Text	Summary
injectLocation	Text	Normal
childMedAuthorizationMedicationID	Text	Normal
isLocked	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
initialEMailSent	Number	Normal
dateCreated	Date	Calculated
crossJoin	Number	Normal
approvalDate	Date	Normal
activeValueListTitle	Text	Calculated
medicationPlusEndDate	Text	Calculated
expiryDateMax	Date	Calculated
signedBySupervisor	Number	Calculated
planSourceList	Text	Normal
attachedToPlan	Text	Calculated
childMedAdministrationIDGlobal	Text	Normal
supervisorSignatureMethod	Text	Normal
parentSignatureMethod	Text	Normal

Relationships#

References child on childMedAuthorization.childID = child.childID.
Referenced by childMedAdministration on childMedAdministration.childMedAuthorizationID = childMedAuthorization.childMedAuthorizationID.

childMedAdministration#

Fields#

Field	Data Type	Field Type
childMedAuthorizationID	Number	Normal
timestampAdministered	TimeStamp	Normal
dosageAdministered	Text	Normal
dosageAmount	Unknown	Unknown
staffID	Text	Normal
emailSent	Number	Normal
childMedAdministrationID	Text	Normal
notes	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
isLocked	Number	Normal
dateAdministered	Date	Calculated
crossJoin	Number	Normal
staffSignatureMethod	Text	Normal
staffSignatureName	Text	Normal

Relationships#

References childMedAuthorization on childMedAdministration.childMedAuthorizationID = childMedAuthorization.childMedAuthorizationID.
References staff on childMedAdministration.staffID = staff.staffID.

staff#

Fields#

Field	Data Type	Field Type
constantVSC	Text	Calculated
constantHealth	Text	Calculated
constantInitial	Text	Calculated
constantOne	Number	Calculated
constantOneCount	Number	Summary
constantPolicy	Text	Calculated
constantRECE	Text	Calculated
constantRecord	Text	Calculated
constantReview	Text	Calculated
constantTraining	Text	Calculated
constantYes	Text	Calculated
crossJoin	Number	Normal
date01Global	Date	Normal
date01GlobalMonth	Number	Calculated
date02Global	Date	Normal
date03Global	Date	Normal
date03GlobalMonth	Number	Calculated
date04Global	Date	Normal
date05Global	Date	Normal
date06Global	Date	Normal
number01Global	Number	Normal
ableDetail	Text	Normal
ablePhysically	Number	Normal
activeStaff	Text	Calculated
campusID	Number	Normal
staffNameFirstMiddleLast	Text	Calculated
medicationAndStorageLocation	Text	Normal
address	Text	Normal
allergiesMedicalConditions	Text	Normal
allQualsOK	Number	Normal
cclsCertificateDate	Date	Normal
cellPhone	Text	Normal
city	Text	Normal
comments	Text	Normal
vscConvictions	Text	Normal
vscConvictionsExplanation	Text	Normal
vscDocumentType	Text	Normal
vscExpiry	Date	Calculated
vscCompletionDate	Date	Normal
vscVerifiedDate	Date	Normal
vscReceiptReceived	Date	Normal
firstDayOfWork	Date	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
declarationConviction	Text	Normal
declarationConvictionExplanation	Text	Normal
declarationFormDate	Date	Normal
declarationFormExpiry	Date	Calculated
criminalCheckReason	Text	Normal
dob	Date	Normal
email	Text	Normal
emergencyContactName	Text	Normal
emergencyContactNumber	Text	Normal
emergencySupportPosition	Text	Normal
firstName	Text	Normal
modifyTS	TimeStamp	Normal
gender	Text	Normal
description	Unknown	Unknown
homePhone	Text	Normal
incompleteIllnessIncidentMedCount	Number	Normal
jobTitleID	Text	Normal
lastDayOfWork	Date	Normal
lastName	Text	Normal
lastPayrollTimecardApprovedDate	Date	Normal
lastRoomID	Number	Calculated
roomID	Unknown	Unknown
lastSupvTimecardApprovedDate	Date	Normal
lastTimestampIn	TimeStamp	Calculated
timestampIn	Unknown	Unknown
lastTimestampOut	TimeStamp	Calculated
timestampOut	Unknown	Unknown
medicalNotes	Text	Normal
mentallyCapable	Number	Normal
modifyAccount	Text	Normal
middleName	Text	Normal
onHealthSafetyCommittee	Number	Normal
payrollPIN	Binary	Normal
payTypeID	Text	Normal
policeForce	Text	Normal
PPE	Date	Normal
primaryRoomID	Number	Normal
professionalMisconduct	Text	Normal
professionalMisconductComment	Text	Normal
province	Text	Normal
reasonForTermination	Text	Normal
receExpiry	Date	Normal
receRegistration	Text	Normal
SIN	Text	Normal
healthActionsToTake	Text	Normal
staffID	Text	Normal
uploadedToCCLS	Date	Normal
zipCode	Text	Normal
text01Global	Text	Normal
text02Global	Text	Normal
rovingStaff	Number	Normal
receVerificationScreenShotModifyTS	TimeStamp	Normal
dateList01Global	Text	Normal
timecardOnly	Number	Normal
jobDeveloperNotes	Text	Normal
createdOutsideProcess	Number	Normal
createdOutsideProcessEmailSent	Number	Normal
baseHourlyRate	Number	Normal
baseSalary	Number	Normal
provincialHourlyEnhancement	Number	Normal
provincialHourlyGrant	Number	Normal
provincialSalaryEnhancement	Number	Normal
provincialSalaryGrant	Number	Normal
activeNonRovingNonTimecardOnlyStaff	Text	Calculated
typeOfDeparture	Text	Normal
receVerifiedExpiry	Date	Calculated
roeReferenceNumber	Text	Normal
primaryOrLastRoomID	Number	Calculated
date07Global	Date	Normal
retainHoursOverRatio	Number	Normal
vscReceiptExpiry	Date	Calculated
genderID	Text	Normal
jobCandidateID	Text	Normal
SINObscured	Text	Calculated
payrollPINBase64	Text	Normal
vscLastCheckAccountName	Text	Normal
vscLastCheckDate	Date	Normal
staffTransferID	Text	Normal
constantZero	Number	Calculated
staffTypeOfDepartureID	Text	Normal
staffPortalPermissionLevelID	Text	Normal
staffPortalPermissions	Text	Normal
workEmail	Text	Normal
workPhone	Text	Normal
workPhoneDisplay	Text	Calculated
phone	Unknown	Unknown
phoneExtension	Unknown	Unknown
calculateStatutoryHours	Number	Normal
cellPhoneNumeric	Text	Calculated
homePhoneNumeric	Text	Calculated
workPhoneNumeric	Text	Calculated

Relationships#

Referenced by childMedAdministration on childMedAdministration.staffID = staff.staffID.
References campus on staff.campusID = campus.campusID.
References room on staff.primaryRoomID = room.roomID.
References staffPortalPermissionLevel on staff.staffPortalPermissionLevelID = staffPortalPermissionLevel.staffPortalPermissionLevelID.
Referenced by staffPortalUserAccount on staffPortalUserAccount.staffID = staff.staffID.
Referenced by staffPortalUserVerificationCode on staffPortalUserVerificationCode.staffID = staff.staffID.
Referenced by staffAttendance on staffAttendance.staffID = staff.staffID.
Referenced by staffShiftAssignment on staffShiftAssignment.staffID = staff.staffID.
Referenced by staffTimeOffRequest on staffTimeOffRequest.staffID = staff.staffID.
Referenced by review on review.staffID = staff.staffID.
Referenced by communication on communication.originatingStaffID = staff.staffID.
Referenced by email on email.staffIDList = staff.staffID.
Referenced by repairOrder on repairOrder.reportedByStaffID = staff.staffID.
Referenced by healthSafetyMeetingStaff on healthSafetyMeetingStaff.staffID = staff.staffID.

staffPortalPermissionLevel#

Fields#

Field	Data Type	Field Type
staffPortalPermissionLevelID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
description	Text	Normal
descriptionCSS	Text	Calculated

Relationships#

Referenced by staff on staff.staffPortalPermissionLevelID = staffPortalPermissionLevel.staffPortalPermissionLevelID.

staffPortalUserAccount#

Fields#

Field	Data Type	Field Type
staffPortalUserAccountID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
accountName	Text	Normal
staffID	Text	Normal
newHireID	Text	Normal

Relationships#

References staff on staffPortalUserAccount.staffID = staff.staffID.

staffPortalUserVerificationCode#

Fields#

Field	Data Type	Field Type
staffPortalUserVerificationCodeID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
staffID	Text	Normal
newHireID	Text	Normal
verificationCode	Binary	Normal

Relationships#

References staff on staffPortalUserVerificationCode.staffID = staff.staffID.

staffAttendance#

Fields#

Field	Data Type	Field Type
staffID	Text	Normal
roomID	Number	Normal
timestampIn	TimeStamp	Normal
timestampOut	TimeStamp	Normal
notes	Text	Normal
dateIn	Date	Calculated
error	Number	Calculated
timeIn	Time	Calculated
timeOut	Time	Calculated
constantOne	Number	Calculated
timestampOutMax	TimeStamp	Calculated
staffAttendanceID	Text	Normal
constantOneCount	Number	Summary
campusID	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
systemNote	Text	Normal
SIN	Text	Normal
dateInUnix	Text	Calculated

Relationships#

References staff on staffAttendance.staffID = staff.staffID.
References room on staffAttendance.roomID = room.roomID.

staffShiftAssignment#

Fields#

Field	Data Type	Field Type
staffShiftAssignmentID	Text	Normal
staffShiftInventoryID	Text	Normal
staffID	Text	Normal
shiftDate	Date	Normal
description	Text	Normal
firstName	Unknown	Unknown
shortDescription	Unknown	Unknown
roomID	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
constantOne	Number	Calculated
sort	Number	Normal
shiftDateUnix	Text	Calculated
crossJoin	Number	Normal

Relationships#

References staff on staffShiftAssignment.staffID = staff.staffID.
References room on staffShiftAssignment.roomID = room.roomID.

staffTimeOffRequest#

Fields#

Field	Data Type	Field Type
approved	Number	Normal
fromDate	Date	Normal
insufficentNotice	Text	Normal
requestDate	Date	Normal
staffID	Text	Normal
toDate	Date	Normal
staffTimeOffRequestID	Text	Normal
fromYear	Number	Calculated
toYear	Number	Calculated
eMailSentToPayroll	Text	Normal
supervisorID	Number	Normal
approvedDate	Date	Normal
campusID	Number	Normal
requestReason	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
staffTimeOffTypeID	Text	Normal
primaryRoomID	Number	Normal
isLocked	Number	Normal
timeBankUpdated	Number	Normal
noncompliance	Text	Normal
relatedStaffTimeOffTypeID	Text	Normal
crossJoin	Number	Normal
approvalAccount	Text	Normal
staffSignatureName	Text	Normal
staffSignatureMethod	Text	Normal
supervisorSignatureMethod	Text	Normal
supervisorSignatureName	Text	Normal
incompleteRequest	Number	Normal
newRequestEmailSent	Number	Normal

Relationships#

References staff on staffTimeOffRequest.staffID = staff.staffID.

review#

Fields#

Field	Data Type	Field Type
complete	Text	Normal
endDate	Date	Normal
score	Number	Calculated
answerSum	Unknown	Unknown
answerCount	Unknown	Unknown
startDate	Date	Normal
comments	Text	Normal
finalReviewDate	Date	Normal
reviewID	Number	Normal
staffID	Text	Normal
constantOne	Number	Calculated
reviewTypeID	Text	Normal
vscOption	Text	Normal
vscExplanation	Text	Normal
currentMonth	Number	Calculated
roomID	Number	Normal
crossJoin	Number	Normal
meetingDate	Date	Normal
meetingTime	Time	Normal
cbm	Number	Normal
text01Global	Text	Normal
isLocked	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
reviewType	Text	Normal
vscMedicalScreenStatement	Text	Normal
policyFailureStatement	Text	Normal
policyReadAndUnderstoodStatement	Text	Normal
wageIncreaseStatement	Text	Normal
staffSignatureMethod	Text	Normal
staffSignatureName	Text	Normal
supervisorSignatureMethod	Text	Normal
supervisorSignatureName	Text	Normal

Relationships#

References staff on review.staffID = staff.staffID.
References reviewType on review.reviewTypeID = reviewType.reviewTypeID.
References room on review.roomID = room.roomID.
Referenced by reviewAnswer on reviewAnswer.reviewID = review.reviewID.

reviewType#

Fields#

Field	Data Type	Field Type
reviewTypeID	Text	Normal
reviewType	Text	Normal
modifyTS	TimeStamp	Normal
appliesTo	Text	Normal
omitScore	Number	Normal
omitRaiseTable	Number	Normal
cbm	Number	Normal
adminOnly	Number	Normal
oneTime	Number	Normal
requiredDaysAfterFirstDay	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
vscMedicalScreenStatement	Text	Normal
policyFailureStatement	Text	Normal
policyReadAndUnderstoodStatement	Text	Normal
wageIncreaseStatement	Text	Normal
affectsPayroll	Number	Normal
minPayrollHours	Number	Normal
reviewTypeCSS	Text	Calculated
wageIncreaseStatementCSS	Text	Calculated
policyReadAndUnderstoodStatementCSS	Text	Calculated
policyFailureStatementCSS	Text	Calculated
vscMedicalScreenStatementCSS	Text	Calculated

Relationships#

Referenced by review on review.reviewTypeID = reviewType.reviewTypeID.

reviewAnswer#

Fields#

Field	Data Type	Field Type
answer	Number	Normal
answerCount	Number	Summary
answerSum	Number	Summary
comment	Text	Normal
constantOne	Number	Calculated
policyList	Text	Calculated
policyName	Unknown	Unknown
reviewAnswerID	Text	Normal
reviewID	Number	Normal
reviewQuestionID	Number	Normal
sort	Number	Normal
timestampAssessed	TimeStamp	Normal
followUpComment	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
isLocked	Number	Normal
reviewTypeID	Text	Normal
reviewQuestionAreaID	Text	Normal
question	Text	Normal
score1Meaning	Text	Normal
score2Meaning	Text	Normal
score3Meaning	Text	Normal
score4Meaning	Text	Normal
reviewQuestionArea	Text	Normal

Relationships#

References review on reviewAnswer.reviewID = review.reviewID.

communication#

Fields#

Field	Data Type	Field Type
communicationID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
roomIDList	Text	Normal
referencedStaffIDList	Text	Normal
childIDList	Text	Normal
message	Text	Normal
isLocked	Number	Normal
crossJoin	Number	Normal
createDate	Date	Normal
createTime	Time	Normal
repeatFlag	Number	Normal
repeatType	Text	Normal
repeatExpiry	Date	Normal
originatingStaffID	Text	Normal
childNameList	Text	Calculated
childNameFirstLast	Unknown	Unknown
referencedStaffNameList	Text	Calculated
staffNameFirstMiddleLast	Unknown	Unknown
roomNameList	Text	Calculated
name	Unknown	Unknown
childDataChangeEventID	Text	Normal
systemGeneratedFlag	Number	Normal
createFirstOfMonth	Date	Calculated
originatingStaffName	Text	Calculated
campusID	Number	Normal
childIllnessID	Text	Normal
childIncidentID	Text	Normal
complaintID	Text	Normal

Relationships#

References child on communication.childIDList = child.childID.
References room on communication.roomIDList = room.roomID.
References staff on communication.originatingStaffID = staff.staffID.

email#

Fields#

Field	Data Type	Field Type
bodyPlain	Text	Normal
constantOne	Number	Calculated
emailID	Number	Normal
mailFrom	Text	Normal
result	Text	Normal
sendDate	Date	Normal
sentFlag	Number	Normal
subject	Text	Normal
bodyHTML	Text	Normal
createDate	Date	Normal
recipientTypeGlobal	Text	Normal
sendGridTemplateID	Text	Normal
crossJoin	Number	Normal
supervisorAlertSent	Number	Normal
supervisorAlertSend	Number	Normal
emailInventoryID	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
dashboardItemID	Text	Normal
suppressHTML	Number	Normal
childIDList	Text	Normal
staffIDList	Text	Normal
childNameList	Text	Calculated
childNameFirstLast	Unknown	Unknown
staffNameList	Text	Calculated
staffNameFirstMiddleLast	Unknown	Unknown
createFirstOfMonth	Date	Calculated
onSuccessScriptName	Text	Normal
onSuccessScriptParam	Text	Normal
onSuccessScriptParamBad	Number	Calculated
onSuccessScriptResult	Text	Normal
emailTransferID	Text	Normal
campusID	Number	Normal
sentByAccount	Text	Normal
tourChildIDList	Text	Normal
registrationChildIDList	Text	Normal
variableData	Text	Normal

Relationships#

References child on email.childIDList = child.childID.
References staff on email.staffIDList = staff.staffID.
Referenced by emailAttachment on emailAttachment.emailID = email.emailID.

emailAttachment#

Fields#

Field	Data Type	Field Type
emailAttachmentID	Text	Normal
filename	Text	Normal
constantOne	Number	Calculated
emailID	Number	Normal
fileSize	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal

Relationships#

References email on emailAttachment.emailID = email.emailID.

repairOrder#

Fields#

Field	Data Type	Field Type
reportedByStaffID	Text	Normal
reportedTo	Text	Normal
timestampReported	TimeStamp	Normal
detail	Text	Normal
actionPlan	Text	Normal
timeLine	Text	Normal
dateCompleted	Date	Normal
location	Text	Normal
description	Unknown	Unknown
campusID	Number	Normal
repairOrderID	Text	Normal
yearReported	Number	Calculated
emailSentToMaintenance	Date	Normal
complete	Number	Calculated
healthSafetyChecklistItemIDGlobal	Text	Normal
crossJoin	Number	Normal
playspaceID	Text	Normal
roomID	Number	Normal
completedBy	Text	Normal
room	Text	Normal
name	Unknown	Unknown
roomOtherFlag	Number	Normal
allergenName	Unknown	Unknown
playspace	Text	Normal
playspaceName	Unknown	Unknown
playspaceOtherFlag	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
checkedByStaffName	Text	Normal
playspaceInventoryID	Text	Normal
maintenanceChecklistInventoryID	Text	Normal
locationDetail	Text	Normal
repairOrderLocationID	Text	Normal
locationPlusDetail	Text	Calculated

Relationships#

References campus on repairOrder.campusID = campus.campusID.
References room on repairOrder.roomID = room.roomID.
References staff on repairOrder.reportedByStaffID = staff.staffID.
Referenced by healthSafetyChecklistItem on healthSafetyChecklistItem.repairOrderID = repairOrder.repairOrderID.

healthSafetyMeeting#

Fields#

Field	Data Type	Field Type
campusID	Number	Normal
callToOrderTimestamp	TimeStamp	Normal
adoptionOfAgenda	Text	Normal
meetingAdjournedAtDate	Date	Normal
nextMeetingDate	Date	Normal
nextMeetingLocation	Text	Normal
meetingTime	Time	Normal
meetingLocation	Text	Normal
meetingDate	Date	Normal
oldBusiness	Text	Normal
healthSafetyMeetingID	Text	Normal
constantOne	Number	Calculated
monthYearDisplay	Text	Calculated
previousHealthSafetyMeetingIDGlobal	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
nextMeetingTime	Time	Normal
meetingAdjournedAtTime	Time	Normal
crossJoin	Number	Normal

Relationships#

References campus on healthSafetyMeeting.campusID = campus.campusID.
Referenced by healthSafetyMeetingStaff on healthSafetyMeetingStaff.healthSafetyMeetingID = healthSafetyMeeting.healthSafetyMeetingID.

healthSafetyMeetingStaff#

Fields#

Field	Data Type	Field Type
healthSafetyMeetingID	Text	Normal
healthSafetyMeetingStaffID	Text	Normal
staffID	Text	Normal
response	Text	Normal
dateApproved	Date	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
staffOtherFlag	Number	Normal
staffName	Text	Normal
staffNameFirstMiddleLast	Unknown	Unknown

Relationships#

References healthSafetyMeeting on healthSafetyMeetingStaff.healthSafetyMeetingID = healthSafetyMeeting.healthSafetyMeetingID.
References staff on healthSafetyMeetingStaff.staffID = staff.staffID.

healthSafetyChecklist#

Fields#

Field	Data Type	Field Type
healthSafetyChecklistID	Text	Normal
checklistFrequency	Text	Normal
checkDate	Date	Normal
comments	Text	Normal
campusID	Number	Normal
timestampCompleted	TimeStamp	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
staffSignatureMethod	Text	Normal
staffSignatureName	Text	Normal

Relationships#

References campus on healthSafetyChecklist.campusID = campus.campusID.
Referenced by healthSafetyChecklistItem on healthSafetyChecklistItem.healthSafetyChecklistID = healthSafetyChecklist.healthSafetyChecklistID.

healthSafetyChecklistItem#

Fields#

Field	Data Type	Field Type
healthSafetyChecklistItemID	Text	Normal
healthSafetyInventoryID	Text	Normal
issues	Text	Normal
healthSafetyChecklistID	Text	Normal
isOkay	Number	Normal
healthSafetyAreaID	Text	Normal
repairOrderCreated	Number	Calculated
repairOrderID	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
constantHealthSafety	Text	Calculated
description	Text	Normal
crossJoin	Number	Normal

Relationships#

References healthSafetyChecklist on healthSafetyChecklistItem.healthSafetyChecklistID = healthSafetyChecklist.healthSafetyChecklistID.
References repairOrder on healthSafetyChecklistItem.repairOrderID = repairOrder.repairOrderID.

Notes#

The click targets are internal Markdown anchors. Whether the Mermaid nodes themselves are clickable depends on the renderer honoring Mermaid click ... href actions.
The per-domain files stay narrower and treat repeated cross-domain tables as linked canonical references rather than duplicating every field table everywhere.