OHIO BOARD OF REGENTS

Edit Rules for each Course Section Schedule (CS) Record

Field Name Error Number
 

Sunday Begin Time	447
Sunday End Time	448
Monday Begin Time	450
Monday End Time	451
Tuesday Begin Time	453
Tuesday End Time	454
Wednesday Begin Time	456
Wednesday End Time	457
Thursday Begin Time	459
Thursday End Time	460
Friday Begin Time	462
Friday End Time	463
Saturday Begin Time	465
Saturday End Time	466

 
 
 
 
 
 

J.	If the value in the first column is a number greater than zero and less than the value in the second column, write the error in the third column

 

Field Name Field Name Error Number
 

Sunday End Time	Sunday Begin Time	449
Monday End Time	Monday Begin Time	452
Tuesday End Time	Tuesday Begin Time	455
Wednesday End Time	Wednesday Begin Time	458
Thursday End Time	Thursday Begin Time	461
Friday End Time	Friday Begin Time	464
Saturday End Time	Saturday Begin Time	467

FOR EDITS K-R : Use the header year AND AU term.
 

K.	If in academic calendar table, the term type code is S for this Institution Code, Year, Term and Daytime Irregular Weekday Hours field is not a number between 0 and 600
	write Error 468 on edit message file
L.	If Daytime Irregular Weekday Hours is not numeric in the academic calendar table, the term type code is Q for this Institution Code, Year, Term and Daytime Irregular Weekday Hours field is not a number between 0 and 400
	write Error 469
M.	If in academic calendar table, the term type code is S for this Institution Code, Year, Term and if Nighttime Irregular Weekday Hours field is not a number between 0 and 600
	write Error 806 on edit message file
N.	If in academic calendar table, the term type code is Q for this Institution Code, Year, Term and if Nighttime Irregular Weekday Hours is not a number between 0 and 400
	write Error 807 on edit message file
O.	If in academic calendar table, the term type code is S for this Institution Code, Year, Term and if Evening Irregular Weekday Hours is not a number between 000 and 600
	write Error 497 on edit message file
P.	If in academic calendar table, the term type code is Q for this Institution Code, Year, Term and if Evening Irregular Weekday Hours is not a number between 000 and 400
	write Error 808 on edit message file
Q.	If in academic calendar table, the term type code is S for this Institution Code, Year, Term and if Weekend Irregular Hours is not a number between 000 and 720
	write Error 498 on edit message file
R.	If in academic calendar table, the term type code is Q for this Institution Code, Year, Term and if Weekend Irregular Hours is not a number between 000 and 480
	write Error 809 on edit message file
S.	If Delete Switch is not Y or N
	write Error 013 on edit message file
T.	If Delete Switch is Y and (there is no row in the course section schedule table for this Campus field, header Year, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Course Section Identifier field, Sunday Begin Time field, Monday Begin Time field, Tuesday Begin Time field, Wednesday Begin Time field, Thursday Begin Time field, Friday Begin Time field, and Saturday Begin Time field)
	write Error 471 on edit message file
U.	If there is more than one record in the data submission file with the same Campus field, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Course Section Identifier field, Sunday Begin Time field, Monday Begin Time field, Tuesday Begin Time field, Wednesday Begin Time field, Thursday Begin Time field, Friday Begin Time field, Saturday Begin Time field, and Delete Switch
	write Error 473 on edit message file
V.	If Delete Switch is N and there is not a previous delete of the unique key and (a row exists in the course section schedule table with this Campus field, header Year, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Section Identifier field, Sunday Begin Time field, Monday Begin Time field, Tuesday Begin Time field, Wednesday Begin Time field, Thursday Begin Time field, Friday Begin Time field, and Saturday Begin Time field)
	write Error 487
W.	If (Delete Switch is N) and (there is more than one record in the data submission file with the same Campus field, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Course Section Identifier field and Delete Switch) and of all records with duplicate Campus field, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Course Section Identifier field, and Delete Switch if [(Sunday Begin Times are not equal), or(Monday Begins Times are not equal) or (Tuesday Begin Times are not equal), or (Wednesday Begin Times are not equal), or (Thursday Begin Times are not equal), or (Friday Begin Times are not equal) OR (Saturday Begin Times are not equal)]
	write Warning A75 on edit message file
