Classic View: SD State Reporting > Health Extract
Search Term: Health Extract
This extract reports height and weight information for students who have undergone health screenings.
Health Extract Editor
Report 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 Student Information > Health > General > 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) | Student Information > Health > Screenings > Height/Weight and Vital Signs > Date healthScreeningGrowth. growthDate |
Student ID | The unique number assigned to a student. Numeric, 9 digits | Census > People > Demographics > Person Identifiers > State ID person.stateID |
Gender | The gender of the student - Male or Female. Numeric, 1 digit | Census > People > Demographics > Person Information > Gender identity.gender |
DOB | The birth date of the student. Date field, 10 characters (MM/DD/YYYY) | Census > People > Demographics > Birth Date identity.birthdate |
Race | The student's race/ethnicity. Alphanumeric, 2 characters | Census > People > Demographics > Race Ethnicity identity.raceEthinicity |
Height | The student's height. Numeric, 2 digits | Student Information > Health > 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 | Student Information > Health > Screenings > Height/Weight and Vital Signs > Height Calculated, data not stored |
Weight | The student's weight. Numeric, 3 digits | Student Information > Health > 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 | Student Information > Health > Screenings > Height/Weight and Vital Signs > Weight Calculated, data not stored |
