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/13 20:12] – 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.| 
-|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| +|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| 
-|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| +|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 106)|Yes|VARCHAR2(2)|Format = YY (year in which the student qualified for the award)|+|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^^^^^ ^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| |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)|Format = MMDDYY (date this report was generated) |241|Date of this report|No|VARCHAR2(6)|Format = MMDDYY (date this report was generated)
  
-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.\\  \\  +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 first set of AP Scores are in columns 59-64.\\  
 The second set are in columns 65-70, etc.\\  \\   The second set are in columns 65-70, etc.\\  \\  
Line 17: Line 17:
   * Admin Year (column 59 for the first set of scores, 65 for the second set of scores, etc., up to 30 sets)   * 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 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)+  * 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 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)+  * 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, et 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.1510603969.txt.gz · Last modified: 2017/11/13 15:12 (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.