Report Description

The Financial Analytics - Auto Validation report will be used to identify discrepancies in amounts found between the source and the Azure SQL pool tables for finance. The report shows a bar chart with the total number of differences found for each record type in a specified validation date range. A detail table lists each record identified with the amounts in the source and SQL pool tables shown along with a column that shows the difference between the two amounts. The report also shows the actual SQL queries used to pull the amounts for each record type.

Filters

FiscalYear

Fiscal year of the financial transaction

ValidationType

The financial record type

ValidationDateTime(bins)

The validation date range (defaults to the last 2 weeks)

Visualization

Actuals RecordDiffCount

Shows the total number of records found to have different amounts for the specified record type (Actuals) and validation date. By default, the number shown is from the most recent run.

CashAccounts RecordDiffCount (in UAT)

Shows the total number of records found to have different amounts for the specified record type (Cash Accounts) and validation date. By default, the number shown is from the most recent run.

Encumb RecordDiffCount

Shows the total number of records found to have different amounts for the specified record type (Encumbrance) and validation date. By default, the number shown is from the most recent run.

Budget RecordDiffCount

Shows the total number of records found to have different amounts for the specified record type (Budget) and validation date. By default, the number shown is from the most recent run.

Req RecordDiffCount

Shows the total number of records found to have different amounts for the specified record type (Requisition) and validation date. By default, the number shown is from the most recent run.

RecordDiffCount by ValidationDateTime(bins) and ValidationType

Bar chart shows the number of records having different amounts for each record type over a specified period of time.

Details

Validation Detail

Shows the source table and SQL pool amounts 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 of each amount column.

Query Pairs

Shows each record type’s actual source and target SQL queries that were used to retrieve the amounts for comparison.

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.