As of the Campus.2311 release, the ASSA Student Sent extract has been updated to better align with the NJ SMART SID Management Report. Please see ASSA Student Sent (New Jersey) for information on the previous version.

Tool Search: ASSA

The ASSA Student Sent Report provides a list of sent students by receiving district and grade level.

ASSA Student Sent Report Editor

Report Logic

Provide a count for each non-consolidated student enrollment with a Start Date <= extract editor End Date and End Date of null or >= extract editor Start Date (at any point within the extract editor Start and End Date range), when the following are true:

No Show box is NOT checked.
When extract editor > State Exclude = Exclude State Exclude Enrollments:
- Only enrollments with State Exclude NOT checked report.
When extract editor > State Exclude = Include State Exclude Enrollments:
- Enrollments with State Exclude checked OR not checked may report.
When extract editor > State Exclude = Only State Exclude Enrollments:
- Only report records for students with State Exclude checked.
When Attending District is blank and does not match the State District Number of the Campus district.
When the enrollment's Tuition Code is NOT '06' or '07'.

Consolidated Enrollments

When the student has any enrollments on or between the extract editor date range that match on the following fields, the student must only be counted once for these enrollments, with the reported enrollment prioritized by the following: Primary enrollment, then latest (or blank) End Date, then latest Start Date, then the highest 'enrollmentID'.

School Entry Date
County Code Attending
District Code Attending
School Code Attending

Record counts are separated by Attending District.

Top record per separated Attending District group lists the State District Number beneath the "Line" column and the District Name in the Enrollment Category column.
The second record lists the Attending District number and Name of the Attending District.
An Attending District group (local district through the highest grade level) reports when any student in the extract calendars selected have a reporting enrollment with Attending District is not Null.
- An Attending District group reports only once on the report.
- All applicable students report within their assigned Attending District group.
Each record group must be separated by a blank row as seen in the image below.

Students without State IDs:

When 'Students w/o stateIDs' is NOT checked on the extract editor:
- Return a record for students with a null and non-null Student State ID
When 'Students w/o stateIDs' is checked on the extract editor:
- Return a record for only students with a null Student State ID

The student's enrollment must be active on at least 1 day included on the report.

When the student has more than 1 enrollment during the extract editor date range, each enrollment is separately included on the report unless otherwise consolidated or excluded.

Exclude enrollments:

In calendars with 'Exclude' checked.
With a grade that is grade-level excluded.
With 'No Show' checked.
With Tuition Code of '06' or '07'.

Report Editor

Field	Description
Extract Type	Determines which ASSA extract generates. For this extract, select Student Sent.
Reporting Period Start Date	The extract Start Date. Dates are entered in mmddyy format or can be chosen using the calendar icon.
Reporting Period End Date	The extract End Date. Dates are entered in mmddyy format or can be chosen using the calendar icon.
Students w/o state IDs	Includes students with a blank State ID field. (Census > People > Demographics > Student State ID)
Include Student Detail Report	Generates the ASSA School Detail when checked. The Detail report begins on page 3 of the file and displays a record for each student included on the Summary report on page 1. Records are sorted by State School Number, then by Enrollment Category, then by State ID.
State Exclude	Drop list options: Exclude State Exclude Enrollments (default) Include State Exclude Enrollments Only State Exclude Enrollments
Ad Hoc Filter	Select an Ad hoc filter to limit report results to students that meet filter requirements.
Format	Determines how the report displays. Drop list options: PDF (State Format) DOCX CSV
Calendar Selection	Select the calendar of enrollment from which to pull student data. Calendars can be chosen by the active year, school name, or year. Selection of at least one calendar is required.
Report Generation Options	Choose Generate Extract to display the results immediately. Select the Submit to Batch option to generate the report at a specified time. This option is helpful when generating large amounts of data.

Generate the Report

Select Student Sent from the Extract Type dropdown list.
Enter a Reporting Period Start Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
Enter a Reporting Period End Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
Check the Students w/o state IDs and/or Include Student Detail Report boxes (when such filtering is desired).
Select the appropriate Exclude option (Exclude State Exclude Enrollments is the default).
Select an Ad hoc filter to limit report results to students that meet filter requirements.
Select the Report Format in which you wish to generate the report.
Select at least one Calendar from the list of options.
Click the Generate Extract button. The report displays in the selected format.

Example Reports

The report includes a Date/Time stamp to indicate when the report was generated.

ASSA Student Sent Summary Report

ASSA Student Sent Detail
(Generates when the 'Include Student Detail Report' option is selected on the report editor)

Report Layout

ASSA Student Sent Summary

Click here to expand...

