CRDC Specific to New Mexico: S_NM_FinalGradeStoreCodes_S (ver 17.6.0)
This is a standalone CRDC table. The data is populated from the VirtualTablesData table. Only records related to CRDCFinalGradeStoreCodes are stored in this table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Id | 17.6.0 | Number(10,0) | Primary 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) | Unused but needed for migration. Migrated from [VirtualTablesData.ForeignKey]. |
ForeignKey_Alpha | 17.6.0 | Varchar2(31) | Unused but needed for migration. Migrated from [VirtualTablesData.ForeignKey_Alpha]. |
TermId | 17.6.0 | Number(11,0) | Specifies to which term the store code mapping applies. Migrated from [VirtualTablesData.User_Defined_Integer]. |
YearId | 17.6.0 | Number(25,10) | Specifies to which school year the store code mapping applies. Migrated from [VirtualTablesData.User_Defined_Numeric]. |
CRDCStoreCodeList | 17.6.0 | Varchar2(2000) | A list of final grade store codes to be used by the CRDC report. Migrated from [VirtualTablesData.User_Defined_Text]. |
FinalGradeStoreCode | 17.6.0 | Varchar2(2) | A final grade store code to be used by the Student Grades report. Migrated from [VirtualTablesData.User_Defined_Text2]. |