NJ ASSA Audit Extract

Enrollments

This section includes students enrollment records that meet the following criteria:

• The student's special education tier field is blank
• The student's assigned tuition code is not 5
• The student's special status is blank

Special Education Enrollments

This section includes special education student enrollment records that meet following criteria:

• The student's special education tier is II, III, or IV
• The student's assigned tuition code is not 2
• The student's special status is blank

Ages 5–17 Only – On Roll Full

This section includes students between the ages 5 through 17 (inclusive) that are On Roll Full. The students' ages are based on the Count Date entered on the report interface. The following criteria is used to identify a On Roll Full student:

• [S_NJ_STU_X]shared_time_code is blank

Ages 5–17 Only

This section includes students between the ages 5 through 17 (inclusive) that are not On Roll Full. The students' ages are based on the Count Date entered on the report interface These students are listed by their Category.
The students' ages are based on the Count Date entered on the report interface. The following criteria is used to identify a student not On Full Roll:

• [S_NJ_STU_X]shared_time_code is equal to 1

County Vocational Counts

This section includes students with a special status equal to 3, 4, or 5.

Special Education Tier I Summary

This section includes counts for special education students receiving Tier I services. The following criteria is used to identify these students:

• [S_NJ_STU_X]Counseling_Services_YN is equal to 1
• [S_NJ_STU_X]Occupational_Therapy_Services_YN is equal to 1
• [S_NJ_STU_X]Physical_Therapy_Services_YN is equal to 1
• [S_NJ_STU_X]Speech_Lang_Therapy_Services is equal to 1
• [S_NJ_STU_X]Other_Related_Services_YN is equal to 1

Special Education Tier IV Summary

This section includes counts for special education students receiving specific Tier IV services ([S_NJ_STU_X]SPEDTier is equal to IV).

Low Income Summary – Enrollment

This section includes only students whose assigned tuition code is equal to 2.

Low Income Summary – Age 5–17 (as of count date)

This section includes only students whose assigned tuition code is equal to 2 and whose age is between 5 and 17 years (inclusive) as of the Count Date entered on the report interface.

LEP Students / SLD Summary

This section includes LEP and SLD student counts, based on the following criteria:

• [S_NJ_STU_X]LEP_TF is equal to 1 and [S_NJ_STU_X]SPEDTier is empty
• [S_NJ_STU_X]SpecialEd_Classification is equal to SLD and [S_NJ_STU_X]SPEDTier is equal to II, III, or IV

Regional/Consolidated Enrollment Breakdown
Students Received - Full Time

This section includes full-time student enrollment records ([Students]parttimestudent is blank).

Regional/Consolidated Enrollment Breakdown

Students Received - Shared Time

This section includes shared-time student enrollment records ([Students]parttimestudent is equal to 1).

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
• Current School Only – Includes all records associated with the current school that meet the selection criteria.
• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Date to Scan

Enter the date to scan for the report. Usually, this date is October 15 of the current school year.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) to execute the report immediately in the background.
• ASAP to execute the report in the order it is received in the Report Queue.
• At Night to execute the report during the next evening.
• On Weekend to execute the report during the next weekend.
• On Specific Time to execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10:05 AM.

Include Regional/Consolidated Breakdown in Report

Select this check box to include a breakdown of the student counts for each district of residence in the school district.

Base Date for Determining Age

Enter the base date for determining students’ age, which is usually October 15 of the current school year.  This is used to determine eligibility for the Ages 5-17 Only sections.

Format: MM/DD/YYYY

Enrollments Column Headings

N/A

Category

This column lists the student count categories included on the NJ ASSA report.

Refer to the category sections defined in this table for a definition of each category.

N/A

N/A

N/A

N/A

N/A

Column

This column lists the student count criteria column headings included on the NJ ASS report.

These columns are:

N/A

N/A

N/A

On Roll Full

[S_NJ_STU_X]shared_time_code is blank

On Roll shared

[S_NJ_STU_X]shared_time_code is not blank

Free Lunch Full

[Students]lunchstatus is equal to F or FDC

[S_NJ_STU_X]shared_time_code is blank

Free Lunch Shared

[Students]lunchstatus is equal to F or FDC

[S_NJ_STU_X]shared_time_code is not blank

Reduced Lunch Full

[Students]lunchstatus is equal to R

[S_NJ_STU_X]shared_time_code is blank

Reduced Lunch Shared