Data Element Name	Description	Location
Line	The report line. Mapped from the state's State Grade Level codes used in the NJ SMART SID Management extract. C1, C2, D1, D2, 01 - 28, 37 - 39 The top row of each Attending District group contains the local State District Number.	System Administration > Calendar > Calendar > Grade Levels > State Grade Level Code
Enrollment Categories	Report the enrollment's Program Type when Program Type NOT = null or MG. When Program Type = null or MG: Include students in the appropriate Line based on their enrollment's mapped State Grade Level: C1 = State Grade of: 3H C2 = State grade of: 4H, 5H D1 = State Grade of: 3F D2 = State Grade of: 4F, 5F Line 01 = State Grade of: DH, KH Line 02 = State Grade of: DF, PF, KF Line 03 = State Grade of: 01 Line 04 = State Grade of: 02 Line 05 = State Grade of: 03 Line 06 = State Grade of: 04 Line 07 = State Grade of: 05 Line 08 = State Grade of: 06 Line 09 = State Grade of: 07 Line 10 = State Grade of: 08 Line 11 = State Grade of: 09 Line 12 = State Grade of: 10 Line 13 = State Grade of: 11 Line 14 = State Grade of: 12 Line 15 = State Grade of: PG Line 16 = State Grade of: A2 Line 17 = State Grade of: A1 Line 18 = Sum of Lines C1 thru 17 Line 19 = Special Ed Status = Y Primary Disability = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16 State Grade of: 3H, 3F, 4H, 4F, 5H, 5F, DH, DF, PF, 01, 02, 03, 04, 05, KF or KH Line 20 = Special Ed Status = Y Primary Disability = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16 State Grade of: 06, 07, 08 Line 21 = Special Ed Status = Y Primary Disability = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16 State Grade of: 09, 10, 11, 12 Line 28 = Sum of Line 19, 20, and 21 Line 37 = Program Type Code = 56 Line 38 = Program Type Code = 57 Line 39 = Sum of all individual line totals above.	Student Information > General > Enrollments > State Reporting Fields > Program Type
Total Sent, Full Time	Reports the total number of sent full-time students by grade or special education category in the selected school, enrolled on October 14.	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
Total Sent, Shared Time	Report the total number of sent shared-time students by grade or special education category in the selected school, enrolled on October 14. These students attend two different schools in one day. Shared-time arrangements are not limited to those involving a program provided by a county vocational school.	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
Low Income Sent, Free Lunch - Full Time	Report the total number of sent full-time free lunch students for each grade and special education level in the selected school, enrolled on October 14. The free lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
Low Income Sent, Free Lunch - Shared Time	Report the total number of sent shared-time free lunch students for each grade and special education level in the selected school, enrolled on October 14. The free lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
Low Income Sent, Reduced Lunch - Full Time	Report the total number of sent full-time reduced lunch students for each grade and special education level in the selected school, enrolled on October 14. The reduced lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
Low Income Sent, Reduced Lunch - Shared Time	Report the total number of sent shared-time reduced lunch students for each grade and special education level in the selected school, enrolled on October 14. The reduced lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
LEP Sent, LEP Not Low Income - Full Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate. LEP record with: Identified Date <= Reporting Period End Date Program Exit Date of null or > Reporting Period End Date Student does NOT have a FRAM record that meets the following F or R criteria: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free or Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
LEP Sent, LEP Not Low Income - Shared Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate. LEP record with: Identified Date <= Reporting Period End Date Program Exit Date of null or > Reporting Period End Date Student does NOT have a FRAM record that meets the following F or R criteria: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free or Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
LEP Sent, LEP & Low Income - Full Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate. LEP record with: Identified Date <= Reporting Period End Date Program Exit Date of null or > Reporting Period End Date Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free or Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
LEP Sentl, LEP & Low Income - Shared Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate.	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
Speech Only, Sent - Full Time	The Speech Only count is a subset of the total sent count. Students are counted on the Speech Only column in the ASSA if the NJSMART Special Education Classification includes: 17: Eligible for Speech-Language Services Student's enrollment has: Special Ed Status = Y Primary Disability = 17 State Reporting Fields > Shared Time NOT = Checked
Speech Only, Sent - Shared Time	The Speech Only count is a subset of the total sent count. Students are counted on the Speech Only column in the ASSA if the NJSMART Special Education Classification includes: 17: Eligible for Speech-Language Services Student's enrollment has: Special Ed Status = Y Primary Disability = 17 State Reporting Fields > Shared Time = Checked

ASSA Student Sent Detail

This information is provided when the 'Include Student Detail Report' checkbox is marked on the extract editor. The Detail report displays a record for each student included on the Summary report. Records are sorted by Enrollment Category and then by State ID.

Click here to expand...

