Course Section Schedule (CS) File, Revised May 16, 2001

 

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
(Detailed and technical explanation of the conditions that triggered the error)

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

445

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

445

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.