South Dakota Extracts - Enrollments

Classic View: SD State Reporting > SD Extracts > Enrollments

 Search Term: 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.

SD Extract - Enrollments Editor

Report Logic

Report lists one record for each student enrollment.

Enrollments 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

Type, Format and Length

Campus UI and Database Location

District Number

State-assigned district identification number.

Number, 5 digits

System Administration > Resources > District Information > District Number


District.number

School Number

State-assigned school identification number.

Number, 2 digits

System Administration > Resources > School > 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

System Administration > Calendar > Calendar > Number


Calendar.number

District Code

The district associated with the enrollment record.

  • 10: Public Schools
  • 20: Non-Public Schools
  • 30: BIA Schools
  • 40: Coops
  • 50: Correctional Facilities
  • 60: State Special Populations
  • 70: Community Based Providers
  • 80: Special Populations
  • 90: Alternative
Numeric, 2 digitsSystem Administration > Resources > District Information > District Code

District.districtCode

First Name

Student's legal first name.

Alphanumeric, 35 characters

Census > People > Demographics > First Name


Identity.firstName

Middle Name

Student's legal middle name.

Alphanumeric, 20 characters

Census > People > Demographics > Middle Name


Identity.middleName

Last Name

Student's legal last name.

Alphanumeric, 40 characters

Census > People > Demographics > Last Name


Identity.lastName

Birthdate

Student's date of birth.

Date field, 10 characters

MM/DD/YYYY

Census > People > Demographics > Birth Date


Identity.birthdate

Gender

Student's gender.

Alphabetic, 1 character

M or F

Census > People > Demographics > Gender


Person.gender

State ID Number

Student's state ID number.

Numeric, 9 digits

Census > People > Demographics > Person Identifiers > Student State ID


Person.studentNumber

Social Security Number

Student's Social Security number.

Numeric, 9 digits

Census > People > Demographics > Social Security Number


Student.ssn

Grade Level

Student grade level

Alphanumeric, 2 characters

Student Information > General > Enrollment > Grade


Enrollment.grade

Resident District Number

The identification number of the district in which the student resides.

Numeric, 5 digits

Student Information > General > 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

Student Information > General > Enrollments > State Reporting Fields > Serving (Attending) District


Enrollment. servingDistrict

Enrollment Start Date

The day student enrollment began.

Date field, 10 characters MM/DD/YYYY

Student Information > General > Enrollments > Start Date


Enrollment.startDate

Enrollment End Date

The day student enrollment ended.

Date field, 10 characters MM/DD/YYYY

Student Information > General > Enrollments > End Date


Enrollment.endDate

Service Type

Indicates type of service student is receiving.

  • P: Primary
  • S: Partial
  • N: Special Ed Services

Alphabetic, 1 character

Student Information > General > Enrollments > Service Type


Enrollment.serviceType

Percent Enrolled

Percentage of time student was enrolled in the service, between 0 and 100.

Numeric, 3 digits

Student Information > General > Enrollments > State Reporting Fields > Percent Enrolled


Enrollment.
percentEnrolled

Start Status

The reason for the student's entry into the school.

Numeric, 2 digits

Student Information > General > 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. See options in the South Dakota Enrollments Tab article.

Numeric, 2 digits

Student Information > General > Enrollments > End Status


Enrollment.endStatus

County Number

State defined county number or code.

Numeric, 2 digits

Student Information > General > Enrollments > 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.

See Enrollment Status Codes Table below.

Alphanumeric, 1 character

Student Information > General > Enrollments > State Reporting Fields > Enrollment Status


EnrollmentSD. enrollmentStatus

EL

Indicates student is participating in English Learner programming.
 
If the current date falls within the Identified Date and Exit Date entered on the EL tab, a value of Y is reported. Otherwise, a value of N is reported.

Alphabetic, 1 character

Y or N

Student Information > Program Participation > English Learners (EL) > Program Status


LEP.programStatus

Primary Language

Primary language the student speaks. If LEP = Y, Primary Language must not be empty.

See the Language List attachment for a complete list of accepted language codes.

Alphanumeric, 3 characters

Census > People > Identities > Home Primary Language


Enrollment.language

EL Date

The date on which the student began participation in the English Learner program.
 
