|
Update
Type 1
|
|
File
or Process
|
File
Name
|
Key
Identifiers
|
Delete
|
Update
|
|
AI
|
Area
Inventory
|
Campus, Physical Structure
Identifier, Addition Identifier, Area Identifier
|
To remove rows from the
database set the delete switch for a given record to “Y”. When
the file is loaded to the database, that row will be removed.
|
To update records already
existing in the database, set the delete switch to “N” and make
sure that the record with the new value matches the key identifiers of the
row on the database being updated. The values from the latest record will
replace the values from the previous record.
|
|
AP
|
Academic
Programs
|
Program Code, Campus
|
|
CI
|
Course
Inventory
|
Course Identifier, Institution,
Year, Term
|
|
CT
|
Cohort
Tracking
|
Student Identifier, Institution
|
|
DO
|
Distance
Learning Course Offerings
|
Course Id, Institution, Year,
Term, Subject Code
|
|
DS
|
Distance
Learning Course Sections
|
Course Id, Section Id,
Institution, Year, Term
|
|
EP
|
Extended
Programs
|
Subject Code, Institution, Year,
Degree Level
|
|
ES
|
Extended
Students
|
Student Identifier, Subject Code, Institution,
Year, Degree Level
|
|
NC
|
Non-Credit Course
Section
|
Course ID, Section ID, Year,
and Campus
|
|
PE
|
Independent,
Proprietary, and Non-Ohio Colleges and Universities
Student Entrance
|
Student Identifier, Institution
and Admission Code, Year (of submission), Term (of submission)
|
|
PS
|
Physical
Structure Inventory
|
Campus, Physical Structure
Identifier, Addition Identifier
|
|
SE
|
Student
Entrance
|
Student Identifier, Institution
Assigned Switch, Admission Area, Institution, Year (of submission), Term (of
submission)
|
|
IC
(from SE): Correcting Admission Area and Institution Assigned Switch
|
|
Please note that all fields in the
SE file may be updated except for the Admission Area and the Institution
Assigned Switch. The Admission Area in the SE table is part of the key, since
multiple admission areas may be entered about a student at a school. In order
to correct the Admission Area, all files that reference that student
identifier for that admission area need to be removed.
In order to correct the
Institution Assigned Switch use the Identifier Change (IC) file. This can be
accomplished by submitting two IC files. The first IC file will contain the
Student Identifier with the bad Institution Assigned Switch as the
"Previous Identifier." The "New Identifier" in this
record will be a dummy identifier. Once that file is loaded submit a second
IC file. This file will contain the dummy identifier as the "Previous
Identifier" and the correct Student Identifier and the correct
Institution Assigned Switch as the "New Identifier."
|
|
Update
Type 2
|
|
File
or Process
|
File
Name
|
Key
Identifiers
|
Delete
|
Update
|
|
AM
|
All
Employee
|
Employee Identifier, Campus, Year
|
To remove rows from the database
set the delete switch for a given record to “Y”. When the file is
loaded to the database, that row will be removed.
|
To update records already
existing in the database, two records will be needed within the same file
submission. The first record, with the Delete Switch set to “Y” needs
to match on all fields the row on the database being updated. The second
record will contain the new information with the Delete Switch set to
“N”. Always list all records to be deleted before the
records to be inserted.
|
|
BD
|
Budget
Data
|
Record Type, Budget Type, Fund
|
|
CB
|
Changes
in Funds Balances
|
All fields
|
|
CN
|
Course
Enrollment
|
All fields
|
|
CP
|
College
Expenditure
|
Campus, Year, College ID
|
|
DC
|
Degree/Certificate
Earned
|
All fields
|
|
EE
|
Education
and General Funds Expenditure
|
Campus Code,
Restricted/Unrestricted, Expenditure Category, Expenditure Description
|
|
FD
|
Faculty
and Instructional Non-faculty Demographics
|
Faculty Identifier, Main Campus or
Institution Code, Year
|
|
FX
|
Funding
Unit Expenditure
|
Campus, Year, Funding Unit
|
|
HG
|
High
School of Graduation
|
Student Identifier, Institution,
Year
|
|
IO
|
Instruction
and General Expenditures by Object
|
Institution, Year,
Restricted/Unrestricted
|
|
OC
|
Off-campus
Course Sections
|
All fields
|
|
PD
|
Independent,
Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned
|
All fields
|
|
PH
|
Preliminary
Headcount
|
Campus, Year
|
|
RF
|
Revised
First Enrollment
|
Student Identifier
|
|
SN
|
Student
Enrollment
|
Student Identifier, Institution,
Campus, Year (of submission), Term (of submission)
|
|
SR
|
Sources
of Education and General Revenues
|
Campus, Year, Unrestricted/Restricted
|
|
TF
|
Undergraduate
Tuition and Fees
|
Student Identifier, Institution,
Year, Term
|
|
UF
|
Unit
Record Financial Aid
|
Student Identifier, Institution,
Year, Term
|
|
DC:
Resubmitting Files Prior to 2003
|
Degree/Certificate
Earned
|
In 2003 we began collecting
Academic Program Code, which added fifteen more characters to the DC file.
The DC file edits now require this field for any year, including those prior
to 2003 when this field was not collected. When correcting DC files for terms
prior to 2003 please insert "PRECOLLECTION" into this field. The
edits have been created to accept the phrase "PRECOLLECTION" for
years prior to 2003.
|
|
SN:
Resubmitting Files Prior to Autumn 2000
|
Student
Enrollment
|
In autumn 2000 we began collecting
Cumulative Credit Hours Earned, which added five more characters to the SN
file. The SN file edits now require this field for any term, including those
prior to autumn 2000 when this field was not collected. When correcting SN
files for terms prior to autumn 2000 please insert "00000" or the
real Cumulative Credit Hours Earned into this field. The edits have been
created to accept the zeros for terms prior to autumn 2000.
|
|
Update
Type 3
|
|
File
or Process
|
File
Name
|
Key
Identifiers
|
Delete
|
Update
|
|
AC
|
Alternative
Credit
|
All fields
|
To remove rows from the
database set the delete switch for a given record to “Y”. When
the file is loaded to the database, that row will be removed.
|
To update records already
existing in the database, two files will be submitted. First, remove
rows from the database by setting the delete switch for a given record to
“Y”. When the file is loaded to the database, that record will be
removed. Add the updated records to the database by submitting a second
file with the new information and the delete switch set to “N”.
|
|
AE
|
Aggregated
Enrollment
|
All fields
|
|
AL
|
Funds
Assets and Liabilities
|
Fund field, Institution, Year
|
|
AS
|
Academic
Scholarship Certification
|
Student Identifier, Term, Year
|
|
CF
|
Changes
in Current Funds
|
All fields
|
|
CS
|
Course
Section Schedule
|
Campus, Structure Identifier,
Addition Identifier, Area Identifier, Course Identifier, Course Section
Identifier
|
|
FF
|
Faculty
and Instructional Non-faculty Funding
|
Faculty Identifier, Campus Code,
Fiscal Year, Funding Unit
|
|
FS
|
Flexibly
Scheduled Course Sections
|
Year, Term, Campus, Course
Identifier, Section Identifier
|
|
OG
|
OCOG Grant Certification
|
Student Identifier, Institution,
Term, Year
|
|
OR
|
Other
Use of Instructional Rooms
|
Campus, Year (of submission), Structure
Identifier, Addition Identifier, Area Identifier, Activity
|
|
OS
|
Other
Source of Funds
|
Campus, Structure Identifier, Addition
Identifier, Other Sources of Funds, Year
|
|
ST
|
Course
Sections Taught
|
Campus, Year, Term, Course,
Section, Faculty Identifier
|
|
TC
|
Tech
Prep Consortium Tracking
|
All fields
|
|
TM
|
Transfer
Module
|
All fields
|
|
XR
|
Cross
Registration
|
All fields
|
Return to Regents
Home Page