Pump Station Electrical Maintenance Data Fields (Distribution)
Pump Station Electrical Maintenance data can be edited on either the Pump Station Electrical Maintenance Grid Window of the Repair Grid or the Pump Station Electrical Maintenance Property Sheet.
To view and edit all pump station electrical maintenance data, use the Property Sheet.
The following describes all the data which can be used to define a pump station electrical maintenance object.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Pump Station Electrical Maintenance Data
Database Table Name: wams_pump_station_em
|
Field Name |
Help Text |
Database Field |
Size |
Precision |
Default |
Error Lower Limit |
Error Upper Limit |
Warning Lower Limit |
Warning Upper Limit |
||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID |
The name of the object. The ID is the primary key in the database for the network object. This means that the ID field of each object must be unique for all objects of the same object type. |
id | Text | 40 | 0 |
|
|||||||||||||||||
| Pump station ID | ID of pump station at which maintenance was carried out. | pump_station_id | Text | 40 |
|
||||||||||||||||||
| Weather |
Weather conditions at time maintenance was carried out:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
weather | Text | 12 | 0 |
|
|||||||||||||||||
| X coordinate | X coordinate of maintenance location. | x | Double | XY | 2 |
|
|||||||||||||||||
| Y coordinate | Y coordinate of maintenance location. | y | Double | XY | 2 |
|
|||||||||||||||||
| Panel 1 |
Indicates whether maintenance has been carried out:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
panel_1 | Text | 10 | 0 |
|
|||||||||||||||||
| Panel 2 |
See Panel 1 |
panel_2 | Text | 10 | 0 |
|
|||||||||||||||||
| Panel 3 |
See Panel 1 |
panel_3 | Text | 10 | 0 | ||||||||||||||||||
| Panel 4 |
See Panel 1 |
panel_4 | Text | 10 | 0 | ||||||||||||||||||
| Panel 5 |
See Panel 1 |
panel_5 | Text | 10 | 0 | ||||||||||||||||||
| Panel 6 |
See Panel 1 |
panel_6 | Text | 10 | 0 | ||||||||||||||||||
| Remote control panel |
See Panel 1 |
remote_control_panel | Text | 10 | 0 | ||||||||||||||||||
| Comminutor panel 1 |
See Panel 1 |
comminutor_panel_1 | Text | 10 | 0 | ||||||||||||||||||
| Comminutor panel 2 |
See Panel 1 |
comminutor_panel_2 | Text | 10 | 0 | ||||||||||||||||||
| Main switch panel |
See Panel 1 |
main_switch_panel | Text | 10 | 0 | ||||||||||||||||||
| Comminutor motor 1 |
See Panel 1 |
comminutor_motor_1 | Text | 10 | 0 | ||||||||||||||||||
| Comminutor motor 2 |
See Panel 1 |
comminutor_motor_2 | Text | 10 | 0 | ||||||||||||||||||
| Float/Probe 1 |
See Panel 1 |
float_probe_1 | Text | 10 | 0 | ||||||||||||||||||
| Float/Probe 2 |
See Panel 1 |
float_probe_2 | Text | 10 | 0 | ||||||||||||||||||
| Float/Probe 3 |
See Panel 1 |
float_probe_3 | Text | 10 | 0 | ||||||||||||||||||
| Float/Probe 4 |
See Panel 1 |
float_probe_4 | Text | 10 | 0 | ||||||||||||||||||
| Float/Probe 5 |
See Panel 1 |
float_probe_5 | Text | 10 | 0 | ||||||||||||||||||
| Float/Probe 6 |
See Panel 1 |
float_probe_6 | Text | 10 | 0 | ||||||||||||||||||
| Alarm unit |
See Panel 1 |
alarm_unit | Text | 10 | 0 | ||||||||||||||||||
| Alarm float |
See Panel 1 |
alarm_float | Text | 10 | 0 | ||||||||||||||||||
| Telephone |
See Panel 1 |
telephone | Text | 10 | 0 | ||||||||||||||||||
| Sump pump |
See Panel 1 |
sump_pump | Text | 10 | 0 | ||||||||||||||||||
| Autochangeover |
See Panel 1 |
autochangeover | Text | 10 | 0 | ||||||||||||||||||
| Motor 1 |
See Panel 1 |
motor_1 | Text | 10 | 0 | ||||||||||||||||||
| Motor 2 |
See Panel 1 |
motor_2 | Text | 10 | 0 | ||||||||||||||||||
| Motor 3 |
See Panel 1 |
motor_3 | Text | 10 | 0 | ||||||||||||||||||
| Motor 4 |
See Panel 1 |
motor_4 | Text | 10 | 0 | ||||||||||||||||||
| Motor 5 |
See Panel 1 |
motor_5 | Text | 10 | 0 | ||||||||||||||||||
| Motor 6 |
See Panel 1 |
motor_6 | Text | 10 | 0 | ||||||||||||||||||
| Lighting external |
See Panel 1 |
lighting_external | Text | 10 | 0 | ||||||||||||||||||
| Lighting dry well |
See Panel 1 |
lighting_dry_well | Text | 10 | 0 | ||||||||||||||||||
| Lighting motor room |
See Panel 1 |
lighting_motor_room | Text | 10 | 0 | ||||||||||||||||||
| Generator |
See Panel 1 |
generator | Text | 10 | 0 | ||||||||||||||||||
| Water heater |
See Panel 1 |
water_heater | Text | 10 | 0 | ||||||||||||||||||
| Statutory electrical notices |
See Panel 1 |
statutory_electrical_notices | Text | 10 | 0 | ||||||||||||||||||
| Scheduled Task fields | See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet. | ||||||||||||||||||||||
| Attachments |
Click the See Attachments Editor and Common Data Fields for further details. |
attachments | |||||||||||||||||||||
| General properties fields | See Common Data Fields for details of field in the General properties section of the property sheet. | ||||||||||||||||||||||
| User defined properties fields | See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet. |
button to display the 