Extract Interim Consumption

Use Extract Interim Consumption to go through interim history for a date range, accumulate the usage, and divide it by the number of billing periods. The results are stored in the location_connection_history_usage table (LCHU) and can then be used by a process like the Meter Import along with a Consumption import type to create billing transactions. A list of customers who are pulled in the workfile is generated.

The location_connection_history_usage table (LCHU) also stores regular usage history from billing posts. Interim history can seen from several places - the Import Interim Reading using the meter import type, you can manually add them in the Read History view, probably some billing transactions, and there is an add interim read wizard, which works in the same as the Read History view. Extract Interim pulls data from there and stores it in UBCONS, and there are a few meter import types that either put data into UBCONS, or pulls data from UBCONS, or creates these LCHU interim records.

Notes:

Meter Import Types:
0 - Readings
1 - Flat Charges
2 - Import Consumption
3 - Consumption
4 - Estimate Usages
5 - Customer Consumption
6 - Import Interim Readings
7 - Import Exceptions

To see an example of the report, click Extract Interim Consumption Report Sample.

Directions:

To open:

1. Click Daily Work from the menu.

2. Click Billing.

3. Click Reading Tools.

4. Click Extract Interim Consumption.

Or, use the keyboard shortcut: [ALT] [y] [b] [r] [r] [e].

Extract Interim Consumption Window Example:

Extract Interim Consumption Prompts
Services	To select the services to post, click to check the appropriate services listed. Tip: To quickly select or de-select all services listed, click the Check All icon .
Companies	To select the companies to post, click to check the appropriate companies listed. Tip: To quickly select or de-select all companies listed, click the Check All icon .
Books	To select the books to post, click to check the appropriate books listed. Tip: To quickly select or de-select all books listed, click the Check All icon .
Billing Periods	Enter the number of billing periods in the date range from which you are extracting reading history.
From Date Through Date	Enter the starting date and the ending date from which to extract readings.
	To start the interim extract, click Proceed. Keyboard shortcut: [ALT + p] Or, to escape without performing the interim extract, click Cancel . Keyboard shortcut: [ALT +c]