Student Medical Conditions Import – eSchoolData

For organizations that use a third party system to track medical conditions, Student Medical Conditions is an available profile for importing the information into eSchoolData. This article contains the Business Rules for importing Student Medical Condition data.

Before You Begin

Need a refresher on setting up an import profile? Visit Create Import Profile.

Business Rules

Student Medical Conditions

If the profile's Import Options is set to Overwrite conflict records, ALL existing student medical conditions, including transferred students, will be cleared before the file is imported. It is a complete wipe and replace.

If the profile's Import Options is set to Ignore Conflict Records, existing student medical conditions will be kept, and import records that already exist in eSD will be skipped.

The following logic will be used for each combination of Medical Condition Types and Medical Condition Codes:

Medical Condition Type provided and Medical Condition Code left blank:
1. If a Medical Condition (System > Health > Setup Health > Medical Condition) with the same description exists, that Medical Condition will be used for the student medical condition record. If there are multiple matches, only one Medical Condition will be used.
2. If there are no matching Medical Condition, the student medical condition record will be created with the Medical Condition Type placed in the Condition Type free-form text box.
Medical Condition Type left blank and Medical Condition Code provided:
1. If a Medical Condition (System > Health > Setup Health > Medical Condition) with the same code exists, that Medical Condition will be used for the student medical condition record.
2. If there are no matching Medical Condition, the import record will be rejected.
Medical Condition Type provided and Medical Condition Code provided:
1. If a Medical Condition (System > Health > Setup Health > Medical Condition) with the same code and description exists, that Medical Condition will be used for the student medical condition record.
2. If there are no matching Medical Condition, the import will create that Medical Condition and then use it for the student medical condition record to import.
3. If the Medical Condition Code matches to a Medical Condition's Medical Code but the description is different, the import record will be rejected.
4. If the import file has multiple records using the same Medical Condition Code but have differing Medical Condition Types, all records using that Medical Condition Code will be rejected
Medical Condition Type left blank and Medical Condition Code left blank:
1. The import record will be rejected - there must be a medical condition to import

Column Name	Notes	Restrictions
Student ID Number	Required
Medical Condition Type	See above	50 character limit
Medical Condition Code	See above	10 character limit
Diagnosis Date	Required
End Date	Can be left blank
Medical Condition Description	Can be left blank	1000 character limit
Acuteness Description	Can be left blank	Valid options: Mild Moderate N/A Severe Slight Unknown
Chronic	Can be left blank	Valid options: 0 1 N Y