School Discipline and Attendance - Student Demographics (Colorado) [.2148 - .2223]

Classic View: CO State Reporting > Data Pipeline > School Discipline and Attendance > Student Demographics

Search Terms: School Discipline and Attendance

The Student Demographics File reports ALL students involved in behavior incidents that are reported in the Discipline by Action File. One record reports for each student with an applicable behavior incident where at least one day falls within the reporting period (Start Date - End Date, entered on the report editor). 

Data reports for each unique combination in the following categories:

  • Race/Ethnicity
  • Gender
  • Grade Level
  • Special Education Involvement
  • 504 Status
  • ELL Status

The Summary Type reports the total number of students for the specified behavior/allegation type. The Detail Type reports each student's behavior event/resolutions by event.

The Detail Type is NOT in a state-compliant format. 

Student Demographics Editor

Report Logic

The Summary Report Type reports a record reports for each individual student involved in Behavior Incidents that report in the Discipline by Action Extract, where at least one day falls within the reporting period. Only one record reports for each student per incident. If there are no discipline incidents for the student, a record is not reported.

If a student has more than one event with a resolution tied to an incident, the resolution that has a value in the Most Serious Action field reports; if that field is not populated, the resolution with the highest eventID (most recently generated). If more than one student is tied to an incident, each student reports.

  • Enrollment Service Type is Primary (P), Partial (S) or Special Ed Services (N).
  • Grade level of enrollment is 002, 004, 006, 007, 010, 020, 030, 040, 050, 060, 070, 080, 090, 100, 110, 120.
  • Behavior incidents contain Behavior Events with state-mapped resolutions. All events must have a resolution with a mapped resolution in order to report EXCEPT Event Codes 18-22.
  • At least one day of the Behavior Incident must fall within the reporting period.
  • The resolution must have occurred in the selected calendar. If a behavior event occurs on the last day of school for the 2018-19 school year, but the resolution was not assigned until the first day of the 2019-20 school year, the record reports when the 2019-20 calendar is selected.

When the role assigned to a participant is Victim, a resolution is NOT required for the following fields:

  • Students Reported as Harassed or Bullied on the Basis of Sex (field 24)
  • Students Reported as Harassed or Bullied on the Basis of Race or Color of National Origin (field 25)
  • Students Reported as Harassed or Bullied on the Basis of Disability (field 26)

All resolutions mapped to a state code of 06:Referred to Law Enforcement are counted, regardless of the Most Severe field being marked. This may cause more than one resolution to report for an incident.

The Detail Report Type uses the same logic, except that it reports ALL resolutions tied to reportable incidents, regardless if they are marked as Most Serious or not, one line per student for every resolution that reports on the Summary Report Type. This means the counts on the Detail Report Type DO NOT match the counts on the Summary Report Type when an incident includes more than one student.

Students are not included when:

  • The enrollment is marked as state exclude or no show.
  • The grade level of enrollment is marked as state exclude.
  • The calendar of enrollment is marked as state exclude.

Report Editor

Data ElementDescription
Extract Type

Selection indicates what file generates.

  • Discipline by Action
  • Firearm (GFSA)
  • Attendance Data File
  • Student Demographics
TypeIndicates whether a Summary report generates or a Detail report generates. Note that the Detail Type is NOT in a state-compliant format.
Start Date
Indicates the start date by which to report behavior events. At least one day of the Behavior Incident must fall within or on the start and end date.

Dates are entered in mmddyy format or use the calendar icon to select a date.
End DateIndicates the end date by which to report behavior events. At least one day of the Behavior Incident must fall within or on the start and end date.

Dates are entered in mmddyy format or use the calendar icon to select a date.
Ad hoc FilterWhen chosen, only those students included in the selected ad hoc filter are reported in the extract, if they meet the requirements of the extract.
FormatDetermines the layout of the report. Choose either CSV or HTML.
Calendar SelectionSelect at least one calendar from which to report student discipline information.
Report GenerationUse the Generate Extract button to display the results of the extract immediately. If there is a larger data set being reported, use the Submit to Batch option to choose when the extract generates (after or before school hours, etc.). See the Batch Queue article for more information.

Generate the Report

  1. Select the Student Demographics Extract Type.
  2. Select either the Summary Report Type or the Detail Report Type.
  3. Enter a Start Date and End Date.
  4. If desired, select an Ad hoc Filter to return only students included in that filter.
  5. Select the desired Format, either CSV or HTML, from the dropdown list. 
  6. Select at least one Calendar from which to report discipline records. Calendars can be chosen by active year, by school name or by year.
  7. Click the Generate Extract button or the Submit to Batch button. The report displays in the selected format.

