Docstoc

Pre Cana Certificate

Document Sample
Pre Cana Certificate Powered By Docstoc
					                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                   Description                                                           Additional Notes                                                 Technical Notes                        Issue           Actual
ID         ule                                                                                                                                                                                                                                   Source          Completion
                                                                                                                                                                                                                                                                 Date
artf1098   Booking       Booking Charge    Booking Charges         Sgt Moriarty was specifiying about an important functionality         SPL                                                                                                     Sgt. Moriarty   5/27/10
                         Link                                      related to booking charges. He wants to see all the booking           ----------
                                                                   charges on the offender profile and his view only the booking staff   get_booking_charges
                                                                   can now see it and even they would have to go through booking         get_ofndr_counts
                                                                   records and and booking reason to see those charges. Do we have
                                                                   anyplace where they can see all the booking charges of the
                                                                   offender. Please review with Prasanth if you have questions           APP FILES
                                                                                                                                         --------------------------------
                                                                                                                                         web/WEB-INF
                                                                                                                                         struts-config-ftrack.xml

                                                                                                                                         src/otrack/omp/offenderdesktop
                                                                                                                                         OffenderSearchProcessorImpl.java
                                                                                                                                         OffenderProfileCountVO.java

                                                                                                                                         web/jsp/offender
                                                                                                                                         OffenderProfile.jsp
                                                                                                                                         bookingCharges.jsp


                                                                                                                                         web/jsp/booking
                                                                                                                                         offenderInformation.jsp

                                                                                                                                         src/otrack/ftrack/offender/offense
                                                                                                                                         BookingViolationVO.java
                                                                                                                                         CurrentOffenseAction.java
                                                                                                                                         CurrentOffenseProcessorIfc.java
                                                                                                                                         CurrentOffenseProcessorImpl.java
artf1203   Booking       Booking outside   Validation of Booking   the http://146.63.70.84/acoms should allow for validation of          Micheal Philips (Barrow PD) - TO CONFIRM IN UAT                                                         Barrow PD       6/12/10
                         Firewall          outside firewall        offenders.

artf1126   Booking       Booking Sheet     Booking Sheet Issues    1. The DOB on the booking sheet is incorrectly formatted as           per Sgt. Moriarity:                                                  HibernateOffenderBookingDAO.java   James Dabbs-    6/3/10
                                                                   YYYY/MM/DD - should be MM/DD/YYYY                                     "David, I booked a test offender in the training server. The         BookingReportsBean.java            Ashworth
                                                                   2. Offender# 172719         Moses, David Hubert - receiving error:    booking sheet appeared to print everything that I put in. I did not
                                                                   null pointer exception                                                test with a photo, as I do not have that capability in my office. It
                                                                   3. When attempting to generate a booking sheet - error                looked right to me though."
                                                                   generating. (333747)
                                                                   Error calling action method of component with id                      Sgt.Moriarty - TO CONFIRM.
                                                                   offenderBookingListBean:printLink                                     Chowdhry will test. Passed QA - Chowdhry
                                                                   Caused by:
                                                                   java.lang.NullPointerException -
                                                                   /jsp/booking/offenderBookingList.jsp(67,4)
                                                                   '#{bookingReportsBean.bookingRecordReport}'
                                                                   java.lang.NullPointerException
                                                                   4. These two #s were booked in last night. But get a server error
                                                                   when attempt to print out their booking sheets. Other booking
                                                                   sheets print fine. 501499, 199839
                                                                   5. The other thing he addressed was the Booking Sheet (Height,
                                                                   Sex, Hair, Weight, Eye, or Physical Address are not showing at this
                                                                   time). I am sure this has been addressed, but still wanted to
                                                                   mention it.
                                                                   6. COURT CASE AND CHARGE DETAILS ARE NOT COMING UP IN
                                                                   THE BOOKING SHEET AT ALL (Mantis 2307)
                                                                   7. Addresses. There is a Mailing list checkbox and a mailing list
                                                                   drop down. If someone's PHYSICAL address is also their mailing
                                                                   address, it wont show up on the booking sheet. We have to select
                                                                   mailing list drop down and Mailing list check box to get a physical




                                                                                                                                                                                                                                                                     Page 1 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                  Description                                                            Additional Notes                                                     Technical Notes                                          Issue            Actual
ID         ule                                                                                                                                                                                                                                                         Source           Completion
                                                                                                                                                                                                                                                                                        Date
artf1216   Booking        Booking Sheet    Booking Sheet - ATN    The booking sheet is only printing 8 of the 9 digits of the ATN        6/9/10: Received confirmation that this was approved in              Jasper                                                   Sgt. Moriarty    6/8/10
                                           Number                 number. As a result ALL fingerprints submitted to DPS since we         produciton - Sgt. Moriarty                                           --------
                                                                  went live are missing a digit on the ATN… We need this fixed                                                                              Offenses.jasper
                                                                  ASAP to ensure the fingerprints sent match to the correct criminal     6/9/10: validated offender 391083 in production - sent sample to
                                                                  arrest.                                                                Sgt. Moriarty for confirmation - Looks good.                     Extended ATN number to display completely in booking sheet
                                                                                                                                                                                                          report.
                                                                                                                                         Sgt Moriarty - TO CONFIRM IN UAT.
                                                                                                                                         Expected PROD deploy - 6/8/2010

                                                                                                                                         Validated offenders: 525544 and 525515 in QA environment
                                                                                                                                         Awaiting Move code to QA

artf1192   Booking        Pre-Booking      Offender Booking       The Offender Booking Listing fields are spliting on the screen. This   6/15/10: Validated offender #525515 & 12 in the .                                                                             Various          6/16/10
                                           Listing - modjk        appears to be modjk issue.                                             84 server - screen is displayed correclty - no longer split on teh
                                                                                                                                         reasons.

                                                                                                                                         6/14/10: Unable to validate fix in QA environment as we do not
                                                                                                                                         have a modjk environment - this will need to be tested in the UAT
                                                                                                                                         enviroment - sever 84 to validate.

                                                                                                                                         6/14/10" Identified that the "pre-booking" screen was fine in
                                                                                                                                         prod - the issue now resides with the "Offender Booking Listing"
                                                                                                                                         Screen.
artf1224   Booking        Property         Property - Error       Unable to add property through booking - receiving error:              6/16/10: Email sent to Jennifer to validate in training. No          src/otrack/booking/view/jsf                              Jennifer         6/16/10
                                           Received               Exception while calling encodeEnd on component : {Component-           response from Jennifer - contacted Sgt. Moriarty (per Don) - no      PersonalPropertyItemBean.java                            Schwartz
                                                                  Path : [Class: org.ajax4jsf.component.AjaxViewRoot,ViewId:             response - validated based on my test to proceed to production.
                                                                  /jsp/booking/personalPropertyItemDetail.jsp][Class:                                                                                         src/otrack/booking/dao/hibernateDAO/baseObjects
                                                                  javax.faces.component.html.HtmlForm,Id:                                6/15/10: Processed property on offenders: 525515 and 12              HibernateOffenderBookingDAO.java
                                                                  personalPropertyItemBean][Class:                                       through booking and directly through property - added and
                                                                  org.richfaces.component.html.HtmlPanel,Id:                             modified, no issues - no errors.                                     web/jsp
                                                                  j_id_jsp_1153843682_2][Class:                                                                                                               std_lib.js
                                                                  org.richfaces.component.html.HtmlPanel,Id:                             6/14/2010: Verified various offenders by adding property in QA
                                                                  j_id_jsp_1153843682_14][Class:                                         no adverse problems, however this needs to be tested in UAT as
                                                                  javax.faces.component.html.HtmlInputHidden,Id:                         this was not occurring in QA prior.
                                                                  prptyLockerFlag]}

                                                                  Caused by:
                                                                  java.lang.IndexOutOfBoundsException - Index: 0, Size: 0

                                                                  Note: Not occurring in QA environment - only training and
                                                                  production.

artf1202   Environment/S Image Capture    Image Capture upload The image capture needs to be able to upload pictures from                Garry Harris - TO CONFIRM IN UAT                                                                                              Gary Harris      6/12/10
           ystems                         from outside the     outside the firewall....
                                          firewall
artf1167   Environment/S Missing Offender Offender Missing     63267 - offender no longer located in system - disappeared.               Michael Partin - TO CONFIRM.                                                                                                  Michael Partin   6/3/10
           ystems                                                                                                                        need clarity from don and laurie
                                                               Offender Name: Ernest Samual Moses
                                                               Offender #63267

                                                                  Error encountered... The requested offender is not found. Please re-
                                                                  search for the offender.

artf1151   Environment/S MODJK             MODJK ISSUE            so the apache just dished all sessions to a single tomcat server...                                                                                                                                  Patrick Schwarz / 6/12/10
           ystems                                                 resulting in an "overload" of the system and the crashing of the                                                                                                                                     Philip Rosen
                                                                  server
artf1099   Environment/S Mug Shot          Photo Image Upload     Can you confirm the url that should be showing up in the Image       Mantis 2316                                                                                                                                      5/26/10
           ystems                                                 program for ACOMS as being
                                                                  http://146.63.217.231/acoms/PhotoUpload?WSDL [^]
                                                                  I see images being saved, I see them uploading, I never see them
                                                                  show up on acoms. #14154 is most recent attempt. Everything
                                                                  appeared to work fine. but photo never shows. But Dennis tells me
                                                                  he is uploading fine!! I'm stumped. I have a call into Joe Butler on
                                                                  this and also Patrick I believe.
                                                                                                                                                                                                                                                                                             Page 2 of 48
                                                                                                                                 "HOT" Items
                                                                                                      1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                 Description                                                          Additional Notes                                                    Technical Notes                                                      Issue           Actual
ID         ule                                                                                                                                                                                                                                                                 Source          Completion
                                                                                                                                                                                                                                                                                               Date
artf1258   Environment/S Offender Search   Offender Search -     I am trying to charge Inmate Andrew Ningealook Sr. and the          6/15/10: Offender now available and verified in production.                                                                               Casey Desiena   6/15/10
           ystems                          Offender Missing      system will not bring him up under his OTIS#355299. If you type in
                                                                 his first and last name it brings him up but when you select him it
                                                                 tells you he doesn't exist. I attached a copy of the screen print
                                                                 when you type in his otis #. It brings up 2 inmates the one at the
                                                                 Wildwood Trans. Program is the one I am talking about. Can you
                                                                 help me??? I can't charge him or access his file.

                                                                 6/13/10 - Able to search in booking and retrieve, unable to access
                                                                 from other modules.

artf1119   Environment/S Password          Password Change       Receiving error when attempting to process a password change.                                                                                                                                                 James Dabbs-    6/1/10
           ystems                                                                                                                                                                                                                                                              Ashworth
artf1153   Environment/S Password          Password - Multiple   I thought I should alert you – I am able to logon using the original                                                                    Pending David Grove to bouce box on 6/1/10 to resolve issue.        Melvin          6/12/10
           ystems                          Saves                 temp password assigned to me by D.O.C., as well as the password I                                                                                                                                             Torgerson
                                                                 changed to after the temp password, as well as the password I
                                                                 changed to after that one.
                                                                 So, I can log on to ACOMS with no less than 3 separate and distinct
                                                                 passwords, using my same logon ID. (I’ve not changed to a 4th
                                                                 password)
                                                                 I created the 2 new passwords yesterday afternoon, and I’m
                                                                 still able to use all 3 of them, now.
                                                                 I have checked this same condition with my Lead Worker in the
                                                                 unit – he can use all 3 of his passwords as well.

                                                                 By the by, regarding the first change from the temp password,
                                                                 supplied by D.O.C.: ACOMS would not allow a change to some
                                                                 other password that didn’t contain the temp password – we
                                                                 were issued the password Newpass1 as the temp password;
                                                                 ACOMS would only allow us to change to a password that
                                                                 contained Newpass1, in our case, we changed to Newpass1234;
                                                                 then, we had to come back in (90 seconds later) and change
                                                                 Newpass1234, to some completely different password of our
                                                                 choice.
                                                                 Also, after a password change, it wasn’t real obvious that I’d
artf1208   Environment/S Permissions       Delete Rights         changed the password –rights removed, it causes null pointer
                                                                 When the user has delete the fields into which I entered the           6/15/10: Identified that there needs to be additional restrictions This causes alot of errors when the application is running            ADOC          6/8/10
           ystems                                                exceptions in screens                                                  based on multiple groups - additional ticket opened.
                                                                                                                                                                                                           #1208
                                                                                                                                        6/14/10: Lori validated in conjunction with Sgt. Moriarty -         Fix:
                                                                                                                                        appears to be good, however would like additional testing to be      - was getting null pointer/exceptions because of comparision of 'D'
                                                                                                                                        done before this issue is closed.                                  flag with 'null'.
                                                                                                                                                                                                             - also set the null comparision for 'Insert' and 'Update' as
                                                                                                                                        6/10/10 - Pending production verification from Lori                precautionary measure for future.

                                                                                                                                      From: Wharton, Lori L (DOC): The window
                                                                                                                                      insert/read/update/delete flags in the Security module appear to
                                                                                                                                      be functioning correctly in the Training application.

                                                                                                                                      The Null Pointer Exception has been fixed. As screen permission
                                                                                                                                      issues appear seprate tickets will be written.

                                                                                                                                      6/7/10: Need confirmation from Lori W - email sent. ASI unable
                                                                                                                                      to recreate issue in servier - cases processed
                                                                                                                                      Case 1:
                                                                                                                                      1. Removed delete access from 2 of the screens, Offender
                                                                                                                                      Address and Offender Scar/Marks. Has Insert and Update
                                                                                                                                      permissions = YES and Delete Permission = NO.
                                                                                                                                      2. Tried deleting the records, got error message as expected that
                                                                                                                                      ‘you don’t have delete permissions for this screen’.


                                                                                                                                      Case 2:
                                                                                                                                      1. Update Permission = NO and Delete Permission = NO. Has
                                                                                                                                      Insert Permission still = YES.



                                                                                                                                                                                                                                                                                                   Page 3 of 48
                                                                                                                                  "HOT" Items
                                                                                                       1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                   Description                                                            Additional Notes                                                      Technical Notes                                                       Issue           Actual
ID         ule                                                                                                                                                                                                                                                                       Source          Completion
                                                                                                                                                                                                                                                                                                     Date
artf1235   Environment/S Photos           Photo - Delete          We need the ability to delete back, in a very controlled fashion.   6/24/10 - UAT Approved - Issue was with modjk - resolved.                Screen: OFNDRPHOTO                                                    Don Brand       6/24/2010
           ystems                         Functionality           I’d like it to be an “IT Onlyâ€
  capability. That’s do-able,
                                                                  right?                                                              6/23/10 - UAT failed.
                                                                                                                                      6/22/10 - QA validated

artf1142   Environment/S Security         45 Minute Time-Out      Need to put a more informative message on the 45-minute                                                                                      This needs to have a good error message when exiting                  Lori Wharton    6/12/10
           ystems                                                 timeout.
artf1158   Environment/S Security         Substance - Monthly     Users are unable to access the monthly test listing screen after   Identified permission issue and resolved - verified with Sgt.             Attemtping to recreate persmissions in QA to identify the role that is Sgt. Moriaty   5/30/10
           ystems                         Test Listing            scheduling random substance tests - appears to a permission issue. Moriarty 5/30/2010                                                        causing the conflict.

artf1249   Environment/S Security         Idle Sessions           Modify the idle sessions from 8 hrs to 45 minutes - including          6/16/10: Validated by Don Brand and comfied good to go.                                                                                     Don Brand       6/16/10
           ystems                                                 tomcat.
                                                                                                                                   6/15/10: Request from Don to increase from 45 minutes to 2
                                                                  6/15/10: Request from Don to increase from 45 minutes to 2 hours hours and move to UAT.
                                                                  and move to UAT.
                                                                                                                                   6/14/2010: Session times out after 45 minutes with the follwoing
                                                                                                                                   error: Error Code 605 encountered: Session has been invalidated
                                                                                                                                   by another logon with same id, please close this browser or logon
                                                                                                                                   again.


artf1278   Environment/S Security         Delete Rights -          Determined that there needs to be additional restrictions based on    6/23/10: Ran same test in UAT - passed - confirmed by Lori                                                                                  Lorit Wharton & 6/24/2010
           ystems                         Restrictions vs. Limited multiple groups. Situation: User in multiple groups, where same       Wharton.                                                                                                                                    Don Brand
                                          Restrictions             functions exists in two or more of hte groups, however under one
                                                                   group, delete permissions exists, and under other group only view     6/23/10: Ran the following test in QA: 1.) Removed the delete
                                                                   access is available. Need to be able to user the highest level of     functionality under faciliteis for grievances - attempted to delete
                                                                   security for access and permissions.                                  received message: Error encountered... You do not have DELETE
                                                                                                                                         authorization for this screen...{0} THEN - added new group to
                                                                                                                                         user specific to delete functionality capablilties for grievances -
                                                                                                                                         no longer received error - able to delete grievnace. Approved to
                                                                                                                                         move to UAT.

                                                                                                                                         6/22/10: Ran the following test in QA: 1.) Removed the delete
                                                                                                                                         functionality under faciliteis for grievances - attempted to delete
                                                                                                                                         received message: Error encountered... You do not have DELETE
                                                                                                                                         authorization for this screen...{0} THEN - added new group to
                                                                                                                                         user specific to delete functionality capablilties for grievances -
                                                                                                                                         still received error - should have been allwed to delete.

                                                                                                                                         6/22/2010 : Completed. Awaiting QA validation.

                                                                                                                                         6/18/10: Currently being analyzed to determine approach to
                                                                                                                                         take.



artf1115   Environment/S Transportation   Transportation          OUCH! An unintended side effect of the transportation fix, I                                                                                                                                                                       5/21/10
           ystems                         Permission              suspect. In any case, introduced in the bounce/build yesterday.
                                                                  This is very hot. At shortly after 2pm yesterday, users that were
                                                                  assigned to the P&P group no longer had access to P&P. The login
                                                                  window that gives them access was removed from their group. I
                                                                  don’t have any way of knowing who or why this was deleted. I
                                                                  have given a couple of superusers rights to the User Admin group
                                                                  which also gives them access to window admin. Someone could
                                                                  have inadvertently deleted this entry since it would be the first in
                                                                  the list. The user admin functionality needs to be separated out
                                                                  from the rest of the system administration. This is a very high
                                                                  priority item. James, you need to talk to Lori about this. We should
                                                                  not be giving anyone group rights to another group. What we
                                                                  should be doing is correcting the rights in the group they are
                                                                  supposed to be in so that they have what they need. We started
                                                                                                      ,
                                                                  out with some “boilerplate―knowing that we were going to
                                                                  have to do some fine tuning as users came up to speed.



                                                                                                                                                                                                                                                                                                         Page 4 of 48
                                                                                                                                "HOT" Items
                                                                                                     1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality    Title                 Description                                                             Additional Notes                                                    Technical Notes   Issue            Actual
ID         ule                                                                                                                                                                                                               Source           Completion
                                                                                                                                                                                                                                              Date
artf1109   Environment/S Vines           Vines                 Vines interface not working                                                                                                                                   Don Brand        5/26/10
           ystems
artf1234   Environment/S Vines           Vines - Information   Several things going on this morning with Vinelink-maybe this is a      6/ 24/10: First synch done; Chris M validated and found only one                      Chris McKenzie   6/24/10
           ystems                                              known problem but thought I’d throw it out there. 
                   offender that was incorrect; Verified and CLOSED

                                                               #1- Vine has a Custody Status showing “Community                      6/22/10: Willl leave on the list until the sync is completed and
                                                               Supervisionâ€
   ….and when looked up in ACOMS, there are still       confirm that the issues reported are not ACOMS related.
                                                               incarcerated. Fortunately, I am still able to sign the POs up for the
                                                               offender notifications, which is a change. When they had this           6/18/10: Wait till Monday to talk with Gail to confirm mappings -
                                                               previously as their status, it wouldn’t let you sign up. This         run sync.
                                                               occurred with 12 out of the 22 offenders.
                                                               #2-This is my favorite- vine thinks he escaped….but he’s            6/16/10: Additional research is being done by David Grove - this
                                                               sitting at ACC-E: (281016)                                              will remain in "Pending" status until resolved.
                                                               3-This guy is incarcerated at Anvil MTN CC, but vine says he’s in
                                                               custody at Kotz Prob: (481447)                                          6/14/10: Mr. Grove is in the process of updating before the sync
                                                               #4- 3 offenders vine said were Out of Custody and I was unable to       can be accomplished - does not expect this to be completed until
                                                               sign the POs up, although they are currently IN custody.                6/16/10.
                                                               #5- 2 were not in vine, but are currently incarcerated.
                                                               #6 – only 1 offender functioned properly in both ACOMS and            6/9/10: Mr. Grove to kick-off sync on the morning of 6/10/10.
                                                               Vine.
                                                                                                                                       6/9/10: Currently being researched by Patrick. Appears to be a
                                                                                                                                       trigger that has been disabled in prod.
                                                                                                                                       Resolution: Disable cron job, Clean Vine data, refresh data,
                                                                                                                                       enable trigger, restore cron job.
                                                                                                                                       Need Chris McKenzie to validate in prod.




artf1149   Facilities    Caseload        Field PO vs. IPO      We now have our SCCC P.O’s assigned to the IPO Desktop                Left a msg for Mary Sandy to validate. David.                                         William Wyatt & 5/30/10
                         Movement        Deskktop              Group. In OTIS these P.O’s were in the Field PO group                                                                                                       Mary Sandy
                                                               consequently after the conversion their case files are assigned in      Reviewed with Mary Sandy on 06/01 she says:
                                                               the Probation and Parole Group. Is there an easy way to transfer        I went to the training module an it appears to be working now.
                                                               these case files to the IPO Desktop? Any assistance with this           Talking to the PO's they say it appears to be working.
                                                               matter would be greatly appreciated.

                                                               Thank you for getting back to me. Here are the PO’s
                                                               userID’s: olprimm, mrhinder, mmmacomb, Jrlong, jcmacomb,
                                                               rpshafer. The SUPERVISOR is cwsimons. If you need any further
                                                               information please don’t hesitate to contact me.


                                                               I know you guys are working on this issue but this is interesting.
                                                               Shows he is a field po but then next to it, it also
                                                               shows he’s an IPO. This is in the probation module. On the IPO
                                                               side they don’t show up. 

                                                               Mantis 2350




artf1117   Facilities    Custody Level   Custody Level         Need to bring over the custody levels from OTIS                                                                                                               Various          5/25/10
artf1118   Facilities    DD List Info    Location Type -       Need to add the option of "DISCHARGE" to the location type with                                                                                               Sgt. Moriarity   5/27/10
                                         Location DD           the body location DD should be D/C.
                                                               Mantis 2394




                                                                                                                                                                                                                                                  Page 5 of 48
                                                                                                                                "HOT" Items
                                                                                                     1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title               Description                                                               Additional Notes                                                  Technical Notes                                                          Issue             Actual
ID         ule                                                                                                                                                                                                                                                                      Source            Completion
                                                                                                                                                                                                                                                                                                      Date
artf1184   Facilities    Escape Desktop    Escape Contacts     The escape contacts are crossing over offenders - should only be          6/23/10 - Validated the first 5 offenders on the escape desktop   Files:                                                                   Anchorage         6/24/2010
                                                               applicable to those offenders that they were added to.                    within the UAT environment - added and removed contacts - all     -------                                                                  Training Class
                                                                                                                                         reflected correctly and did not overlap.                          \otrack\ftrack\escape\EscapeContactVO.java
                                                                                                                                                                                                           \otrack\ftrack\escape\EscapeFlyerReportAction
                                                                                                                                         6/22/10 - Validated the first 5 offenders on the escape destop by otrack\ftrack\escape\EscapeFlyerReportProcessorImpl.java
                                                                                                                                         adding new contacts, deleting contacts, validation approved.      otrack\ftrack\escape\EscapeFlyerReportIfc.java

                                                                                                                                         Awaiting Move to QA                                               Table Modified:
                                                                                                                                                                                                           -----------------
                                                                                                                                                                                                           alter table esc_flyer_cntct add ofndr_num INTEGER before
                                                                                                                                                                                                           esc_cntct_name;

                                                                                                                                                                                                           alter table esc_flyer_cntct add constraint foreign key
                                                                                                                                                                                                           (ofndr_num)
                                                                                                                                                                                                           references ofndr
                                                                                                                                                                                                           (ofndr_num)
                                                                                                                                                                                                           constraint fk_esc_flyer_r120;




                                                                                                                                                                                                           SPLs:
                                                                                                                                                                                                           --------
                                                                                                                                                                                                           get_esc_cntct
                                                                                                                                                                                                           get_esc_cntct_m



artf1139   Facilities    Facility Roster   Facility Roster -   After receiving your email I viewed our alpha roster report only to                                                                                                                                                  Sgt Dickens / Lori 5/27/10
                                           Release Date        see that scheduled release dates of the past still exists on the
                                                               alpha. Is this going to be removed it seems to be causing confusion
                                                               for those who are none security staff. Thanks Sgt. Dickens

artf1136   Facilities    Intake Report     Offender Release    The offender release history report is not retrieving any data. THis      JOE - TO CONFIRM TO QA                                            One small issue is that for Offenders who were RELEASED PRIOR TO Sgt. Moriarty             6/7/10
                                           History Report      report should reflect by court case the offender offenders arrests                                                                          THE ACOMS GO LIVE date, the RELEASE TIME does NOT SHOW. For
                                                               and releases, however currently is not puling any information. In         Report is now showing proper format and release date & time       OFFENDERS with a release date of AFTER GO LIVE, the release time
                                                               addition, need to rename the link to "Offender Intake History"            displayed                                                         DOES show.

                                                               Note: This report should pull ALL arrests and release, regardless of                                                                        Offender Intake History Report Issue Fixed.
                                                               whether or not the offender was released. (Mantis 2386)                                                                                     Now it pull offenders Booking history like booking date,booking
                                                                                                                                                                                                           reason information etc.
                                                               Please see the attached report. This is the Offender Intake History
                                                               from OTIS. I cannot find this report in ACOMS. It is an essential                                                                           05/30- Its effected todays Build.
                                                               report that shows what dates an offender was in custody on                                                                                  06/01 - passed QA tested in Qa environment, awaiting deployment
                                                               specific cases... Can this be built into ACOMS, or is it there and I am                                                                     to test
                                                               missing it? It is a critical essential report used for time accounting
                                                               purposes and verification of service dates. see attached report                                                                             failed with Sgt Moriarity:
                                                               (Mantis 2309)                                                                                                                               I tried it in the training environment, and it doesn't work at all. It
                                                                                                                                                                                                           does work in production, but the formatting cuts off part of the
                                                                                                                                                                                                           release
                                                                                                                                                                                                           date, and the release time is missing.




                                                                                                                                                                                                                                                                                                           Page 6 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                    Description                                                           Additional Notes                                                       Technical Notes                                                        Issue           Actual
ID         ule                                                                                                                                                                                                                                                                           Source          Completion
                                                                                                                                                                                                                                                                                                         Date
artf1104   Facilities    Intake Roster      Inmate Roster - Biling   I know you are swamped, but here is an issue I need addressed         6/8/10: (Jamie W.) I went into OTIS and refreshed my memory                                                                                   Jamie Walker    6/8/10
                                            to Cornell               before the end of the month, please, as it is critical to our         with the reporting feature and it looks like we DID NOT have the
                                                                     processing a very large invoice. We receive a monthly invoice from    option to pick a date range and it printed the most current
                                                                     Cornell Companies for their management of the Hudson facility, in     information based on the day you run the report. The more I
                                                                     Colorado.                                                             think about it, this will work now that the intake date is provided.
                                                                                                                                           I can tell by looking at the report when during the month they
                                                                     This invoice comes with an inmate roster prepared by Cornell          were transferred in or out. So at this point, I think we are okay
                                                                     showing who is being housed at Hudson during the billing month,       with the reporting. If something else comes up I will let you
                                                                     along with any movement of inmates in or out. This information is     know.
                                                                     critical to us, as it shows the number of inmates and the number of
                                                                     mandays used to calculate the invoice total. This is a large invoice - Don will talk to the user(Jamie Walker) on this issue. We will keep
                                                                     usually around $1.5 million each month. I have attached a              this on the list.
                                                                     page from the Cornell Hudson roster for April, indicating two
                                                                     inmates names.                                                         Check with Don.

                                                                     Our normal procedure is to print a Hudson inmate roster from OTIS     Per Jamie: this now needs to have the capability for a date range
                                                                     at the end of each month, and use this OTIS roster as a comparison    of some kind. getting clarity. REOPENED.
                                                                     against the Cornell inmate roster. This is an audit requirement set
                                                                     up by JCO Accounting. I have attached a copy of the OTIS inmate       Need to modify the "Intake Date" on the facility roster report to
                                                                     roster for April, indicating the same inmates names.                  use the start date that the offender was put in the current
                                                                                                                                           location.
                                                                     The column on the OTIS roster labeled "Intake" is the intake date
                                                                     into Hudson, and matches with the intake date indicated on the     David will call Trisha
                                                                     Cornell Hudson roster, which confirms the Cornell Hudson manday
                                                                     calculation.                                                       Per "Nancy": Patty is no longer with the department. i left a msg
                                                                                                                                        for Jamie who Patty listed as the alternative contact for this
                                                                     The current ACOMS Facility Alpha Roster, which I have attached     issue. David.
                                                                     two pages of, (again highlighting the two inmates) does not        I reviewed with Jamie Walker last night and per Jamie: I ran the
