NJ ESSA SubGroups Report

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.

Students to Include

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current selection.

• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running a report.

Processing Options

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

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

Specific Date/Time

Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin 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.

Updating students from the following grades…

All Grades

Select the All Grades check box to include students from all grades in the school or district selected in the record selection process.

Leave this check box blank to filter the student records included in the report selection process by grade level.

… or just these selected Grades

Click one or more grade levels to filter the student attendance included in the record selection process. This list is multi-selectable by dragging in the list with the mouse, or by pressing the shift, command or control keys while clicking in the list with the mouse.

Start Date

Enter a date value to start the date range for attendance.

Include Report Details

Select Yes to include the student details used to calculate the subgroup totals on the report. The default is No.

Use Two Session Meeting Attendance

Choose Yes to calculate the attendance totals using the Two Session Meeting Attendance calculation. You must map the AM and PM periods to each bell schedule used by your district before selecting this option. Refer to Period Mapping (District > District Setup > Period Mapping) on page 36 for more information.

Choose No to calculate the attendance based on attendance conversions.

Header

N/A

School

The name of the school in which the students are enrolled displays. This field value is extracted from the Edit School page, District Setup > Schools/School Info.

[Schools]school_name

N/A

Days of Memb

This field contains the number of days of membership for the school.

Calculated

Columns

N/A

Student Count

This column displays the number of students enrolled in all schools listed. A total displays for each applicable row on the report.

Calculated

N/A

Days Possible

This column displays the number of membership days possible for the students at all schools listed. A total displays for each applicable row on the report.

Calculated

N/A

Days Present

This column displays the number of days students were present at all schools listed. A total displays for each applicable row on the report.

Calculated

Rows

N/A

Low Income

This row contains the counts for students that meet the low income criteria. A low income student has a lunch status equal to F - Free, R - Reduced or FDC - Free-DC.

[Students]LunchStatus = F, R, or FDC

N/A

Not Low Income

This row contains the counts for students that do not meet the low income criteria. These students have a lunch status not equal to F - Free, R - Reduced or FDC - Free-DC.

[Students]LunchStatus ≠ F, R, or FDC

N/A

LEP

This row contains the counts for students whose limited English proficiency (LEP) status is set to yes.

[S_NJ_STU_X]LEP_TF = 1

N/A

Not LEP

This row contains the counts for students whose limited English proficiency (LEP) status is set to no.

[S_NJ_STU_X]LEP_TF ≠ 1

N/A

IEP

This row contains the counts for students with a special education classification other than 17-ESLS and 99-Declassified. A special education classification indicates that the student has an IEP.

[S_NJ_STU_X]SpecialEd_Classification > 0 but not 17 or 99

N/A

Not IEP

This row contains the counts for students that do not have a special education classification or have a special education classification of 99-Declassified or 17-ESLS

[S_NJ_STU_X]SpecialEd_Classification = 0, 17, or 99.

N/A

White/Non-Hispanic

This row contains the counts for students with the ethnicity of White (Non-Hispanic).

[StudentRace]Racecd = W

N/A

Black/African American

This row contains the counts for students with the ethnicity of Black (Non-Hispanic).

[StudentRace]Racecd = B

N/A

Asian

This row contains the counts for students with the ethnicity of Asian (Non-Hispanic).

[StudentRace]Racecd = A

N/A

Hispanic or Latino

This row contains the counts for students with the ethnicity of Hispanic or Latino.

[Students]FedEthnicity

N/A

American Indian/Alaska Native

This row contains the counts for students with the ethnicity of American Indian/Alaska Native (American Indian/Alaskan).

[StudentRace]Racecd = I

N/A

Native Hawaiian or other Pacific Islander

This row contains the counts for students with the ethnicity of Pacific Islander.

[StudentRace]Racecd = P

N/A

Multiracial

This row contains the counts for students with two or more races selected.

Calculated value

N/A

Male

This row contains the counts for male students.

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

[Students]Gender = M

[StudentCoreFields]PSCore_Legal_Gender = M

N/A

Female

This row contains the counts for female students.

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

[Students]Gender = F

[StudentCoreFields]PSCore_Legal_Gender = F

N/A

Migrant

This row contains the counts for students that meet the criteria for migrant students.

