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. |
| 2 | Last Name | No | VARCHAR2(15) | The student's surname. |
| 3 | First Name | No | VARCHAR2(12) | The student's given name. |
| 4 | Middle Initial | Yes | VARCHAR2(1) | The student's middle initial. |
| 5 | Student Street Address 1 | Yes | VARCHAR2(30) | First line of the student's street address |
| 6 | Student Street Address 2 | Yes | VARCHAR2(30) | Second line of the student's street address |
| 7 | Student Street Address 3 | Yes | VARCHAR2(30) | Third line of the student's street address |
| 8 | Student State | Yes | VARCHAR2(2) | Domestic Only |
| 9 | Student Zip Code | Yes | VARCHAR2(9) | Domestic Only |
| 10 | Student Province | Yes | VARCHAR2(32) | International Only |
| 11 | Student International Postal Code | Yes | VARCHAR2(10) | International Only |
| 12 | Student Country Code | Yes | VARCHAR2(3) | International Only |
| 13 | Sex | No | VARCHAR2(1) | M = Male, F = Female, U = Unknown |
| 14 | Date of Birth | Yes | VARCHAR2(6) | Format = MMDDYY |
| 15 | Social Security Number | Yes | VARCHAR2(9) | The nine-digit number of identification assigned to the student by the Social Security Administration |
| 16 | School ID | Yes | VARCHAR2(20) | |
| 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 |
| 18 | Filler | Yes | VARCHAR2(3) | |
| 19 | Ethnic Group 2015 and Prior | Yes | VARCHAR2(2) | Code representing the race/ethnicity that the student has self-reported. The following race and ethnicity values are only valid for the 2015 and prior admins: 0 = I do not wish to respond; 1 = American Indian or Alaska Native; 2 = Asian, Asian American, or Pacific Islander; 3 = Black or African American; 4 = Hispanic; 5 = Mexican or Mexican American; 6 = Puerto Rican; 7 = Other Hispanic, Latino, or Latin American; 9 = White; 10 = Other. If viewing a student record for the 2016 exam administration or after, this field will be blank. Refer to fields 243 and 244 for race/ethnicity data. |
| 20 | Student Search Indicator | No | VARCHAR2(1) | Identifies whether the student chose to participate in the College Board Student Search Service. Y = Yes, N = No |
| 21 | Best Language | Yes | VARCHAR2(1) | Indicates which language the student knows best. 1 = English Only, 3 = English and Another, 4 = Another, 0 = No Response |
| Previous AI Information (Occurs 2 times) | ||||
| 22.. | Previous AI Year [N] (where n represents the number of occurrences) | Yes | VARCHAR2(2) | Format = YY (year that student attended a previous school) |
| 23.. | Previous AI Code [N] (where n represents the number of occurrences) | Yes | VARCHAR2(6) | Unique code representing the school that student previously attended. Six digits, with leading zeros, if applicable. |
| Awards Information (Occurs 6 times) | ||||
| 26.. | Award Type [N] (where n represents the number of occurrences) | 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.. | Award Year [N] (where n represents the number of occurrences) | Yes | VARCHAR2(2) | Format = YY (year in which the student qualified for the award) |
| High School Information | ||||
| 38 | AI Code | No | VARCHAR2(6) | Unique code identifying the school the student attended at the time of the exam administration. Six digits, with leading zeros, if applicable |
| 39 | Institution Name | Yes | VARCHAR2(30) | Name of the school the student attended at the time of the exam administration |
| 40 | AI Street Address 1 | Yes | VARCHAR2(30) | First line of the street address of the school |
| 41 | AI Street Address 2 | Yes | VARCHAR2(30) | Second line of the street address of the school |
| 42 | AI Street Address 3 | Yes | VARCHAR2(30) | Third line of the street address of the school |
| 43 | AI State | Yes | VARCHAR2(2) | Domestic Only |
| 44 | AI Zip Code | Yes | VARCHAR2(5) | Domestic Only |
| 45 | AI Province | Yes | VARCHAR2(32) | International Only |
| 46 | AI International Postal Code | Yes | VARCHAR2(10) | International Only |
| 47 | AI Country Code | Yes | VARCHAR2(3) | International Only |
| College Institution Information (College Requested on the Student's Answer Sheet) | ||||
| 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 |
| 49 | Contact Name | Yes | VARCHAR2(30) | The contact within the institution to which the student has requested to send AP scores |
| 50 | Institution Name | Yes | VARCHAR2(30) | The name of the institution to which the student has requested to send AP scores |
| 51 | DI Street Address 1 | Yes | VARCHAR2(30) | First line of the street address of the institution |
| 52 | DI Street Address 2 | Yes | VARCHAR2(30) | Second line of the street address of the institution |
| 53 | DI Street Address 3 | Yes | VARCHAR2(30) | Third line of the street address of the institution |
| 54 | DI State | Yes | VARCHAR2(2) | Domestic Only |
| 55 | DI Zip Code | Yes | VARCHAR2(5) | Domestic Only |
| 56 | DI Province | Yes | VARCHAR2(32) | International Only |
| 57 | DI International Postal Code | Yes | VARCHAR2(10) | International Only |
| 58 | DI Country Code | Yes | VARCHAR2(3) | International Only |
| Exam Information (Occurs 30 times) - Listed by most recent exam(s) first | ||||
| 59.. | Admin Year [N] (where n represents the number of occurrences) | No | VARCHAR2(2) | Format = YY (year in which the student took the exam) |
| 60.. | Exam Code [N] (where n represents the number of occurrences) | No | VARCHAR2(2) | Unique code representing the exam the student took.
|
| 61.. | Exam Grade [N] (where n represents the number of occurrences) | Yes | VARCHAR2(1) | Student's exam score. Reported on a scale of 1-5. |
| 62.. | Irregularity Code #1 [N] (where n represents the number of occurrences) | Yes | VARCHAR2(2) | Code indicating the type of irregularity or event related to the student's exam, if any.
|
| 63.. | Irregularity Code #2 [N] (where n represents the number of occurrences) | Yes | VARCHAR2(2) |
|
| 64.. | Class Section Code [N] (where n represents the number of occurrences) | Yes | VARCHAR2(1) | Number representing the specific section the student belongs to. Used to distinguish multiple class sections or multiple teachers teaching the same AP subject/exam. Valid values are 1-9, and is assigned by the AP Coordinator at the time of the exam administration. |
| History Information | ||||
| 239 | Date Grades Released to College | Yes | VARCHAR2(6) | Format = MMDDYY |
| 240 | Date of Last Student Update | No | VARCHAR2(6) | Format = MMDDYY (date on which the student's record was last updated) |
| 241 | Date of this report | No | VARCHAR2(6) | |
| Student Information Continued | ||||
| 242 | Student Identifier | Yes | VARCHAR2(25) | A unique number or alpha code assigned to the student by the school, school system, state, or other entity |
| 243 | Race Ethnicity Student Response 2016 and Forward | Yes | VARCHAR(11) | This field is populated for the 2016 exam administration and forward. The student's self-reported race and/or ethnicities. All characters contain either Y or N. The letter Y indicates that race/ethnicity value was selected by the student, while the letter N indicates it was not. One, multiple, or none may be checked with a Y. Position 1 = Cuban, Position 2 = Mexican, Position 3 = Puerto Rican, Position 4 = Other Hispanic Or Latino, Position 5 = Non-Hispanic Or Latino, Position 6 = American Indian or Alaska Native Position 7 = Asian (including Indian Subcontinent and Philippines Origin) Position 8 = Black or African American (including Africa and Afro-Caribbean Origin), Position 9 = Native Hawaiian or Other Pacific Islander Position 10 = White (including Middle Eastern Origin) Position 11 = Other. If viewing a student record for the 2015 exam administration or prior this field will be blank. Refer to field 19 for race/ethnicity data. |
| 244 | Derived Aggregate Race Ethnicity 2016 and Forward | Yes | VARCHAR(2) | This field is populated for the 2016 exam administration and forward. The student's aggregate race/ethnicity per federal reporting guidelines. 0 = No Response, 1 = American Indian/Alaska Native, 2 = Asian, 3 = Black/African American, 4 = Hispanic/Latino, 8 = Native Hawaiian or Other Pacific Islander, 9 = White, 10 = Other, 12 = Two or More Races, Non-Hispanic. If viewing a student record for the 2015 exam administration or prior this field will be blank. Refer to field 19 for race/ethnicity data. |
student/ap_test_scores_import.1509637527.txt.gz · Last modified: 2017/11/02 10:45 (external edit)