Client Support Guide for ACCET - 2018

Report Locations
Key Points
Summary Display
Course Header
Report Data

Report Locations

Annual > ACCET > ACCET Scheduled Hours and FTE Estimate by Date Range
Standard/Query > Student > Scheduled Hours and FTE Estimate by Date Range

Key Points

Courses must be assigned a CIP Code in order to be included
FTE is calculated by dividing scheduled hours by 900
Data must be entered correctly in Student profiles and Course setup to obtain accurate results

Start Dates
Contract Hours
Student Schedules
CIP Codes

Summary Display

Total Students – Total number of students in ALL courses with a CIP Code, who were active between 7/1/2017 – 6/30/2018.

To verify total students, query the following report:

Reports > Student > Student Demographics (Simple)
Query > Flags > Is Active On 7/1/2017 – 6/30/2018
Total Student Count is on the last page

Total Scheduled Days – The count of all days scheduled from 7/1/2017 – 6/30/2018 for ALL students active within that date range, for ALL courses with a CIP Code.

To verify total scheduled days, query the following report:

Student > Attendance > Scheduled vs Actual Hours Attendance Date Range
Start Date is 7/1/2017 and End Date is 6/30/2018
The last page will have the Days Scheduled Total

Total Contract Hours – This is the grand total of all Contract Hours taken from the Financial tab of ALL students active from 7/1/2017 – 6/30/2018.

To verify total contract hours, query the following report:

Student > Attendance > Scheduled vs Actual Hours Attendance Date Range
Start Date is 7/1/2017 and End Date is 6/30/2018
Export to CSV and run a Sum Total of the Contract Hours column
How to Run a Sum Total in Excel

Total Scheduled Hours In Range – The grand total of scheduled hours from 7/1/2017 – 6/30/2018 for ALL students active during that same date range.

To verify total scheduled hours in range, query the following report:

Reports > Student > Attendance > Scheduled vs Actual Hours Attendance Date Range
Start Date is 7/1/2017 and End Date is 6/30/2018
The last page will have the Hours Scheduled Total

Full Time Equivalent (FTE) Estimate – This is calculated by dividing ALL Total Scheduled Hours In Range (from 7/1/2017 – 6/30/2018) by 900.

To verify FTE Estimate:

Divide the above “Total Scheduled Hours In Range” by 900

Total Scheduled Hours Total – The grand total of ALL hours (included) students are scheduled for. Included students are those active from 7/1/2017 – 6/30/2018. Only applies to scheduling for courses assigned a CIP Code.

To verify the total scheduled hours total, query the following reports:

Student > Scheduled Hours vs Actual Hours Attendance Date Range
Flags > Is Active On > 7/1/2017 – 6/30/2018
Enter very wide date range to encompass all possible scheduling
Final page of report has Scheduled Hours Totals

Course Header

Taken verbatim from the Course Name as set in the Administrative Course setup
Lists Full Time Equivalent (FTE) Estimate for that specific course

Report Data

Column 1 – Permit Number: Displays the Permit Number pulled from the student profile Academics tab.
Column 2 – Student: Displays a list of students in all courses with a CIP Code, who were Active between 7/1/2017 – 6/30/2018.
Column 3 – Start Date: The Start Date pulled from the student profile Academics tab. Note this is not the Original Start.
Column 4 – Contract Hours: Displays the hours from the ContractHours field of the student profile Financial tab.
Column 5 – Scheduled Days: The total number of days the student is scheduled for from 7/1/2017 – 6/30/2018.
Column 6 – Scheduled Hours: The total number of hours the student is scheduled for from 7/1/2017 – 6/30/2018.
Column 7 – Total Scheduled Hours: The grand total of hours the student is scheduled for, not just during the date range.

accet

Creation date: 1/4/2019 9:23 AM Updated: 1/31/2019 7:29 AM

DataImage52.png

DataImage9.png

Files		Sort by Name Sort by Date
	DataImage52.png 8.2 KB
	DataImage9.png 9.5 KB

Support documents for the reporting system in OnlineSMART.