Skip to content

Advanced Placement Tests

Key Information


Collection Template

Position Column Name Required Format Description
0 Data Type False Text Advanced Placement 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 Assessment Grade False Text
10 Course True Mapped ID Accepted Values:
  • AP 2-D ART AND DESIGN
  • AP ART HISTORY
  • AP BIOLOGY
  • AP CALCULUS AB
  • AP CALCULUS BC
  • AP CALCULUS BC: AB SUBSCORE
  • AP CAPSTONE SEMINAR
  • AP CHEMISTRY
  • AP CHINESE LANGUAGE AND CULTURE
  • AP COMPARATIVE GOVERNMENT AND POLITICS
  • AP COMPUTER SCIENCE A
  • AP DRAWING
  • AP ENGLISH LANGUAGE AND COMPOSITION
  • AP ENGLISH LITERATURE AND COMPOSITION
  • AP ENVIRONMENTAL SCIENCE
  • AP FRENCH LANGUAGE
  • AP HUMAN GEOGRAPHY
  • AP LANGUAGE AND COMPOSITION
  • AP LATIN
  • AP MICROECONOMICS
  • AP PHYSICS 1: ALGEBRA-BASED
  • AP PSYCHOLOGY
  • AP SPANISH LANGUAGE AND CULTURE
  • AP SPANISH LITERATURE
  • AP SPANISH LITERATURE AND CULTURE
  • AP STATISTICS
  • AP STUDIO ART: 2-D DESIGN PORTFOLIO
  • AP US GOVERNMENT AND POLITICS
  • AP US HISTORY
  • AP WORLD HISTORY
  • ART HISTORY
  • BIOLOGY
  • CHEMISTRY
  • CHINESE LANGUAGE AND CULTURE
  • COMPUTER SCIENCE PRINCIPLES
  • ENGLISH LANGUAGE AND COMPOSITION
  • ENGLISH LITERATURE AND COMPOSITION
  • ENVIRONMENTAL SCIENCE
  • EUROPEAN HISTORY
  • FRENCH LANGUAGE AND CULTURE
  • HUMAN GEOGRAPHY
  • LATIN
  • MACROECONOMICS
  • MICROECONOMICS
  • PSYCHOLOGY
  • SPANISH LANGUAGE AND CULTURE
  • SPANISH LITERATURE AND CULTURE
  • STATISTICS
  • STUDIO ART: 2-D DESIGN PORTFOLIO
  • STUDIO ART: DRAWING PORTFOLIO
  • UNITED STATES GOVERNMENT AND POLITICS
  • UNITED STATES HISTORY
  • WORLD HISTORY
11 Score True Integer (Small) 1 to 5
12 PMF Numerator False Integer (Small) 0 (Negative Outcome) or 1 (Positive Outcome); a student is considered a positive outcome if their score is greater than or equal to 3.
13 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
Calculated Column Column which is calculated based on other data (provided in submission or otherwise); these columns can 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