Classic View: SD State Reporting > SD December Child Count

Search Term: SD December Child Count

The South Dakota December Child Count Extract is an unduplicated count of all children with disabilities age 3-21 receiving Special Education and related services according to an individualized education program (IEP) as of the Effective Date entered or Dec 1st of the reporting year (if Effective Date is null).

Image 1: SD December Child Count Report Editor

Report Logic

Students whose Enrollments record meet the following criteria will be included in this report.

Data is pulled as of report Effective Date or if effective date is null, Dec. 1 of the reporting year.
Special Ed Program or Special Ed Category or Special Ed Primary Disability is not NULL, at least one is populated.
Enrollment Start Date is on or before 12/1 of the reporting year or the Effective Date entered on the report editor.
Enrollment End Date is blank or a date after 12/1 of the reporting year or the Effective Date entered on the report editor.
Percent Enrolled is greater than zero.
Resident District is not 99087: Out of State IA, 99088: Out of State NE, 99089: Out of State WY, 99090: Out of State MT, 99099: Out of State, 99085: Out of State ND or 99086: Out of State MN.
Special Ed End Date is blank or a date after 12/1 of the reporting year or the Effective Date entered on the report editor.
Student's Age is equal to or less than 21 as of 7/1 of the reporting year or the Effective Date entered on the report editor.
If Enrollment Status (State Funding Code) is T or B then Resident District must be 20001: Eagle Butte. If it is not 20001: Eagle Butte, student is excluded from report.

Report Editor

The following table defines the fields available on the SD December Child Count Report Editor.

Editor Field	Description
Extract Format	The format in which the report will generate. Options are CSV, DOCX, HTML, PDF or XML.
Effective Date	Data is reported as of this date. If null, data is reported from Dec 1st of the reporting year.
Calendars	The calendar(s) from which data is pulled for the report. Calendars are listed by school and depend on the year and school selected in the Campus Toolbar.

Generating the Report

To generate the SD December Child Count Report:

Select the Format in which the report should generate.
Enter the Effective Date, if desired. If Effective Date is null, logic reports data based on Dec 1st of the reporting year.
Indicate which Calendar(s) should be included in the report.
Click Generate Extract to generate the report in the desired format.
If an Effective Date is entered, the report header will display this date instead Dec 1 next to the report name.

Image 2: Example of HTML Format

December Child Count Report Layout

