OHIO BOARD OF REGENTS

• Purpose
• Scope
• Outstanding Issues
• Order of Processing
• Detailed Steps of Processing
• Plans for Operations of the Subsidy FTE Process
• Sample Displays from the Operations

Query of Detail Enrollment Table

Changes since the Sept 29, 1999 version:

1. Exclude CN records with "E" in the Attempt for Academic Credit field, see Step 2.
2. Change the 20% in the Bac Limit Rule to 30%, if the Subsidy Consultation agrees, see Step 11.
3. Apply Medical 2 Caps and Medical 5 Percent Repeater rule.

Purpose

Scope

SCH excluded from subsidy: These credit hours have no impact on the subsidy for a campus. They are calculated for each campus and are excluded from the subsequent processes and calculations. Excluded SCH include such enrollments as: audits, cross registration at the host institution (these enrollments are subsidized at the home institution), enrollments in courses marked ineligible for subsidy, combinations of student rank and course level that are ineligible for subsidy (e.g., a freshman student in a professional course), off-campus courses offered at a level that makes them ineligible for subsidy (e.g., a general studies course offered off-campus of a university main campus), and medical enrollments that have exceeded their terms of subsidy.

Eligible Student FTE: These credit hours are calculated by campus and subsidy model.

Ineligible Student FTE: These credit hours are calculated by campus and subsidy model. Students are coded as ineligible for subsidy for such reasons as non-payment of fees, non-Ohio residency, graduate students with excess credit hours, and Selective Service non-compliance.

Outstanding Issues

1. Doctoral cap calculations have not yet been implemented.

Order of Processing

Step 1    Gather all course enrollments, cross registrations, and medical enrollments into a single table and join in related attributes.
Step 2    Exclude course enrollments that have no impact on subsidy.
Step 3    Adjust the subsidy level of course enrollments that may have been classified for subsidy inappropriately.
Step 4    Map course enrollments to subsidy model based on their subject code and course level.
Step 5    Adjust the subsidy model for enrollments in courses that have been approved as exceptions to the rule of determining subsidy model based on subject code and course level.
Step 6    Classify student enrollments as eligible for subsidy or ineligible for subsidy.
Step 7    The processing in this step has been distributed to other steps.
Step 8    Summarize course enrollments by campus and subsidy model for both eligible and ineligible SCH.
Step 9    Apply the Law Caps.
Step 10  Apply the Doctoral Caps. This process will not be implemented.
Step 11  Apply the Baccalaureate Limit rule. For FY 1998 the fall Baccalaureate Limit excesses are repeated for winter and spring terms and entered into the system via Journal Entry records in Step 15. For FY 1999, the calculations described below will be performed for autumn term data and any resulting adjustments will be copied into spring term and winter term for institutions on a quarter calendar.
Step 12  Apply the Medical 5 Percent Repeater rule.
Step 13  Apply the Medical 2 Caps.
Step 14  Apply medical buffering rule.
Step 15  Enter Journal Entry transactions.
Step 16  This processing has been combined with Step 18.
Step 17  Submit to institutions for further review.
Step 18 Summarize the Subsidy FTE for all terms of the fiscal year calculated so far.

Detailed Steps of Processing

Step 1: Gather all course enrollments, cross registrations, and medical enrollments into a single table.

Add to these all enrollments in the Cross Registration (XR) file. Join with the Institution Campus table based on the Integrated Post secondary Education Data System (IPEDS) Institution Code to pick up the Regents Institution Code of the host institution for Ohio public institutions. Join cross registrations at Ohio public institutions with the Course Inventory (CI) file of the host institution, and Student Enrollment (SN) file of the main campus of the home institution, if one exists, or any other campus if there is none for the main campus. Because the term calendars at the home and host may differ and semester institutions have no winter term, for the CI, match winter term at a home institution on a quarter calendar with the previous fall term of a host institution on a semester calendar. Because the XR does not report course section, explicit data about which course section is involved in cross registration is absent, HEI will assume it is not off-campus and not a Resident Credit Center (RCC) course. The credit hours in an XR enrollment are interpreted according to the calendar of the home institution. Combine the Cross Registration enrollments with those from the Course Enrollment table. Enrollments generated from above are labeled XR in the Source for the display of Step 1 data.

Add to these the professional medical enrollments from the  Student Enrollment (SN) file. Each medical student enrollment record will be treated as 15 SCH (one FTE on a three term per year basis) per term for subsidy purposes; enrollments in programs training students for the MD or DO will be attributed to the Med 2 model, while Veterinary Medicine, Dentistry, Optometry, and Professional Psychology enrollments will be attributed to Med 1. Also, from the Student Enrollment table to pick up Rank, Major Field of Study (Subject), and Student Subsidy Eligibility. Major Fields of Study that relate to professional medicine are found in the Medical Funding Units verification table.  Enrollments generated from above are labeled ME in the Source for the display of Step 1 data.

Step 2: Exclude course enrollments that have no impact on subsidy.

