Download complete service offering doc format of    ciw_services_definition.doc

 

1. Description of Service

The Commonwealth Information Warehouse (CIW) brings together a subset of the financial, budgetary, human resource, payroll and time reporting information maintained in dedicated and separate systems by individual agencies. CIW provides access to integrated, common data that supports timely, well informed business decisions to authorized users through a centralized and integrated repository.

This service includes:

  • Design, development and implementation of new and/or modified CIW objects (e.g., fields, tables, views, etc.)
  • Assessment of requested data for integration into the CIW
  • Data mapping
  • Development and/or enhancement of enterprise-wide data quality principles and standards
  • Management and administration of the data warehouse
  • End-user outreach activities
  • Supported infrastructure that allows participants to effectively collect, process, share and distribute related information
  • A secure CIW intranet ( http://www.iw.state.ma.us) providing both a central CIW communication platform and a users' forum to ask questions, share information and best practices, and to submit suggestions.

Support services include:



2. Service Targets/Hours of Availability

Service Requirement

Description

Service Availability

Service is available Monday 8:00 am – 11:00 pm and Tuesday through Friday 8:00 am – 6:00 pm and 8:30 pm to 11:00 pm.

Please note: HRCMS data available at 8:00 am is from previous 1 day cycle.
                    MMARS and LCM data available at 8:00 am is from previous 2 day cycle. 

Planned MaintenanceMaintenance is performed weekly as needed each Monday during which time services are not impacted. Ad-hoc maintenance requiring service interruption will be scheduled for Sunday through change control and customers will be notified in advance as part of the change control process.
Incident Management*

ITD Service Management Office has standard processes to managing incidents, requests and changes.

Outages or urgent issues should be reported by phone to receive the quickest response 1-866-888-2808.

Request FulfillmentStaff will respond to service requests during the hours of 8:00am - 5:00pm, Monday through Friday.

*Incidents, requests, or changes that are outside the scope of the defined service description or normal service hours will be direct charged to the customer.
 


3. Service Reporting

The following reporting information is provided to customers as part of this service:

Report

Description

Reporting Interval

Monthly Update

Monthly report reviewed with the CIW Executive Board summarizing the project status, post-production support and customer outreach activities.


Monthly

Maintenance Update

Monthly report and reviewed with the CIW Executive Board summarizing the status of open/closed change orders and updating priorities.


Monthly


4. Service Requests

COMiT Service Requests*DescriptionLead Time-Business Days
CIW Connectivity Support

This is a request for assistance connecting to CIW.

 

2 Days (may be longer depending upon installation requirements* )

CIW Data QueryThis is a request for query assistance within CIW.

7 Days

CIW General SupportThis is a request for general support for CIW.

2 Days

CIW Modification
HRCMS/MMARS
This is a request to add new data to the HRCMS and MMARS components of CIW.

Up to 14 Days depending on complexity of request*.

CIW Modification Other System DataThis is a request for support of other system data (including UMass, Classic MMARS, PMIS, CAPS, etc.) within CIW.

Up to 14 Days depending on complexity of request**.

*For new service requests only. To manage existing requests, please log into COMiT.
** ITD support teams will work with customers to determine the necessary lead time.
 


5. Customer Responsibilities

Users must have a UAID password to access the Information Warehouse and must protect that password. It is the responsibility of the Departmental Security Officer to confirm the business need for the user's request by checking with the user's supervisor and to notify the Information Security Unit whenever a change in the user's status affects the need for access.

For your convenience, you may also view a detailed list of customer responsibilities doc format of    ciw_services_definition.doc  .

 

6. Chargeback Rate Information

For more information on Chargeback, including an overview of the program as well as current and previous fiscal year rates, please visit our Chargeback Services webpage.

 

Cost Framework: CIW
Direct Charges:
Customer Specific - Costs Directly Charged to Customers
No.DescriptionCostAssumptions
/Comments
1Customer Specific - Costs Directly Charged to Customers

$62,550

 
 Total Customer Specific Costs

$62,550

 

 

Direct Dedicated Resources 
Salaries (AA) and Fringe (DD) Costs, Contract (U05, HH)
No.DescriptionCostAssumptions
/Comments
2aSalaries (AA) and Fringe (DD) Costs,
Contract Support (HH/U05)

$1,312,463

16 FTEs

 

 

Hardware/Software/Contracts (UU, LL, etc)
No.DescriptionCostAssumptions
/Comments
2bDell Software-ColdFusion Enterprise 9 (2 CPU) to support Security Office's In-Tempo application

$1,310

 
 IBM Eff. FY12, Cognos Impromptu Web Reports Legacy (E06B9LL = 266; E06BALL = 2)

$42,695

 
 IBM IBM Software ESSO Amendment 1-Additional ITD portion Plus 2 yrs of support at $38k annually (Will roll throughout contract term)

$136,291

 
 IBM-IBM Software - ESSO Amendment 3 - ITD Netezza

$38,000

 
 SHI Information Power Center Upgrade 9.0 (prior version covered under BI000043)

$71,954

 
 Depreciation

$0

 
 Other Costs, Re-Classifications, Adjustments

$3,637

 
 

Total Hardware/Software/Contracts Costs

$293,887

 

Indirect Costs:

Allocated Shared Resources
No.DescriptionCostAssumptions
/Comments
3aAllocated Shared Resources

$7,017

 

 Total Allocated Costs

$7,017

 

Shared ITD Data Center Services
No.

Service Offering

Rate CodeTitleRate#UnitsCost
4Dedicated x86 Platform SupportSV110 

 

96

$82,272

 Data - ArchiveSH000 

$0.0190

0.0300

$0

 Data - Data Backup and RecoverySG100 

$0.2275

2,664

$606

 Data - Non-Prime I/O OperationsSB1N0 

$0.0067

1,155

$8

 Data - Non Prime CPU TimeSA1N0 

$133.4900

3.8

$507

 Data - On-line Data Storage (DASD)SF090 

$0.0390

106.9

$0

 Data - Platinum (Symmetrix)SF0K0 

$0.0640

32,850

$2,102

 Data - Silver (Clarion Auto-tier FC, SATA)SF0C0 

$0.0170

31,390

$534

 Hosting - Linux OS SupportSV120 

$312

24

$7,488

 Hosting - Non-Prime I/O OperationsSB0N0 

$0.0132

11,080.7

$146

 Hosting - Non-prime CPU TimeSA0N0 

$33.27

2.7736

$92

 Hosting - Prime CPU TimeSA0P0 

$85.81

.3809

$33

 Hosting - Prime I/O OperationsSB0P0 

$.0322

122.9

$4

 Hosting - Shared VMWare Platform SupportSV350 $160228$36,480
 Hosting - Windows OS SupportSV210 $203180$36,540
 Unified Communications - 1000 Mpbs Campus Routed/SwitchedSJ1R0 $2,35948$113,232
 Unified Communications - SNA Connect TimeSJ200 $0.0034256$1
 

Total Shared ITD Data Center Costs

    

$280,045

 


Allocated Costs Not Specific to Service
No.DescriptionCostAssumptions
/Comments
5aAllocated Costs Not Specific to Service

$299,144

 
 Total Allocated Costs Not Specific to Service

$299,144

 

Allocated Commonwealth Information Warehouse to MMARS (60%) and HRCMS (40%)
No.DescriptionCostAssumptions
/Comments
5bAllocated Commonwealth Information Warehouse to MMARS (60%) and HRCMS (40%)

($2,192,555)

 
 Total Allocated Commonwealth Information Warehouse to MMARS (60%) and HRCMS (40%)

($2,192,555)

 
Adjustments:

Less: Customer Specific -  Costs Directly Charged to Customers 
No.DescriptionCostAssumptions
/Comments
6Less: Customer Specific -  Costs Directly Charged to Customers

($62,550)

 
 Total Less: Customer Specific -  Costs Directly Charged to Customers

($62,550)

 

Total Expenses for CIW

$1
 

 

Rates pertaining to this service offering include:

Rate Code

Title

Billable Unit

Planned FY2013 Units

Cost

FY 2013 Rate

NoneCIW Costs are recovered via the MMARS & HRCMS rates (60% - 40% respectively) 

 

 

 

 

Download the cost framework for CIW pdf format of    CIW 2013   
Download a complete listing of all chargeback rates xlsx format of    fy13 chargeback

 


Updated December 6, 2012
Published August 14, 2009
Created April 16, 2009: Information provided by the Enterprise Application Services Team