Common use of Statement of Requirement Clause in Contracts

Statement of Requirement. list all of the Authority’s Requirements, specifications or agreed features of the Future Service to be performed. 1.1.1 The National Apprenticeship Service (NAS) are seeking to make the following changes to their Apprenticeship vacancies system to align with restructuring and policy changes being introduced. The critical success factor for this project is the delivery to the expectations of the business before the end of January 2012. This FSC will cover the Elaboration phase of the project. A key factor is the completion of the Deliverables identified in Section 1.2 – sign-off of these is the mechanism by which Stage 2: System change depends. 1.1.2 Changes to the system required for January are described below. Geography changes There have been changes to the geography structure which affect the ability to access, allocate and record data in the system as it stands today due to the introduction of divisions and the change to regions and area’s The Apprenticeship vacancies system is moving to be a centrally co-ordinated function, but with geographically based management. This will require the system to show Divisional and area geography for NAS users. Due to the physical geographical location of NAS Apprenticeship vacancies teams, there will be a need for teams, wherever they are based to be able to also view and manage the Apprenticeship vacancies system not only for their Division and Area, but to also support and undertake work within the system for other Divisions and Areas. Impact of Minimum Contract Value (MCL) To understand and accurately reflect the changes to how Providers will be contracted with and manage vacancies as a result of the introduction of Minimum Contract Value. This is where Providers will only hold contracts to deliver provision if they have a contract value over a certain amount. The system will need to show both the vacancies managed by the main contractor, but also the relationship hierarchy with vacancies managed by a sub-contractor. There will be instances where for some provision, a Provider is a main contractor but for other provision they need to be linked to another provider as they are a sub-contractor or part of a consortium arrangement. In addition Apprenticeship vacancies takes a feed of Provider information from PIMS and will therefore also need to align with the changes to PIMS following MCL changes Hierarchy Roles in LASS Create new SFA hierarchy roles in LASS for Av to use. e. g. Av:SFA Regional:User Approver, Av:SFA Division:User Approver, etc. This would match the agency’s current organisation hierarchy. The agency would need to detail whether it would be a straight mapping from lsc region to sfa region and/or division and whether sfa divisional users would require extra functionality within AVMS and therefore require additional changes to Av Replacement of the current interim solution which should be regressed once an agreed long term solution has been deployed See CCR11897 (investigation undertaken by *Removed as Reserved Information) 1.1.3 Core competencies of the supplier engaged to fulfil this role are: Extensive experience of similar sized application upgrades Extensive Knowledge of Apprenticeship vacancies and LASS Knowledge of PIMS Ability to apply and share best practice Ability to suggest, explain and demonstrate value added by changes in processes and system Ability to produce documentation easily shared or deployed with/by other Suppliers/parties 1.