If the EL column reports a value of Y, this field will report the Identified Date

Date field, 10 characters

MM/DD/YYYY

Student Information > Program Participation > English Learners (EL) > EL > Identified Date


LEP.identifiedDate

EL Service TypeReport 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)
  • If EL service is not associated with an active State EL state code, do not pull into field 26 or
  • District Code = 30 or blank, do not pull data

Student Information > Program Participation > English Learners (EL) > EL Services > Service Type

ELService.type
EL Service Start DatePull 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)
  • If EL service is not associated with an active EL state code, do not report EL Service Start Date in field 27
  • District Code = 30 or blank, do not pull data
MM/DD/YYYYStudent Information > Program Participation > English Learners (EL) > EL Services > Start Date

ELService.startDate
Gifted

Indicates if the student is considered gifted.

  • When the Gifted field is set to Y:Yes, a value of Y is reported.
  • When the Gifted field is set to N:No, a value of N is reported.
  • When the Gifted field is null, the field reports a blank value.
Alphanumeric, 1 characterStudent Information > General > Enrollments > State Reporting Fields > Gifted

Enrollment.giftedTalented
Documented Hearing Loss

Indicates if the student has documented hearing loss. 

  • Reports 'Y' if the Documented Hearing Loss checkbox is marked on a student's enrollment record.
  • Otherwise, reports 'N'

Alphanumeric, 1 character

Y or N


Student Information > General > 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 characterStudent Information > General > 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.

See Special Ed Category Codes Table below.

Numeric, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Special Ed Category


Enrollment .specialEdSetting

Occupational Therapy Hours

Number of hours student participated in occupational therapy. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Occupational Therapy Hours


CustomEnrollment
sped.occupationalHours

Physical Therapy Hours

Number of hours student participated in physical therapy. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Physical Therapy Hours


CustomEnrollment
sped.physicalHours

Psychological Therapy Hours

Number of hours student participated in psychological therapy. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Psychological Therapy Hours


CustomEnrollment
sped.psychologicalHours

Counseling Hours

Number of hours student participated in counseling services. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Counseling Services Hours


CustomEnrollment
sped.counselingHours

Social Work Hours

Number of hours student participated in social work services. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Social Work Services Hours


CustomEnrollment
sped.socialWorkHours

Audiological Therapy Hours

Number of hours student participated in audiological services. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Audiological Services Hours


CustomEnrollment
sped.audiologicalHours

Recreational Therapy Hours

Number of hours student participated in recreational therapy. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Recreational Therapy Hours


CustomEnrollment
sped.recreationalHours

School Health Hours

Number of hours student participated in school health services. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > School Health Services Hours


CustomEnrollment
sped.schoolHealthHours

Speech Therapy Hours

Number of hours student participated in speech/language therapy. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Speech/Language Therapy Hours


CustomEnrollment
sped.speechHours

SPED Transportation

Indicates whether student is receiving transportation assistance.

Alphabetic, 1 character

Y or N

Student Information > General > Enrollments > Special Ed Fields >Transportation


CustomEnrollment
sped.transportation

Other Service Hours

Number of hours student participated in other services. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Other Service Hours


CustomEnrollment
sped.otherServiceHours

SPED Assistive Technology

Indicates whether student is receiving assistive technology services.

Alphabetic, 1 character

Y or N

Student Information > General > Enrollments > Special Ed Fields > Assistive Technology


CustomEnrollment
sped.assistiveTechnology

Orientation Mobility Hours

Number of hours student participated in orientation mobility therapy. Round to 3 decimals.

Decimal, 8 digits

Student Information > General > Enrollments > Special Ed Fields > Orientation Mobility Hours


CustomEnrollment
sped.orientationHours

ASD Severity Behaviors

Indicates if the student requires ASD Behavioral support and the severity level of this support.

  • 1 = Requiring Support
  • 2 = Requiring Substantial Support
  • 3 = Requiring Very Substantial Support
Alpha, 1 characterStudent Information > General > 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.

  • 1 = Requiring Support
  • 2 = Requiring Substantial Support
  • 3 = Requiring Very Substantial Support
Alpha, 1 characterStudent Information > General > Enrollments > Special Ed Fields >ASD Severity Communication

