Health And Authorizations ER Diagram#

This view focuses on allergies, medical conditions, authorizations, medication administration, and health-linked child context.

Included Tables#

%%{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 childMedAuthorization { childMedAuthorizationID : Text childID : Text administrationInstruction : Text } class childMedAdministration { childMedAdministrationID : Text childMedAuthorizationID : Number staffID : Text } class childSpecialNeed { childSpecialNeedID : Text childID : Text description : Unknown } 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

Tables#

child#

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

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.

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.

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.

staff#

Primary table details live in staff under Workforce And Reviews ER Diagram.

Notes#

  • The export contains many filtered health relations for draft, archive, and approval-state variants. This diagram shows the stable operational records only.
  • Several authorization workflows also branch to symptom and emergency-action tables that are omitted here for readability.