 |
|
|
|
Please note: This is a draft document. It
is in development and is subject to change.
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.
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 is not yet 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 medical 5 percent repeater rule. This process is not yet implemented.
Step 13
Apply medical class cohort excess rule. This process is not yet implemented.
Step 14
Apply medical buffering rule. This process is not yet implemented.
Step 15 Enter Journal
Entry transactions.
Step 16 Convert SCH
to FTE.
Step 17
Submit to institutions for further review.
Step 18
Add UIS Enrollments for Summer and Fall 1997 terms (for FY 1998 only this
step is done prior to Step 17).
Add to these all enrollments in the Cross Registration (XR) file. Join with the Institution Campus table based on the Integrated Postsecondary 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.
Add to these the professional medical enrollments from the Medical Enrollment table. 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. Join with the Student Enrollment table to pick up Rank, Major Field of Study (Subject), and Student Subsidy Eligibility.
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.
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.
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.
The SCH for the ineligible students should be separated from the SCH for eligible students.
Step 7.1: Exempted enrollments for Doctoral Caps.
A special total is kept for each institution year and term for purposes
related to Doctoral Enrollment Caps. This is the total of SCH for students
who are recorded in the Doctoral Cap Exemptions
table and have a matching row in the Student
Enrollment table with a rank of doctoral, marked eligible for subsidy,
and a major field of study matching a program in the Doctoral
Review Program table which
also matches the record in the Doctoral Cap Exemptions table. Note, programs
in the Doctoral Review Program table are identified by all subject codes
that can be associated with the program. All doctoral level SCH for these
students are kept in this special total.
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 7.4: Medical repeaters.
Keep a special total of the number of medical students in medicine
(subject code 511201) or osteopathic medicine (subject code 511901) coded
as a repeater in the current term.
Step
7.5: Current medical class cohort.
For all of the medical students in medicine (subject code 511201) or
osteopathic medicine (subject code 511901) which are eligible for subsidy,
join with the Student
Entrance (SE) table for the student, institution, and Professional
(PRO) Admission Area to pick up their Year and Term of First Enrollment.
Keep a count of students by year, term, and institution.
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.
This process does not include the steps involved in determining the caps. These steps will result in an HEI table, called the Doctoral Caps table, with these caps included.
Additionally, enrollments by continuing students who have been "grandfathered" into programs discontinued by the doctoral review are exempted from the doctoral caps. A list of the Student Identifiers of these people will be updated by the Regents enrollment data coordinator each year. These will be stored on the HEI database in the Doctoral Cap Exemptions table. Institution Code, Student Identifier, Term, and Year will be the key attributes and Major Field of Study will be the only other attribute.
Each year, in the process of determining subsidy FTE, HEI will compare the number of doctoral subsidy eligible SCH in terms of "Doc 1 equivalent" for all campuses of an institution against these fixed caps for each institution. The formula is: Doc 1 Equivalent SCH = (student credit hours in the Doc 1 model) + (1.5 x SCH in the Doc 2 model).
Then Doctoral Subsidy SCH = Doc 1 Equivalent SCH - (All doctoral level SCH for students who match the Doctoral Cap Exemptions table from Step 7 above, after they are converted to Doc 1 equivalent).
As stated in Step 7, the means of converting all doctoral level SCH for students in the Doctoral Cap Exemptions table to Doc 1 equivalent is to compare the Doctoral Cap Exemptions table with the Student Enrollment table based on Institution, Year and OBRID. Pick up the Major Field of Study from the Student Enrollment table and match it to the Doctoral Review Program table based on Institution, Year, and Major Field of Study. The Doctoral Review Program table contains Year, Institution, Subject Code, and Subsidy Model as attributes, and has a row in it for each subject code of every discontinued doctoral program. The Subject Code in the matching Doctoral Cap Exemptions table must also be equal to one of the Subject Codes in the Doctoral Review Program table for this Institution and Year. The Subsidy Model in this matching row of the Doctoral Review Program table is used to convert the credit hours for the student to Doc 1 equivalent by multiplying by 1.5 if the Subsidy Model for the program is Doc 2.
Any excess of Doctoral Subsidy SCH more than the SCH recorded in the Doctoral Caps table at the institution level will be prorated to each campus of the institution based on the ratio of Doc 1 Equivalent at the campus to Doc 1 Equivalent at the institution.
Excess amounts for each campus will be further prorated to the Doc 1 and Doc 2 models for that campus based on the following ratio of SCH:
[Doc 1 SCH / (Doc 1 SCH + 1.5 x Doc 2 SCH)] for the Doc 1 model, and
[1.5 x Doc 2 SCH / (Doc 1 SCH + 1.5 x Doc 2 SCH)]/ 1.5 for the Doc 2 model.
These amounts will be subtracted from the eligible model and added to the ineligible model.
These ineligible credit hours will be combined with the ineligible SCH calculated above for students who are identified in their Student Enrollment record as being ineligible for subsidy.
An example of this calculation is given in Doctoral Cap Calculation.
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.
Less than 60 percent of the SCH must be due to SCH of students ranked Freshman (FR), Sophomore (SO), or Not Otherwise Classified Undergraduate (NU). (This check will be executed during the data submission process and prior to loading the data to the database.)
Note: RCC course sections are restricted to branches of universities. The SCH in these courses were summarized to the campus level in Step 7 prior to the data being summarized to the campus level.
Non-technical SCH are defined as the sum of all SCH in all course sections minus 1.8 times the sum of all SCH in all course sections where Level equals T.
To calculate the Baccalaureate Limit, multiply the Non-technical SCH by .2.
If the Limit has been exceeded, the excess should be moved proportionally from the baccalaureate subsidy models to the GS 2 subsidy model. The excess is prorated first between the baccalaureate models and then between eligible and ineligible credits. Prorating between individual baccalaureate models is based on the SCH in these models individually compared to the total in all of the baccalaureate models in the total of eligible and ineligible categories. Prorating between eligible and ineligible is based on the ratio of SCH in these categories for each individual model to the total of eligible plus ineligible in each individual model.
These deductions from Bac models and additions to GS 2 models are added to the summary data from Step 8 with the source Bac L.
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.
The excess is subtracted from eligible Med 2 and put in excluded, not ineligible.
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.
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:
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
These enrollments start in three files, one for regular enrollments, one for FLX enrollments and one for foreign exchange memo enrollments. All three will be merged into a single table called the UIS 1997 Enrollments table before being input to the Subsidy FTE process. Annualized medical enrollments are included in the regular enrollments file from UIS. This step simply adds these rows to the summary table of enrollments by model calculated in prior steps for winter and spring of 1998. This step is only performed for FY 1998. In FY 1998 Baccalaureate Limit will be calculated on a term basis because it has already been accounted for in the UIS Fall 1997 data.
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 |
|
|
|
|
| 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 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
| 8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summary List of Off-campus
Level Adjustments (Produced in Step 3)
Alter Subsidy Level Report for Altered Reason: Off-Campus
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Summary List of Rank
vs Level Adjustments (Produced in Step 3)
Alter Subsidy Level Report for Altered Reason: Rank vs Level
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Detailed List of Rank
vs Level Adjustments (Produced in Step 3)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Detailed
List of Subject, Original Level match table (Produced in Step 4)
Map to Subsidy Model: Subject, Original Level Match Table
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
| 26884.0 |
|
|
|
|
|
|
|
|
| Ineligible SCH | ||||||||
| GS 1 |
|
|
|
|
|
|
|
|
| 341.0 |
|
|
|
|
|
|
|
|
| RCC SCH |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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) |
|
| 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 |
|
|
|
|
| Prorate Excess to Baccalaureate Models = Excess * [Bac n / (Bac 1 + Bac 2 + Bac 3)] |
|
|
|
|
| Bac Models - RCC |
|
|
|
|
| Eligible |
|
|
|
|
| Ineligible |
|
|
|
|
| Prorate Excess to Eligible and Ineligible |
|
|
|
|
| Eligible |
|
|
|
|
| Ineligible |
|
|
|
|
| Total |
|
|
|
|
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)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
This table contains the enrollment data carried over from the UIS for Summer and Fall terms of 1997. Key attributes are:
http://regents.ohio.gov/hei/subsidy/archive/subsidyFTEprocess12111998.html
Last updated December 11, 1998