Student Discipline and Health Related Exclusion (Maryland)

Classic View: MD State Reporting > Student Discipline and Health Related Exclusion

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

StepAction
1Campus finds the student's FTE on their enrollment.
2Campus finds the number of student day minutes from the calendar.
3Campus 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.

Percent Absent

Absent Value

Attendance Value

0-33

0

1

34-66

.5

.5

67-100

1

0

Report Editor Fields

FieldDescription
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.

  • By default, the date range start date is July 1 of the reporting year.
  • By default, the date range end date is June 30th of the reporting year. The End Date cannot be greater than June 30th of the reporting year.
Choose Grades

Only grade levels from schools that are active during the report date range display.

Ad Hoc FilterAd Hoc Filters are available for you to narrow report results.
FormatDetermines 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

ElementLogicCampus Interface
LEA NumberThe 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 NumberThe student's LEA-assigned ID number.

Numeric, 10 digits
Census > People > Demographics > Student Number
Last NameThe 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 NameThe 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 NameThe 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 SuffixThe 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 NameAn alternative first name preferred by the student.

Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Preferred Name
Date of BirthThe student's date of birth.

Date field, 8 characters

YYYYMMDD

Census > People > Identities > Current Identity > Date of Birth
GradeThe student's grade level.

Numeric, 2 digits
Student Information> General > Enrollments > Grade
Gender

The student's gender.

1 = Male
2 = Female

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 StatusIndicates 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.

Eligibility

Reports

Free

F

Reduced

R

Non-Reimbursable

N

Paid

N


Alpha, 1 character
FRAM > Eligibility  > Eligibility
MigrantIndicates 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.

ValueDescription
 2 

The student is in Code 504.

 2 reports when the student has an active 504 record with a Start Date before the extract editor End Date and one of the following:

  • 504 End Date is NULL OR  
  • 504 End Date is after the extract editor End Date 
     AND the student does not flag as E or 3

Students do NOT need an IEP to report as a 2.

3

The student has exited special education services and has been placed in Code 504.

3 reports when the student has a 504 flag that meets all of the following

  • Active as of extract editor End Date
  •  Start Date is after special ed exit Date
    AND
  • The most recent locked IEP meets ALL of the following.
    •  Special Ed Start Date that is prior to or equal to report extract editor End Date
    • IEP Closed Date is less than or equal to the extract editor Run Date    
    • Exit code is A or J
E

The student has exited special education services and is not currently receiving special education services.

E reports when

  • the student’s most recent IEP has a Special Ed Start Date that is prior to or equal to report extract editor End Date and the latest IEP Closed Date is less than or equal to the extract editor Run Date
    AND
  • the Exit code is A or J AND Special Ed Exit Date is before the incident date.

    AND
  • the student has no 504 record OR the student has a 504 record with a Start Date before the Special Ed Exit Date
NThe student does not have an IEP and is not receiving special education services.
Y

The student has an IEP and is receiving special education services.

Y reports when the most recent IEP has a Special Ed Start Date that is prior to or equal to the report extract editor End Date and the latest IEP Closed Date is less or equal to the extract editor Run Date AND meets one of the following:

  • Exit code is null
    OR
  • Exit code is not Null and is not A or J
    Or
  • Exit code is  A or J AND Special Ed Exit Date after the report End Date

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

  • the student's most recent IEP has a Special Ed Start Date prior to or equal to the report's End Date, AND
  • the IEP Closed Date is less than or equal to the report Run Date, AND
  • the Special Ed Certificate checkbox is selected, AND
  • one of the following requirements is met:
    • Exit Reason is null, OR
    • Exit Reason is not Null and is not A or J, OR
    • Exit Code is A or J AND Special Ed Exit date equal to or after the report End Date.

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.

EL Status

Reports

EL

Y

Exited EL

Y - (When incident date is on or before the EL Exited Date)

Exited EL

N  - (When incident date is after the EL Exited Date)

Not EL

N

Pending

N

No Record

N


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, 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 StatusIndicates 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:

  • Reports for Yes.
  • Reports U for Unknown.
  • Reports N for No.

Otherwise, reports blank.


Alpha, 1 character

Student Information > Enrollments > Military Connected
FillerN/AN/A
Submission DateThe 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:

  • 504 End Date is NULL OR
  • 504 End date is on or after the incident date

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:

  • Exit code is null, OR
  • Exit code is not Null and is not A or J, OR
  • Exit code is  A or J AND Special Ed Exit date after the incident date

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.

  • The days absent report from the Duration in School Days field.
  • The student must be absent a minimum of a half day to report. Half-day absences report as 000.5.

When the Offense Code is 001 or 002 and the Disposition Code is 950, the following logic applies.

  • When the student’s state attendance code is
  • The student must be absent 1 day to report as an offense.
  • 1 day absent reports as 001.0.
  • If the student does not have attendance tied to attendance codes 17 or 99 the event does not report.

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