| News Date | News Details | | 02/06/2012 | DPH HIS CDSA data extracts did not run last night. All CDSA tables are available but have data from Friday morning February 3rd. All other HIS tables are current with data available from Monday morning February 6th. | |
| 01/13/2012 | DPH HIS data extracts did not run last night.. All tables are available but have data from Thursday morning January 12th. | |
| 12/20/2011 | DPH HIS data extracts did not run last night due to a server error. All tables are available but have data from Monday morning December 19th. | |
| 12/12/2011 | DPH HIS data extracts did not run last night due to an error on the HIS database. All tables are available but have data from Monday morning November 28th. | |
| 12/06/2011 | DPH HIS data extracts did not run last night due to an error on the HIS database. All tables are available but have data from Monday morning November 28th. | |
| 12/05/2011 | DPH HIS data extracts did not run last night due to a server error. All tables are available but have data from Monday morning November 28th. | |
| 11/30/2011 | DPH HIS data extracts did not run last night due to a server error. All tables are available but have data from Monday morning November 28th. No run was made Tuesday morning because of the PM 2008 upgrades. | |
| 11/15/2011 | DPH HIS data extracts did not run last night due to a HIS server error. All tables are available but have data from Monday morning November 14th. | |
| 11/10/2011 | All Query and Web Intelligence access to CSDW is down. We are working with ITS to resolve the issue as quickly as possible. | |
| 11/10/2011 | Query and Web Intelligence access to CSDW has been restored. We continue to investigate the cause. | |
| 11/05/2011 | We are working with Sybase to resolve the CSDW server issue. Please do not login to the system until further notice. | |
| 11/02/2011 | CSDW access has been restored. Access for query is now available at 10:00 AM. | |
| 11/02/2011 | All access to CSDW is down. We are working with ITS to resolve the issue as quickly as possible. | |
| 10/26/2011 | CIP team has migrated their windows servers. CIP is still working on fixing the data feed to CSDW. The correct data available for CIP is from Oct 06, 2011. | |
| 10/21/2011 | DPH HIS data extracts did not run last night. All tables are available but have data from Thursday morning October 20th. | |
| 10/12/2011 | CIP data loaded for Oct 12, 2011 | |
| 10/06/2011 | DPH HIS data extracts did not run last night. All tables are available but have data from Wednesday morning October 5th. | |
| 09/14/2011 | DPH HIS data extracts did not run last night. All tables are available but have data from Monday morning September 12th. | |
| 09/13/2011 | DPH HIS data extracts did not run last night. A data error was encountered on the HIS DB. We have contacted the vendor for support. All tables are available but have data from Monday morning September 12th. | |
| 08/29/2011 | DPH HIS data extracts did not run last night. A data error was encountered on the HIS DB. We have contacted the vendor for support. All tables are available but have data from the morning of Friday August 26th. | |
| 08/16/2011 | DPH HIS data extracts did not run again last night. A data error was encountered on the HIS DB. We have contacted the vendor for support. All tables are available but have data from the morning of Monday August 15th. | |
| 08/10/2011 | DPH HIS data extracts ran last night after the data issue was resolved by our vendor. | |
| 08/05/2011 | DPH HIS data extracts did not run again last night. A data error was encountered on the HIS DB. We are waiting on vendor support. All tables are available but have data from the morning of Thursday August 4th. | |
| 07/21/2011 | DPH HIS data extracts did not run last night. The HIS DB server was offline. All tables are available but have data from July 20th Wednesday morning. | |
| 07/08/2011 | DPH HIS data extracts did not run last night. A data error was encountered on the HIS DB. All tables are available but have data from July 6th Wednesday morning. | |
| 07/07/2011 | DPH HIS data extracts did not run last night. The HIS DB server was offline. All tables are available but have data from July 6th Wednesday morning. | |
| 07/02/2011 | The DPH HIS Daily and Monthly Extract ran successfully Saturday morning. Data in the CSDW tables is now current. | |
| 06/29/2011 | DPH HIS data extracts did not run again last night as an error occurred on the HIS DB during the extract. All tables are available but have data from June 28th Tuesday morning. The problem is currently being diagnosed and corrected with the assistance of the vendor. | |
| 06/17/2011 | DPH HIS data extracts did not run last night as an error occurred on the CSDW server during the extract. All tables are available but have data from June 16th Thursday morning. | |
| 05/26/2011 | DPH HIS data extracts did not run last night as an error occurred during the extract. All tables are available but have data from May 25th Wednesday morning. | |
| 05/23/2011 | DPH HIS data extracts did not run last night as an error occurred during the extract. All tables are available but have data from May 20th Friday morning. | |
| 05/16/2011 | DPH HIS data extracts did not run last night. All tables are available but have data from May 13th Friday morning. | |
| 04/19/2011 | DPH HIS data extracts did not run last night. CSDW is wating on data corrections in the HIS Database.. All tables are available but have data from April 18th Monday morning. | |
| 04/14/2011 | DPH HIS data extracts did not run last night. All tables are available but have data from April 13th Wednesday morning. | |
| 04/14/2011 | The DPH HIS data extracts from last night have finished loading. All tables are available. | |
| 04/13/2011 | DPH HIS data extracts did not run last night. All tables are available but have data from April 12th Tuesday morning. | |
| 04/07/2011 | DPH HIS data extracts did not run last night as a scheduled outage for HIS critical system work ran over into the extract run window. All tables are available but have data from April 6th Tuesday morning. | |
| 03/31/2011 | DPH HIS Data was extracted last evening with no errors. | |
| 03/28/2011 | The problem has been identified with the HIS Shadow database being out of synchronization with the HIS Primary database. Corrective actions are planned for tonight. The data in the CSDW is impacted by this loss of Billing Tx Charge Detail data. Approximately 25% of the Charge Detail rows are missing and this can impact query results for any query which includes data on billing information. | |
| 03/25/2011 | The extract for the Health Information Systems Billing Tx Charge Detail Table is incomplete. A failure occurred on the HIS DB while extracting RSC 144. HP and Net Smart have been contacted to correct the problem. | |
| 03/17/2011 | CPPS Data is not available until further notice. Using current CPPS reports may not produce valid results. CSDW team is working to resolve this issue. | |
| 03/16/2011 | Net Smart has identified the problem and will have a resolution soon. This is a high priority issue and will be resolved as soon as possible. | |
| 03/15/2011 | CSDW Data Loads For 03/14/2011 are finished. All the Data for 03/14/2011 is loaded in Data Warehouse. | |
| 03/15/2011 | The extract for the Health Information Systems Billing Tx Charge Detail Table is still incomplete, the remainder of the HIS data has been loaded. | |
| 03/14/2011 | The extract for the Health Information Systems Billing Tx Charge Detail Table is incomplete. An error occurred in the HIS Database while extracting RSC 149 which stopped the extract. A ticket is open with HP and Net Smart to assist in resolving the issue. | |
| 03/01/2011 | Last evening's extraction encountered errors on all tables. The extraction process has been restarted. Until complete only data in the HIS Monthly table for 201101 is available. We regret the inconvenience. The extraction and load is projected to run at least four hours and complete no sooner than early afternoon. | |
| 03/01/2011 | All of the HIS tables have now been successfully loaded with complete data. | |
| 02/28/2011 | The HIS Billing Tx History daily data is incomplete for RSC 334 and not loaded for RSCs greater than 334. A data integrity issue was encountered in the extract and has been reported to HP and Net Smart. Data in the Monthly table is complete. | |
| 10/15/2010 | ITS is working on Datawarehouse Server Maintenance and has scheduled a downtime from 8AM to 12 afternoon on Sunday 17th Oct. The Query tool will not be operational during those hours. | |
| 10/13/2010 | CSDW is back up and running. All of the data loads from last night have finished. | |
| 09/15/2010 | Due to problems with EIS, the EIS/EPIS Daily Case and EIS/EPIS Daily Individual tables will not be loaded in CSDW for the Daily Transaction Date of 9/13/2010. | |
| 07/12/2010 | The database migration completed successfully over the weekend. All regular scheduled data loads have been completed and the CSDW is up and functional for use. | |
| 07/07/2010 | The CSDW Team will be performing a hardware migration beginning Friday July 9. The migration will create availability issues with the CSDW. The daily data from Friday July 9 will not be available until sometime during the day on Monday July 12. We willprovide an update when the data is available on Monday. You should be able to use all CSDW services on Friday. We will provide an update on CSDW availability for Monday July 12. | |
| 06/30/2010 | Central Registry Data is now loaded. | |
| 06/16/2010 | Due to problems with the Central Registry System last night, the Central Registry data in the CSDW has not run for 06/15/2010. Once the data is loaded, we will let you know. | |
| 06/16/2010 | Central Registry data for 06/15/2010 has now been loaded into the CSDW. | |
| 06/15/2010 | The CSDW Data Loads For 06/14/2010 Have Not Occurred. There Was An Issue At ITS Last Night And We Are Currently Working On It. Once Data Is Updated We Will Let You Know. | |
| 06/15/2010 | All loads for 06/14/2010 have been completed with the exception of EIS Applications Data and EPICS Daily Data. These loads should be completed later this morning or early this afternoon. | |
| 06/15/2010 | Update on the progress of Daily CSDW Loads for 06/14/2010. All data for 06/14/2010 is now loaded. | |
| 05/06/2010 | Incorrect Load Date For Food Stamp Daily Case and Individual has been corrected | |
| 05/05/2010 | EIS Applications Load For May 05, 2010 has completed. If you completed any queries using EIS Applications data prior to 11:00 AM on May 05, 2010 the report may be incorrect. Please run the query again to ensure you recieve the correct information. | |
| 03/23/2010 | CW_CENTRAL_REGISTRY will be re-run tonight | |
| 03/02/2010 | Daily Data Not loaded for 03/02/2010. CSDW is working with ITS to resolve this issue. ITS fixed the issue with HFT around 3:30 PM. | |
| 02/25/2010 | We are working with ITS to fix a issue with Business Object tool. This requires CSDW to shutdown the webi servers. It is anticipated to be back by 6PM. | |
| 02/15/2010 | Query tool is operational now. ITS has restored the Filesystem on SAN that was used by Business Object CMS. | |
| 01/12/2010 | ITS is working on Firmware upgrade on Sunday Jan 17th. This requires CSDW to shutdown the webi servers | |
| 11/24/2009 | The Applications Daily data is still in the process of being loaded into Client Service Data Warehouse for Tuesday, November 24. We anticipate this data to be loaded by early afternoon. We are sorry for any inconvenience this may have caused. | |
| 11/24/2009 | EIS Daily Application Data Now Loaded into the CSDW. | |
| 09/29/2009 | Cenral Registry Daily is loaded in Datawarehouse now. | |
| 07/13/2009 | CSDW query tool is up. You may see some performance issues. | |
| 07/10/2009 | CSDW is working with ITS to upgrade Unix Server OS version to Solaris10. You may see performance issues starting today(07/10) at 3PM. CSDW Query tool will not be available from Friday 8 PM until Monday (07/13) 8AM. | |
| 05/20/2009 | Current Central Registry data for 05/19/2009 is not loaded in the data warehouse. The latest data available in datawarehouse for Central Registry is as of 05/18/09. The Datawarehouse team is working with the Central Registry team to resolve the Central Registry load issues. | |
| 03/09/2009 | Incorrect data for February 2009 (Report Month 200902) was loaded into the SIS_Daysheet (monthly) table on March 6, 2009. This data has been removed from the table. The correct data will be loaded today by 3:00 PM. CSDW Users who ran queries using this table for February 2009 data between Friday March 6 and today should discard or disregard their results and re-run the queries after the data is replaced. This message will be updated after the table is re-loaded. | |
| 02/26/2009 | Current CIP data is not loaded in data warehouse. The latest data available in datawarehouse for CIP is as of 02/24/09. Datawarehouse team is working to resolve the CIP issues. | |
| 02/03/2009 | ITS has scheduled Production array migration between Saturday 10 AM until 12 noon Sunday. | |
| 11/10/2008 | CSDW team is working on the issue with ITS | |
| 10/28/2008 | Daily loads for data from Monday, October 27, 2008 did not occur last night. There were problems at ITS that caused the delay. The CSDW Team is working on resolving these issues and will get the data loaded as soon as possible. We will let you know whenthe data is available. | |
| 10/28/2008 | All the Daily Loads are completed and the Data is loaded in Data Warehouse. | |
| 10/09/2008 | Server Issues required restart at 15:10 system is now operational. | |
| 08/20/2008 | The Child Welfare MRS Data was last loaded on Tuesday 08-19-2008. We are working to resolve the problem with loading new data and we will post a message as soon as the problem is resolved. Thank you for your patience. | |
| 08/20/2008 | Child Welfare MRS data is now current. | |
| 07/31/2008 | The server failed in an automatic restart this morning requiring a manual restart between 7:05 AM and 7:10 AM. We apologize for any inconvenience this might have caused. | |
| 07/08/2008 | Update on tonight's Shutdown: ITS Powers off at 5:30 we shutdown starting 4:45 | |
| 07/08/2008 | Deputy State CIO Sharon Hayes has asked that I forward you the following important message: | |
| 07/08/2008 | At 7:00 PM this evening ITS will be executing an emergency change on its physical infrastructure at the Raleigh ITS Data Center. This change is critical and is being implemented to mitigate the potential risk of an unplanned total power outage to the DataCenter. Implementing this change will require that all application servers as well as the mainframe be brought down. We are advising all agencies that host applications at the ITS Data Center to shut down these applications by 5:30 PM today. | |
| 07/02/2008 | The Business Objects Servers will be unavailable later this evening, Wednesday July 2nd, from 7:00PM to 8:00PM for system maintenance. | |
| 06/18/2008 | The Help Feature in InfoView has now been fixed and is available. You should be able to use the circled blue ? button anywhere in InfoView or WebI and get help. | |
| 06/13/2008 | Business Objects is currently reporting a Universe Connection Error on all Universes. We are working to resolve this issue and will post updates as we it is resolved. | |
| 06/13/2008 | The "Universe connection error" problem has been resolved. If you encounter any problems with your reports or Business Objects please report them as usual to the DHHS Customer Support Center. | |
| 05/24/2008 | Business Objects XI has been upgraded with the latest service fixes from BO/SAP. | |
| 04/29/2008 | The Business Objects online Help is now available. This feature has been unavailable since mid-March. You can use this feature by using the blue icon question mark "?" on most screens in Business Objects. | |
| 04/24/2008 | We have a Business Objects problem this morning for DSS users for reports in | |
| 02/02/2008 | Business Objects XI has been upgraded to Service Pack 3 on Saturday Feb 2, 2008. This release improves reliability and adds compatibility with newer versions of Java. | |
| 01/15/2008 | The Business Objects Server is down. Technicians are currently working on this problem. | |
| 01/15/2008 | We are having intermittent RWI00236 errors. We have reconfigured our server and hope to have this resolved. Please report any continuing errors to the DHHS Help Desk. | |
| 12/03/2007 | URGENT! If you have not logged into the new version of the CSDW, contact your security officer for your password. You can no longer access the old version. After you get your password, click on User Tools and Info, BO XI Training for help logging in. | |
| 11/15/2007 | URGENT! The current version of CSDW will not be available after 11/30. Go to http://www.csdw.dhhs.state.nc.us/. Click on User Tools and Info/Instructions/BOXI Rollout Info/ and follow the instructions. DO THIS NOW OR RISK LOOSING SOME OF YOUR REPORTS. | |
| 10/10/2007 | Soon you will be receiving information about using a new version of the Data Warehouse Query Tool. Please complete the 8 action items that are included in the letter as soon as possible. Contact your security officer to get your new password. | |
| 10/02/2007 | Phase II - Financial Program Integrity Data from the Enterprise Program Integrity Control System (EPICS) is now available in the CSDW. For more information see Dear County Director Letter PM-REM-05-2007 located at http://www.ncdhhs.gov/dss/dcdl/index.htm | |
| 06/13/2007 | TEST | |
| 06/06/2007 | | |
| 05/02/2007 | Test Message | |
| 03/06/2007 | Low Income Energy Assistance data is available as of 03-05-2007. Dear County Director Letter # PM-REM-02-2007 detailing the information is posted at http://www.ncdhhs.gov/dss/dcdl/perman.htm. | |
| 11/14/2006 | SIS and SIS Daysheet Data are now available on a daily basis. | |
| 11/06/2006 | CSDW will be performing routine maintenance over the Veteran's Day holiday, starting on Friday, 11/10. You may experience slow-downs during this time. If your query is running slow, exit the Query Tool, shutdown and restart your browser (Internet Explorer or Netscape) and login again. | |
| 10/18/2006 | Program Integrity Data from the Enterprise Program Integrity Control System (EPICS) is now available in the CSDW. For more information see Dear County Director Letter PM-REM-10-2006 located at http://info.dhhs.state.nc.us/olm/manuals/manuals.aspx?dc=dss. | |
| 10/02/2006 | CSDW will be unavailable 10/6/2006 6:00 PM - 10/9/2006 6:00 AM for database upgrades. | |
| 10/02/2006 | Medicaid Part D for October 2006 (Report Month 200608) will be delayed due to file layout changes. Data is expected to be loaded by Wednesday, October 4th 2006. | |
| 09/11/2006 | Food Stamps for Report Month 200608 reloaded. | |
| 09/07/2006 | Daysheet Data Issue. The August 2006 Daysheet data has been re-loaded. Any queries run between 9/5/06 to 9/7/05 for August 2006 could be in error. This affects queries involving Union county and Statewide Totals. | |
| 08/29/2006 | September CSDW processing (Report Month 200609) will be delayed a few days due to database maintenance. All data loads should be complete by Wednesday, September 6th, 2006. | |
| 08/10/2006 | DSS County Expenditures has been added to the DHHS003 Universe. This table contains data from the WC-302 report for SFY 1998 to 2005. Corporate Documents and Metadata are available. Training for this table will be held at a future time. | |
| 07/28/2006 | Effective 07/27/2006, the data loaded into the EIS Facility table SCU Alzheimer's Indicator is correct. You can now resume using this data element in your queries. | |
| 07/24/2006 | CSDW will be down this weekend for routine Operating System upgrades. ITS will be applying the latest Sun patch clusters to all our database servers. | |
| 07/13/2006 | CSDW will be down the weekend of July 22, 2006 for a hardware (additional processor) upgrade. | |
| 07/09/2006 | CSDW has upgraded Business Objects to Version 5.1.9. If you encounter any problems, please contact the CSDW help desk at 919.855.3200 option 2 or csdwsupport@ncmail.net | |
| 06/30/2006 | Effective June 29, a change has been made to the data loaded into the facility table. Until further notice, please do not use the data populated in the SCU Alzheimer's Indicator. We will let you know when you can use that data again. | |
| 06/23/2006 | There are some missing individuals in the EIS App Individual data loaded for 200605. The problem is being corrected and the missing records will be populated with the next load for Report Month 200606 | |
| 05/30/2006 | The CSDW primary write node is currently down. ITS and Sun are working on the issue. This has been an ongoing issue since Saturday night / Sunday morning (5.27-5.28). I have switched access to the CSDW backup node, the latest data is from Friday night 5.27.2006. | |
| 05/30/2006 | The CSDW primary write node is currently down. ITS and Sun are working on the issue. This has been an ongoing issue since Saturday night / Sunday morning (5.27-5.28). I have switched access to the CSDW backup node, the latest data is from Friday night 5.27.2006. | |
| 04/12/2006 | CSDW Query Tool will be unavailable from Thursday, April 13th at 8:00 PM until Monday, April 17th at 5:00 AM for system maintenance. You *may* be able to login and run queries, but expect significant performance issues, or your queries returning errors.Assoon as the maintenance is completed, the headline message will be removed. | |
| 03/20/2006 | Medicare Part D data is now available for querying. | |
| 03/06/2006 | CSDW will be down Friday 3.10.2006 at 4:30 PM until Sunday 3.12.2006 at 1:00 PM for maintenance. We are moving the CSDW web server to new hardware on 3.11.2006. | |
| 02/06/2006 | The CSDW Client table has been modified to populate EIS and FSIS data on a daily basis. SIS and CSE (ACTS) will remain available on a monthly basis. | |
| 01/12/2006 | Starting today (1/12/2006) until Monday (1/16/2006) the CSDW team will be working with ITS to resolve the connection issues you have been experiencing. You may encounter connection related issued during this time. | |
| 01/09/2006 | The data warehouse will be down Sunday (1/15/2006) from 5:00 AM - 9:00 AM for maintenance. | |
| 01/03/2006 | ITS will be physically moving the CSDW Windows Servers. This will require they be bought down Sunday morning, January 8th from 6:00 AM until 8:00 AM. | |
| 12/08/2005 | CSDW Daysheet Data Issue. The November 2005 Daysheet data has been re-loaded into the SIS.Daysheet table. Any queries run between 12/5/2005 and 5:00 PM 12/07/2005 for Report Month November 2005 could be in error and should be refreshed. This issue most de | |
| 12/01/2005 | The data warehouse will be down today (12/1/0005) from 5:00 PM - 6:00 PM (1 hour) for maintenance. | |
| 11/27/2005 | The Client Services Data Warehouse Migration project is live. Please report any problems encountered to the DHHS Customer Support Center. | |
| 11/14/2005 | The data warehouse will be unavailable from Friday, November 18th at 12:00 PM (midnight) until Monday, November 21st at 8:00 AM for system backups. | |
| 11/02/2005 | CSDW Data Warehouse will be unavailable today from 12:00 (noon) until about 12:30 for emergency maintenance. ITS is replacing a fan on the machine. | |
| 10/20/2005 | Beginning October 1, 2005, Central Registry Data went from loading data monthly in the data warehouse to loading data daily. Therefore, the column named Source Data Month is no longer needed for building queries. On October 21, 2005, we will be removing | |
| 10/18/2005 | You may experience slow response or random errors today due to an excessive user load. There are currently 2 separate training sessions occurring. | |
| 10/14/2005 | The data warehouse will be unavailable from Friday, October 14th at 12:00 PM (midnight) until Monday, October 17th at 8:00 AM for system backups. | |
| 10/11/2005 | CSDW will be down Friday 10.14.2005 at 8:00 PM until Monday 10.17.2005 at 6:00 AM for maintenance. | |
| 08/19/2005 | CSDW will be down today (8.19.2005) from 12:00 until 1:00 for emergency maintenance | |
| 08/19/2005 | The data warehouse will be unavailable from Friday, August 19th at 12:00 PM (midnight) until Monday, August 22nd at 8:00 AM for system backups. | |
| 07/15/2005 | The data warehouse will be unavailable from Friday, July 15th at 12:00 PM (midnight) until Monday, July 18th at 8:00 AM for system backups. | |
| 06/10/2005 | The data warehouse will be unavailable from Friday, June 17th at 12:00 PM (midnight) until Monday, June 20th at 8:00 AM for system backups. | |
| 05/20/2005 | Changes to the Participation Rates in CSDW (Terminal Message #2005-51)Programming changes have been made to the TANF work participation rates that are available in the Client Services Data Warehouse (CSDW). These changes will be reflected when the April | |
| 05/17/2005 | Language Preference and "standard" CSDW Race fields have been added to the SIS table. Data for these new fields will start being available as of 8/1/2005; until then the Language Preference and "standard" CSDW Race fields will be NULL. | |
| 05/16/2005 | The data warehouse will be unavailable from Friday, May 20th at 12:00 PM (midnight) until Monday, May 23rd at 8:00 AM for system backups. | |
| 04/26/2005 | The data warehouse will be unavailable from Friday, April 29th at 12:00 PM (midnight) until Monday, May 2nd at 8:00 AM for system backups. | |
| 04/14/2005 | The data warehouse will be unavailable from Friday, April 16th at 12:00 PM (midnight) until Monday, April 18th at 8:00 AM for system backups. | |
| 02/17/2005 | The data warehouse will be unavailable from Friday, February 18th at 12:00 PM (midnight) until Monday, February 21st at 8:00 AM for system backups. | |
| 02/17/2005 | The data warehouse will be unavailable from Wednesday, February 23th at 4:30 PM until Thursday, February 24th at 6:00 AM for system maintenance. | |
| 02/08/2005 | CSDW Daysheet Data Issue. The January 2005 Daysheet data has been | |
| 02/08/2005 | CSDW Daysheet Data Issue. The January 2005 Daysheet data has been re-loaded into the SIS.Daysheet table. Any queries run between 02/5/2005 and 4:30 PM 02/08/2005 for Report Month January 2005 could be in error and should be refreshed. This issue most defi | |
| 02/08/2005 | Food Stamps data for report months 200410 through 200501 have been reposted to fix the race code assignment by case for multi racial cases. | |
| 01/25/2005 | POSTPONED - The data warehouse will be unavailable from Wednesday, January 26th at 4:30 PM until Thursday, January 27th at 6:00 AM for system maintenance | |
| 01/14/2005 | The data warehouse will be unavailable from Friday, January 14th at 12:00 PM (midnight) until Monday, January 17th at 8:00 AM for system backups. | |
| 01/10/2005 | FSIS Case, Individual, and Stamp History data is now available in the Client Services Data Warehouse in the DHHS003 universe on a daily basis. The table names are FSIS Daily Case, FSIS Daily Individual, and FSIS Daily Stamp History. Below are the specif | |
| 11/23/2004 | The CSE Self-Assessment Report for 2004 FFY has been removed from the data warehouse due to erroneous data. The report should be available again by Dec 1. Any reports run using the 2004 FFY should be rerun after Dec 1. | |
| 11/19/2004 | The data warehouse will be unavailable from Friday, November 19th at 12:00 PM (midnight) until Monday, November 22nd at 8:00 AM for system backups. | |
| 11/03/2004 | Applications data (Case and Individual) has been changed to drop and replace. This means there is only 1 month of data for those tables. This 1 month of data will always be the most current Applications snapshot from EIS. Also, a new column, Application_M | |
| 11/01/2004 | The Client Services Data Warehouse is back online. Currently only the last month of data is available (200409 or 200410 depending on system. The CSDW Team is currently working to reload older data. If you have any question or concerns, please contact t | |
| 11/01/2004 | EBT Data is currently available for Transaction Dates 10-22-2004 - Current. The CSDW Team is working to reload all remaining EBT data Please contact DHHS Customer Support @ dhhs.customer.support.center@ncmail.net or 919.855.3200 option 2 if you have any | |
| 10/26/2004 | The Client Services Data Warehouse is currently unavailable. We are currently working on the issue and will let you know when the CSDW is available. You may contact the CSDW help desk if you have any questions. | |
| 10/13/2004 | Due to changes required to the ACTS OCSE 157 report items, the report for 200409 will not be available until 10/30/2004 | |
| 10/08/2004 | The data warehouse will be unavailable from Friday, October 15th at 12:00 PM (midnight) until Monday, October 18th at 8:00 AM for system backups. | |
| 09/20/2004 | EIS Case and Individual tables were re-loaded for report Month 200408, Benefit Month 200409, to correct the SA data that had been created in error due to the Mass Change that occurred in August. | |
| 09/09/2004 | The Data Warehouse will be unavailable from Friday, September 10th at 12:00 PM (midnight) until Monday, September 12th at 8:00 AM for system backups. | |
| 09/01/2004 | Starting September 13, 2004, the CSDW team will set all CSDW user ids to expire after 45 days. The first time you login on or after the expiration day, you will be required to change your password. Please call the DHHS Customer Service Center (CSC) at 919 | |
| 08/30/2004 | The Client Services Data Warehouse is currently unavailable. We are currently working on the issue and will let you know when the CSDW is available. You may contact the CSDW help desk if you have any questions. | |
| 08/24/2004 | Effective September 1, 2004, the CSDW Help Desk functions will be transferred to the DHHS Customer Service Center (CSC) you already use for other applications access. The CSC will handle all password reset and new user requests directly. They will forward | |
| 08/24/2004 | Effective October 1, 2004, the SIS_SERVICES and SIS_INDIVIDUAL tables will be removed from the CSDW. The SIS table contains all of the data that is currently in the SIS SERVICES and SIS INDIVIDUAL tables. Please make sure your personal queries are now bui | |
| 08/13/2004 | The data warehouse will be unavailable from Friday, August 20th at 12:00 PM (midnight) until Monday, August 23rd at 8:00 AM for system backups. | |
| 07/21/2004 | The Data Warehouse will be unavailable from 5pm until 8pm today, Wednesday 7/21/2004, for emergency maintenance. A CPU on a system board will be replaced per Sun recommendation. | |
| 07/20/2004 | The Data Warehouse will be unavailable from 4am until 12pm (noon) on Sunday, 7/25/2004, for emergency maintenance. A CPU on a system board will be replaced per Sun recommendation. | |
| 07/09/2004 | The data warehouse will be unavailable from Friday, July 16th at 12:00 PM (midnight) until Monday, July 19th at 8:00 AM for system backups. | |
| 07/07/2004 | CSDW Daysheet Data Issue. Due to a source file issue with the June 2004 SIS Daysheet data, the totals for a few counties are not correct. This means that statewide totals for data from the Daysheet table may also be incorrect for Report Month June 2004. I | |
| 07/07/2004 | CSDW Daysheet Data Issue. The June 2004 source file issue has been corrected and the data has been reloaded into the Client Services Data Warehouse, however any queries run between 7/1/2004 and 7/7/2004 for Report Month June 2004 could be in error and the | |
| 07/02/2004 | Due to technical problems, the EIS Data for June (ReportMonth 200406) was loaded incorrectly. It is in the process of reloading today. If you have executed any queries against the 200406 EIS data, you will need to re-execute them later today. If you ha | |
| 07/02/2004 | | |
| 06/24/2004 | The data warehouse will be unavailable from Friday, June 25th at 12:00 PM (midnight) until Monday, June 28th at 8:00 AM for system backups. | |
| 06/11/2004 | The data warehouse will be unavailable from Friday, June 18th at 12:00 PM (midnight) until Monday, June 21st at 8:00 AM for system backups. | |
| 05/26/2004 | The data warehouse will be unavailable tonight 5-26-2004 from 5:30 PM until 11:00 PM for system maintenance. | |
| 05/13/2004 | The data warehouse will be unavailable tonight 5-13-2004 from 8:30 PM until 11:00 PM for system maintenance. | |
| 05/07/2004 | The data warehouse will be unavailable from Friday, May 14th at 12:00 PM (midnight) until Monday, May 17th at 8:00 AM for system backups. | |
| 04/14/2004 | The data warehouse will be unavailable from Friday, April 16th at 12:00 PM (midnight) until Monday, April 19th at 8:00 AM for system backups. | |
| 03/24/2004 | The issue with the DHHS003 universe has been resolved. If you experience any problems using the DHHS003 universe, please contact the CSDW Help Desk at csdwsupport@ncmail.net or 919.715.0728. | |
| 03/23/2004 | You may experience difficulty today (3-23-2004) using the DHHS003 universe. The CSDW team is currently working on the issue and will resolve it as soon as possible. A message will be posted here when this issue is resolved. | |
| 03/16/2004 | Child Support Enforcement Transaction Detail Data Issue. Any queries built on the transaction detail table will need to be rebuilt. Due to a database issue the table had to be recreated. If you have any questions, please call the CSDW help desk at 919. | |
| 02/10/2004 | Production Data Warehouse Query Tool (This site) will be unavailable tomorrow (2.11.2004) from 7:00 AM until 8:00 AM for maintenance. | |
| 02/06/2004 | Mental Health State Fiscal Year Data for 2000 and 2001 (Report Months 200013, 200113) will be temporarily unavailable. The data will be available by Monday February 9, 2004 | |
| 01/16/2004 | Beginning January 16, 2004, there is new information available in the EIS Daily Individual table and EIS Daily Case table. In the CSDW, EPIS daily data has now been combined with EIS daily data. EIS Daily Individual table is now named EIS/EPIS Daily Ind | |
| 01/16/2004 | The Client Services Data Warehouse (CSDW) will be unavailable from 12:00 (midnight) PM Friday, January 23 until 8:00 AM Monday January 26 for hardware/software upgrades. | |
| 01/15/2004 | The data warehouse will be unavailable from Friday, January 16th at 12:00 PM (midnight) until Monday, January 19th at 8:00 AM for system backups. | |
| 12/08/2003 | The Current Months SIS Day Sheet table has been re-loaded. Durham County data is available now. | |
| 11/24/2003 | The Data Warehouse will be unavailable from 5:00 PM Wednesday, November 26th until 8:00 AM Monday, December 1st for maintenance and system backups. | |
| 10/24/2003 | The data warehouse will be unavailable from Friday, October 24th at 12:00 PM (midnight) until Monday, October 27th at 8:00 AM for system backups. | |
| 10/02/2003 | FSIS Report Issue. The Corporate Report 'Recerts Due With Client Addresses' has been corrected. If you have executed this query recently, please re-execute this query. | |
| 10/01/2003 | FSIS Report Issue. The Corporate Report 'Recerts Due With Client Addresses' could possibly give incorrect results. If you have executed this query recently, please verify your results as the report_month condition may be incorrect. | |
| 09/15/2003 | The data warehouse will be unavailable from Friday, September 19th at 12:00 PM (midnight) until Monday,September 22nd at 8:00 AM for system backups. | |
| 09/09/2003 | The data warehouse will be unavailable from Friday, September 12th at 12:00 PM (midnight) until Monday,Spetember 15th at 8:00 AM for system backups. | |
| 09/05/2003 | The Client Services Data Warehouse is currently unavailable. We will update this site when the Data Warehouse is back online. If you have any questions concerning this issue, please contact the CSDW Help Desk at (919) 715-0728 or email at csdwsupport@n | |
| 08/25/2003 | The Client Services Data Warehouse is currently unavailable due to technical issues. You will be notified via this site and e-mail when the warehouse is available again. If you have any questions concerning this issue, please contact the CSDW Help Desk | |
| 08/15/2003 | The data warehouse will be unavailable from Friday , August 15th at 6:00 PM until Monday ,August 18th at 8:00 AM for system backups | |
| 07/11/2003 | The data warehouse will be unavailable from Friday , July 11th at 6:00 PM until Monday , July 14th at 8:00 AM for system backups | |
| 07/10/2003 | CSDW Daysheet Data Issue. The June 2003 source file issue has been corrected and the data has been reloaded into the Client Services Data Warehouse, however any queries run between 7/1/2003 and 7/10/2003 for Report Month June 2003 could be in error and th | |
| 07/09/2003 | CSDW Daysheet Data Issue. Due to a source file issue with the June 2003 SIS Daysheet data, the totals for a few counties are not correct. This means that statewide totals for data from the Daysheet table may also be incorrect for Report Month June 2003. | |
| 06/10/2003 | The data warehouse will be unavailable from Friday, June 13th at 5:00 PM until Tuesday,June 17th at 8:00 AM for system backups. | |
| 05/08/2003 | FSIS EBT data is now available in the Client Services Data Warehouse on a daily basis. Transaction data from the EBT vendor will generally be loaded into the data warehouse after two business days. For example, transactions from Tuesday, May 6, 2003 will | |
| 05/08/2003 | The CSDW will be unavailable from 5PM Friday, 09MAY03, for the entire evening. The CSDW could be available as early as Saturday (10MAY03). The CSDW will be available as normal Monday (12MAY03).
| |
| 05/07/2003 | CSDW Daysheet Data Issue. The April 2003 source file issue has been corrected and the data has been reloaded into the Client Services Data Warehouse, however any queries run between 5/6/2003 and 5/7/2003 for Report Month April 2003 could be in error and t | |
| 05/06/2003 | CSDW Daysheet Data Issue. Due to a source file issue with the April 2003 SIS Daysheet data, the totals for Durham County are not correct. This means that statewide totals for data from the Daysheet table may also be incorrect for Report Month April 2003. | |
| 04/30/2003 | The data warehouse will be unavailable from Friday, May 2th at 5:00 PM until Tuesday, May 6th at 8:00 AM for system backups. | |
| 04/30/2003 | The data warehouse will be unavailable Thursday, May 1st from 5:00 PM until 8:00 PM for system maintenance. | |
| 04/23/2003 | The data warehouse will be unavailable from Friday, April 25th at 5:00 PM until Tuesday, April 29th at 8:00 AM for system backups. | |
| 04/15/2003 | The client services data warehouse is currently down due to technical issues. An e-mail message will be sent as soon as the warehouse is available. This message will also be updated. | |
| 04/09/2003 | CSDW Daysheet Data Issue. Daysheet data for March 2003 loaded into the CSDW SIS_Daysheet table on the morning of April 8, 2003 was missing some data for three counties due to a problem with the source file. This issue has been corrected and the data has b | |
| 04/01/2003 | The data warehouse will be unavailable from Friday, April 11th at 5:00 PM until Tuesday, April 15th at 8:00 AM for system backups. | |
| 03/14/2003 | The data warehouse will be unavailable from Friday, March 14th at 5:00 PM until Tuesday, March 18th at 8:00 AM for system backups. | |
| 02/18/2003 | The Client Services Data Warehouse (CSDW) will be unavailable from 5:00 PM Wednesday, February 19 until 12:00 AM Thursday, February 20 for software upgrades. | |
| 02/18/2003 | The Client Services Data Warehouse (CSDW) will be unavailable from 4:00 AM Sunday, February 23 until 12:00 PM for hardware upgrades. | |
| 12/17/2002 | The SIS Daysheet table has now been updated for the 200211 Report Month after the extended deadline for keying the Daysheet information. | |
| 12/11/2002 | Due to the extended deadline for keying the Daysheet information, there may be missing information in the SIS Daysheet table. The updated data is expected to be available Monday, 12/16/2002. If you have any questions please contact the Help Desk. | |
| 11/08/2002 | CSDW Daysheet Data Issue. The October 2002 source file issue has been corrected and the data has been reloaded into the Client Services Data Warehouse, however any queries run between 11/5/2002 and 11/12/2002 for Report Month October 2002 could be in erro | |
| 10/21/2002 | CHECK HISTORY and SIS have beeen updated. ALL Check History queries will not work. Please see release e-mail for details. | |
| 10/11/2002 | The EIS Check History table has been revised and will be changed in the data warehouse on October 21, 2002. The changes to the table are complex and will cause all
existing queries in your personal folder and/or inbox folder to break. If you find that y | |
| 09/25/2002 | Work Participation data for August 2002 was loaded on September 24, 2002. However, this load did not include any updates to the Check History table used by the Work Participation reports, therefore the numbers may be incorrect. To ensure the accuracy o | |
| 08/09/2002 | CSDW Daysheet Data Issue. Due to a source file issue with the July SIS Daysheet data the totals for Durham County were doubled. This means that all statewide totals are incorrect for Report Month July 2002. There are no known issues with the other coun | |
| 06/25/2002 | New CSDW Help Desk Support Phone Number Update - The new phone number has not yet been turned on, please use the support e-mail or feedback form. We will update the urgent message when the new support phone number is available. | |
| 06/21/2002 | New CSDW Help Desk Support Phone Number - 919.715.0728. The Client Services Data Warehouse Program Management and Maintenance & Operations Team will be moving effective 6/24/2002. The current help desk support number will be changed from 919.661.5940 x | |
| 06/12/2002 | CSDW Query Tool ActiveX Error Message Solution. The Business Objects Query Tool was upgraded the weekend of June 8, 2002. In order to have access to the new functionality provided and to take advantage of the fixes that were made, a new version of the A | |
