NCLB Student Data Extract (South Dakota)

This information is current as of the Campus.2323 (June 2023) release.

Classic View: SD State Reporting > NCLB Student Data

Search Terms: NCLB Student Data

The No Child Left Behind Student Data report is used by schools to verify or contest Adequate Yearly Progress designations. This report is a snapshot of student data from the time a school's or district's AYP status was determined.

NCLB Student Data Extract

Report Editor

The only field available for selection in the extract editor is the end Reporting Year for which all district data is pulled. For example, a reporting year of 2022 will pull information from the 2021-22 school year.

Generate the Report

  1. Select a Reporting Year from the dropdown list.
  2. Click Generate Report to generate the extract in CSV format.

NCLB Student Data Report - CSV Format

NCLB Student Data Report Layout

Element Name

Description

Location

year

The reporting year chosen in the extract editor.


Date field, 4 characters (YYYY)

SD State Reporting > NCLB Student Data > Reporting Year

districtNumber

The identification number of the district for which the report is generated.


Numeric, 5 digits

System Administration > Resources > District Information > State District Number

districtName

The name of the district for which the report is generated.


Alphanumeric,  50 characters

System Administration > Resources > District Information > Name

schoolNumber

The identification number of the school into which the student is enrolled.


Numeric, 2 digits

System Administration > Resources > School > State School Number

schoolName

The name of the school into which the student is enrolled.


Alphanumeric,  40 characters

System Administration > Resources > School > Name

stateID

Student state identification number.


Numeric, 9 digits

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

lastName

Student's legal last name.



Alphabetic, 25 characters

Census > People > Demographics > Last Name

firstName

Student's legal first name.


Alphabetic, 25 characters

Census > People > Demographics > First Name

middleName

Student's legal middle name.


Alphabetic, 25 characters

Census > People > Demographics > Middle Name

genderCode

The gender of the student. 


Alphanumeric, 1 character (M or F)

Census > People > Demographics > Gender

raceCode

The student's race/ethnicity.


Alphanumeric, 2 characters

Census > People > Demographics > Race Ethnicity

enrollmentStart

The date on which student began enrollment.


Date field, 10 characters (YYYY-MM-DD)

Student Information > General > Enrollments > District Start Date AND Student Information > General Enrollment > Start Date

enrollmentEnd

The date on which student enrollment ended. 



Date field, 10 characters (YYYY-MM-DD)

Student Information > General > Enrollments > End Date

grade

The grade level in which the student is enrolled.


Numeric, 2 digits

Student Information > General > Enrollments > Grade

absentDays

The number of days the student was absent during the reporting year. Appears as a read-only field on student enrollments.


