Maximo Report Request [New] Homeless Encampment

[rebekkabry]

Request Originated from: #18299 and https://github.com/cityofaustin/atd-data-tech/issues/18349.

OCE ROW group is asking for a report that shows SBO-IMG Work Orders for: Problem Code: PRVASSET

• BSKTGOAL
• DUMPSTER
• ROWOTHER

They'd like a Maximo report that breaks down the SBO-IMG Work Orders with these Problem Codes Problem Code: BSKTGOAL, DUMPSTER, ROWOTHER, FENCE

[rebekkabry]

Provided Lisa with manaul reports for now. 33873213_SBOIMG FY24b.xlsx

[rebekkabry]

DTS Maximo Sync 9/13/24 to discuss scope and add into sprint.

[rebekkabry]

@GaneshKamarapu Builder Notes

• [x] Build report from query SBOIMG ROW Obstruction Homeless Encampment
• [x] by breakdown of problem
• [x] by all status @rebekkabry get confirmation.
• [x] FENCE problem code not found? (ROWOTHER?)

[GaneshKamarapu]

@rebekkabry I have deployed new report in test environment. Can you please take a look?

[GaneshKamarapu]

[rebekkabry]

Updates 9/23/24

• Ganesh finished report in TEST
• Adding parimeters

  1. FY24 by all (show by problem code) 
  2. FY24 by open (show by status) 

[rebekkabry]

Updates from Meeting with Stakeholders

Monthly Performance Measures

• new csr received
• new csr 21 days over
• existing csr (backlog, not 5 status)
• total investigated for month
• new invstigated for month
• total closed for month
• total over than 120 days

Additional Requests:

Builder Notes

@GaneshKamarapu

• [x] update the available result sets to read the Page Title or dataset that would be exported
• [x] what the effort? Count of Days by Created Date
• [x] count of completed work orders monthly, add graph.
• [x] Update name from Homeless to "ROW Compliance/Response Investigation"

[rebekkabry]

11/7/24

• Met with ROW to review compliance report and start center
• Working to create a OCE IMG ROW start center for ROW Compliance / Encampment

DTS Build Note

Start Center

@rebekkabry

1. COMPLIANCE/REPORT *current report, can we confirm only WORKGROUP: SBOIMG, PROBLEMS: dumspter, basketball, CLASS: IMG_INV

2. HOMELESS (currenlty does not report on, but still represneted in INV_IMG ROW work order ownership. <>

3. INV_ROW_OBS Classification (Workgroup: SBOIMG)

Report

@GaneshKamarapu

• date added as a filter option before running the report.
• will add from and to date for the filter options.

Notes

Reporting: 
How do we find: 

ROW 
ROW - Compliance/Response
(basketball, dumspter, fence, etc)
SLA 120 days. 
- lisa, arielle, monica, colton, nick, robert 
Failure Class: BASKETBALL,DUMSP,FENCE

Homeless
ROW investigations - 
 - workgroup: SBOIMG/others depending on scope. 
Failure Class: OTHER/ENCAMPMENTRELATEDISSUES

- 311
  - send in as dist
  - lisa/arielle (create work order ticket and reassign sr to sboimg)  

- We create WO 
 - workgroup: SBOIMG
 - class: IMG_INV

- some meshing with "ours/OCE"

Why dowe have INV_ROW_OBSTRUCTION
add date reported and date completed to compliance report 
move start centers to PROD 
get updated list of access needs.