1. Audit enrollments: Audit enrollments are identified by an "A" coded in the Attempt for Academic Credit field of the Course Enrollment table.
2. Cross registration at host institution: Cross registrations at host institutions are identified by a "C" in the Attempt for Academic Credit field of the Course Enrollment table.
3. Course excluded due to Residency: Course enrollments to be excluded from subsidy due to the student's residency are identified by a "E" in the Attempt for Academic Credit field of the Course Enrollment table. This change is effective as of AU 2000.
4. Cross registration at the home institution for which the host Course Inventory record is not available: Cross registration at the home institution for which the host Course Inventory record is not available was discussed in Step 1.
5. Cross registration in a "FOREGN" that is not an "FXCHNG" foreign exchange: Cross registration for which the host IPEDS institution is FOREGN represents registration in a foreign institution that is not included in a Foreign Exchange program and is excluded from subsidy.
6. Cross registration at an institution other than Ohio public institutions: Cross registration for which the host IPEDS institution is not an Ohio public Institution, has an IPEDS Institution code which is either not in the Institution Campus table, or relates to a campus type of Independent (IS). Note, this case may need to be subsidized.
7. Enrollments in courses that do not earn subsidy: Courses whose enrollments do not earn subsidy are identified by an "N" in the Eligible for Subsidy field of the Course Inventory table.
8. Student rank and course level combinations that do not earn subsidy: Student rank is recorded in the Student Enrollment table and Course Level is obtained from the Course Inventory table. This combination is matched against the Course Level by Student Rank verification table. If there is a matching entry with an "E" (for exclude) coded in the Subsidy Level field then the SCH for the corresponding course enrollment are excluded from subsidy calculation. An example of this would be a freshman student enrolled in a doctoral level course.
9. Enrollments in off-campus course sections that do not earn subsidy: Off-campus course sections are identified by a non-blank, non-null, in the Section Location field of the off-campus attribute of the Course Section table. For such sections, match the campus from the Course Enrollment table and Course Level from the Course Inventory table against the Off campus Course Level verification table. If there is a matching entry with "E" (for exclude) coded in the Subsidy Level field then the SCH for the corresponding course enrollments are excluded from subsidy. An example of this would be a graduate level course offered off-campus from a branch campus of a university. An exception to this exclusion is if the Section Location field is coded FOREIGNCN. In this case do not exclude the course enrollment because it should be subsidized.
10. Medical enrollments for students enrolled more than 13 terms or four terms as a repeater: Medical Students who are to be excluded from Subsidy for this reason have the code "IM" in the Student Subsidy Eligibility code of the Student Enrollment table.
11. Medical students enrolled in non medical courses: Medical students are identified by a Major Field of Study in the Student Enrollment table, which equals a Subject Code in the Medical Funding Unit verification table and Rank equals PR. All enrollments by students with these characteristics are excluded from subsidy.
12. Course enrollments for which there are no student enrollments: Count the number of rows in the Course Enrollment table which are identified by a value other than "C" in the Attempt for Academic Credit field for which there is no corresponding Student Enrollment row. This count should be zero because the only course registrations which may not be supported by a Student Enrollment are those at the host institution of a cross registration when the host is not claiming subsidy. Note, the details of this cross registration situation are still being negotiated at this writing.

Step 3: Adjust the subsidy level of course enrollments that have been classified for subsidy inappropriately.

Reason 1: Certain student rank and course level combinations, when compared against the Course Level by Student Rank verification table (as in Step 2), will match with a row that identifies a Subsidy Course Level different from the assigned Course Level. In this case, the Subsidy Course Level replaces the assigned Course Level. Example: A master's student enrolled in a doctoral level course would be considered a master's student for subsidy purposes.

Reason 2: Certain campus and course level combinations for off-campus course sections, when compared against the Off-campus Course Level verification table (as in Step 2), will match with a row that identifies a Subsidy Course Level different from the assigned Course Level. In this case, the Subsidy Course Level would replace the assigned Course Level. Example: A baccalaureate level course offered off-campus from a community college would be considered General Studies for subsidy purposes.

Reason 3: OSCF campus offers some B level courses, but they are subsidized at the G level.

Note that these reasons for adjusting subsidy course level are not mutually exclusive. A given course enrollment might qualify to have its level adjusted for more than one reason. In order to balance with the total number of SCH on the database, we will count each adjusted enrollment as being adjusted for only one reason. The order of processing described in this document outlines the order of execution.

Note also that Foreign Exchange, Medical, and previously excluded enrollments are not subject to this adjustment of course level.

Step 4: Map course enrollments to subsidy model based on their subject code and course level.

Foreign exchange is an exception. If the IPEDS Institution Code from the Cross Registration record is FXCHNG, then automatically map to Bac 2 as the subsidy model.

Another exception occurs when the subject level combination is not included in the Subject Level to Subsidy Model mapping file. This can happen due to the change of level that can be imposed by Step 3. In this case, map the subject combined with the original level, which is in the mapping file, select the model number from this mapping, and affix it to the model level that it is being changed to. For example, if the subject and original level map to Bac 2, and the subject and adjusted level are not in the mapping file, and the adjusted level is G, then map to GS 2.

Step 5: Adjust the subsidy model for enrollments in courses that have been approved as exceptions to the rule of determining subsidy model based on subject code and course level.

Course enrollments will be compared with the Course Subsidy Exceptions table based on the Institution Code and Course Identifier from the Course Inventory (CI) file as well as year and term. If there is a match, the Subsidy Model from this table replaces the one from the basic mapping in Step 4.

Currently, there are no examples of courses in this category.

Step 6: Classify student enrollments as eligible for subsidy or ineligible for subsidy.

The SCH for the ineligible students should be separated from the SCH for eligible students.

Step 7: Summarize special totals.

            Step 7.1: Exempted enrollments for Doctoral Caps.
This step will not be implemented.
            Step 7.2: Enrollment in Resident Credit Center (RCC) course sections.
Other special totals are kept for each campus's SCH in RCC course sections, which will later be used in the calculation of the baccalaureate limit. The only campuses affected are the branches of universities. Summarize all course sections at the baccalaureate course level which have been declared as RCC in the Course Section table and have less than 60 percent of the enrollment SCH by students with Freshman (FR), Sophomore (SO), or Not Otherwise Classified Undergraduate (NU) Rank. This check will be completed by the input edit process, but it is only a warning. These totals should exclude course sections offered in summer term. Keep the totals for all undergraduate enrollments and for each baccalaureate model and eligible/ineligible model for each campus.

            Step 7.3: Law enrollments for Law Caps.
Special totals are kept for law caps; summarize SCH by institution for subject code 220101, level P.

Step 8: Summarize course enrollments by campus and subsidy model for both eligible and ineligible SCH.