[Students]lunchstatus is equal to R

[S_NJ_STU_X]shared_time_code is not blank

Private School Disabled

[S_NJ_STU_X]school_disabled is equal to 1

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A

Categories

Enrollments Section

N/A

Full Day Preschool 3 Yrs Old

A student is counted in this category if the student’s grade level is equal to -2 and the student is a full-time student.

[Students]GradeLevel = -2

[Students]parttimestudent = 0 or is blank

N/A

N/A

N/A

N/A

Half Day Preschool 3 Yrs Old

A student is counted in this category if the student’s grade level is equal to -2 and the student is a part-time student.

[Students]GradeLevel = -2

[Students]parttimestudent = 1

N/A

N/A

N/A

N/A

Full Day Preschool 4 Yrs Old

A student is counted in this category if the student’s grade level is equal to -1 and the student is a full-time student.

[Students]GradeLevel = -1

[Students]parttimestudent = 0 or is blank

N/A

N/A

N/A

N/A

Half Day Preschool 4 Yrs Old

A student is counted in this category if the student’s grade level is equal to -1 and the student is a part-time student.

[Students]GradeLevel = -1

[Students]parttimestudent = 1

N/A

N/A

N/A

N/A

Full Day Kindergarten

A student is counted in this category if the student’s grade level is equal to 0 and the student is a full-time student.

[Students]GradeLevel = -0

[Students]parttimestudent = 0 or is blank

N/A

N/A

N/A

N/A

Half Day Kindergarten

A student is counted in this category if the student’s grade level is equal to 0 and the student is a part-time student.

[Students]GradeLevel = 0

[Students]parttimestudent = 1

N/A

N/A

N/A

N/A

Post Graduate

A student is counted in this category if the student’s special status is set to Post Graduate.

[S_NJ_STU_X]special_status = 1

N/A

N/A

N/A

N/A

Adult HS (15+ Credits)

A student is counted in this category of the student is an adult student who has earned 15 or more credits.

[S_NJ_STU_X]special_status = 2

[S_NJ_STU_X]adultHS_nb_credits ≥ 15

N/A

N/A

N/A

N/A

Adult HS (1–14 Credits)

A student is counted in this category of the student is an adult student who has earned at least 1 credit but not more than 14 credits.

[S_NJ_STU_X]special_status = 2

[S_NJ_STU_X]adultHS_nb_credits < 15 and > 0

N/A

N/A

N/A

N/A

Grade 1 through Grade 12

(occurs 12 times, one for each grade level)

A student is counted in the appropriate category if the student’s grade level is 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12.

[Students]GradeLevel = 1, 2, 3, 4, 5, 6, 7, 8, 8, 10, 11, or 12

N/A

N/A

N/A

Special Education Enrollments Section

Column Criteria

N/A

Category

This column lists the student count categories included on the NJ ASSA report.

Refer to the category sections defined in this table for a definition of each category.

N/A

N/A

N/A

N/A

N/A

Setting

This column lists the student’s classroom setting. Possible values are In Grade Level and Self-contained.

N/A

N/A

N/A

N/A

N/A

Column

This column lists the student count criteria column headings included on the NJ ASS report. Refer to the columns listed under the “Enrollments Column Headings” section.

N/A

N/A

N/A

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A

Categories

N/A

Tier II – Elementary School

A student is counted in this category if the student’s tier is equal to II and the student’s:

• Grade level is less than or equal to 5, if the student is not enrolled in a special education program.
• Age is less than or equal to 11 years old as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = II

[Students]GradeLevel ≤ 5

N/A

N/A

N/A

N/A

Tier II – Middle School

A student is counted in this category if the student’s tier is equal to II and the student’s:

• Grade level is between 6 and 8 (inclusive), if the student is not enrolled in a special education program.
• Age is between 12 and 14 years old (inclusive) as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = II

[Students]GradeLevel = 6, 7, or 8

N/A

N/A

N/A

N/A

Tier II – High School

A student is counted in this category if the student’s tier is equal to II and the student’s:

• Grade level is less than or equal to 5, if the student is not enrolled in a special education program.
• Age is between 15 and 21 years old (inclusive) as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = II

[Students]GradeLevel = 9, 10, 11, or 12

N/A

N/A

N/A

N/A

Tier III – Elementary School

A student is counted in this category if the student’s tier is equal to III and the student’s:

