CE Hourly Attendance

The Continuation Education (CE) Hourly Attendance report is a school-level, week-by-week detail of attendance and apportionment for Continuation Education students. The report provides detailed hourly attendance and apportionment information to supplement the CE Monthly Attendance report. The report includes an audit trail of the present, excused, unexcused, and absent hours for each continuing education student. The audit trail is broken down into weekly intervals.

If you are on PS version 23.1 or higher and LTK Pref is enabled, when you run the reports with the selected school year 23-24 or higher, the mapped LTK grade values will be displayed.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects student records based on the following criteria:

The student's school enrollment must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
- The student's school enrollment exit date must occur on or after the report's start date.
- The student's school enrollment entry date must occur on or before the report's end date.
- The student's school enrollment exit date must occur after the school enrollment entry date (not on the same day).
The student must be enrolled in a Continuation Education special program for the current school.

Designate which special program is used for Continuation Education by selecting the program on the Attendance Backfill Preferences page.

- The student's CE special program entry date must occur on or before the report end date.
- The student's CE special program exit date must occur after the report start date.

Report Input

This report is run at the school level only.

For help with navigation and running the report, refer to How to Find and Generate a Report.

Field	Description
Select Reporting Period	Choose a reporting period or a start and end date.
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. If you are running the report for a single student, or group of students, select the students prior to running the report.
Display Time Results As	Choose a time measurement to display in the report output.
Sort by Grade	Select Yes to sort the students in the report by grade level.

Report Output

Each of the fields displayed in the output of the report is described below. Refer to Understanding the Report Output Tables for a definition of each column in the table.

Report Output Format: PDF

Data Element	Description	[Table]FieldName
Student Name	The student’s first and last name.	[Students]LastFirst
Student Number	The locally assigned student number.	[Students]Student_Number
Grade Level	The student’s grade level. Note: For school year 23-24 or higher, grade level mapped to LTK will be displayed.	[Students]Grade_Level
Gender	The student’s gender.	[Students]Gender
Gain/Loss Indicator	Indicates whether the student entered and/or exited the CE special program during the report date range.	[SpEnrollments]SchoolID [SpEnrollments]ProgramID Gain: [SpEnrollments]Enter_Date >= Report Start Date [SpEnrollments]EnterDate <= Report End Date Loss: [SpEnrollments]Exit_Date >= Report Start Date [SpEnrollments]Exit_Date <= Report End Date
Weekday Attendance	The report extracts the following values: +: Present E: Excused Absence U: Unexcused Absence S: Suspended Absence	[Attendance]SchoolID [Attendance]Att_Date [Attendance]Att_Mode_Code=ATT_ModeInterval [Attendance]Attendance_CodeID [Att_Code_Code_Entity]Attendance_CodeID [Att_Code_Code_Entity]Code_EntityID [Code_Entity]External_Name=Excused, Unexcused, Suspended
Hours Excused Hours Unexc Hours Susp	The total number of hours or intervals that the student was assigned an Excused, Unexcused, or Suspended attendance code. The report identifies the attendance records as Excused, Unexcused, or Suspended using the following criteria: The attendance record is associated with the student, school, and date range. The attendance record is associated with a section assigned to the Continuation Education special program. The attendance code is associated with an attendance code category named Excused, Unexcused, or Suspended.	[Attendance]SchoolID [Attendance]Att_Date [Attendance]Att_Mode_Code=ATT_ModeInterval [Attendance]Attendance_CodeID [Att_Code_Code_Entity]Attendance_CodeID [Att_Code_Code_Entity]Code_EntityID [Code_Entity]External_Name=Excused, Unexcused, Suspended
Max Hours	The maximum number of hours allowed to be claimed for the week for the student. This value is calculated by multiplying the Target Hours per Day in Week by the number of in-session days in the week that the student was enrolled and subtracting out suspension days. If the student is suspended for a partial day, suspension time is subtracted only if the student was marked as present or absent (other than suspension) for less than the Target Hours per Day prior to being suspended.	[Prefs]Value [Prefs]Name=ATT_BackfillTargetHrs [Prefs]Name=BackfillWExpHours [Calendar_Day]InSession [Agg_Attendance]Agg_Calc_Type=Apportionable M
Work Hours	The total time attendance hours are flagged as work experience. Attendance hours are identified as work experience by selecting Work Experience for the time attendance records on the student’s attendance page. Work hours are included in apportionment if the student meets a minimum of four non-work and/or course hours for the week. If this minimum is not met, then work hours are excluded.	[Agg_Attendance]Att_Minutes [Agg_Attendance]Agg_Calc_Type=BaselineWrkHrs
Non Work Hours	The total time attendance hours are not flagged as work experience.	[Agg_Attendance]Att_Minutes [Agg_Attendance]Agg_Calc_Type=BaselineNWrkHrs
Course Hours	The total interval attendance hours.	[Agg_Attendance]Att_Minutes [Agg_Attendance]Agg_Calc_Type=BaselineCrsHrs [Attendance]Att_Mode_Code=ATT_ModeTime
Appor Hours	Total claimable ADA hours for the week, based on total in-session days. Apportionment is the distribution of attendance hours for continuation education students. The purpose of apportionment is to claim the maximum number of attendance hours per student per week. If a student attends fewer than the maximum hours in week one and more than the maximum hours in week two, the excess hours will be apportioned, or distributed, from week two to week one. The state specifies the number of days eligible for apportionment. Work hours are counted if the student meets the minimum of at least four non-work and/or course hours for each week. If the student does not meet this minimum, then work hours are excluded.	N/A
Total Appor	The number of hours the student was in attendance for the week up to the maximum allowed to be claimed for apportionment (Max Hours). This total includes backfill hours.	N/A
Hours + or -	The difference between Max Hours and the actual hours of attendance for the week. This value represents one of the following: The number of hours that can be used as backfill from previous weeks. The number of hours needed from the backfill to achieve the Max Hours. This value is not equal to Max Hours – Total Appor, because the student may have attended more hours than claimed.	N/A
Hours Debited	The number of hours debited from the week for another week.	N/A
Week Credited	The week used to credit hours to help claim the Max Hours. The date represents the Monday of the reported week.	N/A
Hours Credited	The number of hours credited to the week from the backfill.	N/A
Week Debited	The week for which hours were debited to help claim the Max Hours. The date represents the Monday of the reported week.	N/A