1. Course enrollments from the Course Enrollment table, except professional law, (Source CN)
2. Professional Law, Subject Code 220101, Level P, (Source LW)
3. Cross registration enrollments, (Source XR)
4. Professional medical enrollments (Source ME).

Step 9: Apply the Law Caps.

Each spring term, in the process of determining subsidy FTE, HEI will compare the number of annualized subsidy eligible FTE in the Law field (subject code 220101) at the professional level (P) for the summer and fall terms combined (annualized FTE = fall SCH/15 + summer SCH/30) against these fixed caps. Any amount in excess of the cap for that institution will be subtracted from the eligible SCH for the subsidy model that Law is in (M&P 1) and added to the ineligible SCH for this model. In FY 1998, the law enrollments for summer and fall term 1997 are included in the data file from UIS in the source labeled U LA.

These deductions from eligible M&P 1 and additions to ineligible M&P 1 are added to the summary data from Step 8 with the source Law C.

Step 10: Apply the Doctoral Caps.

Step 11: Apply the Baccalaureate Limit Rule.

Below is a more detailed description of the Baccalaureate Limit calculations. To aid in understanding the calculations, an example of this calculation is given in Baccalaureate Limit Calculation.

• This rule applies to the combination of enrollments in all terms except summer.
• Identify two-year campuses eligible to offer baccalaureate level courses by summarizing the Subject/Campus/Course Level verification table by campus and level. Use the Institution/Campus Codes table to confirm that it is a two-year campus.
• Exempt baccalaureate level RCC course sections from the Baccalaureate Limit calculation. Such courses must meet the following criteria:

• Determine the Baccalaureate Limit.

• Determine if the Baccalaureate Limit has been exceeded.

Additionally, the enrollments for all campuses of SSCC (Southern State Community College) should be added together for these calculations and SSCC should be considered as one campus in the final groupings of SCH by subsidy model.

For FY 1999, the calculations described below will be performed for autumn term data and any resulting adjustments will be copied into spring term and winter term for institutions on a quarter calendar.

NOTE: Adjustments made in Steps 12, 13, and 14 will be part of the SP term Subsidy FTE calculations.

Step 12: Apply the Medical 5 Percent Repeater rule.

Step 13: Apply the Medical 2 Caps

Each medical institution has been assigned a base enrollment FTE. The base enrollments, which are also used for medical buffering, are held in the Medical Base Enrollment table. If the institution’s FTE for all subsidy eligible Med 2 enrollments (including students coded as medical repeaters) for the fiscal year is greater than the institution’s base FTE, then the subsidy eligible FTE will be the smaller of the following:

• The base FTE plus the FTE for medical repeaters OR
• The FTE for all Med 2 enrollments including medical repeaters.

Step 14: Apply Medical Enrollment Buffering rule.

Each medical institution has been assigned a base enrollment FTE. If the institution's eligible Med 2 enrollments, for the fiscal year, are less than this base amount, then the eligible Med 2 enrollments are increased to an amount equal to 65 percent of the base enrollments plus 35 percent of the current year enrollments. The base enrollments are held in a table called the Medical Base Enrollment table.

Step 15: Enter Journal Entry transactions.

Journal Entry transactions serve the purpose of entering management decisions into the process to override or augment the automated process. The Journal Entry provides a facility for entering a transaction and retaining the transactions in a database table.

Each Journal Entry transaction consists of a year, term, campus identification, number of SCH (positive or negative), subsidy model, an eligible or ineligible switch, and reason for the transaction.

The subsidy FTE process simply sums the SCH for the year and term by subsidy model, campus, and eligible/ineligible and adds these to the other SCH in the process. Then, the entered transactions are kept in a table called the Subsidy Journal Entry table for historic reference.

This step is executed every term for the Journal Entry transactions for that term.

Step 16: Convert the SCH to FTE.

This processing has been combined with Step 18.

Step 17: Submit to institutions for further review.

This step could result in more Journal Entry transactions and a repeat of  the conversion to FTE.

Step 18: Add UIS Enrollments for Summer and Fall 1998

Summarize the SCH for all terms in the fiscal year that have been calculated to date by Campus, Model, and Eligible/Ineligible. Also convert SCH to FTE.

Generally, SCH can be converted to FTE on a term by term basis by dividing by 45 for campuses on a quarter calendar, and by 30 for campuses on a semester calendar. The Academic Calendar table shows the calendar for each institution, each term, as well as the calendar type, semester, or quarter. Note the following exceptions:

• In the first year of HEI, fiscal 1998, subsidy will run as part of HEI, but will get enrollments for summer and fall terms from UIS;
• Sometimes part of a campus runs on a different calendar than the rest of the campus. Currently, the only case is that of professional level (P) law (subject code 220101), which is always on semesters regardless of an institution's calendar.

Plans for Operations of the Subsidy FTE Process

