College Credit Plus (CCP) Data

The CCP files below are submitted through the CCP web portal (https://ccp.ohiohighered.org). This is separate from the required reporting for public institutions for HEI. 

CCP Data Reporter Training Presentations:

File format

Files are submitted as .csv files through the CCP web portal (https://ccp.ohiohighered.org) following the formatting for each field laid out in the file specifications below.

Data fields should be submitted separated by commas; quotes or special characters should not be used in the data values for any fields, including text fields. Commas cannot be included in the content of any text field.

Each csv file should have the column names in the first row (“header” row). There will be an example/template of each file available on the web portal for you to download or you can create your own.

If an optional field has no data (for example, subject code), then submit that variable with nothing included between the commas (i.e. ,,). 

For IRN/ACT information, use this crosswalk.

Required File Submission by Post-secondary sector:

File Brief Description and Purpose Public Private Due Date
Student Data File Student level course enrollment, credit hours, and method of deliveries. Used mainly for the payment/reimbursement system. Required after day 14 of each term (or census day)  Required after day 14 of each term (or census day) 2 weeks after census day each term
Alternate Funding File Captures the cost per-credit hour amount when there is an agreement signed with a district. Used for the payment/reimbursement system. Only required if there are alternate funding agreements with districts Only required if there are alternate funding agreements with districts 2 weeks after census day each term
Course Outcomes File Captures the course outcomes for each term. Uses the same six key fields from the Student Data File and course outcome. NOT required. Collected through HEI file submission. Required. 30 days after the end of each term
College Readiness Assessment File Student college readiness assessment scores. Used for program evaluation. Required Required 30 days after the end of each academic year
Demographics File Student demographic and socio-economic status information. Used for program evaluation. NOT required. Collected through HEI file submission. Required 30 days after the end of the academic year
Compliance Questions Survey questions related to program compliance Required Required 30 days after the end of the academic year

CCP Student Data File - Data Fields

Field Names

Field Attributes and Procedures

Data Format

Required / Optional

Key 1 Campus

Enter a campus code from Institution/Campus Codes

Alphabetic 
4 characters 
 

Required

Key 2 SSID or ODE assigned identifier (UIN)

 

Enter the student’s SSID/UIN in this field. This is the unique identifier assigned to Ohio students by the Ohio Department of Education. If the student is home-schooled or attending a non-public school, then enter the nine-digit UIN provided by the ODE when the student was approved for College Credit Plus. The UIN format is CCP123456 (for example)

Alpha characters should be in Uppercase.

Alphanumeric
9 characters
 

Required

Key 3 Course Identifier

Enter the permanent identifier which distinguishes the course from all others offered by the institution. This identifier should resemble those used on transcripts and/or catalogs.

Alpha characters should be in Uppercase.

Alphanumeric 
12 characters 
 

Required

Key 4 Section Identifier

Enter the identifier assigned by the institution which, in a given term, distinguishes among one or more sections, classes, or offerings of the same course. 

Alphanumeric 
6 characters 
 

Required

Key 5 CCP Year

Enter the year as a four digit number (Ex. 2011)

Numeric

4 characters

Required

Key 6 Term

Enter the term as a two-character code (Ex. AU,SP,SM)

Alphanumeric 2 characters

Required

Subject Code

Enter a code from Subject Codes to describe the subject matter of the course. This is also know as the CIP Code.

Numeric 
6 characters 
 

Required

Course Title

Enter a title which clearly relates the course to the current college or university catalog.

Alphanumeric 
25 characters 
 

Required

ACT High School Code

Enter the code assigned to the high school where the student is enrolled. If the high school code is not known enter "XXXXXX” (http://www.actstudent.org/regist/lookuphs/)

Numeric 
6 characters 

Optional

Year of High School Graduation

Enter the four digit year in which the student expects to graduate from high school. If the year of graduation is not known or not required enter UNKN.

Alphanumeric 
4 characters 
 

Required

Credit Hours

Enter the credit hour value of this course enrollment, expressed in hundredths. (Two implied decimals)

Numeric 
4 characters 
 

Required

CCP Credit Hour Type

Enter S for Semester Q for quarter. 

Alphanumeric 1 character

Required

CCP Alternative per credit hour payment structure applies

Enter Y if an alternative per credit hour payment structure is in place; otherwise, enter N.

Alphanumeric 1 character

Required

CCP Delivery Type

Enter the method in which the class is delivered: (choose one)

  • OC = On college campus
  • OL = Online
  • CI = Not on college campus, taught by college (post-secondary) instructor
  • HI = Not on college campus, taught by a qualified instructor who may also be a high school instructor

Alphanumeric 2 characters

Required

CCP Roster Date

For all students with a CCP Delivery Type OC, the roster date is the 15th calendar day of the term.  For all students with an off campus delivery type (OL, CI, HI) the roster date is 15 days after the College Credit Plus course starts.  (MMDDYYYY format)

Alphanumeric 8 characters

Required

CCP Start Date

Enter the first day of the CCP class (MMDDYYYY format)

Alphanumeric 8 characters

Required

CCP End of Class

Enter the last day of the CCP class (MMDDYYYY format)

Alphanumeric 8 characters

Required

CCP District IRN

Enter the IRN number of the school district, community school, STEM school, or non-public school in which the student is enrolled. If the student is home-schooled then enter “999999”. Use the IRN lookup tool to find the IRN:

https://oeds.ode.state.oh.us/SearchOrg 

Alphanumeric 6 characters

 

Required

CCP District Name

Enter the name of the school district, community school, STEM school, or non-public school. Note that a community school’s name may change from one year to the next.

Alphanumeric 60 characters

Required

Delete Switch

Enter Y if the record is to be deleted from the inventory. Otherwise enter N.

Alphabetic 1 character

Required

CCP Alternative Funding File* - Data Fields

Field Names

Field Attributes and Procedures

Data Format

Required / Optional

Key 1 Main Campus

Enter a main campus code from Institution/Campus Codes in uppercase. 

Alphabetic 
4 characters 
 

Required

Key 2 CCP District IRN

Enter the IRN number of the school district, community school, or non-public school in which the student is enrolled.

Use the IRN lookup tool to find the IRN:

https://webapp2.ode.state.oh.us/oeds-r/query/default.asp

 

Alphanumeric 6 characters

 

Required

Key 3 CCP Delivery Type

Enter the method in which the class is delivered: (choose one)

  • OC = On college campus
  • OL = Online
  • CI = Not on college campus taught by college (post-secondary) instructor
  • HI = Not on college campus taught by qualified instructor who may also be a high school instructor

Alphabetic

2 characters

Required

Key 4 CCP Year

Enter the year as a four-digit number (Ex. 2011)

Numeric

4 characters

Required

Key 5 Term

Enter the term as a two-character code (Ex. AU,SP,SM)

Alphanumeric 2 characters

Required

CCP Negotiated Cost

Enter the alternative per credit hour payment amount.  Two implied decimals.

Alphanumeric 5 characters

Required

Delete Switch

Enter Y if the record is to be deleted from the inventory. Otherwise enter N.

Alphabetic 1 character

Required

*This file is required only if there are alternative credit hour agreements with LEAs, otherwise the default credit hour amount for the CCP program will be used for payments. Please refer to the following CCP guidance document (dated October 10).

Course Outcomes Data File

FIELD NAMES

FIELD ATTRIBUTES AND PROCEDURES

DATA FORMAT

REQUIRED / OPTIONAL

Key 1 Campus

Enter a campus code from Institution/Campus Codes in uppercase.

 Alphabetic 
 4 characters 

Required

Key 2 SSID or ODE assigned identifier (UIN)

Enter the student’s SSID/UIN in this field. This is the unique identifier assigned to Ohio students by the Ohio Department of Education. If the student is home-schooled or attending a non-public school, then enter the nine-digit UIN provided by the ODE when the student was approved for College Credit Plus. The UIN format is CCP123456 (for example)

Alpha characters should be capitalized.
Alphanumeric
9 characters
Required

Key 3 Course Identifier

Enter the permanent identifier which distinguishes the course from all others offered by the institution. This identifier should resemble those used on transcripts and/or catalogs.

Alpha characters should be capitalized.

Alphanumeric 
12 characters 

Required

Key 4 Section Identifier Enter the identifier assigned by the institution which, in a given term, distinguishes among one or more sections, classes, or offerings of the same course.  Alphanumeric 
6 characters 
Required
Key 5 CCP Year Enter the year as a four-digit number (Ex. 2011)

Numeric

4 characters
Required
Key 6 Term Enter the term as a two-character code (Ex. AU,SP,WI, SM) Alphanumeric 2 characters Required
Course Outcome

The course outcome is a letter grade that generates GPA points. The total number of the GPA points earned by the student for the course should be reported on a 4.00 scale. Fractions are to be reported as decimals to two places with no decimal point. Use leading zeroes. For example, if a “B” is a 3.00 on the 4.00 scale, a “B” grade in a 5 credit course would be reported as “01500.” Failures are reported as “00000.”

Non-letter grade outcomes. Alphabetic code values:

• Withdrawals – WITHD

• Incompletes – INCOM 

Alphanumeric 
5 characters 

 
Required

College Readiness Assessment Data File

Field Names

Field Attributes and Procedures

Data Format

Required / Optional

Key 1 Campus

Enter a campus code from Institution/Campus Codes in uppercase.

 Alphabetic 
 4 characters 

Required

Key 2 CCP Year

Enter the year as a four-digit number (Ex. 2011)

 Numeric

 4 characters

Required

Key 3 Student’s SSID

Enter the student’s SSID/UIN in this field. This is the unique identifier assigned to Ohio students by the Ohio Department of Education. Alpha characters should be capitalized.

Alphanumeric
 9 characters

Required

Key 4 College Readiness Assessment Code

Send the appropriate code(s) indicating the test used to evaluate college readiness for each subject area in Uppercase.  Separate records should be sent for each College Readiness Assessment code applicable to the student. If no Assessment was completed, select “NC”.  If College Readiness was evaluated using something other than ACT, SAT, Accuplacer, Maplesoft T.A., ALEKS, or PlaceU tests, use the “MMU” - Multiple Measures option.  If College Readiness Assessment has been reported for the student previously, use the “SCA” – Student Continuing Admission option.

Assessment Code Description Subject

ACCALGB

Accuplacer Elementary Algebra

Math

ACCARIT

Accuplacer Arithmetic

Math

ACCMATH

Accuplacer - Math

Math

ACCREAD

Accuplacer - Reading

Reading

ACCSENT

Accuplacer- Sentence skills

Writing

ACCWRIT

Accuplacer - Writing skills

Writing

ACTCOM

ACT Composite

N/A

ACTENG

ACT English

English

ACTMATH

ACT Math

Math

ACTREAD

ACT Reading

Reading

ALEKMATH

ALEKS - Math skills

Math

COMPALG

Compass Algebra

Math

COMPCOL

Compass College Algebra

Math

COMPMATH

Compass Test for Math skills

Math

COMPPRE

Compass Pre-Algebra

Math

COMPREAD

Compass Test for Reading skills

Reading

COMPTRIG

Compass Trigonometry

Math

COMPWRIT

Compass Test for Writing skills

Writing

MAPLMATH

Maplesoft T.A. test for Math skills

Math

MMU

Multiple measures were used to determine college readiness such as GPA review, transcript rev, etc.

N/A

NC

Assessment was not completed.

N/A

PLACMATH

PlaceU test for Math skills

Math

SATCOM

SAT Composite

N/A

SATENGCR

SAT English/Critical Reading test

English

SATENGW

SAT English/Writing test

English

SATMATH

SAT Math test

Math

SATREAD

SAT Reading test

Reading

SATE17

New SAT English Assessment 2017 English
SATM17 New SAT Math Assessment 2017 Math
SATR17 New SAT Reading Assessment 2017 Reading
SATW17 New SAT Writing Assessment 2017 Writing
SATTOT New SAT Composite Score N/A
SCA Student continuing admission (no new testing required) N/A

 Alphabetic

 8 characters

Required

College Readiness Assessment Score

Enter the applicable assessment score for each subject area evaluated on the college readiness assessment.  This field will be left blank for MMU, NC, or SCA options. (Note:  At this time, no validation will be done to see if the score is blank, since some of the measures can be blank.)

  • Score 

 Numeric

 4 characters

Optional

Delete Switch

Enter Y if the record is to be deleted from the database. Otherwise, enter N.

 Alphabetic 
 1 character 

Required

Demographics File Layout (required for Private Institutions Only)

Field Names

Field Attributes and Procedures

Data Format

Required / Optional

Key 1 Campus

Enter a campus code from Institution/Campus Codes in uppercase.

 Alphabetic 
 4 characters 

Required

Key 2 CCP Year

Enter the year as a four-digit number (Ex. 2011)

 Numeric

 4 characters

Required

Key 3 Student’s SSID

Enter the student’s SSID/UIN in this field. This is the unique identifier assigned to Ohio students by the Ohio Department of Education. Alpha characters should be capitalized.

 Alphanumeric
 9 characters

Required

Sex

Enter one of the following:      M - Male  or F – Female in Uppercase

 Alphabetic 
 1 character 

Required

Date of Birth

Enter the student’s date of birth as MMDDYYYY. Enter UNKNOWN if any part of the date of birth is unknown.

 Alphanumeric 
 8 characters 

Required

Hispanic/Latino Ethnicity

Enter uppercase Y if the student is a person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. Otherwise, enter uppercase N

 Alphabetic 
 1 character

Required

American Indian or Alaska Native Race

Enter uppercase Y if the student is a person having origins with any of the original peoples of North and South America (including Central America), and who maintains a tribal affiliation or community attachment. Otherwise, enter uppercase N.

 Alphabetic 
 1 character

Required

Asian Race

Enter uppercase Y if the student is a person having origins with any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent, including Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. Otherwise, enter uppercase N.

 Alphabetic 
 1 character

Required

Black or African American Race

Enter uppercase Y if the student is a person having origins in any of the Black racial groups of Africa. Otherwise, enter uppercase N.

 Alphabetic 
 1 character

Required

Native Hawaiian or Other Pacific Islander Race

Enter uppercase Y if the student is a person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. Otherwise, enter uppercase N.

 Alphabetic 
 1 character

Required

White Race

Enter uppercase Y if the student is a person having origins in any of the original peoples of Europe, the Middle East, or North Africa. Otherwise, enter uppercase N.

 Alphabetic 
 1 character

Required

Unknown Race

Enter uppercase Y if the student’s race and ethnicity is unknown. Otherwise, enter uppercase N.

 Alphabetic 
 1 character

Required

Socio-economic status

Enter uppercase Y if the student is considered economically disadvantaged or uppercase N if Student is not considered economically disadvantaged according to OAC 3333-1-65.6 (2). Enter "U" for Unknown.

 Alphabetic 
 1 character

Required

Disability Status

Enter Uppercase Y if Student is considered an “Individual with a Disability” according to the description listed in 01 from Special Status Codes .  Otherwise, enter Uppercase N. Enter "U" for Unknown.

 Alphabetic
 1 characters

Required

Delete Switch

Enter Y if the record is to be deleted from the database. Otherwise, enter N.

 Alphabetic 
 1 character 

Required