CustomEnrollment 
 sped. asdSeverityCommunication
Participates in Alt AssessmentIndicates if the student participates in alternative assessment.

Alphabetic, 1 character

Y or N

Student Information > General > 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.

  • A: Mild to Moderate Disabilities
  • B: Severe Disabilities
  • C: Speech Only
  • D: Early Childhood
  • E: Day Program
  • F: Residential Program
  • G: Homebound Program

Alphabetic, 1 character

Student Information > General > Enrollments > Special Ed Fields > Special Ed Program


Enrollment.
specialEdStatus

Primary Disability

Student's primary disability. If Primary Disability is entered, SPED Start Date must not be empty.

See Disability Codes Table below.

Alphanumeric, 3 characters

Student Information > General > Enrollments > Special Ed Fields > Primary Disability


Enrollment.disability1

Multiple Disability 1

Student's disability in addition to Primary Disability.

See Disability Codes Table below.

Alphanumeric, 3 characters

Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 1


Enrollment.disability2

Multiple Disability 2

Student's disability in addition to Primary Disability.

See Disability Codes Table below.

Alphanumeric, 3 characters

Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 2


Enrollment.disability3

Multiple Disability 3

Student's disability in addition to Primary Disability.

See Disability Codes Table below.

Alphanumeric, 3 characters

Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 3


Enrollment.disability4

Multiple Disability 4

Student's disability in addition to Primary Disability.

See Disability Codes Table below.

Alphanumeric, 3 characters

Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 4


Enrollment.disability5

Multiple Disability 5

Student's disability in addition to Primary Disability.

See Disability Codes Table below.

Alphanumeric, 3 characters

Student Information > General > 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

Student Information > General > 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

Student Information > General > Enrollments > Special Ed Fields > End Date


Enrollment.spedExitDate

SPED Exit Code

Exit code attached to the ending of the student's special education participation.

See Special Ed Exit Codes Table below.

Numeric, 10 digits

Student Information > General > Enrollments > Special Ed Fields > Exit Code


Enrollment.
spedExitReason

Days Absent

Number of days student was absent.

Decimal, 8 digits

Student Information > General > Enrollments > State Reporting Fields > Absent Days


Calculated, not dynamically stored

Title 1 Status

Indicates whether student is participating in title 1 services.

Alphabetic, 1 character

Y or N

Student Information > General > Enrollments > State Reporting Fields > Title 1


Enrollment.title1

Citizenship

Code indicating student's citizenship status.

  • 1: US Citizen
  • 2: Foreign Exchange Student
  • 3: Immigrant or Refugee

Numeric, 1 digits

Student Information > General > Enrollments > State Reporting Fields > Citizenship


Enrollment.citizenship

Transportation

Indication of transportation assistance provided to the student, if applicable.

  • 01: Student Not Transported
  • 02: Student Transported on District-Owned Buses
  • 03: Student Transported on Contracted Buses
  • 04: Mileage Paid in Lieu of Transportation

Numeric, 2 digits

Student Information > General > 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.

  • D: Doubled Up/Sharing Housing
  • E: Emergency/Transitional Shelter
  • H: Hotels/Motels
  • U: Unsheltered

Alphanumeric, 1 character

Student Information > Program Participation > Homeless > Primary Nighttime Residence


Homeless.
primaryNightTimeResidence

Homeless Start DateThe first day the student was identified as homeless.

Date field, 10 characters 

MM/DD/YYYY

Student Information > Program Participation > 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:

  • Yes = Y
  • No = N
  • Blank = null
Alphanumeric, 1 character Student Information > Program Participation > Homeless > Unaccompanied Youth

Homeless.
unaccompaniedYouth

Title 1 Math

Indicates student's participation in Title 1 Math program.

Alphabetic, 1 character

Y or N

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > 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

Census > People > Demographics > Data Entered US Schools


Identity.
dateEnteredUSschool

Date Entered 9th GradeIndicates the date in which the student entered 9th grade.Date field, 10 characters MM/DD/YYYYStudent Information > General > Graduation > Date First Entered the 9th Grade

Graduation.grade9Date

Diploma Type

The student's graduation diploma type.
 
Valid values are as follows:

  • 1: Regular Diploma