1. The process is executed in two steps. The first step, which calculates the Subsidy FTE and stores the results in a table, is produced as part of the end-of-term process. The second step, which institutions can use to view the Subsidy FTE calculations in summary or in detail, is produced via links on the Restricted Outputs Web page. In both cases login identifiers with permission to execute the process are required. Only data for a person's own institution are displayed.
2. The steps in the process that relate to enrollments for a single term are executed regardless of the term requested. Those that relate to the enrollments for an entire fiscal year are executed only when spring term is requested. Each step displays summary statistics intended to report the processing performed in the step. These data may be used to verify or balance the Subsidy FTE process with other data. The date on which the Subsidy FTE calculations were made is displayed in the heading of the display.
3. These summary statistics have a "drill down" capability for the exception cases. With this facility, "click" on the link and a query of the detailed enrollments that constitute that total are displayed.
4. After the summary statistics, there is a query facility to dynamically access any or all rows of the detailed enrollment table. The query screen is described below after the drill down statistics sample tables.
5. Both the summary and detailed displays are in the form of html files. These may be viewed on the Web, or saved as local html files for use with desk top analysis tools such as Excel.
6. As part of the execution  of the process, two permanent database tables are created. One contains the detailed course enrollments from the CN, XR and ME tables, augmented with the sufficient dependent attributes to calculate the Subsidy FTE. The table also contains attributes which reflect the disposition of the enrollment in the Subsidy FTE process. The second table is a summary of SCH and FTE by campus, year, term, model, eligibility, and source of data. The year and term of all rows in both tables should reflect the calendar year and term of the term that the data represents. In the case of data reflecting the entire fiscal year, such as Law Cap adjustments, use spring for the term and calendar year of the spring term. In order to make the Subsidy FTE process repeatable, the process includes facilities to delete rows in both tables which will be recalculated as part of executing the process. Therefore, for any term, the detailed course enrollment table rows for the term being calculated are deleted. In summer term, all rows of the summary table for the term being calculated are deleted. In autumn term, all rows of the summary table for the term being calculated are deleted plus Baccalaureate Limit adjustments for winter and spring terms are deleted. For winter and spring terms, all rows except Baccalaureate Limit adjustments for the term being calculated are deleted.
7. The various Sources of SCH are:

CN -- Course Enrollments
XR -- Cross registration
LW -- Law Enrollments (converted to semester hours)
Law C -- Law Cap adjustments
Bac L -- Baccalaureate Limit adjustments
DC -- Doctoral Cap adjustments
JE -- Journal Entry adjustments
U Camp -- UIS converted enrollments (for Summer and Fall 1997 only)
U LA -- UIS converted enrollments for Law (for Summer and Fall 1997 only)
U Off -- UIS converted enrollments for Off campus (for Summer and Fall 1997 only)
U RCC -- UIS converted enrollments for RCC (for Summer and Fall 1997 only)
The preceding UIS sources are intended to be used for balancing enrollments for Summer and Fall 1997 with the "Eligible and Ineligible FTE Calculation Fiscal Year 1998" report dated December 17, 1997, which has been sent to institutions.
 
UF Camp -- UIS converted enrollments (for Summer and Fall 1997 only)
UF Off -- UIS converted enrollments for Off campus (for Summer and Fall 1997 only)
The preceding UIS sources are intended to be used for balancing enrollments for Summer and Fall 1997 with the "Flexibly Scheduled Course Sections" report dated February 2, 1998, which has been sent to institutions.
 
UE -- UIS Foreign Exchange memos (for Summer and Fall 1997 only)

Sample Displays from the Operations

Institution                                                      Year      Term
CLEV Cleveland State University                 1998    Spring

Total Enrollment by Source of Input Report (Produced in Step 1)
The totals in this table should balance totals reported in the summary edits of the data submission.
 

Campus	Source	Enrollments (Rows)	SCH
CLEV	CN	40,752	149,743.0
CLEV	XR	15	175.0
CLEV	ME	0	0.0
	Total	40,767	149,918.0

Total Enrollments by Reason for Exclusion Report (Produced in Step 2)
 

Campus	Exclusion Reason	Enrollments (Rows)	SCH
CLEV	Audits	309	1173.0
CLEV	Host of XR	0	0.0
CLEV	XR with no CI	1	12.0
CLEV	Foreign XR	1	12.0
CLEV	Non-public Ohio XR	1	12.0
CLEV	Ineligible Courses	0	0.0
CLEV	Rank vs Level	0	0.0
CLEV	Excluded Off campus	71	284.0
CLEV	Medical Course Enrollments	0	0.0
CLEV	Medical over 13 terms	0	0.0
CLEV	Medical over 4 terms repeater	0	0.0
CLEV	SN Missing	0	0.0
CLEV	Non-Ohio XR	1	12.0
CLEV	Included Enrollments	40,383	148,413.0
CLEV	Total	40,767	149,918.0

Total Enrollments by Reason for Altering Subsidy Level Report (Produced in Step 3)
 

Campus	Altered Level Reason	Enrollments (Rows)	SCH
CLEV	Off-Campus	0	0.0
CLEV	Rank vs Level	221	831.0
CLEV	Unaltered Enrollments	40,153	147,474.0
CLEV	Excluded Enrollments	384	1,505.0
CLEV	Total	40,767	149,918.0

Total Enrollments by Method of Mapping to Subsidy Model Report (Produced in Step 4)
 

Campus	Case	Enrollment (Rows)	SCH
CLEV	Subject, Adjusted Level Match Table	40,383	148,413.0
CLEV	Subject, Original Level Match Table	0	0.0
CLEV	No Mapping File Table Match	0	0.0
CLEV	Excluded Enrollments	384	1,505.0
	Total	40,767	149,918.0

Total Enrollments by Adjusted Subsidy Model for Exempted Courses Report (Produced in Step 5)
 

Campus	Year	Term	Course	Course Level	Altered Model	Reason	SCH
CLEV	1998	WI	ACT221	B	Bac 3	This is a test from Bac 1 to Bac 3 -- CLEV, 1998	620.0
Inst Total							620.0

Total Enrollments by Student Eligibility Code (Produced in Step 6)
 

Campus	Status	Eligibility (Rows)	SCH
CLEV	Eligible	39,258	144,220.0
CLEV	Account not cleared	0	0.0
CLEV	Non-resident	1125	4,193.0
CLEV	Other ineligible	0	0.0
CLEV	Graduate student with excess hours	0	0.0
CLEV	Selective services non-compliance	0	0.0
CLEV	Excluded Enrollments	384	1,505.0
	Total	40,767	149,918.0

Total Enrollments by Model and Student Eligibility Report (Produced in Step 8)
 

