Meeting Hours
Jump to navigation
Jump to search
Meeting Hours is an approximate calculation to determine the length of a scheduled class meeting to within 0.5 hours.
| Metadata | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Data Custodian | |||||||||
| Academic and Centralized Scheduling | |||||||||
| Data Source | |||||||||
| |||||||||
| Logical Transformation / Calculation | |||||||||
| case
when '0000' in (COALESCE(date_format(d.meeting_time_start, 'hh:mm a'),'0000'), COALESCE(date_format(d.meeting_time_end, 'hh:mm a'),'0000')) then 0 else round(((timestampdiff(MINUTE,d.meeting_time_start,d.meeting_time_end)+10)/60.0)*2)/2 end | |||||||||
| Dataset Folder and Field Name | |||||||||
| |||||||||
Business Rules
Each meeting of a class has meeting hours calculated using the Meeting Start Time and Meeting End Time to approximate the length of that meeting.
The total weekly meeting hours for all class meetings in a given week are expressed separately in the Weekly Meeting Hours.
Examples
- A class meeting TR with 10:00:00 AM Meeting Start Time and 11:20:00 AM Meeting End Time has Meeting Hours approximated of 1.5 (Weekly Meeting Hours = 3)
- A class meeting M with 07:00:00 PM Meeting Start Time and 09:50:00 PM Meeting End Time has Meeting Hours approximated of 3 (Weekly Meeting Hours = 3)