Skip to content

Comparing two Datasets Submissions

The Compare Datasets feature allows LEA users to view a Compare Dataset list by fiscal year, or fiscal year by reporting period, that includes the relevant datasets from the Draft, Submission, and Published Dataset Lists. Users may select up to two datasets from the Compare Datasets list for the same entity to compare.

The submissions page displaying (1) the submissions checkbox and the drop-down list (2) which includes the Compare Two Selected Datasets option and the Query SACS option.

To compare two datasets

  1. From the Dataset Submission List, select a maximum of two datasets by clicking the dataset selector checkbox.
  2. Click the Compare button located above the list.
  3. On the Compare Dataset dialog box, select the Comparison Type:
    • GL Data
    • Supplemental Data
    • TRC Log Data
    • TRC Explanation Data
  4. Select the data type of the submission from the Data Type drop-down list for each submission.
  5. Click the Compare button to see the results. Compare Dataset dialog box displaying the Comparison Type (3) radial buttons, the Data Type drop-down list (4), and the Compare button (5).
  6. When the appropriate Compare page opens:
    • A list of all resources, TRCs, or Exceptions will be displayed.
    • Any item (cell) that is different will be highlighted.
    • Any item missing in one submission but not the other will be highlighted. The Compare Results page displaying differences between the two selected datasets. Each fund comparison is represented on a row. Note A and Note B

Note: A - When there is a difference between the two submissions on the same row, the cells of both submissions is highlighted.

Note: B - When there is a Resource in one submission but not the other, the entire resource row of the submission having the data is highlighted and no highlight on the row of the submission without data.