[URGENT] SBO Sidewalk Data - Sidewalk Prioritization (AD R. Hershaw)

[atdservicebot]

What application are you using?

Maximo

Describe the problem.

Hello, I have already spoken with Adriana about this request, but I require assistance with a report. I don't need it completed today but I do need it tomorrow.

How soon do you need this?

Urgently — Critical that this is addressed today

Requested By Ryan H.

Request ID: DTS24-113055

[adry-martinez]

Feb. 27, 2024

Conferred with CTM Nick O. for query support.

Compiled the following table which was shared with requestor R. Harding

[adry-martinez]

Feb. 28, 2024

User acceptance approved. Requestor is asking for a report. No due date. CTM Nick notified via e-mail.

@ReneVarg25 when/if they ask for another round of data, please remind CTM Nick of these SQLs:

For number of sidewalk CSRs we've responded to FY to date ((status = '4COMP' or status = '4COMP-ND' or status = '4COMP-NFR' or status = '4QACOMP' or status = '4QAREJ') and istask = 0 and upper(csr311number) like '%' and failurecode = 'SIDEWALK' and (woclass = 'WORKORDER' or woclass = 'ACTIVITY') and reportdate <= '2024-03-01 05:59:00.000' and historyflag = 0 and reportdate >= '2023-10-01 05:00:00.000' and siteid = 'SBO')

For number of those sidewalk CSRs that received hot mix asphalt for FY24

SELECT workorder.wonum, workorder.siteid, matusetrans.itemnum, workorder.status

FROM maximo.workorder workorder left join maximo.matusetrans matusetrans on matusetrans.refwo = workorder.wonum and matusetrans.tositeid = workorder.siteid where matusetrans.itemnum = 'SBO1004' and matusetrans.transdate between '2023-10-01' and '2024-02-27' and (matusetrans.siteid = 'SBO' and (workorder.status like '4COMP%') or (workorder.status like '5%')) and workorder.origrecordid like 'CSR%' and workorder.parent is null

For current backlog of sidewalk CSRs pending restoration as of today

(wonum in (select wochild.parent from workorder wochild , sr , workorder woparent
where wochild.origrecordid = sr.ticketid and sr.siteid = 'SBO' and wochild.origrecordclass = 'SR'
and sr.csr311number is not null
and woparent.siteid ='SBO' and sr.siteid = 'SBO' and woparent.wonum = wochild.parent and woparent.status not in ('4QACOMP','4COMP-ND','4COMP','4COMP-NFR','5CLOSED','5CANCEL') )) and ((reportdate >= '2023-10-01'
and siteid = 'SBO' and reportdate <= '2024-MM-DD'
and failurecode = 'SIDEWALK'))

[adry-martinez]

Mar. 25, 2024

Ryan H. requesting for data to be on the SBO Project Coordination Start Center as portlets.

[adry-martinez]

April 16, 2024

CTM completed scripting/querying requested result set.

Portlets have been created and added to Project Coordinator Start Center.

[adry-martinez]

Requestor notified to update start center to display added portlets. Issue closed.