Enrollment And Waitlist ER Diagram#

This view covers tours, pre-admission child records, registration guardians, and registration-time scheduling and billing setup.

Included Tables#

`tour`
`tourChild`
`tourChildContact`
`registrationParent`
`registrationChild`
`registrationChildParent`
`registrationChildSchedule`
`registrationParentAccount`
`registrationFeeCost`
`schedule`
`campus`

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class tour { tourID : Text message : Text campusID : Number } class tourChild { tourChildID : Text tourID : Text firstName : Text lastName : Text message : Text } class tourChildContact { tourChildContactID : Text tourChildID : Text message : Text } class registrationParent { registrationParentID : Text parentID : Text description : Unknown firstName : Text lastName : Text } class registrationChild { registrationChildID : Text tourChildID : Text primaryParentID : Number primaryRegistrationParentID : Text campusID : Number description : Unknown } class registrationChildParent { registrationChildParentID : Text registrationChildID : Text registrationParentID : Text description : Unknown firstName : Text lastName : Text } class registrationChildSchedule { registrationChildScheduleID : Text registrationChildID : Text scheduleID : Number } class registrationParentAccount { registrationParentAccountID : Text registrationChildID : Text amountReceived : Number } class registrationFeeCost { registrationFeeCostID : Text campusID : Number effectiveDate : Date } class schedule { scheduleID : Number name : Text fridayCount : Number } class campus { campusID : Number name : Text accountNumber : Text } tourChild --> tour : tourID = tourID tourChildContact --> tourChild : tourChildID = tourChildID registrationChild --> tourChild : tourChildID = tourChildID registrationChild --> registrationParent : primaryParentID = parentID / primaryRegistrationParentID = registrationParentID registrationChild --> campus : campusID = campusID registrationChildParent --> registrationChild : registrationChildID = registrationChildID registrationChildParent --> registrationParent : registrationParentID = registrationParentID registrationChildSchedule --> registrationChild : registrationChildID = registrationChildID registrationChildSchedule --> schedule : scheduleID = scheduleID registrationParentAccount --> registrationChild : registrationChildID = registrationChildID registrationFeeCost --> campus : campusID = campusID

Tables#

tour#

Fields#

Field	Data Type	Field Type
tourID	Text	Normal
campusID	Number	Normal
tourDate	Date	Normal
tourTime	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
staffID	Text	Normal
parentEmail	Text	Normal
parentFirstName	Text	Normal
parentPhone	Text	Normal
complete	Number	Normal
message	Text	Normal
childAgeList	Text	Calculated
childAgeDisplay	Unknown	Unknown
preferredStartList	Text	Calculated
preferredStartDateUnix	Unknown	Unknown
formSubmissionID	Text	Normal
canceled	Number	Normal
closed	Number	Calculated
resultChoiceList	Text	Normal
resultChoiceListDisplay	Text	Calculated
crossJoin	Number	Normal
earliestPreferredStartDate	Text	Calculated
parentLastName	Text	Normal
howHeard	Text	Normal
howHeardDetail	Text	Normal
parentFullName	Text	Calculated
staffName	Text	Normal
staffNameFirstMiddleLast	Unknown	Unknown
tourIDCount	Number	Summary
tourQuestionText	Text	Normal
inPersonOrVirtual	Text	Normal
lastTextMessageState	Text	Normal

Relationships#

Referenced by tourChild on tourChild.tourID = tour.tourID.

tourChild#

Fields#

Field	Data Type	Field Type
childAge	Number	Calculated
preferredStartDate	Date	Normal
childDOB	Date	Normal
childAgeDisplay	Text	Calculated
constantOne	Number	Calculated
constantZero	Number	Calculated
createAccount	Text	Normal
createTS	TimeStamp	Normal
declineReason	Text	Normal
earlyStartDate	Date	Normal
preferredStartDateUnix	Text	Calculated
startEarlier	Number	Normal
firstName	Text	Normal
modifyTS	TimeStamp	Normal
infoSessionComplete	Number	Normal
lastName	Text	Normal
message	Text	Normal
modifyAccount	Text	Normal
reminderEmailDate	Date	Normal
resultChoice	Text	Normal
scheduleID	Number	Normal
thankYouEmailSent	Number	Normal
tourChildID	Text	Normal
tourChildNameFirstLast	Text	Calculated
tourID	Text	Normal

