 |
|
|
|
A.Execute all common edits from the General Section of the
Edit and Load Specifications.
B.If Campus Code field from submission not found in campus code column
of inst campus table
Write Error 001 on edit error message report.
C.If Campus Code field from submission not found in campus code
column of instcampus table matching institution
field (from header record) to inst code column
Write Error 040 on edit error message report.
D.If Expenditure Category field from submission not found in expense
cat code column of expense cat table matching
Year field (from header record) to yr number column
Write Error 705 on edit error message report.
E.If Restricted/Unrestricted field from submission not found
in revenue type column of restricted unrestricted table
matching Year field (from header record) to yr number
column
Write Error 681 on edit error message report.
F.If first character in the Expenditure Amount field is not zero
(0) or negative sign (-) or if remaining characters in field
is not numeric
Write Error 706 on edit error message report.
G.If Delete Switch field value is not equal to "Y" or "N"
Write Error 013 on edit error message report.
H.If Delete Switch field value is "Y" and a row does not exist
on the eg expense table matching Campus Code, Year
(from header record), Expenditure Category, Restricted/Unrestricted,
and Expenditure Description fields to
campus code, yr number, expense cat code, revenue
type code, and expense desc columns
Write Error 710 on edit error message report.
I.If Delete Switch field value is "N" and a row exists on the
eg expense table matching Campus Code, Year (from header
record), Expenditure Category, Restricted/Unrestricted,
and Expenditure Description fields to campus code, yr num,
expense cat code, revenue type code, and expense
desc columns provided submission does not contain another record
with same Campus Code, Restricted/Unrestricted,
Expenditure Category, and Expenditure Description fields with a
Delete Switch field value of "Y"
Write Error 711 on edit error message report.
J.If there are two or more records within the submission with
the same Campus Code, Restricted/Unrestricted,
Expenditure Category, Expenditure Description, and
Delete Switch field values
Write Error 712 on edit error message report.
Errors of Omission
K.If Year (from header record) > 1999 and If the combination of
campus code, expense cat code, revenue type code,
and expense desc columns from eg expens table matching
only Campus Code and Year -1 (from header record) fields
to campus code and yr number columns exists and
the combination of these columns are not reported in the submission
record matching Campus Code field to campus code
column, Expenditure Category field to expense cat code,
Restricted/Unrestricted field to revenue type code,
and Expenditure Description to expense desc
Write Warning A86 on edit error message report.
(Year -1 represents Previous Year, The current
submission should contain all combination of the above this year as it
did last year. We are checking to ensure the
above combinations are not short)
Errors of Addition (opposite of Errors of Omission)
L.If Year (from header record) > 1999 and If the combination
of Campus, Restricted/Unrestricted, Expenditure
Category, and Expenditure Description fields not
found in eg expense table matching Campus Code field to
campus code column, Year -1 field (from header record)
to yr number column, Expenditure Category field to
expense cat code column, Restricted/Unrestricted
field to revenue type code column, and Expenditure Description
field to expense desc column
Write Warning A85 on edit error message report.
(Year -1 represents Previous Year, The current
submission should contain no additional combinations of the above
this year then it did last year. We are checking
to ensure the above combinations are not too many)
Other Post Record Level Edits
M.For the entire file submission with Restricted/Unrestricted
field value of "U" and Delete Switch field value of "N", if
sum of all numeric Expenditure Amount fields (edit
706) in submission is not equal to current total expense column in
current expens table matching Institution field
(from header record) to inst code column, Year field (from header record)
to yr_num column, "A" to budget actual code column,
and "UE" to fund code column
Write Error 707 on edit error message report.
N.For the entire file submission with Restricted/Unrestricted
field value of "R" and Delete Switch field value of "N", if
sum of all numeric Expenditure Amount fields (edit
706) in submission is not equal to current total expense column in
current expense table matching Institution field(from
header record) to inst code column, Year field (from header record)
to yr number column, "A" to budget actual code column,
and "RE" to fund code column
Write Error 708 on edit error message report.
http://regents.ohio.gov/hei/financial/eeedit.html
Last updated January 3, 2000