Skip to content

DC Science

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type True Text DC Science
1 LEA ID True Integer (Small)
2 LEA False Text
3 Campus ID True Integer (Small)
4 Campus False Text
5 School Year True Text YYYY-YYYY
6 USI True Integer (Big)
7 First Name False Text
8 Last Name False Text
9 Subject True Mapped ID Accepted Values:
  • SCI
  • SCIENCE
10 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:
  • EXCLUDED: INCOMPLETE TEST
  • EXCLUDED: INVALIDATED SCORE
  • EXCLUDED: NEW TO US EXEMPTION
  • EXCLUDED: STUDENT DID NOT ATTEND FULL ACADEMIC YEAR AT CAMPUS
  • EXCLUDED: TEST NOT TAKEN
  • INCLUDED
11 FAY True Mapped Text Accepted Values:
  • CAMPUS
  • CHARTER
  • LEA
  • NONE
  • STATE
12 Scale Score False Integer (Small)
13 Performance Level False Integer (Small)
14 Test Code False Mapped Text Accepted Values:
  • BIO01
  • SCI05
  • SCI08

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