ACT Tests
Collection Template
Position |
Column Name |
Required |
Format |
Description |
0 |
Data Type |
True |
Text
|
ACT Tests |
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 |
Test Date |
True |
Date
|
|
10 |
English Score |
True |
Integer (Small)
|
|
11 |
Math Score |
True |
Integer (Small)
|
|
12 |
Reading Score |
True |
Integer (Small)
|
|
13 |
Science Score |
True |
Integer (Small)
|
|
14 |
Composite Score |
True |
Integer (Small)
|
|
15 |
Review Status ID |
False |
Mapped ID
|
Accepted Values:
- 0
- 1
- -1
- 2
- -2
- EXCLUDED: PENDING DC PCSB STAFF REVIEW
- EXCLUDED: RESULT DOES NOT MEET BENCHMARK
- EXCLUDED: SUPPORTING DOCUMENTATION DOES NOT MATCH RESULTS
- EXCLUDED: SUPPORTING DOCUMENTATION REQUIRED
- INCLUDED: RESULTS PROVIDED BY PUBLISHER
- INCLUDED: VERIFIED BY DC PCSB STAFF
|
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.