Table of Contents | ||||
---|---|---|---|---|
|
Report Description
The Financial Analytics - Auto Validation report will be used to identify discrepancies found in the financial amounts found between the source and the Azure SQL pool tables in Synapsefor finance. The report data is refreshed daily (except on Sundays) and shows the shows a bar chart with the total number of differences found for each record type in a summary tablespecified validation date range. A detail table lists each record where differences were found and shows the actual 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
...
The financial record type
Traveler Name
First and last name of traveler.
Fund Code
A five digit numeric value to identify a source of funds. The default is for all codes to be selected; individual or multiple codes may be selected.
FAST Department Code
A six digit numeric code to determine FAST Department. The default is for all codes to be selected; individual or multiple codes may be selected.
Expense Report Status
Current status of travel expense report: Canceled, Deleted, Deletion in Progress, Fiscal Review, Paid, Prepay Auditor, Request Approved, Submission in Progress, Supervisor Review
Expense Report On Hold
Filter will display Y/N if Expense Report is on Hold.
Expense Report Send Backs
Filter will display Y/N if Expense Report had a Send Back.
Expense Report Created Day
The date the travel expense report was created.
Travel End Day
The date in which a travel trip ends.
Visualization
Expense Report by Status
Pie chart that displays the number of expense reports in each status.
Drillable - The pie also allows you to drill to display count of expense reports for Traveler College Name and Traveler Global Department Name separately.
Number of Expense Reports per Day Range for Last Status
Bar chart that displays the number of expenses per each range. Ranges are broken down as follows: 7 days or less, 8 to 29 days, 30 to 59 days, 60 to 89 days, and 90 days or greater.
Number of Expense Reports
The number of expense reports.
Number on Hold
Number of expense reports currently on hold.
Number Sent Back
Number of expense reports that had a send back at any point in time.
Details
Status
Current status of travel expense report: Canceled, Deleted, Deletion in Progress, Fiscal Review, Paid, Prepay Auditor, Request Approved, Submission in Progress, Supervisor Review
Days Since Last Action
Number of days that an expense report has been in a particular status.
ER on Hold
Expense report currently on hold with Y/N flag.
ER Had Send Back
Expense report that has ever had a send back at any point in time will be denoted with a Y/N flag; once an ER has had a send back the flag will flip to "Y".
Travel Begin Day
The date in which a travel trip begins.
Travel End Day
The date in which a travel trip ends.
ER Creation Lag
The difference between the last day of travel and the creation of the travel expense report.
Archivum ER Number
Travel expense report number created by the Archivum database.
Traveler Name
First and last name of traveler.
Travel Title
Travel title entered by traveler for travel request and expense report.
Traveler Global Department Name
Global Department name associated with person listed as the traveler.
Traveler College Name
Name of College associated with person traveling.
Total ER Expenses
Total dollar amount for a travel expense report.
Expense Report Number
Expense report number per the Travel department.
FAST Department Code
A six digit numeric code to determine FAST Department. The default is for all codes to be selected; individual or multiple codes may be selected.
Data Refreshed On
Data in this report is not live, but refreshed once daily. The date and time on the bottom right of the report displays when it was refreshed from Archivum. The refresh is scheduled to occur between 7:00 and 7:45 am each morning.
Disclaimer
...
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.
...