X.	If Delete Switch is N and (there is a matching row in the course section schedule table for this Campus field, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Course Section Identifier field and Delete Switch) and of all rows that duplicate submission's Campus field, Structure Identifier field, Addition Identifier field, Area Identifier field, Course Identifier field, Course Section Identifier field and Delete Switch, if [(Sunday Begin Times are not equal), or (Monday Begins Times are not equal) or (Tuesday Begin Times are not equal), or (Wednesday Begin Times are not equal), or (Thursday Begin Times are not equal), or (Friday Begin Times are not equal) or (Saturday Begin Times are not equal)]
	write Warning A76 on edit message file

Summary Edits

Submission Records

Description of Variables in Table:

Sum the number of CS submission file inserts with the number of CS records already loaded to the database for this year from previous CS file submissions; subtract the number of submission file deletes.

Number of Rows on the Database before Load:

Sum the number of CS records already loaded to the database from previous CS submissions for this institution and year.

Number of Rows Added by this Submission:

Sum the number of inserts in this submission.

Number of Rows Deleted by this Submission:

Sum the number of deletes in this submission.

Note: Print Table at beginning of summary edit report if a warning occurs in the following edit. If there are no warnings do not print table.

A. IF in the area inventory table (For every instance of Campus field, Course Identifier field, and Course Section Identifier field combination that meet on the same day(s) and time(s) in this submission file, identify the header year, Structure Identifier field, Addition Identifier field, and Area Identifier field) the area type code for all records (of the Header Year, Autumn Term, Structure Identifier field, Addition Identifier field, and Area Identifier field combination) is 110 or 210, then sum (Note that usually there will only be one record but there could be more than one and then you need to sum. If the same course meets in two or more different rooms and if they ever meet at a different time based on start time then do not sum the capacity of the rooms. If they meet always at the same time then sum the capacity of the room) the area capacity number from the area inventory table for each Structure Identifier, Addition Identifier, and Area Identifier to obtain "sum of area capacity number".

Next, sum all rows in the course enrollment table with the Campus field, Course Identifier Field, and Course Section field that meet (for all courses that meet in the same room at same time. Ie., if more than one course meet at the same time in one room) for Autumn Term and header year to obtain "total number of registrants".

If the the total number of registrants is equal to or greater than the sum of area capacity number 180% then issue warning

2. If in the area inventory table for this year, campus code, physical structure identifier, addition identifier, area identifier the area type code is 010, 020, 030, 035, or 050 AND the course identifier is not blank.

The purpose of this table is to summarize the number and percentage of classrooms in use during half-hour increments for each day of the week. Note that only 30 minutes is included in each segment. For example, 0800-0830 includes minutes from 8:00 up to but not including 8:30.
 
 
 

Campus Code: XXXX

Description of Table Variables:

This is a four-character campus code associated with each campus of an institution for which data exists.

Available Classrooms: XXXXXX (top left corner):

Sum the number of rows in the Area Inventory table for each Campus and this year where the Area Type code is 110 and the Function code is not 30, 70, 81, 82. (Each area meeting these conditions is an Available Classroom.) Print total. These Available Classrooms will be used in calculations below.

Matrix for # Rooms in Use by Day and Half-hour:

For each Available Classroom, if, in the Course Section Schedule table for this year or in the submission file, the room is scheduled for 15 or more minutes within each half-hour period count that available classroom as in use. Count each room-minute combination only once. Consider the following examples:

1. Two classes meet at different times in the half-hour period 0800-0830 in Room 101. Class A meets from 0800 until 0810, and Class B meets from 0820 until 0825. Room 101 is in use for 15 minutes in the 0800-0830 half-hour period, and therefore counts as in use for the entire half-hour period.
2. Class C meets from 0800 until 0814 in Room 102. No other class meets in Room 102 during the 0800-0830 half-hour period. Room 102 is not in use from 0800-0830.
3. Two classes meet at the same time in Room 103. Both classes meet from 0800 until 0820. Room 103 counts as in use one time from 0800 until 0830. Conversely, if both classes meet from 0800 until 0810, the room does not count as in use (since it is in use under 15 minutes).
4. Class A and Class B overlap during a half-hour period in Room 104. Class A meets from 0800 until 0810 and Class B meets from 0805 until 0815. Count begins at the beginning of Class A at 0800 and ends and the end of Class B at 0815. Count equals 15, therefore, the room is in use.

