The first couple months of go-live with Workday Financials has been busy for the entire team. From answering questions and troubleshooting to developing new training and getting information to the website, it is a steady stream of information across Grounds. New data coming into UVAFinance is at a new level and team members are adjusting.
"The volume of data entering the data warehouse seems to be at least three times greater than we received from Oracle," says Forrest Swope, Director of Data Operations.
Swope reports that the number of journal lines created when payroll is run generates a file too large to move. That's a lot of data!
"We devised a method to overcome these limitations - which is inelegant, but effective," he says.
 |
While his team routinely checks the results of the nightly processing, it proved challenging to confirm
that they were certain they were receiving all of the lines using just Journal Lines data from Workday as a validation.
"After the end of July, we were able to run a Trial Balance in Workday for the entire month and compare the results (Beginning Balance: Changes during July: Ending Balance) to precisely tie out the total of all transactions by Company and Ledger Account to the Journal Lines data collected in the Data Warehouse," shares Swope.
The results of this new assessment have proved successful as Swope reports, "Across six companies with over six million posted transactions, totaling $9 billion we were off by exactly $0.00."
Swope thanks Mohan Vijay Adusumilli, Navya K, and Sai Mahesh Vemulapalli for their dedication to determining new processes and evaluations.
"It's a team effort and my hat goes off to the entire group."
No comments
Post a Comment