artf1276   Facilities    Legal Status       Legal Status - DD        Need to link the "deceased" with the correct status change options 6/15/10: Validated by changing the legal status of offender                                                                                      Sgt. Moriarty   6/16/10
                                            Update                   of "Died..."                                                       #5217 to deceased with a "died..." reason - no issues found.

artf1101   Facilities    Names              Offender Name            The offender John Pompura (Offender 512715) is missing from                                                                                  The offender name is coming now. The fix that i had done earlier for                   5/25/10
                                            MIssing                  ACOMS. When I search for his name, I receive the following                                                                                   another offender search issue would have fixed this one too.
                                                                     screenshot (which shows a blank name next to the Offender #).

                                                                     Original Mantis #2322

artf1107   Facilities    Numbers - Other APSIN ID Numbers            I have a problem entering some APSIN IDs numbers, if the number Joe will check prod status                                                   #2238                                                                  McKenzie,       5/30/10
                                                                     is a duplicate of the Drivers License number. Up until 2000 or so,                                                                           Fix:                                                                   Christopher
                                                                     APSIN IDs and Driver’s License numbers were the same, and                                                                                   - allowed the same number with different Number Type.
                                                                     after that they started to diverge, but when I attempt to enter an
                                                                     APSIN ID that is the same as a DL, I receive an error that the
                                                                     ACOMS does not allow duplicate numbers in this field:
                                                                     Mantis 2338

artf1225   Facilities    Offsite Location   Offsite Location -       The sql statement that selects the Location Types for Offsite         6/11/10 - Completed by Lori Wharton.                                                                                                          Lori Wharton    6/13/10
                                            Electronic Monitoring    Location currently looks for (H,O,S,U) types. It needs to include the
                                                                     ‘L’ type for Electronic Monitoring. These are offsite moves
                                                                     where the offenders will not have bed assignments.

                                                                     We are getting a back log of moves and releases due to the users
                                                                     not being able to get them into the correct location.




                                                                                                                                                                                                                                                                                                             Page 7 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                  Description                                                            Additional Notes                                                   Technical Notes                                      Issue           Actual
ID         ule                                                                                                                                                                                                                                                    Source          Completion
                                                                                                                                                                                                                                                                                  Date
artf1170   Facilities    Payroll - Report   Payroll Hours Report   Issues:                                                                6/16/10: Don to contact Jessie Miller to validate in Training.     Report format issue resolved                         Jessie Miller   6/16/10
                                                                   1. Report only generating when "both" is selected - without a job      Cyndi contacted Bernie Kohut to validate - Berniwe confirmed
                                                                   title - report MUST generate wth ALL variable options selected         report validated.                                                  Files modified:
                                                                   2. Need to remove the empty space between the lines - single line                                                                         ----------------
                                                                   not double line                                                        6/15/10: Validated 3 institutions (PT. Mac, FCC, AMCC) and         payroll_hrs.jasper
                                                                   3. Remove the "size = 10" in the header.                               produced reports for all there options: entered, not entered, both
                                                                   4. Needs to display the location in the header.                        in addition ran by specific job - all reports generated in         SPL Name: get_payroll_hrs_rpt()
                                                                   5. Report is not pulling all offenders in which received payroll       appropriate fashion as expectd.                                    Report format issue is fixed and also report looks
                                                                   added. 444471                                                                                                                             good.
                                                                                                                                          6/15/10: Validated all three types of report for Lemon Creek CC in
                                                                                                                                          the QA environment - all are reflecting correct information and
                                                                                                                                          headers.

                                                                                                                                          6/14/10: Moved report to QA TESTING.
                                                                                                                                          6/14/10: Report is generating with correct information, however
                                                                                                                                          there are a few format issues that need to be resolved before
                                                                                                                                          this can be moved forward. Returned to developer to address.

                                                                                                                                          6/11/10: 80% completed
                                                                                                                                          Returned to developer.

                                                                                                                                          Works fine in QA and Training. Did not work in PROD.
                                                                                                                                          REDEPLOY PROD.

                                                                                                                                          Jessie Miller - TO CONFIRM IN PROD.

artf1169   Facilities    Payroll hours      Payroll Hours Report   Payroll report is working in QA and test but not the live system.  Joe will follow up with Jessie                                         payrollHoursRprtButtons.jsp                          Jessie miller   6/3/10
                         report             produces an error      Producing the an HTTP error.                                                                                                              payrollHoursRprtPageFunction.jsp
artf1144   Facilities    Property           Property - Data        Data Conversion - Property items are reflecting "0" quantity       recreated disposal issue in qa - need to address.                                                                           James Dabbs-    6/3/10
                                            Conversion             making it impossible to dispose. Sgt: Tony: 1) Lots of issues with                                                                                                                             Ashworth
                                                                   property : offender 535963 had 23 property items and did not does Need to shut prod down for about 1 hour
                                                                   not come up in ACOMS. :Sgt Tony: She is also not able to dispose
                                                                   items with quantity as zero. most of the items that have been
                                                                   converted have a converted item as zero.

                                                                   Additional Issue:
                                                                   When attempting to dispose of property - item is moving to
                                                                   disposal, hwoever remaining on the active list as well - creating 2
                                                                   entries.

artf1250   Facilities    Scheduled          Schedule Release -     We are unable to schedule a release OB# 168903. Receive primary        6/15/10: Validated a variety of offenders that had previous        get_prsn_rlse_m                                      Sgt. Moriarty   6/16/10
                         Release            Primary Key Issue      key error, record already exists. Looks like the old scheduled         releases and was able to add to scheduled release list with no
                                                                   release date from last incarceration is still in the system, and it    contraint issues.
                                                                   isn’t allowing us to insert the new rls date. Please see the below
                                                                   screens.                                                               6/14/10: Validated offenders previously released by adding on
                                                                                                                                          scheduled release list for upcoming release - no primary
                                                                                                                                          constraint key message appeared and was able to release and re-
                                                                                                                                          add with no issues.




                                                                                                                                                                                                                                                                                      Page 8 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                  Description                                                                Additional Notes                                                    Technical Notes                                                           Issue            Actual
ID         ule                                                                                                                                                                                                                                                                            Source           Completion
                                                                                                                                                                                                                                                                                                           Date
artf1114   Facilities    Statewide Barred Statewide Barred       Visitor list is pretty important, but the critical element is the Barred   6/15/10: Validated new field and report - offenders 68983 &          Fix:                                                                                      6/16/10
                         Report           Report                 list. This essentially describes some encounters that must never           87623 - identified as statewide barred, appeared on report.          - stored proc was not checking for Statewide Barred code (20) to
                                                                 occue. Sex offenders must never meet with victims, child abusers                                                                               pull records. Additional fix: stored proc was not updating the
                                                                 with children, thinks like that. Need to get under the business            6/15/10: Validated report and new functionality in QA - able to     condition type cd. fixed that also. Chowdhary: will run the
                                                                 process on this one, and make sure the report is reflective of that.       update and remove on the visitor info and correctly refelcts on     conversion for this table to extract all records from old system. After
                                                                 from Gary Harris.                                                          the report.                                                         conversion, this report will pull more records.

                                                                 6/7/10 - Additional info. Identified that the current record kept is a     6/14/10: Development complete - code checked int.
                                                                 spreadsheet that is manually maintained. The desire is to have the         6/9/10: Development is 80% complete.
                                                                 system track the visitors that are barred statewide. Need to add a
                                                                 "checkbox" to the visitor information screen that if checked would         Big change - flag that determines if a visitor statewide barred.
                                                                 identify that the visitor was barred statewide; if unchecked, would        Table change , etc.
                                                                 not be barred. In addition, this needs to be the key trigger if the
                                                                 visitor is reflected on the report or not.                                 Received email from Cyndy that reflected the manual steps that
                                                                                                                                            are taken to identify and notify barred visitors.

                                                                                                                                            Cyndy will email David the spread sheet .ADOC researching
                                                                                                                                            business processes.

                                                                                                                                            David and Chowdhry called and emailed her several times. No
                                                                                                                                            response yet.

                                                                                                                                            This needs to continue to be "hot", however, it requires adding
                                                                                                                                            additional functionality to ACOMS as it requires non-offender
                                                                                                                                            information to be collected, stored, and reported. To work with
                                                                                                                                            Cheyenne Peterson to determine requirements.

                                                                                                                                        Constraint with condition linked to offender - need to identify
artf1163   Facilities    Substance        Substance Test Entry   We are continuing to have an issue with substance rest refusals        David will call Chris Mckenzie. UAT Testing - Chris McKenzie.           w_otr_s2_9.jsp                                                            Chris McKenzie   6/12/10
                                                                 which has just been compounded. If we put in a Refused Test Date
                                                                 and a Requested By officer, the system will not allow us to save the Chowdhry - TO CONFIRM IN QA.Passed QA.
                                                                 entry without putting in a Collected Date or Collected Time.           UAT Testing - Chris McKenzie
                                                                 However, if the offender refused to provide a sample, then there
                                                                 cannot be a collected date or time. Prior to this last build, we could
                                                                 leave the Requested by field blank, which bypassed this problem.
                                                                 However, with the new build we can no longer leave that field
                                                                 blank, so we have to enter a Collected Date and Time when no
                                                                 sample was actually collected.

artf1110   Facilities    Victims          Victim Issues          Attachments of three error message that popped up while I was in                                                                                                                                                         Gail Brimner     5/26/10
                                                                 the process of working in the victim module today. Yesterday I had
                                                                 no problems. Thank you Gail Brimner .
                                                                 Mantis #2351
artf1174   Facilities    Victims          Victims - Data         The victim information was stored in the otis victim_rqst table. This 6/15/10: UAT is still reflecting duplicates - developer to                                                                                         Unknown          6/15/10
                                          Conversion             table has 28,618 rows of data.                                        investigate.

                                                                 I do not see that data as having been brought over into acoms              6/14/10: Identified that in the OTIS system, if a victim was
                                                                 anywhere. Looks like possibly the wrong table was brought over.            updated it created a new history line item as a result, the
                                                                                                                                            conversion picked up each line item as a victim in error.
                                                                 Samples:                                                                   Chowdhry to delete victims in QA, rerun conversion based on
                                                                 OTN Name Number of Vics                                                    most recent victim that reflects a "null" value for the end date
                                                                 489301 Osbey, Travonti 1                                                   and re-validate.
                                                                 520920 Towndrow, Brian 2
                                                                 229335 Davis, Robert G 3                                                   6/10/10 (Don): The claim is, victim information history from ORIS
                                                                 515285 Lillie, Julian 1                                                    did not come forward. This is a very serious exposure, and a P1
                                                                 483862 Dockter, Jeanna 1                                                   condition. Items related to data conversion errors take top
                                                                 532668 Montez, Melissa 1                                                   priority, as previously stated.
                                                                 392304 Bradshaw, Joshua 5
                                                                 2379 Marrs, Patrick 1

                                                                 These were the few that I confirmed today. OTIS has that number
                                                                 of vics listed and ACOMS has none.




                                                                                                                                                                                                                                                                                                               Page 9 of 48
                                                                                                                                 "HOT" Items
                                                                                                      1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                  Description                                                          Additional Notes                                                    Technical Notes                                                         Issue           Actual
ID         ule                                                                                                                                                                                                                                                                    Source          Completion
                                                                                                                                                                                                                                                                                                  Date
artf1183   Facilities    Victims          Victim - Injury Type   1. Need to add the injury type of "UNKNOWN" to the available         6/15/10: Validated offender #5217 by adding a victim and            SF_1183                                                                 Unknown         6/16/10
                                                                 options. (Mantis 2215)                                               selecting the "UNKNOWN" injury type and entering a po box in        -------------------
                                                                 2. One change that needs to be made in the Victim module is the      the first line of the address - no issues found.                    insert into injury_typ_cd values("U","UNKNOWN", "Y");
                                                                 address. As you tab to ‘House Number’, it only allows so                                                                             alter table victim modify (psda_num CHAR(20));
                                                                 many characters in the space provided and you cannot enter a PO      6/14/2010: Validated victims in QA by applying victim type of       alter table victim modify (alt_psda_num CHAR(20));
                                                                 Box 222222. All rural area’s have PO Boxes, plus victims usually   "Unknown" - passed test.                                            get_victim_m
                                                                 get a PO Box for safety reasons.                                                                                                         get_victim

                                                                                                                                                                                                          APP_FILES
                                                                                                                                                                                                          ---------------------
                                                                                                                                                                                                          OffenderVictimVO.java
                                                                                                                                                                                                          w_psi_s5_15.jsp
artf1205   Facilities                     Date on ID card not    The DOB on the id card is truncating portions of the year. Not       Don to BE UAT                                                       SF_1205                                                                                 6/12/10
                                          formated properly      attached example. This only seems to be the case                     Joe - TO CONFIRM IN QA.                                             --------------------
                                                                                                                                      UAT - ASK Don.                                                      IDCard.jasper
                                                                                                                                                                                                          IDCard.jrxml
artf1159   Inmate        Account Status   Indigent Status -      Receiving the following error when attempting to change a bank       6/23/10: Validated UAT by changing account status to each of        Constraint issue related to the location linked to the status           Cyndi Stegall   6/24/2010
           Banking                        Severe Error           status to indigent.                                                  the available status's - validation complete.                       transaction.

                                                                 [SEVERE] 10/05/29 11:17:17                                           6/22/10: Validated in QA                                            Fix:
                                                                 OffenderAccountStatusProcessorImpl.saveRecord: Process                                                                                     - Facility ID was null, due to which null pointer was coming, Now
                                                                 Completed Un-Successfully.                                           Joe found it failed for few offenders and email Amit the list. Amit passing the logged in user facility id.
                                                                 [SEVERE] 10/05/29 11:17:17                                           working on it.
                                                                 OffenderAccountStatusProcessorImpl.saveRecord: SQLException:
                                                                 java.sql.SQLException: Process Completed Un-Successfully.            Amit has shown that it works with several other offenders. Joe is
                                                                 [SEVERE] 10/05/29 11:17:17                                           sending Amit other offenders in order to better understand the
                                                                 OffenderAccountStatusProcessorImpl.saveRecord: SQLException:         issue.
                                                                 java.sql.SQLException: Process Completed Un-Successfully. error      I cannot generate the error in QA. I changed Offender # 24 to
                                                                 Code -391                                                            Indigent Status and it worked fine. Please let me know the steps
                                                                 [SEVERE] 10/05/29 11:17:17                                           you are doing in order for me to generate the error.
                                                                 OffenderAccountStatusAction.saveBalance: Exception:
                                                                 class=otrack.ota.account.OffenderAccountStatusProcessorImpl,me
                                                                 thod=saveRecord,message=Process Completed Un-
                                                                 Successfully.,date=Sat May 29 11:17:17 MDT 2010errorCode=-391



artf1105   Inmate        Bank Deposit     Bank Deposit           Bank deposit done for WCCC, however reflects multiple entries for                                                                         - Modified the Stored Proc to return right facility id when updating   Devra           6/12/10
           Banking                                               checks not receipted in at WCCC.                                                                                                         the deposit ids.

                                                                 Mantis #2399
artf1223   Inmate        Check printing   Check alignment        The information Printed on checks is not aligned properly.           6/11/10: Validated by Amy Weichert - looks good.                     Fix                                                                    DOC Accounting 6/12/10
           Banking                                                                                                                                                                                         ------
                                                                                                                                      6/9/10: Minor correction to move 1 space to the right as the         rep_chk_req_Detail.jasper
                                                                                                                                      "order of" is too close to the label. Once completed - Joe will test SPL : get_rpln_chk_detail_rpt.
                                                                                                                                      on "true" check stock to validate alignment in Juneau.
                                                                                                                                                                                                           Now able to print check without overlapping text.
                                                                                                                                      The alignement aspect is extremely important especially for the
                                                                                                                                      Key Bank transmission acceptance.




                                                                                                                                                                                                                                                                                                     Page 10 of 48
                                                                                                                               "HOT" Items
                                                                                                    1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality   Title                  Description                                                             Additional Notes                                                     Technical Notes                                                          Issue          Actual
ID         ule                                                                                                                                                                                                                                                                       Source         Completion
                                                                                                                                                                                                                                                                                                    Date
artf1148   Inmate        Commissary     Commissary - Import    Have they set up anything for the commissary batches or will we         6/11/10 - Worked with Casey - processed a batch.                     #1148                                                                    Various        6/12/10
           Banking                                             really have to start doing all the data input for every prisoner                                                                             - JSP was calling double form action, due to which report was not
                                                               commissary order each week? Has this new process been                   6/9/10: Validate QA and UAT - Please note: When processing a         getting displayed
                                                               organized thru General Sales?? Is there an update on how long we        commissary batch, if the effective date is different from the        Works fine now.
                                                               will have to been doing this??? It is opening us up to all kinds of     current date, the user will need to enter the date on the Offender
                                                               errors doing it this way….How do we refund commissary?                Commissary Batch screen, otherwise it processes for current date    #1148
                                                               According to the video I don't believe they have set up any way to      if not modified. I tested both and worked fine.                      - Implemented the 'browse file' capability from file system.
                                                               refund the inmates on batches. Currently we use the "Commissary                                                                              - Changed the logic to process the original txt file as in attachment.
                                                               Returns" function when we need to refund money to the inmates           6/9/10: File is complete - report is not returning proper contents. - PS: Report is not pulling the current batch info but all records from
                                                               (if they transfer, items are broken, wrong items, etc.) We also use                                                                         previous batches. Although, it can be verified from goiing into
                                                               the Commissary Returns function to refund money to inmates for                                                                              Offender Account -> Offender Bank Balance and hit retrieve button
                                                               any of the Non Offender Check Accounts (Inmate Council, BACED,          Final touches being done - FTP ing the file .
                                                               Native Culture Club, Medical Co-Pay, etc.) Have the new codes           Will be completed today - 6/8/2010                                  Files:
                                                               specific to each Institution been created for us yet?                                                                                       ------ committed to SVN
                                                                                                                                       Amit found that the requirements were not complete. Amit will
                                                                                                                                       discuss with Joe again.                                             comsrybtch.jsp
                                                                                                                                                                                                           commissary_btch.jasper
                                                                                                                                       Amit completed everything except the report.
                                                                                                                                       Senthil working on report. Will be completed 6/3/2010.

                                                                                                                                       Report part is completed by senthil. Code is waiting for QA
                                                                                                                                       review.

                                                                                                                                       Patrick - TO CONFIRM IN QA
                                                                                                                                       UAT - Ask Don

                                                                                                                                       import file sample attached now
                                                                                                                                       f1 = transaction ID
artf1147   Inmate        Interface      Key Bank - Interface   Got off the phone with Treasury - they haven’t received the           6/9/10: • Confirmation of a successful import of last night’s    ak_keybank_data_extract()                                                Kevin Worley   6/8/10
           Banking                                             download file they typically got out of OTA - this needs to be on the   prod transmission file was received this morning from Key Bank
                                                               list for fixes since we interface with KeyBank and let them know        representatives.                                                  I think it is this query:
                                                               cancelled and stop pay checks as well as what is issued.                • Confirmation by Devra that the transmission file data sent    SELECT LPAD(a.trst_bnk_acct_num,15, 0),
                                                                                                                                       last night is actively filtering checks.                          d.void_rsn_cd, LPAD(d.chk_num, 10, 0), TO_CHAR(d.disb_dt,
                                                                                                                                                                                                         '%Y%m%d'), LPAD(REPLACE(d.disb_amt, "."), 10, 0), p.payee_lname
                                                                                                                                       6/9/10: File sent on 6/8/10 - pending confirmation from Key       last_name, p.payee_fname first_name, p.payee_m_initial middle
                                                                                                                                       Bank. There were a total of 460 checks, includes voided checks. FROM trst_bnk_disb d, trst_disb_payee p, trst_bnk_acct a
                                                                                                                                       Joe to comfirm with Key Bank transmission received and            WHERE p.payee_id = d.payee_id
                                                                                                                                       acceptable. In addition, have Devra and Kevin validate checks on AND a.trst_bnk_acct_id = d.trst_bnk_acct_id
                                                                                                                                       website.                                                          AND disb_amt > 0
                                                                                                                                                                                                         AND (a.trst_bnk_acct_num = 681014068 or a.trst_bnk_acct_num =
                                                                                                                                       6/8/10:(Joe) I just received confirmation from Key Bank that the 729681014068)
                                                                                                                                       last file we sent has been validated, yeah!. The next step is to  AND ((chk_dt_tm > (l_yesterday || " 18:00")) and (chk_dt_tm <
                                                                                                                                       create an export file with all checks printed in production since (l_today || " 18:01")))
                                                                                                                                       5/18/10. I have also confirmed that we can export all of the      --AND ((chk_dt_tm > "2008-04-05" || " 18:00") and (chk_dt_tm <
                                                                                                                                       backlogged checks into one file and send it off to them tonight.  "2008-04-10" || " 18:01"))
                                                                                                                                       Good job.                                                         ORDER BY d.chk_num
                                                                                                                                                                                                         it is pulling nothing
                                                                                                                                       Use the same format as the last file we sent them this morning.
                                                                                                                                       Very important: verify in the script that voided checks are
                                                                                                                                       handled, i.e.
                                                                                                                                                      is
                                                                                                                                       1) a “C― placed in the correct position in the record
                                                                                                                                       2) the check date is set to now()
                                                                                                                                       Please let me know when the file is placed and email me a copy
                                                                                                                                       so I can forward it to the Key Bank personnel.




                                                                                                                                                                                                                                                                                                       Page 11 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                   Description                                                             Additional Notes                                                Technical Notes                                                       Issue            Actual
ID         ule                                                                                                                                                                                                                                                                  Source           Completion
                                                                                                                                                                                                                                                                                                 Date
artf1256   Inmate        NSF - Offender   NSF - Release - Account We have attempted issue check to prisoner who were released          6/23/10: Ran a variety of offender transactions through - all of   [artf1256]                                                            Bernie Kohut &   6/24/2010
           Banking       Account          Balance                 without funds during the off till period we suffered after 05/18/10. which provided the expected results based on the offenders          Fix:                                                                 Various
                                                                                                                                       balance.                                                             - clearing the amount on focus of offender number
                                                                                                                                                                                                            - checking the amount on onBlur event of amout field.
                                                                  Running O#523764 reflect $410.23 being available in ACOMS               6/22/2010 : Cyndi - QA Validation.                                - checked the flag value to not call the checkAmount () on onBlur
                                                                                                                                                                                                          event of offender number. Amount does not needs be checked at
                                                                  Note the process taken was:                                             6/10/10 - Offender #401022 check was able to be processed -     this point of time. There is a seperate area where checkAmount ()
                                                                  1.Process an offender batch that transfers the funds from Savings       pending confirmation on others.                                 needs to be called.
                                                                  to checking. Transaction Code 185
                                                                  2.Process an offender batch that generates a check to offender          6/10/10 - Combined artf1226 with this issue and updated with
                                                                  from checking account. Transaction Code 238, Account 2010 –           document of issues related to NSF.
                                                                  Enter check information (Offender name, address, amount, etc.)
                                                                  3.Print Check (Report)

                                                                  Receiving error:
                                                                  Please correct the following problems -
                                                                  Insufficient Funds: Offender 523764 Current Checking Balance =
                                                                  410.23

                                                                  #1226:
                                                                  Offenders are being released, however system is reflecting a NSF
                                                                  balance when is actuality there is funds.
                                                                  Example: Offender Balance is 24.45 but when we go to do the
                                                                  check for release he comes up NSF saying he doesn’t have 

                                                                  the funds. (473676)

                                                                  #1213:
                                                                  See offender 166539 while posting a charge the intial NSF charge
artf1128   Inmate        NSF/Negative     Offender Balances       The following offenders were brought over with negative balances - Joe will follow up with user - Wayne Romberg                         477603CHK0.00                                                         Wayne Romberg 6/12/10
           Banking       Balances                                 need to investigate.                                                                                                                    477603SAV1.82
                                                                  Offender # 499977 Anderson, Justin                                                                                                      499977CHK0.11
                                                                  Offender # 500807 Martinez, Robert                                                                                                      499977SAV161.44
                                                                  Offender # 477603 Boe, Down                                                                                                             500807CHK18.30
                                                                  Offender # 521748 Bolus, Mark                                                                                                           500807SAV10.43
                                                                                                                                                                                                          521748CHK50.69
                                                                                                                                                                                                          521748SAV77.60

                                                                                                                                                                                                          Data that got converted. Negative balances are showing up because
                                                                                                                                                                                                          of the transactions in ACOMS.
artf1140   Inmate        NSF/Negative     NSF                     NSF occurrences are not producing an error preventing the                                                                               I have fixed NSF - artf1140 Issue. I have committed code changes in Joe Butler         5/30/10
           Banking       Balances                                 transaction from happening and they should be. Analyze Soft is                                                                          SVN.
                                                                  working on resolving this error. The fix should happen within 24                                                                        the triger is working now but the message shows a negative number
                                                                  hours, and will then go to test server for quality assurance before                                                                     with tooo many digits to the right. Needs to be trimmed.
                                                                  being pushed out to production server. Joe to provide the
                                                                  information to Cyndi to replicate. the Error / Warning Message is
                                                                  currently not visible.

artf1096   Inmate        Offender Account Offender Account        Submitted by Joe Butler - please see Joe for additional information mantis 2398                                                         Fixed                                                                                  6/12/10
           Banking                        Statement               and an update.
                                                                                                                                                                                                          SPL Name: ib_offbal_statmt
                                                                  What is missing is the detail and the organization of the detail, not
                                                                  sure if the $$s are there in the database, but the information on
                                                                  the screen and in printed form is missing and confusing.




                                                                                                                                                                                                                                                                                                    Page 12 of 48
                                                                                                                                 "HOT" Items
                                                                                                      1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                  Description                                                          Additional Notes                                                    Technical Notes                                                      Issue            Actual
ID         ule                                                                                                                                                                                                                                                                 Source           Completion
                                                                                                                                                                                                                                                                                                Date
artf1253   Inmate        Offender Account Offender Account -     Need to revise the offender account summary screen to correctly      6/16/10 - Validated UAT - sent email to users to validate. Devra,   Completed the artifact                                               Amy Weichert     6/16/10
           Banking                        Various                dispaly and extract information - see attached document for          Bernie and Amy validated.                                           - made a new stored proc to avoid anyh conflicts with exeisting
                                                                 complete information.                                                                                                                    code
                                                                                                                                    6/15/10 - Everything looks good, EXCEPT the Amount on hold -          - changed the front-end screen.
                                                                 #1253: Cash posted to this account in Prod and although it show in incorrectly pulling the deposits on hold.
                                                                 the detail the cash deposits are not affecting the balance.
                                                                 #512287

                                                                 #1236: Here are some balances that don’t total up. I/M
                                                                 Yoakum, J # 305451 6/2/10 $20.00 posted, but not in his amount,
                                                                 It’s

                                                                  on hold (somewhere). Also, the balance at the beginning is on top
                                                                 (05/20/2010), AND IS ALSO THE CURRENT BALANCE. While
                                                                  the line on the bottom (the most recent date). Shows a balance
                                                                 that… well it should be the current balance.

artf1141   Inmate        Offender         Secondary Inmate       Secondary Inmate Savings account conversion - Offender had           Joe and Chowdhry will review the list to make sure that they     Produce an excel spreadsheet list of all offenders with a secondary     DOC/Joe Butler   6/12/10
           Banking       Account(s)       Savings Account        multiple savings accounts in OTA that were not converted into        captured all the offenders that have a secondary savings account inmate account in OTA.
                                                                 ACOMS as ACOMS only has one saving account availability.                                                                              Show:
                                                                                                                                                                                                       1) Offender number
                                                                                                                                                                                                       2) Secondary account balance.




artf1121   Inmate        Offender Balance Balance Due Offender   A change this fellow was released Discharge and his name is not      6/23/10: Validated report in UAT environment - report is            Report is pulling offenders correctly due for offenders 1year due.   Bernie Kohut     6/24/2010
           Banking       Report           Report                 reflected on the “balance due offenders not incarcerated―        correctly pulling offenders that have been released from an
                                                                 report                                                               institution in the past 12 months and have an oustanding value      Files:
                                                                                                                                      on their account. Sent to Bernie Kohut for validation.              -------
                                                                                                                                                                                                          meu.ibr.jsp
                                                                                                                                      6/22/2010: SPL updated - report corrrectly pulling offendes that    onfdrUnclaimedFundRep.jasper
                                                                                                                                      have been released in past 12 months and have a balance in their
                                                                                                                                      account..                                                        Awaiting Move to QA.

                                                                                                                                      6/21/10: Report is pulling offenders that are still
                                                                                                                                      incarcerated - this report should ONLY pull offenders that are no
                                                                                                                                      longer incarcerated.

                                                                                                                                      Nathan Wegner ON# 508242
                                                                                                                                      Delrico Graham ON# 370977
                                                                                                                                      Leon Chatman ON# 491915
                                                                                                                                      Dustin Strickland ON# 401022
                                                                                                                                      Casey Kalmakoff ON# 432432



artf1315   Inmate        Offender Batch   Savings to Checking    Transaction #185 is only processing half of the transaction - need to 6/23/10: Validated a variety of offenders by transferring funds                                                                         Amy, Devra,      6/24/2010
           Banking                                               debit the savings and credit the checking.                            from savings to checking - all transferred and reflected a debit                                                                        Cyndi
                                                                                                                                       transaction to the savings and a credit to the checking. Pending
                                                                                                                                       AK DOC validation. Note: A script must also be run at time of
                                                                                                                                       movement to production to update 307 offenders that have had
                                                                                                                                       a 185 processed and update with the debit side of the 185
                                                                                                                                       transaction to correctly reflect on their account.

                                                                                                                                      6/22/10: Validated QA - correctly transfered from savings to
                                                                                                                                      checking with proper credit and debit.

                                                                                                                                      6/21/10: Ready for QA Build.




                                                                                                                                                                                                                                                                                                   Page 13 of 48
                                                                                                                                    "HOT" Items
                                                                                                         1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality    Title                    Description                                                            Additional Notes                                                     Technical Notes                                                     Issue         Actual
