File Description
The Course Section Schedule (CS) file contains a record for all courses offered for degree credit in a space identified in the Area Inventory (AI) file or in a space that exists in structures of which less than 50 percent is leased by the institution. Submit multiple records for course sections that meet more than once in a day or occupy more than one area. All fields reported in this file except for the Daytime Irregular Weekday Hours, Evening Irregular Weekday Hours, Nighttime Irregular Weekday Hours, and Weekend Irregular Hours fields reflect activity as of the 15th day of the autumn term. Daytime Irregular Weekday Hours, Evening Irregular Weekday Hours, Nighttime Irregular Weekday Hours, and Weekend Irregular Hours fields reflect activity for the entire autumn term.
Submission Schedule
The Course Section Schedule (CS) file is submitted once every other year for odd numbered years. The window for this file is December 1 - February 6.
Capture Date
The capture date is the 30th day after the last day of the autumn term.
Relationship to Other File Submissions
The Course Section Schedule (CS) file must be submitted after the Physical Structure Inventory (PS) file, the Area Inventory (AI) file, and the Course Enrollment (CN) file have been edited with zero errors and loaded onto the database. Every structure identified in the Course Section Schedule (CS) file must have a corresponding record in the Physical Structure Inventory (PS) file. Every area identified in the Course Section Schedule (CS) file for course sections that meet at the same time every week must have a corresponding record in the Area Inventory (AI) file. Every course section identified in the Course Section Schedule (CS) file must have a corresponding entry in the Course Enrollment (CN) file.
Data Fields
|
Field Names |
Field Attributes and Procedures |
Data Format |
| Campus | Enter a campus code from Institution/CampusCodes. | Alphabetic 4 characters Columns 1-4 |
| Structure Identifier | Enter the institution-assigned structure identifieror LEASEDCLASS or LEASEDLAB. | Alphanumeric 20 characters Columns 5-24 |
| Addition Identifier | Enter the institution-assigned addition identifier or NA (not applicable). | Alphanumeric 20 characters Columns 25-44 |
| Area Identifier | Enter the institution-assigned area identifier. | Alphanumeric 20 characters Columns 45-64 |
| Course Identifier | Enter the institution-assigned course identifier. | Alphanumeric 12 characters Columns 65-76 |
| Course Section Identifier | Enter the institution-assigned section identifier. | Alphanumeric 6 characters Columns 77-82 |
| Sunday Begin Time | Enter the Sunday begin time in military format or 0000. | Numeric 4 characters Columns 83-86 |
| Sunday End Time | Enter the Sunday end time in military format or 0000. | Numeric 4 characters Columns 87-90 |
| Monday Begin Time | Enter the Monday begin time in military format or 0000. | Numeric 4 characters Columns 91-94 |
| Monday End Time | Enter the Monday end time in military format or 0000. | Numeric 4 characters Columns 95-98 |
| Tuesday Begin Time | Enter the Tuesday begin time in military format or 0000. | Numeric 4 characters Columns 99-102 |
| Tuesday End Time | Enter the Tuesday end time in military format or 0000. | Numeric 4 characters Columns 103-106 |
| Wednesday Begin Time | Enter the Wednesday begin time in military format or 0000. | Numeric 4 characters Columns 107-110 |
| Wednesday End Time | Enter the Wednesday end time in military format or 0000. | Numeric 4 characters Columns 111-114 |
| Thursday Begin Time | Enter the Thursday begin time in military format or 0000. | Numeric 4 characters Columns 115-118 |
| Thursday End Time | Enter the Thursday end time in military format or 0000. | Numeric 4 characters Columns 119-122 |
| Friday Begin Time | Enter the Friday begin time in military format or 0000. | Numeric 4 characters Columns 123-126 |
| Friday End Time | Enter the Friday end time in military format or 0000. | Numeric 4 characters Columns 127-130 |
| Saturday Begin Time | Enter the Saturday begin time in military format or 0000. | Numeric 4 characters Columns 131-134 |
| Saturday End Time | Enter the Saturday end time in military format or 0000. | Numeric 4 characters Columns 135-138 |
| Daytime Irregular Weekday Hours | Enter the total number of daytime hours during the entire term that the section meets in this location or 000. | Numeric 3 characters Columns 139-141 |
| Evening Irregular Weekday Hours | Enter the total number of evening hours during the entire term that the section meets in this location or 000. | Numeric 3 characters Columns 142-144 |
| Nighttime Irregular Weekday Hours |
Enter the total number of nighttime hours during the entire term that the section meets in this location or 000. | Numeric 3 characters Columns 145-147 |
| Weekend Irregular Hours | Enter the total number of weekend hours during the entire term that the section meets in this location or 000. | Numeric 3 characters Columns 148-150 |
| Delete Switch | Enter Y if the record is to be deleted from the database. Otherwise, enter N. | Alphabetic 1 character Column 151 |
Additional Information
For all time fields, 12:00 a.m. (or midnight) is represented as 0000 and indicates the start of a new day; therefore, 12:00 a.m. should be represented as 0000. Do not use 2400 to represent 12:00 a.m.
Please note, if a course section spans two days (i.e., begins late one evening and ends early the next morning), two days should be reported for the course section with 0000 being used as the End Time of the first day and as the Begin Time of the second day. For example, if a course section begins on Monday night at 11:00 p.m. and ends on Tuesday morning at 1:00 a.m., Monday Begin Time would be reported as 2300, the Monday End time would be reported as 0000, Tuesday begin time would be reported as 0000, and Tuesday end time would be reported as 0100.
Special Note for reporting "overlapping" (sometimes also referred to as "joint") sections in the irregular hours fields:
- Overlapping sections are multiple sections that meet at the same time in the same place for any period of time. For example, if Typing 101 and Typing 102 meet in the same location, and Typing 101 meets Mondays from 1:00 until 3:00 p.m. and Typing 102 meets Mondays from 1:00 until 2:00 p.m., both courses are overlap for the period of 1:00 until 2:00 p.m. In this case both sections are considered "overlapping."
- Please split the time between the classes so that no time is double reported. Return to our Typing 101 and 102 example. Consider that in our example, these courses occur for 10 weeks. Typing 101 meets for a total of 20 hours during the term. Typing 102 meets for a total of 10 hours for the term. However, the room is only in use for 20 hours during the entire term. The classes should be reported such that the total hours for the room is 20 hours. Therefore, Typing 101 can be reported as 10 hours and Typing 102 can also be reported as 10 hours (or the time may be prorated differently at the reporter's discretion).
Definitions and Descriptions of Data Fields
Campus: This four-character Regents-assigned abbreviation uniquely identifies the campus (or branch) within an institution.
Structure Identifier: This institution-assigned identifier uniquely identifies the structure in which the area being reported is located. This identifier must correspond to a code entered in the Physical Structure Inventory (PS) file unless the course occurs in a leased classroom or laboratory. If the course occurs in a classroom or laboratory that exists in a structure of which less than 50 percent is leased by the institution, enter LEASEDCLASS or LEASEDLAB.
Addition Identifier: This institution-assigned identifier is assigned to areas that are located in building additions. This identifier must correspond to a code entered in the Physical Structure Inventory (PS) file. If the structure is not an addition, enter NA (not applicable).
Area Identifier: This institution-assigned identifier uniquely identifies this area. This identifier must correspond to a code entered in the Area Inventory (AI) file unless the course occurs in a leased classroom or laboratory. If the course occurs in a classroom or laboratory that exists in a structure of which less than 50 percent is leased by the institution, enter an identifier in the Area Identifier field that distinguishes this classroom or lab from other classrooms and labs that are reported with a LEASEDCLASS or LEASEDLAB Structure Identifier.
Course Identifier: This institution-assigned identifier distinguishes the course from all others offered by the institution. This identifier must correspond to a course record in the institution's Course Inventory (CI) file.
Course Section Identifier: This institution-assigned identifier, in a given term, distinguishes among two or more sections, classes, or offerings of the same course. This identifier must correspond to a course record in the institution's Course Enrollment (CN) file.
Sunday Begin Time: This field should be reported if the course section has a Sunday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Sunday End Time: This field should be reported if the course section has a Sunday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Monday Begin Time: This field should be reported if the course section has a Monday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Monday End Time: This field should be reported if the course section has a Monday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Tuesday Begin Time: This field should be reported if the course section has a Tuesday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Tuesday End Time: This field should be reported if the course section has a Tuesday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Wednesday Begin Time: This field should be reported if the course section has a Wednesday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Wednesday End Time: This field should be reported if the course section has a Wednesday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Thursday Begin Time: This field should be reported if the course section has a Thursday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Thursday End Time: This field should be reported if the course section has a Thursday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Friday Begin Time: This field should be reported if the course section has a Friday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Friday End Time: This field should be reported if the course section has a Friday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Saturday Begin Time: This field should be reported if the course section has a Saturday meeting time throughout the term and meets at the same time every week. Hour and minutes of the beginning of the reported course section should be entered in military format. If not applicable, enter 0000.
Saturday End Time: This field should be reported if the course section has a Saturday meeting time throughout the term and meets at the same time every week. Hour and minutes of the ending of the reported course section should be entered in military format. If not applicable, enter 0000.
Daytime Irregular Weekday Hours: For sections that start during daytime hours (between 8:00 a.m. and 3:59 p.m.) and do not meet at the same time every week throughout the term, enter the total number of hours during the entire term that the section meets in this location. The total number of hours should be computed by rounding each meeting time to the nearest half hour and then summing the total of those hours. If the resulting value is a decimal, round up to the nearest hour.The data in this field should be gathered from the reporting institution's schedule database. If the schedule database does not yield appropriate data, an estimation can be reported. If not applicable, enter 000.
Evening Irregular Weekday Hours: For sections that start during evening hours (between 4:00 p.m. and 11:59 p.m.) and do not meet at the same time every week throughout the term, enter the total number of hours during the entire term that the section meets in this location during night hours. The total number of hours should be computed by rounding each meeting time to the nearest half hour and then summing the total of those hours. If the resulting value is a decimal, round up to the nearest hour.The data in this field should be gathered from the reporting institution's schedule database. If the schedule database does not yield appropriate data, an estimation can be reported. If not applicable, enter 000. Also, see special note for overlapping hours, above.
Nighttime Irregular Weekday Hours: For sections that start during nighttime hours (between 12:00 a.m. and 7:59 a.m.) and do not meet at the same time every week throughout the term, enter the total number of hours during the entire term that the section meets in this location during night hours. The total number of hours should be computed by rounding each meeting time to the nearest half hour and then summing the total of those hours. If the resulting value is a decimal, round up to the nearest hour. The data in this field should be gathered from the reporting institution's schedule database. If the schedule database does not yield appropriate data, an estimation can be reported. If not applicable, enter 000. Also, see special note for overlapping hours, above..
Weekend Irregular Hours: For sections that start during weekend hours (between 12:00 a.m. Saturday and 11:59 p.m. Sunday) and do not meet at the same time every week throughout the term, enter the total number of hours during the entire term that the section meets in this location during night hours. The total number of hours should be computed by rounding each meeting time to the nearest half hour and then summing the total of those hours. If the resulting value is a decimal, round up to the nearest hour. The data in this field should be gathered from the reporting institution's schedule database. If the schedule database does not yield appropriate data, an estimation can be reported.If not applicable, enter 000. Also, see special note for overlapping hours, above.
Edit and Load Specifications
Revised June 25, 2003
|
Error Code |
Edit Message Text (Text that appears in primary edit results) |
Programming Logic |
|
001 |
The Campus Code is not in the Institution/Campus Codes table |
If Campus field is not in the Institution Campus table |
|
013 |
The Delete Switch is not Y or N |
If Delete Switch is not Y and not N |
|
040 |
The Campus code in the input record does not correspond to the login Institution code |
If Campus field does not correspond to login Institution Code |
|
182 |
Section Identifier is blank or not left justified |
If the Course Section Identifier field is blank in the first character position |
|
C58
|
Area ID does not appear in Area Inventory table for this Campus, Year, Structure Identifier, and Addition Identifier |
If Campus field is in the institution campus table and not in the borrowing campus column of the Co-located Campus table and Structure Identifier is not LEASEDCLASS and not LEASEDLAB and a row does not exist in the area inventory table for this Campus field, header Year, Structure Identifier field, Addition Identifier field, and Area Identifier field |
|
C58
|
Area ID does not appear in Area Inventory table for this Campus, Year, Structure Identifier, and Addition Identifier |
If Campus field is in the institution campus table and IS in the borrowing campus column of the Co-located Campus table identify value in lending campus column of Co-located campus table for this borrowing campus. Let this value equal Lending Campus field and Structure Identifier is not LEASEDCLASS and not LEASEDLAB and a row does not exist in the area inventory table for this Campus field OR Lending Campus Field, header Year, Structure Identifier field, Addition Identifier field, and Area Identifier field |
|
447 |
Sunday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Sunday Begin Time |
|
448 |
Sunday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Sunday End Time |
|
449 |
Sunday End Time must not be a number less than Sunday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Sunday End Time, Sunday Begin Time |
|
450 |
Monday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Monday Begin Time |
|
451 |
Monday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Monday End Time |
|
452 |
Monday End Time must not be a number less than Monday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Monday End Time, Monday Begin Time |
|
453 |
Tuesday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Tuesday Begin Time |
|
454 |
Tuesday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Tuesday End Time |
|
455 |
Tuesday End Time must not be a number less than Tuesday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Tuesday End Time, Tuesday Begin Time |
|
456 |
Wednesday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Wednesday Begin Time |
|
457 |
Wednesday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Wednesday End Time |
|
458 |
Wednesday End Time must not be a number less than Wednesday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Wednesday End Time, Wednesday Begin Time |
|
459 |
Thursday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Thursday Begin Time |
|
460 |
Thursday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Thursday End Time |
|
461 |
Thursday End Time must not be a number less than Thursday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Thursday End Time, Thursday Begin Time |
|
462 |
Friday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Friday Begin Time |
|
463 |
Friday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Friday End Time |
|
464 |
Friday End Time must not be a number less than Friday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Friday End Time, Friday Begin Time |
|
465 |
Saturday Begin Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Saturday Begin Time |
|
466 |
Saturday End Time is not a number between 0000 and 2400 |
If the first two digits of the following field is not a number between 00 and 23 or if the second two digits is not a number between 00 and 59- Saturday End Time |
|
467 |
Saturday End Time must not be a number less than Saturday Begin Time |
If the value in the first field is a number greater than zero and less than the value in the second field- Saturday End Time, Saturday Begin Time |
|
468 |
Daytime Irregular Weekday Hours is not a number between 0 and 600 |
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 |
|
471 |
No Course Section Schedule table row to delete with this Campus, Year, Structure Identifier, Addition Identifier, and Area ID |
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) |
|
473 |
Two records reported with this Campus, Year, Structure Identifier, and Area Identifier and Delete Switch |
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 |
|
487 |
A row already exists in the CS table with this Structure, Addition, Area, Course, and Section Identifier |
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) |
|
497 |
Evening Irregular Hours is not a number between 000 and 600 |
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 |
|
498 |
Weekend Irregular Hours is not a number between 000 and 720 |
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 |
|
806 |
Nighttime Irregular Weekday Hours is not a number between 0 and 600 |
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 |
|
811 |
ERROR: Irregular Daytime Weekday Hours + sum of scheduled daytime hours exceeds 100% utilization for classrooms. SEE TABLE 4 |
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. If more than 100% |
|
812 |
ERROR: Irregular Evening Weekday Hours + sum of scheduled evening hours exceeds 100% utilization for classrooms. SEE TABLE 4 |
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% |
|
813 |
ERROR: Irregular Nighttime Weekday Hours + sum of scheduled nighttime hours exceeds 100% utilization for classrooms. SEE TABLE 4 |
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% |
|
814 |
ERROR: Irregular Weekend Hours + sum of scheduled weekend hours exceeds 100% utilization for classrooms. SEE TABLE 4 |
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% |
|
815 |
ERROR: Irregular Daytime Weekday Hours + sum of scheduled daytime hours exceeds 100% utilization for laboratories. SEE TABLE 4 |
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. If more than 100% |
|
816 |
ERROR: Irregular Evening Weekday Hours + sum of scheduled evening hours exceeds 100% utilization for laboratories. SEE TABLE 4 |
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% |
|
817 |
ERROR: Irregular Nighttime Weekday Hours + sum of scheduled nighttime hours exceeds 100% utilization for laboratories. SEE TABLE 4 |
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% |
|
818 |
ERROR: Irregular Weekend Hours + sum of scheduled weekend hours exceeds 100% utilization for laboratories. SEE TABLE 4 |
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% |
|
819 |
Course and/or Section Identifier must match a Course and/or Section Identifier for this Course/Sect in the Course Enrollment table |
If the Course Identifier field and Course Section Identifier field are not blank in the first character positions and a row does not exist in the course section table for this Campus field, header Year, fall term, Course Identifier field, and Course Section Identifier field |
|
A72 |
WARNING: Capacity of room(s) exceeded by 80% |
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. e.g. 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 total number of registrants is equal to or greater than the sum of area capacity number 180% |
|
A75 |
Two records with the same Course Identifier and Course Section Identifier have been reported in the same area in submission file |
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)] |
|
A76 |
A row exists with the same Course Identifier and Course Section Identifier in the same area in the Course Section Schedule table |
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)] |
|
B70 |
WARNING: There is a course occurring in a non-assignable room (Circulation, Custodial, Mechanical, Restroom or Unfinished) |
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. |
