Device Segmentation
For each service, determine if there exist meters, badged items, or non-badged items at the service points. For example, if we assume:
Electric service has service points with meters, badged lamps, and parking lots.
Gas and water services just use meters.
Waste water service doesn't actually have a meter installed at it (it uses the water consumption measured by the water service point's meter)
Then your SP types will be:
SP Type
Service Type
SP Sub Type
GAS - METERED
Gas service
Meter
WATER - METERED
Water service
Meter
WASTE WATER
Waste water service
Unbadged
ELECTRIC - METERED
Electric service
Meter
ELECTRIC - BADGED LAMP
Electric service
Item
ELECTRIC - PARKING LOT
Electric service
Unbadged