• Grade level is less than or equal to 5, if the student is not enrolled in a special education program.
• Age is less than or equal to 11 years old as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPED]tier = III

[Students]GradeLevel ≤ 5

N/A

N/A

N/A

N/A

Tier II – Middle School

A student is counted in this category if the student’s tier is equal to III and the student’s:

• Grade level is between 6 and 8 (inclusive), if the student is not enrolled in a special education program.
• Age is between 12 and 14 years old (inclusive) as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = III

[Students]GradeLevel = 6, 7, or 8

N/A

N/A

N/A

N/A

Tier III – High School

A student is counted in this category if the student’s tier is equal to III and the student’s:

• Grade level is less than or equal to 5, if the student is not enrolled in a special education program.
• Age is between 15 and 21 years old (inclusive) as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = III

[Students]GradeLevel = 9, 10, 11, or 12

N/A

N/A

N/A

N/A

Tier IV – Elementary School

A student is counted in this category if the student’s tier is equal to IV and the student’s:

• Grade level is less than or equal to 5, if the student is not enrolled in a special education program.
• Age is less than or equal to 11 years old as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = IV

[Students]GradeLevel ≤ 5

N/A

N/A

N/A

N/A

Tier IV – Middle School

A student is counted in this category if the student’s tier is equal to IV and the student’s:

• Grade level is between 6 and 8 (inclusive), if the student is not enrolled in a special education program.
• Age is between 12 and 14 years old (inclusive) as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = IV

[Students]GradeLevel = 6, 7, or 8

N/A

N/A

N/A

N/A

Tier IV – High School

A student is counted in this category if the student’s tier is equal to IV and the student’s:

• Grade level is less than or equal to 5, if the student is not enrolled in a special education program.
• Age is between 15 and 21 years old (inclusive) as of the count date entered, if the student is enrolled in a special education program.

[S_NJ_STU_X]SPEDtier = IV

[Students]GradeLevel = 9, 10, 11, or 12

N/A

N/A

N/A

County Vocational Counts Section

Column Criteria

N/A

Category

This column lists the student count categories included on the NJ ASSA report.

Refer to the category sections defined in this table for a definition of each category.

N/A

N/A

N/A

N/A

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A

Categories

N/A

County Vocational – Regular

A student is counted in this category if the student has a special status equal to 3, County Vocational – Regular.

[S_NJ_STU_X]special_status = 3

N/A

N/A

N/A

N/A

County Vocational – Full Time Post Secondary

A student is counted in this category if the student has a special status equal to 3, County Vocational – Fulltime Post Secondary.

[S_NJ_STU_X]special_status = 4

N/A

N/A

N/A

N/A

County Vocational – Other

A student is counted in this category if the student has a special status equal to 3, County Vocational – Special.

[S_NJ_STU_X]special_status = 5

N/A

N/A

N/A

Special Education Tier I Summary Section

Column Criteria

N/A

Category

This column lists the student count categories included on the NJ ASSA report.

Refer to the category sections defined in this table for a definition of each category.

N/A

N/A

N/A

N/A

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A

Categories

N/A

Counseling

A special education student is counted in this category if the student is receiving Tier I counseling services.

[S_NJ_STU_X]Counseling_Services_YN = 1

N/A

N/A

N/A

N/A

Occupational Therapy

A special education student is counted in this category if the student is receiving Tier I occupational therapy services.

[S_NJ_STU_X]Occupational_Therapy_Services_YN = 1

N/A

N/A

N/A

N/A

Physical Therapy

A special education student is counted in this category if the student is receiving Tier I physical therapy services.

[S_NJ_STU_X]Physical_Therapy_Services_YN = 1

N/A

N/A

N/A

N/A

Speech Language Therapy

A special education student is counted in this category if the student is receiving Tier I speech language therapy services.

[S_NJ_STU_X]Speech_Lang_Therapy_Services = 1

N/A

N/A

N/A

N/A

Other

A special education student is counted in this category if the student is receiving Tier I other services.

[S_NJ_STU_X]Other_Related_Services_YN = 1

N/A

N/A

N/A

Special Education Tier IV Summary Section

Column Criteria

N/A

Category

This column lists the student count categories included on the NJ ASSA report.

Refer to the category sections defined in this table for a definition of each category.

N/A

N/A

N/A

N/A

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A

Categories

N/A

Individual Instruction

A special education student is counted in this category if the student is receiving individual instruction.