[S_NJ_STU_X]Migrant_TF = 1

N/A

Not Migrant

This row contains the counts for students that do not meet the criteria for migrant students.

[S_NJ_STU_X]Migrant_TF ≠ 1

Column Headings

N/A

Count

A sequential number assigned to each student record included Detail section.

Calculated

N/A

Student Name

The name of the student included in the section detail count.

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

[Students]LastFirst

[StudentCoreFields]PSCore_Legal_Last_Name

[StudentCoreFields]PSCore_Legal_First_Name

N/A

Student No

This column displays the student’s identification number.

[Students]Student_Number

N/A

School

This column displays the school in which the student is currently enrolled.

[Students]SchoolID

N/A

Grade

This column displays the student’s current grade level.

[S_NJ_STU_X]GradeLevelCode

[Students]GradeLevel

N/A

Lunch Status

This column displays the student’s lunch status, which is used to determine the student’s income status.

[Students]Lunchstatus

N/A

Days Possible

This column displays the number of membership days possible for the student at this school.

Calculated

N/A

Days Possible Cum

This column displays the running count of the days possible within the subgroup.

Calculated

N/A

Days Present

This column displays the number of days the student was present at this school.

Calculated

N/A

Days Present Cum

This column displays the running count of the days present within the subgroup.

Calculated

Detail Sections

N/A

Low Income

This section contains the individual counts for each student that meets the low income criteria. A low income student has a lunch status equal to F - Free, R - Reduced or FDC - Free-DC.

[Students]LunchStatus = F, R, or FDC

N/A

Not in Low Income

This section contains the individual counts for each student that does not meet the low income criteria. These students have a lunch status not equal to F - Free, R - Reduced or FDC - Free-DC.

[Students]LunchStatus ≠ F, R, or FDC

N/A

LEP

This section contains the individual counts for each student whose limited English proficiency (LEP) status is set to yes.

[S_NJ_STU_X]LEP_TF = 1

N/A

Not in LEP

This section contains the individual counts for each student whose limited English proficiency (LEP) status is set to no.

[S_NJ_STU_X]LEP_TF ≠ 1

N/A

IEP

This section contains the individual counts for each student with a special education classification other than 17-ESLS and 99-Declassified. A special education classification indicates that the student has an IEP.

[S_NJ_STU_X]SpecialEd_Classification > 0 but not 17 nor 99.

N/A

Not in IEP

This section contains the individual counts for each student that does not have a special education classification or has a special education classification of 17-ESLS or 99-Declassified.

[S_NJ_STU_X]SpecialEd_Classification = 0, 17, or 99.

N/A

Asian

This section contains the individual counts for each student with an Asian race selected and non-Hispanic/Latino.

[StudentRace]RaceCd = A

N/A

Black

This section contains the individual counts for each student with a Black race selected and non-Hispanic/Latino.

[StudentRace]RaceCd = B

N/A

Hispanic or Latino

This section contains the individual counts for each student with the Hispanic / Latino ethnicity selected. When this field value is Y, counts are extracted in this field regardless of which races are selected.

[Students]FedEthnicity

N/A

American Indian

This section contains the individual counts for each student with American Indian race selected and non-Hispanic/Latino.

[StudentRace]RaceCd = I

N/A

Multiracial

This section contains the individual counts for each student with multiple races selected and non-Hispanic/Latino.

Calculated value

N/A

Pacific Islander

This section contains the individual counts for each student with race Pacific Islander and non-Hispanic/Latino specified.

[StudentRace]RaceCd = P

N/A

White

This section contains the individual counts for each student with race White and non-Hispanic/Latino.

[StudentRace]RaceCd = W

N/A

Female

This section contains the individual counts for each female student.

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

[Students]Gender = F

[StudentCoreFields]PSCore_Legal_Gender = F

N/A

Male

This section contains the individual counts for each male student.

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

[Students]Gender = M

[StudentCoreFields]PSCore_Legal_Gender = M

N/A

Migrant

This section contains the individual counts for each student that meets the criteria for migrant students.

[S_NJ_STU_X]Migrant_TF = 1

N/A

Not in Migrant

This section contains the individual counts for each student that does not meet the criteria for migrant students.

[S_NJ_STU_X]Migrant_TF ≠ 1