AP Test Scores Import (2017)

Column #	Column Name	Optional	Data Type	Comment
Student Information
1	AP Number	No	VARCHAR2(8)	Student's AP registration number for this exam administration. This is unique per student per administration year.
17	Education 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 106)	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)
Student Information Continued

Interfaces