Matrix for % Rooms in Use by Day and Half-hour:

Value for each combination of day of week and half-hour reflects the percentage of Available Classrooms in use to Available Classrooms.

Laboratory Utilization by Half-hour Increments for Each Day

Campus Code: XXXX

Description of Table Variables:

Campus Code:

This is a four-character campus code associated with each campus of an institution for which data exists.

Available Laboratories: XXXXXX (top left corner):

Sum the number of rows in the Area Inventory table for each Campus and this year where the Area Type code is 210 and the Function code is not 30, 70, 81, 82. (Each area meeting these conditions is an Available Laboratory.) Print total. These Available Laboratories will be used in calculation below.

Matrix for # Rooms in Use by Day and Half-hour:

For each Available Laboratory, if, in the Course Section Schedule table or this year or in the submission file, the room is scheduled for 15 or more minutes within each half-hour period count that room as in use. Count each room-minute only once. Sum the total Available Laboratories in use. Print result in # Rooms in Use column.

Matrix for % Rooms in Use by Day and Half-hour:

Value for each combination of day of week and half-hour reflects percentage of total Available Laboratories in use to Available Laboratories.

(February 8, 1998 NOTE: Until the next reporting cycle of CS in Table 4 insert NA in the following rows/columns: Classroom Stations, Total Credit Class time Utilization Statistics, Percent Daytime Weekday Use, Percent Evening Week day Use, Percent Nighttime Weekday Use, Percent Weekend Use, Laboratory Stations Total Credit Class-time Utilization Statistics, Percent Daytime Weekday Use, Percent Evening Weekday Use, Percent Nighttime Weekday Use, Percent Weekend Use.)
 

Utilization Statistics by Campus

Campus Code: XXXX

Description of Table Variables:

Campus Code:

This is a four-character campus code associated with each campus of an institution for which data exists.

Scheduled Use Statistics: For each campus having available classrooms or laboratories in the area inventory table, calculate Scheduled Use Statistics using the procedure below.

Percent Daytime Weekday Use--Classroom:

1. Sum the half-hour increments that available rooms are in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday using the statistics from table two and the following rules:

• If the class begins between 0800 and 1559 and ends after 1559 count only until 1559.
• If the class ends between 0800 and 1559 and begins before 0800 begin count at 0800.

1. Sum half-hours to determine Total Hours Classroom Use.
2. Identify the total hours available by multiplying the total number of Available Classrooms by 40 hours to determine Total Hours Classrooms Available.
3. Divide: Totals Hours Classroom Use/Total Hours Classrooms Available.
4. Multiply by 100; print percentage.

1. In the Area Inventory table, sum the capacities for each Available Classroom. Multiply this sum by 40 hours to obtain Available Classroom Capacity.
2. In the Course Enrollment table, sum the registrants (unique combinations of OBRID, Campus, Course Identifier, Course Section Identifier, this year and term) for all course sections that occur in the areas identified (Campus, Physical Structure Identifier, Addition Identifier, Area Identifier) in the submission file or in the Course Section Schedule table for those areas that meet in a half hour during which the room was in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday for this year. Multiply the total registrants by each hour that they are in the room between 0800 and 1559 to obtain Classroom Seat Fill. For example, if Greek 101 is the only class that meets between 0800 and 1559 during the week. And, Greek 101 has 9 registrants meeting in Sophia Hall, Room 202 on Monday, Wednesday, and Friday from 1:00 p.m. - 2:00 p.m. The Classroom Seat Fill equals 27
3. Divide Classroom Seat Fill/Available Classroom Capacity.
4. Multiply by 100; print percent.

1. Sum the half-hour increments that a available rooms are in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday using the statistics from table three and the following rules:

• If the class begins between 0800 and 1559 and ends after 1559 count only until 1559.
• If the class ends between 0800 and 1559 and begins before 0800 begin count at 0800.

2. Sum those half-hours to determine Total Hours Laboratory Use
3. Identify the total hours available by multiplying the Number of Available Rooms by 40 hours to determine Total Hours Laboratories Available
4. Divide: Total Hours Laboratory Use Total Hours Laboratory Use/Total Hours Laboratories Available
5. Multiply by 100; print percentage.

