DC Science Alternative
Collection Template
Position |
Column Name |
Required |
Format |
Description |
0 |
Data Type |
True |
Text
|
DC Science |
1 |
LEA ID |
True |
Integer (Small)
|
|
2 |
LEA |
False |
Text
|
|
3 |
Campus ID |
True |
Integer (Small)
|
|
4 |
Campus |
False |
Text
|
|
5 |
School Year |
True |
Text
|
YYYY-YYYY |
6 |
USI |
True |
Integer (Big)
|
|
7 |
First Name |
False |
Text
|
|
8 |
Last Name |
False |
Text
|
|
9 |
Subject |
True |
Mapped ID
|
Accepted Values:
|
10 |
Accountability Universe ID |
True |
Mapped ID
|
Accepted Values:
- EXCLUDED: INCOMPLETE TEST
- EXCLUDED: INVALIDATED SCORE
- EXCLUDED: NEW TO US EXEMPTION
- EXCLUDED: STUDENT DID NOT ATTEND FULL ACADEMIC YEAR AT CAMPUS
- EXCLUDED: TEST NOT TAKEN
- INCLUDED
|
11 |
FAY |
True |
Mapped Text
|
Accepted Values:
- CAMPUS
- CHARTER
- LEA
- NONE
- STATE
|
12 |
Scale Score |
False |
Integer (Small)
|
|
13 |
Performance Level |
False |
Integer (Small)
|
|
14 |
Test Code |
False |
Mapped Text
|
Accepted Values:
|
Shading Key
|
|
Primary Key Column |
Column(s) which uniquely define the row, and is required in all submissions |
Expected Column |
Column which is expected in a complete submission; in case where the data are missing and the column is not required, these columns may be left blank |
Non-Loaded Column |
Column which is not loaded; these columns are provided to support use of the table, but can be left blank in submissions |
Common Errors
Click on the error type to get more information.