Tool Search: SD Extract
The Enrollments Extract collects student data stored on the enrollments tab. To generate this extract, select Enrollments from the Extract Type field on the SD Extract editor. The report lists one record for each student enrollment.
Enrollments ExtractEnrollments Extract Layout
The following tables describe the fields which appear in the Enrollments Extract.
Header Record
Name | Length | Code/Format | Description |
|---|---|---|---|
Record Type | 2 | “HD” | Always the value “HD” |
Date | 10 | MM/DD/YYYY | Date report was generated |
Time | 8 | HH:MM:SS | Time report was generated |
Version | 15 | “SD2.0” | Always the value “SD2.0” |
Enrollments Records
Name | Description | Location |
|---|---|---|
District Number | State-assigned district identification number. Number, 5 digits | District Information > District Number District.number |
School Number | State-assigned school identification number. Number, 2 digits | School Information > State School Number School.number |
Calendar Number | Number assigned to the calendar. Needs to match calendar number in associated SD-Extract-School Calendar file. Number, 3 digits | Calendar Information > Number Calendar.number |
| District Code | The district associated with the enrollment record.
Numeric, 2 digits | District Information > District Code District.districtCode |
First Name | Student's legal first name. Alphanumeric, 35 characters | Demographics > First Name Identity.firstName |
Middle Name | Student's legal middle name. Alphanumeric, 20 characters | Demographics > Middle Name Identity.middleName |
Last Name | Student's legal last name. Alphanumeric, 40 characters | Demographics > Last Name Identity.lastName |
Birthdate | Student's date of birth. Date field, 10 characters (MM/DD/YYYY) | Demographics > Birth Date Identity.birthdate |
Gender | Student's gender. Alphabetic, 1 character (M or F) | Demographics > Gender Person.gender |
State ID Number | Student's state ID number. Numeric, 9 digits | Demographics > Person Identifiers > Student State ID Person.studentNumber |
Social Security Number | Student's Social Security number. Numeric, 9 digits | Demographics > Social Security Number Student.ssn |
Grade Level | Student grade level. Alphanumeric, 2 characters | Enrollment > General Enrollment Information > Grade Enrollment.grade |
Resident District Number | The identification number of the district in which the student resides. Numeric, 5 digits | Enrollments > State Reporting Fields > Resident District Enrollment. residentDistrict |
Attending District Number | The identification number of the district in which the student attends school. Numeric, 5 digits | Enrollments > State Reporting Fields > Serving (Attending) District Enrollment. servingDistrict |
Enrollment Start Date | The day student enrollment began. Date field, 10 characters (MM/DD/YYYY) | Enrollments > General Enrollment Information > Start Date Enrollment.startDate |
Enrollment End Date | The day student enrollment ended. Date field, 10 characters (MM/DD/YYYY) | Enrollments > General Enrollment Information > End Date Enrollment.endDate |
Service Type | Indicates type of service student is receiving.
Alphabetic, 1 character | Enrollments > General Enrollment Information > Service Type Enrollment.serviceType |
Percent Enrolled | Percentage of time student was enrolled in the service, between 0 and 100. Numeric, 3 digits | Enrollments > State Reporting Fields > Percent Enrolled Enrollment.percentEnrolled |
Start Status | The reason for the student's entry into the school. Numeric, 2 digits | Enrollments > General Enrollment Information > Start Status Enrollment.startStatus |
End Status | Reason student enrollment was ended. If Enrollment End Date is supplied, an End Status must be entered. Numeric, 2 digits | Enrollments > General Enrollment Information > End Status Enrollment.endStatus |
County Number | State defined county number or code. Numeric, 2 digits | Enrollments > General Enrollment Information > County County.number |
Enrollment Status | Status of the student's enrollment. If Resident District and Attending District are not the same, an Enrollment Status must be selected. If Resident District and Attending District are the same, only codes A and D are available. If the districts differ, codes B, C, E, G, J, M, O, P, T and W are available. Alphanumeric, 1 character | Enrollments > State Reporting Fields > Enrollment Status EnrollmentSD. enrollmentStatus |
EL | Indicates student is participating in English Learner programming. Alphabetic, 1 character (Y or N) | English Learners (EL) > Program Status LEP.programStatus |
Primary Language | Primary language the student speaks. If LEP = Y, Primary Language must not be empty. Alphanumeric, 3 characters | Identities > Home Primary Language Enrollment.language |
EL Date | The date on which the student began participation in the English Learner program. Date field, 10 characters (MM/DD/YYYY) | English Learners (EL) > EL > Identified Date LEP.identifiedDate |
| EL Service Type | Report the EL Service State code associated with the EL service on the student's EL Services tab when End Date is blank and the EL Service has an active state code (DUAL, TWIMM, TBIP, DEVB, CESL, PESL, OTHER, NEW or ESELD) AND District code, field 4, must not be blank or = 30 (Resources > District Info > District Code)
| English Learners (EL) > EL Services > Service Type ELService.type |
| EL Service Start Date | Pull from the student's EL Services tab > Service Start Date when End Date is blank and the EL Service has an active state code (DUAL, TWIMM, TBIP, DEVB, CESL, PESL, OTHER, NEW or ESELD) AND District code, field 4, must not be blank or = 30 (Resources > District Info > District Code)
Date field, 10 characters (MM/DD/YYYY) | English Learners (EL) > EL Services > Start Date ELService.startDate |
| Gifted | Indicates if the student is considered gifted.
Alphanumeric, 1 character | Enrollments > State Reporting Fields > Gifted Enrollment.giftedTalented |
| Documented Hearing Loss | Indicates if the student has documented hearing loss.
Alphanumeric, 1 character (Y or N) | Enrollments > State Reporting Fields > Documented Hearing Loss Enrollment.hearingLoss |
| 504 Plan | Indicates if the student has a 504 Plan. When the 504 Plan checkbox is marked, a value of Y is repoted. Otherwise, a value of N is reported. Alphanumeric, 1 character (Y or N) | Enrollments > State Reporting Fields > 504 Plan Enrollment.section504 |
Special Ed Category | Code indicating category into which student's special education program participation fits. If Special Ed Category is entered, Special Ed Start Date must not be empty.
| Enrollments > Special Ed Fields > Special Ed Category Enrollment .specialEdSetting |
Occupational Therapy Hours | Number of hours student participated in occupational therapy. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Occupational Therapy Hours CustomEnrollment |
Physical Therapy Hours | Number of hours student participated in physical therapy. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Physical Therapy Hours CustomEnrollment |
Psychological Therapy Hours | Number of hours student participated in psychological therapy. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Psychological Therapy Hours CustomEnrollment |
Counseling Hours | Number of hours student participated in counseling services. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Counseling Services Hours CustomEnrollment |
Social Work Hours | Number of hours student participated in social work services. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Social Work Services Hours CustomEnrollment |
Audiological Therapy Hours | Number of hours student participated in audiological services. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Audiological Services Hours CustomEnrollment |
Recreational Therapy Hours | Number of hours student participated in recreational therapy. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Recreational Therapy Hours CustomEnrollment |
School Health Hours | Number of hours student participated in school health services. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > School Health Services Hours CustomEnrollment |
Speech Therapy Hours | Number of hours student participated in speech/language therapy. Round to 3 decimals. Numeric, 8 digits | Enrollments > Special Ed Fields > Speech/Language Therapy Hours CustomEnrollment |
SPED Transportation | Indicates whether student is receiving transportation assistance. Alphabetic, 1 character (Y or N) | Enrollments > Special Ed Fields >Transportation CustomEnrollment |
Other Service Hours | Number of hours student participated in other services. Round to 3 decimals. Decimal, 8 digits | Enrollments > Special Ed Fields > Other Service Hours CustomEnrollment |
SPED Assistive Technology | Indicates whether student is receiving assistive technology services. Alphabetic, 1 character (Y or N) | Enrollments > Special Ed Fields > Assistive Technology CustomEnrollment |
Orientation Mobility Hours | Number of hours student participated in orientation mobility therapy. Round to 3 decimals. Decimal, 8 digits | Enrollments > Special Ed Fields > Orientation Mobility Hours CustomEnrollment |
| ASD Severity Behaviors | Indicates if the student requires ASD Behavioral support and the severity level of this support.
Alphabetic, 1 character | Enrollments > Special Ed Fields > ASD Severity Behaviors CustomEnrollment sped.asdSeverityBehaviors |
| ASD Severity Communication | Indicates if the student requires ASD Communication support and the severity level of this support.
Alphabetic, 1 character | Enrollments > Special Ed Fields >ASD Severity Communication CustomEnrollment sped. asdSeverityCommunication |
| Participates in Alt Assessment | Indicates if the student participates in alternative assessment. Alphabetic, 1 character (Y or N) | Enrollments > Special Ed Fields > Participates in Alt Assessment CustomEnrollment sped.cognitiveDisabilities |
Special Ed Program | Code indicating the type of special education program in which the student is participating. If Special Ed Program is entered, SPED Start Date must not be empty.
Alphabetic, 1 character (Y or N) | Enrollments > Special Ed Fields > Special Ed Program Enrollment. |
Primary Disability | Student's primary disability. If Primary Disability is entered, SPED Start Date must not be empty. Alphanumeric, 3 characters | Enrollments > Special Ed Fields > Primary Disability Enrollment.disability1 |
Multiple Disability 1 | Student's disability in addition to Primary Disability. Alphanumeric, 3 characters | Enrollments > Special Ed Fields > Multiple Disability 1 Enrollment.disability2 |
Multiple Disability 2 | Student's disability in addition to Primary Disability. Alphanumeric, 3 characters | Enrollments > Special Ed Fields > Multiple Disability 2 Enrollment.disability3 |
Multiple Disability 3 | Student's disability in addition to Primary Disability. Alphanumeric, 3 characters | Enrollments > Special Ed Fields > Multiple Disability 3 Enrollment.disability4 |
Multiple Disability 4 | Student's disability in addition to Primary Disability. Alphanumeric, 3 characters | Enrollments > Special Ed Fields > Multiple Disability 4 Enrollment.disability5 |
Multiple Disability 5 | Student's disability in addition to Primary Disability. Alphanumeric, 3 characters | Enrollments > Special Ed Fields > Multiple Disability 5 Enrollment.disability6 |
SPED Start Date | Beginning date of Special Education program participation. Date field, 10 characters (MM/DD/YYYY) | Enrollments > Special Ed Fields > Effective Date Enrollment.spedStartDate |
SPED End Date | Ending date of Special Education program participation. Date field, 10 characters (MM/DD/YYYY) | Enrollments > Special Ed Fields > End Date Enrollment.spedExitDate |
SPED Exit Code | Exit code attached to the ending of the student's special education participation. Numeric, 10 digits | Enrollments > Special Ed Fields > Exit Code Enrollment.spedExitReason |
Days Absent | Number of days student was absent. Decimal, 8 digits | Enrollments > State Reporting Fields > Absent Days Calculated, data not stored |
Title 1 Status | Indicates whether student is participating in title 1 services. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Enrollment.title1 |
Citizenship | Code indicating student's citizenship status.
Numeric, 1 digit | Enrollments > State Reporting Fields > Citizenship Enrollment.citizenship |
Transportation | Indication of transportation assistance provided to the student, if applicable.
Numeric, 2 digits | Enrollments > State Reporting Fields > Transportation Category Enrollment.transportation |
| Homeless | Indicates student's homeless status. If student was homeless at any point during the school year, field should remain populated even if student is no longer homeless.
| Homeless > Primary Nighttime Residence Homeless.primaryNightTimeResidence |
| Homeless Start Date | The first day the student was identified as homeless. Date field, 10 characters (MM/DD/YYYY) | Homeless > Start Date Homeless.startDate |
| Unaccompanied Youth | Indicates the student is not in the presence of a parent, guardian or legal status identified by the court system. Reported values are as follows:
Alphanumeric, 1 character | Homeless > Unaccompanied Youth Homeless.unaccompaniedYouth |
Title 1 Math | Indicates student's participation in Title 1 Math program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Math EnrollmentSD.title1Math |
Title 1 Reading | Indicates student's participation in Title 1 Reading program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Reading EnrollmentSD.title1Reading |
Title 1 Science | Indicates student's participation in Title 1 Science program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Science EnrollmentSD.title1Science |
Title 1 Social Science | Indicates student's participation in Title 1 Social Science program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Social Science EnrollmentSD. title1SocialScience |
Title 1 Vocational | Indicates student's participation in Title 1 Vocational program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Vocational EnrollmentSD. title1Vocational |
Title 1 Health | Indicates student's participation in Title 1 Health program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Health/ Dental/Eye Care EnrollmentSD.title1Health |
Title 1 Guidance | Indicates student's participation in Title 1 Guidance program. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > Title 1 Supporting Guidance EnrollmentSD.title1Guidance |
First Year In Country | Indicates that this enrollment represents the student's first year in the country. Alphabetic, 1 character (Y or N) | Enrollments > State Reporting Fields > First Year in Country EnrollmentSD. firstYearInCountry |
Date Entered US Schools | The date the student enrolled in a US school. Date field, 10 characters (MM/DD/YYYY) | Demographics > Data Entered US Schools Identity.dateEnteredUSschool |
| Date Entered 9th Grade | Indicates the date in which the student entered 9th grade. Date field, 10 characters (MM/DD/YYYY) | Graduation > Date First Entered the 9th Grade Graduation.grade9Date |
Diploma Type | The student's graduation diploma type. Alphanumeric, 2 characters | Graduation > Diploma Type Graduation.diplomaType |
Diploma Date | The date the student received the diploma.
| Graduation > Diploma Date Graduation.diplomaDate |
| Diploma Period | Indicates when the diploma was issued. Reported values are as follows:
Alphanumeric, 2 characters | Graduation > Diploma Period Graduation.diplomaPeriod |
| Graduation Endorsement 1 | Indicates if the student has a Graduation Endorsement of 'Advanced Endorsement'. If Endorsements = 1: Advanced Endorsement, a value of Y is reported. Otherwise, a value of N is reported. Alphanumeric, 1 character (Y or N) | Graduation > Endorsements GraduationSeal. stateSeal |
| Graduation Endorsement 2 | Indicates if the student has a Graduation Endorsement of 'Advanced Career Endorsement'. If Endorsements = 2: Advanced Career Endorsement, a value of Y is reported. Otherwise, a value of N is reported. Alphanumeric, 1 character (Y or N) | Graduation > Endorsements GraduationSeal. stateSeal |
| Graduation Endorsement 3 | Indicates if the student has a Graduation Endorsement of 'Advanced Honors Endorsement'. If Endorsements = 3: Advanced Honors Endorsement, a value of Y is reported. Otherwise, a value of N is reported. Alphanumeric, 1 character (Y or N) | Graduation > Endorsements GraduationSeal.stateSeal |
| Student of Active Military Parent | Indicates the student has a parent who is actively in the military.
Alphanumeric, 1 character (Y or N) | Enrollments > State Reporting Fields > Student of Active Military Parent Enrollment.studentOfActiveMilitaryParent |
| Student Directory Information | Indicates whether or not the school is allowed to share information about the student with non school entities. Alphabetic, 3 character (Yes or No) | |
| Student GPA | The student's GPA as reported in the GPA field on their enrollment record.
Numeric, 5 digits X.XXXX | Enrollments > State Reporting Fields > GPA EnrollmentSD.gpa |
| Participates in After School Prg | Indicates if the student participates in an after school program.
Alphanumeric, 1 character (Y or N) | Enrollments > State Reporting fields > Participates in After School Prg Enrollment.afterSchoolProgram |
Year | The end year of the enrollment. Date field, 4 characters (YYYY) | Calendar Information > End Year Calendar.endYear |
