1. business and industrial
2. energy
3. natural gas

COLUMBIA GAS OF OHIO
CHOICE and SCO REFERENCE
MANUAL
April 2014
This manual is for information and educational purposes only. The tariff and other rules, regulations and laws prevail.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
1
Table of Contents
Section 1
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
2
Table of Contents
Section 1
Table of Contents
Outline
2
Section 2
General Program Information
Reference Materials
Credit Worthiness Requirements
General Supplier overview
Glossary of Terms
Acronyms
Revenue Class Codes
Ohio County Codes
5
Section 3
FTP Set-Up
Initial Access & Set-Up
Web Site Instructions
18
Section 4
General Choice Program Information
Choice Program Overview
Solicitation Customer List
Governmental Aggregation Customer List
Code of Conduct
Dispute Resolution
Contract Portability Election
24
Maintenance of Choice Accounts
Set-up and Maintenance of Choice Accounts
Timeline and Calendar
Reference Table Daily & Monthly files
Action Codes Definitions
Audit/Error Code Descriptions
ACC and ACF Files Format
ACT File Format
AC1 / AC2 and GAC2 Files Format
BIL File Format
CAC File Format
CDT File Format
CER File Format
CON File Format
CONF File Format
DAT File Format
DET File Format
DIS File Format
31
Section 5
April 2014
DMD File Format and Import
ERR/ ER2 and GER2 Files Format
Governmental Aggregation list format
NOP File Format
RAC1 File Format
RAC2 File Format
RATE File Format
Rate.DAT File Format
REC File Format
REM File Format
RERR File Forma t
REV File Format (RS5500MK & RS5600T3)
XFR File Format
Solicitation List format
Section 6
General SCO Program Information
SCO Customer Eligibility
SCO Customer and DSS Demand Allocations
101
Section 7
Maintenance of SCO Accounts
Set-up and Maintenance of SCO Account
SCO Timeline and Calendar
Reference Table Daily & Monthly files
Action Codes Definitions
Audit/Error Code Descriptions
AC1 /SAC1 and AC2/GAC2/SAC2 Files Format
ACT File Format
BIL File Format
DAT File Format
DET File Format
DIS File Format
DMD File Format and Import
ERR/ ER2/GER2 and SER2 Files Format
NOP File Format
OPT File Format
REC File Format
REM File Format
REV File Format (RS5500SK & RS5600T3)
SAD File Format
SCON File Format
104
Columbia Gas of Ohio Choice/SCO Reference
Manual
3
Table of Contents
Section 8
Capacity and Delivery Requirement
Pipeline Scheduling Point (PSP)
Capacity
Delivery Requirements
Balancing Services
Section 9
Customer Billing and Rates
Sales Tax Exemptions
Billing Options
Timeline for Choice Supplier Rate Codes
New Choice Rate Code Request
Choice Rate Change Request
SCO Supplier Rate Code
Section 10
Supplier Invoicing
174
Supplier Invoicing Timeline
Annual Reconciliation of Imbalances
Unbilled Term
Invoice Image
Annual Reconciliation of Imbalances Invoice Images
Section 11
Supplier Payment
Supplier Payment
182
Section 12
Aviator
Aviator Web Site
Accessing the GTS Bill Viewer
Concern Database
184
April 2014
154
167
Columbia Gas of Ohio Choice/SCO Reference
Manual
4
General Program Information
Section 2
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
5
Reference Materials for the COH Choice/SCO Programs
The information and instructions in this presentation are in keeping with the Rules and Regulations set forth in the
following two documents:
•
•
•
April 2014
Columbia Gas of Ohio Tariff
House Bill 9
SCO Program Outline
Columbia Gas of Ohio Choice/SCO Reference
Manual
6
Creditworthiness Requirements
A Supplier desiring to participate in Columbia’s Customer
Choice SM Program and Standard Choice Offer Program must
establish credit levels acceptable in accordance with Section
VII, Part 14 of the Columbia Gas of Ohio (COH) Tariff. The
Supplier will be required to provide the following information
as part of the credit evaluation process:
1. All Suppliers must complete and sign the
Company’s Retail Natural Gas Supplier Registration
Form to be considered for participation in the
Columbia Customer Choice Program and Standard
Choice Offer Program.
2. Its or its parent’s most recent independently audited
financial statements.
3. It and or its parent most recent annual report, 10K
or 10Q and current financial statements prepared
since the last audited report;
4. A minimum of three bank and trade references
5. A list of parent company affiliates and corporate
structure.
The evaluation will be based on standard credit factors such
as previous customer history, financial and credit ratings, trade
references, bank references, unused line of credit, financial
information and Supplier ‘s accounts receivable where
Columbia is provided a first secured interest.
April 2014
Based upon the number of standard credit factors met by the
Supplier, Columbia will assign a dollar credit level range for each
Supplier. Columbia will have sole discretion to determine
creditworthiness based on the listed criteria, but will not deny
creditworthiness without reasonable cause.
Columbia may at it’s option, require the use of any of the following
as a form of financial security:
1.
A guarantee of payment;
2.
An irrevocable Letter of Credit;
3.
A cash deposit;
4.
Or other mutually agreeable security or arrangement.
SCO suppliers are also required to provide COH with a cash
deposit, in the amount of $0.06 per Mcf multiplied by the initial
estimated annual delivery requirements for the SCO program year
of the tranches won by that SCO supplier. Any funds remaining at
the end of program year will be transferred to customers through
the Choice/SSO/SCO Reconciliation Rider (CSRR).
A fee of $50.00 will be assessed for each credit evaluation
performed. Columbia reserves the right to conduct additional
evaluations at any time during the course of the program.
The required information, along with a check for $50.00
made payable to “Columbia Gas of Ohio” should be sent
to:
Columbia Gas of Ohio
200 Civic Center Dr, Floor 7
Columbus, OH 43215
Columbia Gas of Ohio Choice/SCO Reference
Manual
7
General Supplier Overview
•
Suppliers must be licensed by the Public Utilities Commission of Ohio (PUCO) .
•
CHOICE Supplier agrees to execute the necessary agreements which include:






•
SCO Supplier agrees to execute the necessary agreements which include:


