NJ ADA/ADM by Student
Introduction
Use the NJ ADA/ADM by Student report to summarize attendance and membership data for student enrollments in a selected time period. You can generate this report for a selected group of students, grade levels or special programs. This is a school level report. The report lists one row for each enrollment session applicable to a student in order to properly report transferred students.
You can generate the report for any of the following student groups:
- Students in select grade levels that are not enrolled in special programs.
- Students in all grade levels that are not enrolled in special programs.
- All students enrolled in select grade levels, including students enrolled in special programs.
- Students enrolled in all grade levels, including students enrolled in special programs (all students).
- Students enrolled in select special programs that are restricted to selected grade levels.
- Students enrolled in select special programs at any grade level.
- All special program student enrollments at any grade level.
- Currently selected students that are enrolled during the reporting period.
Note: Refer to the How This Report Selects Students matrix on the report interface for directions to run each of the above school attendance reports. Some common report scenarios and their results are:
- Scenario 1 – Run for All or Selected Grades, and no Special Programs selected. Students not in special programs at any time during the reporting period will appear on the report. Attendance numbers reported reflect their time in grade level.
- Scenario 2 – Run for All or Selected Grades, and All or Selected Special Programs. Students in a grade level or a Special Program during the reporting period will appear on the report. Attendance numbers reported reflect their time spent in grade level and NOT time spent in Special Programs. Students in Special Programs during the entire reporting period will appear on the report with zero attendance numbers; to obtain attendance numbers for students' time in Special Programs, run the report as in Scenario 3.
- Scenario 3 – Run for All or Selected Special Programs, and not All nor Selected Grades. Students enrolled in a Special Program at any time during the reporting period will appear on the report. Attendance numbers will reflect their time in Special Programs.
Selection Criteria
Selection criteria determine which database records are used in the report. For the NJ ADA/ADM by Student report, student enrollment and attendance records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- The student must be enrolled during the year and month selected for the report.
- The student must be enrolled in a special program during the year and month selected for the report to be included in the special program enrollment counts.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Reporting Segment or Begin Date and Ending Date | Click the date range to use for the report to scan records from the reporting segment pop-up menu or enter a begin date and end date to specify the reporting period. |
Starting Page Number | Select the page number to be assigned to the first page of the report. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
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. |
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 (multi-selectable) | If the All Grades check box is not selected, click one or more grade levels to filter the students 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. |
All Special Programs | Select the All Special Programs check box to include students enrolled in all special programs in the record selection process. Leave this check box blank to filter the student records included in the report selection process by special program. |
… or just these selected Special Programs (multi-selectable) | If the All Special Programs check box is not selected, click one or more special programs to filter the students 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. |
Restrict to District of Residences | Click one or more districts of residence to filter the students 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. If no districts are selected, the student selection is not restricted by the assigned district of residence. |
PTC Codes | Select the version of PTC codes you want to include on the report. Your choices are Display New PTC Codes (default) or Display Old PTC Codes. |
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 |