Tool Search: SD Extract
The Student Demographics extract collects basic student demographic data such as name, birth date and Race/Ethnicity. To generate this extract, select Student Demographics from the Extract Type field on the SD Extract Editor. Multiple records can report for a single student if the student's name or identifying information has changed while at the district.
Student Demographics ExtractSpecial Education data reports from multiple places. Depending on the selected school year, data reports from different areas.
When the selected school year is 2024-25 or earlier, Special Education information reports from the student's Enrollment record for that year.
When the selected school year is 2025-26 or later, Special Education information reports from the Evaluation, Plan, Summary, and Enrollment data. For each field on the report, a logic check is performed in the following order:
- Evaluation - the most recent Start Date that is on or before the effective date if one is selected (or December 1 of the selected school year if one is not selected) and not more than three years in the past, AND has a locked status.
- Plan - the most recent start date that is on or before the effective date if one is selected (or December 1 of the selected school year if none is selected) and not more than one year in the past, AND has a locked status.
- SPED Summary - the start date is on or before the effective date if one is selected (or December 1 of the selected school year if none is selected) and does not have an end date. When that is not found and there is summary data with a start date that is on or before the effective date if one is selected (or December 1 of the selected school year if none is selected) and the end date is after the effective date if one is selected (or December 1 of the selected school year if none is selected).
Student Demographics Extract Layout
The following tables describe the fields that appear in the Student Demographics Extract:
Header Record
Name | Length | Code/Format | Description |
|---|---|---|---|
Record Type | 2 | HD | Always the value HD |
Date | 10 | MM/DD/YYYY | Date the extract was generated |
Time | 8 | HH:MM:SS | Time the extract was generated |
Version | 15 | SD2.0 | Always the value SD2.0 |
Student Demographics Records
Element Name | Description | Location |
|---|---|---|
Record Type | The type of record being generated. In this case, always the value of "SD" for student demographics. Alphabetic, 2 characters (SD) | Not dynamically stored |
District Number | State-assigned district identification number. Numeric, 5 digits | District Information > District Number District.number |
State ID | State identification number assigned to students. For new students, this field should report blank. New students imported at the State level will be assigned a new State ID and not a State ID existing within the file. For existing students, State ID must be populated or a duplicate record will be created. Numeric, 9 digits | Demographics > Person Identifiers > Student State ID Person. studentNumber |
Last Name | Student's legal last name. Alphanumeric, 40 characters | Demographics > Person Identifiers > Last Name Identity.lastName |
First Name | Student's legal first name. Alphanumeric, 35 characters | Demographics > Person Identifiers > First Name Identity.firstName |
Middle Name | Student's legal middle name. Alphanumeric, 20 characters | Demographics > Person Identifiers > Middle Name Identity. middleName |
Suffix | Suffix attached to student's legal name. Accepts Jr. and Sr. with or without punctuation. Alphanumeric, 2 characters | Demographics > Person Identifiers > Suffix Identity.suffix |
Gender | Student's gender. Alphabetic, 1 character (M or F) | Demographics > Person Identifiers > Gender Person.gender |
Birth Date | Student's date of birth. Date field, 10 characters (MM/DD/YYYY) | Demographics > Person Identifiers > Birth Date Identity.birthDate |
Race Determination | Code indicating how student race was determined.
Numeric, 2 digits | Demographics > Person Identifiers > Race Determination Identity.raceEthnicityDetermination |
Hispanic Indicator | Indicates if student is Hispanic/Latino. Numeric, 1 digit | Demographics > Race/Ethnicity > Edit > Is the individual Hispanic/Latino? Identity.hispanicEthnicity |
American Indian or Alaska Native | Indicates if student is American Indian or Alaska native. Alphanumeric, 1 character (Y or N) | Demographics > Race/Ethnicity > American Indian or Alaska Native Identity.raceEthnicity |
Asian | Indicates if student is Asian. Alphanumeric, 1 character (Y or N) | Demographics > Race/Ethnicity > Asian Identity.raceEthnicity |
Black or African American | Indicates if student is Black or African American. Alphanumeric, 1 character (Y or N) | > Demographics > Race/Ethnicity > Black or African American Identity.raceEthnicity |
Native Hawaiian or Other Pacific Islander | Indicates if student is Native Hawaiian or Other Pacific Islander. Alphanumeric, 1 character (Y or N) | Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander Identity.raceEthnicity |
White | Indicates if student is White. Alphanumeric, 1 character (Y or N) | Demographics > Race/Ethnicity > White Identity.raceEthnicity |
| Primary Address | The reporting student's primary home address.
Alphanumeric, 50 characters Allow leading zeros | Households > Address StudentContacts.address |
| City | The city the student resides in.
Alphanumeric, 20 characters | Households > City StudentContacts.city |
| State | The state the student resides in.
Alpha, 2 characters | Households > State StudentContacts.state |
| Zip Code | The zip code the student resides in.
Numeric, 10 digits | Households > Zip Code StudentContacts.zip |
