Minnesota Office of the Legislative Auditor
Financial Audit Division

Menu

Minnesota Office of the Legislative Auditor Menu

Report Summary
Minnesota State Colleges and Universities
Data Warehouse Controls

 

Financial Audit Division Report 04-29 Released July 15, 2004

Key Conclusion:

The Minnesota State Colleges and Universities (MnSCU) developed procedures to extract and load data from source computer systems into its data warehouse. However, we identified some concerns with the security infrastructure and standards for the design and testing of data transferred into the warehouse.

Findings:

  • MnSCU has not documented existing procedures and has not formalized procedures to ensure that data transferred from its source business systems to the data warehouse is accurate and complete.
  • MnSCU needs to improve its security over the operating system and database underlying the data warehouse.
  • One employee performs incompatible duties.
The audit report contained 3 audit findings relating to internal controls over MnSCU’s data warehouse.
  Audit Scope:

Audit Period:
As of April 2004

Selected Audit Areas:
  • Security
  • Data Extract and Load

Agency Background:

MnSCU’s data warehouse is a management information tool and not a transactional accounting system. The warehouse is used to provide data to support a wide array of critical business decisions that are made at all levels of the organization. MnSCU houses individual campus databases at one of four regional data centers. The data warehouse allows MnSCU to produce system-wide reports from these decentralized databases.

More Information

Office of the Legislative Auditor ♦ Room 140, 658 Cedar St., St. Paul, MN 55155