{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > Utility Billing > Parameters > UB System File > Hand held
Recent Changes:
6.231
- Added customer phone number, customer email address, customer billing address, route and sequence to replace custom fields 1 to 5 in the export file.
6.199
- The Channel 1 UOM field will now pull from the Unit of Measurement field on the Service Code Read Type if a value exists. Otherwise, it will continue to default to "GAL" / "CF" / "KWH"
6.160
- removed the service point id from the 'Generic' layout
- changed the name of the "Route" column to "Billing Cycle Route" in the 'Generic' Flexnet layout
6.149
- Added 'Generic' to the Flexnet data synchronization export type
6.131
- Added Service point Id to the data pull if the export type is 'Analytics' and 'Add service point ID' is set in Utility billing system file.
6.73
- Changed the data pull to only include meter location records having no removal date.
6.60
- Changed the datatype for the ReadingMultiplier column in the meter master to a decimal field. It's now 14, with 4 decimal places.
6.46
changed the query to consider the end date when selecting data. it will now select the active customer (customers with no end date), and if it cannot find a row with no end date, it will select the latest row with an end date.
6.29
Changed the service start date and relationship date to correspond the customer's start date. Added "KWH" to the possible values for channel 1 UOM.
6.21
Changed the query that provides the data for the export to include latitude and longitude from the meter table.
6.11
Changed the query that provided the data for the export to include active and inactive meters.Introduction
The Data Synchronization feature included in Handheld setup allows for the automatic export of meter data to be used in a variety of handheld reader types. For the meter to be included in this file the meter status has to be an 'A' or 'I' and the meter style has to be AMI. These are stored in ar210.
For Analytics Export Type it is looking for the meter status to be an 'A' or 'I' and the meter style to be AMI and the Service Code Read Type to be W(GAL)/G(CF)/E(KWH).
Explanation
The Enable Flexnet data synchronization, File Location, and Schedule Time options must be set for this feature to function.
The functionality will produce a file in the location set up in the File Location setting called dataSyncFile.csv.
The fields in the comma separated file are as follows.
| Name | Description |
|---|---|
| Meter Id | Meter Serial |
| Flexnet Id | Meter ERT Id |
| Billing Meter Id | Meter Serial |
| Meter Type | Meter Size |
| Commodity Type | Service Code Read Type |
| Compound Meter Flag | Not Currently In Use |
| State Region Id | State |
| Interval Read Freq | "60" |
| Register Read Freq | "1440" |
| Channel 1 UOM | Service Code Read Types - Unit of Measurement. If blank defaults to "GAL" / "CF" / "KWH" |
| Reading Multiplier | Reading Multiplier |
| Channel 2 UOM | Not Currently In Use |
| Channel 2 Read Multiplier | Not Currently In Use |
| Channel 3 UOM | Not Currently In Use |
| Channel 3 Read Multiplier | Not Currently In Use |
| Channel 4 UOM | Not Currently In Use |
| Channel 4 Read Multiplier | Not Currently In Use |
| Channel 5 UOM | Not Currently In Use |
| Channel 5 Read Multiplier | Not Currently In Use |
| Channel 6 UOM | Not Currently In Use |
| Channel 6 Read Multiplier | Not Currently In Use |
| Channel 7 UOM | Not Currently In Use |
| Channel 7 Read Multiplier | Not Currently In Use |
| Channel 8 UOM | Not Currently In Use |
| Channel 8 Read Multiplier | Not Currently In Use |
| Meter Status | "ON"/"OFF" |
| Location Number | Route and Sequence Number |
| Location Class | Master Code |
| Street Name | Street Name |
| City | City |
| State | State |
| Postal Code | Zip Code |
| Billing Cycle/Route | Route Number |
| Meter Install Date | Meter Installed Date From Meter Location |
| Meter Remove Date | Not Currently In Use |
| Latitude | Meter Latitude |
| Longitude | Meter Longitude |
| Alt.Meter Name | Not Currently In Use |
| Unit Number | Not Currently In Use |
| Street Prefix | Not Currently In Use |
| Street Suffix Direction | Not Currently In Use |
| Street Number | Street Number |
| Alt. Id | Account Number |
| Customer Id | Account Number |
| Customer Name | Name |
| Account Name | Name |
| Last Amt. Billed | "0" |
| Last Meter Read Date | Last Billed Reading Date |
| Service Start Date | Customer Start Date |
| Service End Date | Not Currently In Use |
| Relationship Start Date | Customer Start Date |
| Relationship End Date | Not Currently In Use |
| CTPT Active Date | Not Currently In Use |
| CTPT Inactive Date | Not Currently In Use |
| CTPT Multiplier | Not Currently In Use |
| Customer Phone Number | Customer Phone Number |
| Customer Email Address | Customer Email Address |
| Customer Billing Address | Customer Billing Address - will use the alternate billing address if it is active for the current date, if not it will use the mailing address in the customer table |
| Route Number | Route Number |
| Route Sequence | Route Sequence |
| Custom Field 6 | Not Currently In Use |
| Custom Field 7 | Not Currently In Use |
| Custom Field 8 | Not Currently In Use |
| Custom Field 9 | Not Currently In Use |
| Custom Field 10 | Not Currently In Use |
| Service Point ID | Used only for Export Type Analytics if 'Add Service point ID' is set in system file (this field is not seen in the front end in SmartFusion) |
Generic Layout:
| Name | Description |
|---|---|
| Meter Number | Meter Serial |
| SET Flow ID | Meter ERT Id |
| Billing Identifier | Account Number |
| Commodity Type | Service Code Read Type |
| Customer Name | Name |
| Street Name | Street Number and Name |
| City | City |
| State | State |
| Postal Code | Zip Code |
| Location Number | Route and Sequence Number |
| Billing Cycle Route | Route Number |
Reference.
Utility Billing System Settings
QA Test Plans For Utility Billing Hand Held
Tags
SmartFusionModule Handheld HandHeld