Field Set: State SC Virtual SC_EFA_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_EFA_History | unique_id | S_SC_STU_EFA_History_C | unique_id |
| SC_EFA_History | schoolID | S_SC_STU_EFA_History_C | schoolID |
| SC_EFA_History | foreignKey | S_SC_STU_EFA_History_C | foreignKey |
| SC_EFA_History | foreignKey_alpha | S_SC_STU_EFA_History_C | foreignKey_alpha |
| SC_EFA_History | start_dt | S_SC_STU_EFA_History_C | start_dt |
| SC_EFA_History | stop_dt | S_SC_STU_EFA_History_C | stop_dt |
| SC_EFA_History | efa_primary | S_SC_STU_EFA_History_C | efa_primary |
| SC_EFA_History | efa_2 | S_SC_STU_EFA_History_C | efa_2 |
| SC_EFA_History | efa_3 | S_SC_STU_EFA_History_C | efa_3 |
| SC_EFA_History | efa_4 | S_SC_STU_EFA_History_C | efa_4 |
| SC_EFA_History | efa_5 | S_SC_STU_EFA_History_C | efa_5 |
| SC_EFA_History | efa_6 | S_SC_STU_EFA_History_C | efa_6 |
| SC_EFA_History | efa_7 | S_SC_STU_EFA_History_C | efa_7 |
| SC_EFA_History | efa_8 | S_SC_STU_EFA_History_C | efa_8 |
| SC_EFA_History | efa_9 | S_SC_STU_EFA_History_C | efa_9 |
| SC_EFA_History | efa_10 | S_SC_STU_EFA_History_C | efa_10 |
| SC_EFA_History | datetime_created | S_SC_STU_EFA_History_C | datetime_create |
| SC_EFA_History | school_id | S_SC_STU_EFA_History_C | school_id |
| SC_EFA_History | userid_updated | S_SC_STU_EFA_History_C | userid_updated |
| SC_EFA_History | datetime_updated | S_SC_STU_EFA_History_C | datetime_updated |
| SC_EFA_History | schoolid_updated | S_SC_STU_EFA_History_C | schoolid_updated |
| SC_EFA_History | user_defined_numeric | S_SC_STU_EFA_History_C | rptuserid |
| SC_EFA_History | user_defined_integer | S_SC_STU_EFA_History_C | yearid |