Campus	Model	Eligible Enrollment (Rows)	Eligible SCH	Ineligible Enrollment (Rows)	Ineligible SCH
CLEV	Bac 1 *	9,468	35,855.0	320	1,209.0
CLEV	Bac 2 *	4,806	19,416.0	172	675.0
CLEV	Bac 3 *	5,221	19,053.0	256	950.0
CLEV	Doc 1 *	258	907.0	0	0.0
CLEV	Doc 2 *	136	673.0	0	0.0
CLEV	GS 1 *	4,806	17,120.0	148	519.0
CLEV	GS 2 *	5,421	20,601.0	171	669.0
CLEV	GS 3 *	2,006	5,599.0	58	171.0
CLEV	M&P 1 *	4,070	13,675.0	0	0.0
CLEV	M&P 2 *	2,594	9,539.0	0	0.0
CLEV	M&P 3 *	472	1,782.0	0	0.0
CLEV	Med 1 *	0	0.0	0	0.0
CLEV	Med 2 *	0	0.0	0	0.0
CLEV	Tech 1 *	0	0.0	0	0.0
CLEV	Tech 3 *	0	0.0	0	0.0
	Total Included	39,258	144,220.0	1,125	4,193.0

*Drill-down to see ineligible students.

Law Caps Adjustment Report (Produced in Step 9)
This report is for the entire institution, not by campus.
 

Model	Eligibility	SCH	FTE
M&P 1	EL	-45.0	-1.00
M&P 1	INEL	45.0	1.00

Doctoral Caps Report (Produced in Step 10)
 

Model	Eligibility	SCH	Campus
Doc 1	EL	-2.0588	OHUN
Doc 1	INEL	2.0588	OHUN
Doc 2	EL	-2.9412	OHUN
Doc 2	INEL	2.9412	OHUN

Baccalaureate Limit Report (Produced in Step 11)
 

Campus	Term	Model	Eligibility	SCH
SNCL	WI	Bac 1	EL	-1,141.1
SNCL	WI	Bac 1	INEL	-22.6
SNCL	WI	Bac 2	EL	-545.4
SNCL	WI	Bac 2	INEL	-4.7
SNCL	WI	Bac 3	EL	-882.8
SNCL	WI	Bac 3	INEL	-14.4
SNCL	WI	GS 2	EL	2,569.3
SNCL	WI	GS 2	INEL	41.8

Journal Entry Transactions (Produced in Step 15)
 

Date	Model	Reason	SCH	Campus
June 14, 1997	GS 1	Incorrect level on course CIS340	-83.0	OHUN
June 14, 1997	GS 2	Incorrect level on course CIS340	83.0	OHUN
Etc...	Etc...	Etc...	Etc...	OHUN
Total			0.0	OHUN

Final Report Total Enrollments by Model and Source of Enrollments (Produced after Step 18)
 

Campus	Model	Eligible SCH	Ineligible SCH	Eligible FTE	Ineligible FTE
CLEV	Bac 1	80,870.0	2,891.0	1,797.1	64.2
CLEV	Bac 2	48,859.0	1,456.0	1,085.8	32.4
CLEV	Bac 3	42,873.0	2,167.0	952.7	48.2
CLEV	Doc 1	2,730.0	0.0	60.7	0.0
CLEV	Doc 2	2,108.0	58.0	46.8	1.3
CLEV	GS 1	39,342.0	1,203.0	874.3	26.7
CLEV	GS 2	52,178.0	1,833.0	1,159.5	40.7
CLEV	GS 3	16,401.0	579.0	364.5	12.9
CLEV	M&P 1	52,294.0	44.0	1,303.5	1.0
CLEV	M&P 2	24,505.0	8.0	544.6	0.2
CLEV	M&P 3	4,215.0	12.0	93.7	0.3
Inst Total		366,375.0	10,251.0	8,283.0	227.8

Drill Down Detail Reports

The following detailed lists are the same as the above list: Cross Registration Host, Medical Over 13 Terms, Medical Over 4 Terms Repeater, Non-Ohio XR, SN Missing, Medical Course Enrollments, No Host CI, Foreign XR, Non-public Ohio XR, Non-Ohio XR, Excluded Rank vs Level, Excluded Off campus.

Detailed list of Ineligible Courses (Produced in Step 2)
Excluding Enrollments Report for Exclusion Reason: Ineligible Courses
 

# Rows	Campus	Year	Term	Course	SCH	Subject
8	SNCL	1998	WI	EBE 276	24.0	309999
9	SNCL	1998	WI	EBE 270	30.0	280301
18	SNCL	1998	WI	EBE 275	60.0	309999
27	SNCL	1998	WI	DEV 101	108.0	320199
62	Totals				222.0

Summary List of Off campus Level Adjustments (Produced in Step 3)
Alter Subsidy Level Report for Altered Reason: Off-Campus
 

Campus	Year	Term	Course	Original Level	Adjusted Level	Enrollments (Rows)	SCH
SNCL	1998	WI	ART 236	B	G	1	3.0
SNCL	1998	WI	PHI 297	B	G	1	3.0
SNCL	1998	WI	SOC 225	B	G	1	3.0
SNCL	1998	WI	ENG 256	B	G	8	24.0
Totals						11	33.0

Summary List of Rank vs Level Adjustments (Produced in Step 3)
Alter Subsidy Level Report for Altered Reason: Rank vs Level
 

Campus	Year	Term	Original Level	Adjusted Level	Enrollments (Rows)	SCH
CLEV	1998	WI	M	B	77	270.0
CLEV	1998	WI	D	M	144	561.0
Totals					221	831.0

Detailed List of Rank vs Level Adjustments (Produced in Step 3)
 

Row	Campus	Year	Term	Course	Student ID	Original Level	Adjusted Level	Rank	SCH
1	WSUN	1998	WI	EDL874	xxx-xx-xxxx	D	M	MS	3.0
2	WSUN	1998	WI	EDL874	xxx-xx-xxxx	D	M	MS	3.0
	Totals								6.0

Detailed List of Subject, Original Level match table (Produced in Step 4)
Map to Subsidy Model: Subject, Original Level Match Table
 

Row

Campus

