User Tools

Site Tools


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
Last revisionBoth sides next revision
student:ap_test_scores_import [2018/10/26 12:55] jstanfordstudent:ap_test_scores_import [2020/08/17 19:29] emoreno
Line 3: Line 3:
 ^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 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 (1-6))|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)|
student/ap_test_scores_import.txt · Last modified: 2020/08/17 19:51 by emoreno