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