Student Demographics - CSV Format

Student Demographics - HTML Format

Report Layout

Data ElementsDescriptionLocation
District CodeReports the State District Number.

Numeric, 4 digits
System Administration > Resources > District Information > State District Number

District.number
School CodeReports the number assigned to the school building by the state department of education.

When a student has a Special Education Attendance Code of 31: Administrative Unit OR 32: State-Operated Program, the four-digit code reports from the Serving District field on the student's most recent enrollment record as of the entered effective date, the end date of report generation, or the most recent enrollment closest to the end date of report generation. 


For all other students, the student's latest enrollment where the Special Education Start Date is populated and at least one active Special Education date falls within the reporting period or the most recent enrollment closest to the end date of report generation. 

  • The Service Agency/Facility code reports, if populated.
  • If the Service Agency/Facility Code field is not populated, the School of Accountability reports, if populated.
  • If the School of Accountability field is not populated, the School Number of the student's most current enrollment or most recent enrollment as of the Effective Date or End Date of report generation.      
  • If all of these fields are not populated, a value of 0000 reports.
Numeric, 4 digits

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


Enrollment.serviceDistrict


Student Information > General > Enrollments > Special Education Fields > Service Agency/Facility Code


Enrollment.serviceFacility     


Student Information > General > Enrollments > State Reporting Fields > School of Accountability


Enrollment.residentSchool      


System Administration > Resources > School > School Editor > State School Number


School.number


Ethnicity/Race

Reports the student's race/ethnicity code:

  • 01 - American Indian or Alaska Native
  • 02 - Asian
  • 03- Black (not Hispanic)
  • 04 - Hispanic
  • 05 - White (not Hispanic)
  • 06 - Native Hawaiian or other Pacific Islander
  • 07 - Multiple races

Numeric, 2 digits

Census > People > Demographics > Person Information > Race/Ethnicity


Identity.raceEthnicity
Gender

Reports the gender assigned to the student when the Report Legal Gender checkbox is marked.

  • 01 - Female
  • 02 - Male

Numeric, 2 digits

Census > People > Demographics > Person Information > Gender

Identity.gender
Grade Level

Reports the grade level of the student for the reported action.

  • 004 - Pre-Kindergarten (preschool)
  • 006: Half Day Kindergarten
  • 007 - Full Day Kindergarten
  • 010 - Grade 1
  • 020 - Grade 2
  • 030 - Grade 3
  • 040 - Grade 4
  • 050 - Grade 5
  • 060 - Grade 6
  • 070 - Grade 7
  • 080 - Grade 8
  • 090 - Grade 9
  • 100 - Grade 10
  • 110 - Grade 11
  • 120 - Grade 12

Numeric, 3 digits

Student Information > General > Enrollments > General Enrollment Information > Grade


Enrollment.grade



System Administration > Calendar > Calendar > Grade Levels > State Grade Level

Disability/IDEA Status

Indicates if the record is for an IDEA/Special Education student.


Reports a value of 1 when:

  • The Behavior Incident Date falls within the Special Education Start and Exit Dates on the Enrollment Record
  • The student has an active locked IEP at the time of the incident. 


Otherwise, reports a value of 0. 


Numeric, 1 digit

Student Information > Enrollments > Special Ed Fields > Special Ed Start Date, Special Ed Exit Date


Enrollment.spedStartDate

Enrollment.spedExitDate


Student Information > Special Education > Documents > IEP 


Behavior > Behavior > Management > Date of Incident


BehaviorEvent.date


Behavior > Behavior < Management > Resolution Start Date


BehaviorResolution.startDate

Section 504 Status

Indicates if the record is for students identified as handicapped under regulations implementing Section 504 of the Rehabilitation Act of 1973, but may or may not be eligible for special education placement under the Individuals with Disabilities Education Act.


Reports a value of 1 when there is a Section 504 record at any point during the reporting period.


Otherwise, reports a value of 0.


Numeric, 1 digit

Student Information > Program Participation > Section 504

Section504.section504ID
LEP Status

Indicates if the record is for a student who was identified as being Limited English Proficient.


Reports based on the student's LEP Status as of the time of the incident.

  • For students who do not have LEP services, reports 0.
  • For students who have LEP services, reports 1.

