S_NM_STU_AssessmentFact_C (ver 17.6.0)
This is a child table of the Students table. The data is populated from the VirtualTablesData table. Only records related to AssessmentFact are stored in this table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Id | 17.6.0 | Number(10,0) | Primary Key. |
StudentsDcid | 17.6.0 | Number(10,0) | Foreign Key. |
Unique_Id | 17.6.0 | Number(11,0) | Alternate Primary Key. Migrated from [VirtualTablesData.Unique_Id]. |
SchoolId | 17.6.0 | Number(11,0) | Identifies school this record is related to. Migrated from [VirtualTablesData.SchoolId]. |
ForeignKey | 17.6.0 | Number(11,0) | Alternate Foreign Key. Migrated from [VirtualTablesData.ForeignKey]. |
ForeignKey_Alpha | 17.6.0 | Varchar2(31) | Unused but needed for migration. Migrated from [VirtualTablesData.ForeignKey_Alpha]. |
ScoringModelCode | 17.6.0 | Varchar2(12) | Scoring model code. Migrated from [VirtualTablesData.NM_ScoringModelCode]. |
TestDescription | 17.6.0 | Varchar2(20) | Indicates the type of assessment test. Migrated from [VirtualTablesData.NM_TestDescription]. |
AssessmentSchoolYearDate | 17.6.0 | Date | Assessment school year date. Migrated from [VirtualTablesData.NM_AssessmentSchoolYear]. |
ItemDescription | 17.6.0 | Varchar2(50) | Item description. Migrated from [VirtualTablesData.NM_ItemDescription]. |
StandardAchievedCode | 17.6.0 | Varchar2(6) | Standard achieved code. Migrated from [VirtualTablesData.NM_StandardAchievedCode]. |
TestDate | 17.6.0 | Date | Date on which the assessment test was taken. Migrated from [VirtualTablesData.NM_TestDate]. |
SubToSTARSCode | 17.6.0 | Varchar2(6) | Indicates the STARS reporting segment. Migrated from [VirtualTablesData.NM_SubmittedToSTARS_Code]. |
SubToSTARSDate | 17.6.0 | Date | The date corresponding to the STARS reporting segment. Migrated from [VirtualTablesData.NM_SubmittedToSTARS_Date]. |