S_PA_STU_ASSESSMENTS_C (ver 14.9.1)
This table is a child table of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 14.9.1 | Number(10,0) | System generated primary key. |
| StudentsDCID | 14.9.1 | Number(10,0) | Foreign Key to the Students table. |
YearID | 14.9.1 | Number(2,0) | YearID of the assessment record. e.g. 23 = 2013-14. |
ParticipationCode | 14.9.1 | Varchar2(1) | Valid Participation Code values as defined by PA DOE. |
KeystoneWinterAlgebra | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Winter Algebra Assessment. |
KeystoneWinterLiterature | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Winter Literature Assessment. |
KeystoneWinterBiology | 14.9.1 | Number(1,0 | Boolean Yes/No for participating in Winter Biology Assessment. |
KeystoneSpringAlgebra | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Spring Algebra Assessment. |
KeystoneSpringLiterature | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Spring Literature Assessment. |
KeystoneSpringBiology | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Spring Biology Assessment. |
| KeystoneSummerAlgebra | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Summer Algebra Assessment. |
| KeystoneSummerLiterature | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Summer Literature Assessment. |
| KeystoneSummerBiology | 14.9.1 | Number(1,0) | Boolean Yes/No for participating in Summer Biology Assessment. |