This is an old revision of the document!
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 (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: