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 |