Relationships#

References tour on tourChild.tourID = tour.tourID.
Referenced by tourChildContact on tourChildContact.tourChildID = tourChild.tourChildID.
Referenced by registrationChild on registrationChild.tourChildID = tourChild.tourChildID.

tourChildContact#

Fields#

Field	Data Type	Field Type
message	Text	Normal
tourChildID	Text	Normal
tourChildContactID	Text	Normal
contactedBy	Text	Normal
contactDate	Date	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
response	Text	Normal
emailID	Number	Normal

Relationships#

References tourChild on tourChildContact.tourChildID = tourChild.tourChildID.

registrationParent#

Fields#

Field	Data Type	Field Type
bankAccount	Text	Normal
bankNumber	Text	Normal
bankTimestamp	TimeStamp	Normal
bankTransit	Text	Normal
businessName	Text	Normal
cellPhone	Text	Normal
email	Text	Normal
firstName	Text	Normal
modifyTS	TimeStamp	Normal
homeAddress	Text	Normal
homePhone	Text	Normal
homeProvince	Text	Normal
homeZip	Text	Normal
parentID	Text	Normal
lastName	Text	Normal
workAddress	Text	Normal
workPhone	Text	Normal
workProvince	Text	Normal
workZip	Text	Normal
constantOne	Number	Calculated
homeCity	Text	Normal
workCity	Text	Normal
registrationChildID	Text	Normal
billableAmount	Number	Normal
relationship	Text	Normal
description	Unknown	Unknown
registrationParentID	Text	Normal
nameFirstLast	Text	Calculated
isPrimary	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
receiveEmail	Number	Normal
canPickup	Number	Normal
mobileAppPermissions	Text	Normal
role	Text	Normal
crossJoin	Number	Normal
familialRelationshipID	Text	Normal
mobileAppPermissionLevelID	Text	Normal
parentalRoleID	Text	Normal
registrationParentPossibleIDList	Text	Normal
homePhoneNumeric	Text	Calculated
cellPhoneNumeric	Text	Calculated
workPhoneNumeric	Text	Calculated

Relationships#

Referenced by registrationChild on registrationChild.primaryParentID = registrationParent.parentID; registrationChild.primaryRegistrationParentID = registrationParent.registrationParentID.
Referenced by registrationChildParent on registrationChildParent.registrationParentID = registrationParent.registrationParentID.

registrationChild#

Fields#

