Download the 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 and Metrics

Targets

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*

MassIT 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:00 am - 5:00 pm, Monday through Friday.

 

Metrics

Performance

Description

Measurements

Query PerformanceQuery performance metrics are being introduced in future Service Level Objective (currently under development).Performance in seconds

Availability

Description

Measurements

Data AvailabilityData availability (i.e. when does data become available in warehouse) is being introduced in future Service Level Objectives (currently under development).System opening times

*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 will be made available to the CIW Governance Board summarizing the project status, post-production support and customer outreach activities.

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.
** MassIT 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: Commonwealth Information Warehouse

1. Direct Charges to Customers

1A. Customer Specific - Costs Directly Charged to Customers
DESCRIPTIONCOST
 $0
Total 1A. Customer Specific - Costs Directly Charged to Customers$0
Total 1. Direct Charges to Customers$0

2. Direct Dedicated Resources

2A. Direct Costs - Salaries (AA) and Fringe (DD), Contract (U05, HH)
DESCRIPTIONFTECOST
Direct Costs - Salaries (AA) and Fringe (DD), Contract (U05, HH)17.00$1,388,245
Total 2A. Direct Costs - Salaries (AA) and Fringe (DD), Contract (U05, HH)17.00$1,388,245
2B. Hardware / Software / Contracts (UU, LL , etc)
DESCRIPTIONCOST
- Dell Software-ColdFusion Enterprise 9 (2 CPU) to support Security Office's In-Tempo application-$1,368
- IBM-Eff. FY12, Cognos Impromptu Web Reports Legacy (E06B9LL = 266; E06BALL = 2)-$48,000
- IBM-IBM Software - ESSO Amendment 1- Additional MassIT Portion) Plus 2 yrs of support at $38k annually (Will roll throughout contract term)-$136,291
- SHI-Informatic Power Center Upgrade 9.0 (Prior version covered under BI000043)-$74,113
-Other costs, Reclassifications, Adjustments-$21,274
Depreciation$0
Total 2B. Hardware / Software / Contracts (UU, LL , etc)$281,047
Total 2. Direct Dedicated Resources$1,669,292

3. Indirect Costs

3A. Allocated Shared Resources
DESCRIPTIONCOST
 $0
Total 3A. Allocated Shared Resources$0
Total 3. Indirect Costs$0

4. Indirect Costs

4A. Shared MassIT Data Center Services
DESCRIPTIONRATECODERATEUNITSCOST
Data - Data Backup and Recovery -SG100$0.1699633936$107,706
Unified Communications - 1000 Mpbs Campus Routed/Switched-SJ1R0$188548$90,480
Hosting - Dedicated x86 Platform Support***-SV110$77712$9,324
Hosting - Linux OS Support-SV120$37436$13,464
Hosting - Windows OS Support-SV210$14084$11,760
Hosting - Shared VMWare Platform Support*-SV350$146228$33,288
Data - Silver (Clarion Auto-Tier FC, SATA)-SF0C0$0.02229658$652
Total 4A. Shared MassIT Data Center Services   $266,674
Total 4. Indirect Costs$266,674

5. Allocated Costs

5A. Allocated Costs Not Specific to Service
DESCRIPTIONCOST
Allocated Costs Not Specific to Service$295,707
Total 5A. Allocated Costs Not Specific to Service$295,707
5B. Allocated Commonwealth Information Warehouse to MMARS (60%) and HRCMS (40%)
DESCRIPTIONCOST
Allocated Commonwealth Information Warehouse to MMARS (60%) and HRCMS (40%)-$2,231,673
Total 5B. Allocated Commonwealth Information Warehouse to MMARS (60%) and HRCMS (40%)-$2,231,673
Total 5. Allocated Costs-$1,935,966

6. Management Adjustments

6A. Management Adjustments
DESCRIPTIONCOST
 $0
Total 6A. Management Adjustments$0
Total 6. Management Adjustments$0

Grand Total: Application Services - Commonwealth Information Warehouse

$0

7. Rates Pertaining to this Service

7A. Rates Pertaining to this Service
SERVICE OFFERING / TITLE / BILLABLE UNITRATECODERATEPLANNED UNITSCOST
  $ $0
Total 7A. Rates Pertaining to this Service   $0

 

Download a complete listing of all chargeback rates   


Updated August 12, 2014
Reviewed August 12, 2014
Published August 14, 2009
Created April 16, 2009: Information provided by the Enterprise Application Services Team