ID         ule                                                                                                                                                                                                                                                                    Source        Completion
                                                                                                                                                                                                                                                                                                Date
artf1150   Inmate        Payroll         Payroll - $0.00          Some offenders are receiving a 0.00 dollar payroll transaction in      I have processed offenders 444471 and 508460 (from ticket) in                                                                            Joe Butler    6/3/10
           Banking                       amounts                  their checking account. In most cases their savings account is         QA and applied 72 hours of payroll at .50 per hour – both
                                                                  credited the proper percentage of their pay for the period. The only   reflect values under their check and savings account as per the
                                                                  possible pattern noticed thus far is most offenders to which this      rules.
                                                                  occurs have a available balance less than the amount of their pay.     I am unable to recreate the 0.00 payroll values that were
                                                                  However this may be a coincidence.                                     reported.


                                                                                                                                         We can't duplicate in ours or there...Joe will get back to user.

                                                                                                                                         Verified with user all payroll batches went well. One batch failed
                                                                                                                                         because of the ACOMS afternnoon outage 6/1/10. We have
                                                                                                                                         agreed to leave this issue open until 6/4/10



artf1219   Inmate        Print Checks    Print Checks - SQL Error Unable to print checks - receiving SQL Error. Toni can’t print       Pt Mac: Checks don't appear to be aligend properly anymore -                                                                             Toni Barron   6/7/10
           Banking                                                checks for these 3 offenders; 2 have been discharged and 1             need to address.
                                                                  transferred to Palmer. She needs to get these checks out ASAP. It
                                                                  keeps coming up with a Sequel error. Any suggestions how she can       Identified that a script for Key Bank inadvertantely moved to
                                                                  get this done?                                                         production that caused the error - this was removed and the
                                                                                                                                         checks are now able to print.
                                                                  Error Log:
                                                                  [SEVERE] 10/06/07 10:12:04
                                                                  PrintOrRePrintChecksProcessorImpl.printCheck: AppException:
                                                                  class=otrack.ota.report.PrintOrRePrintChecksProcessorImpl,metho
                                                                  d=printCheck,message=ib_prt_chk_m returned error -
                                                                  691,date=Mon Jun 07 10:12:04 AKDT 2010errorCode=0
                                                                  [INFO] 10/06/07 10:12:04 PrintOrRePrintChecksAction.printRecord:
                                                                  ..end.



artf1204   Inmate        Till Teller -   Junea Main till not in   There is no till linked the Juneau Central office                      6/16/10: Confirmed with Devra - till looks fine.                     Development completed.                                              Devra Hayes   6/16/10
           Banking       Location        system                                                                                                                                                               SPL : get_till_acct_balance()
                                                                                                                                         6/15/10: Validated till by assigning Juneau till, adding receipts    Files Modified
                                                                                                                                         and disbursements, voiding and balancing. Processed bank             ---------------
                                                                                                                                         deposit of checks and then reassigned till - no issues found.        BodyLocationCodeWrapper.java
                                                                                                                                                                                                              TillAssignBalanceImpl.java
                                                                                                                                         6/14/10: Ran complete test in QA and determined that the till is
                                                                                                                                         functioning properly - processed receipts, disbursements and     Till Juneau Location in DD
                                                                                                                                         voids - verified bank deposit and checks are appearing.          ------------------------------
                                                                                                                                                                                                          INSERT INTO fclty_till_acct ( fclty_till_acct_id , till_currency ,
                                                                                                                                         6/9/10: To be groupd with common functionaliyt issues.           till_other, body_loc_cd, till_desc, till_start_date , till_start_tm ,
                                                                                                                                                                                                          till_end_date , till_end_tm , bank_deposited , updt_usr_id ,
                                                                                                                                         Till is now available, however Devra checked out the Juneau till updt_date)
                                                                                                                                         and found that check receipts are not showing up on the bank     VALUES ( 0 , 0.00, 0.00, '03','JUNEAU CENTRAL OFF', TODAY,
                                                                                                                                         deposit screen                                                   CURRENT,TODAY, CURRENT,'Y','cisuser1',TODAY);

                                                                                                                                         Juneau central office - Location should be enabled in UAT.
                                                                                                                                         Chowdhry will update in UAT - 6/8/2010.

                                                                                                                                         Joe confirmed that till not available in UAT.
                                                                                                                                         Devra - TO CONFIRM IN UAT.

                                                                                                                                         Senthil and Joe to review and talk about this one some more.

                                                                                                                                         Joe failed QA. Opened till, received cash but when in the
                                                                                                                                         disbursement screen available cash shows as 0 eventhough the
                                                                                                                                         balance till figures show correct values.




                                                                                                                                                                                                                                                                                                   Page 14 of 48
                                                                                                                                       "HOT" Items
                                                                                                            1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality         Title                   Description                                                            Additional Notes                                                       Technical Notes                                                 Issue          Actual
ID         ule                                                                                                                                                                                                                                                                      Source         Completion
                                                                                                                                                                                                                                                                                                   Date
artf1094   Inmate        Till/Teller          Deposit - Part 2        Reported by Joe Butler who is the primary resource re: this issue.  Need the ability to have "cash" receipts be immediately available Fix                                                                     Joe Butler     6/12/10
           Banking                            superseded by 1207      Checks are being deposited, the money is "there", the detail is not even though the till has not been balanced - this is a result of a ----
                                                                      showing when the Till is closed.                                    book and bail )Mantis 2202)                                          I have fixed when offender cash receipts/Disburse , immediately
                                                                                                                                                                                                             update Offender account, And he will not wait until till get
                                                                                                                                          Need to ensure that this will also remove with a void is           balanced..
                                                                                                                                          processed.
                                                                                                                                                                                                             SPL changes : get_disburse_cash_details_m
                                                                                                                                          Also - Once ready we need to ensure that ALL tills are balanced to          get_rcpt_chk_details_m
                                                                                                                                          prevent unapplied funds to offenders as the logic is changing.              get_till_acct_balance_m1

                                                                                                                                             Joe will check if we solved and definition of issue

artf1095   Inmate        Till/Teller          Starting Balance        Submitted by Joe Butler - please see Joe for more information.                                                                                SPL changes:                                                    Joe Butler     6/12/10
           Banking                                                    When a Till is being opened, what is there is confusing. Need more                                                                            ---------------
                                                                      detail here.                                                                                                                                  ib_iboffbal

artf1103   Inmate        Till/Teller          Till/Teller - GIft      We are trying to receipt gifts thru the ACC East Cash Receipt Till.                                                                           Joe confirmed that this has been fixed.                                        5/25/10
           Banking                            Receipts - Depositors   We can get to the add depositor page and then because we
                                                                      don’t always have the actual address we have tried the
                                                                      following.

                                                                      Entering not known - Putting all 0000 in the blanks - And finally we
                                                                      put the address of this institution 1400 E 4th Avenue Anchorage,
                                                                      AK 99501. This one worked a couple of times but then we started
                                                                      getting the following message. Error encountered - Referential
                                                                      Constraint in the database. Please check the input values you are
                                                                      trying to save.
                                                                      Now all it says is error. HELP

                                                                      Mantis 2325
artf1113   Inmate        Till/Teller          Till/Teller Check       Check number is not printing correctly when a 10 digit number is                                                                                                                                              Devra          5/28/10
           Banking                            Reference               used. Joe Butler actual character limit must be 20 to include
                                                                      symbols.
                                                                      Mantis #2363
artf1209   Inmate        Till/Teller - Cash   Cash deposits being     Cash Deposits are put on hold when they should be immediately          6/15/10 - Validated offender #437187 by process a variety of           SPL Modified:                                                   Amy Weichert   6/16/10
           Banking       Avail.               held                    available.                                                             transactions in the till - cash did reflect on the offender account,   -----------------
                                                                                                                                             however still requires the till be balanced to be effective.           get_till_acct_balance_m1
                                                                                                                                                                                                                    ----------------
                                                                                                                                             6/14/10 - Checks and cash are appearing on report. Cash and            I have updated when checks are posted to offender account and
                                                                                                                                             Gov. Checks are appearing on offender account balance values.          update that amount to amount on hold.
                                                                                                                                             Validated one of each type of transaction, including void -
                                                                                                                                             processed corrently and appeared on report - see attached              Checks not appearing report issue
                                                                                                                                             document for test results. Additional testing will be required         -----------------------------------------
                                                                                                                                             once the Offender Account screen modificaitons are made to             get_till_transactions
                                                                                                                                             esure that no adverse impact was made to this change.                  get_till_transac_rpt

                                                                                                                                             6/13/10 - Checks are appearing on report.                              Awaiting move to QA.
                                                                                                                                                                                                                    I have fixed this issue .And now checks amount
                                                                                                                                             Joe - bug fixed. Additional issue found - checks not appearing on      (BUSINESS CHECK -1,CASHIERS CHECK-3,
                                                                                                                                             report.                                                                GOVERMENT CHECK-4, MONEY OREDER -5)
                                                                                                                                                                                                                    not shows in till transaction report.
                                                                                                                                             Joe - TO CONFIRM IN QA ONCE COMPLETE .

                                                                                                                                             Code is completed and its updated cron job also.

                                                                                                                                             Linked to a number of issues.
                                                                                                                                             Senthil, Chowdhry, Prasanth are all on this.
                                                                                                                                             UAT Testing - Ask Don.



artf1247   Inmate        Till/Teller - Cash   Till/Teller - Cash      When cash is received the offender balance is not always updated 6/11/10: Need to run script on offender account in prod, then                                                                                Joe Butler     6/11/10
           Banking       Avail.               Availability            and available - need to investigate why. Current work around is    move fix in to prod on monday
                                                                      that the developer is manually updating the offender balance. This
                                                                      does not occur on all offenders, only a small handlful.
                                                                                                                                                                                                                                                                                                      Page 15 of 48
                                                                                                                                       "HOT" Items
                                                                                                            1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                     Description                                                           Additional Notes                                                   Technical Notes                                                      Issue       Actual
ID         ule                                                                                                                                                                                                                                                                      Source      Completion
                                                                                                                                                                                                                                                                                                Date
artf1214   Inmate        Till/Teller - Check Cron job to clear held   Create a cron job and script to clear checks on hold.                 6/11/10: Chowdhry verifeid that checked from 10 days prior       We need to create a cron job and script that makes checks that have DOC Accounting 6/11/10
           Banking       Clearing            Checks                                                                                         cleared, however we will monitor the checks of the next few days been on hold for 10 days available.
                                                                                                                                            to ensure they continue to clear.

                                                                                                                                            Chowdhry updated the technical notes which has the list of               ofndr.no amount receipt date
                                                                                                                                            offenders who's checks should be cleared by monday after the 10 19888925.0006/02/2010
                                                                                                                                            day hold.                                                           224708925.0006/02/2010
                                                                                                                                                                                                                3377175250.0006/02/2010
                                                                                                                                            6/10/10: Chowdhry to run report in production to validate           4276267250.0006/02/2010
                                                                                                                                            against offender accounts.                                          535124279.1706/02/2010
                                                                                                                                                                                                                66434786.6706/02/2010
                                                                                                                                            6/9/10: Deployed to Prod - Pending Confirmation                     745561625.0006/02/2010
                                                                                                                                                                                                                88407528.1606/02/2010
                                                                                                                                            Confirmed: This looks good. Offender 580460’s initial             920725.0006/02/2010
                                                                                                                                            balance+ cash deposits +check deposits add up properly. There is 1053113725.0006/02/2010
                                                                                                                                            no money on hold.                                                   1152249234.3506/02/2010
                                                                                                                                                                                                                1244808619.0006/02/2010
                                                                                                                                            Joe - TO CONFIRM IN UAT. Chowdhry will back date the recipt         131215639.9706/03/2010
                                                                                                                                            date of the checks.                                                 14536358161.4106/03/2010
                                                                                                                                                                                                                1537884925.0006/03/2010
                                                                                                                                            this is ready for deployment.                                       16494312573.6406/03/2010
                                                                                                                                                                                                                17292617783.0506/03/2010
                                                                                                                                            Chowdhry will create a cron job to clear checks after the 10 day 1848752560.4906/02/2010
                                                                                                                                            hold.                                                               1952982110.0006/02/2010
                                                                                                                                                                                                                20174303250.0006/03/2010
                                                                                                                                                                                                                217137150.0006/02/2010
                                                                                                                                                                                                                22519269100.0006/02/2010
                                                                                                                                                                                                                2352268630.0006/02/2010
artf1207   Inmate        Till/Teller -      Till/Teller Detail        Combine till/teller detail with existing account detail for account   6/15/10 - Validated UAT - ran complete test of all transactions in Show detail of receipts and disbursements done through the till on   DOC Accounting 6/16/10
           Banking       Details                                      detail screen view and account statement                              Juneau till - the appropriate transactions are appearing and        the offender's account and account statement report.
                                                                                                                                            checks that are on old appear on new field.
                                                                                                                                                                                                                SPLs modified:
                                                                                                                                            6/15/10: Processed till transactions for each type of check and     ib_iboffbal
                                                                                                                                            cash, included void, all appear to process correcntly and reflecton ib_offbal_statmt
                                                                                                                                            the offender account screen correctly.

                                                                                                                                            6/14/10: Processed one of each type of till transaction, details
                                                                                                                                            did not appear on offender account screen - however, this is
                                                                                                                                            being addressed with all the till/teller issues. Balances did
                                                                                                                                            increase.

                                                                                                                                            6/9/10: Two transactions created that reflect the beginning
                                                                                                                                            balance value. Moved to QA on 6/8/10 - pending testing.

                                                                                                                                            Begining balance - Missing transaction.

                                                                                                                                            Will be deployed to QA (6/4/2010).
                                                                                                                                            Joe - TO CONFIRM IN QA.

                                                                                                                                            Prasanth working on - 6/3/2010.

                                                                                                                                            The balances and detail look good. This was failed because we
                                                                                                                                            need to include the beginning balance as a transaction. The user
                                                                                                                                            will not have a complete picture until the conversion starting
                                                                                                                                            balances can be accounted for. -- Joe
artf1116   P&P           Field PO Desktop Parole/probation            Parole/probation expiration dates to populate in ACOMS                                                                                                                                                        Rebecca Brunger 5/27/10
                                          expiration dates to
                                          populate in ACOMS




                                                                                                                                                                                                                                                                                                       Page 16 of 48
                                                                                                                                    "HOT" Items
                                                                                                         1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                  Description                                                              Additional Notes                                                        Technical Notes                                                    Issue            Actual
ID         ule                                                                                                                                                                                                                                                                         Source           Completion
                                                                                                                                                                                                                                                                                                        Date
artf1287   P&P           Offender History Offender History -       Extracted offender history in P&P for offender #521359 - the             6/18/10: The issue was with the “CAPS―      being entered as                                                                           Lori Wharton     6/18/10
                                          Chrono's                 supervision contact note on 6/10/10 is not appearing on the report,                                    –
                                                                                                                                            the “primary contactâ€
 it appears that instead of clicking
                                                                   however the others are - this note is no different than the 3/22/10      on the single head or double head to search for the “user id―
                                                                   note.                                                                    the user typed his user ID in CAPS, as a result the system
                                                                                                                                            didn’t recognize the user id, as all user id are in lowercase.
                                                                   (Lori: The 6/10/2010 record is present in the suprvsn_cntc table.        We’ve fixed this particular user id for this record, and a ticket
                                                                   The only thing I can note is the fact that the 6/10 entry follows a      has been opened #1288 to address the uppercase user id in
                                                                   6/16 dated entry. The stored procedure get_sprvsn_cntc correctly         future.
                                                                   returns the 20 rows to the application. The app just chooses not to
                                                                   display that record. There are no date typos in the record to
                                                                   prevent the display.)

artf1102   P&P           Probation          Court Cases - Probation When attempting to select a court case to enter a Probation                                                                                     Fix                                                                                 5/27/10
                         Agreement          Agreement               Agreement, I received the error to select a Court Case, even                                                                                    ---
                                                                    though the one case I had available (3AN-S09-11143CR), I had                                                                                     Now able to select a court case to enter a Probation Agreement.
                                                                    check marked to select (screen w_otr_s6_4.jsp):                                                                                                  fixed in QA Environment

                                                                   Mantis 2324                                                                                                                                      Code:
                                                                                                                                                                                                                    w_otr_s6_1.jsp
                                                                                                                                                                                                                    w_otr_s6_1.jsp
                                                                                                                                                                                                                    ProbationParoleAgreementAction.java




artf1206   P&P           Probation          Probation Expiration   The ACOMS updates spreadsheet on DOC-WEB indicates that                                                                                                                                                             Rebecca Brunger 6/3/10
                         Expiration Dates   Date                   probation expiration dates were migrated to the ACOMS
                                                                   production server on 5/27/2010. However, they do not appear to
                                                                   have been. I can see them on the test server, but they don’t
                                                                   appear to exist on the production server (first example below is the
                                                                   production server, the second is the test server):

artf1146   P&P           Re-Admit Report Field PO Re-Admit         This is a high priority issue for the Anchorage Probation Office. For    6/16/10: Email sent to Chris for validation. Chris is out - worked      SPL                                                                Chris McKenzie   6/16/10
                                         Report                    the past two days, the Field PO Re-Admit Report has been blank           with Lori Taylor to validate - sent sample of report and walked         -------------------
                                                                   whenever we have attempted to run it. With Memorial Day                  through report generation for Anchorage Prob. - OK                      get_po_readmits_rpt
                                                                   weekend coming up, we typically average 25 – 30 offenders                                                                                      get_fpo_readmit_rep
                                                                   arrested over the long weekend at institutions all over the state.       6/15/10: Validated - offender #44097 was under Palmer Prob
                                                                   We have no adequate system to track offender re-admits without           supervision, booked into FCC - appeared on report, then                 APP_FILES
                                                                   this report, since we have noticed the Daily Count sheets we have        released, appeared on report with release date.                         ---------------------
                                                                   received do not appear to list all of our offenders who have been                                                                                po_readmits_rpt.jasper
                                                                   arrested. If we fail to submit probation violation reports in a timely   6/14/10: Re-tested after SPL was moved - verified - appears to          po_readmits_rpt.jrxml
                                                                   manner, because we do not know an offender has been arrested,            be fine.                                                                AgentWorkloadReportAction.java
                                                                   then we risk having offenders being released by the Courts for our                                                                               AgencyLocCodeWrapper.java
                                                                   failure to charge the offender with probation violations. We need        6/14/10: Ran offender 453063 & 185223 - booked - did not
                                                                   this issue resolved as soon as possible. Thank you.                      appear on report - report blank - returned to developer.

                                                                                                                                            6/9/10: Received feedback from Chris: I only have two issues with
                                                                                                                                            it is the blank spaces for the PO name, I understand that the
                                                                                                                                            means the offender is assigned to the same PO as the offender
                                                                                                                                            listed above, but it’s easier and quicker to read if the PO name
                                                                                                                                            is included on every line. Secondly, the Offender Re-Admit Report
                                                                                                                                            in OTIS spelled out the PO’s name (LAST, FIRST) instead of
                                                                                                                                            using their User ID. It may be a bit easier to read, especially for
                                                                                                                                            new staff, if the ACOMS reports did the same, but that’s not a
                                                                                                                                            high priority.

                                                                                                                                            6/9/10: Validated all sort options for location of Anchorage PROB
                                                                                                                                            and a variety of date ranges - verified offenders - all appears fine.
                                                                                                                                            Sent sample of report to Chris McKenzie and advised that this
                                                                                                                                            would move into Training this afternoon for review.




                                                                                                                                                                                                                                                                                                           Page 17 of 48
                                                                                                                                  "HOT" Items
                                                                                                       1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality    Title                   Description                                                             Additional Notes                                                     Technical Notes                Issue            Actual
ID         ule                                                                                                                                                                                                                               Source           Completion
                                                                                                                                                                                                                                                              Date
artf1133   P&P           Sex Offender    Sex Offender Release    0000002 - The “Future― Offender (SO) Releases is a report
                                                                                               Sex                                     Item 1, YES - Sex Offender - Active List works perfect for me, and SPL                                Terri Telkamp    6/12/10
                                         Report                  I run every 90-days on each institution separately – this example   does resolve Item 3. Having just the present location of the       -------------
                                                                 is one from Palmer Correctional Center but I print them for every     offender and the other info already provided are all that is       get_active_so_list
                                                                 Alaska DOC institution. I sort them by release date, and review       needed for this future release tracking.
                                                                 them for upcoming releases, then use them almost daily as I track                                                                        FILES
                                                                 those I receive and those that I don’t – makes my monthly         Item 2, YES - the Location From and Location To are indeed         ---------------------------
                                                                 report easier, and weeds out those I don’t need to even worry       present on the LIVE ACOMS website, in Facilities, "Sex-Offender sexOffenderActive.jsp
                                                                 about. This is where the OTIS way of classifying certain crimes as    Released List" and work perfect for historical release tracking. I menu.reportform.jsp
                                                                 sex offenses when they are not – like “family violence―    ,    don't have access to Facilities in training site, and it is not    menu.reportsDIOMain.jsp
                                                                                      ,
                                                                 “prostitutionâ€
some “coercionâ€
         cases is a real pain. 
 available in the LIVE ACOMS P&P side, but those are not show       DIO_ReportResources.properties
                                                                                                                                       stoppers since I know where to find it.                            SexOffenderProcessorImpl.java
                                                                 The worst part of this report is that the inmates often move to       David will call Terri Telkamp.Terri - TO CONFIRM IN UAT.           SexOffenderAction.java
                                                                 another institution before they actually release, but that’s not                                                                       sex_offender_active.jrxml
                                                                 one that can be fixed I don’t think. Makes tracking fun and         Senthil - TO CONFIRM IN QA                                         sex_offender_active.jasper
                                                                 quite often I don’t get notified of the move so I literally have to UAT - Terri Telkamp                                                struts-config-dio.xml
                                                                 go “find―  them again. ?
                                                                                                                                       Additional loccations avaialble to select any location if desired.
                                                                 Mantis #2241
                                                                                                                                       Needs to have a date RANGE OPTION per Terri




artf1135   P&P           Sex Offender    Sex Offender Release - We need to be able to run a list of sex offenders releasing, by 6        Item 1, YES - Sex Offender - Active List works perfect for me, and   SF_1135                        Megan Howard     6/12/10
                                         Varying Time Frames months, 1 year, 2 years, etc. Not just one individual, on one date. I       does resolve Item 3. Having just the present location of the         -----------------
                                                                regularly run a list so I can see who needs to be assessed before        offender and the other info already provided are all that is         sexOffenderReleaseReport.jsp
                                                                they release.                                                            needed for this future release tracking.                             sex_ofndr_rels

                                                                 Mantis 2318                                                             Item 2, YES - the Location From and Location To are indeed
                                                                                                                                         present on the LIVE ACOMS website, in Facilities, "Sex-Offender
                                                                                                                                         Released List" and work perfect for historical release tracking. I
                                                                                                                                         don't have access to Facilities in training site, and it is not
                                                                                                                                         available in the LIVE ACOMS P&P side, but those are not show
                                                                                                                                         stoppers since I know where to find it.
                                                                                                                                         David will call Terri Telkamp.
                                                                                                                                         Terri - TO CONFIRM IN UAT.

                                                                                                                                         Senthil - TO CONFIRM IN QA - 6/3/2010
                                                                                                                                         UAT - Terri Telkamp

                                                                                                                                         Report is based in the sex offender charges not on the cautions.

                                                                                                                                         Needs to have a date RANGE OPTION per Terri - 6/2/2010


                                                                                                                                         Senthil - I have tested various Date range , the report bringup
                                                                                                                                         offenders with valid date.




artf1097   P&P           Travel Permit   Travel Permit - Wrong   While it is true that the info on the travel pass listed his race as -- Travel Permit                                               Fixed along with #1120.                 Rebecca Broker   5/30/10
                                         Information             Black and listed his hair color as Indian, my corrections were to    -- Race and Hair Color setter methods values were swapped with
                                                                 hand cross them out and date and then write in the correct info.     each other. Corrected it.
                                                                 ACOMS switches the info from hair color and race. It also
                                                                 automatically lists people as a sex offender. I did not catch it and
                                                                 Horace Timothy caught it and as a result I hand wrote corrections
                                                                 and dated it. I thought everything was fine but then he complained
                                                                 to the Ombudsman as below, which was disappointing but I called
                                                                 Horace Timothy and asked him what we could do to work this out.
                                                                 He told me he was embarrassed which was why he filed the
                                                                 complaint.

                                                                 Offender #477903
                                                                                                                                                                                                                                                                 Page 18 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                    Description                                                                 Additional Notes                                                Technical Notes                                                      Issue           Actual
ID         ule                                                                                                                                                                                                                                                                      Source          Completion
                                                                                                                                                                                                                                                                                                    Date
artf1120   P&P           Travel Permit    Travel Permit - Various 1. Travel permits are overwriting text when printed out (the report          #S 1120                                                                                                                              Rebecca Brunger 5/30/10
                                          Issues                  by line is overwriting special instructions): from Chris McKenzie             Fix:
                                                                  2. When you go into ACOMS to enter the permit, the area for the                - changed all the points mentioned in list, except 5 and 7
                                                                  telephone number is not working correctly as it places that dash in          (discussed with Cyndi)
                                                                  the third space instead of the fourth Example: 84-25799 rather
                                                                  than 842-5799.
                                                                  3. Also when you go to print the travel permit it does not pull the
                                                                  phone number into it and there is a spacing issue within the form
                                                                  itself (see attached).
                                                                  4. We have also noted out here that ACOMS is reversing the race
                                                                  and hair color information as our guy out here shows as Race:
                                                                  Brown and Hari Color: Hispanic/Latino.
                                                                  5. the State ddl is not filtering out the rows with vld_flg = ‘N’.
                                                                  It’s displaying everything.

                                                                  6. Need to only have "active" court cases reflected on the travel
                                                                  permit - currently they are reflecting both inactive and active.
                                                                  7. While doing a couple travel passes in ACOMS, I noticed that for
                                                                  some reason, when you print out a travel pass, it does not show a
                                                                  day of trip, or day of return. This is pretty important information, as
                                                                  it looks like an open ended travel pass without it. The information
artf1264                 Court Case       Court Case - DD         The issue on the court case not appearing is due to 2 court cases            6/16/10 - Email sent to Elesceeya to validate in Training.      get_crt_loc                                                          Don Brand       6/16/10
                                          Addition                are reflecting no case numbers just a “/―    causing a conflict in       ELesceey confirmed - awaiting prod deployment.
                                                                  retrieving. This can be resolved, by entering the court case number
                                                                  and identifying “out-of-state―     checkbox. However, I think that       6/15/10 - validated #5217 by adding a case that was "Out of
                                                                                                                          in
                                                                  we will need to add an option of “Out of State― the Court                State" and then able to select on the victim screen.
                                                                  Name drop down selection list, as system requires that this be
                                                                  entered and an out of state case would be a court name outside of
                                                                  Alaska – the current selection reflects only Alaska court names.
                                                                  If you agree, we can add the option to the drop down list and then
                                                                  we can update the 2 cases that are causing the issue. Please let
                                                                  me know.

                                                                   To Do: Add an option of "Out of State" to the Court name drop
                                                                   down list.

Artifact   Location/Mod Functionality     Title                    Description                                                                 Additional Notes                                                Technical Notes                                                      Issue           Actual
ID         ule                                                                                                                                                                                                                                                                      Source          Completion
                                                                                                                                                                                                                                                                                                    Date
artf1217   Booking       Booking - Charge Booking - "Charge to"    Federal Booking appear to be defaulting to Air force. We had seven          7/1/10: Validated booking offender 383529 with multiple                                                                              Sgt. Moriarty   6/30/10
                         To.                                       remands on Friday that were US Marshal offenders. The booking               booking reasons - the location is correctly reflecting
                                                                   record shows bill to US Marshal, but location history shows hold-air        "arrest/remanded".
                                                                   force. I tried it in the test server to see if it was user error, and got
                                                                   the same result. The offenders in the live server are #531638,              6/30/10: Offender 351831 booked on federal - validated -
                                                                   519271, 457017, 488023, 519789, 322059, and 1332.                           location reason reflects "arrest/remanded"

artf1211   Booking       Referred Offense Offense Errors          This is an inconsistent error that does not occur with all offenders         7/1/10 - Validated adding a variety of offenses - all saved     [artf1211]                                                           Sgt Sean        6/30/10
                                                                  or at all times at all stations. However, this was reported by Sgt           correctly.                                                       - fixed the subquerty returining more than one row.                 Moriarity
                                                                  Moriarity.
                                                                  when adding offenses, the offense is not able to be saved at the
                                                                  time of entry or at booking. thus, many offenders have additional
                                                                  offenses that have not been entered. see attached photos of the
                                                                  error and the user log information.
artf1228   Environment/S Photos           Image (Photo) Capture - The image capture needs security when they upload a photo                    7/1/10: Ran various scenarios - approved.                       Need to write a web service to hit the security tables. Then Image   Don Brand       6/30/10
           ystems                         Security                                                                                             6/30/10: Validated in QA                                        captures needs to validate against this web service.
