2019-10-10 - Report-29
Date
Attendees
Agenda/Notes
Goal: Dorie wants a list of drawings that have been changed that might recently affect Pump Stations and Force Main assets in Maximo.
Records Center > Drawings > Plans Review (ex number=4-85)
you get a list of Name, ProjectName, Date, Business Nunit
I think there's 3 set's of data to join together
A2P
- contains Number (which ties to records center),
- GridNo, UsGridNo, DsGridNo - which are pointers to assets. They want the forcemains, and pumpstations. (because of the 3 columns, we might have a union query here)
- hmm, as I recall, forcemain or pumpstation or both MIGHT be locations, so we might need to get creative with this.
Maximo contains asset number, description, status
Record Center contains the Title, and Number