S_TX_ASSESSMENT_IMPORT_S (ver 22.9.1.0)
This table is a stand-alone table that stores the setup for state-assigned assessments.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 19.8.2.0 | Number(19,0) | Primary Key. |
| STUDENT_NUMBER | 19.8.2.0 | Number(25,10) | A student Identifier corresponding to the Students table Student_Number. |
| TEST_TYPE | 19.8.2.0 | Varchar2(15) | The test type, ie STAAR EOC, STAAR ALT 2 EOC. |
| TEST_DATE | 19.8.2.0 | Date | The date of the test. |
| IMPORT_FILE_ROW_NUMBER | 19.8.2.0 | Number(11,0) | The row number from the Test Administration file. |
| IMPORT_MESSAGE | 19.8.2.0 | Varchar2(4000) | Validation messages related to this record. |
| IMPORT_FILENAME | 19.8.2.0 | Varchar2(260) | Temp filename of the import. |
| TEST_CODES | 19.8.2.0 | Varchar2(21) | Tests included in this record (depending on the test type, multiple subjects can be merged into a single record). |
| GRADE_LEVEL_TESTED | 19.8.2.0 | Number(11,0) | Grade Level the test was taken. |
ALGEBRA_I_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| ALGEBRA_I_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| ALGEBRA_I_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| ALGEBRA_II_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| ALGEBRA_II_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| ALGEBRA_II_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| BIOLOGY_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| BIOLOGY_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| BIOLOGY_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| ENGLISH_I_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| ENGLISH_I_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| ENGLISH_I_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| ENGLISH_II_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| ENGLISH_II_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| ENGLISH_II_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| ENGLISH_III_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| ENGLISH_III_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| ENGLISH_III_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| US_HISTORY_1 | 19.8.2.0 | Number(25,10) | Corresponds to the test number score. |
| US_HISTORY_2 | 19.8.2.0 | Number(25,10) | Corresponds to the test percent score. |
| US_HISTORY_3 | 19.8.2.0 | Varchar2(20) | Corresponds to the test alpha score. |
| SPEAKING_1 | 22.9.1.0 | Number(25,10) | Corresponds to the test number score. |
| SPEAKING_2 | 22.9.1.0 | Number(25,10) | Corresponds to the test percent score. |
| SPEAKING_3 | 22.9.1.0 | Varchar2(20) | Corresponds to the test alpha score. |
| LISTENING_1 | 22.9.1.0 | Number(25,10) | Corresponds to the test number score. |
| LISTENING_2 | 22.9.1.0 | Number(25,10) | Corresponds to the test percent score. |
| LISTENING_3 | 22.9.1.0 | Varchar2(20) | Corresponds to the test alpha score. |
| COMPOSITE_1 | 22.9.1.0 | Number(25,10) | Corresponds to the test number score. |