artf1325   Environment/S Photos           Photos - Booking Date The pictures are synced between Acoms to Winpho, but the                       7/1/10: (Don): Photo security verified                                                                                               Don Brand       6/30/10
           ystems                                                 booking date is missing in Winpho.                                           7/1/10 - Validation to be done by Don Brand and Patrick.

                                                                                                                                               6/30/10 - Unable to validate in QA as we are not connected to
                                                                                                                                               Winpho - need interface with Winpho.




                                                                                                                                                                                                                                                                                                       Page 19 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                   Description                                                            Additional Notes                                                        Technical Notes                                                    Issue           Actual
ID         ule                                                                                                                                                                                                                                                                      Source          Completion
                                                                                                                                                                                                                                                                                                    Date
artf1220   Facilities    Custody Level    Custody Level -         1. When inputting a custody level, the screen will not allow me      7/1/10: Both issues resolved and verified in QA and UAT.                  [artf1220]                                                         Jan Jenski      6/30/10
                                          Effective Date          enter an effective date. It automatically inputs today’s date (or                                                                             - added 'effective date' in listing
                                                                  the date the info is entered), which is not accurate. I would        06/30/10: 2 issues: The effective date is not carrying over to the         - changed the FELONY to FELON
                                                                  strongly request a dialog box on that screen also.                   listing screen - it is still reflecting the current date. Also the term    - removed 4 fields not used from screen.
                                                                                                                                       "Felon" is refelcting "Felony" - need to drop the "Y" (187767)
                                                                  2. Would like to have the option to clear the next classification                                                                              [artf1221]
                                                                  date - currently it defaults and if you clear it defaults to current                                                                            - added new field for Effective Date
                                                                  date.                                                                                                                                           - changed the logic date Next classification due date
                                                                                                                                                                                                                  - added Offense Severity Level in Offender Header i.e. Felony /
                                                                  3. Would like to have the identifier of "Felon" or "Misdemeanor"                                                                               Misdemenor
                                                                  be included on the custody level in the header.


artf1221   Facilities    Custody Level    Custody Level           Some offenders are showing the wrong custody on their profile,                                                                                 Fix:                                                               Sgt. Moriarty   6/30/10
                                          Discrepancies           but is correct in classification desktop. The PO supervisor here has                                                                           - changed the order of records to max(rfrd_for_apprvl_dt)
                                                                  expressed that it is having a significant impact on the amount of
                                                                  time their duties are taking to research custody. See two below
                                                                  print screens.
artf1266   Facilities    DNA Report       DNA Report              DNA report is returning "Null" regardless of the location selected.    7/1/10: Validates single location and all locations - report is both                                                                       Mary Sandy      6/30/10
                                                                                                                                         cases returns data.

                                                                                                                                   6/30/10: Validated a variety of locations - all returned data
                                                                                                                                   related to DNA Tests - no nulls returned.
artf1267   Facilities    DNA Test         DNA Test               DNA Test tab is red indicating he needs DNA test, however         7/1/10: Ran offender #525505 in UAT under 5 scenarios - all                                                                                      Mary Sandy      6/30/10
                                                                 offender #9585 had a "passed" test on 2/25/10 that did not update returned correct results - approved.
                                                                 the link from red to normal.
