Field Set: State NM Virtual SpedEvents
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 |
|---|---|---|---|
SpedEvents | unique_ID | S_NM_STU_SpedEvents_C | unique_ID |
SpedEvents | schoolID | S_NM_STU_SpedEvents_C | schoolID |
SpedEvents | foreignKey | S_NM_STU_SpedEvents_C | foreignKey |
SpedEvents | foreignKey_alpha | S_NM_STU_SpedEvents_C | foreignKey_alpha |
SpedEvents | user_defined_date | S_NM_STU_SpedEvents_C | EventDate |
SpedEvents | user_defined_integer | S_NM_STU_SpedEvents_C | EventType |
SpedEvents | user_defined_text | S_NM_STU_SpedEvents_C | EventReason |
SpedEvents | user_defined_text2 | S_NM_STU_SpedEvents_C | SpedNonComplianceReason |
SpedEvents | NM_SubmittedToSTARS_Code | S_NM_STU_SpedEvents_C | SubToSTARSCode |
SpedEvents | NM_SubmittedToSTARS_Date | S_NM_STU_SpedEvents_C | SubToSTARSDate |