Skip to main content
Skip table of contents

Expulsion and Suspension Letter Report

Introduction

You can use this report to generate expulsion/suspension letters for students against whom any of the following incidents have been reported: 

  • In School Suspension
  • Out of School Suspension
  • Removal to Another School
  • Removal to Alt Ed Program
  • Removal - Expulsion
  • Removal - Unilateral
  • Removal by Hearing Officer
  • Removal to Other

You can then send the letters to the parents or guardians of each student.

Back to Top

Selection Criteria

Selection criteria determine which database records are used in the report. 

School Selection

The report can be run for a single school at a time. 

Student Selection

The report selects students against whom an incident is reported and student is not excluded from state reporting.

Back to Top

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Current Selection StudentsRun the report for the current selection of students or all students.

Incident Start Date

Enter the start date of the incident.

Note: Enter the date in a format of MM/DD/YYYY.

Incident End Date

Enter the end date of the incident.

Note: Enter the date in a format of MM/DD/YYYY.

Letter to use Select the letter to be used from the drop-down list.
Include BehaviorSelect Yes to include.
Include DurationSelect Yes to include.
Include Action Taken Detail CommentsSelect Yes to include.
What to print at top of each pageSelect the relevant option.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item # or Position

Data Element

Description

[Table]FieldName

N/A

Reporting Period

This reporting period selected on the report interface is displayed.

N/A

N/A

### School Days

The number of school days included in the reporting period is displayed.

Calculated

N/A

GRADES

The grade levels selected on the report interface are displayed.

N/A

N/A

SPECIAL PROGRAMS

Included indicates that student attendance for special programs is included in the report. Excluded indicates that student attendance for special program is excluded from the report.

N/A

N/A

#

This is the sequential row number.

N/A

N/A

STUDENT NUMBER

This column displays the number assigned to this student for identification purposes. This field value is extracted from the Demographics page, Student Selection > Demographics.

[Students]student_number

N/A

STUDENT NAME

This column displays the student’s name in last name, first name format. This field is extracted from the Demographics page, Student Selection > Demographics.

[Students]LastFirst

N/A

GRD

This column displays the student’s grade during the reporting period selected for the report. This field is extracted from the Demographics page, Student Selection > Demographics.

[Students]Grade_Level

N/A

HOMEROOM

This column displays the number of the student’s homeroom. This field value is extracted from the Modify Info page, Student Selection > Modify Info.

[Students]home_room

N/A

DISTRICT OF RESIDENCE

This column contains the number identifying the student’s district of residence. This field value is extracted from the Edit Current Enrollment page, Student Selection > Transfer Info > Edit Current Enrollment.

Note: If a student was enrolled in multiple districts of residence, the district of residence in force at the time of the enrollment is reported.

[Students]District_of_residence

Or

[Reenrollments]district_of_residence

N/A

TRACK

This column displays the student’s track, if applicable. This field is extracted from the Edit Current/Previous Enrollment page, Student Selection > Transfer Info, based on the month and year selected for the report.

[Students]Track

N/A

SHRD

An am or pm value in this column indicates that the student shares time between two schools. This field value is extracted from the NJS Student tab, Start Page > Student Selection > State / Province – NJ > NJS Student.

[S_NJ_STU_X]shared_time

N/A

PTC

This column displays the PTC Code (Old or New) based on the student’s regular or special program enrollments for the reporting period. This field value is extracted from the NJS SpEd tab, Student Selection > State/Province – New Jersey > NJS SpEd.

If no PTC is found on NJS SpEd tab for Kindergarten and PreK students, the Part Time Student field found on the Modify Info page is used to derive a PTC value of 3H, 3F, 4H, 4F.

If no PTC is found on NJS SpEd tab for non KG and PreK students, the PTC for the currently enrolled special program enrollment is used.

[S_NJ_STU_X]ProgramTypeCode


[students]parttimestudent

N/A

ENTRY DATE

This column lists the student’s entry date for the current enrollment. This field value is extracted from the Edit Current Enrollment page, Student Selection > Transfer Info > Edit Current Enrollment.

[Students]entry_date

Or

[Reenrollments]entry_date

N/A

EXIT DATE

This column lists the student’s exit date for the current enrollment. This field value is extracted from the Edit Current Enrollment page, Student Selection > Transfer Info > Edit Current Enrollment.

If the exit date is blank, this field defaults to the student’s last day of school at the end of the year.

[Students]exit_date

Or

[Reenrollments]exit_date

N/A

POSSIBLE DAYS

This column displays the total possible days of membership for the reporting period.

CALCULATED

N/A

DAYS PRESENT

This column displays the total number of days the student was present during the reporting period.

CALCULATED

N/A

DAYS ABSENT

This column displays the total number of days the student was absent during the reporting period.

CALCULATED

N/A

DAYS NOT ENROLLED

This column displays the total number of days the student was not enrolled during the reporting period.

CALCULATED

N/A

DAYS OFF TRACK

This column displays the total number of days the student was off track during the reporting period.

CALCULATED

TOTALS

N/A

Number of Student, this page

This is the total number of students listed on each page.

CALCULATED

N/A

Total For Page

The attendance totals display for the students listed on this page. One total displays for the following columns: POSSIBLE DAYS, DAYS PRESENT, DAYS ABSENT, DAYS NOT ENROLLED, and DAYS OFF TRACK.

CALCULATED

N/A

Total Number of Students

This is the total number of students included on the report.

CALCULATED

N/A

Grand Total

The attendance totals display for all students included on the report. One total displays for the following columns: POSSIBLE DAYS, DAYS PRESENT, DAYS ABSENT, DAYS NOT ENROLLED, and DAYS OFF TRACK.

CALCULATED

N/A

Averages

The average daily membership (ADM) and the average daily attendance (ADA) for this reporting period display.

CALCULATED

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.