1. In the Area Inventory table, sum the capacities for all available laboratories. Multiply this sum by 40 hours to obtain Available Laboratory Capacity.
2. In the Course Enrollment table, sum the registrants (unique combinations of OBRID, Campus, Course Identifier, Course Section Identifier, this year and Autumn term) for all course sections that occur in the areas identified (Campus, Physical Structure Identifier, Addition Identifier, Area Identifier) in the submission file or in the Course Section Schedule table for those areas that meet in a half hour during which the room was in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday for this year. Multiply the total registrants by each hour that they are in the room between 0800 and 1559 to obtain Laboratory Seat Fill. For example, if Greek 101 is the only class that meets between 0800 and 1559 during the week. And, Greek 101 has 9 registrants meeting in Sophia Hall, Room 202 on Monday, Wednesday, and Friday from 1:00 p.m. - 2:00 p.m. The Classroom Seat Fill equals 27.
3. Divide Laboratory Seat Fill/Available Laboratory Capacity.
4. Multiply by 100; print percentage.

For each Available Classroom, sum the half-hour increments that a room is in use between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday using the statistics from table two and the following rules:

Use the calculation for Percent Daytime Weekday Use--Classrooms substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday

Percent Evening Weekday Use--Classroom Stations:

Use the calculation for Percent Daytime Weekday Use--Classrooms Stations substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday

Percent Evening Weekday Use--Laboratory:

Use the calculation for Percent Daytime Weekday Use--Laboratory substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Evening Weekday Use--Laboratory Stations:

Use the calculation for Percent Daytime Weekday Use--Laboratory Stations substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Nighttime Weekday Use--Classroom:

Use the calculation for Percent Daytime Weekday Use--Classroom substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Nighttime Weekday Use--Classroom Stations:

Use the calculation for Percent Daytime Weekday Use--Classroom Stations substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Nighttime Weekday Use--Laboratory:

Use the calculation for Percent Daytime Weekday Use--Laboratory substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Nighttime Weekday Use--Laboratory Stations:

Use the calculation for Percent Daytime Weekday Use--Laboratory Stations substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Weekend Use--Classroom:

Use the calculation for Percent Daytime Weekday Use--Classroom substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 3 SUBSTITUTE 48 hours for 40 hours.

Percent Weekend Use--Classroom Stations:

Use the calculation for Percent Daytime Weekday Use--Classroom Stations substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 1 SUBSTITUTE 48 hours for 40 hours.

Percent Weekend Use--Laboratory:

Use the calculation for Percent Daytime Weekday Use--Laboratory substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 3 SUBSTITUTE 48 hours for 40 hours.

Percent Weekend Use--Laboratory Stations:

Use the calculation for Percent Daytime Weekday Use--Laboratory stations substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 1 SUBSTITUTE 48 hours for 40 hours.

Total Credit Class-time Utilization Statistics: For each campus having available classrooms or laboratories in the area inventory table, calculate Total Credit Class-time Utilization Statistics using the procedure below.

Percent Daytime Weekday Use--Classroom:

For each Available Classroom sum the half-hour increments that a room is in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday that have already been loaded for this year to the Course Section table and those in the submission file using the following rules:

1. Identify each Campus, Structure Identifier, Addition Identifier, Area Identifier, this Year. Count each area-minute combination ONLY ONCE (even if multiple courses are identified with the area) for each minute.
2. If the class begins between 0800 and 1559 and ends after 1559 count only until 1559.
3. If the class ends between 0800 and 1559 and begins before 0800 begin count at 0800.
4. If a class is scheduled for 15 or more minutes within any half-hour period, count that half-hour as in use.
5. Sum those half-hours to determine Total Hours Classroom Use.
6. Sum all Irregular Daytime Hours for courses occurring in available classrooms for this Campus and year as indicated by records in the Course Section Schedule table and in the submission file to obtain Total Irregular Daytime Hours.
7. If in the Academic Calendar table, the Academic Term code for this institution, year, and Autumn term is S, divide the Total Irregular Daytime Hours by 15 to obtain Weekly Irregular Daytime Hours. If in the Academic Calendar table, the Academic Term code for this institution, year and Autumn term is Q, divide the Total Irregular Daytime Hours by 10 to obtain the Weekly Irregular Daytime Hours.
8. Add Weekly Irregular Daytime Hours to Total Hours Classroom Use to obtain Combined Total Hours Classroom Use.
9. Identify the total hours available by multiplying the total number of Available Classrooms by 40 hours to determine Total Hours Classrooms Available.
10. Divide: Combined Total Hours Classroom Use/Total Hours Classrooms Available.