[S_NJ_STU_X]TIV_serv_ind_instr_TF = 1

N/A

N/A

N/A

N/A

Pupil: Teacher Aide Ratio 3:1 or Less

A special education student is counted in this category if the student is receiving instruction in a classroom where the pupil to teacher aide ratio is 3 to 1 or less.

[S_NJ_STU_X]TIV_serv_pupil_TF = 1

N/A

N/A

N/A

N/A

High Level Assistive Technology

A special education student is counted in this category if the student is receiving instruction that includes high level assistive technology.

[S_NJ_STU_X]TIV_serv_Assist_TF = 1

N/A

N/A

N/A

N/A

Extended School Year

A special education student is counted in this category if the student is receiving instruction over an extended school year.

[S_NJ_STU_X]TIV_serv_ExtYear_TF = 1

N/A

N/A

N/A

N/A

Intensive Related Services

A special education student is counted in this category if the student is receiving intensive related services.

[S_NJ_STU_X]TIV_serv_Intensive_TF = 1

N/A

N/A

N/A

N/A

Interpreter Services

A special education student is counted in this category if the student is receiving interpreter services.

[S_NJ_STU_X]TIV_serv_Interpreter_TF = 1

N/A

N/A

N/A

N/A

Personal Aide

A special education student is counted in this category if the student has a personal aide in the classroom.

[S_NJ_STU_X]TIV_serv_Aide_TF = 1

N/A

N/A

N/A

N/A

Resident Placement for Ed. Purposes

A special education student is counted in this category if the student is placed in a residential school for educational purposes.

[S_NJ_STU_X]TIV_serv_ResPlacement_TF = 1

N/A

N/A

N/A

N/A

Individual Nursing Services

A special education student is counted in this category if the student is receiving individual nursing services.

[S_NJ_STU_X]TIV_serv_IndNursing_TF = 1

N/A

N/A

N/A

Low Income Summary Enrollment and Age 5–17 Section

Column Criteria

N/A

Full/Shared Time

This column identifies the current enrollment status of each student, either full-time or shared-time.

[S_NJ_STU_X]shared_time_code is blank

[S_NJ_STU_X]shared_time_code is not blank

N/A

N/A

N/A

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A

LEP Students / SLD Summary Section

N/A

LEP Students

A student is counted in this category if that student participates in a limited English proficiency (LEP) program and is not a special education student.

[S_NJ_STU_X]LEP_TF = 1

[S_NJ_STU_X]SPEDTier is blank

N/A

N/A

N/A

N/A

Tier II SLD

A special education student is counted in this category if that student’s tier is II and the student is categorized as Specific Learning Disabled.

[S_NJ_STU_X]SpecialEd_Classification = SLD

[S_NJ_STU_X]SPEDTier = II

N/A

N/A

N/A

N/A

Tier III SLD

A special education student is counted in this category if that student’s tier is III and the student is categorized as Specific Learning Disabled.

[S_NJ_STU_X]SpecialEd_Classification = SLD

[S_NJ_STU_X]SPEDTier = III

N/A

N/A

N/A

N/A

Tier IV SLD

A special education student is counted in this category if that student’s tier is IV and the student is categorized as Specific Learning Disabled.

[S_NJ_STU_X]SpecialEd_Classification = SLD

[S_NJ_STU_X]SPEDTier = IV

N/A

N/A

N/A

Regional/Consolidated Enrollment Breakdown Section

Students Received – Full Time and Students Received – Shared Time

Column Criteria

N/A

District ID

This column lists the district ID for each school that corresponds to the students’ district of residence value.

N/A displays if the district of resident is not defined for a student.

[Students]DistrictOfResidence

N/A

N/A

N/A

N/A

District of Residence

This column lists the district name for each school that corresponds to the students’ district of residence value.

Not Specified displays if the district of resident is not defined for a student.

[Students]DistrictOfResidence

N/A

4

N/A

N/A

Tuition Code – None

This column shows tuition code assigned to each student. None displays for a student without a tuition code.

 [S_NJ_STU_X]tuition_code

N/A

N/A

N/A

N/A

Student Number

This column lists the number assigned to the student that meets the count criteria for this Category and Column.

[Students]Student_Number

Alpha-numeric

N/A

N/A

N/A

Student Name

This column lists the last and first name of the student that meets the count criteria for this Category and Column.

Note: If populated, the report will extract the student's legal name.

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

Alpha-numeric

50

N/A