S_AL_TSC_S ver 22.8.2.0
This table is a Standalone table to hold Threshold Values for Test Scores.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.8.2.0 | Number(19,0) | The primary key that indicates a unique ID |
| TEST_NAME | 22.8.2.0 | Varchar2(140) | Test Name which is setup. |
| TEST_SCORE_NAME | 22.8.2.0 | Varchar2(140) | Test Score Name which is setup |
| YEARID | 22.8.2.0 | Number(11,0) | YearID of a School. Ex - 31 for 2021-2022 |
| THRESHOLD | 22.8.2.0 | Number(25,0) | Threshold Value for a Test Name and Test Score. Integer |
| ALPHATHRESHOLD | 22.8.2.0 | Varchar2(400) | Threshold Value for a Test Name and Test Score. String |
| ISPROCESSED | 22.8.2.0 | Varchar2(40) | Flag to indicate whether nightly job to pick certain rows for processing |