Field	Data Type	Field Type
registrationChildID	Text	Normal
childID	Text	Normal
dob	Date	Normal
firstName	Text	Normal
gender	Text	Normal
description	Unknown	Unknown
lastName	Text	Normal
custodyOrder	Number	Normal
campusID	Number	Normal
immunizationRecordsReligion	Number	Normal
immunizationRecordsSubmittedToCompany	Number	Normal
specialNeeds	Text	Normal
primaryDoctorID	Text	Normal
primaryParentID	Number	Normal
noHealthHistory	Number	Normal
noImmunize	Number	Normal
childAuthorizationIDGlobal	Text	Normal
nameFirstLast	Text	Calculated
primaryRegistrationParentID	Text	Normal
childAllergyIDGlobal	Text	Normal
childSymptomIDGlobal	Text	Normal
constantAllergy	Text	Calculated
constantMedical	Text	Calculated
preferredStartDate	Date	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
tourChildID	Text	Normal
ageInMonths	Number	Calculated
date03Global	Unknown	Unknown
createdOutsideProcess	Number	Normal
createdOutsideProcessEmailSent	Number	Normal
childAgeDisplay	Text	Calculated
startEarlier	Number	Normal
constantZero	Number	Calculated
middleName	Text	Normal
childNameFirstLast	Text	Calculated
allergyEntryRequired	Number	Normal
foodRestrictionEntryRequired	Number	Normal
medicalConditionEntryRequired	Number	Normal
feedingPracticeEntryRequired	Number	Normal
hasAllergy	Number	Normal
hasMedicalCondition	Number	Normal
hasSpecialNeed	Number	Normal
hasFoodRestriction	Number	Normal
constantSupport	Text	Calculated
allergyListHTML	Text	Normal
medicalListHTML	Text	Normal
supportListHTML	Text	Normal
genderID	Text	Normal
registrationDate	Date	Normal
doctorAddr	Text	Normal
doctorCity	Text	Normal
doctorFirstName	Text	Normal
doctorLastName	Text	Normal
doctorPhone	Text	Normal
doctorPost	Text	Normal
doctorProv	Text	Normal
registrationQueueID	Text	Normal
doctorPossibleIDList	Text	Normal
crossJoin	Number	Normal
doctorNameDisplay	Text	Calculated
doctorID	Unknown	Unknown
fullName	Unknown	Unknown
dataEntryIncomplete	Number	Calculated
complete	Unknown	Unknown
registrationChildValidationResultID	Unknown	Unknown
homeRoomID	Unknown	Unknown
programGroupID	Unknown	Unknown
scheduleID	Unknown	Unknown
billableAmountSum	Unknown	Unknown
isEmergencyContact	Unknown	Unknown
isParentGuardian	Unknown	Unknown
registrationFeeCharged	Unknown	Unknown
registrationFeePaymentMethodID	Unknown	Unknown
custodyDoc	Unknown	Unknown
allergen	Unknown	Unknown
registrationChildAllergyID	Unknown	Unknown
severity	Unknown	Unknown
foodRestriction	Unknown	Unknown
registrationChildFoodRestrictionID	Unknown	Unknown
medicalCondition	Unknown	Unknown
registrationChildMedicalConditionID	Unknown	Unknown
specialNeed	Unknown	Unknown
registrationChildSpecialNeedID	Unknown	Unknown
registrationChildInfoSessionID	Unknown	Unknown
infoSessionEmailSent	Unknown	Unknown
registrationChildIntakeAssessmentID	Unknown	Unknown
infoSessionDateListDisplay	Text	Calculated
sessionDateUnix	Unknown	Unknown
allergyAndFoodPlanAuthorizationTimestamp	TimeStamp	Normal
allergyAndFoodPlanVerbiage	Text	Normal
registrationID	Text	Normal
earlyStartDate	Date	Normal

Relationships#

References tourChild on registrationChild.tourChildID = tourChild.tourChildID.
References registrationParent on registrationChild.primaryParentID = registrationParent.parentID; registrationChild.primaryRegistrationParentID = registrationParent.registrationParentID.
References campus on registrationChild.campusID = campus.campusID.
Referenced by registrationChildParent on registrationChildParent.registrationChildID = registrationChild.registrationChildID.
Referenced by registrationChildSchedule on registrationChildSchedule.registrationChildID = registrationChild.registrationChildID.
Referenced by registrationParentAccount on registrationParentAccount.registrationChildID = registrationChild.registrationChildID.

registrationChildParent#

Fields#

Field	Data Type	Field Type
childID	Text	Normal
parentID	Text	Normal
comment	Text	Normal
childParentID	Text	Normal
relationship	Text	Normal
description	Unknown	Unknown
canPickup	Number	Normal
registrationChildID	Text	Normal
registrationParentID	Text	Normal
billableAmount	Number	Normal
billableAmountSum	Number	Summary
receiveEmail	Number	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
mobileAppPermissions	Text	Normal
role	Text	Normal
isEmergencyContact	Number	Calculated
isParentGuardian	Number	Calculated
crossJoin	Number	Normal
familialRelationshipID	Text	Normal
mobileAppPermissionLevelID	Text	Normal
parentalRoleID	Text	Normal
registrationChildParentID	Text	Calculated
parentPossibleIDList	Text	Normal
businessName	Text	Normal
cellPhone	Text	Normal
email	Text	Normal
firstName	Text	Normal
homeAddress	Text	Normal
homeCity	Text	Normal
homePhone	Text	Normal
homeProvince	Text	Normal
homeZip	Text	Normal
lastName	Text	Normal
nameFirstLast	Text	Calculated
registrationParentPossibleIDList	Text	Normal
workAddress	Text	Normal
workCity	Text	Normal
workPhone	Text	Normal
workPhoneNumeric	Text	Calculated
workProvince	Text	Normal
workZip	Text	Normal
bankAccount	Text	Normal
bankNumber	Text	Normal
bankTimestamp	TimeStamp	Normal
bankTransit	Text	Normal

