IT Accesses Financial Data from Banner Using SQL Queries
A public college required customized reports to meet ad hoc financial reporting requirements. IT personnel gathered these requirements and created SQL queries to gather data from the college's Banner ERP system.
ProjectLead met with accounting managers to define their reporting requirements.
ProjectLead designed SQL queries to access data from Banner.
ProjectLead developed reports using the queried data and verified the results..
RESULTS
Customized Reports
Reports were built to comply with specific business requirements.
Accurate Data
Data was verified for accuracy.
Quick Turnaround
Reports typically were completed in 24-48 hours.
Comments