student:ap_test_scores_import
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
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 (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 contained in the import file 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:
- Admin Year (column 59 for the first set of scores, 65 for the second set of scores, etc., up to 30 sets)
- Exam Code (column 60 for the first set of scores, 66 for the second set of scores, etc., up to 30 sets)
- Exam Score (column 61 for the first set of scores, 67 for the second set of scores, etc., up to 30 sets)
- Irregularity Code 1 (column 62 for the first set of scores, 68 for the second set of scores, etc., up to 30 sets)
- Irregularity Code 2 (column 63 for the first set of scores, 69 for the second set of scores, etc., up to 30 sets)
- Class Section Code (column 64 for the first set of scores, 70 for the second set of scores, etc., up to 30 sets)
student/ap_test_scores_import.1510604046.txt.gz · Last modified: 2017/11/13 15:14 (external edit)