Data Element Name	Description	Location
State ID	A unique identifier assigned to the student by the state. Numeric, 10 digits	Census > People > Demographics > Person Identifiers > State ID Person.stateID
Last Name	The student's legal last name. Alphanumeric, 50 characters	Census > People > Identities > Person Information > Last Name Identity.lastName
First Name	The student's legal first name. Alphanumeric, 30 characters	Census > People > Identities > Person Information > First Name Identity.firstName
Age	The student's age based on the student's Birth Date on the extract Reporting Period End Date. Numeric, 2 digits	Census > People > Demographics > Person Information > Birth Date Identity.birthDate
Line	The report line. Mapped from the state's State Grade Level codes used in the NJ SMART SID Management extract. C1, C2, D1, D2, 01 - 28, 37 - 39	System Administration > Calendar > Calendar > Grade Levels > State Grade Level Code
Enrollment Category	Report the enrollment's Program Type when Program Type NOT = null or MG. When Program Type = null or MG: Include students in the appropriate Line based on their enrollment's mapped State Grade Level: C1 = State Grade of: 3H C2 = State grade of: 4H, 5H D1 = State Grade of: 3F D2 = State Grade of: 4F, 5F Line 01 = State Grade of: DH, KH Line 02 = State Grade of: DF, PF, KF Line 03 = State Grade of: 01 Line 04 = State Grade of: 02 Line 05 = State Grade of: 03 Line 06 = State Grade of: 04 Line 07 = State Grade of: 05 Line 08 = State Grade of: 06 Line 09 = State Grade of: 07 Line 10 = State Grade of: 08 Line 11 = State Grade of: 09 Line 12 = State Grade of: 10 Line 13 = State Grade of: 11 Line 14 = State Grade of: 12 Line 15 = State Grade of: PG Line 16 = State Grade of: A2 Line 17 = State Grade of: A1 Line 18 = Sum of Lines C1 thru 17 Line 19 = Special Ed Status = Y Primary Disability = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16 State Grade of: 3H, 3F, 4H, 4F, 5H, 5F, DH, DF, PF, 01, 02, 03, 04, 05, KF or KH Line 20 = Special Ed Status = Y Primary Disability = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16 State Grade of: 06, 07, 08 Line 21 = Special Ed Status = Y Primary Disability = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, or 16 State Grade of: 09, 10, 11, 12 Line 28 = Sum of Line 19, 20, and 21 Line 37 = Program Type Code = 56 Line 38 = Program Type Code = 57 Line 39 = Sum of all individual line totals above.	Student Information > General > Enrollments > State Reporting Fields > Program Type
Total Sent - Full Time	Reports the total number of full-time students by grade or special education category in the selected school, enrolled on October 14.	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
Total Sent - Shared Time	Report the total number of shared-time students by grade or special education category in the selected school, enrolled on October 14. These students attend two different schools in one day. Shared-time arrangements are not limited to those involving a program provided by a county vocational school.	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
Low Income Sent, Free Lunch - Full Time	Report the total number of sent full-time free lunch students for each grade and special education level in the selected school, enrolled on October 14. The free lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
Low Income Sent, Free Lunch - Shared Time	Report the total number of sent shared-time free lunch students for each grade and special education level in the selected school, enrolled on October 14. The free lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
Low Income Sent, Reduced Lunch - Full Time	Report the total number of sent full-time reduced lunch students for each grade and special education level in the selected school, enrolled on October 14. The reduced lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
Low Income Sent, Reduced Lunch - Shared Time	Report the total number of sent shared-time reduced lunch students for each grade and special education level in the selected school, enrolled on October 14. The reduced lunch sent count is a subset of the total sent count. Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
LEP Sent, LEP Not Low Income - Full Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate. LEP record with: Identified Date <= Reporting Period End Date Program Exit Date of null or > Reporting Period End Date Student does NOT have a FRAM record that meets the following F or R criteria: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free or Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked)
LEP Sent, LEP Not Low Income - Shared Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate. LEP record with: Identified Date <= Reporting Period End Date Program Exit Date of null or > Reporting Period End Date Student does NOT have a FRAM record that meets the following F or R criteria: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free or Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
LEP Sent, LEP & Low Income - Full Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate. LEP record with: Identified Date <= Reporting Period End Date Program Exit Date of null or > Reporting Period End Date Student has a FRAM record with: Start Date <= extract Reporting Period End Date End Date >= extract Reporting Period End Date Eligibility = Free or Reduced	Student Information > General > Enrollments > State Reporting Fields > Shared Time (not checked) FRAM > Eligibility > Eligibility POSEligibility.eligibility
LEP Sent, LEP & Low Income - Shared Time	The LEP counts are subsets of the total sent count. Students are counted as LEP students if they have an LEPProgramStartDate and do not have LEPProgramCompletionDate.	Student Information > General > Enrollments > State Reporting Fields > Shared Time (checked)
Speech Only, Sent - Full Time	The Speech Only count is a subset of the total sent count. Students are counted on the Speech Only column in the ASSA if the NJSMART Special Education Classification includes: 17: Eligible for Speech-Language Services Student's enrollment has: Special Ed Status = Y Primary Disability = 17 State Reporting Fields > Shared Time NOT = Checked
Speech Only, Sent - Shared Time	The Speech Only count is a subset of the total sent count. Students are counted on the Speech Only column in the ASSA if the NJSMART Special Education Classification includes: 17: Eligible for Speech-Language Services Student's enrollment has: Special Ed Status = Y Primary Disability = 17 State Reporting Fields > Shared Time = Checked

Previous Version

ASSA Student Sent (New Jersey) [.2211-.2307]

ASSA Student Sent