/
SC | Assessment Required Fields for College & Career Readiness

SC | Assessment Required Fields for College & Career Readiness

CCR Assessment File Requirements

College & Career Readiness (CCR) Reporting

This page outlines the required data fields for assessment files used in CCR reporting. Each assessment type has specific requirements for both column headers and values.

Key Terms

  • Header: The column name in your file (e.g., StudentID, TestDate)

  • Value must exist: A column must contain data for each student (unless otherwise noted)

  • One of the following: Multiple columns must be present, but at least one must contain a value per row

  • Record excluded: Rows with missing or invalid values will not be used in reporting

  • Required Headers & Values Header must be present and columns must have data populated for each student record

  • Required Headers Must exist in the file, but values may be blank

Assessments Data Requirements

Assessment

Required Headers & Values

Required Headers

Assessment

Required Headers & Values

Required Headers

ACT

  • ID_ACT

  • ID_StateAssign

  • ID_Local

  • Test_Dte

  • HS_GradeLev

  • Composite

Records with blank or unrecognized grade levels are excluded

  • C_Readiness

Advanced Placement (AP)

  • Student Identifier

  • AI Code

  • Grade Level

  • At least one complete set of:

    • Admin Year XX

    • Exam Code XX

    • Exam Grade XX

 

“XX” represents multiple exam entries (e.g., multiple AP tests)

  • Irregularity Code #1 XX

  • Irregularity Code #2 XX

 

 

 

 

 

“XX” represents multiple exam entries (e.g., multiple AP tests)

ASVAB

  • student_unique_id

  • Test Date

  • AFQT (Armed Forces Qualification Test score)

  • Grade

Cambridge

  • STUDENT_STATE_ID

  • SERIES

  • GRADE

  • QUALIFICATION

  • LEVEL_ACHIEVED

    • Records with “-” are excluded

  • SYLLABUS

 

International Baccalaureate (IB)

  • student_unique_id

  • YEAR

  • MONTH

  • CANDIDATE

  • SUBJECT

  • LEVEL

  • GROUP_NUMBER

    • (cannot be blank)

  • LANGUAGE

  • SUBJECT_GRADE

 

SAT / PSAT

At least one of the following must be filled for every student:

  • STATE_STUDENT_ID

  • DISTRICT_STUDENT_ID

  • SECONDARY_ID

  • LATEST_SAT_TOTAL

  • Additionally:

    • LATEST_SAT_DATE

All three ID columns must exist, but only one needs a value per row.

values may be empty

  • LATEST_SAT_GRADE

  • PERCENTILE_NATUSER_SAT_TOTAL

  • PERCENTILE_NATREP_SAT_TOTAL

  • LATEST_SAT_EBRW

  • PERCENTILE_NATREP_SAT_EBRW

  • PERCENTILE_NATUSER_SAT_EBRW

  • EBRW_CCR_BENCHMARK

  • LATEST_SAT_MATH_SECTION

  • PERCENTILE_NATREP_SAT_MATH_SECTION

  • PERCENTILE_NATUSER_SAT_MATH_SECTION

  • MATH_CCR_BENCHMARK

  • LATEST_SAT_ESSAY_READING

  • LATEST_SAT_ESSAY_ANALYSIS

  • LATEST_SAT_ESSAY_WRITING

WIN (WorkKeys / WIN Career Readiness)

At least one of:

  • StudentID

  • StateID

Plus all of the following:

  • SchoolID

  • TestAdmin

  • TestDate

  • CertLevel

  • Mode

  • Acc

  • Retake

  • SoftScore

  • SoftSS

  • SoftStatus

  • SoftSTime

  • SoftFTime

  • MathLev

  • MathSS

  • MathStatus

  • MathSTime

  • MathFTime

  • ReadLev

  • ReadSS

  • ReadStatus

  • ReadSTime

  • ReadFTime

  • UID

Summary Checklist for Assessments

Before submitting files, confirm:

  • All required columns (headers) are present

  • All required fields contain values where needed

  • At least one valid student identifier is populated per record

  • No records contain invalid or excluded values (e.g., missing grade level)

For additional information and resources for assessment loading, you may also visit: https://ed.sc.gov/data/assessment-loading-to-ed-fi/ .

 

If you have any questions or concerns, please submit a support request at support.edanalytics.org