artf1332   Facilities    Referred Offense Referred Offense - Sex When attempting to add a referred offense to a court case and the 7/1/10: Applied offenses (sex and other) to offender #196539,   get_rfrd_ofnse_m                                                                 Lori Wharton    6/30/10
                                          Offenses               offense is a "sex" offense, receiving an error: [SEVERE] 10/06/25 included sentence info- no errors received. Validated.
                                                                 06:22:31 CurrentOffenseAction.add: Exception:
                                                                 class=otrack.ftrack.offender.offense.CurrentOffenseProcessorImpl, 6/28/10: QA Validated - both sex offenses and non-sex offenses.
                                                                 method=saveCurrentOffenseRecord,message=save was un-              (artifact #1230 also fixed with this issue)
                                                                 successful ,date=Fri Jun 25 06:22:31 AKDT 2010errorCode=-284


                                                                  This statement in the stored procedure get_rfrd_ofnse_m is
                                                                  producing a -284 error.
                                                                            select dna_rqrd_flg into i_dna_rqrd_flg from ofnse_cd
                                                                  where ofnse_viol_cd in (
                                                                              select ofnse_viol_cd from rfrd_ofnse where ofndr_num =
                                                                  i_ofndr_num) and dna_rqrd_flg = 'Y';
                                                                  It is returning two rows and the select is looking for one row.




                                                                                                                                                                                                                                                                                                       Page 20 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                     Description                                                              Additional Notes                                                      Technical Notes   Issue            Actual
ID         ule                                                                                                                                                                                                                       Source           Completion
                                                                                                                                                                                                                                                      Date
artf1230   Facilities    Referred         Referred Offense -        #1230:                                                                   7/1/10: Validated a variety of scenarios - applying sex offenses,                       Sgt. Moriarty    6/30/10
                         Offenses         Sentencing                Sentence - Save on referred offense - unable to save - receiving an      other offenses and sentence info - all saved correctly.
                                                                    Error Encountered.
                                                                    [SEVERE] 10/06/08 10:57:16 CurrentOffenseAction.add: Exception:          6/28/10: QA Validated - both sex offenses and non-sex offenses.
                                                                    class=otrack.ftrack.offender.offense.CurrentOffenseProcessorImpl,        (artifact #1332 also fixed with this issue)
                                                                    method=saveCurrentOffenseRecord,message=save was un-
                                                                    successful ,date=Tue Jun 08 10:57:16 AKDT 2010errorCode=-284
                                                                    Offenders that did NOT work: 86703, 534670, 335235, 128115,
                                                                    225498, 424197, 532966, 393303, 113619
                                                                    Offender that worked: 534399

                                                                    #1127:
                                                                    1. Cindy Peters and I are both getting an error while attempting to
                                                                    input the referred offenses for this inmate. Please
                                                                     see the below screen shots. It has not happened so far with any
                                                                    other referred offense for any other offender that we
                                                                    have seen.
                                                                    2. We are getting the same error as the below email for OB#
                                                                    393303, 424197, and 128115.
                                                                    3. Also, the CJT next door is having the same issue with OB#
                                                                    15084.




artf1284   Facilities    Statewide Barred Statewide Barred          1.   Need to add a "Reason" for being barred                             7/1/10: Updated two visitors with the state barred information                          Cindy Betts      6/30/10
                         Report           Report                    2.   Date Barred                                                         on the visitor info screen, included DL (Doc No.) on one and a
                                                                    3.   Facility that barred visitor                                        variety of dates - all appeared on report - included the removal of
                                                                    4.   Remove "SSN"                                                        the visitor from the barred identifier - no longer appeared on
                                                                                                                                             report.

                                                                                                                                             6/30/10 - Validated.
artf1157   Facilities    Substance Test   Substance Order           Need to put the following 5 drugs at the top of the list on the          7/1/10: Validated that all 7 drugs are listed on both randon and                        Chris McKenzie   6/30/10
                                                                    substance testing:                                                       targeted.

                                                                    Alcohol
                                                                    Amphetamines
                                                                    Benzodiazepine
                                                                    Cocaine
                                                                    Methamphetamine
                                                                    Opiates
                                                                    THC

                                                                    Can the list of substances be reduced to what we actually test for?
                                                                    The current list (below) is absurdly long, and makes the test results
                                                                    entry more difficult to use and screen print since it is too long. We
                                                                    only need Alcohol, Amphetamines, Methamphetamine, Cocaine,
                                                                    THC, and Opiates. These are the only substances that the UA test
                                                                    kits test for. If the test
                                                                    is sent to a lab for a more specific result, for example positive test
                                                                    for Opiates that is lab confirmed as Heroin, we
                                                                    can put that in the comments section. The list below is too
                                                                    cumbersome.



artf1328   Facilities    Visitors         Visitors - Birth Cert &   1. Rremove the constraint on the Birth Certification                     7/1/10: Validated in UAT                                                                Cheryl Rubalcava 6/30/10
                                          SSN                       2. Remove SSN
                                                                                                                                             6/30/10 - Validated that SSN has been removed and the birth
                                                                                                                                             certificate verfieid is now optional.




                                                                                                                                                                                                                                                         Page 21 of 48
                                                                                                                              "HOT" Items
                                                                                                   1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality   Title                  Description                                                        Additional Notes                                                     Technical Notes                                                Issue          Actual
ID         ule                                                                                                                                                                                                                                                        Source         Completion
                                                                                                                                                                                                                                                                                     Date
artf1286   Inmate        Auth. Ded.     Authorized Deduction   Create an "offender level" authorized deduction report that        7/1/10: Validated offender #78039 by adding2 attachments and         Files Updated:                                                 Amy Weichert   6/30/10
           Banking       Report         Report                 provides a report based on the following criteria:                 processing payroll - approved.                                       ---------------
                                                               1. Active (Includes future)                                                                                                             auth_dedct_report.jasper
                                                               2. Inactive                                                        6/30/10 - Report validated - including payments screen.              auth_deduct_transc_subreport.jasper
                                                               3. Both Options
                                                               4. Date Range                                                      Report completed . Waiting for QA Test                               authDeductionRpt.jsp
                                                               5. Type (Includes "ALL")                                           6/22/2010: will be completed.                                        IB_ReportResources.properties
                                                               6. Offender # (Includes offender Find)                             6/21/10; 60% complete                                                menu.ibp.jsp
                                                                                                                                                                                                       RpAttachAction.java
                                                             Report Information Includes:                                                                                                              RpAttachForm.java
                                                             1. Offender #                                                                                                                             RpAttachProcessorIfc.java
                                                             2. Offender Name                                                                                                                          RpAttachProcessorImpl.java
                                                             3. Order Date                                                                                                                             struts-ota.xml
                                                             4. Effective Date
                                                             5. Completion Date                                                                                                                        SPL :get_auth_dedct_report
                                                             6. Hold                                                                                                                                      get_atch_transc_det
                                                             7. Deduction Reference
                                                             8. Deduction Description
                                                             9. Deduction Type
                                                             10. Priority
                                                             11. Percent
                                                             12. Source
                                                             13. Max LImit APplies
                                                             14. Deduction Override (Percent, SOurce, Max LImit Applies)
                                                             15. Max Monthly AMount
                                                             16. Order AMount
                                                             17. Collected Amount
                                                             18. Outstanding Amount
artf1215   Inmate        Automatic      Automatic Deductions Are you all aware that none of the Attachments and Automatic         7/1/10 - Pending AK DOC Confirmation.                                                                                               Wayne Romberg 6/30/10
           Banking       Deductions                          Transactions seem to be processing? If you need an example look                                                                                                                                          & Casey Desiena
                                                             at IM #345537 Ronnell Keller. I released him earlier this week and   6/30/10: Offender #187767 processed various attachments,
                                                             as part of that process I transferred his Savings to Checking ( he   transactions, payroll, till disbursement and quick release -
                                                             had a zero balance in checking). It should have taken all of that    validation to move to uat
                                                             money from savings and applied it to all of the Attachments once
                                                             the money was transferred from savings. It has not done this. This   6/24/10: Completed development. Code ecked in DEV.
                                                             is just one Inmate example, I know there are many more. I also
                                                             don't think that the system is taking any of the other Attachments   6/22/10 : Assigned to Chowdhry .
                                                             such as Child Support and Court Restitutions out of the Inmate
                                                             Payroll. I have not seen it posted on any of the inmate accounts     6/18/10: Currently in development.
                                                             and we have paid them for this month, so it should have come off
                                                             of a large # of accounts.                                            6/17/10: #1286 was opened and assigned to Sendhil to address
                                                                                                                                  report function of this request and is dependent upon this ticket
                                                               6/14/10: Authorized deductions are not ending once the order       being completed.
                                                               amount is reached.
                                                                                                                                  6/12/10: Need clarification on the business rules - Cyndi to
                                                                                                                                  discuss with Wayne Romberg, Case Desiena and Devra.

                                                                                                                                  6/11/10: Investigating transactions not processing
                                                                                                                                  6/10/10: Spoke with Devra, deductions are occurring, however
                                                                                                                                  there are a few deductions that are not working - need to identify
                                                                                                                                  which is not working and address.

                                                                                                                                  6/9/10: Chowdhry focused on Key Bank on 6/8/10 and will work
                                                                                                                                  on this issue today.

                                                                                                                                Chowdhry will work on it today (6/8/2010)
artf1282   Inmate        Commissary     Commissary -           When commissary is posted to an offenders account the order      7/1/10: Validated same as QA test - approved.                    [artf1282]                                                           Amy Weichert   6/30/10
           Banking       Batch          Reference No.          number needs to be in the ref doc. We frequently use this number                                                                   - linked the Order Number from commissary txt file to Transaction
                                                               to do research and returns.                                      6/30/10: Validated by running a commissary batch in QA - ref. no Reference in offender balance statements
                                                                                                                                is reflecting the doc no.




                                                                                                                                                                                                                                                                                        Page 22 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                   Description                                                             Additional Notes                                                    Technical Notes                                                     Issue            Actual
ID         ule                                                                                                                                                                                                                                                                     Source           Completion
                                                                                                                                                                                                                                                                                                    Date
artf1129   Inmate        Indigent Report   Indigent Report         Indigent Report is pulling all the offenders .They want only indigent   7/1/10: Validated UAT by single and all locations.                  SPL                                                                 Mary Sandy       6/30/10
           Banking                                                 offenders.Also the amount filed should be the one from                                                                                      ----------------
                                                                   checking.Right now it is savings. it shows all issues as suspended as   6/22/10 : Awaiting - authorized deductions.                         ib_indigent_suspend_rpt2
                                                                   well. This doesn’t work and you probably already know and
                                                                   probably links to an Inmate Banking issue. But you’ll see on the      6/21/10: Validated Anchorage Jail, however offender 444471 is FILES
                                                                   bottom of the screen and on the second screen it says one prisoner      pulling on report, however value says $13.55 - however offender --------------
                                                                   but doesn’t list the prisoner. Just though I’d address this         actually has $509.95                                            src
                                                                                                                     file.
                                                                   and get it off my list and into my “issues― Mary Sandy                                                                              IB_ReportResources.properties
                                                                                                                                           6/17/10 - Report completed - pending authorized deduction
                                                                                                                                           completion                                                      /jsp\ota
                                                                                                                                                                                                           indigentSuspendRpt.jsp
                                                                                                                                           6/15/10: Authorized deduction regarding indigent rules needed
                                                                                                                                           before this can be validated/completed.

                                                                                                                                           6/13/10: 60% completed - pending rules verfiication from
                                                                                                                                           Devra.

                                                                                                                                           6/10/10 - To be completed 6/11/10 - delay resulting from
                                                                                                                                           working on offfender balances and missing offender issue.

                                                                                                                                           6/9/10 - To completed on 06/10/10

                                                                                                                                           Chowdhry will create 2 cron jobs for this issue.
                                                                                                                                           Meeting will be held - 6/04/2010 .

                                                                                                                                           Joe to review with Kevin & Devra, to determine urgency.

                                                                                                                                           Pending fix to "Indigent Status" before report can be validated
artf1318   Inmate        Key Bank          Key Bank                Kevin just stopped in my office. We’ve gotten a call from Key         7/01/10: OK per Don.                                                                                                                    Don Brand        6/30/10
           Banking       Interface                                 Bank, there was a block of checks that were missed in the file
                                                                   transmission to Key Bank on the 14th. From what we can see, it          6/24/10: Add checks that were missed on today's flat file. Item
                                                                   looks like they were all WWCC checks, but there may be more. The        will remain open - pending Joe's confirmation of the file receipt
                                                                   checks that were not accounted for are 63702543 through                 by Key bank on 6/25/10
                                                                   63702552. This needs to be investigated ASAP.

artf1256   Inmate        NSF - Offender    NSF - Release - Account We have attempted issue check to prisoner who were released          7/1/10: Validation completed.                                          File not moved to production. Requested to move it in next build.   Bernie Kohut &   6/30/10
           Banking       Account           Balance                 without funds during the off till period we suffered after 05/18/10. 6/30/10: Validation of QA, however limited as offenders that                                                                               Various
                                                                                                                                        meet this situation are few and far between.                        [artf1256]
                                                                                                                                                                                                             Fix:
                                                                   Running O#523764 reflect $410.23 being available in ACOMS               6/25/10: Failed PROD - Appears to occur on only a small handful    - clearing the amount on focus of offender number
                                                                                                                                           of offenders - majority have no issues whatsoever - need           - checking the amount on onBlur event of amout field.
                                                                   Note the process taken was:                                             additional research.                                               - checked the flag value to not call the checkAmount () on onBlur
                                                                   1.Process an offender batch that transfers the funds from Savings                                                                        event of offender number. Amount does not needs be checked at
                                                                   to checking. Transaction Code 185                                       6/23/10: Ran a variety of offender transactions through - all of this point of time. There is a seperate area where checkAmount ()
                                                                   2.Process an offender batch that generates a check to offender          which provided the expected results based on the offenders       needs to be called.
                                                                   from checking account. Transaction Code 238, Account 2010 –           balance.
                                                                   Enter check information (Offender name, address, amount, etc.)
                                                                   3.Print Check (Report)                                                  6/22/2010 : Cyndi - QA Validation.

                                                                   Receiving error:                                                        6/10/10 - Offender #401022 check was able to be processed -
                                                                   Please correct the following problems -                                 pending confirmation on others.
                                                                   Insufficient Funds: Offender 523764 Current Checking Balance =
                                                                   410.23                                                                  6/10/10 - Combined artf1226 with this issue and updated with
                                                                                                                                           document of issues related to NSF.
                                                                   #1226:
                                                                   Offenders are being released, however system is reflecting a NSF
                                                                   balance when is actuality there is funds.
                                                                   Example: Offender Balance is 24.45 but when we go to do the
                                                                   check for release he comes up NSF saying he doesn’t have 

                                                                   the funds. (473676)

                                                                   #1213:
                                                                   See offender 166539 while posting a charge the intial NSF charge


                                                                                                                                                                                                                                                                                                       Page 23 of 48
                                                                                                                                  "HOT" Items
                                                                                                       1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                  Description                                                             Additional Notes                                                       Technical Notes                                                   Issue             Actual
ID         ule                                                                                                                                                                                                                                                                    Source            Completion
                                                                                                                                                                                                                                                                                                    Date
artf1274   Inmate        Offender Account Uncleared Checks -     1. Request received to provide a screen or other method at the          7/1/10: Verified by clearing all types of checks - trans appeared      6/18/2010: Completed the development. Will check in the code in   Amy Weichert      6/30/10
           Banking                        Offender Account       offender level that would display the "deposits on hold", date          and balances were increased.                                           conjunction with #1215.
                                                                 received deposit type (check: BC, CC, MO), amount and expected
                                                                 date that the check would clear.                                        6/30/10: Uncleared checks are reflected and able to clear and
                                                                                                                                         appear in current available balance, available and ending
                                                                 2. Ability to clear "manually" the uncleared check.                     balances updated appropriately..

                                                                                                                                         6/28/10: Completed development. Checked in code in DEV.

                                                                                                                                         6/22/10: Able to clear check, however transaction not appearing
                                                                                                                                         on the offender account. #510009, 241080.

                                                                                                                                         6/21/10: Complete. Should go together with automatic
                                                                                                                                         deductions.

                                                                                                                                         6/18/10: Expected completion 6/18/10

                                                                                                                                         6/17/10: Deteremined that this is needed BEFORE the authorized
                                                                                                                                         deductions can be programmed to ensure that unleared checks
                                                                                                                                         can be viewed and cleared manually for quick release.



artf1244   Inmate        Offender Batch   Offender Batch -       #1244: When processing an ofender batch, depending on the             7/1/10: Validated the same scenarios in UAT - approved.                                                                                    Mary Sandy        6/30/10
           Banking                        Various                transction code selected - the add icon doesn't always appear
                                                                 providing hte user the ability to enter 10 more lines - this needs to 6/30/10: Validated a variety of transaction codes and appear to
                                                                 be avaialble on all transaction codes.                                have the ID removed.

                                                                 #1245: Remove the "ID" reference - not needed                           6/22/10 - Tried a variety of transaction codes and not all reflected
                                                                                                                                         the removal of the "ID" - this needs to be removed from all
                                                                                                                                         transaction codes (ie: 238, 214, etc)

artf1326   Inmate        Payroll          Payroll transfer to    Forced savings deductions may not be working properly. See steps 7/1/10: Validates offenders: 36315, 189627, 310791, 496361,                   Added ofndr_acct_bal tooffdnr_acct_mtd col.                       Patty (Hld Mtn)   6/30/10
           Banking                        forced savings         to recreate.                                                     19467, 24 by processing payroll and confirming that amounts
                                                                                                                                  were correctly applied.

                                                                                                                                         6/30/10: validated offenders: 308451, 241773, 383529, 482212,
                                                                                                                                         245760 by processing payroll and confirming that the appropriate
                                                                                                                                         amounts were applied to forced savings and checking accounts.

artf1331   P&P           Sex Offender     Sex Offender Release   1. FUTURE Sex Offender Release reports, by Institution. Flexible        7/1/10: Validated same scenarios as doen in QA - all retrieved                                                                           Terri Telkamp     6/30/10
                         Release Report   Report                 date range function works fine, but there seems to be an                sex offenders - no issues found.
                                                                 intermittent problem with the information showing up.
                                                                                                                                       6/30/10: Validated a variety of locations for a variety of scenarios
                                                                 I have twice today successfully printed the future release report for - all returned data - validated data for accuracy.
                                                                 the Anchorage Jail, with a time frame of 6/9/10 – 9/30/10, but
                                                                 had to log off & reboot ACOMS to get it the second time. So far all
                                                                 further attempts to run this exact same report has yielded a blank
                                                                 report form. All attempts from the ACOMS/Facilities side have
                                                                 yielded blank forms.

                                                                 All other institutions I tried yielded blank report forms. Some, such
                                                                 as Nome CC may not actually have a Sex Offender releasing in the
                                                                 next 3 months; others however, such as Wildwood CC, Palmer CC ,
                                                                 Spring Creek CC, and Hudson CF will most certainly have sex
                                                                 offenders releasing in the next 90-days and all their reports were
                                                                 blank, every time, from both P&P and Facilities.

                                                                 Data is returning a -958 error (Per Lori)




Artifact   Location/Mod Functionality     Title                  Description                                                             Additional Notes                                                       Technical Notes                                                   Issue             Actual
ID         ule                                                                                                                                                                                                                                                                    Source            Completion
                                                                                                                                                                                                                                                                                                    Date
                                                                                                                                                                                                                                                                                                       Page 24 of 48
                                                                                                                                "HOT" Items
                                                                                                     1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality   Title                   Description                                                           Additional Notes                                                     Technical Notes                                                  Issue            Actual
ID         ule                                                                                                                                                                                                                                                              Source           Completion
                                                                                                                                                                                                                                                                                             Date
artf1339   Environment/S Visitors       Missing Data -          Missing Data for conditions related to statewide barred               7/7/10 - UAT Validated.                                                                                                               Don Brand        7/7/10
           ystems                       Conditions
                                                                                                                                      7/7/10 - Validated QA after script was run - statewide barred flag
                                                                                                                                      is checked and visitors are appearing on report.

artf1340   Facilities     Security      Victim's Window and     Users cannot get to the Victims window unless the delete_flg is set 7/7/10: Validated offender 485140 - changed security and                                                                                Lori Wharton     7/8/10
                                        Delete Flag Issues      to ‘Y’ for the psi_s5_16_2 window. They will generate the       received proper error when attempting to delete, however was
                                                                General Processing error below.                                     able to access victim details.

                                                                [cid:image001.png@01CB1773.223F4200]                                  7/6/10: Validated the ability to view a victims detail after
                                                                                                                                      removing the "delete" function from permissions on the
                                                                With Delete_flg = 'Y' on window psi_s5_16_2                           following screen: psi_s5_16_2

                                                               [INFO] 10/06/29 09:46:38
                                                              OtrackRequestProcessor.processPreprocess:
                                                              ======================================================
                                                              ==============
                                                              [INFO] 10/06/29 09:46:38
                                                              OtrackRequestProcessor.processPreprocess: === NEW REQUEST
                                                              [/offenderVictimAction.list] ===========
                                                              [INFO] 10/06/29 09:46:38
                                                              OtrackRequestProcessor.processPreprocess:
                                                              ======================================================
                                                              ==============
                                                              [INFO] 10/06/29 09:46:38
                                                              OtrackRequestProcessor.processPreprocess: getName
                                                              [offenderVictimForm]
                                                              [INFO] 10/06/29 09:46:38
                                                              OtrackRequestProcessor.processPreprocess: getInput
                                                              [/jsp/offender/w_psi_s5_16_2.jsp]
                                                              [INFO] 10/06/29 09:46:38
                                                              OtrackRequestProcessor.processPreprocess: getType
                                                              [otrack.ftrack.offender.offense.OffenderVictimAction]
artf1348   Facilities     STG           STG - DD to Free Form DPP and DOI have been meeting about gangs in the community              7/7/10 - Validated UAT by adding "OTHER" STG to offender 24, as                                                                       Don Brand        7/5/10
                                                              and in the institution. The only way we now have to identify gang       well as other STG's.
                                                              members is by using the Caution button on ACOMS. The Security
                                                              Threat group button has a drop down box of many gangs, but none         7/7/10 - Development was changed to retain DD and add the
                                                              of them are represented in Alaska. We would like to see if you can      option of "OTHER" to the options, allowing the user to free-form
                                                              eliminate the drop down box and let us type in the gang affiliation.    in the comment section the gang - validated in QA.
                                                              Is it possible to just have a blank field
                                                                                                                                      7/6/10 - Development completed.
                                                                7/6/10 - Request received to leave DD list and use the comment
                                                                field to enter a free-form box gang entry in conjunction with the
                                                                STG of "OTHER" in the DD list in the event a gang is not located in
                                                                the DD list. Source: Don Brand.



artf1364   Facilities     TAR           TAR - Sort of "Action   Request received to have the ACTION ITEMS section sort by             See attachment.                                                      [artf1364]                                                       Don Brand/Lori   7/8/10
                                        Items"                  effective date order from oldest to most current.                                                                                           - sorted the Action Information records by Order Date in Time   Fritz
                                                                                                                                                                                                           Accounting Screen as well as in report.
artf1314   Facilities     Victims       Victims - Addresses     A lot of the victims in acoms don’t have there full address from 7/7/10 - Validated UAT - Chowdhry to send email to Lori to                                                                               Don Brand        7/7/10
                                                                the data conversion. ie: 186234: 2421 Eddson as part of the        validate.
                                                                address
                                                                                                                                   7/7/10: Received info from Lori:
                                                                                                                                   1. Ofndr_num 535001 Woody, Jabez – two victims in otis with
                                                                                                                                   addresses, no addresses in acoms victim table.
                                                                                                                                   2. Ofndr_num 534190 Vest, Nichole – two victims in otis with
                                                                                                                                   addresses, no addresses in acoms victim table.
                                                                                                                                   3. Ofndr_num 535924 Emerson, Thomas – same


artf1360   Inmate         Attachments   Attachment - Null       Received error message while trying to look at an attachment for                                                                                                                                            Amy Weichert     7/8/10
           Banking                      Pointer Exception       Glen Morgan #493588 - null pointer exception




                                                                                                                                                                                                                                                                                                Page 25 of 48
                                                                                                                                      "HOT" Items
                                                                                                           1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                     Description                                                             Additional Notes                                                    Technical Notes                                                      Issue              Actual
ID         ule                                                                                                                                                                                                                                                                        Source             Completion
                                                                                                                                                                                                                                                                                                         Date
artf1269   Inmate        Check Printing    Check Printing -          1. Need to have the stob of the checks print. Joe to provide info.      7/8/10 - Validated QA and UAT - offender batch check stub is                                                                             Joe Butler         7/8/10
           Banking                         Location & Offender       2. Need the ability to select a location (should default based on       correctly reflecting information and print check screen has a
                                           Stub                      user login) and ONLY show those checks for that location to be          location selection preventing users from printing checks from
                                                                     printed.                                                                other locations. Sample sent to Devra and Amy.

                                                                                                                                             7/1/10 - Received request to move this to higher level due to
                                                                                                                                             people printing others checks.

artf1357   Inmate        Indigent Status   Indigent Status -         Need to remove the constraint that prevents the user from               7/7/10 - Validated both QA and UAT - able to debit and credit                                                                            Devra Hayes        7/7/10
           Banking                         Constraints               processing funds from an offender's account. Currently if the           indigent offenders (485140, 392301) and still retain account
                                                                     offender has a status of indigent, the user cannot collect funds        status without constraint.
                                                                     from their account without changing the status of the offender.

artf1162   Inmate        Offender Batch    Batch - View Offender     Need to include the offender's account balance (checking) on the        7/7/10 - Validated                                                  [artf1162]                                                           Mary Sandy         7/8/10
           Banking                         Balances                  offender batch transaction at the time being processed.                                                                                      - added a new column in Offender Batch screen for Current
                                                                                                                                                                                                                 Balance
                                                                                                                                                                                                                  - Transaction Code 185 will show Saving Balance else all other
                                                                                                                                                                                                                 shows Checking Balance
artf1345   Inmate        Offender Batch    Offender Batch - Trans When processing a trans code 185 - it is only alllowing a single           7/7/10 - Validated in UAT with 5 offenders on a batch - no issues   I have completed code fix.                                           Amy Weichert       7/5/10
           Banking                         Code 185               offender (1 row) - if you do two you receive an error.                     identified - batch processed.
                                                                                                                                                                                                                 File change:
                                                                                                                                             7/6/10 - Validated the processing of multiple rows within one       --------------
                                                                                                                                             batch - successful posting of batch.                                NonOffenderTransactionSpecificationProcessorImpl.jav
                                                                                                                                                                                                                 ib_transc_detail_m.
artf1349   Inmate        Transaction       Checking to Savings       Need the ability to transfer funds from checking to savings. Create 7/7/10 - Validated UAT                                                  [artf1349]                                                           Cyndi Stegall      7/6/10
           Banking       Codes             Transaction               transaction code 184 to debit checking account and credit savings 7/6/10 - Validated both the 185 annd 184 transactions - both               - made new Transaction Code 184 and Account Number 2400
                                                                     account.                                                            processed debits and credits correctly.                                  - i.e Transfer from Checking to Saving

artf1173   P&P           Contact List      Field Contact List        1. When creating a field contact list the merge case load option        7/7/10 - QA Validated.                                              [artf1242]                                                             Unkown           7/7/10
                                                                     does not work. (Mantis #2406)                                                                                                               [artf1173]
                                                                                                                                             - artf1242.sql                                                       - fixed the merge functionality
                                                                     2. The phone number that is appearing on the contact listing                                                                                 - fixed the correct latest phone number based on start date
                                                                     screen is pulling from the employment (employer) information -                                                                               - fixed the Print all records option if Check all is selected
                                                                     should be the Phones as relasted to the offender.                                                                                            - loading the Field Contact List for PO which was selected in 'Change
                                                                                                                                                                                                                 Field PO'

artf1242   P&P           Contact List      Field PO - Contact List   1. Would like to have the ability to select a Field PO by which to      7/7/10 - QA Validated                                               [artf1242]                                                             Dana Patterson   7/7/10
                                                                     extract their caseload and produce the contact list in its entirety -   artf1242.sql                                                        [artf1173]
                                                                     currently only allows for a single page to print - needs to print all                                                                        - fixed the merge functionality
                                                                     pages when the print is initiated.                                                                                                           - fixed the correct latest phone number based on start date
                                                                                                                                                                                                                  - fixed the Print all records option if Check all is selected
                                                                                                                                                                                                                  - loading the Field Contact List for PO which was selected in 'Change
                                                                                                                                                                                                                 Field PO'

artf1237   P&P           Next              Next Appointment          We are still receiving the Next Appointment Date error in ACOMS         7/7/101 - Validated offender #1200 by adding a variety of        Next Appointment Date will allow when Probation Date will be less       Chris McKenzie     7/5/10
                         Appointment       Date                      when we attempt to save a supervision contact that has an               appointments that exceeded the prob and parole dates - correct than allowed.
                                                                     appointment date that is past an offender’s parole expiration         results returned.
                                                                     date (but not their probation expiration date). Because parole has                                                                       File: w_otr_s2_3.jsp
                                                                     expired, we cannot enter a next appointment date. As offenders          7/6/10 - Validation of supervision contact and next appointments
                                                                     may serve parole and probation concurrently, and usually                beyond parol exp date, but not past prob exp date successful.
                                                                     probation lasts longer than parole, we need this issue fixed. We
                                                                     have been working around it by leaving the appointment date
                                                                     blank in these cases and putting it in the body of the chrono, but
                                                                     that disrupts the integrity of the Appointment feature in ACOMS.

                                                                     Additionally, I have an error that indicates that Contact Time
                                                                     cannot be blank, but it isn’t blank.


                                                                     In the example below, Don Alano (offender 510009) was on parole
                                                                     and probation. Parole expired on 3/11/2010, but probation does
                                                                     not expire until 2/23/2015:




                                                                                                                                                                                                                                                                                                            Page 26 of 48
                                                                                                                                "HOT" Items
                                                                                                     1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality   Title                   Description                                                            Additional Notes                                                       Technical Notes   Issue           Actual
ID         ule                                                                                                                                                                                                                  Source          Completion
                                                                                                                                                                                                                                                Date
artf1327   P&P           Supervision    Supervision Contact    When you select supervision contact, the “Type―      now defaults   7/7/10 - UAT Validated                                                                   Rebecca Brunger 7/7/10
                         Contact                               to “Telephone/Rural―     instead of being blank as before. If you   7/7/10 - Validated QA.
                                                               need to label the type of contact as “Telephone/Rural― doesis
                                                               not read it as a selection and won’t let you enter the contact
                                                               with it selected.
artf1361   P&P           Supervision    Supervision Contacts - The option of "Telephone/Rural" was added in production by              7/7/10 - UAT Validated                                                                   Don Brand       7/7/10
                         Contact        Telephone/Rural        AKDOC to the supervision contact details "Type" DD, however it          7/7/10 - QA Validated.
                                                               needs to be linked to the supervision contact for purposes of
                                                               correctly reflecting contacts. Currently when this option is used,
                                                               user receives and error.
Artifact   Location/Mod Functionality   Title                  Description                                                             Additional Notes                                                       Technical Notes   Issue           Actual
ID         ule                                                                                                                                                                                                                  Source          Completion
                                                                                                                                                                                                                                                Date
artf1156   Facilities    Court Cases    Court Cases - Attorney Under court cases from the offender profile, when entering the          7/14/10 - UAT Validated (525544) - added court case, with                                Elesceeya       7/12/10
                                        Names                  attorney(s) it will not save them, after the information is entered     attorneys - then edited - saved correctly.                                               Pinterton
                                                               and you refresh the page or go back to the offender profile and go
                                                               back into court cases it is defaulting to “unknown―   long story    7/12/10 - QA Validated - added, edited, saved (525515) - attorney
                                                               short, the attorney names are not being saved                           names and other information retained.

artf1176   Facilities    Grievances     Grievance Screen        Based on conversation with Tim, Phillip, Dwayne on 5/25/10,            7/14/10 - UAT validated -email to Tim to confirm.                                        Tim             7/12/10
                                        Modifications           changes are necessary to the grievance screen in addition to data      7/13/10 - QA Validated.
                                                                conversion items that are missing.                                     7/12/10 - New grievance screen is fully functionaly and to Tim's
                                                                                                                                       specifications, however minor format and spelling error require
                                                                The attached document contains a mock-up screen image of what          return to developer.
                                                                is requested.
                                                                                                                                      7/5/10 - Received confirmation from Tim that the grievance
                                                                Offender Response DD:                                                 report is not used, however we will keep in system in the event
                                                                I envisioned using the selection box from OTIS that had selection     future usage is desired.
                                                                choices. The choices are something like this: "Appealed timely",
                                                                "Appealed, not timely", "Satisfied with Decision", Not Satisfied, but
                                                                Not Appealed", and "None". If a selection box would be used
                                                                instead of a text box, it might fit to the right of the "screened..."
                                                                field boxes.

                                                                Conversion data elements missing need to be converted once the
                                                                screen is completed.

                                                                7/5/10: (TIM) -
                                                                1. The Generated Grievance form—we will not be using it.

                                                                2. The Screened Appeal Response drop down list—I think if you
                                                                add another of the existing drop down lists called “GRIEVANCE
                                                                                   and
                                                                DISPOSITION― staff can make the appropriate selection from
                                                                it.
                                                                3. The Screened Decision Drop Down List—This is a new request
                                                                based upon comments from the field. Could you please add a
artf1375   Facilities    Release        Release List - Stored   letter in a logic error options then sort it alphabetically so the list
                                                                There is front of the in the stored procedure get_rlse_list. This has 7/15/10 - Validated offender in UAT - email to Lori to validate.                          Lori Wharton    7/14/10
                                        Proc "Null" Issue       popped up before but was not able to pinpoint it until now.
                                                                Offender 352323 Hess, is showing on the release list at WCC, but
                                                                he is currently housed at Parkview. He is not assigned to a bed at
                                                                WCC. There are no errors in his location records. The stored
                                                                procedure is picking up on a old 2005 record in the
                                                                offsite_ofndr_loc table that has both a start and end date present.
                                                                There is no check for ‘end_dt is null’ in a couple of places in
                                                                the stored procedure.

artf1380   Facilities    Release        Release - Booking vs.   The booking record is not updating the release date/time when          7/15/10 - Validated UAT - #1200 (sch rel); #221904 (off rel.) - both                     Sgt. Moriarty   7/14/10
                                        Scheduled Release       processed through the scheduled release only occurring when            processed and updated the booking release date.
                                                                processed through the offender release in booking.
                                                                                                                                       7/14/10 - Validated QA




                                                                                                                                                                                                                                                   Page 27 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                   Description                                                           Additional Notes                                                   Technical Notes                                                 Issue          Actual
ID         ule                                                                                                                                                                                                                                                               Source         Completion
                                                                                                                                                                                                                                                                                            Date
artf1335   Inmate        Bank Deposit       Bank Deposit -          I have attached a copy of all three servers not showing the bank      7/14/10 - Validated a deposit w/wo checks and currency - report Now entering cash Deposited in Depositor screen appering on        Devra Hayes    7/12/10
           Banking                          Currency                deposit info. Before emailing you, I double checked this issue and    refected on all and reduced currency amount on till available   Report.
                                                                    what I have figured out was the reports are there and you can print   balance.
                                                                    them as long as you have checks with them. If you go into the                                                                         SPL Name: get_bank_deposits_m
                                                                    inmate banking under till and you try to print out a bank deposit     7/13/10 - QA Validated both w/wo cash and checks
                                                                    report that has only currency deposit amount, you get the attached    7/12/10 - Report still blank
                                                                    message. I figured this out by going into ACCE Cash report account
                                                                    and verifying their 2/25/2010 report which would have been
                                                                    printed back then.

artf1338   Inmate        Court Report       Court Report inmate     Court Report showing statistics on offender accounts                  7/15/10 - Validated in UAT by Don Brand                                                                                            Don Brand      7/15/10
           Banking                          accounts
                                                                                                                                          7/12/10 - Pending User acceptance - Joe to work with user to
                                                                                                                                          validate report.

                                                                                                                                          7/6/10 - Report is done - needs to be moved to the qa server for
                                                                                                                                          testing.

                                                                                                                                          Separate web application (Patrick)
artf1365   Inmate        General Ledger     General Ledger Check    Need to have the general ledger check stub print with the check.      7/14/10 - Validated UAT - offender and general batch - check       Now able to print General Ledger Checks to print report.        Amy Weichert   7/12/10
           Banking                          Stub                                                                                          stubs are fine.
                                                                                                                                                                                                             File created:
                                                                                                                                          7/13/10 - Validated both offender and general ledger checks -      -------------------
                                                                                                                                          able to enter check number and have stubs and check print          check_print_gl_rpt.jasper
                                                                                                                                          properly.

                                                                                                                                          7/12/10 - Check stub looks great!, however unable to enter a
                                                                                                                                          check number (not saving).
artf1275   Inmate        Offender Account Till Transaction Details - Need to idnetify the person that processed the till receipt on the   7/14/10 - Validated offender a/c and statement - both are          Now display who has deposited either check or cash amounts in   Amy Weichert   7/12/10
           Banking                        Offender Account                                                                  but
                                                                     offender account not just say “till 10200 receipt― actually      reflecting depositor name.                                         ofndr statment.
                                                                     show who deposited the money.
                                                                                                                                          7/13/10 - Statement is now correctly reflecting depositor or ref  SPL Name: ib_iboffbal_new
                                                                                                                                          doc.
                                                                                                                                          7/12/10: Ref Doc is reflecting the depositor on the screen,
                                                                                                                                          however not reflected on the offenders statement and needs to
                                                                                                                                          be - in addition, the offenders statement has incorrect available
                                                                                                                                          balance.
artf1381   Inmate        Offender Batch     Insufficient Funds      Truncation of amoutn causing NSF when processing batch.               7/15/10 - EMERGENCY MOVE - validated QA and UAT - processed                                                                        Devra Hayes    7/15/10
           Banking                                                                                                                        with no errors.
artf1290   Inmate        Payroll            Payroll Hours & Batch   Batch is reflecting a single location, however reflects offenders     7/14/10 - Processed same test in UAT as QA (FCC, SCCC) - no                                                                        Devra Hayes    7/12/10
           Banking                                                  from a variety of locations.                                          issues found.

                                                                    Examples (PROD):                                                      7/12/10 - Ran 2 payroll batches: Anvil and FCC - both processed
                                                                    Batch 3860 - Ketchikan; 6/3/10                                        with no issues, and when the offender batch was queried, but
                                                                    Offenders: 508157, 528731, 420534                                     reflected the correct offfender information and location.

artf1336   P&P           Probation Time     Probation & Parole      The probation and parole expiration dates are not appearing in the 7/15/10 - UAT Validated.                                                                                                              James Dabbs-   7/14/10
                                            Expiration Dates        header of hte offender.                                            7/14/10 - QA validated                                                                                                                Ashworth
                                                                    Example: Offender 524895
Artifact   Location/Mod Functionality       Title                   Description                                                        Additional Notes                                                      Technical Notes                                                 Issue          Actual
ID         ule                                                                                                                                                                                                                                                               Source         Completion
                                                                                                                                                                                                                                                                                            Date
artf1392   Environment/S Security           Inmate Banking - DD     The location drop down was based on security causing drop down "7/21/10 - UAT Validated.                                                                                                                 Paul Brown     7/22/2010
           ystems                           not appearing           for some inviduals to not be reflected. This appears to be a recent 7/20/10 - QA Validated"
                                                                    modification to the permissions as a result, we needed to modify
                                                                    the code to allow all users to see location drop down.




                                                                                                                                                                                                                                                                                               Page 28 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                    Description                                                              Additional Notes                                               Technical Notes                                              Issue           Actual
ID         ule                                                                                                                                                                                                                                                           Source          Completion
                                                                                                                                                                                                                                                                                         Date
artf1137   Facilities    Cell Assignment   Locations - EM           6/14/10:                                                                 7/21/10: Validated UAT by processing both mass and bed                                                                      Sgt. Moriarty   7/22/2010
                         DD                                         We need to add move/prison housing to the reason field. The              assignment, verified legal status and location. In addition,
                                                                    current options are not adequate. This is needed for EM                  validated the offsite location and the EM is now an option.
                                                                    placement, as well as correcting errors in the location history…for    (531647)
                                                                    example, moves in here are defaulting to sentenced.
                                                                                                                                         7/20/10: QA Validated
                                                                    7/15/10 (Donna White): When moving offenders in the institution Related to 1168
                                                                    using the Mass Bed Assignment, the status changes to
                                                                    “sentenced―    rather than Move/Prison housing, which is really
                                                                    what it is. The second issue is that when the legal status change is
                                                                    to inmate, the obvious reason for that would be “sentenced―    ,
                                                                    but that is not an option in the drop down box.

                                                                    7/18/10: Need to add the option of Electronic Monitoring to the
                                                                    Offsite Location, "Location Type" DD and add the avaialble options
                                                                    of: Anchorage EM, Palmer EM, Fairbanks EM




artf1138   Facilities    Facility Roster   Facility Roster Report   1. Would like to have the additional field of "housing assignement" 7/21/10 - UAT Validated and approved.                               Now added Housing assignment selection from faclity roster   Sgt. Moriarty   7/22/2010
                         Report                                     (tier) be added to the search criteria.                             7/20/10 - QA validated - ran report for various scenarios w/wo      report.
                                                                    2. Would like to include a time stamp in the footer at the time the cell/bed assignments - all retrived properly.
                                                                    report is generated                                                                                                                     Files Modified:
                                                                                                                                                                                                            ------------------
                                                                                                                                                                                                            facltyRosterReport.jsp
                                                                                                                                                                                                            reportFormFacilityUnitSelect.jsp

                                                                                                                                                                                                            FacltyReportProcessorRosterIfc.java
                                                                                                                                                                                                            FacltyReportProcessorRosterImpl.java
                                                                                                                                                                                                            FacltyRosterReportAction.java
                                                                                                                                                                                                            FacltyRosterReportForm.java
                                                                                                                                                                                                            PrisonUnitWrapper.java

                                                                                                                                                                                                            faclty_roster_report.jrxml
                                                                                                                                                                                                            faclty_roster_report.jasper
artf1248   Facilities    File Location     File Location            It appears this information was never imported into ACOMS from 7/21/10 - UAT updated with conversion data - need verification                                                                        Gary Harris     7/22/2010
                                                                    Otis, although ACOMS has a place for it (Inmate Search in Facilities, by Gary Harris.
                                                                    File Location). Apparently Policy is that File goes with Inmate.
                                                                    Procedure-wise, this often does not happen and some facilities do 7/20/10 - QA updated with conversion data.
                                                                    not even bother to enter that they have received files. So, CJTs
                                                                    have inmates but no files and they need to look up where the file
                                                                    was last. They compare FILE LOCATION to LOCATION and
                                                                    sometimes figure out where the files might be located.

                                                                    It creates extra work for CJTs to "receive" a file in ACOMS that they
                                                                    already have received in Otis, because none of that historical data
                                                                    transferred. But the greater issue is this - - - Sometimes inmates
                                                                    have several files and sometimes these files are in different
                                                                    locations. Example is an inmate who has a Field file and a Prison
                                                                    file. Lets say they are out on probation. Do their time and are
                                                                    discharged. Well, the last institution has their prison file but field
                                                                    probation has their Field file. Or Field probation has both. Inmate
                                                                    goes to another location, gets put back in Jail and CJTs need to look
                                                                    and see where their files are located and have them mailed.

                                                                    6/16/10: Need to identify a better location DD as it is currently
                                                                    pully the body location list, however this is greater than is
                                                                    needed.

                                                                    6/18/10: The location of file is reflecting "unknown" on the listing
                                                                    screen in error.




                                                                                                                                                                                                                                                                                            Page 29 of 48
                                                                                                                                       "HOT" Items
                                                                                                            1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality        Title                   Description                                                           Additional Notes                                                    Technical Notes                                                    Issue           Actual
ID          ule                                                                                                                                                                                                                                                                    Source          Completion
                                                                                                                                                                                                                                                                                                   Date
artf1233    Facilities     ID Card &          ID Card - Font Size     This specific request is to enlarge the font size of the offenders    7/21/10 - UAT Validated.                                            Font size increased to Offender No ,Offender Name Fields.          Michael Gimm    7/22/2010
                           Commitment                                 name and number for increased visibility.                             7/20/10 - QA Validated - Name/Number font increased, color
                           Card                                                                                                             returned to ID card.                                                File Modified : IDCards.jasper

                                                                                                                                            7/6/10: Name and Number font size needs to be increased again - OffenderIdentificationCardAction.java
                                                                                                                                            still too small - in addition color of custody level is not appearing. OffenderSearchProcessorImpl.java

artf1168    Facilities     Legal Status       Legal Status -          Why is ACOMS changing the legal status of inmates when they are       7/21/10 - Validated UAT - email sent to Sgt. Moriarty to confirm.                                                                      Sgt. Moriarty   7/22/2010
                                              Movement                moved? It does this when moving them from CRC to here, in
                                                                      attached example. It also changes legal status when in transport or   7/20/10 - Validated QA - move processed, only location reflected
                                                                      hospital in off site location. It makes it confusing to time          change, legal status did not update
                                                                      accounting staff. The below example should show move/prison
                                                                      housing, not sentenced.
artf1372    Inmate         Attachments        Attachments -           When an attachment payment is processed, it needs to reflect the      7/21/10 - UAT Validated for description.                            [artf1372]                                                           Amy Weichert   7/22/2010
            Banking                           Description             correct transaction code and description on the offender account      7/15/10: offender 1200 validated in QA.                              - changed the logic to process Attachments from Payroll with
                                                                      summary (and statement)                                                                                                                   seperate transaction codes.
artf1390    Inmate         Attachments        Attachment - Data       Data conversion did not flag attachments as "N" resulting in a        7/21/10 - UAT Validated                                             [artf1390]                                                           Amy Weichert   7/22/2010
            Banking                           Conversion - Null       "NULL" indicator and preventing processing of attachments             7/20/10 - QA Validated                                               - override Src flag was set to null during data conversion, I am
                                              Pointer                 through payroll.                                                                                                                          checking Y and N in business logic. Now handled the null
                                                                                                                                                                                                                comparision.
                                                                                                                                                                                                                 - populating the default values for converted records on attachment
                                                                                                                                                                                                                screen
artf1366    Inmate         Offender Batch     Offender Batch          We are still having issues with the pages scrolling back to the top   7/21/10 - Processed a UAT batch (92) - added 10 lines - cursor                                                                           Ken Patten/Don 7/22/2010
            Banking                           Scrolling               10 entries when after adding rows in a batch.                         moved to next available row (offender field)                                                                                             Brand

                                                                                                                                            7/15/10 -- Processed QA batch and cursor stayed on last entry
                                                                                                                                            instead of returing to top when additional lines are added.

artf1391    Inmate         Quick Release      Quick Release - Saving Under certain conditions, the quick release is not saving and          7/21/10 - Validated 3 offenders by processing quick release w/wo [artf1391]                                                            John Clark      7/22/2010
            Banking                                                  redirecting to the disbursement screen.                                attachments and verifying that check was generated and            - removed the check for balance comparision to actual till balance
                                                                                                                                            offender account released.                                        - redirected back to Quick Release after getting the error.

artf1383    Inmate         Receipting Cash - Till Receipt             Need to remove the depositors address from the receipting case        7/21/10: UAT Validated and sample sent to AMy and Devra for         Removed depositor Address from Till Receipt & Report.              Amy Weichert    7/22/2010
            Banking        Receipt                                    receipt that is generated in the till.                                validationt in UAT environment.
                                                                                                                                                                                                                Files :receiptingCheckDetails.jsp
                                                                                                                                             7/18/10: QA Validated - receipting and disbursing.                      depost_receipt.jasper
artf1378    P&P            Supervision        Supervision Contact     Concerning the offender BENTLEY, Daniel (#396327), in supervision 7/21/10 - Validated the addition of a supervision contact (7731)                                                                           Travis Morris   7/22/2010
                           Contact                                    contact entry dated 6/16/2010, I had written the chrono where I        in UAT, using numbering and row separations - saved and printed
                                                                      numbered out what he received as sentences in three different          with same format as entered. Email sent to Chris McKenzie for
                                                                      cases, one below the other and so forth. I printed out the chronos validation.
                                                                      before the chrono itself actually closed out (see his field file-PO
                                                                      Wallace will have it), and it appeared as I had typed it. However, it 7/20/10 - Validated QA (504214)
                                                                      now appears that once the chrono closed out, they were not
                                                                      labeled one after another. It looks like the chrono was clumped
                                                                      together with all spaces between lines removed, and the chrono
                                                                      appears pretty jumbled now. I know it’s not a huge issue, but
                                                                      there are certain chronos I and I am sure some other POs would
                                                                      like to be able to label things sequentially or separately, but now it
                                                                      appears that once the chrono closes out, it doesn’t really
                                                                      matter, it still jumbles the sentencing together.



 Artifact   Location/Mod     Functionality              Title                                      Description                                                        Additional Notes                                                     Technical Notes                               Issue         Actual
   ID            ule                                                                                                                                                                                                                                                                    Source       Completion
                                                                                                                                                                                                                                                                                                        Date




                                                                                                                                                                                                                                                                                                       Page 30 of 48
                                                                                                                                  "HOT" Items
                                                                                                       1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                   Description                                                           Additional Notes                                                     Technical Notes                                Issue            Actual
ID         ule                                                                                                                                                                                                                                               Source           Completion
                                                                                                                                                                                                                                                                              Date
artf1218   Booking       Custody Level &   Adjusted Release Date I spoke with Jan Jenski this morning where she pointed out a      7/29/10 - UAT validate - email sent to Sgt. Moriarty to confirm.           1218                                           Don Brand        7/30/10
                         ARD               and Custody Level -   inmate that was recently booked at Mat Su. She informed me that                                                                              -------------------
                                           New Bookings          his custody level is minimum, although he was recently booked for 7/26/10 - QA Validate                                                      SPL
                                                                 a few felonies which makes him higher then major custody. She                                                                                ------------
                                                                 also informed me that she’s the one that would decide this                                                                                 get_ofndr_clfn
                                                                 after she works with the inmate over the next few weeks. The                                                                                 refer_to_supvr_m
                                                                 custody level which she showed me was from 1/8/08. She was                                                                                   get_verified_prsn_rlse_m
                                                                 wondering if there was a way when a person is booked into the                                                                                get_off_history_assgn_m
                                                                 system, the custody level would automatically close out the prior
                                                                 custody level.                                                                                                                               OffenderCustodyLevelAction.java
                                                                                                                                                                                                              OffenderCustodyLevelClassificationVO.java
                                                                   (Sgt Moriarty): ACOMS needs to reset custody to unclassified after                                                                         OffenderCustodyLevelProcessorImpl.java
                                                                   a release. Currently it shows the last custody level, which is void                                                                        OffenderCustodyLevelReferToSupervisorVO.java
                                                                   when an offender is released, and upon new remand, they need to                                                                            w_dio_s9_4.jsp
                                                                   be reclassified.                                                                                                                           get_high_cstdy_lvl.sql

artf1240   Facilities    Court Cases       Court Case Status       1. Unable to add or edit a case status. - NO LONGER AN ISSUE -        7/29/10 - UAT validated - ran various scenarios (507031) - email     artf1240.sql                                   Jessica          7/30/10
                                                                   ABLE TO EDIT AND ADD.                                                 sent to Chris & Paul to confirm.                                                                                    Warnement &
                                                                   2. When users are attempting to update/insert a case status, the                                                                                                                          Chris McKenzie
                                                                   program is attempting to insert a new legal status record – even    7/26/10 - Ran all 4 scenarios under offender 507031 in the QA
                                                                   if the box is not checked. This is generating -1402 errors on spl     environment - no issues found.
                                                                   get_case_stat_m. In these instances the legal status was already
                                                                   entered correctly (ie Discharge) and the system is attempting to      artf1240.sql
                                                                   enter a duplicate legal status. We also get -1402 errors on spl
                                                                   update_case_status. - NO LONGER AN ISSUE - ABLE TO EDIT AND
                                                                   ADD AND LEGAL STATUS DOES NOT CHANGE - NO ERROR
                                                                   RECEIVED.
                                                                   3. 6/25/2010: I am having an issue dealing with a court case status
                                                                   and the discharge error I reported yesterday. For Tamika
                                                                   Henderson (507031) I am attempting to update her Court Case
                                                                   Status for 3AN-S10-05053CR to reflect that she has a Suspended
                                                                   Imposition of Sentence (Probation). However, when she was
                                                                   discharged from the institution on 5/22/2010, her Case Status was
                                                                   cleared completely. When I attempt to update her case status, I
                                                                   then go into the Court Case Status Listing screen, which indicates
                                                                   UNSENTENCED, with an end date of 5/22/2010. In order to add a
                                                                   new status, I need to clear that End Date. So I attempt to edit the
                                                                   Unsentenced Case Status to remove the End Date. However, when
artf1368   Facilities    Custody Level     Felon or Misd.          I bringto modify the following code to include the booking charges
                                                                   Need up Court Case Status Details, the Change Reason is               7/29/10: UAT validated - email sent to Sgt. Moriarty to confirm.                                                    Don Brand/Lori   7/30/10
                                           Determination           and the referred offenses as a decision factor in the determination                                                                                                                       Wharton/Sgt.
                                                                   of whether Felon or Misd. In addition, have the ability to override   /27/10 - Booked an offender 536638 for a MISD charge, reflected                                                     Moriarty
                                                                   the on teh Legal Status screen, if desired.                           correctly in header - then added referred offense for a felony
                                                                                                                                         charge - header reflected accordingly - deleted referred offense -
                                                                      SELECT count(*) into l_fln FROM crt_case cc,crime_degree_cd        returned to misd.
                                                                   cd,rfrd_ofnse ro
                                                                      WHERE cc.intr_case_num = ro.intr_case_num
                                                                       and ro.crime_degree_cd = cd.crime_degree_cd
                                                                       and cd.severity_lvl in (1,2,3,4,5)
                                                                       and cc.crt_trmn_dt is null
                                                                       and ro.ofndr_num = i_ofndr_num;

                                                                      SELECT count(*) into l_mdmnr FROM crt_case
                                                                   cc,crime_degree_cd cd,rfrd_ofnse ro
                                                                      WHERE cc.intr_case_num = ro.intr_case_num
                                                                       and ro.crime_degree_cd = cd.crime_degree_cd
                                                                       and cd.severity_lvl in (6,7,8,9,10,99)
                                                                       and cc.crt_trmn_dt is null
                                                                       and ro.ofndr_num = i_ofndr_num;

                                                                       IF l_fln > 0 THEN
                                                                        LET o_crm_dgr = 'Felon';
                                                                       ELIF l_mdmnr > 0 THEN
                                                                        LET o_crm_dgr = 'Misdemeanor';
                                                                       END IF
                                                                                                                                                                                                                                                                                 Page 31 of 48
                                                                                                                                      "HOT" Items
                                                                                                           1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                      Description                                                            Additional Notes                                                      Technical Notes                                                         Issue           Actual
ID         ule                                                                                                                                                                                                                                                                             Source          Completion
                                                                                                                                                                                                                                                                                                           Date
artf1130   Facilities    Legal Status      Legal Status - M or F      There needs to be an ability in here to indicate whether the       7/29/10: UAT validated - email sent to Sgt. Moriarty to confirm.                                                                                  Sgt. Moriarty   7/30/10
                                                                      offender is a Misdemeanant or a Felon. Very important! This is how
                                                                      we know where to house the offender, what prisoner clothing they 7/27/10 - Validated offender 536638 - updated legal status with
                                                                      need, etc. This is a critical operation requirement.               F/M/B - all worked and if non - returned to original that was set
                                                                                                                                         by charges/offenses.

                                                                                                                                             7/26/10 - When the field on the legal status screen is updated,
                                                                                                                                             the header is updating, however the legal status in the header is
                                                                                                                                             also updating - shouldn't only the section in the custody level.
                                                                                                                                             (507031)

artf1449   Facilities    Payroll           Payroll - Adjustment       Need to modify the SPL to update the table when a payroll              7/30/10 - UAT Validated                                               Fixed                                                                   Cyndi Stegall   7/30/10
                                                                      adjustment is processed to correctly pay the offender.                 7/28/10 - QA Validated
                                                                                                                                                                                                                   SPL Modified : get_work_time_dtl

                                                                                                                                                                                                                File:
                                                                                                                                                                                                                LaborHoursDetailProcessorImpl.java
artf1239   Facilities    Time Accounting Adjusted Release Date Lori Fritz and I were in agreement that the release date on the               7/29/10 - UAT validated - email sent to Lori Fritz and Sgt.        1239                                                      Sgt. Moriarty &                  7/30/10
                                         vs. Sched. Rel Date   profile should link to the scheduled release date, not the time               Moriarity to confirm.                                              -------------------------                                 Lori Fritz
                                                               accounting section.                                                                                                                              SPL
                                                                                                                                             7/27/10 - Added offenders to "scheduled release list", the release -----------
                                                                      In addition, the label on the header should be changed from            date is appearing on the header of the offender profile as it      get_cen_s1_d
                                                                      "Adjusted Release Date" to "Release Date"                              should. (221904, 135366) - updated TAR - ARD - date did not        OffenderSearchProcessorImpl.java
                                                                                                                                             populate in the header and the IPO Desktop still reflected ARD     Offender.java
                                                                                                                                             correctly.                                                         OffenderHeaderGenralSpec.jsp
artf1430   Inmate        Attachment/Auth Authorized Deductions - The authorized deduction (attachments) are not populating the               7/29/10 - UAT Validated - completion dates are populating when Comparision between Order Amount and Collected Amount was not Cyndi Stegall                    7/30/10
           Banking       orized          Completion Date         "Completion Date" when the attachment has reached it's order                the order amount is collected.                                     proper. Fixed now.
                         Deductions                              amount as being collected. The attachments are no longer
                                                                 retaining funds, however the completion date should be populated 7/27/10 - QA Validated (536639)
                                                                 and the attachment moved to a closed status

artf1373   Inmate        Medical           Medical Transaction        The medical transaction code: 50 - need the system to allow            7/29/10 - UAT validated - email sent to Kari, Devra, Kevin to         [artf1373]                                                           Kari French        7/30/10
           Banking       Payments          Codes - Override           processing against an offender's account EVEN if they don't have       confirm.                                                               - blocked the Medical Transaction Trans Code 50 to not call the NSF
                                                                      enough $$ - allow their account to go to a negative for medical                                                                              check from Offender Batch.
                                                                      payments ONLY. This inlcudes attachments                               7/27/10 - Validated QA (525501, 525502) by processing a batch
                                                                                                                                             50 that exceeded their balances - processed; processed a 14           - NO SQL FILES.
                                                                                                                                             batch - same offenders, would not allow processing due to
                                                                                                                                             balance. OK to move to UAT
artf1273   Inmate        Till/Teller       Till/Teller - Receipting   1. Provide the ability to receive “payroll― through the till and   7/30/10: Validated UAT (420336) by running various scenarios -        [artf1273]                                                              Amy Weichert    7/30/10
           Banking                         Cash                       process applicable forced savings and attachments.                     email sent to Amy and Devra to confirm.                                - enabled the Payroll process from Till Transactions
                                                                      2. Include the "type" of check that is being receipted on the                                                                                 - if Payroll Flg = N, do not split amount, deposit amount in CHK and
                                                                      receipt.                                                               7/27/10: Ran offenders 536639, 536638 through the following           process attachments on Balance Till.
                                                                      3. Correct the location of an offender when brought up on the          scenarios: Till, Payroll, Attachments, balancing, etc. all procesed    - if Payroll Flg = Y, split the amount into CHK and SAV, process
                                                                      receipting screen to reflect the offender’s current location
        accordingly.                                                          attachments on Balance Till.
                                                                      4. If $$ is receipted, need to process applicable attachments when                                                                            - rectified the offender location issue.
                                                                      the batch is balanced - example: attachment with the source =          7/26/10:
                                                                      "ALL" should take appropriate funds from $$ being receipted, same      1. Type of check is not appearing on the receipt. -- SENDHIL's
                                                                      as would happen on a payroll batch.                                    PART - FIXED.
                                                                      5. Update the attachment to only deduct up to the total order          2. The radial button for payroll on the receipting cash/checks is
                                                                      amount, if applicable, and upon reaching the order amount enter a      allowing selection as a result 525505 processed as payroll. --
                                                                      completion date and close the attachment.                              FIXED
                                                                                                                                             3. Processed payroll for 525511 - cleared check - but $ does not
                                                                                                                                             reflect in savings account. -- FIXED




                                                                                                                                                                                                                                                                                                              Page 32 of 48
                                                                                                                                    "HOT" Items
                                                                                                         1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality       Title                  Description                                                          Additional Notes                                                     Technical Notes                                                      Issue           Actual
ID          ule                                                                                                                                                                                                                                                                    Source          Completion
                                                                                                                                                                                                                                                                                                   Date
artf1199    P&P            Community Work Community Work            1. Court case is disappearing when you reenter (edit/view) the       7/29/10: UAT validated - email sent to Chris to confirm.             Fixed                                                                                7/30/10
                           Service        Service                   community work service (Mantis 2212)
                                                                    2. An issue regarding ACOMS improperly changing the amount of        7/27/10: Error has been fixed and hours are allowing to be saved Files Modified:
                                                                    Community Work Service values has been reported to me. It would      in decimal points as well.                                       ------------------
                                                                    appear that the CWS screens of ACOMS do not allow decimals                                                                            CommunityServicesAction.java
                                                                    (e.g., 4.5). CJT York was attempting to update the CWS entry for     7/26/10: Receiving an error: [SEVERE] 10/07/26 09:01:14          CommunityServicesProcessorImpl.java
                                                                    Daniel MAULE (89145) to reflect he had worked 4.5 hours of CWS.      CommunityServicesProcessorImpl.saveCommunityServicesDetail: CommunityServicesVO.java
                                                                    When she attempted to save it, the Community Work Service            SQLException: java.sql.SQLException: Routine
                                                                    Listing screen indicated 0 hours completed. Changing the value to    (get_cmnty_srvce_m) can not be resolved. error Code -674         web/jsp/ftrack/w_psi_s2_9.jsp
                                                                    4, the CWS screen showed 4 hours completed. So, apparently it        [INFO] 10/07/26 09:01:14
                                                                    doesn’t like decimals. I do not like to round the number of        CommunityServicesProcessorImpl.saveCommunityServicesDetail:
                                                                    hours an offender performs community work service, however.          --end---
                                                                    When an offender is ordered to work 80 hours of CWS, they need       [SEVERE] 10/07/26 09:01:14 CommunityServicesAction.add:
                                                                    to work all 80 hours.                                                Exception:
                                                                                                                                         class=otrack.ftrack.supervision.CommunityServicesProcessorImpl
                                                                                                                                         ,method=saveCommunityServicesDetail,message=Routine
                                                                                                                                         (get_cmnty_srvce_m) can not be resolved.,date=Mon Jul 26
                                                                                                                                         09:01:14 MDT 2010errorCode=-674




artf1355    P&P            Field PO Desktop Field PO Desktop - Sort 1. Field PO Desktop - Need to include ALL column headers in the      7/29/10 - UAT validated and email sent to Jessica to confirm.                                                                             Jessica Mathews 7/30/10
                                            Options                 sort options:
                                                                                                                                         7/27/10 - QA validated - all columns are sorting properly.
                                                                    2. Field PO Desktop Report - Need to have the report also provide
                                                                    the sort options.

                                                                    Name
                                                                    Offender #
                                                                    Supervision Level
                                                                    Probation Expiration Date
                                                                    Parole Expiration Date
                                                                    Last Office Contact
                                                                    Last Field Contact
                                                                    Reassessment Due
                                                                    Last Substance
 Artifact   Location/Mod     Functionality            Title                                     Description                                                       Additional Notes                                                       Technical Notes                                Issue          Actual
   ID            ule                                                                                                                                                                                                                                                                   Source        Completion
                                                                                                                                                                                                                                                                                                        Date
artf1320    Environment/S Public View        Public View Screen     Two Tabs:                                                            8/4/10 - UAT Validated - Tab label issue to be resolved in a build   [artf1320]                                                           Don Brand       8/5/10
            ystems        Screen                                    Public View is Booking Profile:                                      this evening. Email sent to Lori.                                     - blocked the property add, edit links.
                                                                    1. Minus: photo, address, bookings, booking charges, referred                                                                              - corrected the sort order for STG
                                                                    offenses, cautions, education, family/associates                        8/3/10; QA Validated                                               - corrected the logic STG in red color v/s regular color scheme.
                                                                    2. Remove SSN from the ‘basic info’ detail
                         8/2/10 Issues:
                                                                    3. Plus: visitors, warrants                                             1. STG is appearing in RED on the offender profile screen and out - Added the STG link on Offender Profile
                                                                    All is read only.                                                       of alpha order.
                                                                    4. Report tab                                                           2. The property link screens don't appear to be driven by security
                                                                                                                                            tables, as a result unable to set as "view only" (w_dio_s2_16,
                                                                    Note: Screen with only an offender tab and a "report" tab and only w_dio_s2_16b, w_dio_s2_15)
                                                                    an offender search menu, is arrived at by a new ‘Navigation
                                                                    Screen’ option of ‘Public View’. This also requires a new
                                                                    group role of ‘Public View’, which hides all other screen and
                                                                    navigation options.
artf1155    Facilities     Detainers/Holds   Detainers/Holds        • Ability to save a detainer/hold, even if a “sent to facility      8/4/10 - UAT Validated (493892) - email sent to Wayne Romberg [artf1155]                                                               Wayne Romberg 8/5/10
                                                                            is
                                                                    date― not entered                                                     to confirm.                                                         - fixed the Sent to Facility, was throwing Number format because
                                                                    • Ability to backdate the effective date or “sent to facility                                                                          Prison Division ID is a combination of Integer and String values.
                                                                    date―                                                                 8/3/10: QA Validated.
                                                                    • Ability to post-date the , or effective date or “sent to facility                                                                    [artf1155]
                                                                    date―.                                                                                                                                    - made the sent to facility date as non mandatory field
                                                                                                                                                                                                                - set the facility code internally




                                                                                                                                                                                                                                                                                                      Page 33 of 48
                                                                                                                               "HOT" Items
                                                                                                    1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                 Description                                                         Additional Notes                                                   Technical Notes                                                      Issue             Actual
ID         ule                                                                                                                                                                                                                                                              Source            Completion
                                                                                                                                                                                                                                                                                              Date
artf1428   Facilities    Labor Hours      Payroll Hours - 1/4   Modify labor hours to accept ¼ hour increments into the hours      8/4/10 - UAT validated - email sent to Donald to confirm.          [artf1428]                                                           Donald Kirstine   8/5/10
                                          Segments              worked.                                                                                                                                 - database has less space to store the decimal points as compared
                                                                                                                                    8/4/10 - QA Validated.                                             to the code.
                                                                                                                                                                                                        - fixed the edit payroll hrs.
                                                                                                                                     8/3/10 - Applied payroll hours to: 267351, 533371, 56217, 495658
                                                                                                                                     - applied correctly - only issue was unable to access detail
                                                                                                                                     screen.                                                           [artf1420]
                                                                                                                                                                                                        - changed the text box to allow decinal points
                                                                                                                                     8/2/10 - Applied payroll hours to: 28191 (45.5) and 144456         - also changed the VO and Action class
                                                                                                                                     (40.25) - did not save hours as entered.
artf1238   Facilities    Property         Property - Various    • Display only “active―   property count on the offender       8/4/10; UAT validated (493892) - email sent to Jennifer Schwatrz, artf1238                                                             Lori Wharton      8/5/10
                                                                profile screen                                                       John Clark, Lori Wharton to confirm. Received confirmation from -------------------------------------
                                                                • Ability to produce the property inventory sheet.
                Jennifer.                                                         artf1238.sql
                                                                • Ability to add an unlimited additional lines to enter property.
                                                                   SPL
                                                                • Ability to dispose of multiple property items and                8/3/10 - QA Validated, including booking sheet.                   -------------
                                                                disburse/donate, etc. at one time, instead of individually                                                                             get_prs_inv_item_m
                                                                • Modify the property outside of booking to be the same as         8/2/10 - Everything worked fine, except when additional rows      get_ofndr_counts
                                                                within booking - free-form entry. (No static property items listed)  were added in the booking property, all the data that I entered,
                                                                • Ability to enter property items and retain location based on     disappeared (the rows were added) and the new rows had a          OffenderBookingDAO.java
                                                                each property item at time entered                                   sequential number associated with them in the quantitiy.          HibernateOffenderBookingDAO.java
                                                                • Ability to display the quantity of each item on the booking      #504214                                                           OffenderBookingServiceImpl.java
                                                                sheet.                                                                                                                                 BookingReportsBean.java
                                                                                                                                                                                                       PersonalPropertyItemBean.java
                                                                                                                                                                                                       PersonalPropertyAction.java
                                                                                                                                                                                                       PersonalPropertyItemForm.java
                                                                                                                                                                                                       PersonalPropertyProcessorIfc.java
                                                                                                                                                                                                       PersonalPropertyProcessorImpl.java
                                                                                                                                                                                                       personalPropertyItemDetail.jsp
                                                                                                                                                                                                       w_dio_s2_15.jsp
                                                                                                                                                                                                       w_dio_s2_16.jsp
                                                                                                                                                                                                       w_dio_s2_17.jsp
                                                                                                                                                                                                       w_dio_s2_18.jsp
                                                                                                                                                                                                       struts-config-dio.xml
artf1333   Facilities    Transportation   Transportation -      • Classification move request should generate a Classification     8/4/10 - UAT Validated - email sent to Brann Wade and Sgt.        1333                                                                 Michael Gimm      8/5/10
                                          Various               Denial of Transfer.                                                  Kopecky to confirm                                                -------------------------
                                                                • Display only active “transport―    users on the Transport                                                                      artf1333.sql
                                                                Staff section. (Group 24)                                            8/2/10 - QA Validate
                                                                • Ability to edit Vehicle Maintenance Listing.
                    7/22/10 - Request received by Don to assign to developer for      SPL
                                                                • Ability to select multiple offenders for a run from the “add code changes as a priority item.                                    ----------------
                                                                Travel Order to Run―  screen                                                                                                         get_trns_vhcl
                                                                • Display only Institutions, CRC’s and Contract Jail options on                                                                    get_lgl_status_cnt_rpt
                                                                the Offender Legal Status Count Report                                                                                                 upd_vehicle
                                                                • Ability to e-mail scheduled run
                                                                                                   get_trns_staff
                                                                • Removal of the “approved―      furlough status that is
                                                                appearing on all moves, even if not a furlough – this field should
                                                                be applicable to furlough only.                                                                                                        ScheduleRunProcessorImpl.java
                                                                                                                                                                                                       TravelOrderAction.java
                                                                                                                                                                                                       TravelOrderProcessorIfc.java
                                                                                                                                                                                                       TravelOrderProcessorImpl.java
                                                                                                                                                                                                       TravelOrdrAction.java
                                                                                                                                                                                                       TravelOrdrProcessorImpl.java
                                                                                                                                                                                                       VehicleMaintenanceAction.java
                                                                                                                                                                                                       VehicleMaintenanceProcessorImpl.java
                                                                                                                                                                                                       VehicleMaintenanceVO.java
                                                                                                                                                                                                       TransportStaffCode.java
                                                                                                                                                                                                       TransportStaffCodeWrapper.java

                                                                                                                                                                                                       w_dio_s5_13.jsp
                                                                                                                                                                                                       w_dio_s5_15.jsp
                                                                                                                                                                                                       w_dio_s5_8.jsp
                                                                                                                                                                                                       w_otr_s5_38.jsp
artf1369   Facilities    Transportation   Transportation -      Modification to the Furlough letter to correctly display            8/4/10 - UAT Validated (439677) - Email to Brann Wade and Sgt.     TravelOrdrVO.java                                                    Brann Wade        8/5/10
                                          Furlough Letter                        or              on
                                                                “Aprroveâ€
 “Denyâ€
 the “Your Furlough isâ€
                 Kopecky to confirm.                                                TravelOrdrAction.java
                                                                                                                                                                                                       moveRequestFurlough.jasper
                                                                                                                                    8/2/10 - Added move request for 504214 - as furlough w/wo          moveRequestFurlough.jrxml
                                                                                                                                    approve/deny - letter produced fine both times                                                                                                               Page 34 of 48
                                                                                                                                       "HOT" Items
                                                                                                            1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality       Title                    Description                                                            Additional Notes                                                       Technical Notes                                                         Issue           Actual
ID          ule                                                                                                                                                                                                                                                                             Source          Completion
                                                                                                                                                                                                                                                                                                            Date
artf1422    Inmate         Quick Release     Quick Release - Release Modify the quick release to address ONLY the financial aspect of        8/4/10 - UAT validated (439677) - email sent to Amy, Devra,            [artf1422]                                                              Amy/Jessie/Devr 8/5/10
            Banking                          Removal                 the offenders checking and savings accounts, and not release the        Jessie & Sean. Received confirmation from Sean.                         - blocked the section to process the actual release of offender        a/Sgt. Moriarty
                                                                     offender.
                                                                                                                                             7/30/10 - QA validated.
artf1454    Inmate         Table             SPL: ib_gl_fclty         Need to removed the following duplicates:                              8/4/10 - UAT Validated                                                 facilty names displayed:Fixed                                           Lori Wharton    8/5/10
            Banking                                                   ARIZONA DET CTR (keep: ARIZONA DETENTION CENTER)                       8/3/10 - QA Validated
                                                                      HIGHLAND MT CC (keep: HIGLAND MTN CC)
                                                                      HUDSON CF (keep: HUDSON CC)
                                                                      MATSU PT (keep: MATSU PRETRIAL)\
                                                                      PALMER-MED CC (keep: PALMER MED CC)
                                                                      PALMER-MIN CC (keep: PLAMER MIN CC)
                                                                      WILDWOOD PT (keep: WILDWOOD PRETRIAL)
                                                                      YUKON-KUSKOKWIM (keep: YUKON-KUSKOKWIM CC)
                                                                      WW TRANSITIONAL PROGRAM (kkep: WILDWOOD TRAN P)
artf1124    P&P            Assessment/Reas Reassessment Date -        • Modify the LSIR Dates to calculate 12 months from date of          8/4/10 - Validated UAT (1317) - email sent to Rebecca to               Fixed                                                                   Rebecca Brunger 8/5/10
                           sessment        LSIR                       assessment for next reassessment due date                              confirm.
                                                                      • Display the next LSIR reassessment date on the Field PO                                                                                   SPLs : get_cpa_ofdr_tst
                                                                      Desktop                                                                8/2/10 - Validated adding an assessment (LSI) - date now reflects            get_agnt_caseload
                                                                                                                                             12 months next due date and is displayed on the desktop.

artf1356    P&P            Supervisor        Supervisor Desktop -     • Ability to access the Field PO caseload from the Supervisor        8/4/10 - UAT Validated, email sent to Rebecca and Jessica to           [artf1356]                                                              Jessica Mathews 8/5/10
                           Desktop           Change PO                                                                link
                                                                      Desktop – Addition of the “Change PO― to the                     confirm.                                                                - added the Field PO link in Supervisor Desktop
                                                                      Supervisor Desktop
                                                                                                                                             8/3/10 - QA Validated
 Artifact   Location/Mod     Functionality            Title                                        Description                                                         Additional Notes                                                        Technical Notes                                   Issue          Actual
   ID            ule                                                                                                                                                                                                                                                                            Source        Completion
                                                                                                                                                                                                                                                                                                                 Date
artf1455    Environment/S Public View        Public View - Additional Addition of the following additional links to the public view          8/11/10 - UAT Validated - email to Lori to Confirm.                    [artf1455]                                                          Lori Wharton        8/12/10
            ystems                           Info.                    screen:                                                                8/10/10 - QA Validated                                                  - added Booking, Addresses and Referred Offenses links in offender
                                                                      • Addresses
                                                                                                                                profile.
                                                                      • Referred Offenses
                                                                                                                         - fixed the STG in red issue.
                                                                      • Bookings
                                                                                                                                  - blocked the SSN from Basic Info and Search.
                                                                      Removal of the SSN from the offender search results screen and
                                                                      the basic information screen.

                                                                    Need to restrict the "new booking" from user access
artf1456    P&P            Field PO Desktop Field PO Desktop -      Request received to display the most recent "successful" Field and 8/11/10 - UAT Validated - email sent to Chris and Jessica to                 [artf1456]                                                              Jessica Mathews 8/12/10
                                            Contacts                Office vists, regardless of the type of condition on the Field PO        confirm.                                                                - fixed the Field and Office last successful date to be displayed on
                                                                    Desktop.                                                                                                                                        Field PO desktop
                                                                                                                                             8/10/10 - QA validated
artf1522    Facilities     Cell Bed          Cell Table Maintenance 1. The "Valid Flag" on the CELL is not saving when checked or            8/11/10 - UAT Validated - Email sent to Lori to confirm.                                                                                       Lori Wharton    8/12/10
                           Maintenance                              unchecked.
                                                                    2. When you click on the cell radio button or the valid check box, 8/10/10 - QA Validated
                                                                    the list of cells resets the pointer to the top of the list forcing user
                                                                    to continuously scrowl down. Not real helpful when the faciltiy has
                                                                    a rather long list of cells.
artf1429    Facilities     Payoll - Labor    Labor Hours - Payroll  Modifications of the payroll screen to be a more effective payroll       8/11/10 - UAT Validated - Email to Devra, Amy, and Kevin to            [artf1429]                                                              Amy/Devra/Jessi 8/12/10
                           Hours                                    process screen as follows:                                               Confirm.                                                                - changed the Labor Hours screen based on new rules and layout         e
                                                                    • Modify screen to include a "Units Worked" column next to
                                                                    each offender.                                                           8/10/10 - QA Validated - All issues resolved.                          [artf1429]
                                                                    • Removal of radial button.
                                                                                                                   - fixed the issues found during testing
                                                                    • Removal of “Date Entered―                                        8/9/10 - Issues:
                                                                    • Removal of “Week" and "Month"
                                     1. After posting a batch and then returing to same dates and
                                                                    • Removal of “Comments―                                            location, the offenders not previously posted hours to do not
                                                                    • Upon saving the effective date of the hours entered should be allow the "copy" feature. (Fairbanks: 183915, 490469, 512985 -
                                                                    the "work end" date as entered in the header section                     8/1/10-8/5/10)
                                                                    • Expand list of offenders down the screen to provide more             2. The Payroll Hours Report is not extracting any data now.
                                                                    offender visibility.                                                     3. If I select another location, and retrieve, location changes back
                                                                    • Default the "Work Location" to the user's work location              to default location - should allow override to another location.
                                                                    (however can be modified, if applicable)                                 4. "Last Entered" date is not displaying on the labor hours screen
                                                                    • Provide the ability to “Copy―     hours to all offender, modify after posting.
                                                                    and remove where applicable.



                                                                                                                                                                                                                                                                                                               Page 35 of 48
                                                                                                                                      "HOT" Items
                                                                                                           1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                    Description                                                             Additional Notes                                                   Technical Notes                                                    Issue             Actual
ID         ule                                                                                                                                                                                                                                                                     Source            Completion
                                                                                                                                                                                                                                                                                                     Date
artf1283   Inmate        Offender Account Offender Account           The following items are needed to be modified/enhanced on the           8/11/10 - UAT validated - email sent to Amy, Devra, Kevin for      Files:                                                             Amy Weichert      8/12/10
           Banking       Statements       Statement                  offender account statements.                                            confirmation.                                                      --------------------
                                                                     • Display a transaction reference on the statements
                                                                                     otrack/ota/imbatch/GetIBReportDatesAction.java
                                                                     • Compress data to streamline number of pages generating.
            8/9/10 - QA validated                                              /otrack/ota/imbatch/GetIBReportDatesForm.java
                                                                     • Ability to sort statements by offender name
                                                                                           otrack/ota/imbatch/GetIBReportProcessorImpl.java
                                                                     • Ability to sort offender statements by "Cell" sort option.
                                                                            IB_ReportResources.properties
                                                                     • Include location and cell of offender on the statement                                                                                 /jsp/ota/ofndrStatBalRpt.jsp

                                                                                                                                                                                                                Jasper file:
                                                                                                                                                                                                                /otrack/ota/report/ofndr_statmt_of_account.jasper
                                                                                                                                                                                                                /otrack/ota/report/ofndr_statmt_of_account.jrxml
artf1529   Booking       Booking Reason     Booking - Edit/Delete    1. If a booking reason is updated (addition of court case info, etc.)   8/11/10 - UAT Validated - email to Bill to confirm.                artf1529                                                           James Dabbs-      8/12/10
                                                                     the booking reason is duplicating.                                      8/10/10 - QA Validated                                             -----------------------                                            Ashworth
                                                                     2. If you attempt to delete - receiving errror: Error calling action                                                                       OffenderBookingDetailBean.java
                                                                     method of component with id                                                                                                                OffenderBookingListBean.java
                                                                     offenderBookingListBean:deleteReasonId Caused by:
                                                                     java.sql.SQLException - Variable (i_ofndr_num) has undefined
                                                                     value.
artf1560   P&P           Field PO Desktop Field PO Desktop -         1. Need to move hte "Field PO Desktop" report to the reporting          8/11/10 - UAT Validated - email to Bill to confirm.                SPL Modified and fine tunned.                                      William Wyatt     8/12/10
                         Report           Reporting Server           server.                                                                                                                                    get_agnt_desktop_rpt.sql
                                                                     2. Need to fine tune the query.                                         8/10/10 - QA Validated

                                                                     Note: When a location like Anchorage PROB is run, system hangs
                                                                     or ties out - need to streamline query and run from dedicated
                                                                     reporting server.
artf1574   Inmate        Auth Ded. Report Authorized Deduction       Authorized deduction report is pulling by "TYPE" instead of each       8/11/10 - UAT Validated - Email sent to Amy to Confirm.             Jasper report has modified. Now the report will display all the    Amy Weichert      8/12/10
           Banking                        Report                     individual attachment as a result if there are like types, only one is                                                                     attachments for an offender.
                                                                     pulled on the report - need to modify code to pull by attachment id 8/10/10 - QA Validated
                                                                     and not type.                                                                                                                              Jasper file:
                                                                                                                                                                                                                ------------
                                                                                                                                                                                                                auth_dedct_report.jasper
artf1354   P&P           Probation Dates    Probation Dates - Color OTIS colored near terms in yellow and at term date or past in red - 8/11/10; UAT Validated - email sent to Jessica to confirm               [artf1356]                                                            Jessica Mathews 8/12/10
                                            Coded                   need to have the same functionality in ACOMS.                          8/11/10 - QA Validated.                                               - color coded dates for Probation Expiration Date, Parole Expiration
                                                                                                                                           8/4/10 - Email sent to Lori for clarification.                       date and Reassessment Due.
                                                                    Yellow then Red on these three fields.
                                                                    1. Probation Termination Date - if( DaysAfter( Today(),
                                                                    prob_term_dt ) <= 30, 255, if( DaysAfter( Today(), prob_term_dt )
                                                                    <= 60, 65535, 0 ) )
                                                                    2. Parole Expiration Date - if( DaysAfter( Today(), parole_term_dt )
                                                                    <= 30, 255, if( DaysAfter( Today(), parole_term_dt ) <= 60, 65535, 0
                                                                    ))
                                                                    3. Reassessment Due Date - if( DaysAfter( Today(), reassess_due )
                                                                    <= 30, 255, if( DaysAfter( Today(), reassess_due ) <= 60, 65535, 0 ) )

artf1165   P&P           Offender History Offender History           1. The Supervision Level that is generating on the Offender History 8/11/10; UAT Validated.                                                artf1165                                                           Paul Scott        8/12/10
                         Report           Report                     in the P&P module report is pulling the custody level (facilities) and                                                                     -------------------------
                                                                     should be pulling hte supervision level.                               8/4/10 - QA Validated                                               HistoryReportProcessorImpl.java
                                                                                                                                                                                                                ReportAction.java
                                                                     2. Need to add the available selection of "Security Threat Group"                                                                          w_otr_s8_6.jsp
                                                                     to the options available to retrieve for an offender history report.


artf1427   Facilities    Payroll Report     Payroll Hours Report     Ability to generate the payroll hours report for all three types of     8/11/10 - UAT Validated - email sent to Devra, Amy and Kevin to                                                                       Jessie Miller     8/12/10
                                                                     generation: Not Entered, Entered, Both.                                 confirm.

                                                                                                                                             8/10/10 - Fixed with #1429
artf1319   Facilities    Location History   Offender Intake History When you run this offender’s Intake History (in facilities), it        8/11/10 - UAT validated - email sent to Sgt. Moriarity to          artf1319.sql                                                       SGT. Moriarty     8/12/10
                                            (Location)              does not include all dates of service reflected in his location history. confirm.
                                                                    The Intake Report must include all service dates. Not sure if this is a 8/9/10 -QA Validated (525544, 525505)
                                                                    random error or not, but my staff tell me they see this frequently.

artf1460   Facilities    Custody Level      Custody Level - Date     Need to remove the column of "Date Classified" on the Custody           8/11/10 - UAT Validated - Email sent to Sgt. Moriarity and Steve   w_dio_s9_3.jsp                                                     Steven Brunger    8/12/10
                                            Classified               Level Listing screen.                                                   Brunger to confirm.

                                                                                                                                             8/9/10 - QA Validated                                                                                                                                       Page 36 of 48
                                                                                                                                      "HOT" Items
                                                                                                           1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality       Title                    Description                                                         Additional Notes                                                    Technical Notes                                                     Issue            Actual
ID          ule                                                                                                                                                                                                                                                                   Source           Completion
                                                                                                                                                                                                                                                                                                   Date
artf1377    P&P            FaceSheet         Facesheet - Single vs.   When you attempt to print just one facesheet from the agents        8/11/10 - UAT validated - email sent to Chris to confirm.           artf1377                                                            Chris McKenzie   8/12/10
                                             Multiple                 caseload, all are generating - should only generate the offenders                                                                       ------------------------
                                                                      that are selected.                                                  8/4/10 - QA Validated                                               FieldContactListAction.java
                                                                                                                                                                                                              w_otr_s8_1.jsp
 Artifact   Location/Mod     Functionality            Title                                       Description                                                     Additional Notes                                                      Technical Notes                                  Issue         Actual
   ID            ule                                                                                                                                                                                                                                                                    Source       Completion
                                                                                                                                                                                                                                                                                                        Date
artf1528    Booking        Booking Sheet     Booking Sheet            Booking Sheet is printing the location of the user in the header    8/17/10 - UAT Validated - email sent to Lori Wharton to confirm.                                                                        Joe Butler       8/23/10
                                                                      instead of the location of where the offender was booked.           8/17/10 - QA Validated (525515)

artf1453    Environment/S Environment       UAT Environment -         Change the config mgr. for the UAT environment to another color     8/17/10 - UAT Validated - NOTE: This will NOT move to                                                                                   Don Brand        8/23/10
            ystems        Color Segregation Color Change              – green and include a disclaimer.                                 production.

                                                                                                                                          8/17/10 - Initial screen and header changed, includes
                                                                                                                                          environment name. QA Validated.
artf1579    Environment/S Public View        Non-DOC Report -         Need to add an initial search"Date Range" criteria screen prior to  8/17/10 - UAT Validated - email sent to Lori Wharton to confirm     Cyndi : Added Date criteria for below reports,                      Lori Wharton     8/23/10
            ystems                           Search Criteria          initiating the following reports located under the Public View      8/17/10 - QA Validated                                              • SSA Prisoner Events

                                                                      screen.                                                                                                                                 • Elections Felony Admits

                                                                      • SSA Prisoner Events
                                                                                                                • CSED Offenders Due Out 

                                                                      • Elections Felony Admits
                                                                                                            • Offenders Over 65

                                                                      • CSED Offenders Due Out 
                                                                                                            Except other 3 reports didn't have any Date range .
                                                                      • Offenders Over 65
artf1587    Environment/S Public View        Public View - Additional 1. Add a column on the bookings screen between “Arrest             8/17/10 - UAT Validated (525515) - email sent to Lori Wharton to   [artf1587]                                                            Lori Wharton   8/23/10
            ystems                           Info                               and                      and
                                                                      Dateâ€
 “Court Caseâ€
 display the officer number and confirm.                                                                         - added the Officer Details Column between “Arrest Date―     and
                                                                      name. ie.: “###-<<NAME>>―       .                                                                                                   “Court Case―  .
                                                                                                                                           8/16/10 - QA Validated (525515, CISUSER3)                           - added the Family / Associated link in offender profile from Public
                                                                      2. Need to provide a link to family/associates on the offender                                                                          View. Can only see Emergency Contacts in the list.
                                                                      profile, however ONLY display the "EMERGENCY CONTACT"
                                                                      person(s) information - all other family and associates would not be
                                                                      visible. Info needed: Name, Relationship, Address, City, State, Zip,
                                                                      Phone.
artf1145    Facilities     Counts            Counts by Institution, Counts By Institution Report layout change request - change from 8/17/10 - UAT Validated - email to Michael Gimm to confirm.                                                                                  Michael Gimm     8/23/10
                                             Sex, Legal Status        landscape to portrait to conserve paper.                             8/16/10 - QA Validated - ran all facilities and single facility.
                                             Report -
                                             Format/Layout
                                             Changes
artf1241    Facilities     Counts            Counts - Delay Timer     Remove the 360 second checked box when freezing the counts           8/17/10 - UAT Validated - email sent to Jennifer SChwarz to        artf1241                                                            Jennifer         8/23/10
                                                                                                                                           confirm.                                                           ------------------------                                            Schwartz
                                                                                                                                           8/16/10 - QA Validated                                             CountRollUpAction.java
                                                                                                                                                                                                              CountRollUpProcessorImpl.java
                                                                                                                                                                                                              w_dio_s3_20_error.jsp
artf1252    Facilities     Counts            Counts - WWCC            Here is the information that you requested for our counts here at   8/17/10 - UAT Validated - email sent to Jennifer Schwartz to        artf1252.sql                                                        Jennifer         8/23/10
                                                                      the Wildwood Correctional Complex. The complex consists of 3        confirm.                                                            OnPropertyCountAction.java                                          Schwartz
                                                                      separate facilities.                                                8/12/10 - QA Validated                                              OnPropertyCountProcessorImpl.java
                                                                      1.)Wildwood CC
                                                                      2.)Wildwood Pretrial                                                8/10/10 - Receiving error: Error encountered...
                                                                      3.)Wildwood Transitional Program                                     Update Stopped. The count closed at 08/10/2010 at 09:30 -
                                                                      These need to be separated so we can run our counts at each         appears that the WWCC's are still linked even though they are
                                                                      facility independent of one another.                                suppose to be separate entities.

                                                                      As for the rest of the locations see below: DO NOT CHANGE UNTIL 8/9/10 - Able to process, however no change from prior count
                                                                      YOU HEAR BACK FROM CYNDI.                                       processing.
                                                                      1.)Kenai EM (all 4 of them can be removed).
                                                                      2.)Wildwood CC Intake(s) and Wildwood PT Intake(s) (see
                                                                      below).

                                                                      I have a question about the Wildwood CC Intake(s) and Wildwood
                                                                      PT Intake(s) these are counted under Wildwood CC and Wildwood
                                                                      Pretrial respectively. Can these be deleted as I see that no
                                                                      prisoners are currently assigned to them now?




                                                                                                                                                                                                                                                                                                      Page 37 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                   Description                                                            Additional Notes                                                 Technical Notes                                           Issue            Actual