Statement of Requirement. list all of the Authority’s Requirements, specifications or agreed features of the Future Service to be performed. 1.1.1 The National Apprenticeship Service (NAS) are seeking to make the following changes to their Apprenticeship vacancies system to align with restructuring and policy changes being introduced. The critical success factor for this project is the delivery to the expectations of the business before the end of January 2012. This is a Time and Materials FSC will cover the Elaboration phase of the project. A key factor is the completion of the Deliverables identified in Section 1.2 – sign-off of these is the mechanism by which Stage 2: System change depends. 1.1.2 Changes to the system required for January are described below. Geography changes There have been changes to the geography structure which affect the ability to access, allocate and record data in the system as it stands today due to the introduction of divisions and the change to regions and area’s The Apprenticeship vacancies system is moving to be a centrally co-ordinated function, but with geographically based managementone Individual Assignment. This will require the system to show Divisional and area geography for NAS users. Due to the physical geographical location of NAS Apprenticeship vacancies teams, there Individual assignment will be a need DBAD3 SQL Database Administrator to work under the instruction of the Authority The requirement is for an established SQL Server expert to assist with the management and consultancy of the YPLA and other Data Service SQL databases and other SQL related services, such as SSIS, SSRS and SSAS. The expertise needs to help us ensure the database servers are highly available, fault tolerant and of optimal configuration. It is expected that this will be delivered by two people working normal office hours (Monday to Friday 9 – 5.30pm) excluding English Bank Holidays. If one person is off, expectation is the other would cover so this would exclude them both taking holiday at the same time. The role will be directed by Removed as reserved information in the Data Service. It is envisioned that this, and an associated IA, will be replaced by a managed service provided by Cap Gemini. A Contract Change Request has been raised with Cap Gemini, discussed in the March Change Request Board meeting. Discussions are currently underway between the Data Service and Cap Gemini to agree the structure, nature and pricing of such a service. It is expected that this IA will be moved to a service within the next one to two months. Given the essential nature this role currently occupies, a temporary arrange for IA funding is required to ensure continuity of service. Activities included are: Consultancy and advice Advising on deployments Advising on Data management Advising on configuration of SQL servers or databases Advising on performance tuning approach and methodology Advising on Database design and development Advising on Architecture and system design Advising on new software solutions Advising on Security implementations Advising on Disaster recovery strategy and planning Analysis and investigations not relating to incidents Design – where analysis is complete Design of basic schemas less than 5 tables (physical) Design of basic SSIS packages without complex transformations Design of basic reports Development – where design is complete Development of basic schemas less than 5 tables (physical) Development of basic procedures (C.R.U.D) Development of basic SSIS packages (without complex transformations) Development of basic SSRS reports Development of basic SSAS cubes Documentation – where configuration is known Documentation of databases Documentation of packages Documentation of servers House keeping Deletion of development or test databases Taking of an ad-hoc database backup Shrinking of development and test database files outside the standard maintenance plans Creation of indexes Management Ensure Sale service is delivered as defined by INF-HOS09 Section 2.3 Proactive ownership of SQL Server outages or issues e.g. liaising with other Cap Gemini teams, wherever they such as the server or SAN management team Monitoring and formal ownership of Cap Gemini technical change requests that affect the environments in scope Items out of scope are based to those that would normally be able to also view undertaken by the operational DBA team and manage already included in the Apprenticeship vacancies system not only for their Division and Area, but to also support and undertake work within the system for other Divisions and AreasCapgemini contract. Impact of Minimum Contract Value (MCL) To understand and accurately reflect the changes to how Providers The above activity list will be contracted undertaken in accordance with the appropriate IM Services governance processes. A list of deliverables and manage vacancies success criteria for this role are as a result follows: Ref 001 - Document detailing roles and responsibilities of the introduction Cap DBA and MI Staff Ref 002 - Provision of Minimum Contract Value. This is where Providers will only hold contracts service as defined in Sect 1.1 above until 31 May 2012 Ref 003 - Option to deliver provision if they have a contract value over a certain amount. The system will need to show both continue service for 2012/13 financial year Success Criteria: Ongoing DBA support for the vacancies managed by the main contractor, but also the relationship hierarchy with vacancies managed by a sub-contractor. There will be instances where for some provision, a Provider is a main contractor but for other provision they need to be linked to another provider as they are a sub-contractor or part of a consortium arrangement. In addition Apprenticeship vacancies takes a feed of Provider information from PIMS and will therefore also need to align with the changes to PIMS following MCL changes Hierarchy Roles in LASS Create new SFA hierarchy roles in LASS for Av to use. e. g. Av:SFA Regional:User Approver, Av:SFA Division:User Approver, etc. This would match the agency’s current organisation hierarchy. The agency would need to detail whether it would be a straight mapping from lsc region to sfa region and/or division and whether sfa divisional users would require extra functionality within AVMS and therefore require additional changes to Av Replacement of the current interim solution which should be regressed once an agreed long term solution has been deployed See CCR11897 (investigation undertaken by *Removed as Reserved Information) 1.1.3 Core competencies of the supplier engaged to fulfil this role are: Extensive experience of similar sized application upgrades Extensive Knowledge of Apprenticeship vacancies and LASS Knowledge of PIMS Ability to apply and share best practice Ability to suggest, explain and demonstrate value added by changes in processes and system Ability to produce documentation easily shared or deployed with/by other Suppliers/parties 1Data Service.