Service Point Fields

The billing data service point fields capture details such as the service point location, meter type, and any applicable parcel data.

Each table row represents a column in the data file. The header row of the data file must contain all table "Column Name" values, even if all values in those columns are blank. The columns must appear from left to right in the order in which they appear in the table and be separated by tab characters. See Legacy Billing Data File Specifications for more information.

Column Name	Description
service_point_id	Utility’s unique identifier for the service point. A service point identifies an unchanging device location where service is delivered. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_house_number	The house number portion of the street address. For example, 123 for 123 Main Street. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_street_name	Street name. If applicable in your service territory, this field should include predirection (beginning of string), street suffix, or postdirection (end of string) as appropriate. For example, W 24th St NE. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_unit	The unit number. For example, 2A for Apartment 2A. Note: This field is required for multi-unit premises. If possible, do not supply data such as “Third pole” that indicates where the meter is located. Type: STRING Can Be Empty?: Yes. Default: Null.
service_city	The city in which the service point is located. Do not include the state. For example, Richmond. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_state	The 2-character state code where the service point is located. For example, VA for Virginia. Type: STRING (2 characters) Can Be Empty?: No. Default: Not applicable.
service_zip_code	5-digit zip or 9-digits of zip+4. For example, 22209 or 22209-1234. Zip+4 is requested if available to help geocode service point addresses. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_premise	A named location, usually a building or collection of buildings with a common name. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
service_street_number	The house number portion of the street address excluding floor, apartment, flat, or suite number/indicator. For example, 123 for 123 Main Street.For example, 123 for 123 Main Street, Apartment A. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
service_street	Street name of the service address - includes predirection (left), street suffix, or postdirection (right) as appropriate. For example, 24th St West. Street name of the service address - includes street type and suffix as appropriate. For example, 24th St West. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_subpremise	Apartment, flat, or floor # of the service address. For example, Flat 2 or 5th Floor. Type: STRING Can Be Empty?: Yes. Default: Null.
service_locality	Post town / city / locality of the service address. Type: STRING Can Be Empty?: No. Default: Not applicable.
service_sublocality	Sublocality is required if the street name is not unique within the post town area. Include suburb in this field if it is a customary component of this address. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
service_admin_area_1	Include the county of the service point, if available. Abbreviated province for the service address. For example, NS. Abbreviated state or territory for the service address. Province or territory abbreviation of the service point. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
service_postal_code	5-7 character postcode. For example, M1 1AA, DN55 1PT of the service address. Six-character postal code for the service address. For example, B3J 2Y3. 4-digit numeric postal code. Type: STRING Can Be Empty?: No. Default: Not applicable.
meter_type	The fuel type reported by the meter. Allowed Values: E Electric G Gas W Water WW Waste water Type: STRING Can Be Empty?: Yes. Default: E
meter_units	The unit of energy used to represent usage values. Allowed Values: C Hundred cubic feet (CCF) G or GAL Gallons K or kWh Killowatt hours KV or KVAR Kilovolt-ampere reactive KVARH or KVH Kilovolt-ampere reactive hours KW Kilowatts L Liters M or MCF Thousand cubic feet M3 or 3 Cubic meters T or TH Therms Only one `meter_units` unit type can be supported for each `meter_type`. For example, the therm and M3 units cannot both be used for the gas `meter_type`. In addition, it is not possible to change the `meter_units` after one has been set at the creation of a service point, which is typically at the beginning of a program. For example, if a gas unit of therms is used at the beginning of the program, the gas unit cannot be changed to M3 later in the program. If you need support to address either of these restrictions, contact your Delivery Team. Type: STRING Can Be Empty?: Yes. Default: K
voltage_class	A grouping of commercial customers based on how they receive electricity. Determines what discounts are earned by a commercial customer. Allowed Values: PRIMARY SECONDARY TRANSMISSION Type: STRING Can Be Empty?: Yes. Default: Null.
latitude	Latitude of the service address, expressed as a decimal number of degrees between -90 and 90, no directional indicators. Any latitude data should be rooftop or better. If less specific than rooftop, leave as null (empty/blank). If no latitude value is available, leave this empty instead of supplying a value of 0. Type: NUMBER Can Be Empty?: Yes. Default: Null.
longitude	Longitude of the service address, expressed as a decimal number of degrees between -180 and 180, no directional indicators. Any longitude data should be rooftop or better. If less specific than rooftop, leave as null (empty/blank). If no longitude value is available, leave this empty instead of supplying a value of 0. Type: NUMBER Can Be Empty?: Yes. Default: Null.
dwelling_type	An indication of the type of dwelling in which a customer lives. Allowed Values: SING MULT CONDO DUPLEX TRIPLEX TOWNHOUSE MOBILE COOP QUADRUPLEX OTHER_RESIDENTIAL NON_RESIDENTIAL Type: STRING Can Be Empty?: Yes. Default: Null.
bldg_sq_foot	Square footage of the living area of the building. This generally does not include the garage, unfinished basement, or porch. This information is used to select neighbors or similar homes for the normative comparison. Type: NUMBER Can Be Empty?: Yes. Default: Null.
parcel_sq_foot	Square footage of the parcel lot. Type: NUMBER Can Be Empty?: Yes. Default: Null.
year_built	Year the structure was built. Type: NUMBER Can Be Empty?: Yes. Default: Null.
total_rooms	Total number of rooms in the structure. Type: NUMBER Can Be Empty?: Yes. Default: Null.
assess_value	Either the assessed value of the property, or a number or letter representing a range for the value. A blank field indicates that the assessed value is unknown. Type: NUMBER Can Be Empty?: Yes. Default: Null.
heat_type	The heat type used by the customer. Allowed Values: ELEC GAS NONE OTHER LPG OIL WOOD DISTRICT_HEATING GEOTHERMAL Null (blank) = unknown Type: STRING Can Be Empty?: Yes. Default: Null.
photovoltaic	A flag to indicate whether the customer generates photovoltaic or solar power. Allowed Values: 0 Customer does not generate photovoltaic / solar power. 1 Customer does generate photovoltaic / solar power. Blank It is unknown whether the customer generates photovoltaic / solar power. Type: NUMBER Can Be Empty?: Yes. Default: Null.
pool	A flag to indicate whether the customer has a pool. Allowed Values: 0 Customer does not have a pool. 1 Customer does have a pool. Blank It is unknown whether the customer has a pool. Type: NUMBER Can Be Empty?: Yes. Default: Null.
air_cond	A flag to indicate whether the customer has air conditioning. Allowed Values: 0 Customer does not have air conditioning. 1 Customer does have air conditioning. Blank It is unknown whether the customer has air conditioning. Type: NUMBER Can Be Empty?: Yes. Default: Null.
bedrooms	Number of bedrooms in the structure. This can be used in place of `bldg_sq_foot` to identify the size of a home for the purpose of selecting neighbors. Type: NUMBER Can Be Empty?: Yes. Default: Null.
amperage	The amperage value, expressed as a floating point number. For example, 1.24. Type: NUMBER Can Be Empty?: Yes. Default: Not applicable.