Changed to look like the LEGACYSPED object (no significant change.
Moved index create script to same file as the object.
Use Transform_IepGoalArea_goals instead of Transform_IepGoalArea
Changed to be more like the LEGACYSPED object and changed IEPRefID to EP RefID.  Not sure how this did not error before???
Removed script for the map table we're using from LEGACYSPED and changed Transform_IepGoalArea to Transform_IepGoalArea_goals.
MAP_IepGoalAreaID has EPRefID instead of GoalRefID (this is key to having one goal area per IEP instead of one Goal Area per Goal) and instead of using MAP table we use Transform_IepGoalArea_goals.
Reordered objects according to the order in the LEGACYSPED localization script.
Removed MAP_EPSubGoalAreaDefID since we are using the one from LEGACYSPED
Minor cleanup for readability and out of general pickiness.
Moved index creation script to the file with the object.
Cleanup
set all required objects to Enabled.
full join on Student MAP table to limit to students that were actually matched (and had Grade and School).
Join to MAP_PrgGoalID instead of Transform_PrgGoal (query more efficient).
MAP_IepGoalAreaID EPRefID instead of GoalRefID
GoalAreaPivotView instead of GiftedGoalAreaPivotView
MAP_PrgGoalID instead of Transform