|
Validity
check of records, variables and form
Check
for missing, invalid, out-of-range duplicate institutional codes and
record identifiers such as part, section and line number as well as
needed institutional characteristics such as sector and level. Check
for missing forms vs. not applicable forms. This form is applicable to
institutions of all levels, 2-year, 4-year, and graduate only.
Fatal
error checks. An
error message is generated for each of the following relationships
when not true [fatal errors may not be overridden by editor, must be
resolved]:
- R#1
Horizontal add checks- For each level of student enrollment, the
sum of full-time enrollment + part-time enrollment must equal the
total enrollment. That is, for each of lines 1-8, column 1 +
column 2 = column 3.
- Vertical
add checks- For each enrollment status(column), i.e. full-time(column
1), part-time(column 2) and total (column 3):
- R#2
Line 1 = line 2 + line 3 in each column
- R#3
Line 6 = line 1 + line 4 + line 5 in each column
Comparison
error checks.
An error message should be generated for each of the following
conditions that is not met [comparison errors may be accepted as 'ok'
at the discretion of the editor]:
- Internal
form comparison - For each column:
- R#4
Line 7 should be less than line 2. First-time freshmen enrollment
normally does not exceed the number of undergraduates enrolled in
a program, and rarely are they equivalent. Error message when Line
7 => line 2 in any column.
- R#5
Line 8 should be less than line 3. First-time non-degree seeking
undergraduates may not exceed the number of non-degree seeking
undergraduates. Error message when Line 8 => line 3 in any
column.
- Institution
level comparison -
- R#6 An
institution, whose level is '2-year', may not report enrollment on
lines 4 or 5. Error message when institution level =' 2-year' and
enrollment on line 4 or line 5 is > 0.
- R#7 An
institution whose level is 'graduate only' may not report
enrollment on lines 1,2,3,7,8. Error message when institution
level ='graduate only' and enrollment on line 1 or 2 or 3 or 7 or
8 > 0.
- Year to
year comparisons, current year (CY) vs. prior year(PY)-
- R#8.1
– R8.6, R8.10-R8.18, For each data cell in lines 1,2,4-6 columns
1,2,3, error message when: The absolute value of the current year
minus the prior year is greater than 39 and the absolute value of
the percent change from the prior year is greater than 27. If
CY=current year data and PY=prior year data
Define
[%CHG]=absolute value of 100*[(CY-PY) / PY] applied to the cells
listed above
Error
message when absolute value (CY-PY) > 39 and [%CHG] >27
- R#8.7-8.9,
R8.19, R8.20, R9.1, R9.2, For each data cell in line 3 columns
1,2,3 and in lines 7 and 8, columns 1 and 2, error message when:
The absolute value of the current year minus the prior year is
greater than 100 and the absolute value of the percent change from
the prior year is greater than 25. If CY=current year data and PY=prior
year data
Define
[%CHG]=absolute value of 100*[(CY-PY) / PY] applied to the cells
listed above
Error
message when absolute value (CY-PY) > 100 and [%CHG] >25
- R#10.1-11.2
Apply rules 8 and 9 to PY data file NYSED-2.4
Calculated
Fields
Prelim.
Full-time, First-time Enr =line7col1+line8col1
Prelim.
Part-time, first-time Enr = line7col2+line8col2
Prelim.
Full-time Equivalent Enr = line6col1 + 1/3*line1col2
+0.4*(line4col2+line5col2)
|