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. |
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 Schola 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. |