12. If percentage is more than 100.0%, print Error 811 at top of Summary Edit Results.

1. In the Area Inventory table, sum the capacities for each Available Classroom. Multiply this sum by 40 hours to obtain Available Classroom Capacity.
2. In the Course Enrollment table, sum the registrants (unique combinations of OBRID, Campus, Course Identifier, Course Section Identifier, this year and term) for all course sections that occur in the areas identified (Campus, Physical Structure Identifier, Addition Identifier, Area Identifier) in the submission file or in the Course Section Schedule table for those areas that meet in a half hour during which the room was in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday for this year. Multiply the total registrants by each hour that they are in the room between 0800 and 1559 to obtain Scheduled Classroom Seat Fill. For example, if Greek 101 is the only class that meets between 0800 and 1559 during the week. And, Greek 101 has 9 registrants meeting in Sophia Hall, Room 202 on Monday, Wednesday, and Friday from 1:00 p.m. - 2:00 p.m. The Scheduled Classroom Seat Fill equals 27.
3. In the Course Enrollment table, sum the registrants (unique combinations of OBRID, Campus, Course Identifier, Course Section Identifier, this year and term) for all course sections with non-0000 Irregular Daytime Hours entries that occur in the areas identified (Campus, Physical Structure Identifier, Addition Identifier, Area Identifier) in the submission file or in the Course Section Schedule table. Multiply the total registrants by the Weekly Irregular Daytime Hours (obtained in step 7 in Percent Daytime Weekday Use--Classroom) to obtain Irregular Classroom Seat Fill.
4. Sum Scheduled Classroom Seat Fill and Irregular Classroom Seat Fill to obtain Classroom Seat Fill.
5. Divide Classroom Seat Fill/Available Classroom Capacity.
6. Multiply by 100; print percentage.

For each Available Laboratory, sum the half-hour increments that a room is in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday that have already been loaded for this year to the Course Section table and those in the submission file using the following rules:

1. Identify each Campus, Structure Identifier, Addition Identifier, Area Identifier, this Year. Count each area-minute combination ONLY ONCE (even if multiple courses are identified with the area) for each minute.
2. If the class begins between 0800 and 1559 and ends after 1559 count only until 1559.
3. If the class ends between 0800 and 1559 and begins before 0800 begin count at 0800.
4. If a class is scheduled for 15 or more minutes within any half-hour period, count that half-hour as in use.
5. Sum those half-hours to determine Total Hours Laboratory Use.
6. Sum all Irregular Daytime Hours for courses occurring in available laboratories for this Campus and year as indicated by records in the Course Section Schedule table and in the submission file to obtain Total Irregular Daytime Hours.
7. If in the Academic Calendar table, the Academic Term code for this institution, year and Autumn term is S, divide the Total Irregular Daytime Hours by 15 to obtain Weekly Irregular Daytime Hours. If in the Academic Calendar table, the Academic Term code for this institution, year and Autumn term is Q, divide the Total Irregular Daytime Hours by 10 to obtain the Weekly Irregular Daytime Hours.
8. Add Weekly Irregular Daytime Hours to Total Hours Laboratory Use to obtain Combined Total Hours Laboratory Use.
9. Identify the total hours available by multiplying the Number of Available Rooms by 40 hours to determine Total Hours Laboratories Available
10. Divide: Total Hours Laboratory Use Total Hours Laboratory Use/Total Hours Laboratories Available

12. If percentage is more than 100.0%, print Error 815 at top of Summary Edit Results.
 
 

Percent Daytime Weekday Use--Laboratory Stations:

