Field Set: State SC Virtual SC_EIA_History
This field set was included with State Reporting Installer 20.8.2.0 released on August 19, 2020.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| SC_EIA_History | unique_id | S_SC_STU_EIA_History_C | unique_id |
| SC_EIA_History | schoolID | S_SC_STU_EIA_History_C | schoolID |
| SC_EIA_History | foreignKey | S_SC_STU_EIA_History_C | foreignKey |
| SC_EIA_History | foreignKey_alpha | S_SC_STU_EIA_History_C | foreignKey_alpha |
| SC_EIA_History | start_dt | S_SC_STU_EIA_History_C | start_dt |
| SC_EIA_History | stop_dt | S_SC_STU_EIA_History_C | stop_dt |
| SC_EIA_History | eia_1 | S_SC_STU_EIA_History_C | eia_1 |
| SC_EIA_History | eia_2 | S_SC_STU_EIA_History_C | eia_2 |
| SC_EIA_History | eia_3 | S_SC_STU_EIA_History_C | eia_3 |
| SC_EIA_History | eia_4 | S_SC_STU_EIA_History_C | eia_4 |
| SC_EIA_History | eia_5 | S_SC_STU_EIA_History_C | eia_5 |
| SC_EIA_History | eia_6 | S_SC_STU_EIA_History_C | eia_6 |
| SC_EIA_History | eia_7 | S_SC_STU_EIA_History_C | eia_7 |
| SC_EIA_History | eia_8 | S_SC_STU_EIA_History_C | eia_8 |
| SC_EIA_History | eia_9 | S_SC_STU_EIA_History_C | eia_9 |
| SC_EIA_History | eia_10 | S_SC_STU_EIA_History_C | eia_10 |
| SC_EIA_History | datetime_created | S_SC_STU_EIA_History_C | datetime_created |
| SC_EIA_History | school_id | S_SC_STU_EIA_History_C | school_id |
| SC_EIA_History | userid_updated | S_SC_STU_EIA_History_C | userid_updated |
| SC_EIA_History | datetime_updated | S_SC_STU_EIA_History_C | datetime_updated |
| SC_EIA_History | schoolid_updated | S_SC_STU_EIA_History_C | schoolid_updated |
| SC_EIA_History | SC_GT_Artistic_Discipline | S_SC_STU_EIA_History_C | GT_Artistic_Discipline |
| SC_EIA_History | SC_GT_Academic_Area | S_SC_STU_EIA_History_C | GT_Academic_Area |
| SC_EIA_History | user_defined_numeric | S_SC_STU_EIA_History_C | rptuserid |
| SC_EIA_History | user_defined_integer | S_SC_STU_EIA_History_C | yearid |