Tool Search: Health Extract
This extract reports height and weight information for students who have undergone health screenings.
Health Extract toolReport Logic
When the student's Health Appraisal screening record date falls within the extract's To and From Dates, and the student's enrollment date range, the student's Health Appraisal record(s) in the selected calendar is reported.
When the student's Health Appraisal screening record date does not fall within any enrollment record date range but does fall within the extract's From and To Dates, logic reports the Health Appraisal record for the enrollment within the calendar selected during the extract's To and From Dates.
- Enrollment Service Type = Primary
- Enrollments marked as No Show or have an Enrollment Service Type = N or P are not reported.
- Health Appraisal records are entered in Screenings > New > Type = Health Appraisal.
Report Editor
|
Field |
Description |
|---|---|
|
Calendar |
The calendar from which data will be pulled. |
|
From Date |
The opening date of the date range from which data will be pulled. This is a required field. |
|
To Date |
The closing date of the date range from which data will be pulled. |
|
Format |
The format in which the report should be generated. Options are CSV and HTML. |
Generating the Extract
To generate the South Dakota Health Extract:
- Select the Calendar to be included in the report.
- Enter a From Date in mmddyyyy format or by clicking the calendar icon.
- Enter a To Date in mmddyyyy format or by clicking the calendar icon.
- Indicate the Format in which the report should be generated, CSV or HTML.
- Click Generate Extract to generate the report in the desired format.
Health Extract - CSV Format
Health Extract - HTML Format
Report Layout
|
Element Name |
Description |
Location |
|---|---|---|
|
Date Of Meas |
The date the measurement record was created. Date field, 10 characters (MM/DD/YYYY) |
Screenings > Height/Weight and Vital Signs > Date
healthScreeningGrowth. growthDate |
|
Student ID |
The unique number assigned to a student.
Numeric, 9 digits |
Demographics > Person Identifiers > State ID
person.stateID |
|
Gender |
The gender of the student - Male or Female. Numeric, 1 digit |
Demographics > Person Information > Gender
identity.gender |
|
DOB |
The birth date of the student.
Date field, 10 characters (MM/DD/YYYY) |
Demographics > Birth Date
identity.birthdate |
|
Race |
The student's race/ethnicity.
Alphanumeric, 2 characters |
Demographics > Race Ethnicity
identity.raceEthinicity |
|
Height |
The student's height.
Numeric, 2 digits |
Screenings > Height/Weight and Vital Signs > Height
healthScreeningGrowth. growthHeight |
|
8's |
Rounds to the nearest eighth of an inch. For heights that include a decimal, this field reports the additional eighths of an inch of the student's height. 1/8 of an inch = .125 inches.
Numeric, 1 digit |
Screenings > Height/Weight and Vital Signs > Height
Calculated, data not stored |
|
Weight |
The student's weight.
Numeric, 3 digits |
Screenings > Height/Weight and Vital Signs > Weight
healthScreeningGrowth. growthWeight |
|
4's |
Rounds to the nearest quarter of a pound. For weights that include a decimal, this field report the additional quarters of a pound of the student's weight. 1/4 of a pound = .25 pounds.
Numeric, 1 digit |
Screenings > Height/Weight and Vital Signs > Weight
Calculated, data not stored |