1. In the Area Inventory table, sum the capacities for all available laboratories. Multiply this sum by 40 hours to obtain Available Laboratory Capacity.
2. In the Course Enrollment table, sum the registrants (unique combinations of OBRID, Campus, Course Identifier, Course Section Identifier, this year and Autumn term) for all course sections that occur in the areas identified (Campus, Physical Structure Identifier, Addition Identifier, Area Identifier) in the submission file or in the Course Section Schedule table for those areas that meet in a half hour during which the room was in use between 0800 and 1559 Monday, Tuesday, Wednesday, Thursday, and Friday for this year to obtain Scheduled Laboratory Seat Fill. See Scheduled Classroom Seat Fill for example.
3. In the Course Enrollment table, sum the registrants (unique combinations of OBRID, Campus, Course Identifier, Course Section Identifier, this year and term) for all course sections with non-0000 Irregular Daytime Hours entries that occur in the areas identified (Campus, Physical Structure Identifier, Addition Identifier, Area Identifier) in the submission file or in the Course Section Schedule table. Multiply the total registrants by the Weekly Irregular Daytime Hours (obtained in step 7 in Percent Daytime Weekday Use--Laboratory) to obtain Irregular Laboratory Seat Fill.
4. Sum Scheduled Laboratory Seat Fill and Irregular Laboratory Seat Fill to obtain Laboratory Seat Fill.
5. Divide Laboratory Seat Fill/Available Laboratory Capacity.
6. Multiply by 100; print percentage.

Use the calculation for Percent Daytime Weekday Use--Classrooms substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday. Also, if percentage is more than 100.0%, print Error 812.

Percent Evening Weekday Use--Classroom Stations:

Use the calculation for Percent Daytime Weekday Use--Classroom Stations substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Evening Weekday Use--Laboratory:

Use the calculation for Percent Daytime Weekday Use--Laboratory substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday. Also, if percentage is more than 100.0%, print Error 816 at top of Summary Edit Results.

Percent Evening Weekday Use--Laboratory Stations:

Use the calculation for Percent Daytime Weekday Use--Laboratory Stations substituting Evening Hours for Daytime Hours. Evening Hours are between 1600 and 2359 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Nighttime Weekday Use--Classroom:

Use the calculation for Percent Daytime Weekday Use--Classroom substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Also, if percentage is more than 100.0%, print Error 813 at top of Summary Edit Results.
 
 
 
 

Percent Nighttime Weekday Use--Classroom Stations:

Use the calculation for Percent Daytime Weekday Use--Classroom Stations substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Nighttime Weekday Use--Laboratory:

Use the calculation for Percent Daytime Weekday Use--Laboratory substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday. Also, if percentage is more than 100.0%, print Error 817 at top of Summary Edit Results.

Percent Nighttime Weekday Use--Laboratory Stations:

Use the calculation for Percent Daytime Weekday Use--Laboratory Stations substituting Nighttime Hours for Daytime Hours. Nighttime Hours are between 0000 and 0759 Monday, Tuesday, Wednesday, Thursday, and Friday.

Percent Weekend Use--Classroom:

Use the calculation for Percent Daytime Weekday Use--Classroom substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 9 SUBSTITUTE 48 hours for 40 hours. Also, if percentage is more than 100.0%, print Error 814 at top of Summary Edit Results.

Percent Weekend Use--Classroom Stations:

Use the calculation for Percent Daytime Weekday Use--Classroom Stations substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 1 SUBSTITUTE 48 hours for 40 hours.

Percent Weekend Use--Laboratory:

Use the calculation for Percent Daytime Weekday Use--Laboratory substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 9 SUBSTITUTE 48 hours for 40 hours. Also, if percentage is more than 100.0%, print Error 818 at top of Summary Edit Results.

Percent Weekend Use--Laboratory Stations:

Use the calculation for Percent Daytime Weekday Use--Laboratory stations substituting Weekend Hours for Daytime Hours. Weekend Hours are between 0000 on Saturday and 2359 on Sunday. ALSO IN STEP 1 SUBSTITUTE 48 hours for 40 hours.
 

Table: room utilization

Attributes: Attribute description:
 

