Tool Search: Student Discipline and Health Related Exclusion
The Student Discipline and Health Related Exclusion extract reports discipline incidents that are associated with a state-coded disposition.
Student Discipline and Health Related Exclusion Editor
Report Logic
- This extract reports Behavior Incidents that have a state-coded resolution and incident dates between July 1st and June 30th of the reporting year.
- All incidents with a state coded resolution report regardless of whether or not they occur on the same date.
- If an incident contains multiple events, only the most serious event in which the the student participated reports. This is based on the event being marked as Most Severe. If multiple events have Most Severe marked or no events have it marked, the lowest event ID event reports.
- Offense Codes 001 (Immunization) and 002 (Personal health), report from the student's attendance. The student must be absent for the entire day and have the Role "Offender" to report.
Title I Determination Logic
- If the student has an active Title1 Flag with a state code of T1 and is marked as state reported as of the incident date Y reports; otherwise, move onto following logic.
If the student has a value in the home school field on their enrollment AND there is a school in the district with that state school code, then Campus finds the school record that falls as of the end date in the extract editor and reports the value from the Title 1 field on that school.
Code in School
Description
Reports
TGELGBNOPROG
Targeted Assistance Eligible - No Program
N
TGELGBTGPROG
Targeted Assistance Program
N
SWELIGTGPROG
School wide Eligible - Targeted Assistance
N
SWELIGNOPROG
School wide Eligible- No Program
N
SWELIGSWPROG
School wide Program
Y
NOTTITLE1ELIG
Not a Title I School
N
- If all values are null, N reports.
Absent Calculation for 001 and 002 Offense Codes
If the student does NOT have an FTE override filled out on their enrollment, the following logic applies.
Campus calculates the total number of absences for the reporting period based on the values found in System Administration > Calendar > Whole Day (absence), and Half Day (absence) Absences are defined by any attendance code tied to a state code of 17 or 99.
If the student HAS a value in the FTE override field on their enrollment, the following logic applies.
| Step | Action | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Campus finds the student's FTE on their enrollment. | ||||||||||||
| 2 | Campus finds the number of student day minutes from the calendar. | ||||||||||||
| 3 | Campus multiples the number of student day minutes by the FTE. | ||||||||||||
| 4 | Campus divides the number of minutes the student was absent by the product from number 3. Absences are defined by any attendance code tied to a state code of 17or 99.
|
Report Editor Fields
| Field | Description |
|---|---|
| Run Date | This date populates the Submission Date field on the extract. |
| Date Range | The report can be run to only include data with a date range.
|
| Choose Grades | Only grade levels from schools that are active during the report date range display. |
| Ad Hoc Filter | Ad Hoc Filters are available for you to narrow report results. |
| Format | Determines the format for the report. Use the Fixed Width (State Format) when submitting the final data. Use HTML or CSV for data review and testing. |
| Select Schools | The School(s) from which data is pulled for the report. The extract editor excludes schools not active during the report date range. Schools must have at least one instructional day on/after the start date OR on/before the end date of the report Date Range to appear in the Select Schools list. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Report Elements
| Element | Logic | Campus Interface | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LEA Number | The two-digit state designation of the local education agency (LEA). Numeric, 2 digits | System Administration > Resources > District Information > State District Number | ||||||||||||||
| School Number | The home school number from the student’s enrollment as of the Incident Date. If the home school number is null, the school number on the school table tied to the enrollment reports. Numeric, 4 digits | System Administration > Resources > School > State School Number | ||||||||||||||
State Assigned Student ID (SASID) | The student's state-assigned ID number. Numeric, 10 digits | Census > People > Demographics > Student State ID | ||||||||||||||
| Local Student ID Number | The student's LEA-assigned ID number. Numeric, 10 digits | Census > People > Demographics > Student Number | ||||||||||||||
| Last Name | The student's last name. Reports the last name from the current Identity record. Legal Last Name reports. If Legal Last Name is null, the Last Name reports. Alpha, 25 characters | Census > People > Identities > Current Identity > Legal Last Name or Last Name | ||||||||||||||
| First Name | The student's first name. Reports the first name from the current Identity record. Legal First Name reports. If Legal First Name is null, the First Name reports. Alpha, 15 characters | Census > People > Identities > Current Identity > Legal First Name or First Name | ||||||||||||||
| Middle Name | The student's middle name. Reports the middle name from the current Identity record. Legal Middle Name reports. If Legal Middle Name is null, the Middle Name reports. Alpha, 15 characters | Census > People > Identities > Current Identity > Legal Middle Name or Middle Name | ||||||||||||||
| Generational Suffix | The suffix tied to the student's name. Reports the suffix from the current Identity record. If the Legal First Name and Legal Name are not null, Legal Suffix reports. If the Legal First Name and Legal Middle Name are null, Suffix reports. Alpha, 3 characters | Census > People > Identities > Current Identity > Legal Suffix or Suffix | ||||||||||||||
| Preferred Name | An alternative first name preferred by the student. Alphanumeric, 15 characters | Census > People > Identities > Current Identity > Preferred Name | ||||||||||||||
| Date of Birth | The student's date of birth. Date field, 8 characters YYYYMMDD | Census > People > Identities > Current Identity > Date of Birth | ||||||||||||||
| Grade | The student's grade level. Numeric, 2 digits | Student Information> General > Enrollments > Grade | ||||||||||||||
| Gender | The student's gender. 1 = Male X: Non-Binary Reports the gender from the current Identity record. Legal Gender reports. If Legal Gender is null, Gender reports. Numeric, 1 digit | Census > People > Identities > Current Identity > Legal Gender or Gender | ||||||||||||||
| Hispanic or Latino Ethnicity | Indicates whether the student is considered Hispanic/Latino. If the Is the individual Hispanic/Latino? field = Yes, Y reports. Otherwise, N reports. Alpha, 1 character Y or N | Census > People > Demographics > Race Ethnicity > Is the individual Hispanic/Latino? | ||||||||||||||
| American Indian or Alaska Native | Indicates whether the person has origins in any of original peoples of North and South America (including Central America) and who maintains cultural identification through tribal affiliation or community attachment. 1 = Yes 0 = No or Null Alpha, 1 character | Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native | ||||||||||||||
| Asian | Indicates whether the person has origins in any of original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, Philippine Islands, Thailand, and Vietnam. 2 = Yes 0 = No or Null Alpha, 1 character | Census > People > Demographics > Race/Ethnicity > Asian | ||||||||||||||
| Black or African American | Indicates whether the person has origins in any of the black racial groups of Africa. 3 = Yes 0 = No or Null Alpha, 1 character | Census > People > Demographics > Race/Ethnicity > Black or African American | ||||||||||||||
| Native Hawaiian or Other Pacific Islander | Indicates whether the person has origins in any of original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. 4 = Yes 0 = No or Null Alpha, 1 character | Census > People > Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander | ||||||||||||||
| White | Indicates whether the person has origins in any of original peoples of Europe, Middle East, or North Africa. 5 = Yes 0 = No or Null Alpha, 1 character | Census > People > Demographics > Race Ethnicity > White | ||||||||||||||
| Homelessness Status | Indicates whether the student lacks a fixed, regular, and adequate nighttime residence. Alpha, 1 character Y or N | Student Information > General > Enrollments > State Reporting Fields > Homeless | ||||||||||||||
Title I Indicator | Indicates whether the student participated in a Title 1 program. See the Title I Determination Logic for more information. Alpha, 1 character | System Administration > Resources > School > Title 1 and Student Information > General > Enrollments > State Reporting Fields > Title 1 OR System Administration > Resources > School > Title 1 = School wide program | ||||||||||||||
Free/Reduced Price Meals | Indicates if the student receives free/reduced price meals. If the Migrant element reports Y, then this field reports F. Otherwise, the field reports from the FRAM record as of the end date entered on the extract editor.
Alpha, 1 character | FRAM > Eligibility > Eligibility | ||||||||||||||
| Migrant | Indicates whether the student is a migrant. Alpha, 1 character | Student Information > General > Enrollment > State Reporting Fields > Migrant | ||||||||||||||
Foreign Exchange Student | Indicates whether the student is a foreign exchange student. If the student is in grade 9-12 as of the end date selected on the extract editor, Y reports if the Foreign Exchange record is Y, J1, or F1. Otherwise, N reports. If the student is not in grades 9-12, N reports. Alpha, 1 character Y or N | Student Information > General > Enrollment > State Reporting Fields > Foreign Exchange | ||||||||||||||
Special Education | Indicates the student's special education services. Values are reported as of the Effective Date entered on the extract editor.
Alphanumeric, 1 character | Student Information > General > Enrollment >Special Ed Fields > Special Ed Status | ||||||||||||||
Special Education End Date | The date on which special education services ended. This date reports from the most recent IEP as of the Effective Date entered on the extract editor. Date field, 8 characters YYYYMMDD | Student Information > Special Ed > Documents > IEP > Special Ed Exit Date | ||||||||||||||
Special Education Certificate | Indicates whether the student is on track to receive a MD High School Certificate of Completion. This is required if Special Education Services = Y. Y reports when
Otherwise, N reports. Alphanumeric, 1 character | Student Information > General > Flags Programs Admin > Flags > State Program Type > State Reported (Flag is tied to state program type of certificate and State Reported checkbox is marked) | ||||||||||||||
English Learner (EL) Status | Indicates whether the student has a primary or home language other than English and has been assessed as having limited or no ability to understand, speak or read English. Reports the student’s most recent EL record where the Identified Date is on or before the End Date on the extract editor.
Alpha, 1 character | Student Information > Program Participation > English Learners (EL) > EL > Program Status | ||||||||||||||
| English Learner Entry into the US Date | The date when the student began EL services or entered the United States for the first time. If the Date Entered US field is null, the Date Entered US School reports. If the Date Entered US School field is null, the Identified Date from the earliest EL record reports. Date field, 8 characters YYYYMMDD | Census > People > Demographics > Date Entered US School Student Information > Program Participation > English Learners (EL) > EL > Identified Date | ||||||||||||||
| EL Begin Date | The date when the student's ELL services started. Date field, 8 characters YYYYMMDD | Student Information > Program Participation > English Learners (EL) > EL > Program Start Date | ||||||||||||||
| EL End Date | The date when the student's ELL services ended. Date field, 8 characters YYYYMMDD | Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date | ||||||||||||||
| English Learner ELA Assessment Exempt Status | Indicates the student receiving ESOL services in their first year of enrollment in a U.S. school is exempt from the PARCC English/Language Arts assessment and may substitute the required state assessment with the English Language Proficiency Assessment (ACCESS for ELs 2.0). When EL Status = Y, Y reports for student’s in their first year of enrollment in a U.S. School. Otherwise, N reports. Students are exempt if they are within 1 calendar year (365 days) of their first day enrolled in a US school. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL > Program Status | ||||||||||||||
| Foster Care Status | Indicates whether the student is in foster care. Y reports when the student has an active foster care record as of the report end date selected in the extract editor OR the student’s enrollment end date. Otherwise, N reports. Alpha, 1 character Y or N | Student Information > Program Participation > Foster Care | ||||||||||||||
| Military Connected Indicator | Indicates whether the student has a parent or guardian in the military. Reports the value populated:
Otherwise, reports blank. Alpha, 1 character | Student Information > Enrollments > Military Connected | ||||||||||||||
| Filler | N/A | N/A | ||||||||||||||
| Submission Date | The date the file was submitted to the MSDE. This is generated via the date entered in the Run Date field on extract editor. Date field, 8 characters YYYYMMDD | Not dynamically stored | ||||||||||||||
| 504 Indicator | Indicates whether the student is 504. Y reports when the student has an active 504 record with a start date on or before the incident date AND has one of the following:
Alpha, 1 character Y or N | Programs > Flags > 504 with State Reported marked Student Information > General > Flags > 504 | ||||||||||||||
| Disability Code | Indicates the student's primary disability. The primary disability is the major category of disability under which the student needs special education services. The Disability Code reports from the latest IEP where the Special Ed Start Date is prior to or equal to the incident date and the latest IEP Closed Date for the IEP is less or equal to the extract editor run date AND meets one of the following:
Numeric, 2 digits | Student Information > Special Ed > Documents > IEP > Print Format is MD SPED Date > Detail Editor > Start Date, IEP Closed Date, Exit Code, Disability type | ||||||||||||||
Offense Code | The code that best describes the incident in which the student was disciplined. The State Event Code reports. If the event is not associated with a State Event Code, the Event Code is reported. The first 3 digits of the event code report. Alphanumeric, 3 characters | Behavior > Event and Participant Details > Event Type (mapped to a State Event Code) | ||||||||||||||
Date of Offense | The date on which the offense which required disciplinary action occurred. Date field, 8 digits YYYYMMDD | Behavior > Behavior Management > Incident Detail Information > Date of Incident | ||||||||||||||
| Disposition Code | Indicates the action taken in response to the offense. The state resolution code reports if it's mapped to one of the following State Resolution Codes: 910‐913, 920, 930, 940‐942, 950, 960. If the resolution type is not mapped to a state resolution code, the local resolution code reports if the first 3 digits are 910-913, 920, 930, 940-942, 950, or 960. The first 3 digits of the resolution code report. Alphanumeric, 3 characters | Behavior > Behavior Management > Resolution Details > Resolution Type (mapped to a State Event Code) | ||||||||||||||
Length of Removal | The number of days the student was removed from their current placement at the time of the offense. When the Offense Code is not 001 or 002, the following logic applies.
When the Offense Code is 001 or 002 and the Disposition Code is 950, the following logic applies.
Records for offense codes of 001 or 002 with a Disposition code of 950 entered in Behavior Management do not report. Numeric, 5 digits NNN.N | Behavior> Resolution Details > Duration in School Days OR Attendance Calculation | ||||||||||||||
Physical Injury | Indicates if the offense resulted in physical injury. Alpha, 1 character | Behavior > Medical Services Provided | ||||||||||||||
Type of Educational Services Provided | The code that best describes the type of educational services the suspended/expelled student is receiving. Numeric, 1 digit | Behavior > Behavior Management > Resolution Details > Educational Services Provided |
