Bullying and Racism Report

 Field

Description

RCDTS Number (Override)

Enter the 15-digit RCDTS (Region, Country, District, Type, and School) number.

The value entered in this field will be used in the file name and the header in the report results.

Start Date

Enter the start date for the reporting period.

Format: MM/DD/YYYY. Default value Term Start Date

End Date

Enter the end date for the reporting period.

Format: MM/DD/YYYY. Default Value Term End Date

Incident ID

Unique identifier for the specific incident.

[S_IL_BullyingRacism_S]IncidentID

Number

10

RCDTS

Region-County-District-Type-School code, a unique identifier for schools in Illinois.

[S_IL_BullyingRacism_S]IncidentRCDTS

String

20

Date Allegation Received by the school

The date the school received the bullying or racism allegation.

[S_IL_BullyingRacism_S]Dt_Allegation_RECD

Date

8

Date of Alleged Incident

The date when the alleged incident occurred.

[S_IL_BullyingRacism_S]Dt_Allegation

Date

8

Sexual Harassment

Incidents involving unwelcome sexual advances or conduct.

Output: Y/N

[S_IL_BullyingRacism_S]Sex_Har

String

1

Discrimination or harassment on the basis of race, color or national origin

Incidents involving unfair treatment or harassment based on race, color, or national origin.

Output: Y/N

[S_IL_BullyingRacism_S]Har_RCN

string

1

Discrimination or harassment on the basis of sex

Incidents involving unfair treatment or harassment based on sex.

Output: Y/N

[S_IL_BullyingRacism_S]HAR_SEX

String

1

Discrimination or harassment on the basis of religion

Incidents involving unfair treatment or harassment based on religion.

Output: Y/N

[S_IL_BullyingRacism_S]HAR_REL

String

1

Discrimination or harassment on the basis of disability

Incidents involving unfair treatment or harassment based on disability.

Output: Y/N

[S_IL_BullyingRacism_S]HAR_DIS

String

1

Retaliation

Incidents involving adverse actions taken against someone for reporting bullying or discrimination.

Output: Y/N

[S_IL_BullyingRacism_S]Retaliation

String

1

Verified allegation of Bullying (non-cyber)

Confirmed incidents of bullying that do not involve electronic means.

Output: Y/N

[S_IL_BullyingRacism_S]Ver_Allegation_NonCyber

String

1

Verified allegation of Bullying (cyber)

Confirmed incidents of bullying that involve electronic means.

Output: Y/N

[S_IL_BullyingRacism_S]Ver_Allegaation_Cyber

String

1

Allegation Status

Current status of the bullying or racism allegation (e.g., pending, resolved).

Output can be 1 = Founded, 2 = Unfounded, or 3 = Investigation Pending.

[S_IL_BullyingRacism_S]Allegation_Status

Number

1

Investigation Pending Additional Information

Indicates if the investigation is awaiting more information.

[S_IL_BullyingRacism_S]Inv_Pend_AddInfo

String

500

Date Investigation Resolved

The date when the investigation was concluded.

[S_IL_BullyingRacism_S]Dt_Inv_Res

Date

8

The below columns needs value if Verified bullying is Y

None

Indicates no specific category applies

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_None

String

1

Race

Incidents involving discrimination or harassment based on race.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Race

String

1

Color

Incidents involving discrimination or harassment based on skin color.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Color

String

1

Religion

Incidents involving discrimination or harassment based on religion.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Religion

String

1

Sex

Incidents involving discrimination or harassment based on sex.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Sex

String

1

National Origin

Incidents involving discrimination or harassment based on national origin.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Origin

String

1

Ancestry

Incidents involving discrimination or harassment based on ancestry.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Ancestry

String

1

Physical Appearance

Incidents involving discrimination or harassment based on physical appearance.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Phy_App

String

1

Socioeconomic status

Incidents involving discrimination or harassment based on socioeconomic status.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Eco_Status

String

1

Academic Status

Incidents involving discrimination or harassment based on academic performance.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Aca_Status

String

1

Pregnancy

Incidents involving discrimination or harassment based on pregnancy.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Pregnancy

StTring

1

Parenting Issue

Incidents involving discrimination or harassment related to parenting.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Parent_Iss

String

1

Homeless

Incidents involving discrimination or harassment based on homelessness.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Homeless

String

1

Age

Incidents involving discrimination or harassment based on age.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Age

String

1

Marital Status

Incidents involving discrimination or harassment based on marital status.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Mar_Status

String

1

Physical /Mental Disability

Incidents involving discrimination or harassment based on physical or mental disability.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Disability

String

1

Military Status

Incidents involving discrimination or harassment based on military status.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Miltry_Status

String

1

Sexual Orientation

Incidents involving discrimination or harassment based on sexual orientation.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Sex_Orient

String

1

Gender-related identity or expression

Incidents involving discrimination or harassment based on gender identity or expression.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Gen_Iden

String

1

Unfavourable discharge from military service

Incidents involving discrimination or harassment based on an unfavorable discharge from military service.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Mil_Discharge

String

1

Association with a person or group with one or more or the aforementioned actual or perceived characteristics

Incidents involving discrimination or harassment based on association with individuals or groups with the listed characteristics.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Perceivd_Char

String

1

Any other distinguishing characteristics

Incidents involving discrimination or harassment based on other unique characteristics.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Dis_Char

String

1

School Adhered to bulling policy

Indicates if the school followed its bullying policy.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Sch_Policy

String

1

Parent notifications within 24 hours

Indicates if parents were notified within 24 hours of the incident.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Parent_Notf

String

1

Number of bulling incident referred to the compliant manager

The number of bullying incidents referred to the complaint manager.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_Inc_Ref

String

1

Number of safety plans issued to students as a result of bullying compliant investigation

The number of safety plans issued to students following a bullying investigation.

[S_IL_BullyingRacism_S]Bullying_Safety_Plans

Number

2

Other Pertinent information to the investigation

Any other relevant information related to the investigation.

[S_IL_BullyingRacism_S]Bullying_Peri_Info

String

500

Findings related to bullying compliant investigation

The findings from the bullying complaint investigation.

[S_IL_BullyingRacism_S]Bullying_Findings

String

500

Victim count for this incident

Total  number of Victims added in the incident

[S_IL_BullyingRacism_S]Bullying_Victim

Number

2

Bullying count for this incident

The number of bullying incidents involved

[S_IL_BullyingRacism_S]Bullying_Count

Number

2

IDHR training occurred

Indicates if training by the Illinois Department of Human Rights (IDHR) occurred.

Output: Y/N

[S_IL_BullyingRacism_S]Bullying_IDHR

String

1