Interfaces

User Tools

Site Tools

Trace:
student:ap_test_scores_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:ap_test_scores_import [2017/11/02 15:56] – jstanfordstudent:ap_test_scores_import [2020/08/17 19:51] (current) – emoreno
Line 1: Line 1:
-======AP Test Scores Import (2017)======+======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's AP registration number for this exam administration. This is unique per student per administration year.| +|1|AP Number / AP ID|No|VARCHAR2(8)|Student's AP registration number/ID for this exam administration. This is unique per student per administration year.| 
-|2|Last Name|No|VARCHAR2(15)|The student's surname.| +|17|Grade 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| 
-|3|First Name|No|VARCHAR2(12)|The student's given name.| +|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| 
-|4|Middle Initial|Yes|VARCHAR2(1)|The student's middle initial.| +|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)|
-|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^^^^^ ^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| |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. {{page>student_exam_codes}} | 
-|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. {{page>student_irregularity_codes}}| 
-|63..|Irregularity Code #2 [N] (where n represents the number of occurrences)|Yes|VARCHAR2(2)|{{page>student_irregularity_codes}}| 
-|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)|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'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.| 
  
 +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>**NOTE:** The Last Name, First Name, Middle Initial, Sex, and Date of Birth contained in the import file are used to match to the local student ID for students already in the database and ensure that the record in the import file links to the correct student in the database. The local ID is matched to the imported record.\\ 
 + \\  
 +
 +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. </WRAP>
  
student/ap_test_scores_import.1509638182.txt.gz · Last modified: 2017/11/02 10:56 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.