Decimal, 6 characters (###.##)

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

residentDistrictName

The name of the district in which the student resides.


Alphanumeric, 50 characters

Student Information > General > Enrollments > State Reporting Fields > Resident District

residentDistrictNumber

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


Numeric, 5 digits

Student Information > General > Enrollments > State Reporting Fields > Resident District

attendingDistrictName

The name of the district at which the student attends school.


Alphanumeric, 50 characters

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

membershipDays

The number of days counted as membership days for the student.


Decimal, 6 characters (###.##)

Calculated, not dynamically stored

percentEnrolled

The percent of a standard school day for which a student is expected to be in attendance. 


Decimal, 5 characters

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

enrollmentStatus

The status of the student's enrollment. See options in the South Dakota Enrollments Tab article.

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 digit

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

exitCode

The end status of the student's enrollment. See options on the South Dakota Enrollments article.


Numeric, 2 digits

Student Information > General > Enrollments > End Status

foreignExchange

Indicates whether or not student is enrolled as a foreign exchange student based on the value of 2: Foreign Exchange Student in the Citizenship dropdown list.


Numeric, 1 digit

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

lep

Indicates if student has a status as a limited English proficient.


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > LEP Status

migrant

Indicates if student is a migrant.



Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > Migrant Indicator

mealStatusCode

Indicates whether student is eligible for meal assistance. Options are:

  • F: Free
  • R: Reduced
  • S: Standard

Alphanumeric, 1 character (Y or N)

FRAM > Eligibility > Eligibility

title1

Indicates student is served by a Title 1 program.


Alphanumeric, 1 character (Y or N)

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

readingScaleScore

The student's scaled reading score.


Numeric, 2 digits

Student Information > General > Assessments > Test Score Detail > Reading Scale Score

readingLevel

The achievement level of the student for a reading assessment based on a grade and assessment-specific scale.


Alphanumeric, 10 characters

Student Information > General > Assessments > Test Score Detail > Reading Result

mathScaleScore

The student's scaled math score.


Numeric, 2 digits

Student Information > General > Assessments > Test Score Detail > Math Scale Score

mathLevel

The achievement level of the student for a math assessment based on a grade and assessment-specific scale.


Alphanumeric, 10 characters

Student Information > General > Assessments > Test Score Detail > Math Result

seStart

The effective date of the student's special education participation.


Date field, 10 characters (MM/DD/YYYY)

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

seEnd

The end date of the student's participation in special education.



Date field, 10 characters (MM/DD/YYYY)

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

seDisabilityCode

The special education student's primary disability.


Numeric, 3 digits

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

seCategory

The special ed student's program category. 


Numeric, 4 digits

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

seExitCode

The reason the student's participation in a special education program ended. 


Numeric, 2 digits

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

districtInclude

Indicates that the student spent a full academic year at the district.


Alphanumeric, 1 character (Y or N)

Not available in the user interface.

schoolInclude

Indicates that the student spent a full academic year at the school.



Alphanumeric, 1 character (Y or N)

Not available in the user interface.

districtIEPInclude

Indicates that the student spent a full academic year at the district while receiving special education services.



Alphanumeric, 1 character (Y or N)

Not available in the user interface.

schoolIEPInclude

Indicates that the student spent a full academic year at the school while receiving special education services.


Alphanumeric, 1 character (Y or N)

Not available in the user interface.

assessmentExemption

Indicates whether student is exempt from state-required assessments.


Alphanumeric, 5 characters (TRUE or FALSE)

Student Information > General > Enrollments > State Reporting Fields > Assessment Exemption

firstYearInCountry

Indicates that this year is the student's first year in the country.



Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > First Year in Country

seCognitiveDisabilities

Indicates that student has significant cognitive disabilities.


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > Special Ed Fields > Significant Cognitive Disabilities

delpTest

Indicates if student has taken a DELP assessment


Alphanumeric, 1 character (Y or N)

Student Information > General > Assessment > DELP Assessment

scienceScaleScore

The student's scaled science score.


Numeric, 2 digits

Student Information > General > Assessment > Test Score Detail > Science Scale Score

scienceLevel

The achievement level of the student for a science assessment based on a grade and assessment-specific scale.


Alphanumeric, 10 characters

Student Information > General > Assessment > Test Score Detail > Science Result

accommodationreading

Indicates that student received accommodation on a Dakota STEP reading assessment.


Alphanumeric, 1 character (Y or N)

Student Information > General > Assessment > Test Score Detail > Received Accommodation

accommodationmath

Indicates that student received accommodation on a Dakota STEP math assessment.


Alphanumeric, 1 character (Y or N)

Student Information > General > Assessment > Test Score Detail > Received Accommodation

accommodationscience

Indicates that student received accommodation on a Dakota STEP science assessment.


Alphanumeric, 1 character (Y or N)

Student Information > General > Assessment > Test Score Detail > Received Accommodation

dec1count

Indicates that the student was considered special education on December 1st of the reporting year.


Alphanumeric, 5 characters (TRUE or FALSE)

Not available in the user interface.

formerschoolIEPInclude

Indicates that the student spent a full academic year in the school while receiving special education services at some point within the last two years, but not during the current year.


Alphanumeric, 1 character (Y or N)

Not available in the user interface.

formerdistrictIEPInclude

Indicates that the student spent a full academic year in the district while receiving special education services at some point within the last two years, but not during the current year.


Alphanumeric, 1 character (Y or N)

Not available in the user interface.

fomerstateIEPInclude

Indicates that the student spent a full academic year in the state while receiving special education services at some point within the last two years, but not during the current year.


Alphanumeric, 1 character (Y or N)

Not available in the user interface.

LEP2year

Indicates that the student achieved Limited English Proficiency within the last two years.


Alphanumeric, 3 characters (Yes or No)

Not available in the user interface.

Sped2Year

Indicates that the student appeared in the December 1 Child Count for special education students at some point in the last two years, but not during the current year.


Alphanumeric, 3 characters (Yes or No)

Not available in the user interface.