Skip to main content

Data Export - Contact Details Quality

Contact Details Quality​

Generated by the Bulk Data Export system

The order of columns is subject to change. When parsing files, please ensure to use headers rather than positional parsing to ensure you are reading the data correctly.

What this export contains​

A data-quality export listing every patient and related person at your institute and whether the minimum contact details needed for measurement (email or phone) are present. For child patients it also shows caregiver coverage. Use it to find and fix gaps before they block measurement.

Example questions this export can answer​

  • Find patients or caregivers missing an email or phone number
  • Check that child patients have a caregiver on file
  • Prioritize the data cleanup that will unblock measurement
PropertyNameField TypeNotes
instituteidInstitute Ididentifier
instituteShortcodeInstitute ShortcodeString
patientIdPatient IDIdentifierPatient
episodeOfCareIdEpisode of Care IDIdentifier
organizationNameOrganization Namestring
clientFirstNameClient First Namestring
clientLastNameClient Last Namestring
clientMissingContactDetailsClient Missing Contact DetailsbooleanIf a patient has either a phone number or email this will be TRUETRUE | FALSE
clientEmailClient Emailstring
clientPhoneNumberClient Phone Numberstring
clientAgeBracketClient Age BracketenumSee Below
providerFirstNameProvider First Namestring
providerLastNameProvider Last Namestring
childMissingCaregiverChild Missing CaregiverbooleanFor any patient that is in the Client Age Bracket of "child" this field indicates whether they missing a caregiver. TRUE | FALSE
caregiverRelationshipCaregiver Relationshipenumguardian | teachermotherfatherchild
caregiverFirstNameCaregiver First Namestring
caregiverLastNameCaregiver Last Namestring
caregiverEmailCaregiver Email
caregiverPhoneNumberCaregiver Phone Number

A note on Child Age Bracket​

Mirah will group categories of people into specific age brackets. The breakdown of that is:

CategoryAge
child< 10
adolescent< 17
adult< 65
unknownNULL
senior65+

​