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. |