campus code	Summarize by campus code from submission file
year num	Header Year
term code	Term (for now AU)
physical structure id	Summarize by physical structure identifier from submission file
addition id	Summarize by addition identifier from submission file
area id	Summarize by area identifier from submission file
area type code	Summarize by area type code
room day use	Sum the total hours (calculate from begin and end time fields) for every occurrence of campus, header year, physical structure id, addition id, area id between 0800 and 1559 inclusive to obtain hours used. Divide hours used by 40. Multiply by 100 and print percentage
room evening  use	Use the same calculation as for day use substituting the hours of 1600 and 2359
room night use	Use the same calculation as for day use substituting the hours of 0000 and 0759
room weekend use	Use the same calculation as for day use substituting the hours Saturday 0000 and Sunday 2359 and substituting 48 for 40
room irregular day use	Sum the irregular daytime hours, divide that sum by 15 (if in the academic calendar table, the academic term code for this institution, year and Autumn term is S) OR divide by 10 (if in the academic calendar table, the academic term code for this institution, year and Autumn term is Q) to obtain weekly hours used. Divide weekly hours used by 40. Multiply by 100 and print percentage.
room irrgular evening use	Use the same calculation as for irregular day use substituting irregular evening hours for irregular daytime hours
room irregular night use	Use the same calculation as for irregular day use substituting irregular nighttime hours for irregular daytime hours
room irregular weekend use	Use the same calculation as for irregular day use substituting irregular weekend hours for irregular daytime hours
*noncredit day activity	Sum the OR file Daytime Hours for all activity identified as NC Activity. Divide that sum by 15 (if in the academic calendar table, the academic term code for this institution, year and Autumn term is S) OR divide by 10 (if in the academic calendar table, the academic term code for this institution, year and Autumn term is Q) to obtain weekly hours used. Divide weekly hours used by 40. Multiply by 100 and print percentage.
*academic day activity	Use the same calculation as for noncredit day activity, but substitute AA Activity for NC Activity
*medical day activity	Use the same calculation as for noncredit day activity, but substitute MP Activity for NC Activity
*community service day activity	Use the same calculation as for noncredit day activity, but substitute CS Activity for NC Activity
*noncredit evening activity	Use the same calculation as for non credit day activity, but substitute Evening Hours for Daytime Hours
*academic evening activity	Use the same calculation as for academic day activity, but substitute Evening Hours for Daytime Hours
*medical evening activity	Use the same calculation as for medical day activity, but substitute Evening Hours for Daytime Hours
*community service evening activity	Use the same calculation as for community service day activity, but substitute Evening Hours for Daytime Hours
*noncredit night activity	Use the same calculation as for non credit day activity, but substitute Nighttime Hours for Daytime Hours
*academic night activity	Use the same calculation as for academic day activity, but substitute Nighttime Hours for Daytime Hours
*medical night activity	Use the same calculation as for medical day activity, but substitute Nighttime Hours for Daytime Hours
*community service night activity	Use the same calculation as for community service day activity, but substitute Nighttime Hours for Daytime Hours
*noncredit weekend activity	Use the same calculation as for noncredit day activity, but substitute Weekend Hours for Daytime Hours
*academic weekend activity	Use the same calculation as for academic day activity, but substitute Weekend Hours for Daytime Hours
*medical weekend activity	Use the same calculation as for medical day activity, but substitute Weekend Hours for Daytime Hours
*community service weekend  activity	Use the same calculation as for community service day activity, but substitute Weekend Hours for Daytime Hours

Table: campus_utilization

This table is populated by data from the CS file and OR file. Fields identified with an asterisk cannot be filled until the OR file is processed.
 
 

Attributes: : Attribute description:
 

