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. 

June 6, 2018: Updated Assessments Codes to add Accuplacer Next Generation. Removed Compass assessments as options.

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 or campus owned or leased space that is not a secondary school
  • OL = Online
  • CI = Not on college campus (including leased space) taught by college (post-secondary) instructor
  • HI = Not on college campus (including leased space) taught by 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://oeds.ode.state.oh.us/SearchOrg 

 

Alphanumeric 6 characters

 

Required

Key 3 CCP Delivery Type

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

  • OC = On college campus or campus owned or leased space that is not a secondary school
  • OL = Online
  • CI = Not on college campus (including leased space) taught by college (post-secondary) instructor
  • HI = Not on college campus (including leased space) 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
ACCTRIG Accuplacer Trigonometry  Math
ACCWRIT Accuplacer - Writing skills Writing
ACUNGA Accuplacer Next Gen Arithmetic Math
ACUNGAF Accuplacer Next Gen Advanced Algebra and Functions Math
ACUNGQ Accuplacer Next Gen Quantitative Reasoning, Algebra, and Stats Math
ACUNGR Accuplacer Next Gen Reading Reading
ACUNGW Accuplacer Next Gen Writing. Also use for WritePlacer. Writing
ACTCOM ACT Composite N/A
ACTENG ACT English English
ACTMATH ACT Math Math
ACTREAD ACT Reading Reading
ALEKMATH ALEKS - Math skills Math
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
SATE17 SAT Evidence-Based Reading and Writing Assessment 2017 English
SATENGCR SAT English/Critical Reading test English
SATENGW SAT English/Writing test English
SATM17 New SAT Math Assessment 2017 Math
SATMATH SAT Math test  Math
SATR17 New SAT Reading Assessment 2017 Reading
SATREAD SAT Reading test Reading
SATTOT New SAT Composite Score N/A
SATW17 New SAT Writing and Language Assessment 2017 Writing
SCA Student continuing admission (no new testing required) N/A
WAIVER Please use when reporting a student using a CCP Innovative Program Waiver. 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