Revenue Segmentation
Look at your rates and determine which rates can be used by each SA type. The following table shows the sample rates that can be used for each service:
CIS Division/ SA Type |
Service Type |
Distribution Code |
Rates |
CA/G |
Gas service |
A/R-UTIL |
GALL-1 |
CA/W |
Water service |
A/R-UTIL |
WALL-1 |
CA/E |
Electric service |
A/R-UTIL |
ERES-1, ERES-2, ECOM-1, EIND-1, ELAMP-1 |
CA/WW |
Waste water service |
A/R-UTIL |
WWALL-1 |
CA/CABLE |
Cable service |
A/R-UTIL |
CABLE |
Now, look at the rates' calculation rule GL Distribution window. You're looking for calculation rules whose GL distribution is affected by revenue class. If there are no revenue classes referenced on the calculation rules, this means that the revenue associated with the rate will be booked to a single GL account regardless of the type of customer. If you see revenue classes, this means that the revenue account associated with the calculation rule(s) differs depending on the SA type's revenue class. If revenue classes are used in the rates, you must create a different SA Type for every revenue class.
Let's assume the following:
- The gas rate (GALL-1) references the RESIDENTIAL, COMMERCIAL and INDUSTRIAL revenue classes in order to differentiate revenue based on the type of customer.
- None of the other rates differentiate revenue based on customer class.
Our SA types will now look as follows:
CIS Division/ SA Type |
Service Type |
Distribution Code |
Revenue Class |
Rates |
CA/G-RES |
Gas service |
A/R-UTIL |
R - residential |
GALL-1 |
CA/G-COM |
Gas service |
A/R-UTIL |
C - commercial |
GALL-1 |
CA/G-IND |
Gas service |
A/R-UTIL |
I - industrial |
GALL-1 |
CA/W |
Water service |
A/R-UTIL |
N/A |
WALL-1 |
CA/E |
Electric service |
A/R-UTIL |
N/A |
ERES-1, ERES-2, ECOM-1, EIND-1, ELAMP-1 |
CA/WW |
Waste water service |
A/R-UTIL |
N/A |
WWALL-1 |
CA/CABLE |
Cable service |
A/R-UTIL |
N/A |
CABLE |
Notice that we created new SA types for gas in order to specify the respective revenue class. We didn't do this for the other services because it isn't necessary. However, you should feel free to do this if it feels right or if you need it for reporting purposes. For example, if you want to report on all residential service agreements, but you differentiate only gas by residential versus commercial, you'll be in trouble.