campus code	Summarize by campus code from submission file
year num	Header Year
term code	Term (for now AU)
area type code	Summarize by area type code
day use	**
evening use	**
night use	**
weekend use	**
irregular day use	***
irregular evening use	***
irregular night use	***
irregular weekend use	***
*noncredit day activity	1. Sum all Daytime Hours in submission file and daytime hours in other use instructional rooms table for all available classrooms for this Campus and year to obtain Total Daytime Hours for NC activity code  2. If in the Academic Calendar table, the Academic Term code for this institution, year, and Autumn term is S, divide the Total Daytime Hours by 15 to obtain Weekly Daytime Hours. If in the Academic Calendar table, the Academic Term code for this institution, year and Autumn term is Q, divide the Total Daytime Hours by 10 to obtain the Weekly Daytime Hours. 3. Add Weekly Daytime Hours to Total Hours Classroom Use to obtain Combined Total Hours Classroom Use. 4. Identify the total hours available by multiplying the total number of Available Classrooms by 40 hours to determine Total Hours Classrooms Available. 5. Divide: Combined Total Hours Classroom Use/Total Hours Classrooms Available.  6. Multiply by 100; print percentage
*academic day activity	Use calculation for noncredit day activity substituting AA for NC activity code.
*medical day activity	Use calculation for noncredit day activity substituting MP for NC activity code
*community service day activity	Use calculation for noncredit day activity substituting CS for NC activity code
*noncredit evening activity	Use calculation for noncredit day activity substituting Evening Hours for Daytime Hours
*academic evening activity	Use calculation for noncredit day activity substituting Evening Hours for Daytime Hours and AA for NC activity code.
*medical evening activity	Use calculation for noncredit day activity substituting Evening Hours for Daytime Hours and MP for NC activity code.
*community service evening activity	Use calculation for noncredit day activity substituting Evening Hours for Daytime Hours and CS for NC activity code.
*noncredit night activity	Use calculation for noncredit day activity substituting Nighttime Hours for Daytime Hours
*academic night activity	Use calculation for noncredit day activity substituting Nighttime Hours for Daytime Hours and AA for NC activity code.
*medical night activity	Use calculation for noncredit day activity substituting Nighttime Hours for Daytime Hours and MP for NC activity code.
*community service night activity	Use calculation for noncredit day activity substituting Nighttime Hours for Daytime Hours and CS for NC activity code.
*noncredit weekend activity	Use calculation for noncredit day activity substituting Weekend Hours for Daytime Hours
*academic weekend activity	Use calculation for noncredit day activity substituting Weekend Hours for Daytime Hours and AA for NC activity code.
*medical weekend activity	Use calculation for noncredit day activity substituting Weekend Hours for Daytime Hours and MP for NC activity code.
*community service weekend activity	Use calculation for noncredit day activity substituting Weekend Hours for Daytime Hours and CS for NC activity code.

Extra notes for calculations:

**For day_use, eve_use, night_use, weekend_use columns, use data from the Percent Daytime Weekday Use, Percent Evening Weekday Use, Percent Nighttime Weekday Use , Percent Weekend Use columns (respectively) of Table 4.

***For irr_day_use, irr_eve_use, irr_night_use, irr_weekend_use columns use steps 6, 7, 9, 10, 11 from the equivalent sections of the Total Credit Class-time Utilization Statistics from Table 4

Course Sections for which a Record was Expected and Not Received:

This table displays the course sections in which students are enrolled for this year and Autumn term, but for which a Course Section Schedule record was not submitted.

Campus Code: XXXX
 

Course Identifier	Course Section Identifier

Description of Table Variables:

Course Identifier and Course Section Identifier:

Print each Course Identifier and Course Section Identifier that meets the following conditions:

• the Campus, Year, AU Term, Course Identifier, Course Section Identifier have already been loaded to the Course Sections Table for this year,

• in the row for that Campus, Year, AU Term, Course Identifier, Course Section Identifier, the Course Sections Table the Course Section Location field is empty

• the Campus, Year, Course Section, Course Identifier does not appear in the Course Section Schedule table for this year in the submission file.

This table displays the number of course sections that took place in rooms that were not classrooms or labs.

Campus Code: XXXX
 

Area Type	Number of Classes

Description of Table Variables:

For each Campus, Structure Identifier, Addition Identifier, Area Identifier, in this submission (as an insert) or which has already been loaded to the Course Section Schedule Table for this year, identify the Area Type code in the Area Inventory table. For each area type, sum the Course Identifier and Course Section Identifiers that meets the following conditions:

• the Campus, Year, Course Identifier, Course Section Identifier are in the submission file as an insert OR have already been inserted for this year into the Course Section Schedule Table.
• the Campus, Building Identifier, Addition Identifier, and Area Identifier in the submission file as an insert is verified in the Area Inventory table as an area that is NOT Area Type 110 and NOT Area Type 210.

1. If capacity is 0000 in the area inventory table for a classroom (area type 110) or a laboratory (area type 210), you will need to assign a capacity for the room. For classrooms (area type 110) divide the NSF for the area by 15 to derive capacity. For laboratories (area type 210), divide the NSF by 40 hours to derive capacity.
2. In all station utilization calculations, the registrants contribute to the numerator while capacity is the denominator. If total registrants is greater than capacity, use capacity for the numerator in place of registrants.
3. Room should be considered in use for station utilization to be summed when calculating scheduled classroom/laboratory seat fill.
4. In calculating station utilization (during step 2), if two courses overlap during a half-hour segment then registrants should be added before multiplying by the appropriate hours. If two course sections do NOT overlap, registrants should be averaged before multiplying.

Return to Facilities Files

http://regents.ohio.gov/hei/facilities/csedit.html
Last updated February 20, 2000