| Interface Connects |
Function |
GIS Features |
Identifier Attribute |
References to |
Operational Use |
| GIS to SAP |
Retrieves maintenance orders and project information |
connection, streetname |
connection number |
SAP; used with a SAP PM work order or SAP PS project |
The user can select one or more connection points in the GeoLink application, start the SAPGui, and receive a list of maintenance orders and projects referenced to these connection points. The user can also select one or more streets and retrieve a SAP report that displays all maintenance orders for those streets and an overview of larger PS projects. In the report, the user can select a specific work order and retrieve detailed information about it using the SAPGui interface. |
| GIS to SAP |
Retrieves functional location information |
watertower, pumping station, WPC, streetname |
functional location |
A SAP functional location |
In the GeoLink application, the user selects an infrastructure and clicks on the SAP3 functional location button. Functional location information for the selected element is displayed on the screen. This allows GIS users to quickly get detailed information about a functional location by passing parameters from GIS to the SAPGui. |
| GIS to SAP |
Retrieves maintenance orders that are linked to the location of a problem |
problem location point |
workorderid |
A SAP PM maintenance order |
The user selects one or more problem location points for an area and uses the SAP4 button to start the SAPGui in PM. The workorderid attributes from GIS are used as the selection criteria. A list of maintenance orders gives detailed information about the problem. |
| GIS to CIS |
Retrieves scanned connection schematics |
connection |
connection number |
The CIS intranet environment; uniquely identifies a connection |
In GeoLink, the user can select the connections layer and use the default ArcIMS hyperlink tool to click on a connection, retrieve the connection number, and pass it as a parameter in a URL to the intranet archive. This produces a list of available scanned documents in the archive containing detailed historical information. |
| GIS to CIS |
Retrieves customer information |
connection, streetname |
connection number |
CIS mainframe; uniquely identifies a connection |
This provides accurate information on customers that will be affected by construction or maintenance on the network and who need to be notified. After one or more streets have been selected in the GIS, this interface produces a detailed list of affected customers in an HTML table. This information is easily pasted into other applications and can be used for mailing lists. Future functionality will include main isolation tracing that can automatically select all connections linked to a specific network segment. |
| GIS to SCADA |
Retrieves real-time water level information |
watertower, pumping station |
SCADAID |
SCADA facility |
From an overview map or a map zoomed to an individual water tower, default hyperlink functionality can be used to get the actual water levels from SCADA. SCADA information is available through a browser interface on the intranet and only requires defining a URL with the SCADAID as a parameter. When the SCADA information is retrieved, an overview graph of the last 24 hours is also available. |
| SAP to GIS |
Zooms to a partner in GIS within SAPGui |
connection, streetname |
connection number |
SAP; used as a partner in a PM work order |
When the user selects an order in the SAP PM module, an extra tab sheet is created that uses the SAP HTML control to display the GeoLink application within the SAPGui. Opening the tab sheet retrieves the partner number and uses it in a URL to zoom to the streetname in GeoLink where the referenced connection is located. |
| GIS to SAP |
Creates maintenance order based on a GIS feature |
connection, streetname |
connection number |
SAP; used as a partner in a PM work order |
Calls about distribution network problems are routed to a dispatcher who looks up the location and assesses the situation. By selecting a street, the dispatcher can retrieve connection information. A SAP work order is started either on the street level or at a specific connection and uses the GIS and SAP information to dispatch the nearest available crew. |
