CDS Attendance Audit

Field

Description

Report Parameters

Select the checkboxes next to the filter fields to save the settings as defaults. To select all checkboxes, choose Select All from the Report Parameters pop-up menu. To clear all checkboxes, choose Clear All.

Select Students

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 report.

Select Reporting Period

Choose a reporting period from the pop-up menu, or enter a begin and end date.

Select the Non-Instructional Attendance Code Category (if applicable)

If you have a non-instructional code category set up to track non-instructional present codes, select the code category. Otherwise, select Does Not Apply.

Run Report by Teacher

If you would like to run the report for a single teacher, select Yes. Otherwise, if you would like all student that meet the selection criteria, regardless of the teacher, select No.

Select Teacher

Choose the appropriate teacher from the pop-up menu.

Note: This option only applies when running the report by teacher.

Select Teacher Period(s) (leave blank for all)

Check the appropriate periods. Leave all checkboxes blank to run the report for all periods.

Note: This option only applies when running the report by teacher.

Data Element

Description

[Table]FieldName

School Name

The name of the school.

[Schools]Name

Report Name

The name of the report.

N/A

School Year

The school year for which attendance is reported.

The report extracts the value from the first and last day of the school calendar. The report determines which school calendar to use based on the term selected at the top of the page at report runtime.

[Calendar]FirstDay

[Calendar]LastDay

Teacher

Teacher Name

Note: This data element is only displayed when the report is run by teacher

[Users]Last_Name

[Users]First_Name

Reporting Period

The reporting segment selected at report runtime.

For example, if you selected reporting segment 3, the report extracts 3.

N/A

Date Range

The start and end date of the report, derived from the Reporting Segment, or entered at report runtime.

N/A

Student Name

The student’s first and last name.

[Students]First_Name

[Students]Last_Name

Student Number

The locally assigned student number.

[Students]Student_Number

Grade

The grade level associated with the student’s school enrollment.

Note: For school year 23-24 or higher, grade level mapped to LTK will be displayed. 

[Students]Grade_Level

Mandatory Expulsion

Indicates whether the student’s referral method for CDS is mandatory expulsion.

The report extracts Yes if Mandatory Expulsion is chosen for the CDS Referral Method field on the Edit Special Program Enrollment page.

Note: Student enrollments with like referral methods will be consolidated and grouped by Mandatorily Expelled Y/N.

Valid Values: Yes or No

Note: If no Referral Method is set on the student’s CDS special program enrollment, ‘Missing’ is displayed.

[CA_SpEnrollments]Referral_Method

Week

Indicates the week for which attendance is reported. Each California reporting segment contains four weeks.

N/A

Date

Indicates the date on which the attendance was taken.

The report selects dates that meet the following criteria:

1. The date must be marked In Session on the Calendar Setup page for the specified school and school year.

2. The date must occur on or after the report start date and on or before the report end date.

[Calendar_Day]Date

Day

Indicates the day of the week: Monday through Sunday.

N/A

Date

Indicates the calendar date

N/A

1^st – 10^th

Indicates the student’s attendance status for each interval on the specified day:

• NC: Non-Certificated Instructor - Indicates that a Present attendance record is associated with a section that is not assigned a certificated teacher. Non-certificated minutes are not counted towards total minutes earned by the student.

• NE: Not Enrolled – Indicates that the student was not enrolled in school or CDS program.

• NI: Non-Instructional Minutes - Indicates that a Present attendance record is associated with a section that is not assigned a certificated teacher. Non-instructional minutes are not counted towards total minutes earned by the student.

• *: Enrolled in Other CDS Program – If a student has multiple enrollments in CDS programs over the period for which the report is run and the Mandatorily Expelled value is the same, an * will appear on the days when the student has data for the other Mandatorily Expelled value.

• — : Not In Session – Indicates that the day was not in session, i.e. not counted for attendance.

• Blank: Attendance Missing – CDS is a positive attendance program in which attendance must be taken for each interval. A blank in an interval indicates that either no attendance was taken or the student was not scheduled.

• [Value]: Either minutes present or absent code – If the student is absent for the interval, their absence code appears. If the student is present and the attendance qualifies, the minutes of attendance received for that interval is displayed.

Teachers are considered certificated if they have an active CALPADS Staff Assignment record with one of the following Job Classification values:

• (10) Administrator

• (11) Pupil Services

• (12) Teacher

[Attendance]StudentID

[Attendance]Att_Date

[Attendance]Att_Interval

[Attendance]Attendance_CodeID = [Attendance_Code]ID

[Attendance_Code]Presence_Status_CD = Present

[Code_Entity]External_Name

[S_CA_USR_StaffAssignments_C]EffectiveDate

[S_CA_USR_StaffAssignments_C]EndDate

[S_CA_USR_StaffAssignments_C]Cert_Class_Desig = 10, 11, or 12

[CC]TeacherID = [SchoolStaff]ID

Mins

The total number of instructional minutes in which the student was Present and enrolled in a section with a certificated teacher.

Sum

ADA (Days)

The report extracts 1 if the student is Present for 1 or more intervals.

N/A

5^th Hour

The report extracts 1 if the student was Present for 5 or more intervals associated with a certificated teacher.

N/A

6^th Hour

The report extracts 1 if the student was Present for 6 or more intervals associated with a certificated teacher.

N/A

Student Total

Totals for the student for the period in which the report is being run.

N/A

Report Summary

Note: This page appears at the end of the report, after all the individual student summaries. The total for each row is determined for each of the following groups of students during the report date range:

• Total Minutes: The total number of minutes for all the intervals.

• Total ADA (Days): Total students present for 1 or more intervals.

• Total 5^th Hour: Total students present for 5 or more instructional hours associated with a certificated teacher.

• Total 6^th Hour: Students present for 6 or more instructional hours associated with a certificated teacher.

Mandatorily Expelled Pupils

The report totals the number of mandatorily expelled students for each group listed above.

N/A

Non-Mandatorily Expelled Pupils

The report totals the number of non-mandatorily expelled students for each group listed above.

N/A

Grand Totals

The report totals the number of both mandatorily and non-mandatorily expelled students for each group listed above.

N/A