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 |