Skip to content

PSAT Tests

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type True Text PSAT Tests
1 LEA ID True Integer (Small)
2 LEA False Text
3 Campus ID True Integer (Small)
4 Campus False Text
5 USI True Integer (Big)
6 First Name False Text
7 Last Name False Text
8 Test Date True Date
9 Evidence-Based Reading and Writing Score False Numeric
10 Math Score False Numeric
11 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