Advanced Placement Tests
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.