Vocational Monthly and Annual FTE ADA/ADM Audit
Introduction
This report includes daily attendance (ADA) and daily membership values (ADM) totals students enrolled in vocational courses based on reporting period. The report displays ADA/ADM student totals in the following comma separated format: Last Name, First Name, State Student Number, Student Number, Report Period, Grade, District Number, School Number, Sped Disability, Local Class Number, Course Code, Course Name, CTE, ADM, ADA.
Note: School_ID is the student's school of enrollment. CCSchool_ID is the student's school ID where they are enrolled in the class being reported. If the class is taken at another school the School_ID and CCSchool_ID will be different. If the values are the same the student took the class being reported at the school in which they are enrolled.
ADA/ADM Calculation
See the vocational ADA or ADM report for details on calculated values.
Note: Review additional information about troubleshooting attendance totals.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Course Enrollment Selection
The report selects records from the [CC] table based on the following criteria:
- The course must be assigned to a school included in the report and the school must not be excluded from state reporting.
- The course must be marked as Vocational.
- The course must have a Department equal to A12, FCS, FCSO, HS, TI, TEE, BT, ME, CA, or VOCM (2012-13 and prior).
- The course must have a Department equal to AG, CONS, ARTS, BUS, EDU, FIN, GOV, HS, HOSP, HUSV, IT, LAW, MANU, MKTG, TRAN, STEM, WBL, CA or CTE (2013-Present).
- The student must have enrolled in the course section on or before the report end date.
- The student must have exited the course section on or after the report start date.
- The student must not be excluded from state reporting.
- The student must be either enrolled in grade level 7, 8, 9, 10, 11, or 12, or the student must have a special program enrollment with the name Option 07, Option 08, or Option 09.
Note: If the EDPlan import is being used special education option status will be derived from the imported data. If the EDPlan import is not being used the report will use Student > Special Programs to derive special education options status.
Report Input
For help with navigation and report generation, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
Note: The All Schools option is only available when running the report from the District Office. |
Select Students | Choose one of the following from the pop-up menu:
|
Reporting Period | Choose the appropriate reporting period from the pop-up menu. The dates for each reporting period are based on the reporting segments set up for each school.
|
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 # | Data Element | Description | [Table]FieldName |
1 | Last_Name | Student’s Last Name | [Students]Last_Name |
2 | First_Name | Student’s first name. | [Students]First_Name |
3 | Student_Key | Student’s state student number | [Students]State_StudentNumber |
4 | Student_Number | Student’s student number | [Students]Student_Number |
5 | Report_Period | The report period the report was completed for. | N/A |
6 | Grade | Student’s grade level. | [Students]Grade_Level |
7 | District_ID | Student’s district ID | [Students]DistrictOfResidence |
8 | School_ID | Student’s school ID | [Students]SchoolID |
8 | CCSchool_ID | Student’s Class Enrollment school ID Note: School_ID is the student’s school of enrollment. CCSchool_ID is the student’s school ID where they are enrolled in the class being reported. If the class is taken at another school the School_ID and CCSchool_ID will be different. If the values are the same the student took the class being reported at the school in which they are enrolled. | [CC]SchoolID |
9 | SPED_Code | Student’s special program enrollment code in option 07, 08 or 09, if it exists. | [SpEnrollments]ProgramID |
10 | Local_Class_Number | The course number and section number of the student’s course enrollment. | [CC]Course_Number [CC]Section_Number |
11 | Course_Code | Course Number | [CC]Course_Number |
12 | Course_Name | Course Name | [Courses]Course_Name |
13 | CTE | CTE value. See the Appendix for valid values based on year. | [Courses]Sched_Department |
14 | ADA | The report calculates ADA for students who meet one of the two following criteria:
Note: The ADA values are listed at 5 digits. These values are summed and truncated to 4 digits before being reported in the vocational ADA report. | N/A |
15 | ADM | The report calculates the daily membership for students who meet one of the two following criteria:
The report adds the value for students taking vocational classes offered by the district and subtracts the value for students taking vocational classes offered by another district. Note: The ADM values are listed at 5 digits. These values are summed and truncated to 4 digits before being reported in the vocational ADM report. | N/A |