Test, 86 (ver3.6.1)
Academic or Fitness Tests offered at the school/district such as SATs, ACTs or the President's Physical Fitness Challenge.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | An optional area to describe any information about this item. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
| ImportCode | 20.11.0 | Varchar(20) | A code used to maintain the test hierarchy during import using Data Import Manager |
Name | 3.6.1 | Varchar(35) | Name provided for this test, such as ACT I, SAT2, etc. Indexed. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
Test_Type | 3.6.1 | Number(10,0) | The type of test being administered. 1 = National, 2 = State, 3 = Local, 4 = District, 5 = School, 6 = Other, 7 = Fitness (as of 20.11.0) |
Teacher_Access | PS_24.9.0.0 | Number(2,0) | The type of teacher access being administered. 0 = No Access 1 = View Only Access 2 = Full Access, 3 =Add Only Access 4 = Edit Only Access |
Historical_Test | PS_24.9.0.0 | Number(1,0) | The access of teachers to review historical test results outside of the current year being administered. Valid values: 0, 1 |
Number_Entry_Type | PS_24.9.0.0 | Number(1,0) | If the teacher can add or edit the scores for the chosen number entry types being administered. Valid values: 0, 1 |
Percent_Entry_Type | PS_24.9.0.0 | Number(1,0) | If the teacher can add or edit the scores for the chosen percent entry types being administered. Valid values: 0, 1 |
Alpha_Entry_Type | PS_24.9.0.0 | Number(1,0) | If the teacher can add or edit the scores for the chosen alpha entry types being administered. Valid values: 0, 1 |