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/13 20:08] – 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 |
- | |17|Education | + | |17|Grade Level|No|VARCHAR2(2)|3 = < 9th Grade\\ |
- | |26, 28, 30, 32, 34, 36|Award Type [N] (where n represents the number of occurrences 1-6)|Yes|VARCHAR2(2)|01 = AP Scholar\\ | + | |26, 28, 30, 32, 34, 36|Award Type [N] (where n represents the number of occurrences |
- | |27, 29, 31, 33, 35, 37|Award Year [N] (where n represents the number of occurrences | + | |27, 29, 31, 33, 35, 37|Award Year [N] (where n represents the number of occurrences |
^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) | ||
- | ^Student Information Continued^^^^^ | ||
+ | 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. </ | ||