|
Data Element | Description and Logic | Campus UI Location |
Calendar | Indicates the calendar reporting data. | N/A |
School Address | Reports the address information for the school associated with the selected Calendar. If Address = NULL, report blank. | System Administration > Resources > School > Address
|
Date Generated | Reports the date the report was generated. | N/A |
Page Number | Indicates the page number for organizational purposes on the report. | N/A |
Course - Section | Reports the course and section number | Course > Course > Course Number Course > Section > Section Number |
Teacher | Reports the teacher | Courses > Staff History > Primary Teacher |
Teacher CACTUS ID | Reports the teacher CACTUS ID | Census > People > Demographics > Person Identifiers > Staff State ID |
Date Range | Reports the start and end dates selected on the Extract Editor. If dates = NULL, report blank. | N/A |
Term Description | Reports the Term Description entered on the Extract Editor. If the Term Description field = NULL, report blank. | N/A |
Period | Reports the Class Period. | Course > Section > Section Schedule Placement |
Students | Indicates number of students included on the report. | N/A |
Cycle Day | Reports the name of the Period Schedule. | System Administration > Calendar > Calendar > Periods > Name |
Core Code | Reports the course State Code | Scheduling > Courses > Course > Course Information > State Code |
Report Fields |
Data Element | Description and Logic | Campus UI Location |
Student # | The student's Local Student Number. | Census > People > Demographics > Person Identifiers > Local Student Number |
Student Name | The student's Last Name, First Name, Middle Initial. | Census > People > Demographics > Person Info > Last Name, First Name, Middle (Initial) |
Grade | The student's grade (shown in parenthesis). | Student Information > Enrollments > Grade |
Attendance Code | Indicates the student's attendance for each day. - # = Course not scheduled
- Gray Box = Non-school or weekend day
- - = Student off roll
- A, U, T = the student's attendance status for that day
| System Administration > Attendance > Attendance Codes |
M (Membership) | The student's total number of membership days in the course section. - When the student's non-excluded enrollment that was active on the report day has Membership FTE Override = null:
- Sums the unique instructional days the student is enrolled during the reporting dates indicated on the extract editor.
- When the student's non-excluded enrollment that was active on the report day has Membership FTE Override NOT = null:
- Multiplies the membership days by the (School Membership FTE Override field value / 100) when Membership FTE Override is not null.
- Rounded up to the next whole number.
Non-excluded enrollment: - No Show NOT = checked on the enrollment
- State Exclude NOT = checked on the enrollment
- Priority given to the active Primary enrollment to report when both a Primary and non-Primary enrollment are active on the calendar day.
| N/A |
P (Present) | The total number of days the student was present in the course section. - When the student's non-excluded enrollment*** that was active on the report day has Membership FTE Override = null:
Sums the unique instructional days the student is enrolled where the student had any period in the day not one of the following: Status = “Absent” Excuse = “Unknown”, “Excused” or “Unexcused”
- When the student's non-excluded enrollment that was active on the report day has Membership FTE Override NOT = null:
- Multiplies the actual days attended by the (School Membership FTE Override field value / 100).
- Rounded up to the next whole number.
Non-excluded enrollment: - No Show NOT = checked on the enrollment
- State Exclude NOT = checked on the enrollment
- Priority given to the active Primary enrollment to report when both a Primary and non-Primary enrollment are active on the calendar day.
| N/A |
T (Tardy) | The total number of days the student was tardy for the course section. - Sums the unique instructional days the student is enrolled during the reporting dates in a non-excluded enrollment indicated on the extract editor where any rostered instructional period in the day is assigned an attendance code with:
- Status = “Tardy”
- Excuse NOT = “Exempt”
Non-excluded enrollment: - No Show NOT = checked on the enrollment
- State Exclude NOT = checked on the enrollment
- Priority given to the active Primary enrollment to report when both a Primary and non-Primary enrollment are active on the calendar day.
| N/A |
AB UNEX (Absent Unexcused) | Counts the number of enrolled instructional days during the reporting dates in a non-excluded enrollment indicated on the extract editor where the following is true for the student:
- Grade Level Half Day:
- When the student's enrollment grade level has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) NOT = null:
- When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field where their absent code has:
- Status = “Absent”
- Excuse = “Unexcused” or "Unknown"
- Calendar Half Day:
- When the student's enrollment grade level has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) = null:
- When (System Admin > Calendar > Calendar > Half Day Absence (minutes) NOT = null:
- When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field on Calendar where their absent code has:
- Status = “Absent”
- Excuse = “Unexcused” or "Unknown"
- Calculated Half Day:
- When (System Admin > Calendar > Calendar > Half Day Absence (minutes) = null:
- When the student is absent for half or more of the instructional minutes in the day, where their absent code has:
- Status = “Absent”
- Excuse = “Unexcused” or "Unknown"
- Reports the most common absence type between ABS UNEX and ABS EX (one or the other, not both) when student qualifies as absent for the day.
- When student is enrolled in the day in < the full number of instructional periods in the day:
- Consider the student to be enrolled in the full number of instructional periods (minutes) in the day so that they are not counted as absent if not enrolled in > 240 minutes.
Non-excluded enrollment: - No Show NOT = checked on the enrollment
- State Exclude NOT = checked on the enrollment
- Priority given to the active Primary enrollment to report when both a Primary and non-Primary enrollment are active on the calendar day.
| System Administration > Calendar > Grade Levels > Grade Level Detail > Half Day Absence
System Administration > Calendar > Calendar > Half Day Absence |
ABS EX (Absent Excused) | Counts the number of enrolled instructional days during the reporting dates in a non-excluded enrollment indicated on the extract editor where the following are true for the student:
- Grade Level Half Day:
- When the student's enrollment grade level has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) NOT = null:
- When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field where their absent code has:
- Status = “Absent”
- Excuse = “Excused”
- Calendar Half Day:
- When the student's enrollment grade level has (System Admin > Calendar > Grade Levels > Grade Level Detail > Half Day Absence (minutes)) = null:
- When (System Admin > Calendar > Calendar > Half Day Absence (minutes) NOT = null:
- When the student is absent for >= the value entered into the "Half Day Absence (minutes)" field on Calendar where their absent code has:
- Status = “Absent”
- Excuse = “Excused”
- Calculated Half Day:
- When (System Admin > Calendar > Calendar > Half Day Absence (minutes) = null:
- When the student is absent for half or more of the instructional minutes in the day, where their absent code has:
- Status = “Absent”
- Excuse = “Excused”
- Reports the most common absence type between ABS UNEX and ABS EX (one or the other, not both) when student qualifies as absent for the day.
- When student is enrolled in the day in < the full number of instructional periods in the day:
- Consider the student to be enrolled in the full number of instructional periods (minutes) in the day so that they are not counted as absent if not enrolled in > 240 minutes.
Non-excluded enrollment: - No Show NOT = checked on the enrollment
- State Exclude NOT = checked on the enrollment
- Priority given to the active Primary enrollment to report when both a Primary and non-Primary enrollment are active on the calendar day.
| System Administration > Calendar > Grade Levels > Grade Level Detail > Half Day Absence
System Administration > Calendar > Calendar > Half Day Absence |
Off Roll | Reports the sum of days the student was not enrolled in the course section. | N/A |
Section Totals | Reports the sum of all M, P, T, ABS UNEX, ABS EX, Off Roll for all students in the course section. | N/A |