Numeric, 1 digit

Student Information > Program > Program Participation > LEP > LEP

Lep.lep
Unduplicated Count of Students Disciplined

Reports the unduplicated count of students involved in a behavior incident in which the State Behavior Resolution Code is 00-09, 11


 When a student has a behavior event with a State Resolution Code of 00-09 and 11, a count of 1 reports.


Otherwise, a value of 0 reports.


Numeric, 1 digit

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Classroom Removals

Reports the total number of students (not incidents) who were removed by the teacher or suspended from the classroom. If a student was removed or suspended multiple times, each time is included in this count.


Reports the count of instances when a student has a behavior event with a State Behavior Resolution Code is 01: Classroom Suspension/Teacher Removal marked as Most Serious Resolution.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
In-School Suspensions

Reports the total number of students (not incidents) who received an in-school suspension. If a student received multiple in-school suspensions, each time is included in this count.


Reports a count of instances when a student has a behavior event with a State Behavior Resolution Code is 02: In School Suspension marked as Most Serious Resolution.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Received Only One Out-of-School Suspension

Reports the total number of students (not incidents) who received just one out-of-school suspension in the school year.


Reports a value of 1 when the student has a behavior event with a State Behavior Resolution Code is 03: Out of School Suspension marked as Most Serious Resolution AND the resolution was assigned to the student only once in the selected calendar year.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Received More than One Out-of-School Suspension

Reports the total number of students (not incidents) who received an out-of-school suspension more than once during the school year.


Reports a value of 1 when the student has a behavior event with a State Behavior Resolution Code is 03: Out of School Suspension marked as Most Serious Resolution AND the resolution was assigned to the student two or more times in the selected calendar year.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Total Out-of-School Suspensions

Reports the total number of students (not incidents) who received an out-of-school suspension. All instances of the student receiving an out-of-school suspension are counted.


Reports a value of 1 when the student has a behavior event with a State Behavior Resolution Code is 03: Out of School Suspension marked as Most Serious Resolution.


Otherwise, reports a value of 0.


Numeric, 1 digit

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Expulsions with Educational Services

Reports the total number of students (not incidents) who were expelled and were provided with educational services during the expulsion.


Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 04, 05, 08 or 11 marked as Most Serious Resolution AND Services During Expulsion is marked. All occurrences for the student are counted.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Expulsions without Educational Services

Reports the total number of students (not incidents) who were expelled and were not provided with educational services during the expulsion.


Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 04, 05, 08 or 11 marked as Most Serious Resolution AND Services During Expulsion is not marked. All occurrences for the student are counted.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Law Enforcement Referral

Reports the total number of students (not incidents) referred to law enforcement. Each time a student was referred to law enforcement is counted.


Reports the total number of instances when the student has a behavior event with a 

State Behavior Resolution Code is 06: Referred to Law Enforcement for Most Serious Action OR if the student has a behavior event

with a State Behavior Resolution Code is 06: Referred to Law Enforcement.  


Otherwise, reports a value of 0.


When the State Behavior Resolution Code is 18-22, that event is not included.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
School Related Arrest

Reports the total number of students (not incidents) who were arrested for any activity conducted on the school grounds, during off-campus school activities, or due to a referral by any school official.


Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code AND the School Related Arrest checkbox is marked.


Otherwise, reports a value of 0.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Other Action

Reports the total number of students (not incidents) in which another action was taken that has not been counted in any other category. Each other action is included, even if the student has been counted multiple times.


Reports the total number of instances when the student has a behavior event with a State Behavior Resolution Code is 07: Other Action Taken or 09: Removal Other, Death, Incarcerated, etc marked as Most Serious Resolution.


Otherwise, reports a value of 0.


The value reported here matches the value reported for the Other Actions field on the Discipline by Action report.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Transferred To Alternative School

Reports the number of students for each demographic combination who meet all of the following:

  • State Behavior Resolution Code is 04, 05, 08, 09 or 11.
  • The Services during Expulsion checkbox is marked.
  • The Transferred to Alternative School checkbox is marked (The Transferred to Alternative School checkbox is located at Behavior > Behavior Management > Behavior Resolution).


All others, report 0. 


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Resolution

Calculated value
Subjected to Mechanical Restraint

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event is assigned a Behavior Response code of M. All occurrences for the student are counted.


Detail Report Type:

