 |
|
|
|
| A. | Read Record |
| B. | If Campus field is not in inst_campus table |
write Error 001 on edit message file |
|
| C. | If Campus field does not correspond to login Institution Code |
write Error 040 on edit message file |
|
| D. | If a row does not appear in the physical structure inventory table for this Campus field, Structure Identifier field, Addition Identifier field and header year* |
write Error 411 on edit message file |
|
| E. | If Net Square Footage field is not numeric |
write Error 404 on edit message file |
|
| F. | If Net Square Footage field is 000000 |
write Warning B52 on edit message file |
|
| G. | If Capacity field is not numeric |
| write Error 405 on edit message file | |
| H. | If Area field is not in area_type table for the header year |
write Error 410 on edit message file |
|
| I. | If Area field is either (210 or 110) and Capacity field is 0000 |
write Error 895 on edit message file |
|
| J. | If Funcition field is not int the function table for header year |
write Error 407 on edit message file |
|
| K. | If Function field is 00 and Area and Function combination is not in the area_type_function table for the header year |
write Error 495 on edit message file |
|
| L. | If Area field is in the area type table and Area field is (not 110 and not 115) and Function field is either (10 or 21) and Subject field is NA in first two character positions |
write Warning B55 on edit message file |
|
| M. | If Area field is 110 and the ration of Net Square Footage/Capacity is not 5 to 50 square feet (incluvsive)/1 |
write Warning B47 on edit message file |
|
| N. | If Area field is 210 and ratio of net Square Footage/Capacity is not 10 to 400 square feet (inclusive)/1 |
write Waring B48 on edit message file |
|
| O. | If Subject field is not NA in first two character positions and is not in Subject table for header year autumn term |
write Error 003 on edit message file |
|
| P. | If Subject field is not NA in the first two character positions and if the Subject field summarized at the first two characters does not agree with a Subject summarized at the first two characters of any course enrolled in either summer or fall term of the header year and campus of this submission |
write Warning A63 (subject Code is not related to any course enrollment in Summer and fall term.) Note: It will be necessary to join the CN and CI to obtain subject Code of courses enrolled. |
|
| Q. | If Delete switch is not Y and not N |
write Error 013 on edit message file |
|
| R. | If Delete Switch is Y and there is no row in the area inventory table for this campus code field, physical structure identifier field, addition identifier field, area identifier field and header year |
write Error 439 on edit message file |
|
| S. | If there is more than one record in the data submission file with the same campus code field, physical structure identifier field, addition identifier field, area identfier field, and Delete Switch |
write Error 473 on edit message |
|
| T. | If Network Connection field is not in the network_conn table |
write Error 496 on edit message file |
|
| U. | If function code is 10, 21, 22, 30, 40, 51, 52, 53, or 54 and area type code 740 or 745 |
write Warning B68 on edit message file |
|
| V. | If area type code is equal to 110 or 210 and network code is equal U |
write Error 823 on the edit message file |
|
| W. | For each combination of campus code field, header year, physical structure identifier field, and addition identifier field contained in the Physical Structure Inventory which is neither in the Area Inventory table for this Campus, header Year, Structure Identifier, and Addition Identifier nor in this submission file for this Campus, header Year, Structure Identifier, and Addition Identifier |
write Warning A73 on edit message file |
|
| X. | If Delete Switch is Y and there are rows in crse_sect_sched for this Campus, Structure Identifier, Addition Identifier, and Submission Year |
|
|
| Y. | If Delete Switch is Y and there are rows in other_use_instr_room for this Campus, Structure Identifier, Addition Identifier, and Submission Year |
|
Note: The summary edits are performed only after the primary edits
have yielded zero errors for all records in a file submission. The scope
of the summary edit statistics consists of the net effect of this AI file
and those already loaded on the database for this institution and year.
The purpose of this table is to summarize the number of Area Inventory
rows that have been loaded on the database for this institution and year.
| Total Number of Rows on Database after Load | |
| Number of Rows on the Database before Load | |
| Number of Rows to be Added by this Submission | |
| Number of Rows to be Deleted by this Submission | |
| Number of Rows to be Changed by this Submission |
Total Number of Rows on Database after Load:
Sum the number of AI submission file inserts with the number of AI records already loaded to the database for this year and term from previous AI file submissions; subtract the number of submission file deletes.
Number of Rows on the Database before Load:
Sum the number of AI records already loaded to the database from previous AI submissions for this institution and year.
Number of Rows to be Added by this Submission:
Sum the number inserts in this submission.
Number of Rows to be Deleted by this Submission:
Sum the number of deletes in this submission.
Number of Rows to be Changed by this Submission:
Sum the number of inserts in this submission that have a key in a row
already loaded to the database.
Campus Code: XXXX Function Codes
|
Area Type Codes |
00 | 10 | 21 | 22 | 30 | 40 | 51 | 52 | 53 | 54 | 61 | 62 | 63 | 70 | 81 | 82 | Total: NSF by Area Type Range |
| 010 - 050 | |||||||||||||||||
| 110 - 115 | |||||||||||||||||
| 210 - 215 | |||||||||||||||||
| 220 - 225 | |||||||||||||||||
| 250 - 255 | |||||||||||||||||
| 310 - 315 | |||||||||||||||||
| 350 - 355 | |||||||||||||||||
| 410 - 455 | |||||||||||||||||
| 510 - 585 | |||||||||||||||||
| 590 | |||||||||||||||||
| 610 - 615 | |||||||||||||||||
| 616 | |||||||||||||||||
| 620 - 625 | |||||||||||||||||
| 630 - 635 | |||||||||||||||||
| 640 - 645 | |||||||||||||||||
| 650 - 655 | |||||||||||||||||
| 660 - 665 | |||||||||||||||||
| 670 - 675 | |||||||||||||||||
| 680 - 685 | |||||||||||||||||
| 710 - 765 | |||||||||||||||||
| 800 - 895 | |||||||||||||||||
| 900 - 970 | |||||||||||||||||
| Total: NSF by Function |
Campus Code:
This is a four-character campus code associated with each campus of an institution for which data exists.
Matrix of Function Codes by Area Type Ranges:
The value in each cell represents the total square footage for each combination of function code and area type code range. Calculate the value for each campus by summing the net square footage of all keys for each combination of function code and area type code range in the Area Inventory table and in the submission file. If a row is being changed, use the update and not the row in the table. Next, subtract the net square footage for deletes of all keys for each combination of function code and area type code range in the submission file. Print resulting value.
Total: NSF by Function:
Sum the values in the rows above and print the value.
Total: NSF by Area Type Range:
Sum the values in the columns to the left and print the value.
This table displays the square footage of area in each structure
that is considered structural area (area that cannot be occupied or put
to use because of structural building features). The value in the table
below is determined by calculating the difference between the measured
gross area (as reported in the Physical Structure Inventory file) and all
net square footage reported in the Area Inventory file. There is a table
for each campus of an institution.
Campus Code: XXXX
| Structure Identifier | Addition Identifier | Net Square Footage | Structural Area | Gross Square Footage | Percentage of Structural to Gross Square Footage |
Structure Identifier:
This is an institution assigned identifier. For each year, the Structure Identifier and Addition Identifier uniquely identify each structure.
Addition Identifier:
This is an institution assigned identifier. For each year, the Structure Identifier and Addition Identifier uniquely identify each structure.
Net Square Footage:
Sum the Net Square Footage for each Structure Identifier and Addition identifier in the Area Inventory table for this year and in the submission file where the Delete Switch is set to N. For inserts, use the key from the submission file.
Structural Area:
Sum the Net Square Footage for each Structure Identifier and Addition
identifier in the Area Inventory table for this year and in the submission
file where the Delete Switch is set to N. For inserts, use the key from
the submission file. Subtract all Net Square Footage for each Structure
Identifier and Addition Identifier where the Delete Switch is set to Y
to obtain difference. Subtract the resulting difference from the gross
square footage reported for this structure identifier, addition identifier,
and year in the Physical Structure Inventory table. If the difference is
a positive value, print the final value. If the difference is a negative
value, print Error 810 (text below) at top of file. See instructions at
beginning of Summary Edits.
| 810 | Structural area cannot be negative. NSF total must not exceed the GSF reported for this structure in the PS. |
Gross Square Footage:
Print the value in the gross square footage column for this campus, year, structure identifier, and addition identifier in the Physical Structure Inventory table.
Percentage of Structural Area to Gross Square Footage:
Calculate the percentage of structural square footage to gross square
footage using the value in the Structural Area column to the left as the
numerator and the value in the gross square footage column for this Campus,
Year, Structure Identifier and Addition identifier in the Physical Structure
Inventory table as the denominator.
Campus Code: XXXX
| Total Number of Seats Available for Classrooms (area type 110) This Year | Total Number of Seats Available
for Classrooms (area type 110)
Last Year |
Total Number of Seats Available for Classroom Laboratories (area type 210) This Year | Total Number of Seats Available for Classroom Laboratories (area type 210) Last Year |
Sum the value in the area capacity number column for each Structure Identifier, Addition Identifier, and this Year where the Area Type is 110 in the Area Inventory table with the values for Capacity for inserts in the submission file. For inserts, use the key in the submission file. Next subtract all Capacity values for each Structure Identifier and Addition Identifier for each delete. Print the value.
Total Number of Seats Available for Classrooms (area type 110) Last Year:
Sum the Capacity values of all keys for each Structure Identifier and Addition identifier where the Area Type is 110 in the Area Inventory table for last year.
Total Number of Seats Available for Classroom Laboratories (area type 210) This Year:
Sum the value in the area capacity number column for each Structure Identifier, Addition Identifier, and this Year where the Area Type is 210 in the Area Inventory table with the values for Capacity for inserts in the submission file. For inserts, use the key in the submission file. Next subtract all Capacity values for each Structure Identifier and Addition Identifier for each delete. Print the value.
Total Number of Seats Available for Classroom Laboratories (area type 210) Last Year:
Sum the Capacity values of all keys for each Structure Identifier and
Addition identifier where the Area Type is 210 in the Area Inventory table
for last year.
| Campus Code | Percentage of Rooms for which a Subject Code was Expected and not Received |
Campus Code:
This is a four-character campus code associated with each campus of an institution for which data exists.
Percentage of Rooms for which a Subject Code was Expected and not Received:
For each campus, count the key fields in the Area Inventory table for this year and inserts in the submission file where the row or record meets the following conditions:
1. The Function field is 10 or 21.
and
2. The Area Type field is not 1xx.
and
3. The Subject field is NA.
Use the resulting value as the numerator.
Next, count the key fields in the Area Inventory table for this year and inserts in the submission file where the row or record meets the following conditions:
1. The Function field is 10 or 21.
and
2. The Area Type field is not 1xx.
Use the resulting value as the denominator.
Calculate the percentage and print the value.
Campus Code: XXXX
| Total Number of Classrooms (area type 110) Available This Year | Total Number of Classrooms (area
type 110) Available
Last Year |
Total Number of Class Laboratories (area type 210) Available This Year | Total Number of Class Laboratories (area type 210) Available Last Year |
Total Number of Classrooms (area type 110) Available This Year:
Sum the Structure and Addition Identifiers where the area type is 110 and the function code is not 30 or 70 or 81 or 82, in the Area Inventory table for this year and in the submission file where the Delete Switch is set to N. For inserts, use the key from the submission file and not the value in the table. Print the value.
Total Number of Classrooms (area type 110) Last Year:
Sum the Structure and Addition Identifiers where area type is 110 and the function code is not 30 or 70 or 81 or 82) in the Area Inventory table for last year.
Total Number Classroom Laboratories (area type 210) This Year:
Sum the Structure and Addition Identifiers where the area type is 210 and the function code is not 30 or 70 or 81 or 82), in the Area Inventory table for this year and in the submission file for each insert. For inserts, use only the key from the submission file and not the value in the table. Print the value.
Total Number of Classroom Laboratories (area type 210) Last Year:
Sum the Structure and Addition Identifiers where the Area Type is 210 and the function code is not 30 or 70 or 81 or 82), in the Area Inventory table for last year.
http://regents.ohio.gov/hei/facilities/aiedit.html
Last updated March 30, 2004