•
April 2014
Retail Natural Gas Registration Application
COH Accounts Receivable Purchase Agreement
COH Full Requirements Aggregation Service Agreement
COH Billing Option Agreement
Customer Information Agreement
Contract Portability Agreement
Retail Natural Gas Registration Application
COH Standard Choice Offer Supplier Agreement
Establish acceptable Creditworthiness prior to participating. Columbia reserves the right to check credit when
the need arises (See Creditworthiness Requirements).
Columbia Gas of Ohio Choice/SCO Reference
Manual
8
General Supplier Overview (continued)
•
CHOICE Supplier must meet a minimum of 100 customers or at least 10,000 Mcf annual throughput.
•
SCO Supplier customers will be assigned via the monthly SCO allocation process.
•
An aggregation pool is comprised of those customers within each Supplier’s customer group located within
the same Pipeline Scheduling Point.
•
Supplier will have an Aggregation Pool for each PSP. Customers are assigned to Aggregation Pools by their
service address zip code. To determine the PSP to zip code designation, Columbia will provide the zip code
to PSP Listing . Please refer to the Capacity and Delivery Requirement section for a list of PSPs.
•
Supplier is required to follow the Columbia Gas of Ohio Tariff and House Bill 9.
•
CHOICE Supplier must complete mandatory Choice Program Training.
•
SCO Supplier will be offered SCO Program Training.
•
Supplier must be able to communicate using Columbia’s Electronic Bulletin Board.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
9
Glossary of Terms
Balancing
•
Equalizing a shipper’s receipts of gas into a pipeline with withdrawals out of a pipeline system. Balancing
may be accomplished daily, monthly or seasonally, with penalties accessed for excessive transportation
imbalance.
BTU
•
Is an acronym which stands for British Thermal Unit . A British Thermal Unit, is the amount of heat required
to raise the temperature of one (1) pound of water from 60 degrees Fahrenheit to 61 degrees Fahrenheit at a
constant pressure of 14.73 psia.
Capacity
•
Total volume of gas that can flow through a pipeline over a given period of time, considering factors such as
pipeline diameter, pressure, and time interval.
Capacity Assignment
•
The ability to reassign interstate pipeline capacity to other entities on a non-discriminatory basis. A shipper
with excess capacity could relinquish space back to the pipeline for it to resell.
CHOICE Supplier
•
A Retail Natural Gas Supplier serving customer under the Columbia’s Customer Choice SM Program.
Daily Scheduled Quantities
•
Volumes of transported gas (Dth/Day) to be delivered by interstate pipeline at Shipper’s direction for
Shipper’s account, after retainage of interstate pipeline’s company use and unaccounted for volumes.
DSS
•
Shall mean a Commission regulated “Default Sales Service” provided by Columbia to Transition Customer.
Those customers not eligible to participate in the Choice program or Governmental Aggregation Program
and PIPP customers.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
10
Glossary of Terms
Firm Service
•
The highest quality sales or transmission service offered to customers under a filed rate schedule which
anticipates no planned interruption.
FTS
•
Firm Transportation Service from Columbia Gas Transmission Corporation.
Human Needs
•
A term used in curtailment plans to describe those customers relying upon natural gas for heat for the
protection of life: residences, nursing homes, hospitals, hotels, etc.
Imbalance
•
The difference between the Scheduled Quantities and the Actual Tendered Quantity.
Local Gas Purchase Price
•
The TCO Monthly Index plus a fixed dollar amount , which is determined annually.
Local Gas Purchas Requirement
•
A volume of gas that CHOICE/SCO Suppliers shall purchase from Columbia monthly. Which shall equal to
an estimate of the Columbia purchases of Ohio Production.
NYMEX
•
Is an acronym which stands for New York Mercantile Exchange.
Peak Day
•
The highest usage day during the winter season; a 24 hour period of delivery greater than any other day.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
11
Glossary of Terms (continued)
POR
•
Purchase of Receivables is an agreement between the Supplier and Columbia whereby Columbia purchases
at 100% of the Supplier’s gas cost that is billed to the customer when the combined billing option has been
chosen in the execution of the COH Choice Full Requirements Aggregation Agreement.
PSP/Pipeline Scheduling Point
•
The single delivery point or set of delivery points grouped or designed by an upstream pipeline for purposes
of scheduling gas supplies for delivery by such upstream pipeline; or the single delivery point or set of
delivery points grouped or designed by Columbia for operational purposes. The PSPs of Columbia Gas
Transmission, LLC shall be utilized by Columbia for the purpose of developing Demand Cuvees
Retail Price Adjustment
•
The rate per Mcf an auction bidder offers in addition the NYMEX closing price to devise the Retail sales
price for SCO/DSS commodity services.
SCO/DSS Price
•
Shall equal the Retail Price Adjustment plus Market Price (Market price equals monthly NYMEX closing
price).
SCO Service
•
A commodity service available to Choice eligible customers that have not elected a CHOICE Retail Natural
Gas Supplier and are not served through Governmental Aggregation Program .
SCO Supplier
•
A winning SCO Auction bidder that has received both the right and obligation to provide natural gas
commodity for a specified list of CHOICE eligible customers that have not elected a CHOICE Retail Natural
Gas Supplier and are not served through Governmental Aggregation Programs plus their proportionate
share of DSS customer requirements.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
12
Glossary of Terms (continued)
Storage or Storage Capacity
•
Typically, depleted gas wells used to store gas which has been transferred from its original location. Shall
mean TCO FSS and Related SST and /or Panhandle Pipeline FS and Related EFT.
Summer Season
•
That part of a contract year from the beginning of April through the end of October.
System-Wide Retention Factor
•
A percentage representing Columbia’s system average lost and unaccounted for volumes and company use
gas.
Supplier
•
Retail Natural Gas Supplier.
TCO Monthly Index
•
The price as reported in Platts Inside FERC’s Gas Market Report for the month of purchase, in the monthly
report titled “Pricing of spot gas delivered to pipelines,’ under the column heading “Index” for “Columbia Gas,
Appalachia”.
Transition Customers
•
Those customers eligible to participate in the Choice Program or Governmental Aggregation programs not
enrolled in either program or assigned to an SCO Supplier at the commencement of the billing month.
Winter Season
•
That part of a contract year from the beginning of November through the end of the following March.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
13
Acronyms
BCF
CCF
COH
CSD
DIS
DSS
DTH
FSS
FT
FT-1
FTP
FTS
GAS/GMB
GTS
HDD
LIFO
MCF
MDQ
MDSQ
MMCF
NCGT
OCC
PSIA
PSP
PUCO
SCO
SCQ
SST
TCO
April 2014
One Billion Cubic Feet
One Hundred Cubic Feet
Columbia Gas of Ohio
Commissions Consumer Services Department
Distributive Information System -low pressure accounts billed in the same month
Default Sales Service
Dekatherm (Ten Therms, One Million Btu’s)
Firm Storage Service
Firm Transportation
Firm Transportation – 1
File Transfer Protocol
Firm Transportation Service
Gas Measurement Billing – high pressure accounts billed on a one month lag
Gas Transportation Service
Heating Degree Day
Last In First Out
One Thousand Cubic Feet
Maximum Daily Quantity
Maximum Daily Storage Quantity
One Million Cubic Feet
North Coast Gas Transmission, LLC
Ohio Consumer Council
Pounds per Square Inch Absolute
Pipeline Scheduling Point
Public Utilities Commission of Ohio
Standard Choice Offer
Storage Contract Quantity
Storage Service Transportation
Columbia Gas Transmission Corporation
Columbia Gas of Ohio Choice/SCO Reference
Manual
14
Revenue Class Codes
CODE
00
01
03
TYPE
RES
N/A
RES
DESCRIPTION
RESIDENTIAL NON-HEAT
DEFAULT VALUE-DO NOT USE
CHOICE RES – HEAT
04
05
COM
RES
CHOICE COMM - HEAT
CHOICE RES - NON-HEAT LP
63
64
IND
IND
06
IND
CHOICE IND - ALL
65
IND
07
IND
CHOICE IND - A/C
66
IND
08
09
COM
RES
CHOICE COMM - NON-HEAT
CHOICE RES - A/C
67
70
IND
RES
10
RES
CHOICE RES – HEAT and A/C
71
COM
11
12
COM
COM
COMMERCIAL NON-HEAT
CHOICE COMM - A/C
77
78
COM
COM
13
14
15
30
31
41
53
COM
COM
COM
RES
COM
COM
COM
CHOICE COMM – HEAT and A/C
CHOICE COMM - NGV
CHOICE COMM - INTRASTATE
RESIDENTIAL HEAT
COMMERCIAL NGV
COMMERCIAL HEAT
INTRASTATE UTILITY SERVICE
79
COM
April 2014
CODE
60
61
62
Columbia Gas of Ohio Choice/SCO Reference
Manual
TYPE
RES
COM
IND
DESCRIPTION
RESIDENTIAL A/C
COMMERCIAL A/C
ELEC POWER
GENERATION
INDUSTRIAL
INDUSTRIAL
DISTRIB - LP
INDUSTRIAL
TRANSMISSION
INDUSTRIAL
DISTRIB-OTHER
INDUSTRIAL A/C
RESIDENTIAL
HEAT AND A/C
COMMERCIAL
HEAT AND
OTHER SALES
MUTUAL
ASSOCIATION
FIELD SALES
15
Ohio County Codes
County Name
Code
County Name
Code
ADAMS
ALLEN
ASHLAND
ASHTABULA
ATHENS
AUGLAIZE
BELMONT
BROWN
BUTLER
CARROLL
CHAMPAIGN
CLARK
CLERMONT
CLINTON
COLUMBIANA
COSHOCTON
CRAWFORD
CUYAHOGA
DARKE
DEFIANCE
DELAWARE
ERIE
FAIRFIELD
FAYETTE
FRANKLIN
FULTON
001
003
005
007
009
011
013
015
017
019
021
023
025
027
029
031
033
035
037
039
041
043
045
047
049
051
GALLIA
GEAUGA
GREENE
GUERNSEY
HAMILTON
HANCOCK
HARDIN
HARRISON
HENRY
HIGHLAND
HOCKING
HOLMES
HURON
JACKSON
JEFFERSON
KNOX
LAKE
LAWRENCE
LICKING
LOGAN
LORAIN
LUCAS
MADISON
MAHONING
MARION
MEDINA
053
055
057
059
061
063
065
067
069
071
073
075
077
079
081
083
085
087
089
091
093
095
097
099
101
103
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
16
Ohio County Codes (continued)
County Name
Code
County Name
Code
MEIGS
MERCER
MIAMI
MONROE
MONTGOMERY
MORGAN
MORROW
MUSKINGUM
NOBLE
OTTAWA
PAULDING
PERRY
PICKAWAY
PIKE
PORTAGE
PREBLE
PUTNAM
RICHLAND
ROSS
SANDUSKY
SCIOTO
SENECA
SHELBY
STARK
SUMMIT
TRUMBULL
105
107
109
111
113
115
117
119
121
123
125
127
129
131
133
135
137
139
141
143
145
147
149
151
153
155
TUSCARAWAS
UNION
VAN WERT
VINTON
WARREN
WASHINGTON
WAYNE
WILLIAMS
WOOD
WYANDOT
157
159
161
163
165
167
169
171
173
175
ALL COUNTIES
999
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
17
FTP Set-Up
Section 3
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
18
Initial Access and Set-Up
If you do not have access to the Columbia Suppliers Choice 
website, http://www.columbiasuppliers.com/
follow the instructions provided below:
April 2014
•
A Columbia Gas representative will be assigned to you
and provide additional information regarding the
Supplier code assignment, user ID and password .
•
Once you have been provided your Supplier log in
information (User ID and Password ), review the
following pages for “Web Site Instructions “and
“Maintenance of Choice and /or SCO Accounts
Columbia Gas of Ohio Choice/SCO Reference
Manual
19
Web Site Instructions
Welcome to the Columbia Supplier
website. Beginning on this page we will
show you how to navigate this site to
learn more about Columbia’s Customer
Choice program.
Select Columbia Gas of Ohio
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
20
Web Site Instructions (continued)
.
This is the landing page for Choice and TS
Programs, as well as Auction information. Any
new developments, reminders, technical
problems, etc will be posted here. Columbia
suggests to check this page daily.
•
Members:
•
Logon into File Exchange by entering
your user ID and password in their
respective boxes. Both fields are
case sensitive. Access to Aviator is
available on all pages.
•
Click on the Submit button
Additional Menu Items
•
Meter Reading Schedules – meter
reading dates for Columbia’s billing
cycles, Unit 1-21
•
Tariff
•
Rate Information – 2 years
•
Zip code Listing for PSP’s
•
Need Help?
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
21
Web Site Instructions (continued)
.
Select Choice for additional information
regarding the Choice Program.
•
Links include:
•
Become a Supplier
•
Policy & Procedures
•
Find a Form
•
Customer List
•
Customer Concern Database
•
Weather Data
•
Frequently Asked Questions
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
22
Web Site Instructions (continued)
.
Select Auctions for additional information
regarding the Standard Choice Offer.
•
Links include:
•
Program Outline
•
PUCO Filings
•
Auction Information
•
General Information
•
Agreements & Forms
•
Reports and Statistics
•
Exhibits & Examples
•
Weather Data
•
Frequently Asked Questions
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
23
General Choice Program Information
Section 4
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
24
Choice Program Overview
Eligibility
Customers using less than 6,000 Mcf a year or are human needs are eligible for Choice.
Enrollment
Electronically through the COH Web FTP site. Customers can sign a consent form, enroll via the
Internet or be enrolled telephonically through recorded voice verification. COH does not require a
copy of the customer contract between the Supplier and the customer.
Gas Deliveries
Required to use Aviator to nominate on COH system.
Follow Demand and Supply Curves as specified in the COH Tariff.
Make deliveries by using Pipeline Scheduling Point.
Firm Transportation is required.
Capacity Storage and Balancing Fees.
Supplier Aggregation pools are required.
Rate Schedules
FRSGTS – Full Requirements Small General Transportation Service
FRGTS – Full Requirements General Transportation Service
FRLGTS – Full Requirements Large Transportation Service
FRCTS – Full Requirements Cooperative Transportation Service
Billing
Customers are billed nightly. Suppliers are billed after all the meters have been read or calculated for
the billing cycle and nominations have been confirmed, approximately the 6th working day of the
month.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
25
Solicitation Customer List
Columbia Gas will provide, upon written request, an eligible Customer List by specific zip codes or for the entire
Columbia service territory (State) to Certified Natural Gas Suppliers via electronic means. The Customer Lists are
prepared using real time data on a best efforts basis.
Steps to request a Solicitation List:
• Supplier must execute the four page Customer Information Agreement
• Using Word or Notepad, in the .DAT file format, the supplier must provide the zip codes and
send the request electronically to their Analyst (applicable only when ordering by specific zips).
• Supplier doesn’t need to provide zip codes when requesting a list for the entire State.
Format: XXX12345 = the supplier’s 3 digit Supplier code + the five digit zip code
• Costs are $0.07 per record for the first list released per year and $0.02 per record for up to three quarterly
lists thereafter.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
26
Governmental Aggregation Customer List
Steps to request a Governmental Aggregation Customer List (COH):
• The Governmental Aggregator (GA) must execute the four page Customer Information
Agreement.
• Using Word or Notepad, in the .DAT file format, the GA must provide the 9 digit zip codes (includes +4)
and send the request electronically to their Analyst.
Format: XXX123451111 = the supplier’s 3 digit Supplier code + the nine digit zip code
• Costs are $0.07 per record for the first list released per year and $0.02 per record for up to three quarterly
lists thereafter.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
27
Code of Conduct
Supplier or Governmental Aggregator participating in Columbia’s Customer Choice SM
Program shall:
•
Conduct its competitive retail natural gas service activities consistent with the Commissions Minimum
Standards for Competitive Retail Natural Gas Services.
•
Supplier’s failure to comply with the Company’s Tariff and/or Commission rule requirements may be
deemed to be in material default which may be grounds for the Company to request suspension or
termination.
•
Deliver gas to Company on a firm basis.
•
Must undergo a credit evaluation, at Retail Natural Gas Supplier’s expense.
NOTE: Suppliers or Governmental Aggregators should review House Bill 9 Rules for full Code of
Conduct rules.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
28
Dispute Resolution Tariff – Rules and Regulations
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
29
Dispute Resolution Tariff – Rules and Regulations (continued)
•
The Supplier is responsible for resolving disputes with customer.
•
The Customer’s contract is between the customer and the approved participating Choice Supplier.
•
It is the Supplier's’s responsibility to manage the contractual relationship with the customer.
•
COH only recognizes the approved Choice Supplier. Third parties are not recognized on our system.
•
Notify the customer, not less than sixty (60) days and no more than ninety (90) days, prior to the expiration
of a contract, of their right to renew, terminate or renegotiate a contract that will automatically renew.
•
All Choice contracts must be approved by the PUCO prior to implementation.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
30
Contract Portability Election
Contract Portability is an optional service that allows a Customer to transfer an existing CHOICE contract from one
address to another within Columbia’s service territory.
•
A Supplier must execute a Contract Portability Election agreement to make this service available to its CHOICE
customers.
•
Customer(s) must elect the Contract Portability service during the request for transfer of billing, and must be an active
CHOICE customer at the time of the request.
•
CHOICE contract(s) may temporarily overlap between premises as a result of the transfer of service.
•
Columbia will provide the Supplier old and new account information through an electronic data file (see XFR File
Format).
•
The Supplier agrees to serve all active CHOICE customers within Columbia’s service territory, which includes those
customers residing in all of Columbia’s Pipeline Scheduling Points.
•
Customers enrolled in Governmental Aggregation contracts are excluded.
•
Upon written notice, Supplier may modify their Contract Portability election once a year in February, to be effective
with the April customer billing cycle.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
31
Maintenance of Choice Accounts
Section 5
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
32
Set-up and Maintenance of Choice  Accounts
This section describes how to set-up and maintain your Choice  account information and send it to
Columbia.
The .DAT file is used by Suppliers for setting up, changing, or deleting accounts from their Choice 
Aggregation Group.
Using any text editor software available, such as WordPad or NotePad, create a file by entering the account
information in the .DAT file format provided.
The file must be saved as XXX.DAT. The XXX is the 3-digit Supplier code assigned by Columbia Gas.
When you have entered your account information, upload the file onto the Internet by the daily deadline
shown on the timeline/deadline calendar (5:00 p.m. EST).
A copy of a .DAT file must always remain in your directory. DO NOT delete the .DAT file from the web site.
The timeline/calendar included with these instructions gives an illustration of the different time restrictions
involved with your .DAT file.
On the deadline indicated in timeline/calendar (15th of the month), the file will be “frozen” with any
enrollments, drops and/or deleted accounts that you have added. (If the 15th of the month falls on a
weekend or holiday, the previous business day is the deadline).
The .DAT file will be cleared of Action Codes 1,2,3,4, & D the day following the freeze.
New accounts, for the next processing cycle, should be added after the date specified on the timeline. A
new .DAT file can be started on the 16th - however, no processing of files for enrollments, drops, and/or
deleted accounts will begin until the 20th of the month, or the next business day after if the 20th falls on a
holiday or weekend. Beginning January 30, 2013 (Unit 1 billing for February 2013) Action code 5 for rate
code changes will be processed during the freeze. Rate code changes will be effective immediately.
SPECIAL NOTE: DO NOT USE ANY WORD PROCESSING SOFTWARE TO ENTER OR CHANGE
ACCOUNTS, USE THE RECOMMENDED TEXT EDITOR SOFTWARE, WORDPAD OR NOTEPAD.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
33
Transition From Monthly to Daily Processing: “Action Code 5” Transactions
Through January 2013 billing, Changing a customer ‘s rate code (Action Code 5)will be processed monthly
following the same timeline as Action Codes 1,2,3,4,8, & 9 (enrollments/drops/deletes/change to sales tax
exemption%)
Beginning February 2013 billing, Changing a customer’s rate code (Action Code 5) will be processed daily.
The customers rate code change will be effective immediately with this daily process (There will be no freeze
period from the 16th – 19th calendar days for Action Code 5). Changes for February 2013 can be submitted
using both monthly and daily processes. However, March 2013 billing forward, only the daily process can be
used.
Dec 20th 2012 – Jan 15th 2013 : Action Code 5 can be submitted for February 2013 billing (monthly process)
Jan 30th - Feb 27th : Action Code 5 can be submitted for February 2013 billing (daily process)
Feb 28th - Mar 28th : Action Code 5 can be submitted for March 2013 billing (daily process)
Note: Any Action Code 5’s submitted from Jan 20th – Jan 29th will not be processed.
Suppliers can track when a customer will bill based on their billing unit. Active Suppliers as of January 2013
will receive a file of their active customers and billing units. Going forward Suppliers can find a customer’s
billing unit in the AC1 and BIL file. The meter read dates for each unit can be found on
http://www.columbiasuppliers.com A customer must bill at least one time before an Action Code 5 can be
submitted.
Example: Customer A is billing unit 4. Supplier would need to submit a rate code change between Feb 5, 2013
and Mar 5, 2013 to be effective for March 2012 billing. (The Action Code 5 can be submitted the same day as
the customer will bill. Action Code 5 processes before billing each day. )
The timeline on the following slide also illustrates the transition from Action Code 5 being processed monthly
to daily.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
34
COH Timeline by Calendar Day
Date Period:
What to do/what to look for:
45 days prior to gas flow
Submit request for new rate code(s) to be established
(Example: Submit new rate code request by 5/15 for 7/1 flow)
1st business day
Preliminary Accounting and Tax information for previous month (.DET file)
New Rate Codes request due for next month’s flow
RS5500 (XXXMK.REV) and RS6500 (XXXTX.REV) placed on FTP by COH for the previous month receivables
2nd business day
. RATE file available providing a summary of current rate code values
1st thru 15th calendar days
Enter accounts, edit .DAT file and check returned files
1st thru 20th calendar days
Enter rate code price changes in XXXRATE.DAT and check returned files
6th business day
Supplier is billed for previous months customer’s consumption
15th calendar day
Final Enrollments, Drops, and Changes to sales tax exemption% (Action Codes 1,2,3,4,8,9) due in XXX.DAT file for next month’s flow
16th thru 19th calendar days
Only Action Code 5 will be processed in the .DAT file
DAT file emptied of Enrollment/Drops for next processing cycle
XXX RATE.DAT files continue to be processed daily
20th calendar day
Demand and Supply Curves posted
Rate Code price changes (both automated via XXX.RATE.DAT and manual via fax) due to Columbia Gas
Start entering Enrollments, Drops, and Changes to sales tax exemption% (Action Codes 1,2,3,4,8,9) for next Choice processing cycle
21st thru 25th calendar days
Upload XXX.DAT file and check returned files
Start entering rate changes (XXXRATE.DAT) for next billing cycle
Payment made to Choice Suppliers by the 25th of the month for previous month’s receivables.
GER2 and GAC2 files are uploaded to Natural Gas Suppliers
26th thru end of month
Upload XXX.DAT file and check returned files
Frozen .DAT file (from the 15th) and the daily .RAC1 data gets uploaded into COH billing system and re-audited
Accounts are processed in COH billing system
AC2, .ER2 , .RAC2 and .ACF (if purchased) files are uploaded to Suppliers
--------------------------------------------------------------------------------------------------------------------------------TIME PERIOD
By 5:00 PM each business day
By noon each business day
DAILY
Upload .DAT and XXXRATE.DAT files (except on non-processing dates)
Returned files available (except on non-processing dates)
NOTES: If the 15th falls on a weekend or holiday, enrollments/drops for the following billing period ( .DAT file) is due the previous business day.
ALL DATES AND TIMES ARE SUBJECT TO CHANGE.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
35
COH Timeline By File Type
File Description
File Name
Timeline
Accepted File (enroll/drop)
AC1, ACC
Daily 20th – 15th (ACC only if purchased)
Final Accepted File
AC2, ACF
Monthly after unit 21 (ACF only if purchased)
Active Customer File
ACT
Monthly after unit 21 (only if purchased)
Daily Customer Bill File
BIL
Daily
Change Accept
CAC
Daily
Customer Count File
CDT
by the 20th
Change Error
ERC
Daily
Confirmation File
CONF
Daily
Consumption File
CON
Daily 20th – 15th (if Action Code 3 or 4 has
been submitted)
Detail File
DET
1st business day (info is for previous month)
Disconnect File
DIS
Daily
Demand Curve
DMD
by the 20th
Error File
ERR
Daily 20th – 15th
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
36
COH Choice Timeline By File Type (cont.)
File Description
File Name
Timeline
Final Error File
ER2
Monthly after unit 21
Final Accept for GMB
customers
GAC2
Monthly (typically between 16th to 20th )
Final Error for GMB
customers
GER2
Monthly (typically between 16th to 20th )
Notice of Pending Term
NOP
Daily
Supplier Rate Code Change
RAC1
Daily
Final Rate Code Change
RAC2
Monthly on the 20th
Revenue File
MK.REV, TX.REV
1st business day (info is for previous month)
Rate Code Values
RATE
2nd business day
Rate Code Errors
RERR
Daily
Rescind File
REC
Daily
Remove File
REM
Daily
Transfer of CHOICE Contract
for existing customers
XFR
Daily
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
37
Reference Table/Daily and Monthly Files
Daily Files:
Monthly Files:
•
AC1 – Provides the accounts preliminarily accepted from the XXX.DAT file
uploaded the previous business day
•
AC2 – File showing accounts that will flow gas the 1st of the month
•
•
ACC – Daily accepted file containing supplemental information regarding
accounts (preliminary accepted file)
ACF – End of month accepted file containing supplemental information
regarding accounts (additional fee applicable)
•
•
BIL – File providing the meter reading and adjustment information billed by the
Columbia billing system. File may be produced daily if Supplier has accounts
in each billing cycle
ACT -This file will provide all the established accounts for a Supplier as
of the date of the last .AC2 file (additional fee)
•
CDT – File containing the customer count information for the LIK
adjustment on the .DMD file
•
DET – Providing preliminary accounting and tax information
•
CON – File with 24 months customer’s consumption requested from the
XXX.DAT file
DMD – File containing required nomination information for the current
group of active customers
•
ER2 st
– Final error file showing errors and accounts that will not flow gas
the 1 of the month
CONF – Confirmation file which is a record of the transactions received each
day as submitted through the .DAT file
•
GAC2 –File showing the GAS/GMB accounts that will flow gas the 1st of
the month.
•
ERC - Errors for rate code changes (Action Code 5) that occurred from the
XXX.DAT file uploaded the previous business day
•
GER2 – Final error file showing errors
and accounts for GAS/GMB
accounts that will not flow gas the 1st of the month
•
DAT – File for enrolling, removing or changing accounts
•
RAC2 - File that shows rate code changes that will be used for billing
customers starting with unit 1 of the effective month.
•
DIS – Provides the Supplier with disconnected accounts (inactive/finaled with
Columbia Gas)
•
•
ERR – Errors that occurred from the XXX.DAT file uploaded the previous
business day
RATE – File provides active rate codes and the associated
price value per unit of measure for each billing cycle. This
Report is available the 2nd business day of each month.
•
NOP – File that shows accounts that have received a pending termination
notice for non-payment or non-access to their meters
•
REV – File provides the Supplier’s prior month billed revenues,
payment details and tax information where applicable.
•
RAC1 - Provides rate code changes preliminarily accepted from the
XXXRATE.DAT file uploaded the previous business day
•
RATE.DAT – File for submitting rate code changes for existing rate codes
•
•
•
•
•
CAC - Provides the accounts accepted for a rate code change (Action Code 5)
from the XXX.DAT uploaded the previous business day (Changing a customer’s
rate code is effective immediately so this is the final accept file.)
NOTE:
•
The .ACC file is a preliminary list of accounts that are accepted for
Choice. There is no charge for this file.
•
The .ACF file will contain the final list of accounts accepted for Choice.
The charge for this file is $20.00 plus .10 per record.
RERR - Errors that occurred from the XXXRATE.DAT file uploaded the previous
business day
•
The .ACT file lists all active accounts as of the AC2 files. There is a
minimum charge of $55.00 or .015 per record.
REC – Accounts that have rescinded their pending enrollment with the natural
gas supplier within the allowable 7-business day rescission period
•
REM – Provides accounts that will be removed from Supplier’s customer data
base as a result of the customer’s election of another natural gas supplier,
including the LDC
•
XFR – Provides information for customers who have elected to transfer their
existing CHOICE contract to their new service address within Columbia’s
service territory.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
38
Action Code Definitions
The following characters are to be used in the first column in the FTP site:
1
Indicates that an account is to be enrolled as a Choice account
2
Indicates that an account should be removed from the Choice program. The account
must have already billed as a Choice account. This code is used whenever you want to
remove an account that has already billed at least once as your customer
3
Indicates that an account should be enrolled as a Choice account and 24 months of the
account’s consumption history is to be sent back to the Supplier in the .CON file
4
Indicates that 24 months of an established Choice account’s consumption history is to be
sent back to the Supplier in the .CON file (must be a customer of the requesting
Supplier)
5
Indicates that a change should be made to the customer’s rate code (Effective 1/30/13,
Action Code 5 will be processed daily.)
8
Indicates that a tax exemption percentage should be added or changed to an existing or
pending Choice account
9
Indicates that a tax exemption percentage should be removed from an existing or
pending Choice account
D
Indicates that a pending account should be deleted from the .DAT file. DO NOT
PHYSICALLY delete the account from the .DAT file. This code is used to delete an
account that was submitted and accepted during the current enrollment period
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
39
Audit/Error Codes and Descriptions
0001 ACCOUNT NOT ON DIS
•
Account not in DIS database - Re-verify
customer account number.
0010 INVALID RECORD ON FILE
0002 CHECK DIGIT IN ERROR
•
Check digit submitted does not agree with
check digit on DIS database - re-verify
customer account number’s check digit.
0011 INVALID COMM/IND-NOT USED
0003 ACCOUNT NOT AN ACTIVE ACCOUNT
•
Account is not an active account - re-verify
account number.
0004 NOT USED
•
0012 INVALID RES-NOT USED
0013 INVALID HUMAN NEEDS ACCOUNT
•
0005 NOT USED
0006 MARK CD INV - DIS
•
Supplier code is not in the DIS tables.
0007 INVALID REVENUE CLASS SELECTED
•
Revenue class must be 00, 11, 30, 41, 60, 61,
62, 63, 64, 65, 66, 67, 70, 71.
0008 NOT COMPANY 34
•
Account or Supplier Rate Code is not valid in
Ohio.
0009 DUPLICATE ACCOUNT ADD DIFF
•
Account added was transmitted by more than
one Supplier - re-verify account number and
status with customer. Potentially a competitive
situation or a data entry error may have
occurred.
April 2014
Could not process record, invalid format.
Account is a commercial account with
consumption greater than the annual limit
and not identified as a Human Needs
account. (If more than one meter involved,
check that both are coded Human Needs).
0014 INVALID – GTS ACCOUNT
•
Rate schedule number is a GTS rate
schedule -'1011', '1021', '874' - account is
already transporting on the Traditional
GTS Program.
0015 CANNOT BE REMOVED FROM PROGRAM
•
Either the account is not set up as
Columbia Choice  account or the
Supplier cannot remove the account from
the program because it was set up with a
different Supplier code.
Columbia Gas of Ohio Choice/SCO Reference
Manual
40
Audit/Error Codes and Descriptions (continued)
0016 ACCT IS ACTIVE PIP
•
Account is an active PIPP account.
0017 DUPLICATE ACCT ADD/REMOVE BY SAME
SUPPLIER
•
Duplicate account adds or deletes were
transmitted from the same Supplier. Check the
.DAT file and delete (using a ‘D’ action code)
one of the entries.
0018 ACCT NOT ACTIVE Choice CANNOT CHANGE
•
Action code ‘5’ was submitted but the account
cannot be changed because the account
belongs to another Supplier or has been
removed from the program.
0019 ALREADY SET UP
•
This account is already set up as a Choice 
account by another Supplier or the Supplier
making the request. If the account is set up by
the Supplier making the request, then the
additional message for Supplier XXX01 will be
displayed. XXX will be the three-character
Supplier code and the 01 will be the
appropriate billing code.
0020 CANNOT REQUEST CONSUMPTION
•
Consumption cannot be provided because the
Supplier requesting the account s consumption
does not have this account as a Choice 
customer.
0022 NO MATCH - PSP
•
PSP does not agree with PSP on table used in
conjunction with Supplier Code and Nomination
Group Number to get a valid PSP.
0023 NOM GROUP NUMBER INVALID
•
Nomination Group Number supplied by Supplier
is invalid or not on tables used to get a valid
PSP.
0024 60 DAYS ARREARS >0
•
The account is not on an ‘active payment plan’
or ‘active budget’ and the ‘tariff only’ arrears are
60-days in arrears.
0025 PAYPLAN ARREARS >0
•
The account is on an ‘active payment plan’ and
the account is in arrears for the payment plan.
0026 BUDGET ARREARS >0
•
The account is an ‘active’ budget and the
account is in arrears for the budget plan.
0027 CONTRACT NUMBER INVALID
•
The contract number is not in the GTS tables.
0028 CANNOT BE CHANGED, REMOVE FOUND
•
Account cannot be changed because a removal
was previously transmitted in the .DAT file.
Check the .DAT file and delete (using a ‘D’
action code) the removal and then submit the
change.
0021 ZIP NOT FOUND FOR
•
Zip code not found on table using the PSP
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
41
Audit/Error Codes and Descriptions (continued)
0029 SUPPLIER RATE CODE EXPIRED or
SUPPLIER CODE NOT EFFECTIVE
•
Supplier rate code is expired or has not been
established in Columbia’s system.
0030 NOT USED
0031 NOT USED
0037 PENDING TRANS PREV ENROLL PERIOD
•
The account has a pending add transaction (‘1’ or
‘ 3’ action code) for the previous enrollment
period that must final (accepted in .AC2) before
an add for the current enrollment period can be
processed; this transaction should be resubmitted
after .AC2s for the previous enrollment period are
posted.
0032 ACCOUNT NOT FOUND OR CANNOT UPDATE
•
The account cannot be found in DIS and
cannot be updated – re-verify account
number.
0038 CANNOT CHANGE TAX EXEMPT STATUS
•
Tax exemption status cannot be added or
changed because the supplier requesting the
change does not currently serve this account as a
Choice customer and does not have a pending
add transaction.
0035 RESCISSION FOUND FOR ACCOUNT/RATE
CODE
•
The account is being submitted on the same
rate code the customer previously rescinded
in the same enrollment period; account must
be submitted on a different rate code if for
the same enrollment period.
0039 INVALID TAX % OR MISSING ‘E’ INDICATOR
•
Tax exempt percentage field must be entered as
a three digit number (number entered was <000
or >100) or transaction with ‘8’ or ‘9’ action code
is missing ‘E’ in tax exempt indicator
0036 INVALID DELETE, NO PENDING
TRANSACTIONS
•
A delete transaction (‘D’ action code) was
submitted and there are no pending
transactions for the current enrollment
period.
April 2014
0041 ACCOUNT NOT ELIGIBLE FOR CHOICE
•
Account has been finaled.
Columbia Gas of Ohio Choice/SCO Reference
Manual
42
Audit/Error Codes and Descriptions (continued)
0042 INVALID DOLLAR VALUE FORMAT
•
Mcf dollar value submitted is not in the
required format (XX.XXXX) or is a negative
value.
0043 INVALID SUPPLIER RATE CODE - BILLING
•
Supplier bills gas costs
0098 MKTR TYPE CODE -N- REQUIRES + OR •
NYMEX Rate submitted without Plus or
Minus.
0099 MARKETER TYPE CODES ARE NOT EQUAL
•
Price value and/or option does not match
Supplier Rate Code established in
Columbia’s system.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
43
.ACC and .ACF Files
Both files provide the accounts that were
accepted and additional customer
information from the .DAT file uploaded the
previous business day.
These files include supplemental information
about the customers that can be used when
building a customer database.
The XXXMMDDY.ACC/. ACF files, where
XXX reflects the Supplier and State, MM
reflects the month, DD reflects the day, and
the Y reflects the last digit of the year the
record is created
April 2014
The .ACC files provides the accounts that
were accepted from the DAT file uploaded on
the previous business day.
The .ACF file will provide a final number of
records accepted for the current month’s flow
and will be created on the date specified in
the timeline/calendar.
NOTE:
The .ACC file is a preliminary list of accounts
that are accepted for Choice .
The .ACF file will contain the final list of
accounts accepted for Choice . The charge
for this file is $20.00 plus .10 per record.
Columbia Gas of Ohio Choice/SCO Reference
Manual
44
.ACC and .ACF File Formats (continued)
Column 1:
•
Action Code
Columns 71-110:
•
Description
Columns 2-6:
•
Supplier Number
Columns 111-112:
•
Revenue Class Old
Columns 7-39:
•
Supplier Name
Columns 113-114:
•
Revenue Class New
Columns 40-47:
•
Customer PCID Number
Columns 115-126:
•
Customer First Name
Columns 48-50:
•
Customer Sequence Number
Column 51:
•
Customer Check Digit Number
Columns 52-60:
•
Customer PSID Number
Columns 61-66:
•
Effective Date (YYYYMM)
Columns 67-70:
•
Filler (zeros)
April 2014
Column 127:
•
Customer Middle Initial
Columns 128-147:
•
Customer Last Name
Columns 148-180:
•
Service Address
Columns 181-219:
•
Service Address, City, State, Zip+4,
Carrier Route
Columbia Gas of Ohio Choice/SCO Reference
Manual
45
.ACC and .ACF File Formats (continued)
Columns 220-231:
•
Customer Home Phone
Columns 273-276:
•
Standard Industrial Code
Columns 232-243:
•
Customer Business Phone
•
(if available)
Columns 277-284:
•
Supplier Nomination Group
Columns 244-247:
•
Customer Business Phone Extension
•
(if available)
Columns 248-257:
•
Date Processed (YYYYMMDD)
Columns 258-259:
•
Company Number
Column 260:
•
Filler
Columns 261-265:
•
5 Digit Supplier Rate Code
Columns 266-272:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
46
.ACT File Format
The XXXMMDDY. ACT file, where XXX reflects the
Supplier and State, MM reflects the month, DD
reflects the day, and the Y reflects the last digit of the
year the record is created, provides information to the
Suppliers about customer’s accounts that are
established as of the date of the last .AC2. This file
can be used when building a customer database or to
verify the information contained in a Supplier’s
database.
For example, an .ACT file ran in the middle of a
month would contain all confirmed accounts
as of the previous AC2 file. The accounts
that had been added since the previous
month’s 15th deadline would not be included.
Please note there is a $0.015 cents per record with a
minimum charge of $55.00.
Columns 1-8:
•
Customer PCID Number
Columns 9-11:
•
Customer Sequence Number
Column 12:
•
Customer Check Digit Number
Columns 13-45:
•
Customer Name
Columns 46-78:
•
Service Address
Columns 79-99:
•
City
Columns 100-101:
•
State
Column 102:
•
Filler
Columns 103-112:
•
Zip Code plus 4
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
47
.ACT File Format (continued)
Columns 140-149:
•
‘Add’ date (YYYY-MM-DD)
• This is the date the account was
added (with a ‘1’ code) by this
Supplier. This date is what is used to
determine whether an account is
‘grandfathered’ or is charged
Incremental Balancing Fees in
addition to Optional Balancing Fees)
Column 113:
•
Hyphen
Columns 114-117:
•
Postal Carrier Route
Columns 118-122:
•
Five-digit Supplier Code
Column 150:
•
Incremental Balancing Fee Indicator (YYes or N-No)
• This indicates whether an account is
charged Incremental Balancing Fees
in addition to Optional Balancing
Fees
Columns 123-130:
•
Effective Date (YYYYMMDD)
Columns 131-138:
•
Nomination Group Number
Column 139:
•
Tax Exempt Code Added (Y-Yes or N-No)
• This indicates if the account is coded
in Columbia’s billing system as tax
exempt.
April 2014
Columns 151-152:
•
Revenue Class Code
Column 153-155:
•
Tax Exempt Percentage - if coded in
Columbia’s billing system will report with
leading zeros as a three digit number ( i.e.
10% will be reported as ‘010’ and 100% as
‘100’)
Columbia Gas of Ohio Choice/SCO Reference
Manual
48
.ACT File Format (continued)
Columns 156-157:
•
Billing Unit
Column 283:
•
Budget Customer Indicator “Y” or “N”
Columns 158-183:
•
Filler
Columns 184-216:
•
Mailing Street Address
Columns 217-249:
•
Mailing Street Address Overflow
•
(if necessary)
Columns 250-269:
•
Mailing City
Columns 270-271:
•
Mailing State
Column 272:
•
Filler
Columns 273-282:
•
Mailing Zip Code plus 4
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
49
.AC1/.AC2 and .GAC2 Files
The XXXMMDDY.AC1 file, where XXX
reflects the Supplier and State, MM
reflects the month, DD reflects the day,
and the Y reflects the last digit of the year
the record is created. This file provides
all the accounts that were accepted from
the .DAT file that was uploaded the
previous business day.
.AC1 contains preliminary accepted
accounts. Do not assume that accounts
showing in the .AC1 will be accepted in
the final .AC2 file.
NOTE - When you begin building your
new .DAT file for the next billing cycle (on
the 16th of the month generally), you will
not see the .AC1 file until the 20th of the
month when we begin processing files
again for the new billing cycle.
April 2014
The XXXMMDDY .AC2 and .GAC2 file
provides all the accounts that were
accepted for the previous processing
cycle. Keep in mind that the accepted
accounts you see in the .AC1 file may not
be the same accounts you see in the final
.AC2 and .GA2 file that is generated after
unit 21 bills in Columbia’s system. It is
possible that accounts you saw in your
.AC1 file may have been disconnected,
finaled or have become ineligible between
the time you saw them in the .AC1 file
and the time the final .AC2/.GAC2 file
posts.
.AC2 file provides all the final accepted
DIS accounts from the previous
processing cycle that will flow gas the 1st
of the month.
.GAC2 file provides all the Gas/GMB
accounts from the previous processing
cycle that will flow gas the 1st of the
month.
Columbia Gas of Ohio Choice/SCO Reference
Manual
50
.AC1/ .AC2/.GAC2 File Formats (continued)
Columns 84-86:
•
Filler
Column 1:
•
Action Code
Columns 2-9:
•
Customer PCID Number
Columns 87-88:
•
Billing Unit
Columns 10-12:
•
Customer Sequence Number
Columns 89-91:
•
Filler
Column 13:
•
Customer Check Digit Number
Column 92:
•
Tax Exempt Code - This indicates if the
account is tax exempt.
Preliminary Acceptance File will always
reflect an “N”
Final Acceptance File will reflect an N or Y
Columns 14-19:
•
Effective Date (YYYYMM)
Columns 20-31:
•
Rate Code and Discretionary
Supplier Information
Columns 32-39:
•
Filler
Columns 93-95:
•
Tax Exempt Percentage
Preliminary Acceptance File = 000
Final Acceptance File = 010-100
(digit number with leading zeros, i.e.,10% should
report as 010 and 100% as 100)
Columns 40-59:
•
Customer Last Name
Columns 60-71:
•
Customer First Name
Column 72:
•
Customer Middle Initial (if available)
Columns 73-75:
•
Filler
Columns 76-83:
•
Nomination Group Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
51
.BIL File Format
The XXXMMDDY.BIL file, where XXX reflects
the Supplier and State, MM reflects the
month, DD reflects the day, and the Y reflects
the last digit of the year the record is created,
Provides meter reading and adjustment
Information billed by the DIS system.
A file is produced daily, but may be empty if
the Supplier does not have accounts in each
billing unit.
.BIL Detail Record (11) - current
month billing information format
below:
Columns 1-2
•
Record-type (11)
Columns 3-10
•
System Creation Date
(YYYYMMDD)
April 2014
Columns 11-16:
•
Revenue Cycle (YYYYMM)
Columns 17-18:
•
Billing Unit being billed that day
Columns 19-22:
•
Location Number - Internal COH use
Columns 23-24:
•
Revenue Class
Columns 25-32:
•
Customer PCID Number
Columns 33-35:
•
Customer PCID Sequence Number
Column 36:
•
Customer Check Digit Number
Columns 37-45:
•
Customer PSID Number
Columbia Gas of Ohio Choice/SCO Reference
Manual
52
.BIL Detail Record Format (continued)
Columns 46-78:
•
Customer Name
Columns 198-205:
•
Columns 79-111:
•
Customer Name Overflow
Columns 206-213:
•
Columns 112-144:
•
Service Address
Columns 179-185:
•
Taxing District
Columns 186-193
•
Meter Number
Columns 194-197:
•
April 2014
To-Date (YYYYMMDD)
Columns 214-221
Columns 145-175:
•
Service City, State and Zip Code
Columns 176-178:
•
FIPS County Code
From-Date (YYYYMMDD)
•
From – Read
Columns 222-229
•
To – Read
Columns 230-239:
•
Sign +/-
•
Usage by volume in Ccf
Columns 240:
•
Final Bill
•
Yes – Y, No – N
WIN, AMR. Calc or Read
Columbia Gas of Ohio Choice/SCO Reference
Manual
53
.BIL Detail Record Format (continued)
Column 241:
•
Rebill – Code
•
Yes – Y, No – N
Columns 290-299:
•
Sign +/•
Pay This Amount
Columns 242-251:
•
Sign +/•
Total Current Amount
Columns 300-304:
•
Supplier Rate Code
Columns 252-261:
•
Sign +/•
Total Current Tax Exempt Revenue
Columns 262-269:
•
Sign +/•
Sales Tax
Columns 270-279:
•
Sign +/•
Previous Balance
Columns 280-289:
•
Sign +/•
Total Account Balance
April 2014
Columns 305-310:
•
Sign +/•
Supplier Rate
Columns 311-316:
•
Sign +/•
Supplier Discount
Columns 317-326:
•
Sign +/•
Supplier Previous Balance
Columns 327-336:
•
Sign +/•
Supplier Current Charges
Columbia Gas of Ohio Choice/SCO Reference
Manual
54
.BIL Detail Record Format (continued)
Columns 337-346:
•
Sign +/•
Supplier Current Balance
Columns 436-445:
•
Sign +/•
Delayed Payment Penalty
Columns 347-396:
•
+/- Supplier Charges 1
•
+/- Supplier Charges 2
•
+/- Supplier Charges 3
•
+/- Supplier Charges 4
•
+/- Supplier Charges 5
Columns 446-455:
•
Sign +/•
Agency Handling Fee
Column 456:
•
Customer on Budget
•
Yes-Y, No-N
Columns 397-405:
•
Columbia Rate Schedule
Columns 406-415:
•
Sign +/•
Columbia Customer Charge
Columns 457-466:
•
Sign +/•
Supplier Budget Amount
Columns 416-425:
•
Sign +/•
Columbia Transportation Charges
Columns 467-476:
•
Sign +/•
Supplier Budget Arrears
Columns 426-435:
•
Sign +/•
Supplemental Charges
Columns 477-486:
•
Sign +/•
Supplier Budget Balance
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
55
.BIL Detail Record Format (continued)
Columns 529-538:
•
“Add” date (YYYY-MM-DD)
• This is the date the account was
added with a ‘1or 3’ code by this
Supplier. This date is used to
determine whether an account is
“grandfathered” or is charged
Incremental Balancing Fees in
addition to Optional Balancing Fees.
Columns 487-496:
•
Sign +/•
Columbia Budget Amount
Columns 497-506:
•
Sign +/•
Columbia Budget Arrears
Column 539:
•
Incremental Balancing Fee Indicator (YYes or N-No)
• This indicates whether an account is
charged Incremental Balancing Fees
in addition to Optional Balancing
Fees.
Columns 507-516:
•
Sign +/•
Columbia Budget Balance
Columns 517-518:
•
Billing Unit of the account
Columns 540-548:
•
Sign +/•
Columbia Service Partners charges
Column 519:
•
Zipcheck Status Code
Columns 520-528:
•
Zipcheck Routing Transit Number
April 2014
Columns 549-557:
•
Sign +/•
Miscellaneous Revenue Accounting
charges
Columbia Gas of Ohio Choice/SCO Reference
Manual
56
.BIL Adjustment Record File Format
.BIL Adjustment Record (15)-current month
adjustment information format below:
Columns 35-38:
•
Transaction – Type
Columns 1-2:
•
Columns 39-43:
Record – type (15)
•
Supplier Rate Code
Columns 3-6:
•
Columns 44-53:
Location
•
•
Columns 7-15:
•
Sign +/Columbia Transportation Charges
Customer PSID Number
Columns 54-63:
Columns 16-23:
•
Customer PCID Number
Columns 24-26:
•
Sign +/-
•
Gas Cost Amount (includes Sales Tax if
applicable)
Columns 64-71:
•
Adjustment Period Date (YYYYMMDD)
Customer Sequence Number
Columns 27-34:
•
•
Transaction – Date (YYYYMMDD)
Columns 72-81:
•
Sign +/•
Ccf
Column 82:
•
Customer Check Digit Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
57
.BIL Adjustment Record File Format (continued)
Columns 83-92:
•
“Add” date (YYYY-MM-DD)
• This is the date the account was
added (with a “1or 3” code) by this
Supplier. This date is what is used to
determine whether an account is
“grandfathered” or is charged
Incremental Balancing Fees in
addition to Optional Balancing Fees
Column 93:
•
Incremental Balancing Fee Indicator (YYes or N-No)
• This indicates whether an account is
charged Incremental Balancing Fees
in addition to Optional Balancing
Fees
Columns 94-539:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
58
.BIL Detail Record File Format
.BIL Detail Record (9) - current month balance
record information format below:
Columns 1-9:
Balance Record Indicator (all nines)
Gas Measurement Billing information is located in the
BIL file following the BIL Detail Record – current
month balance record information (highlighted below).
Columns 10-15:
Sign +/Record Count
Columns 16-27:
Sign +/Total Account Balance (last two digits are
decimal $xxxxxxx.xx)
Columns 28-56:
Filler
Columns 57-58
Balance Record Indicator (all nines)
Columns 59-539:
Filler
Sign +/Transportation
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
59
.CAC File Format
The XXMMDDY.CAC file, where XX reflects the
Marketer, MM reflects the month, DD reflects the day,
and the Y reflects the last digit of the year the record
is created.
This file provides all rate code changes (Action Code
5) that were accepted from the .DAT file that was
uploaded the previous business day.
Rate Code changes are processed daily so this is the
final accept file.
Column 1:
•
Action Code
Columns 2-9:
•
Customer PCID Number
Columns 10-12:
•
Customer Sequence Number
Column 13:
•
Customer Check Digit Number
Columns 14-19:
•
Effective Date (YYYYMM)
Columns 20-31:
•
Rate Code and Discretionary
Marketer Information
Columns 32-39:
•
Filler
April 2014
Columns 40-59:
•
Customer Last Name
Columns 60-71:
•
Customer First Name
Column 72:
•
Customer Middle Initial (if available)
Columns 73-75:
•
Filler
Columns 76-83:
•
Nomination Group Number
Columns 84-86:
•
Filler
Columns 87-88:
•
Billing Unit
Columns 89-91:
•
Filler
Column 92:
•
Tax Exempt Code - This indicates if the
account is tax exempt.
( .CAC = N) View AC2 for this information
Columns 93-95:
•
Tax Exempt Percentage
( .CAC = 000) View AC2 for this information
Columbia Gas of Ohio Choice/SCO Reference
Manual
60
.CDT File Format
The .CDT file is the Customer Detail Report. This report compares the number of customers from the previous
month with the current customer count. This information can prove useful when figuring the Like-in-Kind
adjustment from the Demand curve. The file XXXMMDDY.CDT where the XXX is the Supplier and State, MM
reflects the Month, DD reflects the day and Y reflects the last digit of the year the report was created.
An example of this file print out is as follows and is self explanatory:
Demand Curve Customer Detail Report
Supplier
Class
YY
C
1111
1,000
850
YY
C
2222
6
8
YY
C
3333
50
45
YY
R
1111
10,000
980
YY
R
2222
300
150
YY
R
3333
200
300
April 2014
Nom grp
This Month Customers
Columbia Gas of Ohio Choice/SCO Reference
Manual
Last Month Customers
61
.CON File Format
The XXXMMDDY.CON file where XXX reflects the
Supplier and State, MM reflects the month, DD
reflects the day, and the Y reflects the last digit of the
year the record was created. This file provides a list
of valid accounts with 24 months of consumption from
the .DAT file uploaded the previous business day.
These accounts had either a ‘3’ or ‘4’ action code in
column 1.
Column 1:
•
Codes 3 and 4
•
3 indicates an account should be
enrolled as a Choice account and
24 months consumption history is
to be sent to the Supplier on the
.CON file.
•
4 indicates 24 months of an
established Columbia Choice
account’s consumption history is to
be sent to the Supplier on the
.CON file.
Columns 14-21
•
Customer PCID Number
Columns 22-24:
•
Customer Sequence Number
Column 25:
•
Customer Check Digit Number
Columns 26-34:
•
Customer PSID Number
Columns 35-586
•
24 Months Consumption
•
Each month has the following information:
• Revenue Cycle (YYYYMM)
• Meter Read Date (YYYYMMDD)
• Consumption (999999999) in Ccf
Columns 2-13:
•
Supplier Rate Code
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
62
.CONF File Format
The .CONF file is a confirmation record of the transactions received each day as submitted through the .DAT file. Please
note that this is not an accept or reject confirmation, rather a response file including date and time stamp, of your previous
day’s submission. This file can be used to verify the information submitted to Columbia for processing.
The .CONF file is produced daily, however it will be empty if there is no activity to report.
Column 1:
•
Action code
Columns 40-59:
• Filler
Columns 2-9:
•
Customer PCID Number
Columns 60-62:
• Marketer code
Columns 10-12:
•
Customer SEQUENCE
Columns 63-70:
• Date YYYYMMDD
Column 13:
•
Customer CHECK DIGIT
Columns 71-74:
• 24 Hour Time HHMM
Column 14 - 19
•
Filler
Columns 75-79:
• Record sequence number
Columns 20-25:
•
Marketer rate code
Columns 26-31:
•
Filler
Columns 32-39:
•
Nomination Group number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
63
.DAT File Format
The .DAT file is utilized by the Suppliers to enroll, remove ,delete or change an account on the FTP Web Site.
Supplier’s enter the Action Code in the first column followed by the account information which is included in
columns 2 through 39 described on the next page. Files can be submitted daily up through the 15th of the month
preceding the effective flow date.
Example: to add a new account, the following transaction would be submitted in the .DAT file:
1123456780012
XXC01
00000000
The number 1 at the beginning of the PCID number is to enroll a customer in Choice .
Examples: for sales tax exemption status changes the following transactions would be submitted in
the .DAT file:
8123456780012E085 XXC01
00000000
The number 8 at the beginning of the PCID number is to add or change a customers sales
tax percentage.
9123456780012E000 XXC01
00000000
The number 9 at the beginning of the PCID number is to remove the tax exemption on an
account.
The Supplier must start with a “clean” .DAT file after each enrollment period.
NOTE: Columns = Spaces
.DAT FILE FORMAT:
Codes are ‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘8’, ’9’, ‘D’ (see explanation of each below):
1 - Account to be enrolled on Choice 
2 - Account to be removed from Choice
3 - Account to be enrolled on Choice and 24 months consumption sent to Supplier
4 - 24 months consumption of an established Columbia Choice  customer sent to Supplier
5 - Change to customer’s rate code
8 - Add or Change to customer’s sales tax exemption percentage
9 - Remove a customer’s sales tax exemption percentage
D - Pending account to be deleted from the .DAT file. DO NOT physically delete the
account from the .DAT file
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
64
.DAT File Format (continued)
Column 1:
•
Action code
Columns 18-19:
•
Filler (Leave blank)
Columns 2-9:
•
Enter the Customer PCID (8 character)
Number
Columns 10-12:
•
Enter the Customer SEQUENCE
(3 character) Number
Columns 20-31:
•
Enter in the 12 digit control as the following:
•
Enter a 5-digit Supplier rate code in the first 5
positions
•
The first 3 characters are the Supplier code and
the last two characters are the rate number
•
The next 7 characters are not required and can
be used by the Supplier at their own discretion
Column 13:
•
Enter the Customer CHECK DIGIT
(1 character) Number
Columns 32-39:
•
Enter eight digit Nomination Group number
(precede with zeros)
Column 14:
•
Enter in a one character tax exempt
indicator
•
Valid code is ‘E’ or blanks
•
An ‘E’ indicates customer’s tax exempt
indicator should be set to true and works
with an account code ‘8’ only. An ‘E’ with
an action code of ‘9’ and ‘000’ for the
percentage indicates that the tax exempt
indicator should be set to false.
Columns 15-17:
•
Enter the customer tax exempt percentage
as a number from ‘001’ to ‘100’ (must
include leading zeros). Enter ‘000’ if
removing tax
April 2014
SPECIAL NOTE:
The “D” code is used during the current enrollment
period when a pending account in the .DAT file has
been entered in error. To remove or delete an
account that has been submitted/enrolled in error
during the current enrollment period, use the “D”
action code
Do not confuse this code with the “2” code which is
used to remove an account from the program after
set-up has already occurred
Columbia Gas of Ohio Choice/SCO Reference
Manual
65
Transaction Examples
Notes:
DAT and RATE.DAT must be uploaded by 5:00 pm EST
DAT and RATE.DAT are not processed on weekends and holidays (see meter reading schedule for process
dates)
DAT file does not process Action Code 1,2,3, 8,9, & D from the 16th – 19th calendar days (only 5 codes are
processed)
SCO Suppliers will only have a DAT file and it can only be used to submit Action Codes 8 & 9 for sales tax
exemption status changes
Action: Request a new Rate Code
File: N/A
Timeline: 45 days prior to the effective month Supplier must email their Choice Analyst the Marketer Rate
Statement fill in the statement with prices (if prices haven’t been determined enter a dummy price).
Action: Enroll or Drop a Customer
File: DAT
Timeline: 20th – 15th (effective next billing month)
Notes: Customers can be enrolled (Action code 1 or 3) or dropped (Action code 2) from Choice via the DAT file
from the 20th to the 15th for the following month’s billing. (If the 15th falls on a weekend or holiday, the .DAT file
is due the previous business day.)Example: An enrollment submitted from September 20th through October
15th will be effective for November billing.
Example: Supplier enrolls customer for Jan billing between Nov 20th and Dec 15th
3123456780011
XXX01
000####
Supplier drops customer for May billing between Mar 20th and Apr 15th
2123456780011
XXX01
000####
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
66
Transaction Examples (cont.)
Action: Cancel an Enroll / Drop
File: DAT
Timeline: 20th – 15th
Notes: Suppliers can cancel an enrollment or drop during the same enrollment period by submitting a D (delete)
action code. If the cancel is just due to the incorrect rate code, submit another enrollment with the correct rate
code. After the customer has billed at least one time, then Action Code 5 can be used.
Example:
3/3/13 Submitted Enrollment
3123456780011
XXX01
0000####
3/12/13 Realized customer should have been enrolled on rate code XXX02, Submitted a cancel and a new
enrollment
D123456780011
XXX01
0000####
3123456780011
XXX02
0000####
Action: Change Rate Code
4/19/13 Customer should be on XXX03 for May billing. Determine the customers billing unit from the AC1 or BIL
file. Look at the meter reading schedule to determine when the customer will bill for May meter reading schedule.
The Customer is unit 11 and will bill on May 14 for May
The rate code change must be submitted after the customer bills for April but before the customer bills for May.
The rate code change is processed immediately. The customer will bill at the price point for the newly changed
rate code.
5123456780011
April 2014
XXX03
0000####
Columbia Gas of Ohio Choice/SCO Reference
Manual
67
Transaction Examples (cont.)
Action: Change Tax Exempt Percentage
File: DAT
Timeline: 20th – 15th (effective next billing month)
Notes: COH SCO and Choice Suppliers are responsible for maintaining Customers sales tax exempt
certificates. Suppliers must then submit their customers’ sales tax exemption percentage with Action Code 8.
Changes to the percentage should also be made with Action Code 8. Removing the sales tax exemption
percentage requires Code 9.
Action: Change a Customer’s Rate Code
File: DAT
Timeline: Daily (effective immediately)
Notes: Suppliers can change the rate code of their existing customers (Action code 5) via the DAT file. This
will be processed immediately. It is important to track a customer’s billing unit (found on the BIL file) to
determine what day the customer will bill. Meter reading schedules can be found on
www.columbiasuppliers.com.
Example Customer should be on XXX06 for June billing.
The Customer is unit 14 and will bill on June 18th for June
The rate code change must be submitted after the customer bills for May but before the customer bills for June
5/18/13 – 6/18/13. The rate code change is processed immediately.
5123456780011
XXX06
0000####
(Note: Had this example been Jan 2013 billing or before, the Action 5 code would have been submitted
between April 20th and May 15th to be effective for June billing)
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
68
Transaction Examples (cont.)
Action: Change the Price on a Rate Code
File: RATE.DAT
Timeline: 20th – 20th (effective next billing month)
Notes: Rate code price changes can be submitted daily. The last price received for a rate code by the 20th will
be effective for the next billing month.
Example: XXX01 is currently $5.00 per Mcf but should be $4.85 effective January billing
12/15 submit in RATE.DAT
XXX01 0004.8500
If this is returned in the RAC1 file, this will be the effective rate for Jan billling
12/17 Supplier decides XXX01 should be $4.95 per MCF effective January billing.
XXX01
0004.9500
This will replace the 4.85 and the effective rate for Jan billing will be $4.95
Action: Request a Customer’s Consumption History
File: DAT
Timeline: 20th – 15th
Notes: Submitting an account with Action Code 3 will enroll a customer as well as return a CON
(consumption) file. (Action code 1 will enroll but not return a CON file).
Also, an Action Code 4 can be submitted for an existing customer (must have billed at least one time).
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
69
.DET File Format Layout
The OHXXMMYY.DET file where XX reflects the
Supplier, MM reflects the month, YY year the
record was created.
The .DET file is the Supplier Detail file – record
layouts. There are Three (3) record types that can be
in each file:
1. Detail record (type = 1)
2. Adjustment detail record (type = 2)
3. Control total record (type = 3)
All numeric fields are defined as signed unpacked
numbers. This allows us to retain negative values in
the numeric fields. A conversion chart of values for
signed unpacked numbers are below:
A=1
J = -1
B=2
K = -2
C=3
L = -3
D=4
M = -4
E=5
N = -5
F=6
O = -6
G=7
P = -7
H=8
Q = -8
I = 9
R = -9
{ =0
} = -0
April 2014
Detail Record:
Column 1:
•
Record Type 1
Columns 2-3:
•
Company
Columns 4-14:
•
Customer PCID Sequence Number
Column 15:
•
Customer Check Digit Number
Columns 16-20:
•
Supplier Number
Columns 21-23:
•
County Code
Column 24:
•
Revenue Class
Columns 25-33:
•
Supplier Current Month Mcf
Columbia Gas of Ohio Choice/SCO Reference
Manual
70
.DET File Format Layout, Detail Record (continued)
Columns 34-42:
•
Supplier Adjustment Mcf
Columns 97-107:
•
Total Tax
Columns 43-51:
•
Total Mcf
Columns 108-118:
•
Grand Total
Columns 52-60:
•
Supplier Current Month Gas Cost
Columns 119-126
•
Filler
Columns 61-69:
•
Supplier Adjustment Gas Cost
NOTES:
•
Total Mcf = (Splr curr mo Mcf + Splr adj Mcf)
•
Total Gas Cost = (Splr curr mo gas cost + Splr
adj gas cost)
•
Total Tax = (State tax curr mo + State tax adj)
•
Grand Total = (Total gas cost + Total tax)
•
Values for the Revenue Classes are:
•
R = Residential
•
C = Commercial
•
I = Industrial
Columns 70-78:
•
Total Gas Cost
Columns 79-87:
•
State Tax Current Month
Columns 88-96:
•
State Tax Adjustment
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
71
.DET File Format Layout, Supplier and Adjustment
Adjustment Detail Record
Note: Supplier adjustment date = YYYYDD
Column 1:
•
Record Type 2
Columns 2-3:
•
Company
Columns 4-14:
•
Customer PCID Sequence Number
Column 15:
•
Customer Check Digit Number
Columns 16-20:
•
Supplier Number
Columns 21-26:
•
Supplier Adjustment Date
Columns 27-35:
•
Supplier Adjustment Mcf
Column 36-44:
•
Supplier Adjustment Gas Cost
Column 45-126:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
72
.DET File Format Layout, Control Total Record
Control Total Record
Columns 61-69:
•
Supplier Adjustment Gas Cost
Column 1:
•
Record Type 3
Columns 70-78:
•
Total Gas Cost
Columns 2-3:
•
Company
Columns 79-87:
•
State Tax Current Month
Columns 4-15:
•
Filler
Columns 88-96:
•
State Tax Adjustment
Columns 16-20:
•
Supplier Code
Columns 97-107:
•
Total Tax
Columns 21-24:
•
Filler
Columns 25-33:
•
Supplier Current Month Mcf
Columns 34-42
•
Supplier Adjustment Mcf
Columns 108-118:
•
Grand Total
Columns 119-126:
•
Filler
Columns 43-51:
•
Total Mcf
Columns 52-60:
•
Supplier Current Month Gas Cost
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
73
.DIS File Format
The .DIS file shows the customers who have
been disconnected and are inactive in our
billing system.
The XXXMMDDY.DIS file where XXX reflects
the Supplier and State, MM reflects the
month, DD reflects the day, and the Y reflects
the last digit of the year the record was
created. This provides information to the
Suppliers about accounts that have been
removed from COH service for various
reasons.
Upon receiving an account in this file, the
Supplier should check with the customer to
validate activity on the account.
The customer has taken one or more of the
following actions:
•
re-established an account at a new
address
•
changed ownership
•
moved out of the Columbia service
territory
The .DIS file reflects service changes and should not
be confused with the .NOP file.
Columns 1-5:
•
Supplier Rate Code
Columns 6-7:
•
Company Number (i.e. 34 for Ohio)
Columns 8-11:
•
Location Number – An internal Columbia
tracking number based on the Area Office
that serves the customer
Columns 12-19:
•
Customer PCID Number
Columns 20-22:
•
Customer PCID Sequence Number
Column 23:
•
Customer Check Digit Number
All the above would cause the customer to be
disconnected on our system.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
74
.DIS File Format (continued)
Columns 24-32
•
Customer PSID Number
Columns 33-34:
•
Unit Number (The unit of the billing cycle)
Columns 35-36:
•
Book Number (The book for the billing
cycle)
Columns 81-88:
•
Customer Activity Date (YYYYMMDD) =
Date COH processed the order in our
system
Columns 89-92:
•
Customer Activity Type
(The transaction code from the COH
billing system, internal use)
Column 37:
•
Account Status Code
Columns 38-45:
•
Disconnect Date (YYYYMMDD) = Date
account became inactive
Columns 46-47:
•
Revenue Class Code
Columns 48-80:
•
Customer Name
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
75
.DMD File - Steps to Import Into Excel
The XXXMMDDY. DMD file, where XXX reflects the
Supplier and State, MM reflects the month, DD reflects
the day, and the Y reflects the last digit of the year the
record is created. To import the .DMD comma delimited
file into Excel do the following steps:
•
•
•
•
•
•
•
•
•
Move the .DMD file to your hard drive
Open Excel
Open the .DMD file – Should bring up the Import
Wizard
Import Wizard – Step 1
•
Radio Button – Delimited (Default)
•
Select Next
Import Wizard – Step 2
•
Delimiters – Select Comma
•
Remove any other selected Delimiters
Select Next
Import Wizard – Step 3
Column Data Format
•
Select Text
Select Finish
File should now be in a spreadsheet format.
Save the file.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
76
Demand Curves
•
Report 1 Calendar Month Report provides the normalized volumetric information for the current group of
customers based on their actual historical consumption. Volumes on this report are increased for retainage
and decreased for customer attrition. The volumes have not been reduced by the Local Gas Purchase
Percentage.
•
Report 2 Billing Month Report provides the normalized billing month volumetric information based on
actual historical information. Columbia bills the customer on billing cycles and Suppliers deliver on calendar
months. This report reflects that difference. Volumes on this report are increased for retainage and
decreased for customer attrition. The volumes have not been reduced by the Local Gas Purchase
Percentage.
•
Report 3 Dth Summary Report provides number of customers, operational information, daily like and kind
adjustment, and daily and annual volumes. Bal Type = N indicates non-temperature balancing or Bal Type =
F indicates full balancing for Co-Operatives.
•
Report 4 Nom Group Dth Curve Report shows daily delivery volumes by temperature. The balance point
temperature is 54 degF. Volumes on this report have been reduced by 3.2300%, the Local Gas Purchase
Percentage.
Note: The volumes on all reports include unaccounted-for volumes, hence they represent volumes at the city gate.
Report 3 shows the unaccounted-for factor.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
77
Choice Demand Curves Report 1
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
78
Choice Demand Curves Reports 2 & 3
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
79
Choice Demand Curves – New Report 4
Temp Range: 54 to 32, but all temperatures aren’t shown on the slide
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
80
.ERC File Format
The XXMMDDY.ERC file, where XX reflects the
Marketer, MM reflects the month, DD reflects the day,
and the Y reflects the last digit of the year the record
is created.
This file provides all rate code changes (Action Code)
that were submitted incorrectly from the previous
business day.
Accounts that are re-submitted correctly will then be
dropped off the .ERC file and show up on the .CAC
file.
Column 1:
•
Action code
Columns 2-6:
•
Supplier Number (Rate Code)
Columns 7-39:
•
Supplier Name
Columns 40-47:
•
Customer PCID Number
Columns 48-50:
•
Customer Sequence Number
Column 51:
•
Customer Check Digit Number
Columns 52-60:
•
Customer PSID Number
Columns 61-66:
•
Effective Date (YYYYMM)
Columns 67-70:
•
Audit Error Code (see Audit/Error Codes
and Descriptions)
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
81
.ERC File Format (continued)
Columns 71-110:
•
Audit Error Description (see Audit/Error Codes
and Descriptions)
Columns 220-231:
•
Customer Home Phone
Columns 111-112:
•
Current Revenue Class
Columns 232-243:
•
Customer Business Phone (if available)
Columns 244-247:
•
Business Phone Extension (if available)
Columns 113-114:
•
Old Revenue Class
Columns 248-257:
•
Date Processed (YYYY-MM-DD)
Columns 115-126:
•
Customer First Name
Columns 258-259:
•
Company Number
Column 127:
•
Customer Middle Initial
Column 260:
•
Filler
Columns 128-147:
•
Customer Last Name
Columns 261-272:
•
12 digit control code
(5 character Supplier code & 7 discretionary
characters)
Columns 148-180:
•
Service Address
Columns 181-219:
•
Service City, State, Zip+4, Carrier Route
April 2014
Columns 273-276:
•
Standard Industrial Code (Classification)
Columbia Gas of Ohio Choice/SCO Reference
Manual
82
.ERR/.ER2 and .GER2 Files
The .ERR file:
The .ER2/.GER2 file:
This file is an alert to correct any accounts
submitted incorrectly or accounts that are unable
to be coded for Choice  the previous business
day.
Accounts that are re-submitted correctly and can
be coded for Choice  will then be dropped off
the .ERR file and shows up on the .AC1 file.
The XXXMMDDY. ERR/.ER2 and .GER2 file:
•
XX reflects the Supplier
•
X reflects the State
•
MM reflects the month
•
DD reflects the day
•
Y reflects the last digit of the year the
record is created
This file reflects the accounts rejected from the
.DAT file that was uploaded the previous
business day.
NOTE: It is STRONGLY RECOMMENDED that
the .ERR file is reviewed daily in order to
maximize enrollment and minimize customer
complaints.
April 2014
These files provide the accounts that were rejected
from the monthly processing cycle , and will not flow
gas the 1st of the month.
These accounts cannot be corrected for this billing
cycle but will have to be resubmitted with corrections
on your new .DAT file for the next billing cycle.
.ER2 file shows the final rejected DIS accounts
.GER2 file show the final rejected Gas/GMB
accounts
Additional Information:
The .ERR, .ER2 and .GER2 files provide a total
number of accounts at the bottom of the file
processed from the .DAT file.
The number of accounts accepted from the .DAT file
and the number of accounts that are rejected and
sent back on the .ERR, .ER2 and .GER2 files. This
total also shows the number of accounts that were
deleted from the .DAT file. This total, however, does
not include the code 2 accounts that were removed
from the program. They are included in the number
of records processed.
Columbia Gas of Ohio Choice/SCO Reference
Manual
83
.ERR/.ER2 and .GER2 File Formats (continued)
Column 1:
•
Action code
Columns 2-6:
•
Supplier Number (Rate Code)
Columns 7-39:
•
Supplier Name
Columns 71-110:
•
Audit Error Description (see Audit/Error
Codes and Descriptions)
Columns 111-112:
•
Current Revenue Class
Columns 40-47:
•
Customer PCID Number
Columns 113-114:
•
Old Revenue Class
Columns 48-50:
•
Customer Sequence Number
Columns 115-126:
•
Customer First Name
Column 51:
•
Customer Check Digit Number
Columns 52-60:
•
Customer PSID Number
Column 127:
•
Customer Middle Initial
Columns 128-147:
•
Customer Last Name
Columns 61-66:
•
Effective Date (YYYYMM)
Columns 67-70:
•
Audit Error Code (see Audit/Error Codes
and Descriptions)
Columns 148-180:
•
Service Address
Columns 181-219:
•
Service City, State, Zip+4, Carrier Route
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
84
.ERR /.ER2 and .GER2 File Formats (continued)
Columns 220-231:
•
Customer Home Phone
Columns 232-243:
•
Customer Business Phone (if available)
Columns 244-247:
•
Business Phone Extension (if available)
Columns 248-257:
•
Date Processed (YYYY-MM-DD)
Columns 258-259:
•
Company Number
Column 260:
•
Filler
Columns 261-272:
•
12 digit control code
(5 character Supplier code & 7 discretionary
characters)
Columns 273-276:
•
Standard Industrial Code (Classification)
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
85
Governmental Aggregation List Layout
Columns 1 – 8
•
Customer PCID Number
Columns 110 – 142
•
Mailing Address
Columns 9 – 11
•
Customer Sequence Number
Columns 143 – 162
•
Mailing City
Column 12
•
Customer Check Digit Number
Columns 13 – 45
•
Customer Name
Columns 163 – 164
•
Mailing State
Columns 165 – 173
•
Mailing Zip + 4
Columns 46 – 78
•
Service Address
Columns 79 – 98
•
Service City
Columns 99 – 100
•
Service State
Columns 101 – 109
•
Service Zip + 4
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
86
.NOP File Format
The XXXMMDDY. NOP file, where XXX reflects
the Supplier and State, MM reflects the month,
DD reflects the day, and the Y reflects the last
digit of the year the record is created, provides
information to the Suppliers about customer’s
accounts that have been issued a pending
termination notice for non-payment or nonaccess to their meter.
Upon receiving an account in this file the
Supplier could contact the customer to make
sure that the customer stays current on the
account in order to avoid termination of service
due to non-payment or non-access.
Columns 1-5:
•
Supplier Rate Code
Columns 6-7:
•
Company Number (34 for Ohio)
Columns 8-11:
•
Location Number - An internal
Columbia tracking number based on
the Area office that serves the
customer.
Columns 12-19:
•
Customer PCID Number
Columns 20-22:
•
Customer PCID Sequence Number
Column 23:
•
Customer Check Digit Number
Columns 24-32:
•
Customer PSID Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
87
.NOP File Format (continued)
Columns 33-34:
•
Unit Number (The unit of the billing cycle)
Columns 35-36:
•
Book Number (The book of the unit for the
billing cycle)
Column 37:
•
Account Status Code
Columns 89-94:
•
CCTNNP – customer receives a 14-day
disconnection notice for non-payment of
arrears or
•
CCTNFA – customer receives a 14-day
disconnection notice for failure to grant
Columbia access to the meter for a 12
month period or longer
Columns 95-99:
•
Five Digit Supplier Rate Code
Columns 38-45:
•
Filler (zeros)
Columns 100-107:
•
Filler (zeros)
Columns 46-47:
•
Revenue Class Code
Columns 48-80:
•
Customer Name
Columns 81-88:
•
Date of Transaction (YYYYMMDD) – Date
the notice or termination occurred
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
88
.RAC1 File Format
The XXXMMDDY.RAC1 file, where XXX reflects the
Supplier, MM reflects the month, DD reflects the day, and
the Y reflects the last digit of the year the record is created.
The .RAC1 file contains preliminary accepted Supplier rate
code values from the RATE.DAT file that were uploaded the
previous business day to be used for billing starting with Unit
1 of the effective month..
In addition, the .RAC1 file will contain the last billed value for
the Supplier rate code.
Columns 1-5:
•
Supplier Rate Code (5 characters)
Columns 6-14:
•
Price Value
XXXX.XXXX
Columns 15:
•
Billing Option
Blank, “N”, or “F”
Columns 16:
•
Plus or Minus NYMEX
Blank, “ +” , “-”
Columns 17-22:
•
Effective Date (YYYYMM)
Columns 23-32:
•
Last Billed Value
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
89
.RAC2 File Format
The XXXMMDDY.RAC2, where XXX reflects the Supplier,
MM reflects the month, DD reflects the day, and the Y
reflects the last digit of the year the record is created.
The .RAC2 file is generated on the last day of the
submission period, normally calendar day 20, and will reflect
the Supplier rate code(s) and values to be used for customer
billing starting with Unit 1 billing for the effective month.
The .RAC2 file will be used as the pre-bill verification
eliminating the hard copy pre-bills with the exception of
new Supplier codes. Hard copy pre-bills will still be
sent for new Supplier rate codes.
April 2014
Columns 1-5:
•
Supplier Rate Code (5 characters)
Columns 6-14:
•
Price Value
XXXX.XX
Columns 15:
•
Billing Option
Blank, “N”, or “F”
Columns 16:
•
Plus or Minus NYMEX
Blank, “ +” , “-”
Columns 17-22:
•
Effective Date (YYYYMM)
Columbia Gas of Ohio Choice/SCO Reference
Manual
90
.RATE File Layout – Supplier Billing Rates
The XXMMDDY.RATE file, where XX in the name of
the file is an abbreviated two-digit code to identify
the Supplier , MM reflects the month, DD reflects the
Day and Y reflects the last digit of the year the record is
created.
Columns 113-117:
•
Supplier Rate Code
This report provides active rate codes and the associated
price value per unit of measure for each billing cycle. This
report is available the 2nd business day of each month.
Columns 123-130:
•
Rate Effective Date
Columns 1-44:
•
Filler
Columns 118-122:
•
Filler
Columns 131-134:
•
Filler
Columns 45-61:
•
Company
Columns 135-144:
•
Price Value (MCF)
Columns 62-68:
•
Billing Cycle (Month/Year)
Columns 145-148:
•
Filler
Columns 69-75;
•
Filler
Columns 149:
•
Type
Columns 76-112:
•
Supplier Name
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
91
RATE.DAT File Format
The XXXRATE.DAT file, where XXX reflects the Supplier
identifier, is used to submit Supplier rate codes for price value
changes via the FTP Web Site. This automated process will
allow Suppliers to submit updates on a daily basis starting on
the 21st of one month and ending on the 20th of the following
month.
Price values can be changed for the same Supplier rate code
throughout the submission period. The last price value for a
Supplier rate code received and accepted by Columbia will be
the value used for billing starting with Unit 1 of the effective
month.
If the 20th falls on a weekend or holiday, then the submission
period ends on the previous business day.
If the 21st falls on a weekend or holiday, then the submission
period starts on the next business day.
Format Examples of Rate Options:
----+----1----+ABC010005.8900
EXAMPLE OF A FIXED VALUE OF 0004.5000 MULTIPLIED
BY MCF
ABC020004.5000N+ EXAMPLE OF A NYMEX '+' VALUE OF 0004.5000
ABC030000.7500N- EXAMPLE OF A NYMEX '-' VALUE OF 0000.7500
ABC040100.0000F EXAMPLE OF A FLAT VALUE OF 0100.0000
NOTE:
A “clean” XXXRATE.DAT file will be posted daily.
April 2014
Columns 1-5:
•
Supplier Rate Code (5 characters)
Columns 6-14:
•
Price Value
XXXX.XXXX
The price value is a 9 character field and must be
entered with a decimal point between the dollars and
cents. All 9 characters must be entered.
Columns 15:
•
Billing Option
Blank, “N”, or “F”
Blank is for a fixed rate structure per Mcf.
“N” is for a NYMEX rate structure.
“ F” is for a Flat rate structure.
Columns 16:
•
Plus or Minus NYMEX
Blank, “ +” , “-”
“+” character will be added to monthly NYMEX rate.
“-” character will be subtracted from the monthly
NYMEX rate.
Columbia Gas of Ohio Choice/SCO Reference
Manual
92
.REC File Format
The XXXMMDDY.REC file, where XXX reflects the
Supplier and State, MM reflects the month, DD
reflects the day, and the Y reflects the last digit of the
year the record is created provides all the accounts
that have rescinded their pending enrollment with the
natural gas supplier within the allowable 7-business
day rescission period.
The accounts listed in the .REC file will be deleted
from the pending enrollment table and will not be
confirmed in the. AC2.
Columns 10-12:
•
Customer Sequence Number
Column 13:
•
Customer Check Digit Number
Columns 14-19:
•
Filler
Columns 20-24:
•
Supplier Rate Code
Please use the .REC file to update your database.
Column 1:
•
Code will be ‘C’ indicating the account has
rescinded their pending enrollment or code
“N” indicating account remains with
previous Supplier
Columns 25-31:
•
Filler
Columns 32-39:
•
Nomination Group Number
Columns 2-9:
•
Customer PCID Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
93
.REM File Format
The XXXMMDDY. REM file, where XXX reflects
the Supplier and State, MM reflects the month,
DD reflects the day, and the Y reflects the last
digit of the year the record is created, provides all
the accounts that will be removed from the
natural gas supplier's customer base as a result
of the customer's election of another natural
gas supplier, including the LDC.
This is an automatic process that no longer
requires an action code ‘2’ submittal by the
current Supplier.
The accounts listed in the .REM file will be
removed from the current Supplier and enrolled
with the new Supplier or returned to the LDC
tariff service.
Column 1:
•
Code will be ‘2’ or ‘S’ indicating the account
will be removed from the current Supplier
Columns 2-9:
•
Customer PCID Number
April 2014
Columns 10-12:
•
Customer Sequence Number
Column 13:
•
Customer Check Digit Number
Columns 14-19:
•
Effective Date (YYYYMM)
Columns 20-24:
•
Supplier Rate Code
Columns 25-31:
•
Filler or 7 discretionary characters entered
in Supplier .DAT File
Columns 32-39:
•
Filler
Columns 40-59:
•
Customer Last Name
Columbia Gas of Ohio Choice/SCO Reference
Manual
94
.REM File Format (continued)
Columns 60-71:
•
Customer First Name
Column 72:
•
Customer Middle Initial (if available)
Column 92:
•
Tax Exempt Code Added (Y-Yes or N-NO)
• This indicates if the account is coded
in Columbia’s billing system as tax
exempt.
Columns 73-75:
•
Filler
Column 93-96:
•
Filler
Columns 76-83:
•
Nomination Group Number
Columns 97-132:
•
Removal Type:
• GENERATED REMOVAL
(CUSTOMER IS KING) indicates that
an account has enrolled with another
Supplier.
• RETURN TO SALES indicates an
account has elected to return to tariff
sales service.
Columns 84-86:
•
Filler
Columns 87-88:
•
Billing Unit
Columns 89-91:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
95
.RERR File Format
Columns 1-5:
•
Supplier Rate Code
The .RERR file:
This file is a daily file that reflects the Supplier rate codes
and/or price values that rejected from the RATE.DAT that
was uploaded the previous business day. Supplier rate
codes and/or price values that are re-submitted correctly
during the submission period will then be dropped off the
.RERR file and will report in the .RAC1 file.
The XXXMMDDY.RERR file:
XXX reflects the Supplier and State
MM reflects the month
DD reflects the day
Y reflects the last digit of the year the record is
created
NOTE: It is STRONGLY RECOMMENDED that the
.RERR file is reviewed daily in order to maximize
the opportunities to revise dollar values during the
submission period.
Columns 6-14:
•
Price Value
XXXX.XXXX
Columns 15:
•
Billing Option
Blank, “N”, or “F”
Columns 16:
•
Plus or Minus NYMEX
Blank, “ +” , “-”
Columns 17-20:
•
Audit Error Code (see Audit/Error Codes
and Descriptions)
Columns 21-22:
•
Filler
Columns 23-61:
•
Audit Error Description (see Audit/Error
Codes and Descriptions)
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
96
.REV File Format - RS5500MK
The XXXMKMMY.REV file, where XXX in the name of
the file is an abbreviated three-digit code to identify
the Supplier and State, MK reflects the report name,
MM reflects the month and Y reflects the last digit of
the year the record is created.
This report provides the Supplier’s prior month billed
revenue. The report provides details by Supplier
rate code as well as a summary page.
Total Supplier payment is the payment amount prior
to any offsetting, that will be made to the Supplier
on the 25th of each month.
Note: The following are examples of offsets to
Supplier payments: .ACT/.ACF file request charges,
billing rate changes in excess of allowable number,
local gas purchase charges, demand/supply curve
non-compliance charges, balancing charges, or any
other miscellaneous charges. Your monthly GTS
invoice will reflect these charges.
A Supplier who participates in the Company’s
Accounts Receivable Purchase program (POR), the
report provides detail on the purchased receivables
and the supplier payment .
The .REV file is available in report format and does
not require an import.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
97
.REV File Format - RS5500MK
April
2013
April
2014
Columbia Gas of Ohio Choice/SCO
Columbia Gas of Ohio Choice/SCO Reference
Reference
Manual
Manual
98
98
.REV File Format –RS5600T3-1
RS5600T3-1 Supplier Sales Tax Report by
County
The XXXTXMMY.REV file, where XXX in the name
of the file is an abbreviated three-digit code to
identify the Supplier and State, TX reflects the report
name, MM reflects the month and Y reflects the last
digit of the year the record is created.
Further questions regarding sales tax responsibilities
can be directed to the Ohio States tax hotline at 1888-405-4039.
The .REV file is available in report format and does
not require an import.
The taxes calculated on this report will be based on
the effective sales tax rate of the county in which
the customers resides. These reports are the basis
of tax payments to the state.
April 2014
Columbia Gas of Ohio Choice/SCO Reference Manual
99
.REV File Format - RS5600T3-1
April 2013
April 2014
Columbia
of Choice/SCO
Ohio Choice/SCO
Columbia GasGas
of Ohio
Reference Manual
Reference Manual
100
100
Solicitation List Layout
Columns 1-33
•
Customer Name
Columns 162-163
•
Revenue Class
Columns 34-66
•
Service Address
Columns 164-165
Columns 67-86
•
Service Address City
Columns 166-169
•
•
Columns 87-88
•
Service Address State
Columns 89-97
•
Service Address Zip + 4
Unit Out
Revenue Cycle Year
Columns 170-171
•
Revenue Cycle Month
Columns 172-180
•
Columns 98-130
•
Mailing Address
Monthly Consumption in Ccf
Columns 181-184
Columns 131-150
•
Mailing Address City
Columns 151-152
•
Mailing Address State
Columns 153-161
•
Mailing Address Zip + 4
April 2014
•
Revenue Cycle Year
Columns 185-186
•
Revenue Cycle Month
Columns 187-195
•
Monthly Consumption in Ccf
Columbia Gas of Ohio Choice/SCO Reference
Manual
101
Solicitation List Layout (continued)
Columns 196-199
•
Revenue Cycle Year
Columns 241-244
Columns 200-201
•
Revenue Cycle Month
Columns 245-246
Columns 202-210
•
Monthly Consumption in Ccf
Columns 247-255
•
•
•
Columns 211-214
•
Revenue Cycle Year
Revenue Cycle Year
Revenue Cycle Month
Monthly Consumption in Ccf
Columns 256-259
•
Revenue Cycle Year
Columns 215-216
•
Revenue Cycle Month
Columns 260-261
Columns 217-225
•
Monthly Consumption in Ccf
Columns 262-270
•
•
Revenue Cycle Month
Monthly Consumption in Ccf
Columns 271-274
Columns 226-229
•
Revenue Cycle Year
•
Revenue Cycle Year
Columns 275-276
•
Revenue Cycle Month
Columns 230-231
•
Revenue Cycle Month
Columns 277-285
•
Monthly Consumption in Ccf
Columns 232-240
•
Monthly Consumption in Ccf
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
102
Solicitation List Layout (continued)
Columns 286-289
•
Revenue Cycle Year
Columns 331-334
•
Revenue Cycle Year
Columns 290-291
•
Revenue Cycle Month
Columns 335-336
Columns 292-300
•
Monthly Consumption in Ccf
Columns 337-345
•
•
Revenue Cycle Month
Monthly Consumption in Ccf
Columns 301-304
•
Revenue Cycle Year
Columns 305-306
•
Revenue Cycle Month
Columns 307-315
•
Monthly Consumption in Ccf
Columns 316-319
•
Revenue Cycle Year
Columns 320-321
•
Revenue Cycle Month
Columns 322-330
•
Monthly Consumption in Ccf
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
103
.XFR File Format
Provides information for customers whom elected to transfer
their existing CHOICE Contract to their new service address
within Columbia’s service territory.
Column 1:
•
Transfer Code
“1” - Preliminary Transfer Election
“D” - Deletion of Preliminary Transfer
Election (at the Customer’s request)
“A” - Final Completed Transfer
“R” - Final Rejected Transfer
The customer may elect or delete a ‘transfer’ at any time prior
to the connection of service at the new address.
Columns 2-11:
•
Transfer Activity Date (YYYY-MM-DD)
The file will contain both preliminary and final records;
preliminary records will be displayed first.
Columns 12-16 :
•
Marketer Rate Code
A .XFR file is produced daily, however it will be empty if
there is no activity to report.
Columns 17-24:
•
From- Customer PCID Number
Transfer requests can be rejected if the following condition is
true at connection:
•New premise consumption exceeds 5,999 Mcf and is not
identified as a Human Needs account.
Columns 25-27:
•
From- Customer PCID Sequence Number
The XXYYYYMMDD.XFR file, where XX reflects
the Supplier , YYYY reflects the year, MM reflects the
month, DD reflects the day.
NOTE:
This file will be provided only to suppliers who are
participating in contract portability service.
Column 28:
•
From- Customer Check Digit Number
Columns 29-38:
•
Connect Date (YYYY-MM-DD)
Columns 39-43:
•
New Marketer Rate Code (Final Record)
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
104
.XFR File Format (continued)
Columns 44-51:
•
New Customer PCID Number (Final Record)
Columns 52-54:
•
New Customer PCID Sequence Number (Final Record)
Column 55:
•
New Customer Check Digit Number (Final Record)
Columns 56-64:
•
New PSID Number
Columns 65-66:
•
New Billing Unit
Columns 67-99:
•
New Service Address
Columns 100-104:
•
Service City, State
Columns 105-117:
•
Zip Code Zip+4, Carrier Route
Columns 118-150:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
105
General SCO Program Information
Section 6
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
106
SCO Customer Eligibility
•
•
•
•
•
•
•
Is a customers using less than 6,000 Mcf per year
Is a Human Needs customer accounts using 6,000 Mcf or more per year
Is not 60 days past due or past due on a payment plan
Is not a PIPP (Percentage of Income Payment Plan) customer
Is not enrolled in the Transportation Service (TS)
Is not enrolled in Choice Program
Is not being served through Governmental Aggregation Program
NOTE;
New Customers/Transition Customers may be served under DSS for two billing cycles before the
customer is assigned to an SCO Supplier.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
107
SCO Customer and DSS Demand Allocations
Annual SCO Assignment
Monthly Allocation
Will occur in mid March after Choice
Enrollment window has closed for April
Processing.
Will occur each month after the Choice Enrollment
window has closed for the subsequent month.
Each SCO Supplier will initially be allocated
actual customers’ load and DSS Demand
based on the following:
1. Newly eligible SCO Customer Load
•
will be randomly assigned by PSP, based on
the number of tranches supplied by each SCO
Supplier.
1. SCO Customer Load
•
Revenue Class
•
Annual Demand
•
Geographical area (PSP)
•
Credit Ranking
2. DSS Customer Demand
•
Pro rata share of the total estimated DSS
Demand, by PSP, based on the number
of tranches supplied by each SCO
Supplier.
April 2014
Each SCO Supplier will be allocated actual SCO
customers’ load and DSS demand based on the
following:
2. DSS Customer Demand
•
Pro rata share of the total estimated DSS
Demand, by PSP, based on the number of
tranches supplied by each SCO Supplier.
Columbia Gas of Ohio Choice/SCO Reference
Manual
108
Maintenance of SCO Accounts
Section 7
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
109
SCO Timeline and Calendar
Date Period:
What to do/what to look for:
1st thru 15th calendar days
Enter 8 or 9 action codes in .DAT file and check returned files
Preliminary Accounting and Tax information for previous month (.DET file)
4th business day
RS5500 (.REV) placed on FTP by COH for previous month receivables
6th business day
Supplier is billed for prior month’s activity
15th calendar day
Final .DAT file for SCO Supplier due for next month’s flow (COH freezes file)
16th thru 19th calendar days
No .DAT file processing, .DAT file emptied for next processing cycle
20th thru 25th calendar days
Demand and Supply Curves are generated
Demand Curve files (.DMD) are placed on FTP by COH
.SAC1, .SAD and .SCON files are placed on FTP by COH
Enter 8 or 9 action codes in .DAT file and check returned files
Payment made to SCO Suppliers
.GAC2 & .GER2 files are placed on FTP by COH (for prior month)
26th thru end of month
Enter 8 or 9 action codes in .DAT file and check returned files
Accounts for 1st of month flow get coded as SCO in COH billing system
.SAC2 & .SER2 files are placed on FTP by COH
.OPT file is placed on FTP by COH
Annual SCO Assignment
In March, the .SAC2 and .SER2 will be generated daily for any accounts
processed for April in March due to the large amount of accounts being allocated.
-------------------------------------------------------------------------------------------------------------------------------TIME PERIOD
DAILY
By 5:00 PM each business day Upload .DAT files (except on non-processing dates)
By noon each business day
Returned and outbound files available (except on non-processing dates)
NOTES: If the 15th falls on a weekend or holiday, the .DAT file is due the previous business day.
ALL DATES AND TIMES ARE SUBJECT TO CHANGE.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
110
Set-up and Maintenance of Standard Choice Offer (SCO)
Accounts
This section describes how to set-up and maintain your SCO account information.
The .DAT file is used by SCO Suppliers to add, change or remove sales tax exemption percentages on existing or
pending SCO customers.
SCO customers will be easily identified with a unique Supplier code of XXC ZZ. This will be beneficial to those
Suppliers serving both SCO and Choice  accounts.
Using any text editor software available, such as WordPad or NotePad, create a file by entering the account
information in the .DAT file format provided on page 31.
The file must be saved as XXX.DAT. The XXX is the 3-digit Supplier code assigned by Columbia Gas.
When you have entered your account information, upload the file onto the Internet by the daily deadline shown on the
timeline/deadline calendar (5:00 p.m. EST).
A copy of a .DAT file must always remain in your directory. DO NOT delete the .DAT file from the web site.
The timeline/calendar included with these instructions gives an illustration of the different time restrictions involved with
your .DAT file.
On the deadline indicated in timeline/calendar (15th of the month), the file will be “frozen” with any enrollments, drops
and/or deleted accounts that you have added. (If the 15th of the month falls on a weekend or holiday, the previous
business day is the deadline).
An empty .DAT file will be placed in your directory the day following the freeze.
New accounts for the next processing cycle should be added after the date specified on the timeline. A new .DAT file
can be started on the 16th however, no processing of files will begin until the 20th of the month or the next business day
after if the 20th falls on a holiday or weekend.
SPECIAL NOTE: DO NOT USE ANY WORD PROCESSING SOFTWARE TO ENTER OR CHANGE ACCOUNTS, USE
THE RECOMMENDED TEXT EDITOR SOFTWARE, WORDPAD OR NOTEPAD.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
111
Reference Table/Daily and Monthly Files
Daily Files:
Monthly Files continued:
•
AC1 – Provides the accounts preliminarily accepted (action code 8 or 9
only) from the XXX.DAT file uploaded the previous business day
•
DET – Provides preliminary accounting and tax information
•
BIL – File providing the meter reading and adjustment information billed
by the Columbia billing system. File may be produced daily if Supplier
has accounts in each billing cycle
•
DMD – File containing required nomination/delivery information
for the current group of active customers
•
ER2 – Final error file showing errors and accounts that will not be
processed for action code 8 and 9
•
GAC2 –File showing the GAS/GMB accounts that will flow gas
the 1st of the month.
•
GER2 – Final error file showing errors and accounts for
GAS/GMB accounts that will not flow gas the 1st of the month
•
OPT – This file will be inclusive of all customers assigned to the
SCO Supplier for whom have elected to be excluded from the
Company’s solicitation list
•
REV – File provides the Supplier’s prior month billed revenues,
payment details and tax information where applicable.
•
SAC1 – Provides the accounts preliminarily accepted for SCO
from the monthly allocation
•
SAC2* – Files showing accounts that will flow gas the 1st of the
month
•
SAD - This file provides SCO customers service and mailing
address that can be used for welcome letters, sales tax
exemption notifications, ect. This list will be based on the
customers assigned in your .SAC1 file.
•
SCON – File with 24 months customer’s consumption of the
allocated accounts listed in .SAC1 file
•
SER2* – Final error file showing errors and accounts that will not
flow gas the 1st of the month
•
•
•
DAT – File for adding, changing or removing the sales tax exemption
percentage on existing or pending customers
DIS – Provides the Supplier with disconnected accounts (inactive/finaled
with Columbia Gas)
ERR - Errors that occurred (action code 8 and 9) from the XXX.DAT file
uploaded the previous business day
•
NOP – File that shows accounts that have received a pending
termination notice for non-payment or non-access to their meters
•
REC – Provides accounts that have rescinded their pending enrollment
with a Choice Supplier within the allowable 7-business day rescission
period
•
REM – Provides accounts that will be removed from Supplier’s
customer data base as a result of the customer electing to join the
Choice program
Monthly Files:
•
AC2 – File showing accepted accounts for action code 8 and 9
•
ACT -This file will provide all the established accounts for a Supplier as
of the date of the last .SAC2.
NOTE:
The .SAC2 and .SER2 will be generated daily for any accounts
processed for April in March due to the large amount of accounts being
allocated.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
112
Action Code Definitions
The following characters are to be used in the first column in the FTP site:
8
Indicates that a tax exemption percentage should be added or changed to an existing or
pending Choice account
9
Indicates that a tax exemption percentage should be removed from an existing or
pending Choice account
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
113
Audit/Error Code and Description
0010 CODE IS NOT VALID
•
Could not process record, invalid code (an
action code other than a 8 or 9 was
submitted)
0039 INVALID TAX % OR MISSING ‘E’ INDICATOR
•
Supplier can not add, change or remove
tax exemption information
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
114
.AC1/.SAC1 and .AC2/.GAC2/.SAC2 File
The .AC2, .GAC2 and .SAC2 files:
The .AC1 and .SAC1 files:
These two files provide preliminary accepted
accounts.
Do not assume that accounts showing in the
.AC1 and .SAC1 will be accepted in the final
.AC2, .GAC2 and .SAC2.
.AC1 files provides preliminary accepted
accounts for action codes 8 and 9 from the .DAT
file that was uploaded the previous business
day.
.SAC1 file provides preliminary accepted SCO
accounts from the monthly allocation process.
The XXXMMDDY. AC1/.SAC1files:
•
XX reflects the Supplier
•
X reflects the State
•
MM reflects the month
•
DD reflects the day
•
Y reflects the last digit of the year the
record is created
NOTE: When you begin building your new .DAT
file for the next billing cycle (on the 16th of the
month generally), you will not see the .AC1 file
until the 20th of the month when Columbia
begins processing files for the new billing cycle.
April 2014
These files provide all the accounts that were
accepted for the previous processing cycle. These
are the accounts that will flow gas the 1st of the
month, or their sales tax exemption will be effective.
.AC2 file provides all accounts that were accepted for
action code 8 and 9.
.GAC2 file provides all GAS/GMB accounts
.SAC2 file provides all the SCO accounts
The XXXMMDDY. AC2/.GAC2/.SAC2 files:
•
XX reflects the Supplier
•
X reflects the State
•
MM reflects the month
•
DD reflects the day
•
Y reflects the last digit of the year the record is
created.
NOTE: Keep in mind that the accepted accounts you see
in the .AC1/.SAC1 files may not be the same
accounts you see in the final .AC2, .GAC2 or .SAC2
file. It is possible that accounts you saw in your
.AC1/.SAC1 files may have been disconnected or
finaled between the time you saw them in the
.AC1/.SAC1 file and the time the final .AC2 .GAC2 or
.SAC2 file post.
Columbia Gas of Ohio Choice/SCO Reference
Manual
115
AC1/.SAC1 and .AC2/.GAC2/.SAC2 File Formats (continued)
Column 1:
•
Action Code
Columns 76-83:
•
Nomination Group Number
Columns 2-9:
•
Customer PCID Number
Columns 84-86:
•
Filler
Columns 10-12:
•
Customer Sequence Number
Columns 87-88:
•
Billing Unit
Column 13:
•
Customer Check Digit Number
Columns 89-91:
•
Filler
Columns 14-19:
•
Effective Date (YYYYMM)
Column 92:
•
Tax Exempt Code - Indicates if the account is
tax exempt.
Preliminary Acceptance File will always reflect
an “N”
Final Acceptance File will reflect an N or Y
Columns 20-31:
•
Rate Code and Discretionary
Supplier Information
Columns 32-39:
•
Filler
Columns 40-59:
•
Customer Last Name
Columns 93-95:
•
Tax Exempt Percentage
Preliminary Acceptance File = 000
Final Acceptance File = 010-100
Columns 60-71:
•
Customer First Name
Column 72:
•
Customer Middle Initial (if available)
Columns 73-75:
•
Filler
April 2014
Column 96
•
Filler
Columbia Gas of Ohio Choice/SCO Reference
Manual
116
.ACT File Format
The XXXMMDDY. ACT file, where XXX reflects the
Supplier and State, MM reflects the month, DD
reflects the day, and the Y reflects the last digit of the
year the record is created, provides information to the
Suppliers about customer’s accounts that are
established as of the date of the last billing SAC2.
This file can be used when building a customer
database or to verify the information contained in a
Supplier’s database.
For example, an .ACT file ran in the middle of a
month would contain all confirmed accounts
as of the previous billing cycle.
Please note there is a $0.015 cents per record with a
minimum charge of $55.00.
Columns 1-8:
•
Customer PCID Number
Columns 9-11:
•
Customer Sequence Number
Column 12:
•
Customer Check Digit Number
Columns 13-45:
•
Customer Name
Columns 46-78:
•
Service Address
Columns 79-99:
•
City
Columns 100-101:
•
State
Column 102:
•
Filler
Columns 103-112:
•
Zip Code plus 4
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
117
.ACT File Format (continued)
Column 113:
•
Hyphen
Columns 140-149:
•
Filler
Columns 114-117:
•
Postal Carrier Route
Column 150:
•
Filler
Columns 151-152:
•
Revenue Class Code
Columns 118-122:
•
Five-digit Supplier Code
Column 153-155:
•
Tax Exempt Percentage - if coded in
Columbia’s billing system will report with
leading zeros as a three digit number ( i.e.
10% will be reported as ‘010’ and 100% as
‘100’)
Columns 123-130:
•
Effective Date (YYYYMMDD)
Columns 131-138:
•
Nomination Group Number
Column 139:
•
Tax Exempt Code Added (Y-Yes or N-No)
• This indicates if the account is coded
in Columbia’s billing system as tax
exempt.
April 2014
Columns 156-157:
•
Billing Unit
Columbia Gas of Ohio Choice/SCO Reference
Manual
118
.ACT File Format (continued)
Columns 156-183:
•
Filler
Columns 184-217:
•
Mailing Street Address
Columns 218-249:
•
Mailing Street Address Overflow
•
(if necessary)
Columns 250-269:
•
Mailing City
Columns 270-271:
•
Mailing State
Column 272:
•
Filler
Columns 273-282:
•
Mailing Zip Code plus 4
Column 283:
•
Budget Customer Indicator “Y” or “N”
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
119
.BIL File Format
The XXXMMDDY. BIL file, where XXX reflects
the Supplier and State, MM reflects the
month, DD reflects the day, and the Y reflects
the last digit of the year the record is created,
Provides meter reading and adjustment
Information billed by the DIS system.
A file is produced daily, but may be empty if
the Supplier does not have accounts in each
billing unit.
.BIL Detail Record (11) - current
month billing information format
below:
Columns 1-2
•
Record-type (11)
Columns 3-10
•
System Creation Date
(YYYYMMDD)
April 2014
Columns 11-16:
•
Revenue Cycle (YYYYMM)
Columns 17-18:
•
Billing Unit for that day billing
Columns 19-22:
•
Location Number - Internal COH use
Columns 23-24:
•
Revenue Class
Columns 25-32:
•
Customer PCID Number
Columns 33-35:
•
Customer PCID Sequence Number
Column 36:
•
Check Digit Number
Columns 37-45:
•
Customer PSID Number
Columbia Gas of Ohio Choice/SCO Reference
Manual
120
.BIL Detail Record Format (continued)
Columns 46-78:
•
Customer Name
Columns 198-205:
•
Columns 79-111:
•
Customer Name Overflow
Columns 206-213:
•
Columns 112-144:
•
Service Address
•
Columns 179-185:
•
Taxing District
From – Read
To – Read
Columns 230-239:
Columns 186-193
Meter Number
•
Sign +/-
•
Usage by volume in Ccf
Columns 240:
•
Final Bill
•
Yes – Y, No – N
Columns 194-197:
April 2014
•
Columns 222-229
Columns 176-178:
•
FIPS County Code
•
To-Date (YYYYMMDD)
Columns 214-221
Columns 145-175:
•
Service City, State and Zip Code
•
From-Date (YYYYMMDD)
Meter AMR. Calculated or Read
Columbia Gas of Ohio Choice/SCO Reference
Manual
121
.BIL Detail Record Format (continued)
Column 241:
•
Rebill – Code
•
Yes – Y, No – N
Columns 290-299:
•
Sign +/•
Pay This Amount
Columns 242-251:
•
Sign +/•
Total Current Amount
Columns 300-304:
•
Supplier Rate Code
Columns 252-261:
•
Sign +/•
Total Current Tax Exempt
Columns 262-269:
•
Sign +/•
Sales Tax
Columns 270-279:
•
Sign +/•
Previous Balance
Columns 280-289:
•
Sign +/•
Total Account Balance
April 2014
Columns 305-310:
•
Sign +/•
SCO Rate
Columns 311-316:
•
Filler
Columns 317-326:
•
Sign +/•
Previous Gas Cost Balance
Columns 327-336:
•
Sign +/•
Current Gas Cost Charges
Columbia Gas of Ohio Choice/SCO Reference
Manual
122
.BIL Detail Record Format (continued)
Columns 337-346:
•
Sign +/•
Current Gas Cost Balance
Columns 436-445:
•
Sign +/•
Delayed Payment Penalty
Columns 347-396:
•
Filler
Columns 446-455:
•
Sign +/•
Filler
Columns 397-405:
•
Columbia Rate Schedule
Columns 406-415:
•
Sign +/•
Columbia Customer Charge
Columns 416-425:
•
Sign +/•
Columbia Transportation Charges
Columns 426-435:
•
Sign +/•
Supplemental Charges
Column 456:
•
Customer on Budget
•
Yes-Y, No-N
Columns 457-466:
•
Sign +/•
Gas Cost Budget Amount
Columns 467-476:
•
Sign +/•
Gas Cost Budget Arrears
Columns 477-486:
•
Sign +/•
Gas Cost Budget Balance
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
123
.BIL Detail Record Format (continued)
Columns 529-538:
•
Filler
Columns 487-496:
•
Sign +/•
Columbia Budget Amount
Column 539:
•
Filler
Columns 497-506:
•
Sign +/•
Columbia Budget Arrears
Columns 540-548:
•
Sign +/•
Columbia Service Partners charges
Columns 507-516:
•
Sign +/•
Columbia Budget Balance
Columns 549-557:
•
Sign +/•
Miscellaneous Revenue Accounting
charges
Columns 517-518:
•
Billing Unit of the account
Column 519:
•
Zipcheck Status Code
Columns 520-528:
•
Zipcheck Routing Transit Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
124
.BIL Adjustment Record File Format
.BIL Adjustment Record (15) - current month
adjustment information format below:
Columns 35-38:
•
Transaction – Type
Columns 1-2:
•
Columns 39-43:
Record – type (15)
•
Supplier Rate Code
Columns 3-6:
•
Columns 44-53:
Location
Columns 7-15:
•
•
Sign +/-
•
Columbia Transportation Charges
Customer PSID Number
Columns 54-63:
Columns 16-23:
•
Customer PCID Number
Columns 24-26:
•
Sign +/-
•
Gas Cost Amount (includes Sales Tax if
applicable)
Columns 64-71:
•
Adjustment Period Date (YYYYMMDD)
Customer Sequence Number
Columns 27-34:
•
•
Transaction – Date (YYYYMMDD)
Columns 72-81:
•
Sign +/•
Ccf
Column 82:
•
Check Digit Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
125
.BIL Adjustment Record File Format (continued)
Columns 83-92:
•
Filler
Column 93:
•
Filler
Columns 94-539:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
126
.BIL Detail Record File Format
.BIL Detail Record (9) - current month balance
record information format below:
Columns 1-9:
Balance Record Indicator (all nines)
Gas Measurement Billing information is located in the
.BIL file following the .BIL Detail Record – current
month balance record information (in bold below).
Columns 10-15:
Sign +/Record Count
Columns 16-27:
Sign +/Total Account Balance (last two digits are
decimal $xxxxxxx.xx)
Columns 28-56:
Filler
Columns 57-58
Balance Record Indicator (all nines)
Columns 59-539:
Filler
Sign +/Transportation
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
127
.DAT File Format
The .DAT file is utilized by the Suppliers to add, delete or change an account on the FTP Web Site. Supplier
enters the Action Code in the first column followed by the account information which is included in columns 2
through 39 described on the next page. Files can be submitted daily up through the 15th of the month preceding
the effective flow date.
Example: to add, change or remove an accounts tax exemption percentage, the following transaction
would be submitted in the .DAT file:
8123456780012E085 XXCZZ
0000NNNN
The number 8 at the beginning of the PCID number is to add or change a customers sales
tax percentage.
9123456780012E000 XXCZZ
0000NNNN
The number 9 at the beginning of the PCID number is to remove the tax exemption on an
account.
NOTES:
A Supplier who is serving both Choice and SCO must submit an action code 1 or 3 for an existing SCO customer
who is moving to Choice.
The Supplier must start with a “clean” .DAT file after each enrollment period.
Columns = Spaces
.DAT FILE FORMAT:
Codes are “8”, “9” (see explanation of each below):
8 - Add or Change to customer’s sales tax exemption percentage
9 - Remove a customer’s sales tax exemption percentage
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
128
.DAT File Format (continued)
Column 1:
•
Action code (8 or 9 only)
Columns 2-9:
•
Enter the customer PCID (8 character)
Number
Columns 10-12:
•
Enter the customer SEQUENCE
•
(3 character) Number
Column 13:
•
Enter the customer CHECK DIGIT
•
(1 character) Number
Column 14:
•
Enter in a one character tax exempt
indicator
•
Valid code is ‘E’ or blanks
•
An ‘E’ indicates customer’s tax exempt
indicator should be set to true and works
with an account code ‘8’ only. An ‘E’ with
an action code of ‘9’ and ‘000’ for the
percentage indicates that the tax exempt
indicator should be set to false.
April 2014
Columns 15-17:
•
Enter the customer tax exempt percentage as a
number from ‘001’ to ‘100’ (must include leading
zeros). Enter ‘000’ if removing tax
Columns 18-19:
•
Filler (Leave blank)
Columns 20-31:
•
Enter in the 12 digit control as the following:
•
Enter a 5-digit Supplier rate code in the first 5
positions
•
The first 3 characters are the Supplier code and
the last two characters are the rate number
•
The next 7 characters are not required and can
be used by the Supplier at their own discretion
Columns 32-39:
•
Enter eight digit Nomination Group number
(precede with zeros)
Columbia Gas of Ohio Choice/SCO Reference
Manual
129
.DET File Format Layout
The XXMMYY.DET file where XX reflects the
Supplier, MM reflects the month, YY year the
record was created.
The .DET file is the Supplier ‘s monthly billed
revenue, adjustments and summary detail.
There are Three (3) record types that can be
in each file:
1.
2.
3.
Detail record (type = 1)
Adjustment detail record (type = 2)
Control total record (type = 3)
NOTES:
•
Total Mcf = Current Month Mcf + Adjusted Mcf)
•
Total Gas Cost = (Current Month Gas Cost +
Adjusted Gas Cost)
•
Total tax = (Current Month State Tax + Adjusted
State Tax )
•
Grand total = (Total Gas Cost + Total State Tax)
•
Values for the Revenue-class are:
•
R = residential
•
C = commercial
•
I = industrial
April 2014
Detail Record Codes
All numeric fields are defined as signed
unpacked numbers. This allows us to retain
negative values in the numeric fields.
A conversion chart of values for signed
unpacked numbers are below:
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I = 9
{ =0
Columbia Gas of Ohio Choice/SCO Reference
Manual
J = -1
K = -2
L = -3
M = -4
N = -5
O = -6
P = -7
Q = -8
R = -9
} = -0
130
.DET File - Detail Record Format Layout (continued)
Detail Record:
Column 1:
•
Record Type 1
Columns 2-3:
•
Company
Columns 4-14:
•
PCID – Sequence No
Column 15:
•
PCID CK Digit number
Columns 16-20:
•
Supplier Rate Code
Columns 21-23:
•
County Code
Columns 34-42:
•
Adjusted Mcf
Columns 43-51:
•
Total Mcf
Columns 52-60:
•
Current Month Gas Cost
Columns 61-69:
•
Adjusted Gas Cost
Columns 70-78:
•
Total Gas Cost
Columns 79-87:
•
Current Month State Tax
Column 24:
•
Revenue Class
Columns 88-96:
•
Adjusted State Tax Adjustment
Columns 25-33:
•
Current month Mcf
Columns 97-107:
•
Total state tax
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
131
.DET File - Detail Record Format Layout (continued)
Columns 108-118:
•
Grand Total
Columns 119-126
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
132
.DET File - Adjustment Detail Record Format Layout
Adjustment Detail Record
Column 1:
•
Record Type 2
Columns 2-3:
•
Company
Columns 4-14:
•
PCID – Sequence No
Column 15:
•
PCID CK Digit number
Columns 16-20:
•
Supplier Rate Code
April 2014
Columns 21-26:
•
Adjustment Date
Columns 27-35:
•
Adjusted Mcf
Column 36-44:
•
Adjusted Gas Cost
Column 45-126:
•
Filler
Note: Adjustment date = DDYYMM
Columbia Gas of Ohio Choice/SCO Reference
Manual
133
.DET File - Control Total Record Format Layout
Control Total Record
Column 1:
•
Record Type 3
Columns 52-60:
•
Current Month gas cost
Columns 2-3:
•
Company
Columns 61-69:
•
Adjusted Gas Cost
Columns 4-15:
•
Filler
Columns 70-78:
•
Total Gas Cost
Columns 16-20:
•
Supplier Rate Code
Columns 79-87:
•
Current Month State Tax
Columns 21-24:
•
Filler
Columns 88-96:
•
Adjusted State Tax
Columns 25-33:
•
Current Month Mcf
Columns 34-42
•
Adjusted Mcf
Columns 43-51:
•
Total Mcf
April 2014
Columns 97-107:
•
Total State Tax
Columns 108-118:
•
Grand Total
Columns 119-126:
•
Filler
Columbia Gas of Ohio Choice/SCO Reference
Manual
134
.DIS File Format
The .DIS file shows the customers who have
been disconnected and are inactive in our
billing system.
The XXXMMDDY.DIS file where XXX reflects
the Supplier and State, MM reflects the
month, DD reflects the day, and the Y reflects
the last digit of the year the record was
created. This provides information to the
Suppliers about accounts that have been
removed from COH service for various
reasons.
Upon receiving an account in this file, the
Supplier should check with the customer to
validate activity on the account.
The customer has taken one or more of the
following actions:
•
re-established an account at a new
address
•
changed ownership
•
moved out of the Columbia service
territory
The .DIS file reflects service changes and should not
be confused with the .NOP file.
Columns 1-5:
•
Supplier Rate Code
Columns 6-7:
•
Company Number (i.e. 34 for Ohio)
Columns 8-11:
•
Location Number – An internal Columbia
tracking number based on the Area Office
that serves the customer
Columns 12-19:
•
Customer PCID number
Columns 20-22:
•
Customer PCID Sequence Number
Column 23:
•
Customer Check Digit Number
All the above would cause the customer to be
disconnected on our system.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
135
.DIS File Format (continued)
Columns 24-32
•
Customer PSID Number
Columns 33-34:
•
Unit Number (The unit of the billing cycle)
Columns 35-36:
•
Book Number (The book for the billing
cycle)
Columns 81-88:
•
Customer Activity Date (YYYYMMDD) =
Date COH processed the order in our
system
Columns 89-92:
•
Customer Activity Type
(The transaction code from the COH
billing system, internal use)
Column 37:
•
Account Status Code
Columns 38-45:
•
Disconnect Date (YYYYMMDD) = Date
account became inactive
Columns 46-47:
•
Revenue Class Code
Columns 48-80:
•
Customer Name
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
136
.DMD File - Steps to Import Into Excel
The XXXMMDDY. DMD file, where XXX reflects the
Supplier and State, MM reflects the month, DD reflects
the day, and the Y reflects the last digit of the year the
record is created. To import the .DMD comma delimited
file into Excel do the following steps:
•
•
•
•
•
•
•
•
•
Move the .DMD file to your hard drive
Open Excel
Open the .DMD file – Should bring up the Import
Wizard
Import Wizard – Step 1
•
Radial Button – Delimited (Default)
•
Select Next
Import Wizard – Step 2
•
Delimiters – Select Comma
•
Remove any other selected Delimiters
Select Next
Import Wizard – Step 3
Column Data Format
•
Select Text
Select Finish
File should now be in a spreadsheet format.
Save the file.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
137
Demand Curves
•
Report 1 Calendar Month Report provides the normalized volumetric information for the current group of
customers based on their actual historical consumption. Volumes on this report are increased for retainage
and decreased for customer attrition. The volumes have not been reduced by the Local Gas Purchase
Percentage.
•
Report 2 Billing Month Report provides the normalized billing month volumetric information based on
actual historical information. Columbia bills the customer on billing cycles and Suppliers deliver on calendar
months. This report reflects that difference. Volumes on this report are increased for retainage and
decreased for customer attrition. The volumes have not been reduced by the Local Gas Purchase
Percentage.
•
Report 3 Dth Summary Report provides number of customers, operational information, and daily and
annual volumes. Bal Type = N indicates non-temperature balancing or Bal Type = F indicates full balancing
for Co-Operatives.
•
Report 4 Nom Group Dth Curve Report shows daily delivery volumes by temperature. The balance point
temperature is 54 degF. Volumes on this report have been reduced by the Local Gas Purchase Percentage.
Note: The volumes on all reports include unaccounted-for volumes, hence they represent volumes at the city gate.
Report 3 shows the unaccounted-for factor.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
138
SCO Demand Curves Report 1
Report 1. Normalized Dth Calendar Months
Company
Id
34
34
34
34
34
34
34
34
34
34
34
34
Cust
Type
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
Mktr
Id
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
PSP
2223-1
23-3
23-4
23-5
23-6
23-8
23-9
23N-2
23N-7
24-35
24-39
Nom
Group
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
Bal
Type
N
N
N
N
N
N
N
N
N
N
N
N
Total
2010-03
27576
379453
62333
73834
769403
330474
174243
111467
275492
119371
58373
1492
2010-04 2010-05 2010-06 2010-07 2010-08 2010-09 2010-10 2010-11 2010-12 2011-01 2011-02
10671
4342
3334
3445
3445
3497
9804
24530
46733
57005
41998
178749
73278
47889
49486
49486
55403 146535 302722 527219 628651 503020
29263
11915
7640
7895
7895
8835
22890
49474
87868 105036
83083
36257
16123
10318
10662
10662
11684
28534
58225 100890 120500
95515
350600 158110 121559 125611 125611 130845 289654 644640 1145464 1383791 1072952
147654
63627
48084
49687
49687
52067 121377 275104 497752 597986 459753
79571
34100
23980
24780
24780
26643
65724 141820 254135 304067 236757
49255
20338
14170
14642
14642
15993
41070
91630 165462 197812 152426
138373
59655
37156
38395
38395
40854
95243 200767 362843 438178 352195
59121
25069
15366
15878
15878
17164
41652
88291 157932 190698 152999
26280
10505
6569
6788
6788
7583
22106
46553
83264 100271
77989
722
308
190
196
196
218
563
1172
2046
2448
1938
2383511 1106516
477370
336255
347465
347465
370786
Annual
Calendar Mktr
Dth
Name
236379 ZZ
2941890 ZZ
484127 ZZ
573206 ZZ
6318240 ZZ
2693253 ZZ
1390601 ZZ
888907 ZZ
2077547 ZZ
899417 ZZ
453070 ZZ
11489 ZZ
885152 1924928 3431608 4126443 3230625 18968126
Report 1. Normalized Dth Calendar Months
Company
Id
34
34
34
34
34
34
34
34
34
34
34
34
Cust
Type
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
Mktr
Id
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
PSP
2223-1
23-3
23-4
23-5
23-6
23-8
23-9
23N-2
23N-7
24-35
24-39
Nom
Group
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
Bal
Type
N
N
N
N
N
N
N
N
N
N
N
N
Total
April 2014
2010-03 2010-04 2010-05 2010-06 2010-07 2010-08 2010-09 2010-10 2010-11 2010-12 2011-01 2011-02
3538
1334
506
377
389
389
398
1219
3142
6037
7378
5425
79658 37080
14660
9299
9609
9609
10894
30212
63398 111027 132561 105977
8143
3754
1445
881
911
911
1040
2903
6439
11535
13816
10913
11067
5286
2172
1288
1331
1331
1498
4085
8671
15237
18259
14438
59886 27094
12004
9153
9458
9458
9880
22307
50126
89343 108011
83700
26088 11438
4685
3452
3567
3567
3771
9317
21660
39505
47544
36497
21338
9536
3847
2597
2684
2684
2930
7794
17305
31310
37542
29180
15761
6739
2525
1643
1698
1698
1908
5536
12893
23603
28301
21751
23848 11948
5113
3162
3267
3267
3483
8202
17364
31430
37970
30512
17980
8812
3621
2150
2222
2222
2424
6146
13254
23851
28841
23119
12358
5508
2136
1299
1342
1342
1516
4613
9837
17673
21304
16557
123
58
23
13
13
13
15
44
96
170
204
161
279788 128587
52737
35314
36491
36491
39757
Columbia Gas of Ohio Choice/SCO Reference
Manual
102378
224185
400721
481731
Annual
Calendar Mktr
Dth
Name
30132 ZZ
613986 ZZ
62688 ZZ
84663 ZZ
490419 ZZ
211092 ZZ
168747 ZZ
124056 ZZ
179567 ZZ
134642 ZZ
95485 ZZ
932 ZZ
378230 2196409
139
SCO Demand Curves Reports 2
Report 2. Normalized Dth Billing Months
Company
Id
34
34
34
34
34
34
34
34
34
34
34
34
Cust
Type
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
SCO
Mktr
Id
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
PSP
2223-1
23-3
23-4
23-5
23-6
23-8
23-9
23N-2
23N-7
24-35
24-39
Nom
Group
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
Bal
Type
N
N
N
N
N
N
N
N
N
N
N
N
Total
2010-03
35073
465972
76173
89006
968963
386970
211558
138812
325843
144188
71147
1786
Annual Mktr
2010-04 2010-05 2010-06 2010-07 2010-08 2010-09 2010-10 2010-11 2010-12 2011-01 2011-02 Billing Dth Name
17994
6616
3977
3578
3175
3387
5485
14688
35914
55124
51367
236379 ZZ
290490
128198
62269
52428
46303
46931
78298
181647
397273
603917
588163 2941890 ZZ
47926
20703
9807
8241
7467
7531
12087
28809
65210
101811
98363
484127 ZZ
57028
26525
13679
11383
9862
10140
15757
35275
75427
115976
113149
573206 ZZ
573423
253097
147631
131773
120335
117634
169106
377755
856798 1314893 1286832 6318240 ZZ
211369
89564
59729
51371
47738
47148
79252
185375
416237
583263
535238 2693253 ZZ
125535
54122
29279
25859
23073
24008
37630
87839
194911
295207
281580 1390601 ZZ
83162
35133
17930
15267
13690
14144
21863
53304
122146
189775
183682
888907 ZZ
210410
98556
51742
42304
35259
35454
53699
122845
271966
419099
410370 2077547 ZZ
95054
44364
21335
17164
14966
14607
22038
50717
113833
181809
179342
899417 ZZ
43197
18003
8579
7165
6373
6444
11280
28412
62809
96585
93075
453070 ZZ
1173
535
245
201
188
189
284
671
1552
2371
2294
11489 ZZ
2915491 1756761
775416
426202
366734
328429
327617
506779
1167337
2614076
3959830
3823455 18968126
Report 2. Normalized Dth Billing Months
Company
Id
34
34
34
34
34
34
34
34
34
34
34
34
Cust
Type
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
DSS
Mktr
Id
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
PSP
2223-1
23-3
23-4
23-5
23-6
23-8
23-9
23N-2
23N-7
24-35
24-39
Nom
Group
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
Bal
Type
N
N
N
N
N
N
N
N
N
N
N
N
Total
April 2014
Annual Mktr
2010-03 2010-04 2010-05 2010-06 2010-07 2010-08 2010-09 2010-10 2010-11 2010-12 2011-01 2011-02 Billing Dth Name
4708
2468
873
464
409
362
375
627
1711
4338
7062
6736
30132 ZZ
96759 59116
25096
12384
10586
8781
8919
16259
38859
84800
128667
123760
613986 ZZ
9687
5874
2349
1139
950
855
876
1586
3965
8878
13662
12868
62688 ZZ
12756
7577
3321
1799
1415
1235
1268
2448
5737
12357
18131
16619
84663 ZZ
73957 43166
18806
11739
9947
8907
8986
12962
29887
67011
105085
99966
490419 ZZ
32076 18078
7665
4596
3752
3371
3377
5563
13216
30616
45496
43287
211092 ZZ
26277 15691
6498
3381
2873
2468
2558
4163
10282
23274
36358
34924
168747 ZZ
19307 11220
4411
2204
1782
1579
1637
2904
7604
17723
27558
26127
124056 ZZ
27951 18123
8327
4456
3655
2990
2972
4605
10670
23508
36752
35558
179567 ZZ
21202 13519
6118
3010
2420
2038
2082
3372
8032
17943
28094
26812
134642 ZZ
14798
8843
3555
1726
1433
1236
1282
2425
6155
13684
20728
19620
95485 ZZ
149
97
43
18
14
14
11
20
52
126
198
192
932 ZZ
339627 203772
87062
46916
39236
33836
34343
Columbia Gas of Ohio Choice/SCO Reference
Manual
56934
136170
304258
467791
446469
2196409
140
SCO Demand Curves – Report 3
Report 3. Combined Dth Summary (CHO+SCO+DSS)
Annual
Prior 12
Normal
Attrition
Months Calendar
Num Cust Factor BTU Factor Actual Dth
Dth
Peak
Design
Temp
Peak
Demand
Dth
Over
/Under
Delivery %
Over
/Under
Delivery
Dth
Weather
Daily Dth
Adjust
Daily Like
In Kind
Adjust
Demand
Curve
Plateau
Dth
Company
Id
Cust
Type
Mktr Id
PSP
Nom
Group
Bal
Type
34
ALL
ZZ
22-
xxxx
N
3365
1.034
292527
266510
0
4533
0
0
0
0
3266
PORTSMOUTH
ZZ
34
ALL
ZZ
23-1
xxxx
N
32395
1.034
3478661
3555875
-7
45051
0
0
0
0
32459
TOLEDO
ZZ
34
ALL
ZZ
23-3
xxxx
N
5669
1.034
550791
546814
-8
7393
0
0
0
0
5327
LIMA
ZZ
34
ALL
ZZ
23-4
xxxx
N
6404
1.034
667256
657868
-7
8466
0
0
0
0
6100
ALLIANCE
ZZ
34
ALL
ZZ
23-5
xxxx
N
76405
1.034
6988061
6808659
-6
97055
0
0
0
0
69928
COLUMBUS
ZZ
34
ALL
ZZ
23-6
xxxx
N
31362
1.034
2954827
2904346
-7
41562
0
0
0
0
29945
DAYTON
ZZ
34
ALL
ZZ
23-8
xxxx
N
15988
1.034
1603516
1559348
-6
21518
0
0
0
0
15504
MANSFIELD
ZZ
34
ALL
ZZ
23-9
xxxx
N
11674
1.034
1069568
1012962
-4
14574
0
0
0
0
10500
OH MISC
ZZ
34
ALL
ZZ
23N-2
xxxx
N
20682
1.034
2204292
2257114
-6
28908
0
0
0
0
20829
PARMA
ZZ
34
ALL
ZZ
23N-7
xxxx
N
9393
1.034
1010553
1034059
-6
12994
0
0
0
0
9362
SANDUSKY
ZZ
34
ALL
ZZ
24-35
xxxx
N
5855
1.034
562481
548555
-5
7706
0
0
0
0
5552
PITTSBURGH
ZZ
34
ALL
ZZ
24-39
xxxx
N
131
1.034
12655
12422
-7
162
0
0
0
0
117
NEW CASTLE
ZZ
0
0
208888
Total
April 2014
219323
21395188 21164532
289922
Columbia Gas of Ohio Choice/SCO Reference
Manual
PSP Name
141
Mktr Name
Choice/SCO Demand Curves – Report 4
This slide only shows a sample of one PSP for 54 – 32 degrees
Report 4. Nom Group Dth Curves Combined (CHO+SCO+DSS)
The Daily Delivery Dth volumes include like-in-kind adjustment.
Company Cust
Id
Type
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
34
ALL
April 2014
Mktr
Id
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
PSP
2222222222222222222222222222222222222222222222-
Daily
NomGro
Delivery
up
Temp
Dth PSP Name
xxxx
54
221 PORTSMOUTH
xxxx
53
299 PORTSMOUTH
xxxx
52
375 PORTSMOUTH
xxxx
51
452 PORTSMOUTH
xxxx
50
529 PORTSMOUTH
xxxx
49
606 PORTSMOUTH
xxxx
48
683 PORTSMOUTH
xxxx
47
759 PORTSMOUTH
xxxx
46
837 PORTSMOUTH
xxxx
45
913 PORTSMOUTH
xxxx
44
990 PORTSMOUTH
xxxx
43
1067 PORTSMOUTH
xxxx
42
1144 PORTSMOUTH
xxxx
41
1221 PORTSMOUTH
xxxx
40
1298 PORTSMOUTH
xxxx
39
1375 PORTSMOUTH
xxxx
38
1451 PORTSMOUTH
xxxx
37
1529 PORTSMOUTH
xxxx
36
1605 PORTSMOUTH
xxxx
35
1682 PORTSMOUTH
xxxx
34
1760 PORTSMOUTH
xxxx
33
1836 PORTSMOUTH
xxxx
32
1913 PORTSMOUTH
Columbia Gas of Ohio Choice/SCO Reference
Manual
Mktr
Name
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
ZZ
142
.ERR/.ER2/.GER2 & .SER2 Files
The .ER2, .GER2 and .SER2 files:
The .ERR file:
This file is an alert to correct any accounts
submitted incorrectly for action codes 8 and 9
from the previous business day.
The file reflects the accounts rejected from
the.DAT file that was uploaded the previous
business day.
Accounts that are re-submitted correctly, within
the processing cycle, will then be dropped off
the .ERR file and shows up on the .AC1 file.
The XXXMMDDY. ERR file:
•
XX reflects the Supplier
•
X reflects the State
•
MM reflects the month
•
DD reflects the day
•
Y reflects the last digit of the year the
record is created
NOTE: It is STRONGLY RECOMMENDED that
the .ERR file is reviewed daily in order to
maximize enrollment and minimize customer
complaints.
April 2014
These files provide the accounts that were rejected
from the monthly processing cycle, and will not flow
gas the 1st of the month, or change in sales tax
exemption percentage.
.ER2 file shows the rejected code 8 and 9 accounts
.GER2 file shows the rejected GAS/GMB accounts
.SER2 file shows the rejected SCO accounts
The XXXMMDDY. ER2/.GER2/.SER2 files:
•
XX reflects the Supplier
•
X reflects the State
•
MM reflects the month
•
DD reflects the day
•
Y reflects the last digit of the year the record is
created.
Additional Information:
The .ERR, .ER2, .GER2 & .SER2 files provide a total
number of accounts at the bottom of the file
processed from the .DAT file.
Columbia Gas of Ohio Choice/SCO Reference
Manual
143
.ERR/.ER2/.GER2 & .SER2 File Formats (continued)
Columns 71-110:
•
Audit Error Description (see Audit/Error
Codes and Descriptions)
Column 1:
•
Action code
Columns 2-6:
•
Supplier Number (Rate Code)
Columns 7-39:
•
Supplier Name
Columns 113-114:
•
Old Revenue Class
Columns 40-47:
•
Customer PCID Number
Columns 115-126:
•
Customer First Name
Columns 48-50:
•
Customer Sequence Number
Column 51:
•
Customer Check Digit Number
Columns 52-60:
•
Customer PSID Number
Column 127:
•
Customer Middle Initial
Columns 128-147:
•
Customer Last Name
Columns 148-180:
•
Service Address
Columns 61-66:
•
Effective Date (YYYYMM)
Columns 67-70:
•
Audit Error Code (see Audit/Error Codes
and Descriptions)
April 2014
Columns 111-112:
•
Current Revenue Class
Columns 181-219:
•
Service City, State, Zip+4, Carrier Route
Columbia Gas of Ohio Choice/SCO Reference
Manual
144
.ERR/.ER2/.SER2 & .GER2 File Formats (continued)
Columns 220-231:
•
Customer Home Phone
Columns 232-243:
•
Customer Business Phone (if available)
Columns 244-247:
•
Business Phone Extension (if available)
Columns 248-257:
•
Date Processed (YYYY-MM-DD)
Columns 258-259:
•
Company Number
Column 260:
•
Filler
Columns 261-272:
•
12 digit control code
(5 character Supplier code & 7 discretionary characters)
Columns 273-276:
•
Standard Industrial Code (Classification)
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
145
.NOP File Format
The XXXMMDDY. NOP file, where XXX reflects
the Supplier and State, MM reflects the month,
DD reflects the day, and the Y reflects the last
digit of the year the record is created, provides
information to the Suppliers about customer’s
accounts that have been issued a pending
termination notice for non-payment or nonaccess to their meter.
Upon receiving an account in this file the
Supplier could contact the customer to make
sure that the customer stays current on the
account in order to avoid termination of service
due to non-payment.
Columns 1-5:
•
Supplier Rate Code
Columns 6-7:
•
Company Number (34 for Ohio)
Columns 8-11:
•
Location Number - An internal
Columbia tracking number based on
the Area office that serves the
customer.
Columns 12-19:
•
Customer PCID Number
Columns 20-22:
•
Customer PCID Sequence Number
Column 23:
•
Customer Check Digit Number
Columns 24-32:
•
Customer PSID Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
146
.NOP File Format (continued)
Columns 33-34:
•
Unit Number (The unit of the billing cycle)
Columns 35-36:
•
Book Number (The book of the unit for the
billing cycle)
Column 37:
•
Account Status Code
Columns 89-94:
•
CCTNNP – customer receives a 14-day
disconnection notice for non-payment of
arrears or
•
CCTNFA – customer receives a 14-day
disconnection notice for failure to grant
Columbia access to the meter for a 12
month period or longer
Columns 95-99:
•
Five digit Supplier Rate Code
Columns 38-45:
•
Filler (zeros)
Columns 100-107:
•
Filler (zeros)
Columns 46-47:
•
Revenue Class Code
Note:
Columns 48-80:
•
Customer Name
Account Status Codes
Code
Description
Columns 81-88:
•
Date of Transaction (YYYYMMDD) – Date
the notice of termination occurred
B
C
D
F
V
Active Account
Active Delinquent
Active Account, Shut Off For Non Pay
Final, Actual Read
Active Account, Shut Off for Access
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
147
.OPT File Format
The XXXXXMMDDY. OPT file, where XXXXX reflects
the Supplier SCO rate code, MM reflects the month,
DD reflects the day, and the Y reflects the last digit of
the year the record is created, provides customers
assigned to the SCO Supplier for whom have elected
to be excluded from the Company’s solicitation list
Columns 46-78:
•
Service Address
Columns 1-8:
•
Customer PCID Number
Columns 110-114:
•
Supplier Rate Code
Columns 79-109:
•
Service City, State, Zip+4
Columns 9- 11:
•
Customer Sequence Number
Column 12:
•
Customer Check Digit Number
Columns 13-45:
•
Customer Name
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
148
.REC File Format
The XXXMMDDY.REC file, where XXX reflects the
Marketer and State, MM reflects the month, DD
reflects the day, and the Y reflects the last digit of the
year the record is created provides all the accounts
that have rescinded their pending enrollment with the
natural gas supplier within the allowable 7-business
day rescission period.
The accounts listed in the .REC file will be deleted
from the pending enrollment table and will not be
confirmed in the. AC2.
Columns 10-12:
•
Customer Sequence Number
Column 13:
•
Customer Check Digit Number
Columns 14-19:
•
Filler
Columns 20-24:
•
Marketer Rate Code
Please use the .REC file to update your database.
Column 1:
•
Code will be ‘C’ indicating the account has
rescinded their pending enrollment or code
“N” indicating account remains with
previous Marketer
Columns 25-31:
•
Filler
Columns 32-39:
•
Nomination Group
Columns 2-9:
•
Customer PCID Number
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
149
.REM File Format
The XXXMMDDY. REM file, where XXX reflects
the Supplier and State, MM reflects the month,
DD reflects the day, and the Y reflects the last
digit of the year the record is created, provides all
the accounts that will be removed from the
natural gas supplier's customer base as a result
of the customer's election to join the Choice
program.
The accounts listed in the .REM file will be
removed from the current supplier and enrolled
with the new natural gas supplier.
Column 1:
•
Code will be ‘2’ or ‘S’ indicating the account
will be removed from the current Supplier
Columns 2-9:
•
Customer PCID Number
Columns 10-12:
•
Customer Sequence Number
Column 13:
•
Customer Check Digit Number
Columns 14-19:
•
Effective Date (YYYYMM)
Columns 20-24:
•
Supplier Rate Code
Columns 25-31:
•
Filler or 7 discretionary characters entered
in Supplier .DAT File
Columns 32-39:
•
Filler
Columns 40-59:
•
Customer Last Name
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
150
.REM File Format (continued)
Columns 60-71:
•
Customer First Name
Column 72:
•
Customer Middle Initial (if available)
Column 92:
•
Tax Exempt Code Added (Y-Yes or N-NO)
• This indicates if the account is coded
in Columbia’s billing system as tax
exempt.
Columns 73-75:
•
Filler
Column 93-96:
•
Filler
Columns 76-83:
•
Nomination Group Number
Columns 97-132:
•
Removal Type:
• GENERATED REMOVAL - indicates
that an account has enrolled in the
Choice Program.
Columns 84-86:
•
Filler
Columns 87-88:
•
Billing Unit
Columns 89-91:
•
Filler
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
151
.REV File Format - RS5500SK
The XXXMKMMY.REV file, where XXX in the name of
the file is an abbreviated three-digit code to identify
the Supplier and State, MK reflects the report name,
MM reflects the month and Y reflects the last digit of
the year the record is created.
This report provides the Supplier’s prior month billed
revenue. The report provides details by Supplier
rate code as well as a summary page.
A Supplier who participates in the Company’s
Accounts Receivable Purchase program (POR), the
report provides detail on the purchased receivables
and the supplier payment .
Total Supplier payment is the payment amount prior
to any offsetting, that will be made to the Supplier
on the 25th of each month.
Note: The following are examples of offsets to
Supplier payments: .ACT/.ACF file request charges,
billing rate changes in excess of allowable number,
local gas purchase charges, demand/supply curve
non-compliance charges, balancing charges, or any
other miscellaneous charges. Your monthly GTS
invoice will reflect these charges.
NOTE: IF YOU ARE A SUPPLIER PARTICIPATING
IN CHOICE AND SCO, YOU WILL RECEIVE THE
RS5500MK AND RS5500SK REPORT.
The .REV file is available in report format and does
not require an import.
April 2014
Columbia Gas of Ohio Choice/SCO Reference Manual
152
.REV File Format - RS5500SK
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
153
.REV File Format –RS5600T3-1
RS5600T3-1 Supplier Sales Tax Report by
County
Further questions regarding sales tax responsibilities can be
directed to the Ohio States tax hotline at 1-888-405-4039.
The XXXTXMMY.REV file, where XXX in the name
of the file is an abbreviated three-digit code to
identify the Supplier and State, TX reflects the report
name, MM reflects the month and Y reflects the last
digit of the year the record is created.
The .REV file is available in report format and does not
require an import.
The taxes calculated on this report will be based on
the effective sales tax rate of the county in which
the customers resides. These reports are the basis
of tax payments to the state.
April 2014
Columbia Gas of Ohio Choice/SCO Reference Manual
154
.REV File Format - RS5600T3-1
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
155
155
.SAD File Format
The XXXXXMMDDY. SAD file, where XXXXX
reflects the Supplier SCO rate code, MM reflects the
month, DD reflects the day, and the Y reflects the
last digit of the year the record is created. This file
provides SCO customers service and mailing
address that can be used for welcome letters, sales
tax exemption notifications, etc. This list will be
based on the customers assigned in your .SAC1 file.
Columns 1-8:
•
Customer PCID Number
Columns 9- 11:
•
Customer Sequence Number
Column 12:
•
Customer Check Digit Number
Columns 13-45:
•
Customer Name
Columns 46-78:
•
Service Address
April 2014
Columns 79-98:
•
Service Address City
Columns 99-100:
•
Service Address State
Columns 101-105:
•
Service Address Zip
Columns 106-109:
•
Service Address Zip+4
Columns 110-142:
•
Mailing Address
Columns 143-175:
•
Mailing Address Overflow
Columns 176-195:
•
Mailing Address City
Columns 196-197:
•
Mailing Address State
Columbia Gas of Ohio Choice/SCO Reference
Manual
156
.SAD File Format (continued)
Column 198-202:
•
Mailing Address Zip
Columns 203-206:
•
Mailing Address Zip+4
Columns 207-211:
•
Supplier Code
Columns 212-213:
•
Revenue Class Code
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
157
.SCON File Format
The XXXMMDDY.CON file where XXX reflects the
Supplier and State, MM reflects the month, DD
reflects the day, and the Y reflects the last digit of the
year the record was created.
This file provides 24 months of consumption for the
accounts listed in the .SAC1 file.
Column 1:
•
Code 3
•
3 indicates 24 months of an
established Columbia SCO
account’s consumption history is to
be sent to the Supplier on the
.SCON file.
Columns 2-13:
•
Supplier Rate Code
April 2014
Columns 14-21
•
Customer PCID number
Columns 22-24:
•
Customer sequence number
Column 25:
•
Customer Check Digit Number
Columns 26-34:
•
Customer PSID number
Columns 35-586
•
24 Months Consumption
•
Each month has the following information:
• Revenue Cycle (YYYYMM)
• Meter Read Date (YYYYMMDD)
• Consumption (999999999) in Ccf
Columbia Gas of Ohio Choice/SCO Reference
Manual
158
Capacity and Delivery Requirement
Section 8
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
159
Pipeline Scheduling Point
Pipeline Scheduling Point (PSP)
Portsmouth (OH/KY Border)
Parma
Sandusky
Alliance
Dayton
Columbus
Pittsburgh (OH/PA Border)
Mansfield
Ohio Misc.
Toledo
Lima
New Castle (OH/PA Border)
April 2014
22
23N-2
23N-7
23-4
23-6
23-5
24-35
23-8
23-9
23-1
23-3
24-39
Columbia Gas of Ohio Choice/SCO Reference
Manual
160
Capacity
Capacity Allocation Process
•
If an SCO Supplier is also a CHOICE Supplier, Columbia will make a single capacity assignment by PSP
each month during the SCO period.
•
Capacity Allocated/Assigned on “Level Playing Field” Basis
•
Equal percentage levels of storage and FTS assigned to each PSP and equal percentage level of
Columbia provided Peaking Service provided in each PSP.
•
Equal percentage of Supplier provided firm capacity/supply for each PSP.
•
Percentages are identical for CHOICE and SCO.
•
Capacity Assignment based on Design Peak Day Demand
•
Capacity will be released for one month at a time.
•
Releases of Columbia Gas Transmission (TCO) capacity will be made by contract with releases to
multiple PSPs performed in single release whenever possible.
•
Suppliers may re-release the capacity assigned by Columbia subject to recall by Columbia. Releases
of assigned Panhandle capacity do not entitle any third party access to Columbia’s distribution system
unless such third party has specifically been named as an agent for the releasing Supplier for
purposes of meeting that Supplier’s Supply Curve requirements.
•
Any re-release of Tennessee capacity does not alter the Supplier’s responsibility to abide by the
delivery requirements of its Dungannon Supply Curve.
•
All costs associated with the released capacity will be paid directly to the pipelines by the
CHOICE/SCO Suppliers pursuant to applicable pipelines’ capacity release payment procedures.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
161
Capacity (continued)
Capacity Assignment
•
Columbia holds certain discounted contracts on Panhandle, Trunkline and Tennessee where the utilization
of unauthorized alternate points may cause Columbia to incur additional costs. Any costs incurred by
Columbia as a result of a Supplier or another party to which a Supplier has released the Columbia assigned
capacity utilizing an unauthorized alternate point shall be paid by the Supplier. Please see Tariff.
•
Columbia’s total contracted capacity and supply resources to be assigned and/or utilized in the Columbia
provided Peaking Service is determined annually after setting aside of TCO FTS and FSS/SST capacity to
provide certain services to TS Customers (Standby Service and Capacity Release).
•
Columbia will retain TCO FSS/SST to provide Standby Service to TS customers that sign up for the
service
•
Columbia shall retain some TCO FTS for release/assignment to TS customers.
•
Allocation steps followed by Columbia in determining the amount of assets to be assigned by PSP are as
follows:
•
Overall percentage of capacity Columbia shall assign including the peaking service will be up to 100%
of Suppliers peak day demand. For the 2013-2014 winter, Columbia assigned capacity will equate to
approximately 99% of the Supplier’s peak day demand. Supplier will be required to deliver
approximately 1% of it’s own capacity before peaking service is available.
•
Columbia will retain capacity equivalent to approximately 22% of peak day demand to provide NonTemperature Balancing Services for CHOICE/SCO Suppliers.
•
Columbia will assign approximately 53% of the peak day demand as storage.
•
For the PSP that includes the Maumee Gate the percentage of storage assignment shall
include Panhandle FS and TCO FSS.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
162
Capacity (continued)
Capacity Assignment continued
•
Columbia will assign approximately 17% of the peak day demand as FTS
•
Panhandle FTS will be included in the FTS assigned to the Toledo PSP
•
For the Alliance and Portsmouth PSPs, the TCO FTS assignment shall include Tennessee FT-A as
the upstream pipeline.
•
All other TCO FTS assigned shall also have Columbia Gulf FTS-1 assigned as the upstream pipeline.
•
•
Columbia will also retain the North Coast and Crossroads capacity.
Total capacity utilized by Columbia to provide peaking is approximately 29% of peak day demand.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
163
Capacity (continued)
Capacity Allocation Steps
•
Determination of the amount of storage Columbia will retain to provide Non-Temperature Balancing
Services for CHOICE/SCO Suppliers ( 22.12% of Stipulated Design Peak Day Demand of 2,037,600
Dth).
•
Determination of the percentage of peak day demand for each Demand Curve to be assigned as
storage. For the PSP that includes the Maumee Gate the percentage of storage assignment shall
include Panhandle Pipeline FS and TCO FSS. Current estimate is 49.7%.
•
Determination of the percentage peak day demand for each Demand Curve to be assigned as FTS.
For PSPs that include deliveries from Panhandle Pipeline or North Coast, the percentage of FTS
assignment shall include Panhandle Pipeline EFT and NCGT FT. For the Alliance and Portsmouth
PSPs, the TCO FTS assignment shall include Tennessee FT-A as the upstream pipeline. All other
TCO FTS assigned shall also have Columbia Gulf FTS-1 assigned as the upstream pipeline. Current
estimate is 19%.
•
To the extent that, under this methodology, Columbia is not able to assign all contracted FTS to
Suppliers, it will retain the excess as Operationally Retained Capacity and use such capacity in
providing its Peaking Service.
•
Columbia currently projects that it will retain as Operationally Retained capacity approximately
7,900 Dth of North Coast and related Crossroads capacity and 50,600 Dth of TCO FTS and
related Tennessee FT-A capacity.
•
Determination of the percentage of peak day demand for each Demand Curve to be provided as a
peaking service by Columbia. Local, Retained and Peaking is approximately 28% of Peak Day
Demand.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
164
Capacity (continued)
System Balancing
•
Columbia shall retain approximately 22% of the Peak Day Demand to provide System Balancing.
• Majority of the retained storage will be TCO FSS/SST to balance differences between
deliveries by Suppliers (Demand Curve requirements) with the actual demand of the
CHOICE/SCO and DSS customers.
• Small portion of retained storage will be Panhandle FS/EFT to balance Maumee Gate.
•
Columbia shall utilize the storage assets retained to provide balancing and to provide its non-firm Banking
and Balancing Service for its TS Customers.
• The daily balancing component of the non-firm Banking and Balancing Service will be reduced
or interrupted when the assets Columbia retained are required to provide CHOICE/SCO and
DSS balancing and/or peaking services.
• All Banking and Balancing fees collected by Columbia will be credited to the CSRR.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
165
Capacity (continued)
Storage Management
•
Based on Columbia’s historical planning practices the following minimum storage inventory levels are
recommended:
•
•
•
•
•
Nov. 1
Feb. 15
Mar. 5
Mar. 22
Apr. 1
98%
30%
20%
10%
2%
•
All CHOICE/SCO Suppliers have the sole responsibility to fill and manage the storage inventories of the
TCO FSS and Panhandle FS capacity assigned them on a monthly basis.
•
For the months of October through April, CHOICE/SCO Suppliers shall manage natural gas supply
nominations and deliveries to Columbia to match deliveries as specified by their individual Demand Curves
at the actual temperatures posted by Columbia through utilization of TCO FSS and SST capacity. Such
utilization shall generally consist of adjustments to their FSS/SST nomination at the end of the gas day such
that all confirmed supplies delivered to Columbia (including the FSS/SST nomination adjustment) in each
PSP match the specified Demand Curve volumes at the actual temperature as posted by Columbia.
•
Each CHOICE /SCO Supplier is solely responsible for ensuring that they have adequate injection or
withdrawal rights to match their Demand Curve obligations.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
166
Delivery Requirements
Daily Delivery Requirements
Columbia shall develop Demand Curves and Supply Curves for CHOICE/SCO Suppliers on an equivalent basis.
Demand Curves
Are based on Supplier’s customers' most recent 12 months of consumption adjusted to represent normal weather.
Customer counts and volumes are reduced by the current attrition percentage to account for attrition. Demand Curves
are posted on the columbiasuppliers.com website in a comma delimited format.
Main Points:
•
Flow gas by calendar month - Receive payment by billing month.
•
Expect more deliveries than collections October-January.
•
Increasing Apparent Gas Banks and Negative Cash Flow in the Fall.
•
Expect more collections than deliveries February-April.
•
Decreasing Apparent Gas Banks and Positive Cash Flow in the Spring.
•
Actual deliveries and collections affected by weather and Like-in-Kind adjustment.
•
Flow Adjusted Daily Average for the months May-September.
•
Flow according to Daily Temperature Demand Curve for the months October-April.
•
Demand Curves posted on or before the 20th of each month.
•
Deliveries based on 54-degree HDD.
•
Like-in-Kind adjustment is used to compensate both Columbia and the CHOICE Supplier for the difference
between the Flow month and the Billing cycles. This is only calculated for new gains and losses.
•
Demand curves show your customers' peak day consumption on Columbia's design peak day.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
167
Delivery Requirements (continued)
Failure to deliver according to the demand and supply curve requirements will result in Non-Compliance charges based
on the difference between confirmed volumes and required deliveries.
•
Non OFO/OMO days –A per Dth Non-Compliance Charge equal to the higher of a $10.00 or 150% times the
TCO Daily Index adjusted for SST commodity and shrinkage will be billed to the Supplier based upon the Dth
quantity difference between the Supplier’s daily Demand and/or Supply Curve requirement and the actual
pipeline daily confirmed volume delivered to Columbia, for each day of difference.
•
OFO/OMO day in place –A per Dth Non-Compliance Charge equal to the higher of a $30.00 or 150% times
the TCO Daily Index adjusted for SST commodity and shrinkage will be billed the Supplier based upon the
Dth quantity difference between the Supplier’s daily Demand and/or Supply Curve requirement and the actual
pipeline daily confirmed volume delivered to Columbia, for each day of difference.
•
In addition to the above Non-Compliance Charges, on days when Columbia incurs a penalty from an
upstream pipeline provider, CHOICE/SCO Suppliers that have failed to match deliveries to Columbia with
those specified by their Demand Curves and/or Supply Curves applicable to deliveries by the penalizing
pipeline, shall pay a proportionate share of the penalty costs incurred by Columbia.
•
Any Supplier that serves one or more Choice Aggregation Pools and also serves one or more SCO Tranches
must make a combined daily nominations for Choice and SCO. The combined nominations apply to both
Demand Curves and Supply Curves.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
168
Delivery Requirements (continued)
Supply curves
Are posted on Aviator on or before the 20th of each month. Supply Curves are developed based on the
operational requirements and/or ability of non-TCO points of delivery to accept supplies. Volumes scheduled into
COH based on a Supply Curve(s) can be allocated to Choice/SCO requirements, Transportation Service (TS)
customers, sold to a third party, or a combination.
•
•
•
•
•
Daily Supply Curve volumes allocated to Choice/SCO will be part of the Supplier’s daily Demand
Curve requirements for the PSP in which the Supply Curve is located.
Supply Curve required deliveries cannot be assigned to another party except when the Choice/SCO
Supplier has named an alternate Supplier as its agent for purposes of meeting the Supply Curve
delivery requirements.
Supply Curves provided to Supplier's assigned non-TCO capacity.
Failure to deliver according to the Supply Curves will result in the Supplier incurring a per Dth noncompliance charge to be paid to Columbia.
Non-compliance charges will be based on the difference between the Supply Curve required volumes
and the actual deliveries.
Maumee Gate:
•
Direct interconnect between Panhandle and COH.
•
Supply Curves provided for each Supplier assigned Panhandle /Trunkline pipeline capacity with a primary
delivery point at the Maumee Gate.
•
Supplies at the Maumee Gate are operationally required.
•
Required daily deliveries during months of November – March.
•
Deliveries through the Maumee Gate for April through October are not required and will not be accepted.
•
Flow according to Daily Temperature Supply Curve at the relevant forecasted temperature of the PSP for
the months November – March.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
169
Delivery Requirements (continued)
North Coast Gas Transmission Interconnects (NCGT):
•
Columbia Gas will retain all of NCGT capacity and utilize it as part of Columbia peaking service. This
option is no longer available to suppliers, effective April 1, 2013.
Dungannon Interconnect (Tennessee):
•
Interconnection between Tennessee and TCO.
•
Suppliers must schedule daily at a minimum the volume indicated by the Supply Curve at the forecasted
temperature.
•
Suppliers may deliver volumes in excess of the Supply Curves if acceptable to TCO.
•
Suppliers must schedule the Dungannon scheduled volumes on Navigates for delivery to the COH city
gate.
•
Deliveries may be scheduled at any city gate subject to TCO restrictions.
•
Deliveries via Tennessee (Dungannon) required Nov-March.
•
Supplies via Tennessee to TCO at Dungannon are operationally required.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
170
Balancing Services
Non-Temperature Balancing Service
•
The Company will provide Non-Temperature Balancing Services to Suppliers participating in the Choice
and SCO Program.
•
Non-Temperature Balancing Service provides supply for the difference between:
•
The actual demand of the Aggregation Pool and ;
•
The volume projected by the Demand Curve at the actual temperature experienced as provided by
Columbia on the day after the Gas Day.
•
Applicable to all volumes consumed by the following:
•
CHOICE customers under rate schedules FRSGTS, FRGTS, or FRLGTS; and
•
SCO and DSS Customers.
RATE
•
•
April 2014
A fixed fee of $.27 per Mcf will be charged directly to the customer. Each CHOICE Supplier is
required to ensure that the charge is not passed on to the CHOICE customers as an embedded
charge within the Supplier’s rate code, as to avoid the customers being charged twice for the
same service. Suppliers are required to execute an affidavit prior to April 1, 2013.
All costs incurred by Columbia to provide balancing, along with all balancing revenue received by
Columbia, will be charged/credited to the CHOICE/SCO Reconciliation Rider (CSRR).
Columbia Gas of Ohio Choice/SCO Reference
Manual
171
Balancing Services (continued)
Full Balancing Service
•
The Company will provide Full Balancing Services to Suppliers serving customers under rate schedule Full
Requirements Cooperative Transportation Service (FRCTS).
•
Supplier is not assigned Firm Storage Service or Storage Service Transportation (FSS and SST).
•
Full Balancing Service the Company is balancing the supply difference between:
•
The actual demand of the Aggregation Pool and;
•
The volume projected by the Demand Curve at the temperature projected on the day preceding the
Gas Day.
•
Applicable to all volumes consumed by the following:
•
Customers under rate schedule FRCTS or any special contract rate schedule.
RATE
•
April 2014
A fee of $.4694 per Mcf will be charged to customers under rate schedule FRCTS or any special
contract, for all volumes consumed in the CHOICE Supplier’s Aggregation Pool(s) for each billing
month.
Columbia Gas of Ohio Choice/SCO Reference
Manual
172
Customer Billing and Rates
Section 9
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
173
Sales Tax Exemptions
The Choice/SCO Supplier has the responsibility for identification of the sales tax status of its Customers including, but
not limited to:
1)
Collection and maintenance of certificates of exemption for current and newly assigned/enrolled customers
2)
Identification of governmental Customers exempt from sales tax, but not required to submit certificates of
exemption
3)
Submission to the Company via electronic means of information related to the Customers’ sales tax exemption
status
4)
Processing of retroactive adjustments of bills and pass back of refunds where Customers were exempt from the
payment of sales tax, but exemptions were not timely recognized.
5)
Responsible for payment to the State of Ohio of all sales taxes on gas costs billed by the Company on behalf of
the Supplier for the sale of volumes by that Supplier through Company’s Customer CHOICESM program and
Standard Choice Offer Program .
If the Company receives a Sales Tax Exemption Certificate, the Company will not process the exemption . Instead,
the Company will fax the certificate to the applicable Supplier for processing and record retention .
The Company assumes no responsibility or liability for the Supplier’s misapplication of tax-exempt status to a
Customer. The Supplier shall release, waive and hold the Company harmless for any assessments, penalties,
liabilities or claims of any kind whatsoever, related to the Supplier’s proper and timely reporting and remitting of sales
tax collections to the State of Ohio.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
174
Billing Options
Per the COH tariff, there are two billing options for CHOICE Suppliers, consolidated billing or dual billing. They must
select the billing option at the time they sign the Choice Aggregation Agreement. Their election can be changed
annually. For SCO Suppliers, consolidated billing is only billing option available.
Dual Billing – Natural Gas Supplier issues a bill for its gas costs and Columbia issues a bill for its transportation costs
Consolidated Billing - Columbia issues the total bill for the gas and transportation costs
Choice Suppliers that have elected consolidated billing have the following bill structure options:
–
–
–
Fixed rate per Mcf to be applied to the Customer’s consumption to determine the applicable billing charges
NYMEX monthly rate +/- a value per Mcf to be applied to the Customer’s consumption
Flat Supplier Amount per month to be billed to the Customer
Choice Suppliers will be permitted to have a maximum of 100 rate ready billing codes. Customers must be assigned
to current active codes prior to requesting additional rate codes.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
175
Time Line for CHOICE Supplier Rate Codes
Example:
Supplier has three accounts to flow gas on May 1st:
•
•
•
•
On the 2nd business day each month Columbia
provides a .RATE file which provides a summary of
all prior month rate codes and dollar values.
Choice Suppliers have until the 20th of the month to
submit new rate code request or to change the
value of an existing rate code. Value changes for
existing rate codes must be submitted via the
RATE.DAT file.
If the Choice Supplier submits new rate code
values, COH sends a pre-bill by fax asking the
Supplier to review and confirm before Unit 21 bills.
Choice Supplier then confirms all new rates by
signing the fax cover letter.
NOTE: No response constitutes confirmation of rates
May: 12345678-001-8
XXX03
$3.30
15678912-002-7
XXX03
$3.30
14789123-001-2
XXX03
$3.30
Customer #2 negotiates a different rate ($2.00/Mcf) for the month of
June. Using an established rate code, XXX01, this is how the
change would appear for June:
June: 12345678-001-8
XXX03
$3.30
15678912-002-7
XXX01
$2.00
14789123-001-2
XXX03
$3.30
Supplier Submitted the #2 account through the .DAT file using a “5”
code to change the rate code
Note: Changing the rate code XXX03 to $2.00 would have affected
all three accounts
The XXX03 is a variable rate that the Supplier wishes to change in
July in order for the Supplier to affect the July billings for
Customers 1 and 3. The Supplier must submit a change to
XXX03 in the Rate.DAT file via the FTP website by June 20th.
(Proposed new amount to be $2.95/Mcf)
July: 12345678-001-8
15678912-002-7
14789123-001-2
XXX03
XXX01
XXX03
$2.95
$2.00
$2.95
Please Note: No Change to .DAT file was needed
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
176
New CHOICE Rate Code Request
Establishing a new rate code:
• To request a new rate code, the Choice Supplier must
email their Choice Analyst a minimum of 45 days prior
to the flow month. (ex: requested by 5/15 available
7/1)
•
Values must be submitted at the time of the request for
new rate codes to prevent an account being added to a
rate code that has no value attached. Once the rate
code has been created and the value needs to be
changed, this can be done using the RATE.DAT file by
the 20th of the month.
•
If the 20th falls on a weekend or holiday the new rates
are due the previous business day.
NOTE: Once a rate code is established for a specific rate
option you may only change the value via the RATE.DAT
file, not the type. For example, if a rate code is established
as a fixed value rate, it cannot be updated via the
RATE.DAT file to a NYMEX +/-.
On the 2nd business day each month Columbia
provides a .RATE file which provides a summary of all
your prior month rate codes and dollar values.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
177
CHOICE Rate Change Request
The XXXRATE.DAT file is an automated process utilized by the Choice Supplier to change the price point
attached to their Supplier rate codes. New rate information can be submitted from the 21st of the current month
through the 20th of the following month. The information is due by 5:00 pm EST. There is one exception to the
automated process, Supplier rate codes that have never had a dollar value assigned will need to be submitted
manually via the current manual process.
If the 20th falls on a weekend or holiday, the submission period ends on the previous business day. If the 21st
falls on a weekend or holiday the submission period starts the next business day.
•
The Choice Supplier will submit changes using their 5 digit market rate code and an 8 digit value. The
value must be submitted with a decimal point between the dollars and cents fields.
Format Examples of Rate Options:
----+----1----+– ABC010005.8900
EXAMPLE OF A FIXED VALUE OF 0004.5000 MULTIPLIED
BY MCF
– ABC020004.5000N+ EXAMPLE OF A NYMEX '+' VALUE OF 0004.5000
– ABC030000.7500N- EXAMPLE OF A NYMEX '-' VALUE OF 0000.7500
– ABC040100.0000F EXAMPLE OF A FLAT VALUE OF 0100.0000
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
178
CHOICE Rate Change Request continued
The Choice Supplier must start with a clean Rate.Dat file every day. An “empty” Rate.Dat file is posted
daily. We recommend all rate value submissions are sent to Columbia by the 19th of the month. This will
allow one day to submit any final corrections prior to unit 1 billing
•
The Choice Supplier will receive either an .RAC1 or an .RERR file that provides the rates that were
preliminarily accepted or rejected from the XXXRATE.DAT file uploaded the previous business day.
•
After unit 21 bills, Choice Suppliers will receive a .RAC2, final acceptance file. The .RAC2 file provides
the rate values that will be used for customer billing starting with unit 1 for the effective month. The
.RAC2 file will replace the hard copy pre-bills that are normally sent. The exception will be Supplier
rate code changes that are submitted manually. Hard copy pre-bills will still be sent for them. The
.RER2 file is for internal use only and will provide rate values that were not accepted and will not be
used for customer billing.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
179
SCO Supplier Rate Code
Columbia will provide each SCO Supplier with a 5 digit supplier rate code.
This unique code will follow for the allowing:
•
SCO customers will be easily identified with a unique Supplier code. This will be beneficial to those Suppliers
serving both SCO and Choice  accounts.
•
Group SCO customers by SCO Supplier for reporting and payment purposes
•
Will identify the SCO Supplier
•
Will hold the monthly SCO price
Example:
XXCZZ
Where XX reflects the SCO Supplier, and CZZ will contain the monthly SCO Rate (NYMEX plus Retail
Adjustment Adder).
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
180
Supplier Invoicing
Section 10
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
181
Supplier Invoicing Timeline
Monthly Billing
•
The Supplier delivers gas on a daily basis and the customers are billed on a 21 unit billing cycle. After all meters
have been read or calculated and nominations have been confirmed, the process for billing the NGS begins
approximately the 6th working day of the month.
•
If the Supplier participates in the Purchase of Receivables Program, the Receivables credit amount will appear on
the invoice. Adjustment will be processed to reflect any amount owed Columbia which will be withheld from the
Receivables.
Supplier Charges
Offsets for computation of payments to the Choice and SCO Supplier may include, but are not limited to the
following;
1) Local Gas Purchase Charge
2) Demand and Supply Curve Non-Compliance Charge
3) Related charges for reimbursement to Columbia for pro rate share of all charges Columbia incurs in
connection with interstate pipeline transportation of Supplier-Delivered Gas (if applicable)
4) Credit Evaluation Fee
5) Late Payment Charge
6) Gross receipts taxes, or any other applicable taxes, on amounts billed by Columbia to Suppliers.
7) All other documented amounts which Columbia is entitled to recoup form a Supplier
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
182
Supplier Invoicing Timeline (continued)
Annual Reconciliation of Imbalances
•
On March 31st of each year, Columbia will reconcile the imbalance between the Choice Supplier’s deliveries
and their customer’s actual consumption, including any adjustments applicable for the 12- months ending
March 31st.
•
On March 31st of each year, Columbia will reconcile the imbalance between the SCO Supplier’s deliveries
and
– their SCO customer’s actual consumption, including any adjustments applicable for the 12- months
ending March 31st
– plus the allocated DSS customer consumption per Tranche, including any adjustments applicable for
the 12-months ending March 31st, multiplied by the number of Tranches for which the SCO Supplier is
responsible for providing gas supplies to Columbia.
•
Supplier’s deliveries shall include all nominations confirmed by upstream pipeline to Columbia at the
appropriate PSP and the Local Gas Purchase Requirement volumes purchased monthly by the Supplier
from Columbia, adjusted as applicable by Columbia’s System-Wide Retention Factor and Weighted Average
BTU Conversion Factor. The consumption of Choice Aggregation Pools shall incorporate an unbilled
adjustment. The SCO consumption shall reflect billed volumes. SCO Suppliers that are also CHOICE
Suppliers will be reconciled on a combined basis.
Annual Imbalance Charge
•
If the imbalance is negative, the Supplier must purchase the deficient volume from Columbia. If the
imbalance is positive, the Company will purchase the excess from the Supplier.
•
The price to be paid (cashout price) to resolve any such imbalance shall be equal to the TCO Monthly Index
adjusted for TCO SST retainage, the TCO SST Commodity charge, FSS retainage and the FSS Injection
charge.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
183
Annual Reconciliation of Imbalances
Columbia of Ohio reads meters and bills customers
on a billing month basis. The first billing cycle is read
just prior to the first day of the month and represents
gas consumed, for the most part, in the previous
month. The final billing cycle is processed near the
end of the month and represents gas consumed
primarily in the current month. This is why the billed
portions of the current month are represented by the
lower left triangle in each calendar month. The
upper right triangles represent the unbilled portion of
the month, i.e. gas that was consumed but not billed.
The illustrations below show calendar months as
rectangles and billing months as parallelograms.
Billing months can also be thought of as the previous
month’s unbilled volume (upper triangle) plus the
current month’s billed volume (lower triangle).
Deliveries by Suppliers
Suppliers deliver gas by calendar months as
represented below. Current year deliveries
represent 12 full months of consumption. These
deliveries as designed to cover gas consumed for
the calendar months of April – March. The unbilled
portion of last March was supplied in the previous
calendar year. That is why the true-up must leave a
positive imbalance for March 31 – the balance is
there to cover consumption that occurred during
March, but was not billed. If the imbalances were
adjusted to zero, Columbia would be returning gas
to the Suppliers that was consumed by their
customers, but not yet billed. Payments for this
imbalance gas will be included in the April payment.
Payments to Suppliers:
Payments for the program year are made by billing
months as represented below. They include
compensation for gas delivered during the unbilled
portion of March last year, but not for the unbilled
portion of March this year. This represents 12 full
months of consumption.
April 2014
Please note the imbalance due to unbilled volumes
illusionary. Gas is burned the day it is delivered.
There is no physical gas in the bank. The
imbalance is positive because it is the difference
between deliveries and payments, not between
deliveries and consumption.
Columbia Gas of Ohio Choice/SCO Reference
Manual
184
Unbilled Term
Calendar and Billing Months
January
February
March
April
1 2 3 4 5 6 7 8 9 ……………………….31 1 2 3 4 5 6 7 8 9 ………………………….28 1 2 3 4 5 6 7 8 9 …………………...……..31 1 2 3 4 5 6 7 8 9 .……………………...30
Unit1
Unit2
Unit3
February
Unbilled
Balance
March
Unbilled
Balance
April
Unbilled
Balance
Unit21
Calendar Month
Billing Month
The Unbilled Balance for a month is the upper right triangle for the month.
The Unbilled Entry or Activity for a month is the month’s unbilled balance minus the previous month’s unbilled balance.
Calendar Month = Billing Month + Current Month Unbilled - Previous Month Unbilled.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
185
Choice Invoice Image – Monthly
NOTE: VOLUMES AND RATES ARE NOT REAL
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
186
Choice Invoice Image – Annual Reconciliation Option 1
NOTE: VOLUMES AND PRICING ARE NOT REAL
April 2014
187
Columbia Gas of Ohio Choice/SCO Reference
Manual
169
Choice Invoice Image – Annual Reconciliation Option 2
RATE SCHEDULE INFORMATION
Nomination Group: 0000
True-Up Period: Option 2
Next true-up date : MAR 20XX
Rate Schedule: 924
Rate
Volume
Amount
Transportation Charges
Base Rate
All Gas (Dth)
$0.0000
0.0
$0.00
$0.3200
46,542.0
$14,893.44
2,500.0
$19,722.50
$34,615.94
Other Charges
Non-Temperature Balancing Service (Mcf)
Local Gas Purchase Charge (Dth)
$7.8890
Rate Schedule 924 Total
Option 2 - Annual True Up
April Cash Out (Debit) (Dth)
$4.1198
1566.0
$6,451.61
May Cash Out (Debit) (Dth)
$4.5390
2666.0
$12,100.97
June Cash Out (Credit) (Dth)
$4.4469
823.0
July Cash Out (Debit) (Dth)
$4.9992
1986.0
August Cash Out (Debit) (Dth)
$5.0606
1899.0
September Cash Out (Credit) (Dth)
$3.8232
785.0
October Cash Out (Debit) (Dth)
$4.0379
3699.0
November Cash Out (Debit) (Dth)
$3.4755
1883.0
December Cash Out (Credit) (Dth)
$4.5492
6036.0
January Cash Out
$3,659.80 Credit
$9,928.41
$9,610.08
$3,001.21 Credit
$14,936.19
$6,544.37
$27,458.97 Credit
(Credit) (Dth)
$4.5186
8733.0
$39,460.93 Credit
February Cash Out (Credit) (Dth)
$4.6106
2598.0
$11,978.34 Credit
$4.0277
2742.0
$11,043.95 Credit
March Cash Out
(Credit) (Dth)
Taxes
Gross Receipts Tax
$4,697.13
Nomination Group 0000 Total
Volume
Marketer Receivables
Choice Supplier Commodity Payment (Mcf)
46,542.0
Current Charges Total
$2,281.50 Credit
Amount
$325,794.00 Credit
$328,075.50 Credit
IMBALANCE/ALLOCATION SUMMARY
Nomination Group 9998
INTER: SG
(Dth)
Beginning Imbalance
Current Month Activity
Volume Received
Adjustment
Allocations
Remaining Volume
Unbilled Imbalance
Monthly Imbalance
Ending Imbalance
INTRA: TCO
(Dth)
0.0
54,886.0
2,588.0
0.0
2,588.0
64,855.0
0.0
45,633.0
0.0
0.0
0.0
0.0
74,108.0
71,366.0
(2,742.0)
71,366.0
188
April 2014
Average Btu of 1.034
Columbia Gas of Ohio Choice/SCO Reference
Manual
170
Supplier Payment
Section 11
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
189
Supplier Payment
•
Supplier must be set up to receive Automatic Clearing House (ACH) Payment.
•
Payments to Suppliers will be made on or before the 25th of each month for the prior month ‘s activity.
•
Payment will be made on a net basis, i.e., all cost or changes owed Columbia directly or indirectly shall be
offset against , or recouped from what Columbia may otherwise owe Suppliers.
•
All amounts billed to Suppliers, with the exception of Credit Evaluation Fee(s), will be credited to the CSRR.
•
CHOICE Supplier Payments
– Will be based on actual billed commodity gas cost and sales taxes to their CHOICE customers during
the prior billing month
•
SCO Supplier Payments
– Will be a combination of :
• commodity gas cost and sales tax billed to their allocated SCO customers during the prior billing
month;
• their pro rata share of the total DSS commodity dollars billed to DSS customers during the prior
billing month.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
190
Aviator
Section 12
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
191
Aviator Web Site
The following Suppliers’ information can be
retrieved from the Aviator Web Site:
•
•
•
•
•
•
•
•
•
•
•
•
April 2014
Daily nominations
The TCO or pipeline contract on which the
gas is delivered
The Pipeline Scheduling Point (PSP) in
which the customer is located
Pool volumes
Shipper
Customer rank
Nomination group
Path
MDQ
Supply Curves
Concern Database
GTS Bill Viewer Access
Columbia Gas of Ohio Choice/SCO Reference
Manual
192
Accessing the GTS Bill/Viewer
•
Suppliers can access their GTS invoices for
their company through the Aviator website
(www.ldcaviator.com).
•
This allows suppliers easy access to view
their invoices 24 hours a day.
•
Return GTS Bill Viewer form to Gas Analyst
in original form.
•
April 2014
Only one code will be given.
Columbia Gas of Ohio Choice/SCO Reference
Manual
193
Accessing the GTS Bill/Viewer (continued)
•
To Access GTS Bill/Viewer:
– Click on the GTS Bill Viewer tab
•
To view the Invoice
– Enter the Invoice Group number and the
Access Code, then click Submit.
– The Invoice Group Name will be displayed
in the Account Verification field.
Be advised after five unsuccessful attempts
to log in with an incorrect Account Group /
Access Code the account will be locked. If
an user is not authorized, a message will
appear stating user is not authorized to view
invoices.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
194
Accessing the GTS Bill/Viewer (continued)
•
Click ‘Yes’ to verify the account information is
correct.
•
The Billing Month Grid will be displayed.
•
Select a billing month hyperlink in the Select
Bill Month grid.
•
Adobe Reader will be invoked displaying
the invoice in .pdf format.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
195
Customer Concern Database
The Customer Concern Database is an automated process using Aviator to move and store information about
customer issues. The database can be used for concerns raised by both Choice , SCO and GTS customers. It is
viewed by Columbia and the Supplier. The site is password protected. Each person responsible for monitoring
the Concern Database will be assigned a User ID and password.
Benefits to the Supplier include, but are not limited to:
• automated electronic process
• increase efficiency and lower processing costs
• happier customers due to the speed of the responses
• ability to view all information about the customer concern
• status of all customer concerns easily available
• automatic three-day reminder message
• password protected so the Supplier only knows the concerns of its own customers
Please provide Columbia with a representative(s) from your organization that is responsible for answering
customer concerns and include the following information so the User ID and Password can be established.
• Full Name and Job Title
• Office phone and Email address
Once the representative has been established in Aviator, they will receive an automated email from the Aviator
system containing the new User ID and Password.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
196
Customer Concern Database (continued)
Suppliers are encouraged to check
the database daily, as there is a
three day response time.
•
•
•
Access the Aviator site @
www.ldcaviator.com
Log in using your assigned USERID
and Password
Click on the Choice Concerns
Hyperlink at the top of the page
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
197
Customer Concern Database (continued)
The Supplier will have two options displayed
from the drop down menu
•
The Concern List screen provides a
listing of concerns. This screen will default
to active concerns which need attention
based upon its status. New concerns will
be highlighted in yellow and after three
days, if not completed, the concerns will be
highlighted in red.
•
The Reports screen allows users to
generate reports based upon predefined
criteria.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
198
Customer Concern Database (continued)
•
Click on the ID of the concern in the Waiting for
Supplier status and access the Concern Details
screen.
•
Review the customer concern and expectations
for resolution.
--To navigate away from the page without
saving the data entered, click Return
•
Enter a response in the Response Form field.
•
Click Send Response to electronically return the
concern and go back to the Concern List screen.
•
The response will be returned and the concern
status will be updated to Waiting on
Nisource/Commission
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
199
Customer Concern Database (continued)
•
To access reports select: Choice
Concerns/Reports
•
The Concerns Reports screen allows users to
generate reports based upon predefined criteria.
Multiple columns can be selected using
(CTRL-Click).
•
Reports can be opened in an Excel format. The
report must be run before it can be exported.
•
Additionally, if using IE7 or IE8, automatic
prompting for downloads must be checked in
Internet Options for this functionality to work
properly.
•
•
•
Default filters are displayed.
Click Run to display results.
Click Export to open in Excel format.
April 2014
Columbia Gas of Ohio Choice/SCO Reference
Manual
200