Year

Term

Course

Section

Student ID

SCH

Subject

Original Level

Adjusted Level

Rank

Elig Status

Model

1

CINC

1998

WI

15000199

001

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

2

CINC

1998

WI

15000199

001

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

3

CINC

1998

WI

15000199

001

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

4

CINC

1998

WI

15000199

002

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

5

CINC

1998

WI

15000199

003

xxx-xx-xxxx

0.0

220101

P

B

JR

IR

Bac 1

6

CINC

1998

WI

15000199

003

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

7

CINC

1998

WI

15000199

003

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

8

CINC

1998

WI

15000199

003

xxx-xx-xxxx

0.0

220101

P

B

SR

EL

Bac 1

9

CINC

1998

WI

15001592

001

xxx-xx-xxxx

3.0

220104

M

B

SR

EL

Bac 2

Totals

3.0

Detailed List of no mapping match (List is same as above, except the Subsidy model is missing.)

Detailed List of Adjusted Subsidy Model (Produced in Step 5)
 

Year	Term	Campus	Course	Mapped Model	Adjusted Model	Enrollments	SCH
1998	WI	OHUN	CIS 567	Bac 1	Bac 3	48	300.0
1998	WI	OHUN	Total			48	300.0

Detailed List of Ineligible Student Enrollments (Produced in Step 6)
 

Year	Term	Campus	Student ID	Eligibility Code	Model	Course Enrollments	SCH
1998	WI	OHUN	xxx-xx-xxxx	IR	GS 1	4	13.0
1998	WI	OHUN	xxx-xx-xxxx	IR	GS 1	3	15.0
1998	WI	OHUN	xxx-xx-xxxx	IR	GS 1	5	12.0
1998	WI	OHUN	Etc...	Etc...	Etc...	Etc...	Etc...
1998	WI	OHUN	Total			98	346.0

Doctoral Cap Details (Produced in Step 10)
This report is for the entire institution, not by campus.
 

Step	Doc 1 SCH	Doc 2 SCH	Doc 1 Equiv SCH	Cap	Excess
Exemptions	15	20	45	NA	NA
Institution Eligible SCH	250	400	850	800	5

Campus Proration (Produced in Step 10)
 

Campus	Doc 1 SCH	Doc 2 SCH	Doc 1 Equiv SCH	Campus Proration
OHUN	250	400	850	5

Doc 1 & Doc 2 Proration (Produced in Step 10)
 

Campus	Doc 1 Proration	Doc 2 Proration
OHUN	1.4706	2.3529

Doctoral Exemptions (Produced in Step 10)
 

Course	Section	Student ID	Exempt Model	Course Model	SCH	Campus
Math 501	003C	xxx-xx-xxxx	Doc 1	Doc 2	15.0	OHUN
Math 101	001	xxx-xx-xxxx	Doc 1	GS 2	0.0	OHUN
CIS 567H	0005	xxx-xx-xxxx	Doc 2	Doc 2	10.0	OHUN
CIS 567H	0005	xxx-xx-xxxx	Doc 2	Doc 2	10.0	OHUN
Total					35.0	OHUN

Baccalaureate Limit Details (Produced in Step 11)
 

Eligible SCH
GS 1	GS 2	GS 3	Tech 1	Tech 3	Bac 1	Bac 2	Bac 3	Total
26884.0	34140.0	6839.0	24738.0	24571.5	4586.0	2192.0	3548.0	127498.5
Ineligible SCH
GS 1	GS 2	GS 3	Tech 1	Tech 3	Bac 1	Bac 2	Bac 3	Total
341.0	539.0	97.0	297.0	293.0	91.0	19.0	58.0	1735.0
RCC SCH				Eligible	Bac 1	Bac 2	Bac 3	Total
					0.0	0.0	0.0	0.0
				Ineligible	Bac 1	Bac 2	Bac 3	Total
					0.0	0.0	0.0	0.0

Eligible + Ineligible Undergraduate SCH minus RCC

129,233.5

Total Tech SCH	49,899.5
Total Tech SCH * 1.8	89,819.1

Non technical SCH = (Eligible + Ineligible Undergraduate SCH minus RCC) - (1.8 * Tech SCH)

39,414.4

Baccalaureate Limit = Non technical SCH * 0.2	7,882.9
Baccalaureate Level SCH minus RCC	10,494.0
Excess = Baccalaureate level SCH - Baccalaureate Limit	2,611.1

Bac Models - RCC	Bac 1 = 4,677.0	Bac 2 = 2,211.0	Bac 3 = 3,606.0	Total = 10,494.0
Prorate Excess to Baccalaureate Models = Excess * [Bac n / (Bac 1 + Bac 2 + Bac 3)]	Bac 1 = 1,163.7	Bac 2 = 550.1	Bac 3 = 897.2	Total = 2,611.1
Bac Models - RCC	Bac 1	Bac 2	Bac 3	Total
Eligible	4,586.0	2,192.0	3,548.0	10,326.0
Ineligible	91.0	19.0	58.0	168.0
Prorate Excess to Eligible and Ineligible	Bac 1	Bac 2	Bac 3	Total
Eligible	1,141.1	545.4	882.8	2,569.3
Ineligible	22.6	4.7	14.4	41.8
Total	1,163.7	550.1	897.2	2,611.1

Baccalaureate Limit RCC Details (Produced in Step 11)
 

Course	Section	Requested / Accepted	Enrollments	Eligible SCH	Ineligible SCH
Math	504	Requested	15	39	6
Math	505	Accepted	15	39	6

Summary of FTE by Model, Campus, Year, Term and Source of Data (Produced in Step 18)
 

