Authorization Letter for Bank Statment

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 "2008-04-05" || " 18:00") and (chk_dt_tm 0 THEN

LET o_crm_dgr = 'Felon';

ELIF l_mdmnr > 0 THEN

LET o_crm_dgr = 'Misdemeanor';

END IF

Page 31 of 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 ) >― . “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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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 46

"HOT" Items

96e95422-535d-4c2b-9dfd-a5d5048ae245.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()









Page 46 of 46