|Column #||Column Name||Optional||Data Type||Comment|
|1||AP Number / AP ID||No||VARCHAR2(8)||Student's AP registration number/ID for this exam administration. This is unique per student per administration year.|
|17||Grade Level||No||VARCHAR2(2)||3 = < 9th Grade
4 = 9th Grade
5 = 10th Grade
6 = 11th Grade
7 = 12th Grade
8 = No longer in high school
11 = Unknown
|26, 28, 30, 32, 34, 36||Award Type [N] (where n represents the number of occurrences (1-6))||Yes||VARCHAR2(2)||01 = AP Scholar
02 = AP Scholar with Honor
03 = AP Scholar with Distinction
04 = State AP Scholar
05 = National AP Scholar
06 = National AP Scholar (Canada)
07 = AP International Diploma
08 = DoDEA AP Scholar
09 = International AP Scholar
12 = National AP Scholar (Bermuda)
13 = AP Capstone Diploma
14 = AP Seminar and Research Certificate
|27, 29, 31, 33, 35, 37||Award Year [N] (where n represents the number of occurrences (1-6))||Yes||VARCHAR2(2)||Format = YY (year in which the student qualified for the award)|
|High School Information|
|48||College Code||Yes||VARCHAR2(6)||Format = 00####. Unique code identifying the college, university, or scholarship program to which the student has requested to send AP scores|
|241||Date of this report||No||VARCHAR2(6)|
Up to 30 sets of AP scores can be imported, with a separate record for each set of AP scores starting at column 59.
The first set of AP Scores are in columns 59-64.
The second set are in columns 65-70, etc.
Each record will contain all of the columns above plus the following:
NOTE: The Last Name, First Name, Middle Initial, Sex, and Date of Birth contained in the import file are used to match to the local student ID for students already in the database and ensure that the record in the import file links to the correct student in the database. The local ID is matched to the imported record.
Prior to 2018, social security number (SSN) was contained in the import file and used to match the ID for students. Files after 7/11/2018 will not have the SSN.