Campus	Year	Term	Source	Model	Eligibility	Term Type	SCH	FTE
CLEV	1998	AU	U Camp	Bac 1	EL	Q	32,747.0	727.7
CLEV	1998	AU	U Camp	Bac 1	INEL	Q	1,113.0	24.7
CLEV	1998	AU	U Camp	Bac 2	EL	Q	21,012.0	466.9
CLEV	1998	AU	U Camp	Bac 2	INEL	Q	609.0	13.5
CLEV	1998	AU	U Camp	Bac 3	EL	Q	17,121.0	380.5
CLEV	1998	AU	U Camp	Bac 3	INEL	Q	876.0	19.5
CLEV	1998	AU	U Camp	Doc 1	EL	Q	1,210.0	26.9
CLEV	1998	AU	U Camp	Doc 2	EL	Q	832.0	18.5
CLEV	1998	AU	U Camp	Doc 2	INEL	Q	37.0	0.8
CLEV	1998	AU	U Camp	GS 1	EL	Q	17,682.0	392.9
CLEV	1998	AU	U Camp	GS 1	INEL	Q	526.0	11.7
CLEV	1998	AU	U Camp	GS 2	EL	Q	26,595.0	591.0
CLEV	1998	AU	U Camp	GS 2	INEL	Q	888.0	19.7
CLEV	1998	AU	U Camp	GS 3	EL	Q	8,334.0	185.2
CLEV	1998	AU	U Camp	GS 3	INEL	Q	296.0	6.6
CLEV	1998	AU	U Camp	M&P 1	EL	Q	13,737.0	305.3
CLEV	1998	AU	U Camp	M&P 1	INEL	Q	28.0	0.6
CLEV	1998	AU	U Camp	M&P 2	EL	Q	10,482.0	232.9
CLEV	1998	AU	U Camp	M&P 2	INEL	Q	4.0	0.1
CLEV	1998	AU	U Camp	M&P 3	EL	Q	1,759.0	39.1
CLEV	1998	AU	U Camp	M&P 3	INEL	Q	12.0	0.3
CLEV	1998	AU	U LA	M&P 1	EL	S	11,647.0	388.2
CLEV	1998	AU	U Off	Bac 1	EL	Q	300.0	6.7
CLEV	1998	AU	U Off	Bac 1	INEL	Q	4.0	0.1
CLEV	1998	AU	U Off	Bac 2	EL	Q	108.0	2.4
CLEV	1998	AU	U Off	M&P 1	EL	Q	183.0	4.1
CLEV	1998	AU	U Off	M&P 2	EL	Q	36.0	0.8
CLEV	1998	AU	U Off	M&P 3	EL	Q	80.0	1.8
CLEV	1998	AU	UE	Bac 2	EL	Q	315.0	7.0
CLEV	1998	AU	UE	GS 2	EL	Q	90.0	2.0
CLEV	1998	FA	UF Camp	Bac 1	EL	Q	103.0	2.3
CLEV	1998	FA	UF Camp	M&P 1	EL	Q	510.0	11.3
CLEV	1998	FA	UF Camp	M&P 2	EL	Q	66.0	1.5
CLEV	1998	SM	U Camp	Bac 1	EL	Q	12,258.0	272.4
CLEV	1998	SM	U Camp	Bac 1	INEL	Q	589.0	13.1
CLEV	1998	SM	U Camp	Bac 2	EL	Q	7,836.0	174.1
CLEV	1998	SM	U Camp	Bac 2	INEL	Q	172.0	3.8
CLEV	1998	SM	U Camp	Bac 3	EL	Q	6,045.0	134.3
CLEV	1998	SM	U Camp	Bac 3	INEL	Q	317.0	7.0
CLEV	1998	SM	U Camp	Doc 1	EL	Q	573.0	12.7
CLEV	1998	SM	U Camp	Doc 2	EL	Q	603.0	13.4
CLEV	1998	SM	U Camp	Doc 2	INEL	Q	21.0	0.5
CLEV	1998	SM	U Camp	GS 1	EL	Q	4,540.0	100.9
CLEV	1998	SM	U Camp	GS 1	INEL	Q	158.0	3.5
CLEV	1998	SM	U Camp	GS 2	EL	Q	4,892.0	108.7
CLEV	1998	SM	U Camp	GS 2	INEL	Q	276.0	6.1
CLEV	1998	SM	U Camp	GS 3	EL	Q	2,468.0	54.8
CLEV	1998	SM	U Camp	GS 3	INEL	Q	112.0	2.5
CLEV	1998	SM	U Camp	M&P 1	EL	Q	8,607.0	191.3
CLEV	1998	SM	U Camp	M&P 1	INEL	Q	16.0	0.4
CLEV	1998	SM	U Camp	M&P 2	EL	Q	4,040.0	89.8
CLEV	1998	SM	U Camp	M&P 2	INEL	Q	4.0	0.1
CLEV	1998	SM	U Camp	M&P 3	EL	Q	566.0	12.6
CLEV	1998	SM	U Camp	M&P 3	INEL	Q	0.0	0.0
CLEV	1998	SM	U LA	M&P 1	EL	S	1,077.0	35.9
CLEV	1998	SM	U Off	Bac 1	EL	Q	56.0	1.2
CLEV	1998	SM	U Off	Bac 1	INEL	Q	0.0	0.0
CLEV	1998	SM	U Off	Bac 2	EL	Q	12.0	0.3
CLEV	1998	SM	U Off	M&P 1	EL	Q	112.0	2.5
CLEV	1998	SM	U Off	M&P 2	EL	Q	0.0	0.0
CLEV	1998	SM	U Off	M&P 3	EL	Q	28.0	0.6
CLEV	1998	SU	UF Camp	Bac 1	EL	Q	117.0	2.6
CLEV	1998	SU	UF Camp	Bac 2	EL	Q	160.0	3.6
CLEV	1998	SU	UF Camp	Bac 3	EL	Q	58.0	1.3
CLEV	1998	SU	UF Camp	Doc 1	EL	Q	40.0	0.9
CLEV	1998	SU	UF Camp	M&P 1	EL	Q	2,746.0	61.0
CLEV	1998	SU	UF Camp	M&P 2	EL	Q	342.0	7.6
CLEV	1998	WI	CN	Bac 1	EL	Q	35,259.0	783.5
CLEV	1998	WI	CN	Bac 1	INEL	Q	1,185.0	26.3
CLEV	1998	WI	CN	Bac 2	EL	Q	19,308.0	429.1
CLEV	1998	WI	CN	Bac 2	INEL	Q	675.0	15.0
CLEV	1998	WI	CN	Bac 3	EL	Q	19,649.0	436.6
CLEV	1998	WI	CN	Bac 3	INEL	Q	974.0	21.6
CLEV	1998	WI	CN	Doc 1	EL	Q	907.0	20.2
CLEV	1998	WI	CN	Doc 2	EL	Q	673.0	15.0
CLEV	1998	WI	CN	GS 1	EL	Q	17,108.0	380.2
CLEV	1998	WI	CN	GS 1	INEL	Q	519.0	11.5
CLEV	1998	WI	CN	GS 2	EL	Q	20,594.0	457.6
CLEV	1998	WI	CN	GS 2	INEL	Q	669.0	14.9
CLEV	1998	WI	CN	GS 3	EL	Q	5,599.0	124.4
CLEV	1998	WI	CN	GS 3	INEL	Q	171.0	3.8
CLEV	1998	WI	CN	M&P 1	EL	Q	13,675.0	303.9
CLEV	1998	WI	CN	M&P 2	EL	Q	9,539.0	212.0
CLEV	1998	WI	CN	M&P 3	EL	Q	1,782.0	39.6
CLEV	1998	WI	JE	Bac 1	EL	Q	30.0	0.7
CLEV	1998	WI	XR	Bac 2	EL	Q	108.0	2.4
CLEV	1998	WI	XR	GS 1	EL	Q	12.0	0.3
CLEV	1998	WI	XR	GS 2	EL	Q	7.0	0.2
Inst Total							376,626.0	8,510.8

