Skip to content

ACT Tests

Key Information

Collection Template

Position Column Name Required Format Description
0 Data Type True Text ACT Tests
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 Test Date True Date
10 English Score True Integer (Small)
11 Math Score True Integer (Small)
12 Reading Score True Integer (Small)
13 Science Score True Integer (Small)
14 Composite Score True Integer (Small)
15 Review Status ID False Mapped ID Accepted Values:
  • 0
  • 1
  • -1
  • 2
  • -2
  • EXCLUDED: PENDING DC PCSB STAFF REVIEW
  • EXCLUDED: RESULT DOES NOT MEET BENCHMARK
  • EXCLUDED: SUPPORTING DOCUMENTATION DOES NOT MATCH RESULTS
  • EXCLUDED: SUPPORTING DOCUMENTATION REQUIRED
  • INCLUDED: RESULTS PROVIDED BY PUBLISHER
  • INCLUDED: VERIFIED BY DC PCSB STAFF

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