Skip to content

State Assessment Achievement

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type True Text PARCC
1 Assessment ID True Mapped ID Accepted Values:
  • DC CAPE
  • PARCC
2 LEA ID True Integer (Small)
3 LEA False Text
4 Campus ID True Integer (Small)
5 Campus False Text
6 School Year True Text YYYY-YYYY
7 USI True Integer (Big)
8 First Name False Text
9 Last Name False Text
10 Subject True Mapped ID Accepted Values:
  • ELA
  • ENGLISH LANGUAGE ARTS
  • MATH
11 Assessment Grade False Text
12 FAY True Mapped Text Accepted Values:
  • CAMPUS
  • CHARTER
  • LEA
  • NONE
  • STATE
13 Raw Score False Integer (Small)
14 Scale Score False Integer (Small)
15 Performance Level False Integer (Small)
16 Test Code False Mapped Text Accepted Values:
  • ALG01
  • ALG02
  • ELA03
  • ELA04
  • ELA05
  • ELA06
  • ELA07
  • ELA08
  • ELA09
  • ELA10
  • GEO01
  • MAT03
  • MAT04
  • MAT05
  • MAT06
  • MAT07
  • MAT08
  • MAT2I
17 PMF Framework True Mapped ID Accepted Values:
  • ACCOUNTABILITY PLAN
  • ADULT
  • ALTERNATIVE ACCOUNTABILITY
  • ALTERNATIVE ACCOUNTABILITY (HIGH SCHOOL)
  • ALTERNATIVE ACCOUNTABILITY (PK-8)
  • EARLY CHILDHOOD
  • ELEMENTARY AND MIDDLE SCHOOL
  • ELEMENTARY SCHOOL
  • HIGH SCHOOL
  • MIDDLE SCHOOL
  • NONE
  • PK-8
  • PK ONLY
18 Accountability Universe ID True Mapped ID This field denotes if a record is included in a school’s Accountability Measure or Charter Goals metric calculations.

Accepted Values:
  • -50
  • EXCLUDED: ALTERNATIVE ACCOUNTABILITY CAMPUS
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN CURRENT YEAR
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN PRIOR YEAR
  • EXCLUDED: DID NOT MEET MINIMUM ENROLLMENT REQUIREMENTS
  • EXCLUDED: ENROLLED LESS THAN 30 DAYS AFTER 10TH DAY OF SCHOOL
  • EXCLUDED: INELIGIBILITY REASON NOT AVAILABLE
  • EXCLUDED: INVALID SCORE IN CURRENT YEAR
  • EXCLUDED: INVALID SCORE IN PRIOR YEAR
  • EXCLUDED: NO SCHOOL/LEA FAY IN CURRENT YEAR
  • EXCLUDED: NO SCORE OR MINIMUM ENROLLMENT IN PRIOR YEAR
  • EXCLUDED: NOT EL IN CURRENT YEAR
  • EXCLUDED: NOT EL IN PRIOR YEAR
  • EXCLUDED: NOT IN ACCOUNTABILITY UNIVERSE
  • EXCLUDED: NOT IN ACHIEVEMENT UNIVERSE IN PRIOR YEAR
  • EXCLUDED: NOT IN TESTING GRADE IN PRIOR YEAR
  • EXCLUDED: ONLY IN PMF UNIVERSE
  • EXCLUDED: ONLY IN STAR UNIVERSE
  • EXCLUDED: PREVIOUSLY PROFICIENT
  • EXCLUDED: PROFICIENT IN FIRST YEAR OF TESTING
  • EXCLUDED: SCHOOL-SPECIFIC EXCEPTION
  • EXCLUDED: STUDENT DECEASED
  • EXCLUDED: STUDENT DID NOT ATTEND FULL ACADEMIC YEAR AT CAMPUS
  • EXCLUDED: STUDENT EXPELLED FOR FEDERALLY RECOGNIZED REASON
  • EXCLUDED: STUDENT IN NON-PUBLIC PLACEMENT
  • EXCLUDED: STUDENT RECEIVED CREDENTIAL IN PREVIOUS YEAR
  • EXCLUDED: STUDENT TRANSFERRED TO ANOTHER CAMPUS IN SAME LEA
  • EXCLUDED: TERMINAL GRADE (NOT RETAINED)
  • EXCLUDED: TESTED AT A DIFFERENT SCHOOL IN CURRENT YEAR
  • EXCLUDED: UNKNOWN REASON
  • EXCLUDED: VALID EXIT
  • EXCLUDED: WAS NOT CONTINUOUSLY ENROLLED DURING TESTING WINDOW
  • INCLUDED
  • INCLUDED: ELEMENTARY GRADES
  • INCLUDED: ENROLLED AT ANOTHER CHARTER
  • INCLUDED: ENROLLED AT DCPS
  • INCLUDED: MIDDLE GRADES
  • INCLUDED: NOT IN SECTOR REPORTING UNIVERSE