Element Name	Description	Type, Format and Length	Campus Database	Campus Location
District Name	The name of the district.	Alphanumeric, 50 characters	District.name	System Administration > Resources > District Information > Name
School Name	The name of the school in which the student is enrolled.	Alphanumeric, 40 characters	School.name	System Administration > Resources > School > Name
State ID	Student state identification number.	Numeric, 9 digits	Identity.stateID	Census > People > Demographics > Person Identifiers > Student State ID
Student Name	The last and first name of the student.	Alphanumeric, 50 characters	Identity.lastName Identity.firstName	Census > People > Demographics > Last Name AND First Name
Gender	The gender of the student.	Alphanumeric, 1 character M or F	Identity.gender	Census > People > Demographics > Gender
State Race Ethnicity	The student's race/ethnicity. See options in the Race/Ethnicity Options table following.	Alphanumeric, 2 characters	Identity.raceEthinicity	Census > People > Demographics > Race Ethnicity
Birthdate	The date of birth of the student.	Date field, 10 characters MM/DD/YYYY	Identity.birthdate	Census > People > Demographics > Birthdate
Age	The age of the student in years, as calculated from the student's birth date to the Effective Date entered on the report editor	Numeric, 2 digits	Not dynamically stored	Census > People > Demographics > Age
Grade	The grade level in which the student is enrolled.	Numeric, 2 digits	Enrollment.grade	Student Information > General > Enrollments > Grade
Flagged	Flagged = 1 if one of the following is met: Age is between 3- 4 as of 12/01 or effective date of report generation and setting is not 0310, 0315, 0325, 0330, 0335, 0345, 0355, 0365, or 0375 Age is = 5 and grade is EC or PK as of 12/01 or effective date of report generation and setting is not 0310, 0315, 0325, 0330, 0335, 0345, 0355, 0365, or 0375 Age is = 5 and grade is not EC or PK as of 12/01 or effective date of report generation and setting is 0310, 0315, 0325, 0330, 0335, 0345, 0355, 0365, or 0375 Age 6-21 as of 12/01 or Effective date of report generation and setting is not 0100, 0110, 0120, 0130, 0140, or 0150. Age 6-21 as of 12/01 or Effective date of report generation and primary disability is 570. Age = 21 as of 7/2 and setting not 0100, 0110, 0120, 0130, 0140, 0150 Age 21 as of 7/2 and primary disability 570	Numeric, 1 digit	Not dynamically stored	Not dynamically stored
Special Ed Category	The category Special Ed student's program. See options in the Special Ed Category Options table following.	Numeric, 4 digits	Enrollment. specialEdSetting	Student Information > General > Enrollments > Special Ed Fields > Special Ed Category
Occupational Therapy Hours	The number of hours the student spends receiving occupational therapy.	Decimal, 7 characters ###.###	CustomEnrollment sped.occupationalHours	Student Information > General > Enrollments > Special Ed Fields > Occupational Therapy Hours
Physical Therapy Hours	The number of hours the student spends receiving physical therapy.	Decimal, 7 characters ###.###	CustomEnrollment sped.physicalHours	Student Information > General > Enrollments > Special Ed Fields > Physical Therapy Hours
Psychological Therapy Hours	The number of hours the student spends receiving psychological therapy.	Decimal, 7 characters ###.###	CustomEnrollment sped.psychologicalHours	Student Information > General > Enrollments > Special Ed Fields > Psychological Therapy Hours
Counseling Service Hours	The number of hours the student spends receiving counseling services.	Decimal, 7 characters ###.###	CustomEnrollment sped.counselingHours	Student Information > General > Enrollments > Special Ed Fields > Counseling Service Hours
Social Work Service Hours	The number of hours the student spends receiving social work services.	Decimal, 7 characters ###.###	CustomEnrollment sped.socialWorkHours	Student Information > General > Enrollments > Special Ed Fields > Social Work Service Hours
Audiological Services Hours	The number of hours the student spends receiving audiological services.	Decimal, 7 characters ###.###	CustomEnrollment sped.audiologicalHours	Student Information > General > Enrollments > Special Ed Fields > Audiological Services Hours
Recreational Therapy Hours	The number of hours the student spends receiving recreational therapy.	Decimal, 7 characters ###.###	CustomEnrollment sped.recreationalHours	Student Information > General > Enrollments > Special Ed Fields > Recreational Therapy Hours
School Health Services Hours	The number of hours the student spends receiving school health services.	Decimal, 7 characters ###.###	CustomEnrollment sped.schoolHealthHours	Student Information > General > Enrollments > Special Ed Fields > School Health Services Hours
Speech Language Therapy Hours	The number of hours the student spends receiving speech language therapy.	Decimal, 7 characters ###.###	CustomEnrollment sped.speechHours	Student Information > General > Enrollments > Special Ed Fields > Speech Language Therapy Hours
Transportation	Indicates if student receives transportation assistance.	Alphanumeric, 1 character Y or N	CustomEnrollment sped.transportation	Student Information > General > Enrollments > Special Ed Fields > Transportation
Assistive Technology	Indicates if student receives assistive technology.	Alphanumeric, 1 character Y or N	CustomEnrollment sped.assistiveTechnology	Student Information > General > Enrollments > Special Ed Fields > Assistive Technology
Other Service Hours	The number of hours the student spends receiving other services.	Decimal, 7 characters ###.###	CustomEnrollment sped.otherServiceHours	Student Information > General > Enrollments > Special Ed Fields > Other Service Hours
Orientation Mobility Hours	The number of hours the student spends receiving orientation mobility services.	Decimal, 7 characters ###.###	CustomEnrollment sped.orientationHours	Student Information > General > Enrollments > Special Ed Fields > Orientation Mobility Hours
Special Ed Program	The Special Ed Program in which the student is participating. See options in the Special Ed Program Options table following.	Alphanumeric, 1 character	enrollment. specialEdStatus	Student Information > General > Enrollments > Special Ed Fields > Special Ed Program
Primary Disability	The Special Ed student's primary disability. Reporting of the disability fields is dependent upon the Category selected. If the category does not match the students age, then the system will report the disabilities associated with the category, not what is concurrent as of effective date See options in the Disability Options table following.	Numeric, 3 digits	Enrollment.disability1	Student Information > General > Enrollments > Special Ed Fields > Primary Disability
Multiple Disability 1	The special ed student's additional disability. See options in the Disability Options table following. This field will only report if the student's Primary Disability = 530: Multiple Disabilities	Numeric, 3 digits	Enrollment.disability2	Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 1
Multiple Disability 2	The special ed student's additional disability. See options in the Disability Options table following. This field will only report if the student's Primary Disability = 530: Multiple Disabilities	Numeric, 3 digits	Enrollment.disability3	Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 2
Multiple Disability 3	The special ed student's additional disability. See options in the Disability Options table following. This field will only report if the student's Primary Disability = 530: Multiple Disabilities	Numeric, 3 digits	Enrollment.disability4	Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 3
Multiple Disability 4	The special ed student's additional disability. See options in the Disability Options table following. This field will only report if the student's Primary Disability = 530: Multiple Disabilities	Numeric, 3 digits	Enrollment.disability5	Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 4
Multiple Disability 5	The special ed student's additional disability. See options in the Disability Options table following. This field will only report if the student's Primary Disability = 530: Multiple Disabilities	Numeric, 3 digits	Enrollment.disability6	Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 5
State School Number	The State School number.	Numeric, 7 digits	School.number	System Administration > Resources > School > School Detail > State School Number
ASD Severity Behavior	Indicates the student's Autism Spectrum Disorder severity level of behavior issues.	N/A	CustomEnrollment sped.asdSeverityBehaviors	Student Information > General > Enrollments > Special Ed Fields > ASD Severity Behavior
ASD Severity Communication	Indicates the Autism Spectrum Disorder severity level of communication issues.	N/A	CustomEnrollment sped.asdSeverityCommunication	Student Information > General > Enrollments > Special Ed Fields > ASD Severity Communication
District Number	The reporting district's District Number.	N/A	District.number	System Administration > Resources > District Information > State District Number
Serving District	Indicates the district responsible for providing services to the student. This field was added in Release Pack .1517.	N/A	Enrollment.servingDistrict	Student Information > General > Enrollments > State Reporting Fields > Serving District
Date	The date of report generation.	Numeric, 8 digits MM/DD/YYYY	Not dynamically stored	N/A

