Field Set: State LA Virtual CalendarSpc
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 |
|---|---|---|---|
| CalendarSpc | unique_ID | S_LA_CalendarSpc_S | unique_ID |
| CalendarSpc | schoolID | S_LA_CalendarSpc_S | schoolID |
| CalendarSpc | foreignKey | S_LA_CalendarSpc_S | foreignKey |
| CalendarSpc | foreignKey_alpha | S_LA_CalendarSpc_S | foreignKey_alpha |
| CalendarSpc | user_defined_date | S_LA_CalendarSpc_S | First_Day |
| CalendarSpc | user_defined_date2 | S_LA_CalendarSpc_S | Last_Day |
| CalendarSpc | user_defined_text | S_LA_CalendarSpc_S | Calendar_Code_Description |
| CalendarSpc | user_defined_integer | S_LA_CalendarSpc_S | CalendarCode |
| CalendarSpc | user_defined_numeric | S_LA_CalendarSpc_S | Minutes_Per_Day |
| CalendarSpc | LA_Periods_Per_Day | S_LA_CalendarSpc_S | Periods_Per_Day |
| CalendarSpc | LA_Num_Of_Semesters | S_LA_CalendarSpc_S | Num_Of_Semesters |
| CalendarSpc | LA_First_Grade | S_LA_CalendarSpc_S | First_Grade |
| CalendarSpc | LA_Second_Grade | S_LA_CalendarSpc_S | Second_Grade |
| CalendarSpc | LA_Third_Grade | S_LA_CalendarSpc_S | Third_Grade |
| CalendarSpc | LA_Fourth_Grade | S_LA_CalendarSpc_S | Fourth_Grade |
| CalendarSpc | LA_Fifth_Grade | S_LA_CalendarSpc_S | Fifth_Grade |
| CalendarSpc | LA_Sixth_Grade | S_LA_CalendarSpc_S | Sixth_Grade |
| CalendarSpc | LA_Seventh_Grade | S_LA_CalendarSpc_S | Seventh_Grade |
| CalendarSpc | LA_Eighth_Grade | S_LA_CalendarSpc_S | Eighth_Grade |
| CalendarSpc | LA_TransNinth_Grade | S_LA_CalendarSpc_S | TransNinth_Grade |
| CalendarSpc | LA_Ninth_Grade | S_LA_CalendarSpc_S | Ninth_Grade |
| CalendarSpc | LA_Tenth_Grade | S_LA_CalendarSpc_S | Tenth_Grade |
| CalendarSpc | LA_Eleventh_Grade | S_LA_CalendarSpc_S | Eleventh_Grade |
| CalendarSpc | LA_Twelvth_Grade | S_LA_CalendarSpc_S | Twelvth_Grade |
| CalendarSpc | LA_Fifteenth_Grade | S_LA_CalendarSpc_S | Fifteenth_Grade |
| CalendarSpc | LA_Twentieth_Grade | S_LA_CalendarSpc_S | Twentieth_Grade |
| CalendarSpc | LA_Twenty_Fourth_Grade | S_LA_CalendarSpc_S | Twenty_Fourth_Grade |
| CalendarSpc | LA_Twenty_Fifth_Grade | S_LA_CalendarSpc_S | Twenty_Fifth_Grade |
| CalendarSpc | user_defined_text2 | S_LA_CalendarSpc_S | SiteCode |
| CalendarSpc | LA_SchoolNumber | S_LA_CalendarSpc_S | SchoolNumber |
| CalendarSpc | LA_Yearid | S_LA_CalendarSpc_S | Yearid |
| CalendarSpc | LA_Sub_District | S_LA_CalendarSpc_S | Sub_District |
| CalendarSpcEvent | unique_ID | S_LA_CalendarSpc_Event_C | unique_ID |
| CalendarSpcEvent | schoolID | S_LA_CalendarSpc_Event_C | schoolID |
| CalendarSpcEvent | foreignKey | S_LA_CalendarSpc_Event_C | foreignKey |
| CalendarSpcEvent | foreignKey_alpha | S_LA_CalendarSpc_Event_C | foreignKey_alpha |
| CalendarSpcEvent | user_defined_date | S_LA_CalendarSpc_Event_C | Beginning_Day |
| CalendarSpcEvent | user_defined_date2 | S_LA_CalendarSpc_Event_C | Ending_Day |
| CalendarSpcEvent | user_defined_text | S_LA_CalendarSpc_Event_C | Record_Type |
| CalendarSpcEvent | user_defined_text2 | S_LA_CalendarSpc_Event_C | Event_Description |
| CalendarSpcEvent | user_defined_integer | S_LA_CalendarSpc_Event_C | Instructional_Time |