ID         ule                                                                                                                                                                                                                                                       Source           Completion
                                                                                                                                                                                                                                                                                      Date
artf1190   Facilities    Divison Roll-up   Divison Roll-up         1. Remove Unit - Not applicable                                        8/17/10 - UAT Validated - Email to Michael Gimm to confirm.  artf1190                                                      Ofc. Simpson &   8/23/10
                                                                   2. Facility should be correctly selected - currently rolling over to                                                                ---------------------                                         M. Gimm
                                                                   "...Intake"                                                      8/16/10 - QA Validated - Various institutions (WCC, KCC, LCC, etc) SPL
                                                                   3. Remove count next to the description - not needed.                                                                               -------------
                                                                                                                                                                                                       get_unit_rollup
                                                                                                                                                                                                       DivisionRollupAction.java
                                                                                                                                                                                                       DivisionRollupProcessorImpl.java
                                                                                                                                                                                                       w_dio_rollup.jsp
artf1227   Facilities    Offender Intake   Offender Intake History • The ATN number is only reflecting 6 of the 9 characters when 8/17/10 - UAT validated - email sent to Lori Fritz to confirm.     I have aligned Data Year properly. Now its look good.         Lori Fritz       8/23/10
                         History Rpt       Report                  printing the offender intake history report.                     8/17/10: QA Validated
                                                                   • Need to include the Discharge Reason for each entry when you 8/17/10: Time is cutting off on release date/time
                                                                   print the report.                                                8/16/10 -
                                                                                                                                    1. Release Year is cutting off
                                                                                                                                    2. Column header for "time" is not displaying.