Race/Ethnicity Options

Code	Description
AS	Asian
BL	Black, not Hispanic
HI	Hispanic
IN	American Indian or Alaskan Native
PI	Native Hawaiian or Pacific Islander
WH	White, not Hispanic
TR	Two or more races

Special Ed Category Options

Code	Description
0100	General Class with Modifications 80-100%
0110	Resource Room 40-79%
0120	Self-Contained Classroom 0-39%
0130	Separate Day School
0140	Residential Facility
0150	Home/Hospital
0310	EC 10 hrs +, services in EC
0315	EC 10 hrs +, services in other location
0325	EC less than 10 hrs, services in EC
0330	EC less than 10 hrs, services in other location
0335	Special Education Class
0345	Separate School
0355	Residential Facility
0365	Home
0375	Service Provider Location

Special Ed Program Options

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

Disability Options

Code	Description
500	Deaf-Blindness
505	Emotional Disturbance
510	Cognitive Disability
515	Hearing Loss
525	Specific Learning Disability
530	Multiple Disabilities
535	Orthopedic Impairment
540	Visual Loss
545	Deafness
550	Speech/Language
555	Other Health Impairment
560	Autism Spectrum Disorder
565	Traumatic Brain Injury
570	Developmental Delay

SD December Child Count Report (South Dakota) [.2124 - .2219]