Advanced Placement Tests

Key Information

• Users Can Submit Data During Submission Window Only
• Users Can Create, Can Update Rows

---

Collection Template

Position	Column Name	Required	Format	Description
0	Data Type	True	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 3-D ART AND DESIGN AP ART HISTORY AP BIOLOGY AP CALCULUS AB AP CALCULUS BC AP CALCULUS BC: AB SUBSCORE AP CAPSTONE RESEARCH 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 MODERN WORLD HISTORY AP PHYSICS 1: ALGEBRA-BASED AP PHYSICS 2 AP PSYCHOLOGY AP SEMINAR AP SPANISH LANGUAGE AND CULTURE AP SPANISH LITERATURE AP SPANISH LITERATURE AND CULTURE AP STATISTICS AP STUDIO ART: 2-D DESIGN PORTFOLIO AP UNITED STATES GOVERNMENT AND POLITICS AP USA GOVERNMENT AND POLITICS 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 HISTORY WORLD HISTORY
11	Score	True	Integer (Small)	1 to 5
12	Accountability 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.

• Not-Null Constraint

• Submission Constraint (During Window Only)