artf1605   Inmate        Offender          Offender Account        Need the ability to enter an offender number and NOT a facility        8/17/10 - UAT Validated - email to AMy to confirm.               Offender Nos alone user allow to enter.                   Devra Hayes      8/23/10
           Banking       Statements        Statements              that would pull the offender statement, even if the offender was       8/17/10 - QA Validated
                                                                   no longer incarcerated. (released/discharged/probation, etc.)

artf1382   P&P           Court Case/Case Court Case/Case Status Need a Business Rule for Offenders that were never Booked into a 8/17/10 - UAT Validated (525504) - Email sent to Lori who is                                                                        Rebecca Brunger 8/23/10
                         Status                                 Facility and come from the court system                          pending review by Rebecca Brunger to confirm.

                                                                   Legal Status Description: PSI Pending                                  8/16/10 (Lori): The table changes have been made in Trng.
                                                                   Legal Status Change: New Referral                                      I’ve contacted Rebecca Brunger to validate. She will be back
                                                                                                                                          to work on Thursday and will validate then.
                                                                   Example: During the initial talking to PD, offender was interviewed
                                                                   then released. Case moved up the chain and the DA is now
                                                                   charging the Offender. Offender 542405 is charged with Theft 2.
                                                                   Case has been given to Pre-Sentence Investigation unit for their
                                                                   collection of information. Offender has not been sentenced yet.

                                                                   PSI Writer adds offender to ACOMS, Legal Status should read: PSI
                                                                   Pending. In order to get PSI Pending, you have to add Legal Status:
                                                                   Probation, and then add Legal Status: PSI Pending. Offender was
                                                                   never on Probation and with Probation listed first, confuses users
                                                                   in the office.

                                                                (Rebecca): Two possible scenarios. One would be for the pending
                                                                PSI – new referral and the other for probation – probation
                                                                start. We have folks that will have a PSR ordered that have never
                                                                been booked, but we will also have folks placed on probation that
                                                                have never been booked. The ACOMS data entry person will need
                                                                to be able to select either instances, dependent on the case they
artf1289   P&P           Felony Report     NON-DOC User Reports have been assigned.
                                                                Need to create the following reports that will be placed on the   8/12/10 - These will NOT move to PROD until the date range and All the 7 reports completed and placed all the reports in public view James Dabbs-   8/23/10
                                                                "REPORTS" tab in the new "Public View" module - these should be permissions is applied to prevent users from viewing data that is tab.                                                                 Ashworth
                                                                created in an excel file format - PDF is not needed.              restricted from them.
                                                                                                                                                                                                   1.SSA Prisoner Events - SPL: ak_ssa_rpt & ak_ssa_cleanup
                                                                1. SSA Prisoner Events - SPL: ak_ssa_rpt & ak_ssa_cleanup         8/11/10 - UAT Validated - Email sent to Lori to confirm.         2. Elections Felony Admits - SPL: ak_elect_race
                                                                2. Elections Felony Admits - SPL: ak_elect_race                                                                                    3. CSED All Offenders - SPL: ak_csed
                                                                3. CSED All Offenders - SPL: ak_csed                              8/9/10 - Reports validated                                       4. CSED Offenders Due Out - SPL: ak_csed_due 5. Labor All
                                                                3. CSED Offenders Due Out - SPL: ak_csed_due (Has to be                                                                            Offenders - SPL: ak_unempl() & ak_unempl_weekly()
                                                                reworked to accommodate new table structure. Used otis            6/21/10: (Lori) - I’ve already reworked most of these non-doc 6. Offenders Over 65 - SPL: ak_old_guys
                                                                inst_intake table.)                                               reports. They now need to be put in a place (a new tab?) that is 7. Epidemiology Roster
                                                                4. Labor All Offenders - SPL: ak_unempl() & ak_unempl_weekly() accessable and presentable to these folks in acoms. The attached
                                                                5. Offenders Over 65 - SPL: ak_old_guys                           list show the stored procedures that are finished (g2g).
                                                                6. Epidemiology Roster - SPL: ak_epidem



artf1578   P&P           Field PO          Field PO Assignment -   Need to remove the start date constraint to allow future dating.       8/17/10 = UAT Validated - email sent to Jennifer to confirm.                                                               Jessica Mathews 8/23/10
                         Assignment        Future Date                                                                                    8/16/10 - QA Validated (525515)




                                                                                                                                                                                                                                                                                         Page 38 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality      Title                   Description                                                         Additional Notes                                                      Technical Notes                                                    Issue           Actual
ID          ule                                                                                                                                                                                                                                                                  Source          Completion
                                                                                                                                                                                                                                                                                                 Date
artf1270    P&P           Travel Permit     Travel Permit - Font    1. Enlarge the destination address field on the travel permit       8/17/10 - UAT Validated - email sent to Jason Brown to confirm.       [artf1270]                                                           Jason Brown   8/23/10
                                            Sizes                   2. Enlarge the comment field on the (PHONES) telephone number                                                                              - increased field length for Destination address to 85 chars.
                                                                    3. Enlarge the direction and coordinate (ADDRESSES) field on an     8/17/10: QA Validated.                                                 - increased field length for Offender Phone Comment to 85 chars.
                                                                    address entry                                                       8/16/10: Fixed the report.                                             - increased field length for Address Direction to 100 chars
                                                                    4. Terminate the prior address if a new address is being entered    8/16/10 - Destination Address is running over the city - need to       - automated the Mailing address flag to switch incase new record is
                                                                    and prevent the error from appearing.                               adjust print.                                                         flagged.
                                                                                                                                        8/16/10: Was getting disk space error in QA while increasing the       - also put the end date for historical physical address (extra)
                                                                                                                                        column space. Fixed the issue with size. Please retest.
                                                                                                                                        8/16/10 - Travel Permit - Destination Address only saved 30
                                                                                                                                        character even though over 70 were entered. All other issues -
                                                                                                                                        no problem


 Artifact     Location/     Functionality            Title                                     Description                                                      Additional Notes                                                        Technical Notes                                Issue         Actual
   ID          Module                                                                                                                                                                                                                                                                 Source       Completion
                                                                                                                                                                                                                                                                                                      Date
artf1645    Booking       Daiy Count Sheet Daily Count Sheet        The Daily Count Sheet report in Booking is showing incorrect        9/1/10 - Ran report for 9/1/10 - Lemon Creek - totals match           HibernateOffenderBookingDAO.java                                   Sgt. Moriarty   9/2/10
                                                                    information, such as releases from other locations.                 expectations - email sent to Sgt. Moriarty and MIchael to
                                                                                                                                        confirm.

                                                                                                                                        9/1/10 - Ran report for 9/1/10 - Fairbanks - total of offenders now
                                                                                                                                        matches the facility roster report and the totals for bookings and
                                                                                                                                        releases is correct.

                                                                                                                                        8/31/10 - Ran report for 8/31/10 - Fairbanks - total of offenders
                                                                                                                                        not correct - reflects 13,200 when in fact there are only 310 - QA
                                                                                                                                        Environment.
artf1662    Environment/S MODJK             MODJK - Issues          1. Unable to validate the booking records in the MODJK              8/31/10 - Move to PROD on 8/31/10 per Don if does not disrupt there was an extra / in the proxy.conf file on the .84 server.              Don Brand      9/2/10
            ystems                                                  environments.                                                       prod - move at 6 tonight. Requests AKDOC to validate and           Removed the extra / and all is well with jsf and mod_jk......hopefully
                                                                                                                                        include photos.                                                    :)

                                                                                                                                        8/31/10 - Validated in both modjk and citrix - able to validate
                                                                                                                                        booking.
artf1691    Environment/S Public View       Public View -Property   1. Need to remove the property link on the public view screen.      9/2/10 - UAT Validated - email sent to Michael Gimm to confirm.       [artf1691]                                                         Don Brand       9/2/10
            ystems                          & Account Balance       2. Need to remvoe the "account balance" that appears on the                                                                                - removed the Property link from Offender Profile
                                                                    header when you access a link from the offender profile.            8/31/10 - QA Validated - property removed and                          - blocked the Account Balance from Public View
                                                                                                                                        verified all links no longer reflect the account balance when
                                                                                                                                        accessed. (525504)

artf1277    Environment/S Security          Photos - Images -       Image should not only show to people have rights - need to hide or 9/1/10 - UAT Validated - CISUSER3 - email ti Michael to confirm.       changed image.jsp                                                  Don Brand       9/2/10
            ystems                          Security Rights         show images based on rights to a new security object
                                                                                                                                       8/26/10 - QA Validated - cisuser2 (w/wo) - 525515
                                                                                                                                                                                                              Also is based on the OFNDRPHOTO security object (users needs to
                                                                                                                                        8/17/10 - Modified user: CISUSER2 to have OFNDERPHOTO                 have or not have rights to this object)
                                                                                                                                        access, however photos are not appearing. (525515, 525544)




                                                                                                                                                                                                                                                                                                    Page 39 of 48
                                                                                                                                 "HOT" Items
                                                                                                      1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                  Description                                                          Additional Notes                                                    Technical Notes                                                   Issue            Actual
ID         ule                                                                                                                                                                                                                                                              Source           Completion
                                                                                                                                                                                                                                                                                             Date
artf1265   Facilities    C-Notes & Case   C-Notes, Case Updates Request received to provide the links of "Case Updates" and "C-       9/1/10 - UAT Validated - email to Rachael, Mary and Michael to      artf_1265                                                         Mary Sandy       9/2/10
                         Updates                                Notes" on facilties, BOPP and P&P modules.                            confirm.                                                            ---------------------
                                                                                                                                                                                                          SPL
                                                                                                                                      8/31/10 - QA Validated for BOPP, Facilities & P&P - all have new    ----------
                                                                                                                                      links/functions.                                                    get_bop_counts
                                                                                                                                                                                                          OffenderInformationCountsVO.java
                                                                                                                                      8/30/10 - Error received when attempting to access BOPP -           OffenderInformationProcessorImpl.java
                                                                                                                                      offender profile:                                                   OffenderProfile.jsp
                                                                                                                                      SEVERE] 10/08/30 09:58:01                                           w_bop_s1.jsp
                                                                                                                                      OffenderInformationProcessorImpl.loadBopCountsInformation:
                                                                                                                                      SQLException: java.sql.SQLException: Row/column index out of
                                                                                                                                      range
                                                                                                                                      [SEVERE] 10/08/30 09:58:01
                                                                                                                                      OffenderInformationProcessorImpl.loadBopCountsInformation:
                                                                                                                                      SQLException: java.sql.SQLException: Row/column index out of
                                                                                                                                      range error Code -79703
                                                                                                                                      [SEVERE] 10/08/30 09:58:01 OffenderInformationAction.show:
                                                                                                                                      Exception:
                                                                                                                                      class=otrack.bopp.offender.OffenderInformationProcessorImpl,
                                                                                                                                      method=loadBopCountsInformation,message=Row/column index
                                                                                                                                      out of range,date=Mon Aug 30 09:58:01 MDT 2010errorCode=-
                                                                                                                                      79703



artf1697   Facilities    Custody Level    Custody Level - End    Need to run a query against production for all offenders that are no 9/1/10 - UAT Validated - Email sent to Michael to confirm.          [artf1697]                                                        Lori Wharton     9/2/10
                                          Dates                  longer incarcerated and still have a "custody level" (NOT                                                                                 - updated the custody levels in QA.
                                                                 SUPERVISION LEVEL) - so that they can be updated to end date hte 8/31/10 - QA Validated - Ran script in QA environemtn - verified
                                                                 custody level.                                                       that only offenders that are not currently incarcerated reflected
                                                                                                                                      an end date = to release date on the custody level.


artf1693   Facilities    Offender Release Offender Release -     Need to allow the option of: RELEASE COURTESY HOLD (TTL 47)          9/1/10 - UAT Validated - email to Sgt. Moriarty to confirm.         Need to run below scripts for Release Custody 47 -Legal status.   Sgt. Moriarty    9/2/10
                                          Legal Status           when a relase of discharge or dismissed is used on the offender
                                                                 release.                                                             9/1/10 - QA Validated (525504)                                      Update lgl_stat_cd set vld_flg='Y' Where lgl_stat_cd='1'
                                                                                                                                                                                                          INSERT INTO lgl_stat_chg_rule VALUES ('1','1',1025,NULL);
                                                                                                                                                                                                          --COSTODTY TTL-47 To DISCHARGE
                                                                                                                                                                                                          INSERT INTO lgl_stat_chg_rule VALUES('1','K',1025,NULL);


artf1198   Facilities    PSI              PSI Clone              PSI clone function is not working - needs to be functioning. (Mantis 9/1/10 - UAT Validated (1269_ - email to Rebecca and Michael to                                                                       ANCH. Training   9/2/10
                                                                 2181)                                                                confirm.

                                                                                                                                      8/31/10 - QA Validated - added PSI, finalized, cloned, edited,
                                                                                                                                      finalized - both printed PSI and did not allow editing after
                                                                                                                                      finalization, however did allow cloning again.




                                                                                                                                                                                                                                                                                                Page 40 of 48
                                                                                                                                     "HOT" Items
                                                                                                          1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality       Title                   Description                                                           Additional Notes                                                     Technical Notes                                                    Issue            Actual
ID          ule                                                                                                                                                                                                                                                                    Source           Completion
                                                                                                                                                                                                                                                                                                    Date
artf1648    Facilities     STG               Security Threat Group   There are a couple of problems in the stored procedure                9/1/10 - UAT Validated - all sort options. Email sent to Michael,    SPL Issue is resolved.                                             Lori Wharton &   9/2/10
                                                                     get_scrty_threat_grp_rpt.                                             William and Don to confirm.                                          SPL Name : get_scrty_threat_grp_rpt()                              William Wyatt
                                                                                                                                                                                                                08/30:
                                                                     1. The first one is easy – It is sending the wrong stored           8/31/10 - QA Validated - Validated all sort options and mutiple      Sort Option now working fine.
                                                                     procedure name to the error log.                                      STG's for a single offender.
                                                                              ON EXCEPTION SET g_sqlcode, g_isamcode, g_errval                                                                                  Modified Files:
                                                                              CALL rollback_work() RETURNING pstatus;                                                                                           ===========
                                                                              CALL i_errlog("get_body_loc_desc");                                                                                               src/otrack/ftrack/offender/safety/OffenderGangListingAction.java
                                                                                                                                                                                                                FCLTY_ReportResources.properties
                                                                     2. The following queries (two occurrences) do not take into                                                                                get_scrty_threat_grp_rpt()
                                                                     consideration the possibility of multiple records meeting the
                                                                     criteria, resulting in -284 errors.
                                                                                -- Get Dates
                                                                                SELECT adj_rel_date INTO
                                                                                o_full_term_rlse_dt
                                                                                FROM stat_good_time_info
                                                                                WHERE ofndr_num = o_ofndr_num
                                                                                AND hist_dt IS NULL;

                                                                             SELECT parole_elg_dt INTO o_tent_parole_dt
                                                                             FROM stat_good_time_info
                                                                             WHERE ofndr_num = o_ofndr_num
                                                                             AND hist_dt IS NULL;

artf1698    OMP            Assessment Test Assessment Test - SPL     Determined that the SPL is returning an error when attempting to      9/1/10 - UAT Validated - email to Michael Gimm to confirm.           SPL error is resolved.                                             Lori Wharton     9/2/10
                                           Error                     save an assessment test.
                                                                                                                                           8/31/10 - QA Validated (525504) - able to add assessments test       Files:--
                                                                                                                                           with no errors.                                                      src/otrack/omp/offenderassessment/OffenderAssessmentProcessor
                                                                                                                                                                                                                Impl.java
                                                                                                                                                                                                                get_cpa_ofdr_tst_m()
artf1288    P&P            C-Notes &         C-Notes, Supervision    1. The issue was with the “CAPS―       being entered as the     9/1/10: UAT Validated - email sent to Mary, Rachael, MIchael,          SPL                                                           ELesceeya             9/2/10
                           Supervision       Contacts, Case                                    –
                                                                     “primary contactâ€
 it appears that instead of clicking on the Elesceeya to confirm.                                                     ----------------------                                        Pinkerton
                           Contacts          Updates                 single head or double head to search for the “user id― userthe                                                                         get_cnote_m
                                                                     typed his user ID in CAPS, as a result the system didn’t          8/31/10: QA Validated.                                                 get_cnote
                                                                     recognize the user id, as all user id are in lowercase. Need to put
                                                                     in edit that prevents the user id from being saved as CAPS. )P&P - 8/30/10:                                                                CaseUpdateAction.java
                                                                     Supervision Contact)                                                1. C-Notes - While the description field allows for large quantities   w_otr_s3_3_2.jsp
                                                                                                                                         of data, only saves 479 characters.                                    w_otr_s2_3.jsp
                                                                     2. Decription Field Size too small - Need to increase box size -    2. Case Updates - When attempting to delete - receiving error:         w_otr_s6_18.jsp
                                                                     current character limit is set at 10,000. C-Notes                   [SEVERE] 10/08/30 10:07:26 CaseUpdateAction.delete:
                                                                                                                                         Exception:
                                                                     3. Anchorage Probation is requesting an error to prompt you when class=null,method=null,message=error.invalid.caseUpdate.dateLi
                                                                     entering a future date for Supervision Contacts and Case Updates. mit,date=nullerrorCode=0

                                                                     4. Case Updates should only allow editing of a note within 24
                                                                     hours of original entry bythe same user - and then no further edits
                                                                     should be allowed.



artf1699    P&P            Field PO Desktop Field PO Desktop -       THe Parole Expiration and Probation Expiration Dates are not          9/1/10 - UAT Validated - email to Jessica, Michael to confirm.       Parole & Probation Dates Issue resolved.                           Don Brand &     9/2/10
                                            Dates                    correct on the Field PP Desktop - appears to be mapped                                                                                                                                                        Jessice Mathews
                                                                     incorrectly.                                                          8/31/10 - Validated offenders dates on field po desktop agains       SPL Modified:
                                                                                                                                           headers - all appear fine. QA Validated                              -----------------
                                                                                                                                                                                                                get_agnt_caseload()


 Artifact      Location/     Functionality            Title                                      Description                                                       Additional Notes                                                      Technical Notes                                Issue           Actual
   ID           Module                                                                                                                                                                                                                                                                 Source         Completion
                                                                                                                                                                                                                                                                                                         Date
artf1660    Environment/S Public View        Public View - Photos    Need to revise the public view screen to display photos by            9/8/10 - Code moved to UAT and validated - email to Lori and         [artf1660]                                                         Don Brand        9/9/2010
            ystems                                                   permissions.                                                          Don to review.                                                        - unblocked the image.jsp loop
                                                                                                                                           9/7/10 - Code does not appear to have been moved to UAT.              - will work the same way as photos at other places under same
                                                                                                                                           9/6/10 - QA Validated.                                               security role.

                                                                                                                                                                                                                                                                                                       Page 41 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality    Title                    Description                                                            Additional Notes                                                    Technical Notes                                                  Issue          Actual
ID         ule                                                                                                                                                                                                                                                                Source         Completion
                                                                                                                                                                                                                                                                                             Date
artf1246   Facilities    Central         Central Monitoring Link Central monitoring link requested to be added to the offender           9/7/10 = UAT Validate, email to Bran Wade to validate.              [artf1246]                                                       Brann Wade     9/9/2010
                         Monitoring      - Offender Profile      profile screen (original central monitoring link would remain, for      9/7/10 - QA Validated                                                - files were not checked in. Please retest.
                                                                 use by transportation/classification only) that would provide           9/6/10 - Added CM to offender 490959, with offenders 525515
                                                                 limited access to user to see the offender and location of the          and 525505 as conflict individuals, however only displaying under   [artf1246]
                                                                 separate. Screen would include the following:                           490959 525515 and 525505 have the link highlighted, however          - updated the flow to find offenders from victim level also.
                                                                                                                                         when you access nothing appears. In addition, 490959 is not
                                                                  • Primary Offender Name
                                             displaying both conflict offender no.                               [artf1246]
                                                                  • Primary Offender Number
                                                                                                                - made a new link on offender profile as 'Central Monitoring'
                                                                  • Primary Offender Location (should this include bed assignment      8/23/10 - Issues:                                                   showing the conflicts of offender with other offenders.
                                                                  as well or only location?)                                             1. Not reflecting on all offenders added (primary or conflict) on
                                                                  • Conflict Person’s Name
                                          offender profile screen (525502, 525504, 478289)
                                                                  • Conflict Offender Number
                                          2. Not displaying all offender numbers (conflict)
                                                                  • Conflict Person’s Location (should this include bed
                                                                  assignment as well or only location?)                                  8/12/10 - Email sent to Brann Wade with screen images to
                                                                                                                                         confirm changes.
                                                                  1. Screen would be a “view―    only that would provide limited
                                                                  information. Would display information whether offender that is
                                                                  being viewed is the primary or conflict person.
                                                                                                if
                                                                  2. Link would be “RED― offender has a central monitoring on
                                                                  his/her file.
                                                                  3. Restriction of the Central Monitoring screen (outside of offender
                                                                  profile) (Source File: w_dio_s4_4.jsp) screen to ONLY
                                                                  transportation employees.