Alphanumeric, 2 characters

Student Information > General > Graduation > Diploma Type


Graduation.diplomaType

Diploma Date

The date the student received

Date field, 10 characters MM/DD/YYYY

Student Information > General > Graduation > Diploma Date


Graduation.diplomaDate

Diploma Period

Indicates when the diploma was issued.

Reported values are as follows:

  • EA : Early
  • SP : Spring
  • SU : Summer
Alphanumeric, 2 charactersStudent Information > General > 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > Graduation > Endorsements

GraduationSeal.
stateSeal
Student of Active Military Parent

Indicates the student has a parent who is actively in the military.

  • If unchecked, a value of 'N' is reported.
  • If checked,a value of 'Y' is reported.
Alphanumeric, 1 characterStudent Information > General > Enrollments > State Reporting Fields > Student of Active Military Parent

Enrollment.
studentOfActiveMilitaryParent
Student Directory InformationIndicates whether or not the school is allowed to share information about the student with non school entities.Alphabetic, 3 character 
 
 Yes or No
Student Information > General > Enrollments > State Reporting Fields > Student Directory Info 7-12 ONLY

EnrollmentSD.doNotShare
Student GPA

The student's GPA as reported in the GPA field on their enrollment record.

  • Only students in State Grade Levels 9-12 are reported.
  • If the value has more than 4 decimal places, the GPA value is truncated on the far right of the decimal to a length of 4.
  • If the value has less than 4 decimal places, zeros are added to the far right to a length of 4 decimal places.

Numeric, 5 digits

X.XXXX

Student Information > General > Enrollments > State Reporting Fields > GPA

EnrollmentSD.gpa
Participates in After School PrgIndicates if the student participates in an after school program.
  • Report Y, when the Participates in After School Prg checkbox is checked (Enrollments > State Reporting fields)
  • If not checked report N
Alphanumeric, 1 character
Student Information > General > Enrollments > State Reporting fields > Participates in After School Prg

Enrollment.afterSchoolProgram

Year

The end year of the enrollment (i.e. for SY2006-2007 = 2007).

Date field, 4 characters

YYYY

System Administration > Calendar > Calendar > Calendar Info


Calendar.endYear

Enrollment Status Codes 

Code

Description

Only Valid If

A

School Choice

Only Valid If Resident District Same As Attending District

D

Persistently Dangerous

Only Valid If Resident District Same As Attending District

B

Placed and Paid by Tribal

Only Valid If Resident District Different From Attending District

C

Contracting Student

Only Valid If Resident District Different From Attending District

E

Paid for by Auxiliary Placement

Only Valid If Resident District Different From Attending District

G

Whole Grade Sharing

Only Valid If Resident District Different From Attending District

J

Placed and Paid by Corrections

Only Valid If Resident District Different From Attending District

M

Parentally Placed in Private School

Only Valid If Resident District Different From Attending District

O

Open Enrollment

Only Valid If Resident District Different From Attending District

P

Tuition Paid by District

Only Valid If Resident District Different From Attending District

RResidential Placement Paid by DOEOnly Valid If Resident District Different From Attending District

T

Tuition Paid by Other

Only Valid If Resident District Different From Attending District

W

Tuition Waived

Only Valid If Resident District Different From Attending District


Disability Codes 

Code

Description

500

Deaf-Blindness

505

Emotional Disturbance

510

Cognitive Disability

515

Hearing Loss

525

Specific Learning Disability

530

Multiple Disabilities

535

Orthopedic Impairments

540

Visual Loss

545

Deafness

550

Speech/Language

555

Other Health Impairment

560

Autism

565

Traumatic Brain Injury

570

Developmental Delay

Special Ed Exit Codes 

Code

Description

1

Not receiving SE services

2

Graduated (high school diploma)

03Continues/Completed IEP team mod/ course reqs

4

Reached the maximum age

5

Died

6

Moved, known to be continuing

7

Moved, not known to be continuing

8

Dropped out

9

Refused services

10

ISFP done before max age/Pt C

11

Change in IEP

12

Student Continues

13Discontinued/Completed IEP team mod/course reqs
14Aged Out/Completed IEP team mod/course reqs
15Revocation of consent



Previous Versions