 |
|
|
|
B. If Record Type field is not found in record type code column
of record type table matching submission ("AL") and year fields (from header
record) to submission and yr number columns
Write Error 541 on edit error message report.
C. If Fund field is not found in fund code column of fund table
matching institution and year (from the header record) to institution code
and yr number columns and Fund field is not found in fund code column
of fund except table matching submission ("AL"), institution and
year fields (from the header record) to submission, institution code and
yr number columns
Write Error 500 on edit error message report
and process no further edits in this file for this record.
D. If Record Type (edit 541) and Fund (edit 500) fields in submission
are valid and Record Type and Fund are repeated within the file
Write Error 501 on edit error message report.
Edits for Record Type value of "A".
E. For Record Type field value of "A", if first character in
any of the following fields is not zero (0) or negative sign (-) or if
remaining characters in field are not numeric, write the corresponding
error from the table below on edit error message report
| Field Name | Error Number |
| Cash and Cash Equivalents | Error 529 |
| Investments | Error 510 |
| Accounts Receivable | Error 511 |
| Notes Receivable | Error 512 |
| Due from Other Funds | Error 513 |
| Prepaid Expenses and Deferred Charges | Error 514 |
| Inventories | Error 515 |
| Buildings | Error 516 |
| Construction in Progress | Error 517 |
| Land | Error 518 |
| Improvements other than Building | Error 519 |
| Moveable Equipment and Library Books | Error 520 |
| Other Assets | Error 521 |
| Total Assets | Error 522 |
F. For Record Type field value of "A", a valid Fund (edit 500),
for each numeric field (except Total Fund Assets) that is numeric (edits
529, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521) and non-zero,
if combination of Field Name (from Submission Document), Fund field, institution
(from header record) and year (from header record) is not found in asset_fund
table as a combination of asset object name, fund code, institution code,
and yr number columns
Write Error 524 on edit error message report.
G. For each record with Record Type field value of "A" with valid Fund (edit 500), if Total Fund Assets field is numeric (edit 522) and the following fields are numeric:
Cash and Cash Equivalents (edit 529),
Investments (edit 510),
Accounts Receivable (edit 511),
Notes Receivable (edit 512),
Due from Other Funds (edit 513),
Prepaid Expenses and Deferred Charges (edit 514),
Inventories (edit 522),
Land (edit 518),
Improvements other than Buildings (edit 519),
Buildings (edit 516),
Moveable Equipment and Library Books (edit 520),
Construction in Progress (edit 517),
Other Assets (edit 522)
and Total Fund Assets fields is not equal to sum of items above
Write Error 523 on edit error message report.
H. For Record Type field value of "A", a valid Fund (edit 500),
if combination of Fund field, institution (from header record) and year
(from header record) is found in fund asset table as a combination of fund
code, institution code, and yr number columns
Write Error 543 on edit error message report.
Edits for Record Type value of "L".
I. For Record Type field value of "L", if first character in any
of the following fields is not zero (0) or negative sign (-) or if remaining
characters in field are not numeric, write the corresponding error from
the table below on edit error message report.
| Field Name | Error Number |
| Accounts Payable | Error 530 |
| Notes Payable | Error 531 |
| Bonds Payable | Error 532 |
| Other Plant Indebtedness | Error 533 |
| Accrued Liabilities | Error 534 |
| Deposits | Error 535 |
| Deferred Revenues | Error 536 |
| Due to Other Funds | Error 537 |
| Other Liabilities | Error 538 |
| Total Liabilities | Error 539 |
J. For Record Type field value of "L", a valid Fund (edit 500),
for each numeric field (except Total Liabilities) that is numeric (edits
530, 531, 532, 533, 534, 535, 536, 537, 538) and non-zero, if combination
of Field Name (from Submission Document), Fund field, institution (from
header record) and year (from header record) is not found in liability
fund table as a combination of liability object name, fund code, institution
code, and yr number columns
Write Error 567 on edit error message report.
K. For each record with Record Type field value of "L" with valid Fund (edit 500), if Total Liabilities field is numeric (edit 539) and the following fields are numeric:
Accounts Payable (edit 530),
Notes Payable (edit 531),
Bonds Payable (edit 532),
Other Plant Indebtedness (edit 533),
Accrued Liabilities (edit 534),
Deposits (edit 535),
Deferred Revenues (edit 536),
Due to Other Funds (edit 537),
Other Liabilities (edit 538)
and Total Liabilities fields is not equal to sum of items above
Write Error 540 on edit error message report.
L. For Record Type field value of "L", a valid Fund (edit 500),
if combination of Fund field, institution (from header record) and year
(from header record) is found in fund liability table as a combination
of fund code, institution code, and yr number columns
Write Error 543 on edit error message report.
After processing of individual edits on each record:
M. If there is any value in fund columns of fund or fund except
tables matching only institution (from header record) and year fields (from
header record) to institution code and yr number columns (note: for any
value in submission column of fund except table) which (any value in fund
columns) is not reported in Fund field of AL submission for at least for
one of Record Type field value ("A" or "L")
Write Error 674 on edit error message report.
N. If sum of values of Due to Other Funds field for all records of Record
Type value of "L" does not equal sum of values of Due from Other Funds
field for all records of Record Type value of "A"
Write Error 624 on edit error message report.
O. For Fund field value of TA, if value of Total Fund Assets field for
Record Type value of "A" does not equal value of Total Liabilities
field for Record Type value of "L"
Write Error 661 on edit error message report.
P. If any value in record type code column of record type table matching
combination of submission, yr number and req sw columns to combination
of institution field (from header record), year field (from header
record) and value 'Y' is not reported in Record Type field of AL submission
Write Error 660 on edit error message report.
Note: The Edit and Load Specifications for Actual Financial Data (AD) File take care about Summary Edits and Load sections.
Error Messages
| Edit Code | Edit Text | Display Value |
| 500 | Fund is not provided or is not valid for this file or not valid for institution. | Fund |
| 501 | Fund is reported more than once. | Repeated Fund |
| 510 | Investments contains non-numeric data. | Investments |
| 511 | Accounts Receivable contains non-numeric data. | Accounts Receivable |
| 512 | Notes Receivable contains non-numeric data. | Notes Receivable |
| 513 | Due from Other Funds contains non-numeric data. | Due from Other Funds |
| 514 | Prepaid Expenses and Deferred Charges contains non-numeric data. | Prepaid Expenses and Other Charges |
| 515 | Inventories contains non-numeric data. | Inventories |
| 516 | Buildings contains non-numeric data. | Buildings |
| 517 | Construction in Progress contains non-numeric data. | Construction in Progress |
| 518 | Land contains non-numeric data. | Land |
| 519 | Improvements Other than Building contains non-numeric data. | Improvements Other than Building |
| 520 | Moveable Equipment and Library Books contains non-numeric data. | Moveable Equipment and Library Books |
| 521 | Other Assets contains non-numeric data. | Other Assets |
| 522 | Total Assets contains non-numeric data. | Total Assets |
| 523 | Total Assets is not equal to Sum of Assets within the record. | Total Assets |
| 524 | Invalid asset for Fund or Institution. | Fund/Asset |
| 529 | Cash and Cash Equivalents contains non-numeric data. | Cash and Cash Equivalents |
| 530 | Accounts Payable contains non-numeric data. | Accounts Payable |
| 531 | Notes Payable contains non-numeric data. | Notes Payable |
| 532 | Bonds Payable contains non-numeric data. | Bonds Payable |
| 533 | Other Plant Indebtedness contains non-numeric data. | Other Plant Indebtedness |
| 534 | Accrued Liabilities contains non-numeric data. | Accrued Liabilities |
| 535 | Deposits contains non-numeric data. | Deposits |
| 536 | Deferred Revenues contains non-numeric data. | Deferred Revenues |
| 537 | Due to Other Funds contains non-numeric data. | Due to Other Funds |
| 538 | Other Liabilities contains non-numeric data. | Other Liabilities |
| 539 | Total Liabilities contains non-numeric data. | Total Liabilities |
| 540 | Total Liabilities is not equal to Sum of Liabilities within the record | Total Liabilities |
| 541 | Record Type value is not valid for this submission. | Record Type |
| 543 | Record exists in table. | Key from submission |
| 567 | Invalid liability for institution. | Liability |
| 624 | Sum of Due to Other Funds for Record Type A not equal to Sum of Due from Other Funds for Record Type R. | Sum of Due to Other Funds/Sum of Due from Other Funds |
| 660 | A required Record Type was not reported. | Missing Record Type |
| 661 | Total Assets for Trust and Agency funds is not equal to Total Liabilities. | Total Assets/Total Liabilities |
| 674 | A fund was expected to be reported in submission but was not. | Fund |
http://regents.ohio.gov/hei/financial/aledit.html
Last updated January 5, 2000