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:14] – 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 (1-6))|Yes|VARCHAR2(2)|01 = AP Scholar\\ | ||
|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)| | ||
Line 11: | Line 11: | ||
|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 | + | 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 27: | Line 27: | ||
* Class Section Code (column 64 for the first set of scores, 70 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. </ | ||