artf1654   Facilities    ID Card         ID & Commitment Card The second page (ID Card) that generates when printing the       9/7/10 - UAT validated (12) - email sent to Bill Wyatt                        Offender Information missing in Top 2 Photos issue fixed.        Bill Wyatt     9/9/2010
                                                              commitment card and ID cards is missing the offender informaiton 9/7/10: QA Validated
                                                              on the two ID cards (at top). No issues when printing just an id 9/6/10: Cards 2,3,4 are cutting off the DOB year.                             9/6/10: Cards 2,3,4 are cutting off the DOB year Issue fixed.
                                                              card, only when printing with commitment card.
                                                                                                                                                                                                             Files Commited:
                                                                                                                                                                                                             ---------------------
                                                                                                                                                                                                             \otrack\ftrack\offender\summary\CommitmentCard_subreport1.jas
                                                                                                                                                                                                             per
                                                                                                                                                                                                             \otrack\ftrack\offender\summary\CommitmentCard.jasper
                                                                                                                                                                                                             otrack\ftrack\offender\summary\IDCard.jasper

artf1713   Inmate        Attachment      Attachment - Max         The "Max Monthly AMount" is not being considered in teh                9/9/10 - UAT Validated.                                             [artf1713]                                                       Amy Weichert   9/9/2010
           Banking                       Monthly Amount           retention of a payment for an attachment.                              9/8/10 - QA Validated - 80586                                        - if max monthly amount is specified, then do not take into
                                                                                                                                                                                                             consideration the percent
artf1651   Inmate        Child Support   Child Support Report     Need to create a report in Inmate Banking that will generate an        9/7/10: Reminder sent to Kevin and Devra                            Child Support Report created under Inmate Bank->Report -->tab    Joe Butler     9/9/2010
           Banking       Report                                   excel file with the following information:                             9/1/10 - Per Kevin and Devra - need to delay deployment until
                                                                  Report Name: CSSD Report                                               next week as they are unable to validate the UAT environment
                                                                                                                                         this week.                                                          Files commited:
                                                                  Specifications:                                                                                                                            ---------------------
                                                                  1) All transactions with transaction codes 8, 181, 136, 235 -- child   9/1/10 - UAT Validated - email to Devra and Kevin to confirm.       childSupportRpt.jsp
                                                                  support requirements                                                                                                                       menu.ibr.jsp
                                                                  2) All offenders                                                       8/31/10 - QA Validated                                              struts-config-ota.xml
                                                                  3) Date range: from ACOMS conversion date to present                                                                                       child_support_report.jrxml - Reporting Server

                                                               Output format:
                                                               1) one line per offender showing total for each
                                                               offender/transaction code
                                                               2) offender number, transaction code, total amount collected for
                                                               each transaction
                                                               3) subtotal for each trans action code
                                                               4) grand total for all transaction codes
                                                               5) output to excel
artf1712   Inmate        Offender        Offender Statements - When offender statements are generated the transaction dates are 9/7/10 - UAT validated, email to Devra and AMy for validation.               09/07 : Statements are ordered by Transaction dates.             Kevin Worley   9/9/2010
           Banking       Statements      Sort                  not in date order                                                9/7/10 - QA Validated.
                                                                                                                                                                                                             SPL : get_ofndr_stat_acct_new ()




                                                                                                                                                                                                                                                                                                Page 42 of 48
                                                                                                                                    "HOT" Items
                                                                                                         1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact    Location/Mod Functionality      Title                   Description                                                         Additional Notes                                                      Technical Notes                                                      Issue           Actual
ID          ule                                                                                                                                                                                                                                                                    Source          Completion
                                                                                                                                                                                                                                                                                                   Date
artf1452    P&P           Pending Release   Pending Release        Issue: When an offender is added to the scheduled release list as a 9/7/10 - UAT Validated - email to Lori to validate.                                                                                         Lori Wharton    9/9/2010
                          Assignment        Assignment -           "PROBATION" option (from the Schedule Release screen), the          9/6/10 - Added 3 offenders to release, prob, parole, d/c -
                                            Scheduled Release List offender is not reflecting on the "PENDING RELEASE ASSIGNMENT" (514061, 490017, 490959).
                                                                   on the Supervisor Desktop.

                                                                                        was selected, they are appearing.
                                                                    Note: If “Parole―

 Artifact     Location/     Functionality            Title                                      Description                                                      Additional Notes                                                          Technical Notes                              Issue          Actual
   ID          Module                                                                                                                                                                                                                                                                  Source        Completion
                                                                                                                                                                                                                                                                                                        Date
artf1656    Environment/S Config Mgr        Config Mgr - JSP -      Modify existing report pointers from the JSP to config manager to   9/14/10 - UAT validated - ran various reports both reporting          [artf1656]                                                           Patrick/Amit    9/16/10
            ystems                          Reports                 prevent incorrect pointers during build.                            server and non-reporting server - all reports generated.               - changed the respective ConfigManager.properties files in QA and
                                                                                                                                        9/14/10 - validation can only be done at time of build                UAT to point to dynamic Reporting URL.


                                                                                                                                                                                                              Config.Manager - Properties file to pickup reporting server URL
                                                                                                                                                                                                              using key (report.server.url).

                                                                                                                                                                                                              So removed server URL from all the jsps.

                                                                                                                                                                                                              Modified following reports
                                                                                                                                                                                                              ------------------------------

                                                                                                                                                                                                              1.Facility Roster Report
                                                                                                                                                                                                              2.Prison Visit Report
                                                                                                                                                                                                              3.Visitor pattern Report
                                                                                                                                                                                                              4.Child Support Report

                                                                                                                                                                                                              Non User Reports

                                                                                                                                                                                                              5.SSA Prisoner Report
                                                                                                                                                                                                              6.CSED Offender Due Report
                                                                                                                                                                                                              7.CSED All Offenders Report
                                                                                                                                                                                                              8.Epidemiology Roster Report
                                                                                                                                                                                                              9.Elections Felony Admits Report
                                                                                                                                                                                                              10.Labor All Offenders Report
                                                                                                                                                                                                              11.Offender Over 65 Report.
artf1665    Environment/S Tables            Assign Reason Code      The “assgn_rsn_cd―   table had 84 rows in OTIS on May 17,       9/15/10 - Received email from Lori - desire is to remove the                                                                               David Grove &   9/16/10
            ystems                                                  2010 - ACOMS has 156 rows, many are redundant. Need to              assign reasons that have never been used completely from the                                                                               Don Brand
                                                                    identify what was in OTIS and what is in ACOMS andd evaluate and    table rather than just flag as inactive and not display - developer
                                                                    update to meet AKDOC needs.                                         is pulling report to identify all inactive assign reasons that have
                                                                                                                                        NOT been used and then the table will have these removed.
                                                                                                                                        Identifed that there are only 28 that have never been used -
                                                                                                                                        others have been used and cannot be removed.
                                                                                                                                        9/14/10 - UAT validated - email to Lori to confirm.
                                                                                                                                        9/14/10 - QA Validation
                                                                                                                                        9/13/10 - Follow-up email to Lori, however will assign to
                                                                                                                                        developer to ensure that the flag is correctly working.
                                                                                                                                        9/7/10 - Email sent to Lori to confirm active reasons.




                                                                                                                                                                                                                                                                                                      Page 43 of 48
                                                                                                                                       "HOT" Items
                                                                                                            1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality       Title                    Description                                                                Additional Notes                                                     Technical Notes                                                      Issue            Actual
ID         ule                                                                                                                                                                                                                                                                            Source           Completion
                                                                                                                                                                                                                                                                                                           Date
artf1758   Facilities    Custody Level      Custody Level -          Need to update the historical custody levels with an end date prior 9/16/10 - Received confirmation from Steven Brunger - OK                    I ran the SQL to update the old custody level dates in UAT.          Steven Brunger   9/16/10
                                            Historical               to the next custody level to prevent the custody level from         9/15/10 - UAT Validated - 183228 - email to Steven Brunger to
                                                                     appearing on the facilty roster report.                             confirm. (183228)                                                           Here are the examples:
                                                                                                                                         9/14/10: I revised the logic for updating end dates.                        1. Offender No. 513378
                                                                     An example of this is I/M Lonewolf, Charles # 503427. he was        Examples:                                                                   2. Offender No. 442695
                                                                     remanded on 9/12/10 and on the alpha roster it indicates that he is 1. 360429
                                                                     Medium Custody but on an offender search, it does not show a        2. 7758
                                                                     custody level. An interesting item to point out is that the first   3. 186
                                                                     custody level listed in the Classification screen is minimum and    4. 321567
                                                                     shows an end date as you programmed into the system but all of
                                                                     the other entries do not have an end date.                          9/14/10 - Please provide example, because I believe you said
                                                                                                                                         effective date -1.


                                                                                                                                                9/14/10 - The end dates are reflecting one day prior to effective
                                                                                                                                                date, should be one date prior to the next custody effective date.



artf1730   Facilities    Visitor Address    Visitor - Address        The city is not saving on the visitor address.                      9/15/10 - Received confirmation from Bernie - ok                            VisitorAddressProcessorImpl.java                                     Cyndi            9/16/10
                                                                                                                                         9/14/10 - UAT validated - email sent to confirm
                                                                                                                                         9/14/10 - QA Validated
artf1694   Facilities    Visitor Conditions Visitor Condition        Need to increase the "comments" text box to allow additional test - 9/15/10 - Received confirmation from Bernie - ok                            alter table ofndr_cvln_cond modify(cmt lvarchar(500));               Bernie Kohut     9/16/10
                                                                     500 characters. This needs to be allowed to enter and save.         9/14/10 - UAT Validated - email to Bernie to validate                       get_ofncvln_cond
                                                                                                                                         9/14/10 - QA Validated                                                      get_ofncvln_cond_m
                                                                                                                                         9/13/10 - Comment section is only saving 80 characters.                     w_otr_s11_10_2.jsp
artf1717   Facilities    Visitor Reports    Visitor - Reports        1. Offender Visitor Roster - Currently report is showing multiple   9/15/10 - Received confirmation from Bernie - ok                            artf_1717                                                            Phillip Rosen    9/16/10
                                                                     visitor records for addresses that have ended. Should only show     9/14/10 - UAT Validated - email to Bernie to validate                       -------------------
                                                                     the visitor with teh current addresses. (31148)                     9/13/10 - QA Validated                                                      get_vistr_pattern_report (in jasper server)
                                                                                                                                                                                                                     get_visitor_hist_report
                                                                     2. The location on the visitor history report is showing hte current                                                                            get_visitor_list
                                                                     location of the offender and not the actual location of where the                                                                               get_ofndr_visitor_roster_rpt
                                                                     visit occurred.

                                                                     3. Visitor Pattern Report - the location of the visit is showing the
                                                                     offender current location and not the actual location of the visit.

                                                                     See attached document.



artf1451   Inmate        Till               Assigned Till - Different User was able to make transactions under her login, even though           9/15/10 - Received confirmation from Amy - OK                        [artf1451]                                                           Denise Dickens   9/16/10
           Banking                          User                      the user that assigned the till was not the user that was making hte      9/14/10 - UAT Validated - email to Amy, Denise and Devra for          - fixed the other areas to show proper messages for till.
                                                                      transaction. The till assignment shoudlfreeze all till activity for all   validation.
                                                                      users EXCEPT the person that assigned the till, or a supervisor that      9/14/10 - QA Validated                                               [artf1451]
                                                                      has rights to the Balance Till-SUpervisor Override.                       9/13/10 - The receipting, disburse, void and quick release is         - fixed the Sup Override and flow for one till at a time.
                                                                                                                                                allowing user to use other tills - should not.
                                                                                                                                                9/8/10 - Not functioning properly. See FCC in QA.                    [artf1451]
                                                                                                                                                                                                                      - changed the flow to allow user to open one till at a time.
                                                                                                                                                                                                                      - another user can open different till from same location.
artf1647   P&P           Offender History Supervision Contacts       When running the offender history report, it appears that it is not        9/14/10 - UAT validated (1269) - email to Lori to confirm            Tested for offender :525515. All the types were being pulled up in   Lori Wharton     9/16/10
                                                                     including all applicable types need to include the follwoing:              9/9/10 - Ran varios scenarios on offender 504214 in the QA           the report.
                                                                     Telephone Rural                                                            environment - successfully displayed on offender report and field
                                                                     Office PO COntact                                                          po desktop.
                                                                     Mail Rural

                                                                     #437433 - 8/23/10




                                                                                                                                                                                                                                                                                                              Page 44 of 48
                                                                                                                                 "HOT" Items
                                                                                                      1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality     Title                   Description                                                       Additional Notes                                                 Technical Notes                                                 Issue          Actual
ID         ule                                                                                                                                                                                                                                                       Source         Completion
                                                                                                                                                                                                                                                                                    Date
artf1692   P&P           Workload Report PO Workload Report & Stored procedures: get_po_workload_rpt and                            9/14/10 - UAT Validated - Anchorage PROB - Verified totals and   Modified SPLs to get all Active agent .                         Lori Wharton   9/16/10
                                         Field PO Workload    get_agnt_workload_rpt should filter out non active                    active/non-active field po's - email to Lori to confirm.
                                         Report               po’s/agents.                                                        9/13/10 - QA Validated                                             SPL names
                                                                                                                                                                                                       -------------------
                                                                                                                                    9/8/10: While this issue regarding the active and non-active Field get_po_workload_rpt
                                                                                                                                    PO's has been resolved, there is an issue with the totls that are   get_agnt_workload_rpt
                                                                                                                                    appearing - this has been returned to the developer for additional
                                                                                                                                    review.

                                                                                                                                    9/7/10: UAT Validated - email sent to Lori for validation.
                                                                                                                                    9/7/10 - QA Validated

Artifact   Location/     Functionality    Title                   Description                                                       Additional Notes                                                 Technical Notes                                                 Issue          Actual
ID         Module                                                                                                                                                                                                                                                    Source         Completion
                                                                                                                                                                                                                                                                                    Date
artf1775   Environment/S Public View      Non-DOC Report -       Need to add the following additional report, also require data     9/24/10 - Production Confirmed                                   Report done in QA. 09/17                                        Don Brand      9/23/10
           ystems                         Foreign Born Inmates - range search criteria:
                                          New                     - Foreign_Born_Inmates_New – ak_ins_new                                                                                          Modified SPL and 536642 offender infos pulling to report too.

                                                                                                                                                                                                     Report is based on intake_date and also non - US
                                                                                                                                                                                                     citizenship offenders pull..


                                                                                                                                                                                                     Files:
                                                                                                                                                                                                     jsp/menu.public.reports.jsp
                                                                                                                                                                                                     jsp/ftrack/nonUser.jsp


artf1606   Environment/S Reports          Non-DOC Report -       Need to add the following additional report, also require data     9/24/10 - Production Confirmed                                   Report done in QA. 09/17                                        Don Brand      9/23/10
           ystems                         Foreign Born Inmates - range search criteria:
                                          All                     - Foreign_Born_Inmates_All – ak_ins_dt_c                                                                                         Meet requirement as requested by cyndi-09/19.
                                                                                                                                                                                                     Report will pull only who are active release date.
                                                                                                                                                                                                     So 155244 - is active and pull this report too.




                                                                                                                                                                                                     Files:
                                                                                                                                                                                                     jsp/menu.public.reports.jsp
                                                                                                                                                                                                     jsp/ftrack/nonUser.jsp

artf1764   Environment/S Various          Stored Procedure        1. -661 errors on stored procedure get_bop_counts                   9/24/10 - Production Confirmed                                 [artf1764]                                                      Lori Wharton   9/23/10
           ystems                         Issues                  2. spl: get_furlough generating -217 error                                                                                          - fixed the procedures in DEV, QA and UAT.
                                                                  3. -284 A subquery has returned not exactly one row.
                                                                  Find_intvl_by_time
                                                                  Get_addr_typ_cd
                                                                  Get_cen_s1_d
                                                                  Get_ofndr_hstry
                                                                  Get_ofndr_rdu
                                                                  Get_prob_st_end
                                                                  Get_prsn_rlse
                                                                  Get_rlsecasestat
                                                                  Get_rlsecasestat_ac
                                                                  Get_till_acct_balance
                                                                  Update_case_status
artf1760   Facilities    Grievances       Grievance Search        The initial ACOMS rollout provided options to search for grievances 9/24/10 - Production Confirmed                                 artf_1760                                                       Tim Lyden      9/23/10
                                                                  by 1) grievance number, 2) offender name, 3) offender number, or                                                                   -------------------
                                                                  4) location. This ability was lost during updates.                                                                                 GrievanceAction.java
                                                                                                                                                                                                     GrievanceAction.java
                                                                                                                                                                                                     get_grvnc




                                                                                                                                                                                                                                                                                       Page 45 of 48
                                                                                                                                   "HOT" Items
                                                                                                        1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality    Title                    Description                                                               Additional Notes                   Technical Notes                                                     Issue           Actual
ID         ule                                                                                                                                                                                                                                     Source          Completion
                                                                                                                                                                                                                                                                   Date
artf1425   Facilities    Report          Facility/Offender        1. Need to add the link/functionality of the "Facility/Offender       9/24/10 - Production Confirmed         Report has modified as mentioned pointy 1,2 & 3.                    Amy/Devra/Jessi 9/23/10
                                         Balance Report           Balance Report" to the facilities module. Currently this is available                                                                                                            e
                                                                  only in Inmate Banking, would like to have available in facilities as                                        Files :
                                                                  well.                                                                                                        /otrack/ota/imbatch/GetIBReportDatesForm
                                                                                                                                                                               /otrack/ota/imbatch/GetIBReportProcessorImpl
                                                                  2. Is there a way we can chose to have either the checking, savings                                          /src/otrack/ota/report/imb_ofndr_balance_rpt.jasper
                                                                  or both?                                                                                                     /jsp/menu.reportsDIOMain.jsp

                                                                  3. Add functionality to be able to produce an excel file - like what is
                                                                  available in the facility roster report. (Don Brand)

artf1664   Facilities    Visitors        Visitors - Active &      Need to modify the offender profile visitor link when entered that        9/24/10 - Production Confirmed     OffenderCivilian.java                                               Paul Brown       9/23/10
                                         Inactive                 has the ability to view both active and inactive visitors - need to                                          OffenderVisitorAction.java
                                                                  add a column on the screen that identifies. IN addition, restict                                             OffenderVisitorForm.java
                                                                  "check-in" "out" if visitor is not approved/active.                                                          OffenderVisitorProcessorImpl.java
                                                                                                                                                                               w_otr_s11_13_1.jsp
                                                                                                                                                                               get_ofncvln
artf1696   Inmate        Attachments     Attachments -            Need to modify the current transaction codes to process the               9/24/10 - Production Confirmed     [artf1696]                                                          Kevin Worley     9/23/10
           Banking                       Transaction Codes        correct transaction.                                                                                          - changed the layout for attachment form to accomodate
                                                                                                                                                                               Description (gl_tran_cd).
                                                                  140 – Court Restitution / Fines
                                                                            - applied new transaction codes based on Deduction Type.
                                                                  347 - CRC Restitution
                                                                  140 – Fines / Surcharge

                                                                  125 – JCO Prior Year

                                                                  50 – Medical Co-payment

                                                                  140 – Surcharge

                                                                  1019 – Civil Judgments

                                                                  1020 – Counseling Fees

                                                                  1021 – Court Appointed Counsel

                                                                  1022 – Court Filing Fees

                                                                  1023 – Violent Crimes Compensation

                                                                  50 - Medical Restitution
                                                                  140 - CSED T&H

                                                                  In addition, the attachment of child support needs to be able to
                                                                  select one of the 5 transaction codes:
                                                                  8 – AK Child Support Services

                                                                  136 – WA Child Support Services

                                                                  181 - ID Child Support Services
                                                                  1017 – OR Child Support Services (needs a number)

                                                                  1018 – TH Child Support Services (needs a number)


                                                                  The NEW codes need to be in the category of INMATE.

                                                                 NOte: There are still some attachments that are pending codes -
artf1811   Inmate        Quick Release   Quick Release - Receipt The quick release is not saving when no cash is being disbursed.           9/24/10 - Production Confirmed     Quick Release issue fixed in QA & UAT.09/21                         Casey Desiena    9/23/10
           Banking                       issue
artf1177   P&P           Legal Status    Legal Status Report     Modify report to show offenders who are currently assigned to a            9/24/10 - Production Confirmed     Modified report and added new column for Assigned location for      Chris McKenzie   9/23/10
                         Report                                  probation officer at a specific location (e.g., Anchorage Probation)                                          each offender.
                                                                 and then show the current location of those individuals as well as                                            09/13-Done.
                                                                 their Legal Status
                                                                                                                                                                               Issue with any location pick will able to shows Report PDF. 09/15

                                                                                                                                                                               agntCaseLoad.jasper
                                                                                                                                                                               get_agnt_case_load()

artf1695                 Assessments     Assessment Listing -     The assessment test are not displaying in date order on the               9/24/10 - Production Confirmed     09/15 - Assessment Listing Sort Order by Test Date issue Fix.       Lori Wharton     9/23/10
                                         Order                    Offender Assessment Listing screen.
                                                                                                                                                                               SPL : get_cpa_ofdr_tst()

Artifact   Location/     Functionality   Title                    Description                                                               Additional Notes                   Technical Notes                                                     Issue            Actual
ID         Module                                                                                                                                                                                                                                  Source           Completion
                                                                                                                                                                                                                                                                    Date


                                                                                                                                                                                                                                                                       Page 46 of 48
                                                                                                                                    "HOT" Items
                                                                                                         1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality      Title                    Description                                                          Additional Notes                                                    Technical Notes                                                         Issue           Actual
ID         ule                                                                                                                                                                                                                                                                       Source          Completion
                                                                                                                                                                                                                                                                                                     Date
artf1657   Environment/S Broadcast         Broadcast Message        Need the ability to enter a notification via system admin            9/29/10: UAT Validated - email to David, Lori, Michael and Don to   [artf1657]                                                              Don Brand       9/30/10
           ystems        Message                                    functionalities that would provide any users currently logged in a   confirm.                                                             - made a new section for Administrator Broadcast Messages
                                                                    "warning" message (pop-up window, etc.) which woudl require the      9/27/10: QA Validated                                                - acknowledge messages
                                                                    user to acknowledge the message "OK".                                9/22/10: Please retest.                                              - converted date to proper format
                                                                                                                                         9/21/10 - System froze - unable to log in.                           - converted the Enter to <br> while saving
                                                                    Requirements:                                                        9/21/10: made it more dynamic, please retest.                        - displayed the only active messages to users
                                                                    1. Message should allow a minimum of 250 characters.
                                                                    2. Each message should appear only once for each user that is        9/21/10 - Added message - system locked up and won't allow
                                                                    logged in and require that user acknowledge the message.             access.
                                                                    3. Message maintanance must be handled through the admin
                                                                    functions.


artf1722   Environment/S Photos            Photos - "Read Only"     Need to prevent a user that has "read only" rights to not allow      9/29/10 - UAT Validated (cisuser3) - email to Lori and Don to       [artf1722]                                                             Lori Wharton     9/30/10
           ystems                                                   access into the image program. Currently they can access,            confirm.                                                             - added the insert image rights check to block the adobe installer
                                                                    however if they try to add it stops them. AKDOC would like the       9/27/10 - Photo Capture is no longer avaialble if the user does     icon.
                                                                    user stopped at the point of the offender profile screen.            not have rights - verfied 525478 - w/wo rights                       - also changed the layout to table structure internally to render the
                                                                                                                                                                                                             page properly.
artf1776   Environment/S Public View       Non-DOC Reports -     1. Need to add the following additional report, also require data       9/29/10 - UAT Validated - Email to Don and Lori to confirm.         New Report is created :09/24                                           Don Brand        9/30/10
           ystems                          Labor Updated Inmates range search criteria:                                                  9/27/10 - QA Validated.
                                                                  - Labor_Updated_Inmates – ak_unempl_2
artf1777   Environment/S Public View       Non-DOC Reports -     Need to add the following additional report, also require data          9/29/10 - UAT Validated - email to Lori and Don to confirm.         New non Doc Report created :09/24                                       Don Brand       9/30/10
           ystems                          Vetran Felon Inmates range search criteria:                                                   9/27/10 - QA Validated (340908)
                                                                  - Veteran_Felon_Inmates – ak_vets (spl not converted to
                                                                 acoms)
artf1808   Facilities    Central           Central Monitoring -  We request that only the location of the separatee be visible to all    9/30/10 - UAT validated with Lori via call.                      [artf1808]                                                                 Pamela Martin   9/30/10
                         Monitoring        Offender Profile link non-classification staff. We only want those outside of                 9/30/10 - QA Validated (525635, 525511, 525510, 525512,          [artf1814]
                                                                 Transportation and Classification to see the “conflict                525479)                                                           - removed the two columns for Conflicted Offender Number and
                                                                                           ,
                                                                 person’s locations―not the name or number. Need to modify           9/28/10 - Please retest in QA.                                   Name.
                                                                 the central monitoring link on the offender profile.                                                                                      - added the Non DOC Staff Member in listing screen and
                                                                                                                                         9/28/10 - Added CM to 525505, with 525515 and staff member adding/editing screens.
                                                                                                                                         as conflict - locations do not appear on screen.                  - modified the search.
artf1814   Facilities    Central           Central Monitoring -     Need a freeforn field that allows user to enter a name for a staff   9/30/10 - UAT validated with Lori via call                       [artf1808]                                                                 Pam Martin      9/30/10
                         Monitoring        Non-DOC Staff            member (non-doc) that is not in the system that shoudl be kept       9/30/10 - QA Validated. (525635, 525511, 525512)                 [artf1814]
                                           Member                   separate from offender.                                              9/28/10 - Please retest in QA.                                    - removed the two columns for Conflicted Offender Number and
                                                                                                                                                                                                          Name.
                                                                    Per Pam: First and last name and location would be great. We         9/28/10 - If an staff member is added and then a non-doc person, - added the Non DOC Staff Member in listing screen and
                                                                    need to be able to do this for both contract workers who don’t     receive primary key constraint: Error encountered... This record adding/editing screens.
                                                                    use ACOMS and for staff. Right now, ACOMS asks for an offender       is already present. Primary key violation in the database.        - modified the search.
                                                                    number when we add a staff name (someone that is a user). The
                                                                    conflict staff name only appears as their ACOMS user ID, not their
                                                                    name.
artf1658   Facilities    Custody Level     Custody Level -          Request to add a "Comments" field that would capture maximum 9/29/10 - UAT validated - email to Gary, Rebecca, Lori to                   [artf1658]                                                              Lori Wharton, G. 9/30/10
                                           Classification Desktop   100 characters on the Custody Scoring Form screen w_dio_s9_4.jsp confirm.                                                                 - added the new field on screen called 'Comments'                      Harris, R.
                                                                                                                                       9/28/10 - QA Validated - 100 characters saved and viewable.                                                                                   Brunger

artf1189   Facilities    IPO Intake Form   IPO Intake Form          The distribution section needs to be modified to reflect:            9/29/10 - UAT Validated (525515) - email to Mary Sandy to           Report error in text so now it has corrected format.                    Mary Sandy      9/30/10
                                                                    1. "cc" and not "oc"                                                 confirm
                                                                    2. The "PD III" should be "PO III"                                   9/28/10 - QA Validated.                                             Japer File: ipo_intake_form_rpt.jasper
                                                                    (MANITS 2186)                                                        9/27/10 - PO 111 should be PO III (Roman Numerals)
artf1728   Inmate        Account Hold      Offender Account on      When an offender account is on hold and the medical payments         9/29/10 - UAT Validated - email to Devra and Kevin to confirm.      [artf1728]                                                              Devra Hayes     9/30/10
           Banking                         HOld                     put the offender in a negative balance, it is not allowing user to   9/28/10 - QA Validated                                               - added the check for balance to be > 0 in order to check validation
                                                                    remove the hold.                                                                                                                         for amount on hold.
artf1816   Inmate        Labor Hours       Payroll - Modification   If you update and offender (and have NOT posted the batch), all    9/29/10: Uat Validated - (528329-anch) - Email to Kari to                                                                                     Kari French     9/30/10
           Banking                                                  previous hours for prior entries change to 0.00                    confirm.
                                                                                                                                       9/27/10 - Updated hours nmerous times - then posted -
                                                                                                                                       functioned properly 28191.
artf1716   P&P           Contact List      Contact List             1. The phone numbers are not appearing on the Field PO Contact 9/29/10 - UAT Validated - email to Jessical to confirm.                   [artf1716]                                                              Jessica Mathews 9/30/10
                                                                    List. Example: Field PO: mrstanley, offender #489757 has a current 9/27/10 - QA Validated (12, 504214, 503706)                            - fixed the phone number issue, pulling the latest phone
                                                                    phone, however does not appear on list.                                                                                                  numberfrom offender's account.
                                                                                                                                                                                                             - zone seems to be working fine.
                                                                    2. The Zone is not always appearing and should



                                                                                                                                                                                                                                                                                                         Page 47 of 48
                                                                                                                            "HOT" Items
                                                                                                 1af6dc86-becd-4bde-b1a5-554237f90358.xls Prod Approved Items-6.24.10

Artifact   Location/Mod Functionality   Title                Description                                                         Additional Notes                                        Technical Notes                                                 Issue           Actual
ID         ule                                                                                                                                                                                                                                           Source          Completion
                                                                                                                                                                                                                                                                         Date
artf1457   P&P           Supervisor     Supervisor Desktop   Add the functionality of an "view" icon to the supervisor desktop   9/29/10 - UAT Validated - email to Jessica to confirm   [artf1458]                                                      Jessica Mathews 9/30/10
                         Desktop                             next to each of the subordinates names that would take user to      9/28/10 - QA Validated                                   - added the new image/link under Supervisor Desktop ->
                                                             the subordinates caseload for viewing.                                                                                      Subordinates listing to go each subordinate desktop (Field PO
                                                                                                                                                                                         Desktop)




                                                                                                                                                                                                                                                                            Page 48 of 48

				
DOCUMENT INFO
Description: Pre Cana Certificate document sample