From: To: Subject: ASD Open Change Report - 4.11.13 Date: Thursday, April 11, 2013 8:52:00 AM Attachments: WW Attached is the ASD Open Change Report for 4.11.13 Let me know if you have any questions. Thank you, Waf?e 64.1mm IT Gatekeeper Department of Corrections Information Technology 360-725-8531 PRR.000116 PRR.000117 Open IT Requests for ASD Customers Total Open: 64 of Requests by Status Timespan: 08/17/2010 to 4/11/2013 APP RELEASE 3361 HR consolidate and renaming common ?elds in tables in SQL Server Opened: 08/17/2010 Due: 04/04/201 3 Priority: 3471 Create a snapshot table in SQL server to contain information, in order to create a historical retention for future Opened: (39/21/2010 reports_ Due: 04/04/2013 Priority: 3472 Consolidate and remove tables not being utilized in SQL Server, and add columns to existing tables. Opened: 09/21/2010 Due: 04/04/2013 Priority: 3702 Allow 620 activity to be edited or deleted on more than one GZO per cause Opened: 12/01/2010 Due: 11/21/2013 Priority: 4502 TCS - Create permission group for view all timecards with no edit capability Opened: 07/29/2011 Due: 05/30/2013 Priority: 5135 WECNVEP Program should toll for non-DOC con?nement and failure to report Opened: 02/03/2012 Due: 09/13/2013 Priority: 5328 Tolling for DOSA Revoke or CCP Return Opened: 03/20/2012 Due: 05/31/2013 Priority: 5418 I GO items-created to capture Gap 9 and Gap 10 enhancements submitted by the Business Staff current ATLAS 04/09/2012 functionality as well as paving the way for future business users (such as HS using as a roster system) Due: 12/27/2013 Priority: Printed on 4/11/2013 Page 1 of 6 PRR.000118 5419 CO Items to capture Gap9 and Gap10 enhancements to support current ATLAS functionality Opened 04/09/2012 Due: 12/13/2013 Priority: 5588 Early Deporation to ICE Opened 05/24/2012 Due: 05/24/201 3 Priority: 5711 Modify the TRACKS application to use NIPG codes for consumable inventory items when a purchase order is Opened 07/02/2012 generated. Develop and interface in CIS to retrieve purchase information from TRACKS. This requires a Due: 09/19/2013 two?way interface as the NIPG number is created in CIS and then used by TRACKS. Priority: 5760 Edit the mainline screen to 1. Add offenders assigned unit; 2. Add running count of meals scanned for each unit OPE/lad: 07/09/2012 assigned that dining hall; 3. Make all ?elds larger and easier to read from a distance. SAMPLE SCREEN Due: 05/24/2013 WITH THE lT REQUEST. Priority: 5854 Create a noti?cation in OMNI for the records mailbox where the offender is currently being supervised in OBTS. OPBHGUI 03/03/2012 The noti?cation needs to contain the date the offender changes supervision from CCI to on active Due: 03/29/2013 causes only. "*Development estimate is 4 hours and Testing effort is also 4 hours'? Priority: 5910 The new TRACKS needs the normal reporting services capabilities for SQL programs created for staff use. Opened 08/22/2012 Due: 05/24/2013 Priority: 5960 If the overall status of an offender is "closed". OSPS will close any open OSPS check dates. When the check Opened! 09/05/2012 dates are closed, delete any associated noti?cations. Due: 03/29/2013 ?Development estimate is 4 hours and test estimate is 2 Priority: 5983 Create OMNI HELP text article in regards to using the analyze prison calculations screens. Opened: 09/17/2012 Due: 05/24/2013 Priority: 5048 Update forms in the Report Wizard for Records Staff to the current forms (see attachments). Opened: 10/03/2012 Due: 05/30/2013 Priority: 5054 Earned Time Records: 1. Add the staff name of the logged on user at the time the entry is made. For entries Openecli 10/08/2012 made by the system from Prison Discipline the OMNI system would be entered as the staff. 2. There would be Due: 05/24/2013 two separate views of the earned time screen. The system would default to the current period of incarceration priority; (View Current Incarceration Only). There would be another view of (Display All Earned Time Records) that would show the history of any earned time records in the system. 3. When an offender status is closed the Earned Time Records would be stored an could be viewed in the (Display All Earned Time Records) that will be created. 6056 Update OMNI Consecutive Supervision Screen to Add Counts. Opened: 10/08/2012 Due: 07/19/2013 Priority: 6057 Update the View Screen to include the calculations or link from the View screen to previous Opened: 10/08/2012 ca cu ations, Due: 05/24/2013 Priority: 6107 OMNI Mainline - When an offender scans "Offender not at this facility" the audible alert should be "Check Openedi 1092/2012 Identi?cation". The visual alerts should still display "Offender is not at this facility" and "Regular" and the meal Due: 05/24/2013 not counted in the total meal count. Priority: Printed on 4/1 112013 Page 2 of 6 PRR.000119 6172 Add language (in attachment) to the "in re Costello" letter in Report Wizard. The change should be italicized. Opened: 11/13/2012 Due: 05/30/201 3 Priority: 5205 Mainline Scan Screen - Add the name. DOC number and meal type of the last 10 offenders scanned. Opened: 11/20/2012 Due: 07/18/2013 Priority: 6307 The application of jail credits in OMNI when there is a mandatory/enhancement that are being served as flat Opened! 12/27/2012 time needs to be changed. Due: 09/13/2013 Priority: 5345 Develop a report in the new CIS environment that shows quantities of items on hand for multiple items, Opened: 01/10/2013 quantities received, quantities used, and ending balance for any identified period of time by the warehouse Due: 07/25/2013 location in which they are housed. See attached for example of what the report should look like (each line priority; item would have a unique commodity code in CIS that is used across all the warehouses). 6404 Requesting updates for conditions in the offender sentence information page. A spreadsheet is attached with Opened: 01/30/2013 the list of narratives and conditions. OMNI has the functionality to complete an auto narrative when the Due: 07/19/2013 condition is entered on the HV (Home Visit) condition. Priority: 6423 Update the list of current Problem codes in OMNI. Add an end date on the out of date codes, add the Opened: 02/04/2013 new problems and rename other codes for consistency. This request would require code table updates only Due: 07/19/2013 and would not require any new programming. Priority: - 6652 Required for Hearings Maintenance Add Snohomish County Work Release as a location in both listed drop Opened: 04/0312013 down menus - Search Field Hearings and Create Hearing screens. Due: 05/24/201 3 Priority: FOR WORK 5728 Purchase and install 4 Genie Kiosks; 2 for each of the 2 new living units located at WSP. Opened: 07/03/2012 Due: 06/30/2013 Priority: 6055 Add Form DOC 07-023 (Registration Noti?cation) and Form DOC 07-023 ES (No Cl) Registration Noti?cation Opened: 10/03/2012 to the Report Wizard. They need to be added in the Report Category of Prisons and the Report Type of Due: 05/30/2013 Release. Priority: 6102 D00 sends a report with a list of offenders who are serving time for vehicular assault and vehicular 10/13/2012 homicide to DOL. This information needs to come from OMNI and the OBTS Flat File will need to be Due: 05/31/2013 decommissioned. Ed Beckner currently sends the report to DOL. See attachments for the information sent Priority: With the column headings. 6248 QuickBooks 2007 Replacement Project. QuickBooks 2007 is not compatible with Windows 7. Opened: 12/06/2012 Due: 06/28/2013 Priority: 6298 Requesting to add missing elements to the SQL Tables Planning and Research are currently receiving. An Opened: 12/20/2012 Excel ?le is attached de?ning the requested elements. Due: 05131/2013 Priority: 6439 OMNI is currently not programmed to apply Persistent Misbehavior (PM) sanction losses correctly, causing Opened: 02/07/2013 errors in release dates. See attached document for changes. Due: 05/24/201 3 Priority: Printed on 4/11/2013 Page 3 of 6 PRR.000120 Printed on 4/11/2013 6456 ATLAS - Requesting that inactive position numbers no longer be displayed in the Assign/Terminate/ Position Opened: (32/13/2013 Assignment Changes screen. Due: 05/24/201 3 Priority: 5478 RPM Flat File changes. speci?cally the ?at ?le is missing the program name and program type. Although it Opened: (32/20/2013 may be bene?cial to pull over all data elements associated with RPM. Due: 07/05/201 3 Priority: 6499 Requesting IT support in the Design of new IP Video System at Peninsula Work Release. The existing system Opened: 0212712013 is out dated and provides poor quality recordings and no longer provides the required 30 days of Stored Video. Due: 06/28/2013 There will also be additional cameras installed in areas that do not have coverage at this time. Priority: 6501 AHCC - The existing Door control panels for the Seg. Unit at AHCC is an old Switch and relay based system. Opened: 02/27/2013 The old switch panel would be replaced with a system. The system has also been identi?ed as a Due: 06/28/2013 Saftey and Security risk. Priority: 5502 ?Approved for the May Opened: 02/27/2013 Due: 05?31?2013 Lease 3 Dell Optiplex XE. No monitors. This is to replace 3 door control PC's that were to be used as spares Priority: for emergency replacement. 6509 Update the business rules in ECUS to send complete name variations to the State Patrol. Opened: (32/28/2013 This would be all combinations of the names as entered into OMNI. Last Name, First Name, Middle Name; Last Due: 05/24/2013 Name, First Name. Middle Initial;Last Name, First Name. These should not be considered duplicate names. priority; EXAMPLE: HAMBY. Daniel Howard. HAMBY, Daniel H. and HAMBY. Daniel if a part of the OMNI record would all be sent to ECUS and would not be considered duplicates. 6517 Create a rule in OMNI: When an entry is made into Case Management that will result in the offenders Opened! 03/04/2013 jurisdiction being closed AND the offender has an open warrant in the Category>Secretary's Warrant. Type>AI Due: 05/24/2013 Types. the following WARNING message will be displayed, "Open DOC warrant. Contact Warrants Unit to priority; cancel warrant." Staff will be able to continue with the closure at that point. A noti?cation will also be sent to the Warrants Mailbox at Headquarters (Needs to be established). Noti?cation will give Name and the following Description: "Open DOC warrant. Jurisdiction closed." 6518 Create the noti?cation "762 Hearing Complete DOSA Revoke". Without this noti?cation there is a possibility Opened: 03/04/2013 that the sentence modi?cation may not be created in OMNI which would leave an incorrect release date Due: . 05/24/2013 calculations and the offender could potentially be released early. Priority: 6520 Custody Facility Plan needs to have the rules that set the Investigation or Noti?cation ORP changed as Opened: 03/04/2013 legislation has changed since we went live with OMNI. An override process also needs to be included that will Due: 05/24/2013 allow the counselor to change the ORP type if needed as not all requirements can be captured by the system. Priority: See attached document for details. 6618 FOR MAY LEASING Open?: 03/25/2013 WCCW Replace existing perimeter detection system. DOC to provide one Dell Optiplex XE PC, and spare Due: 05/31/2013 hard drive for rapid replacement if hard drive fails. Contractor to purchase Touch Screen Monitor as part of the priority; Contract. This type of system does not work well in a Network type con?guration and will not be connected to the existing SEN at WCCW. 6443 Enable access through iPhone mobile devices to our DOC internal websites (SharePoint InsideDOC). Opened: 02/11/2013 Due: 05/01/2013 Priority: 6500 - Replace the Door Control system that operates the Exterior doors in the SOU Expansion and the Opened: 0227/2013 Vechicle Sally Port Gate. This system is operated by Minor Control during Shifts 2&3 and is transferred to Due: Major Control during Shift 1. The PC operating system and the Software that is used for the door controls is no priority; longer supported. Page 4 of 6 5469 Opened: 04/23/2012 Due: 04/19/201 3 Priority: 6214 Opened: 1 1127/2012 Due: Priority: 6550 Opened: 03/11/2013 Due: Priority: 6566 Opened: 03/12/2013 Due: Priority: 6567 Opened: 03/12/2013 Due: Priority: 6612 Opened: 03/25/2013 Due: Priority: 6649 Opened: 04/01/2013 Due: Priority: 6654 Opened: 04/03/2013 Due: Priority: DESKTOP RELEASE 6232 Opened: 11/30/2012 Due: 04/17/2013 Priority: HOLD 4836 Opened: 10/31/2011 Due: 12/31/2013 Priority: LOGGED 6400 Opened: 01/29/2013 Due: Priority: PRR.000121 Would like additional fields added to AD and present in Outlook for users to use (Personnel/ii, Job Class/Title. Accounting Code. Work Schedule, Mobile these could then be populated by Payroll from HRMS information WSP Security Electronic Expansion Project - needs the following from lT in order for the Genetec CCTV System to operate correctly. 1. An IGMP Querier setup on a Core Network switch. 2. The client stations that are required to pull up recorded video, need to have full access (be able to see all devices) on the 2 CCTV Networks and The current configuration of the system due the network design. gives the ET staff less than workable accessibility to all systems on the network. They have no easy avenue to get to all of the CCTV servers and clients on the whole campus, from their location on the West campus, or vice versa if they are on a machine on the East campus. Update the RCW's in the Master RCW Table in OMNI. Ask Marshelle for the attached list. Change the display of the scars, marks. and tattoos on the OMNI Personal Characteristic Summary Page. Requesting a price quote for the Cascade. Secretary. and Rainier Conference Rooms to have overhead projectors installed. As well as a desktop computer in each. Dawn asked to get a quote on a "smart" projector as well. Create a new security role: PREA Super User. This will be a security role above PREA Administrator (PREA 1). Authorized users in this role, will be able to modify Incident Reports and investigation data in any way and to ail ?elds. The Super User will also be able to delete the entire cases or reports. Change the modi?er rule in OMNI to capture that Conspiracy to Child Molest 1st is 33 113% ERT eligible. I am also including a copy of an email from Ronda Larson. AAG that con?rms this. include a section under cause information noting the number of prior SAC Low Level responses on the hearing prep sheets. DZO There is an upgrade to MoosLight v2.80, it is v2.81. 2.80 is prompting users to upgrade whenever they open a project. We want to get the newer version of Mooslight on the desktop release schedule. TRACKS - Allow multiple purchasers to access and process TRACKS PR documents. Requesting to have a formatted Release Date Calculation Report print from the View Prison Screen. This copy would be maintained in the central ?le. This documents how the sentence was entered. the calculations for the offender. (Example attached). MEETING 6655 Opened: 04/03/2013 Due: Priority: Allow for editing of scheduled hearings. Printed on 4/11/2013 Page 5 of 6 6656 Opened: 04/03/2013 Due: Priority: SVC MNT RELEASE 5789 Opened: 07/16/2012 Due: 04/19/2013 Priority: TRB REP REVIEW 6676 Opened: 04/10/2013 Due: Priority: WI 581 9 Opened: 07/26/2012 Due: 04/12/2013 Priority: 5851 Opened: 08/07/2012 Due: 04/16/2013 Priority: 6257 Opened: 12/10/2012 Due: 04126/2013 Priority: PRR.000122 Change the comment fields to allow for more than 500 characters in both Arrest Data and Preparation Information Field sections. A recent risk assessment by lT Security revealed that high?value con?dential data is being housed insecurely by Planning and Research. The risk assessment recommends the purchase of a robust workstation to be housed in the Department's data center. A hardcopy of the risk assessments Executive Summary has been printed for the daily triage group. Since the assessment reveals the location and protection of the high value data, it is available only on a need-to-know basis. A digital copy of the risk assessment and summary is available from either the or the IT Security Architect. The assessment describes the security recommendations, including the computer. computer con?guration. local security policy, remote security policy. data handling, remote access, and administrative controls. It is recommended that the IT Security Architect have oversight for this request. Requesting a scanning system that will allow my Food Service staff to maintain more accurate payroll records for their inmate workers. SAID - I have not seen the "program" but she is referring to is an Access database. I don't know who developed the Access database other than AHCC Cl. I will try to get a copy of the database to submit for the IT Request. Customer will then need a barcode scanner to scan Offender ID to the database. I'll talk to Rosa in the next day or so to update the request. Requesting software from IPAT (current vendor) be loaded onto DOC PC's so that the battery tests can be taken for pre employment screening for CO positions. Replace the touch screen door controls for the at WCC with 4 new Dell Optiflex XE PC's (leased), 2 IBM servers meeting DOC standards and 1 Cisco 2960 24 port POE switch. Upgrade the following PC's to Windows 7: Brad Wilkins, Alissa Beers, Kevin Boos (SW Region). Sharon McDaniel (HR). and Tom Georg. lntemal IT Change Requests are not included in this report. Status Legend Logged - the request is opened Consultation - if needed, a consultation is performed Assess - if needed, an assessment is performed TRB Rep Review - the Technology Resource Board representative for the affected business area reviews the request, consultation, and assessment Meeting - the request will go through several meetings for approval to move forward work the request has been approved for work to begin App Release - the request is scheduled for an application maintenance release (corresponds with Releases) Release - the request is scheduled as part of a Service Maintenance Release (lT classification for items which require work in muiltiple areas in 1T1 - the request is actively being worked Scheduled - if there is a particular release day, the request is scheduled at the Configuration Change Release Workgroup (CCRW - meets every Monday) implemented the request is complete and ready to be closed by the Gatekeeper Pilot - the request is being piloted at a specific location to assess whether it will be fully implemented or not Hold - the request has been placed on hold Printed on 4/11/2013 Page 6 of 6