This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
student:ap_test_scores_import [2017/11/02 15:38] – jstanford | student:ap_test_scores_import [2020/08/17 19:51] (current) – emoreno | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ======AP Test Scores Import | + | ======AP Test Scores Import====== |
^Column #^Column Name^Optional^Data Type^Comment^ | ^Column #^Column Name^Optional^Data Type^Comment^ | ||
^Student Information^^^^^ | ^Student Information^^^^^ | ||
- | |1|AP Number|No|VARCHAR2(8)|Student' | + | |1|AP Number |
- | |2|Last Name|No|VARCHAR2(15)|The student' | + | |17|Grade Level|No|VARCHAR2(2)|3 = < 9th Grade\\ |
- | |3|First Name|No|VARCHAR2(12)|The student' | + | |26, 28, 30, 32, 34, 36|Award Type [N] (where n represents the number of occurrences (1-6))|Yes|VARCHAR2(2)|01 = AP Scholar\\ |
- | |4|Middle Initial|Yes|VARCHAR2(1)|The student' | + | |27, 29, 31, 33, 35, 37|Award Year [N] (where n represents the number of occurrences |
- | |5|Student Street Address 1|Yes|VARCHAR2(30)|First line of the student' | + | |
- | |6|Student Street Address 2|Yes|VARCHAR2(30)|Second line of the student' | + | |
- | |7|Student Street Address 3|Yes|VARCHAR2(30)|Third line of the student' | + | |
- | |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 | + | |
- | |18|Filler|Yes|VARCHAR2(3)| | | + | |
- | |19|Ethnic Group 2015 and Prior|Yes|VARCHAR2(2)|Code representing the race/ | + | |
- | |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 | + | |
- | ^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^^^^^ | ^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' | ||
|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| | |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. Refer to section below for the full list of valid exam codes and exam names.{{page> | ||
- | |61..|Exam Grade [N] (where n represents the number of occurrences)|Yes|VARCHAR2(1)|Student' | ||
- | |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' | ||
- | |63..|Irregularity Code #2 [N] (where n represents the number of occurrences)|Yes|VARCHAR2(2)|Refer to page 5 for the full list of valid codes and descriptions.| | ||
- | |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/ | ||
- | ^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' | ||
|241|Date of this report|No|VARCHAR2(6)|Format = MMDDYY (date this report was generated) | |241|Date of this report|No|VARCHAR2(6)|Format = MMDDYY (date this report was generated) | ||
- | ^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' | ||
- | |244|Derived Aggregate Race Ethnicity 2016 and Forward|Yes|VARCHAR(2)|This field is populated for the 2016 exam administration and forward. The student' | ||
+ | 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: | ||
+ | * 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) | ||
+ | |||
+ | |||
+ | <WRAP box> | ||
+ | | ||
+ | |||
+ | Prior to 2018, social security number (SSN) was contained in the import file and used to match the ID for students. Files after 7/11/2018 will not have the SSN. </ | ||