20190927 - Report-29
Date
Attendees
Agenda/Notes
- Dorie is looking for a report. She put's in a date range and it will check the p2a database (aka SASD.Asset_Sheet_Link) for records that were posted to SDE during that date range. From their it will scan 1) the grid_no looking for FM's, 2) usgridno, dsgridno looking for Pump Stations. Then it will list those assets
- Page, asset number, location
- App > Records Center > Drawings > Plans Review. View Library - 1,
- Title=9210 (search)
- that Number column represents a plan number
Note FM are children of pump station
Strategy 2 - we could look into the plans database, the log entries table contains a maximo SR#. While this route could also work, the first strategy is better.