Report Description
The Financial Analytics - Auto Validation report will be used to identify discrepancies found in the financial amounts between the source and the Azure SQL pool tables in Synapse. The report data is refreshed daily (except on Sundays) and shows the number of differences found for each record type in a summary table. A detail table lists each record where differences were found and shows the actual amounts in the source and SQL pool tables along with a column that shows the difference between the two amounts.
Filters
FiscalYear
Fiscal year of the financial transaction
ValidationType
The financial record type
Visualization
Card
Each card shows the number of records where differences in amounts were found for a specific record type (Actuals, Budget, Encumbrance, Requisition). By default, the numbers shown are from the most recent run.
RecordDiffCount by ValidationDateTime and ValidationType
Bar chart that displays the number of records having different amounts for each record type over time.
Details
Validation Summary
Shows the total number of records where differences in amounts were found for each record type and validation run date.
Validation Detail
Shows the amounts found for each record. The source table and SQL pool amounts are shown for each record type, validation date, fiscal year, accounting period, business unit, account, operating unit, fund code, department, initiative, project, and product.
Another column shows the calculated difference between the two amounts. Overall totals are shown at the bottom for each amount.
Data Refresh Schedule
Data in this report is updated daily (expect on Sundays) and is included in the same schedule/pipeline as the rest of the data for Financial Analytics.
Disclaimer
Unauthorized use of this report is prohibited. If you log on to this computer system, you acknowledge your awareness of and concurrence with the University of South Florida policies. The University will prosecute violators to the full extent of the law.