Relationships#

References registrationChild on registrationChildParent.registrationChildID = registrationChild.registrationChildID.
References registrationParent on registrationChildParent.registrationParentID = registrationParent.registrationParentID.

registrationChildSchedule#

Fields#

Field	Data Type	Field Type
registrationChildID	Text	Normal
homeRoomID	Number	Normal
scheduleID	Number	Normal
registrationChildScheduleID	Text	Normal
programGroupID	Number	Normal
monday	Number	Normal
tuesday	Number	Normal
wednesday	Number	Normal
thursday	Number	Normal
friday	Number	Normal
modifyTS	TimeStamp	Normal
wednesdaySum	Number	Calculated
tuesdaySum	Number	Calculated
thursdaySum	Number	Calculated
mondaySum	Number	Calculated
fridaySum	Number	Calculated
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
saturday	Number	Normal
saturdaySum	Number	Calculated
sunday	Number	Normal
sundaySum	Number	Calculated

Relationships#

References registrationChild on registrationChildSchedule.registrationChildID = registrationChild.registrationChildID.
References schedule on registrationChildSchedule.scheduleID = schedule.scheduleID.

registrationParentAccount#

Fields#

Field	Data Type	Field Type
amountReceived	Number	Normal
billDate	Date	Normal
dateIssued	Date	Normal
billingAnchorDate	Unknown	Unknown
tillDate	Date	Normal
comment	Text	Normal
registrationParentID	Text	Normal
paymentType	Text	Normal
amountCharged	Number	Normal
constantOne	Number	Calculated
fromDate	Date	Normal
registrationParentAccountID	Text	Normal
registrationChildID	Text	Normal
regularOrExceptionBilling	Text	Normal
regularOrException	Unknown	Unknown
dateIssuedUnix	Text	Calculated
crossJoin	Number	Normal
billingTypeID	Text	Normal
createAccount	Text	Normal
createTS	TimeStamp	Normal
modifyAccount	Text	Normal
modifyTS	TimeStamp	Normal
amountNet	Number	Calculated
curPersistentID	Text	Calculated
isEFT	Number	Normal
creditReasonCodeID	Text	Normal
constantZero	Number	Calculated
registrationFeePaidID	Text	Normal
parentID	Number	Normal

Relationships#

References registrationChild on registrationParentAccount.registrationChildID = registrationChild.registrationChildID.

registrationFeeCost#

Fields#

Field	Data Type	Field Type
registrationFeeCostID	Text	Normal
createTS	TimeStamp	Normal
createAccount	Text	Normal
modifyTS	TimeStamp	Normal
modifyAccount	Text	Normal
campusID	Number	Normal
effectiveDate	Date	Normal
tillDate	Date	Normal
registrationFeeRegular	Number	Normal
registrationFeeSibling	Number	Normal
registrationFeeRegularCWELCC	Number	Normal
registrationFeeSiblingCWELCC	Number	Normal

Relationships#

References campus on registrationFeeCost.campusID = campus.campusID.

schedule#

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

campus#

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

Notes#

The registration schema fans out into many health and authorization sub-records. This diagram stays on the admissions spine only.
registrationChildSchedule.homeRoomID exists on the table, but the schedule-to-room operational relationship is easier to read from the children and organization diagrams.