Geographic Area Segmentation
The following table reflects the new service providers that were added since we started Designing Service Providers.
CIS BU/
SA Type
SA Relationship Type
Service Provider
G/COM
Energy supply
AmeriGas
TransGas
Green Power
G/IND
Energy supply
AmeriGas
TransGas
Green Power
E/RES
Energy supply
Green Power
Cheap Power - Res
Us - Billable
E/COM
Energy supply
ElectriCorp
Cheap Power - Com/Ind
TeniCorp - Com
Meter service
MeterCorp
Us - Non billable
E/IND
Energy supply
ElectriCorp
Cheap Power - Com/Ind
TeniCorp - Ind
Meter service
MeterCorp
Us - Non billable
Next, determine the postal code ranges in which a service provider is allowed to provide service.
CIS BU/
SA Type
SA Relationship Type
Service Provider
Postal Range
G/COM
Energy supply
AmeriGas
94000 - 95999
TransGas
94000 - 95999
Green Power
94000 - 95999
G/IND
Energy supply
AmeriGas
94000 - 95999
TransGas
94000 - 95999
Green Power
94000 - 95999
E/RES
Energy supply
Green Power
94000 - 95999
93000 - 93999
Cheap Power - Res
94000 - 95999
Us - Billable
94000 - 95999
E/COM
Energy supply
ElectriCorp
94000 - 95999
Cheap Power - Com/Ind
94000 - 95999
TeniCorp - Com
94000 - 95999
Meter service
MeterCorp
94000 - 95999
Us - Non billable
94000 - 95999
E/IND
Energy supply
ElectriCorp
94000 - 95999
Cheap Power - Com/Ind
94000 - 95999
TeniCorp - Ind
94000 - 95999
Meter service
MeterCorp
94000 - 95999
Us - Non billable
94000 - 95999
Next, we need to strip off the SA types because the postal ranges are defined for combinations of service provider and SA relationship type. Notice the problem - we have a service provider - Green Power has different postal ranges for the same SA relationship type. You have two ways to fix this problem, you can split your service provider (have one for the gas and another for the electric), or you can split the SA relationship type (have one for the gas and another for the electric). We've chosen the former in our example.
SA Relationship Type
Service Provider
Postal Range
Energy supply
AmeriGas
94000 - 95999
TransGas
94000 - 95999
Green Power - Gas
94000 - 95999
Energy supply
AmeriGas
94000 - 95999
TransGas
94000 - 95999
Green Power - Gas
94000 - 95999
Energy supply
Green Power - Electric
94000 - 95999
93000 - 93999
Cheap Power - Res
94000 - 95999
Us - Billable
94000 - 95999
Energy supply
ElectriCorp
94000 - 95999
Cheap Power - Com/Ind
94000 - 95999
TeniCorp - Com
94000 - 95999
Meter service
MeterCorp
94000 - 95999
Us - Non billable
94000 - 95999
Energy supply
ElectriCorp
94000 - 95999
Cheap Power - Com/Ind
94000 - 95999
TeniCorp - Ind
94000 - 95999
Meter service
MeterCorp
94000 - 95999
Us - Non billable
94000 - 95999
In the table below, we have shown the final list of service providers.
Service Provider
Billing Relationship
Payment Relationship
Consumption Relationship
AmeriGas
We Bill For Them - Bill Ready
Pay At Billing Time
We Send Consumption
TransGas
We Bill For Them - Bill Ready
Pay At Billing Time
We Send Consumption
Green Power - Electric
We Bill For Them - Rate Ready
Pay At Billing Time
N/A
Green Power - Gas
We Bill For Them - Rate Ready
Pay At Billing Time
N/A
Cheap Power - Res
We Bill For Them - Rate Ready
Pay At Billing Time
N/A
Cheap Power - Com/Ind
Dual Billing
N/A
N/A
Us - Billable
It's Us
N/A
N/A
Us - Non billable
None
N/A
N/A
ElectriCorp
They Bill For Us - Bill Ready
N/A
N/A
TeniCorp - Com
We Bill For Them - Bill Ready
Pay At Billing Time
We Send Consumption
TeniCorp - Ind
We Bill For Them - Bill Ready
Pay At Pay Time
We Send Consumption
MeterCorp
Dual Billing
N/A
N/A