Query of Detail Enrollment Table

For each selected enrollment, the entire set of attributes used in the Subsidy FTE process is returned. They are listed below in the Description of Output Attributes.

Select Parameters

Year
Term
Campus
Type (Source of Data)
Course ID
Section ID (use Like operator)
Student ID (use Like operator)
Attempt Academic Credit Code
Subject (use Like operator)
Level (Course Level, not Adjusted Level)
Course Subsidy Eligibility
Student Rank, Major Field of Study and Subsidy Eligibility
Off campus and RCC Course Sections
Enrollment Type (CN, XR, or ME)
Host IPEDS Code (use Like operator)
Exclude Type and Level Adjustment Level Group
Adjusted Level
Subsidy Model Used

Output

Show all attributes of each detail row selected, no sorting or summarization. The idea is that the requester will download the output to a desk top tool for further analysis.

Description of the Output Attributes

1. From the Course Enrollment (CN) file: Institution, Campus, Year, Term, Course ID, Section, SSN, FTE (not SCH) to six decimal places, attempt for academic credit.
2. From the Course Inventory (CI) file: Subject, Level, Subsidy Eligibility.
3. From the Student Enrollment (SN) file: Rank, Student Eligibility, Major Field of Study.
4. From the Course Section Schedule (CS) file: Location (on or off), RCC (no, yes, or define signifying that the section is RCC and meets the 60 percent rule)
5. Type or Source of Data: (CN or XR)
6. For XR: Host IPEDS Code and Host Institution (for Ohio Public Institutions)
7. Exclude Type: Signifies whether the enrollment is included or excluded and if excluded for what reason.
8. Level Adjustment Type: Signifies whether the level has been adjusted and if so for what reason.
9. Adjusted Level: The Level after any adjustment.
10. Subsidy Model 4a: The model related to the Subject Code and Adjusted Level.
11. Subsidy Model 4b: The model derived when the Subject Code and Adjusted Level are an invalid combination.
12. Subsidy Model 5a: The model reflecting a course exception to the subject, level to model mapping.
 

Medical Class Cohort Limit Table

• Institution Code,
• Class or Cohort Year,
• Cohort Limit Headcount.

Medical Base Enrollment Table

 Course Subsidy Exceptions Table

• Institution Code,
• Year,
• Term,
• Course,
• Subsidy Model.

Doctoral Cap Exemptions Table

• Institution Code,
• Year,
• Term,
• OBRID (Student Identifier),
• Subject Code of Program.

Doctoral Review Program Table

• Institution Code,
• Year,
• Term,
• Subject Code,
• Subsidy Model.

Doctoral Caps Table

Subsidy Journal Entry Table

• Campus Code,
• Year of the Adjustment,
• Term of the Adjustment,
• Subsidy Model to be Adjusted,
• SCH Adjustment Amount (positive or negative),
• Reason for the Adjustment.

UIS 1997 Enrollments Table

This table contains the enrollment data carried over from the UIS for Summer and Fall terms of 1997. Key attributes are:

• Campus Code,
• Year,
• Term,
• Institution,
• Source of Data, as follows:

U Camp -- UIS converted enrollments (Summer and Fall 1997 only)
U LA -- UIS converted enrollments for Law (Summer and Fall 1997 only)
U Off -- UIS converted enrollments for Off campus (Summer and Fall 1997 only)
U RCC -- UIS converted enrollments for RCC (Summer and Fall 1997 only)
UF Camp -- UIS converted enrollments (Summer and Fall 1997 only)
UF Off -- UIS converted enrollments for Off campus (Summer and Fall 1997 only)
UE -- UIS Foreign Exchange memos (Summer and Fall 1997 only)
 
• Subsidy Model,
• Eligibility (EL or INEL),
• Calendar Type (Q or S).

• SCH (number 999999v9),

FTE (number 999999v999.

http://regents.ohio.gov/hei/subsidy/subsidyFTEprocess.html
Last updated June 5, 2003