S_IL_Term_Grade_Mapping_S (ver 17.5.0)
This is a stand alone table for migration from IL_Term_Grade_Mapping virtual table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.5.0 | Number(11,0) | Primary Key |
| SchoolID | 17.5.0 | Number(11,0) | ID of the school associated with this Store code list. Migrated from [IL_Term_Grade_Mapping.SchoolID]. |
| Termid | 17.5.0 | Number(11,0) | Powerschool Term. Migrated from [IL_Term_Grade_Mapping.Termid]. |
| Storecode | 17.5.0 | Varchar2(2) | Store Code.Migrated from [IL_Term_Grade_Mapping.Storecode]. |
| TermPeriod | 17.5.0 | Varchar2(2) | State Term. Migrated from [IL_Term_Grade_Mapping.TermPeriod]. |
| StartDate | 17.5.0 | Date | Start Date. Migrated from [IL_Term_Grade_Mapping.StartDate]. |
| EndDate | 17.5.0 | Date | End Date. Migrated from [IL_Term_Grade_Mapping.EndDate]. |
| Yearid | 17.5.0 | Number(11,0) | YearId. Internal Use. Migrated from [IL_Term_Grade_Mapping.user_defined_integer]. |
| Schoolstaffid | 17.5.0 | Number(25,10) | Userid. Internal Use.. Migrated from [IL_Term_Grade_Mapping.user_defined_numeric]. |
| Sort_by | 17.5.0 | Varchar2(50) | Internal use.Migrated from [IL_Term_Grade_Mapping.Sort_by]. |
| foreignkey | 17.5.0 | Number(11,0) | Default field. No longer used. |
| foreignKey_alpha | 17.5.0 | Number(11,0) | Default field. No longer used. |