Returns Scope Level Target Details by Institution and Forecast Year

The following query returns Scope-level target information for the selected institution, including target categories, types, baseline and horizon years, forecast values, and scope coverage. It pivots key scope metrics for easier comparison and highlights whether each target falls under the Scope Category flag.