Reports a count of Behavior Events assigned a Behavior Response code of M for the reported student. 


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Response Details > Response Type = M: Mechanical Restraint

Calculated value
Subjected to Physical Restraint

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event is assigned a Behavior Response code of P. All occurrences for the student are counted.


Detail Report Type:

Reports a count of Behavior Events assigned a Behavior Response code of P for the reported student. 


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Response Details > Response Type = P: Physical Restraint

Calculated value
Subjected to Seclusion

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event is assigned a Behavior Response Code of S. All occurrences for the student are counted.


Detail Report Type:

Reports a count of Behavior Events assigned a Behavior Response code of S for the reported student. 


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Response Details > Response Type = S: Seclusion

Calculated value
Students Reported as Harassed or Bullied on the Basis of Sex

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 18 and the Student Role is Victim. All occurrences for the student are counted.


Detail Report Type:

Reports a count of  Behavior Events that  have a State Event Code of 18 and the Student Role is Victim for the reported student.


NOTE: For both Report Types, a Behavior Resolution is NOT required for this field.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Participant Details > Role = V: Victim

Behavior > Admin > Behavior Event Types > State Event Code = 18: Allegations of harassment or bullying on the basis of sex

Calculated value
Students Reported as Harassed or Bullied on the Basis of Race or Color or National Origin

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 19 and the Student Role is Victim. All occurrences for the student are counted.


Detail Report Type:

Reports a count of  Behavior Events that  have a State Event Code of 19 and the Student Role is Victim for the reported student. 



NOTE: For both Report Types, a Behavior Resolution is NOT required for this field.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Participant Details > Role = V: Victim

Behavior > Admin > Behavior Event Types > State Event Code = 19: Allegations of harassment or bullying on the basis of race, color or national origin

Calculated value

Students Reported as Harassed or Bullied on the Basis of Disability

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 20 and the Student Role is Victim. All occurrences for the student are counted.


Detail Report Type:

Reports a count of  Behavior Events that  have a State Event Code of 20 and the Student Role is Victim for the reported student. 



NOTE: For both Report Types, a Behavior Resolution is NOT required for this field.


Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Participant Details > Role = V: Victim

Behavior > Admin > Behavior Event Types > State Event Code = 20: Allegations of harassment or bullying on the basis of disability

Calculated value
Students Disciplined for Bullying or Harassment on the Basis of Sex

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 18 and the Student Role is Offender. All occurrences for the student are counted.


Detail Report Type:

Reports a count of  Behavior Events that  have a State Event Code of 18 and the Student Role is Offender for the reported student.



Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Participant Details > Role = O: Offender

Behavior > Admin > Behavior Event Types > State Event Code = 18: Allegations of harassment or bullying on the basis of sex

Calculated value
Students Disciplined for Bullying or Harassment on the Basis of Race or Color or National Origin

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 19 and the Student Role is Offender. All occurrences for the student are counted.


Detail Report Type:

Reports a count of  Behavior Events that  have a State Event Code of 19 and the Student Role is Offender for the reported student. 



Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Participant Details > Role = O: Offender

Behavior > Admin > Behavior Event Types > State Event Code = 19: Allegations of harassment or bullying on the basis of race, color or national origin

Calculated value
Students Disciplined for Bullying or Harassment on the Basis of Disability

Summary Report Type:

Reports the sum of students for each demographic combination where the Behavior Event has a State Event Code of 20 and the Student Role is Offender. All occurrences for the student are counted.


Detail Report Type:

Reports a count of  Behavior Events that  have a State Event Code of 20 and the Student Role is Offender for the reported student. 



Numeric, 4 digits

Behavior > Behavior Management > Incident > Events and Participation > Participant Details > Role = O: Offender

Behavior > Admin > Behavior Event Types > State Event Code = 20: Allegations of harassment or bullying on the basis of disability

Calculated value
LASIDReports the student's local student number.

Numeric, 10 digits
Census > People > Demographics > Student Number

Person.studentNumber
Incident IDReports the incident ID.

This field only reports on the Detail Type Report.  

Numeric, 10 digits
Behavior > Behavior Management > Incident ID

BehaviorIncident.incidentID
Most SeriousWhen the Resolution being reported is marked as Most Serious, this field reports Yes.

Otherwise, this field reports No.

This field only reports on the Detail Type Report. 

Alphanumeric, Yes or No
Behavior > Behavior Management > Most Serious Action

BehaviorIncident.mostSeriousAction