19 STAR Framework True Mapped ID Accepted Values:
  • ALTERNATIVE FRAMEWORK
  • ELEMENTARY SCHOOL WITHOUT PRE-KINDERGARTEN
  • ELEMENTARY SCHOOL WITH PRE-KINDERGARTEN
  • HIGH SCHOOL
  • MIDDLE SCHOOL
  • NONE
20 STAR Universe False Mapped ID Accepted Values:
  • EXCLUDED: ALTERNATIVE ACCOUNTABILITY CAMPUS
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN CURRENT YEAR
  • EXCLUDED: ALTERNATIVE ASSESSMENT IN PRIOR YEAR
  • EXCLUDED: DID NOT MEET MINIMUM ENROLLMENT REQUIREMENTS
  • EXCLUDED: ENROLLED LESS THAN 30 DAYS AFTER 10TH DAY OF SCHOOL
  • EXCLUDED: INELIGIBILITY REASON NOT AVAILABLE
  • EXCLUDED: INVALID SCORE IN CURRENT YEAR
  • EXCLUDED: INVALID SCORE IN PRIOR YEAR
  • EXCLUDED: NO SCHOOL/LEA FAY IN CURRENT YEAR
  • EXCLUDED: NO SCORE OR MINIMUM ENROLLMENT IN PRIOR YEAR
  • EXCLUDED: NOT EL IN CURRENT YEAR
  • EXCLUDED: NOT EL IN PRIOR YEAR
  • EXCLUDED: NOT IN ACCOUNTABILITY UNIVERSE
  • EXCLUDED: NOT IN ACHIEVEMENT UNIVERSE IN PRIOR YEAR
  • EXCLUDED: NOT IN TESTING GRADE IN PRIOR YEAR
  • EXCLUDED: ONLY IN PMF UNIVERSE
  • EXCLUDED: ONLY IN STAR UNIVERSE
  • EXCLUDED: PREVIOUSLY PROFICIENT
  • EXCLUDED: PROFICIENT IN FIRST YEAR OF TESTING
  • EXCLUDED: SCHOOL-SPECIFIC EXCEPTION
  • EXCLUDED: STUDENT DECEASED
  • EXCLUDED: STUDENT DID NOT ATTEND FULL ACADEMIC YEAR AT CAMPUS
  • EXCLUDED: STUDENT EXPELLED FOR FEDERALLY RECOGNIZED REASON
  • EXCLUDED: STUDENT IN NON-PUBLIC PLACEMENT
  • EXCLUDED: STUDENT RECEIVED CREDENTIAL IN PREVIOUS YEAR
  • EXCLUDED: STUDENT TRANSFERRED TO ANOTHER CAMPUS IN SAME LEA
  • EXCLUDED: TERMINAL GRADE (NOT RETAINED)
  • EXCLUDED: TESTED AT A DIFFERENT SCHOOL IN CURRENT YEAR
  • EXCLUDED: UNKNOWN REASON
  • EXCLUDED: VALID EXIT
  • EXCLUDED: WAS NOT CONTINUOUSLY ENROLLED DURING TESTING WINDOW
  • INCLUDED
  • INCLUDED: ELEMENTARY GRADES
  • INCLUDED: ENROLLED AT ANOTHER CHARTER
  • INCLUDED: ENROLLED AT DCPS
  • INCLUDED: MIDDLE GRADES

Shading Key

Primary Key Column Column(s) which uniquely define the row, and is required in all submissions
Expected Column Column which is expected in a complete submission; in case where the data are missing and the column is not required, these columns may be left blank
Non-Loaded Column Column which is not loaded; these columns are provided to support use of the table, but can be left blank in submissions

Common Errors

Click on the error type to get more information.

  • No common errors