Field Set: State IL Virtual IL Term Grade Mapping
This field set was included with State Reporting Installer 17.6.0 released on June 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| IL_Term_Grade_Mapping | unique_ID | S_IL_Term_Grade_Mapping_S | unique_ID |
| IL_Term_Grade_Mapping | schoolID | S_IL_Term_Grade_Mapping_S | schoolID |
| IL_Term_Grade_Mapping | foreignKey | S_IL_Term_Grade_Mapping_S | foreignKey |
| IL_Term_Grade_Mapping | foreignKey_alpha | S_IL_Term_Grade_Mapping_S | foreignKey_alpha |
| IL_Term_Grade_Mapping | termid | S_IL_Term_Grade_Mapping_S | termid |
| IL_Term_Grade_Mapping | storecode | S_IL_Term_Grade_Mapping_S | storecode |
| IL_Term_Grade_Mapping | sort_by | S_IL_Term_Grade_Mapping_S | sort_by |
| IL_Term_Grade_Mapping | termPeriod | S_IL_Term_Grade_Mapping_S | termPeriod |
| IL_Term_Grade_Mapping | startDate | S_IL_Term_Grade_Mapping_S | startDate |
| IL_Term_Grade_Mapping | endDate | S_IL_Term_Grade_Mapping_S | endDate |
| IL_Term_Grade_Mapping | user_defined_integer | S_IL_Term_Grade_Mapping_S | yearid |
| IL_Term_Grade_Mapping | user_defined_numeric | S_IL_Term_Grade_Mapping_S | schoolstaffid |