Overview
Background
APUC (Advanced Procurement for Universities and Colleges) provides and supports an MSAccess-based Scotland-wide contract database called Hunter. This database is used by Procurement Office staff to store supplier contract details, including the supplier and product information required for display to users within the University. However, Hunter does not present this information in a format suitable for non-procurement staff and so a solution is required to interpret and present this information in a more user-friendly format. Procurement Office may also wish to supplement the Hunter database with additional University-specific data.
Scope
Out of scope
- Any updates to the Hunter database. These updates will continue to be done manually directly into Hunter as currently.
Objectives
- Improved access for University staff (& the general public) to information on contracted products and suppliers
- Reduced off-contract spend
- Improved efficiency by reducing double-entry of contract data
Deliverables
- New database for holding procurement contract data (suppliers and commodities)
- End-user interface, delivered via the University website, for searching for suppliers and commodities.
- EASE-protected Admin functionality for the maintenenace of the new database. For Procurement Office use.
- Link to APUC Hunter database to pull in the golden copy of supplier contract data.
Benefits
- Improved access to information on contracted products and suppliers
- Increased spend with contracted suppliers (reduced off-contract spend)
- Better value for money on purchases
- Improved efficiency
Success Criteria
- Data from Hunter is accurately reflected on the new web-based pages
- Procurement Office are able to maintain the data
- End users are able to search for products and suppliers and be displayed the correct results