COLUMBIA GAS OF VIRGINIA CHOICE REFERENCE MANUAL April 2014

COLUMBIA GAS OF VIRGINIA
CHOICE 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 Virginia Choice Reference Manual
1
Table of Contents
Section 1
April 2014
Columbia Gas of Virginia Choice Reference Manual
2
Table of Contents
Section 1
Section 2
Section 3
April 2014
Table of Contents
Outline
2
General Choice Program Information
Reference Materials
Virginia Choice Requirements
Credit Worthiness Requirements
Choice Overview
Customer Lists
Code of Conduct
Dispute Resolution
Glossary of Terms
Acronyms
4
FTP Set Up & Maintenance of Choice Accounts 16
Initial Access & Set Up
Timeline & Calendar
Reference Table Daily & Monthly Files
Revenue Class Codes
Action Codes
Audit Error Codes/Descriptions
ACT File Format
AC1 & .AC2 & GAC2 File Formats
BIL File Format
CAN File Format
CON File Format
CONF File Format
DAT File Format
DBR File Format
DET File Format
DIS File Format
DMD File Format
ERR & .ER2 & GER2 File Formats
GCB File Format
NOP File Format
PAY & MTH File Formats
RAC1 File Format
RAC2 File Format
RATE File Format
RATE.DAT File Format
REM File Format
RERR File Format
REV File Format (RS5500MK Reports)
Solicitation List File Format
Section 4
Capacity and Delivery Requirements
Pipeline Scheduling Point (PSP)
Capacity Assignment
Delivery Requirements
Balancing Service
79
Section 5
Customer Billing & Rates
Billing Options
Timeline
New Rate Code Process
Rate Change Process
84
Section 6
Supplier Invoicing
Timeline
Monthly Bill Image
Annual Reconciliation
Annual Reconciliation Bill Image
89
Section 7
Aviator
Access to Bill Viewer
Customer Concern Database
94
Columbia Gas of Virginia Choice Reference Manual
3
General Choice Program Information
Section 2
April 2014
Columbia Gas of Virginia Choice Reference Manual
4
Reference Materials for the CGV Choice Program
The information and instructions in this presentation are in keeping with the Rules and Regulations set forth in the
following 3 documents:
•
•
•
April 2014
Columbia Gas of Virginia Tariff
The CGV Gas Supply Operations Plan
The Virginia Retail Access Rules
Columbia Gas of Virginia Choice Reference Manual
5
General Columbia Gas of Virginia CHOICE Requirements
•
CSP must be licensed by the VSCC.
•
CSP agrees to participate by signing an Competitive Service Provider Service Agreement.
•
Establish acceptable Credit Worthiness prior to participating. Columbia reserves the right to check credit when
the need arises ( See slide 12 for requirements).
•
CSP must establish an aggregation pool which consists of at least 100 customers or at least 10,000 mcf of
annual throughput. The aggregation pool is comprised of those customers within each CSP’s customer group
located within the same Pipeline Scheduling Point. The PSP is determined by the zip code at the service
address. Columbia will provide the zip code list. Following is list of each PSP.
Rockville
Charlottesville
Richmond
Norfolk
Lewisburg
46-30
46-31
30CS-33
30CS-34
26-17
•
CSP is required to follow the Columbia Gas of Virginia Statewide Choice Gas Supply Operations Plan, Rate
Schedule CSPS, the SCC’s Rules Governing Retail Access to Competitive Energy Services, and CGV’s
General Terms and Conditions, as amended from time to time.
•
CSP must complete mandatory Choice Marketer Training.
•
CSP must be able to communicate using Columbia’s Electronic Bulletin Board
April 2014
Columbia Gas of Virginia Choice Reference Manual
6
Creditworthiness Requirements
A CSP desiring to provide service under this Rate
Schedule must be credit worthy, as determined by CGV in
its reasonable judgment. The CSP will be required to
Provide the following information as part of the credit
evaluation process:
1.
2.
3.
4.
5.
6
7
8
9
10
11
April 2014
Proof of license from the SCC, pursuant to
20 VAC 5-312-40, to conduct business as a
competitive service provider for residential and
small commercial customer within Columbia’s
certificated service territory
A copy of the most recent application for such
license;
Most recent annual report, 10K or 10Q and current
financial statements prepared since the last audited
report;
List of parent company and other affiliates;
Names, addresses, and telephone numbers of 3
trade references;
Names, addresses, and telephone numbers of one
or more banking institution contacts;
List of unbundling programs in which the CSP is
participating;
Confirmation that the CSP is not operating under
bankruptcy or insolvency law;
Confirmation that no significant lawsuits or
judgments are outstanding;
Confirmation that the CSP is not aware of any
adverse condition that could case a material
change in financial conditions; and
Any additional financial related information as
determined by CGV
The evaluation will be based on standard credit factors such
as previous customer history, Dun & Bradstreet financial and
credit ratings, trade references, bank references, unused
lines of credit and financial information. Columbia shall have
sole discretion to determine creditworthiness based on the
above criteria but will not deny creditworthiness reasonable
cause.
A fee of $280.00 will be assessed for each evaluation. This
Fee is for the cost Columbia incurs to obtain credit reports
($40) and the cost Columbia incurs to activate a CSP ($240).
Columbia reserves the right to conduct additional evaluations
at any time during the course of the program. No additional
credit report fee will be charged to the CSP.
The required information, along with a check for $280.00
made payable to “Columbia Gas of Virginia” should be sent
to:
Columbia Gas of Virginia
200 Civic Center Dr, Floor 7
Columbus, OH 43215
Columbia Gas of Virginia Choice Reference Manual
7
Columbia Gas of Virginia Customer Choice Overview
Eligibility
Any CGV Customer that is current on their gas bill.
Enrollment
Electronically through the CGV Web FTP site. Customers can sign a consent form, enroll via the
internet or be enrolled telephonically through recorded voice verification. CGV does not require a
copy of the customer contract between the CSP and the customer. The deadline is the 15th of the
month to serve customers the following month. Customer are accepted monthly.
Gas Deliveries
Required to use Aviator to nominate on the CGV system.
Follow Daily Delivery Obligation as specified in the CGV tariff and the Gas Supply Operations Plan.
Make deliveries by using PSPs (formerly TCO market areas).
Firm Transportation is required and there is mandatory assignment of capacity.
Capacity and storage are outlined in the Gas Supply Operations Plan.
CSP Aggregation pools are required
Rate Schedules
RTS
SGTS
UGLTS
ACTS
Residential Transportation Service
Small General Transportation Service
Unmetered Gas Light Transportation Service
Air Conditioning Transportation Service
Billing
Customers are billed nightly. The CSP is 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. Two billing options are available to the CSP (refer to the tariff). Customers are billed in CCF.
April 2014
Columbia Gas of Virginia Choice Reference Manual
8
Customer Solicitation List
A Customer List is available to an existing CSP on the columbiasuppliers website. The list will be updated or
replaced every six months. The list is provided at no cost.
Steps to obtain the Customer Lists:
•
•
•
•
•
April 2014
Access the Columbia Choice website @ www.columbiasuppliers.com
Double click on Columbia Gas of Virginia
Sign in by using the CSP VCMP number and password
• Click the submit button
Select Customer List
Click on the file name you wish to view.
Columbia Gas of Virginia Choice Reference Manual
9
Code of Conduct
The Code of Conduct can be found in the Rules Governing Retail Access to Competitive Energy Services (VAC 5-312-30)
Marketing – 20 VAC 5-312-70
•
All information presented by the CSP must be accurate and understandable, that is not misleading.
•
CSP’s must provide to prospective residential customers an estimated annual bill including all distribution
charges, and an average cost per MCF.
•
Customer Service contracts must include:
• Price or explanation how price will be calculated
• Length of the service contract, including any provisions for automatic contract renewal
• Provisions for termination by the customer and by the competitive service provider including
disclosure of any minimum state requirements of the local distribution company.
• Statement of any minimum contract terms, minimum or maximum usage requirements, minimum
or fixed charges, other charges, and any required deposit
• Applicable fees – start-up fees, cancellation fees, late payment fees and insufficient fund fees
• Notice of billing terms and conditions
• A toll-free telephone number and an address for inquiries and complaints
• Bold caption “Customers Right to Cancel” that a customer has 10 days after mailing of notice by
the local distribution company of customers right to cancel.
• Confirmation of the customers request for enrollment and the approximate date the customers
service shall commence.
• A notice that, upon request by the customer, the competitive service provider shall provide a copy
of its dispute resolution procedure.
• A notice that, upon any change in the terms and conditions of the contract must be communicated
to the customer at least 30 days in advance of implementing such changes.
Prior to the enrollment of a customer with a CSP, an aggregator shall provide notice to the customer identifying
the name, toll-free telephone number , and address for the selected CSP.
•
April 2014
Columbia Gas of Virginia Choice Reference Manual
10
Code of Conduct (continued)
Enrollment and switching – 20 VAC 5-312-80
•
CSP may offer to enroll customers upon receiving a license from the Virginia State Corporation
Commission (VSCC); EDI certification; and completing registration from the local distribution company.
•
CSP shall maintain adequate records allowing it to verify a customers enrollment authorization. Such
records must be retained for at least 12 months and shall be provided within five business days upon
request.
•
A CSP must send customer a written contract prior to sending the enrollment request to the local
distribution company.
•
Upon receipt of enrollment, the local distribution company, within one day of receiving a request, must
mail notification to the customer advising them of the enrollment request.
•
When a CSP terminates a customer’s contract, they must notify the customer at least 30 days prior to the
date service is scheduled to terminate
•
If a CSP decides to exit the program, at least 60 days advance written notice is required to be sent to the
customers, LDC and VSCC.
April 2014
Columbia Gas of Virginia Choice Reference Manual
11
Dispute Resolution
Dispute Resolution Procedure - 20 VAC 5-312-110
•
This dispute resolution procedure shall become effective at the time Columbia initiates full or phased-in retail
access to competitive energy services, and shall address complaints, disputes, or alleged violations of the
provisions of this chapter that may arise between the local distribution company and competitive service
provider.
•
A CSP shall establish an explicit dispute resolution procedure that clearly identifies the process that shall be
followed when resolving customer disputes.
•
A CSP shall furnish to customers an address and 24 hour toll free phone number for customer inquiries and
complaints regarding services provided by the CSP. The telephone number shall be stated on all customer
billing statements.
•
A CSP shall immediately direct a customer to contact the appropriate local distribution company in case of
emergency.
•
The CSP shall retain customer billing and account records and complaints for at least three years.
•
In the event a customer is referred to the LDC by the CSP, or to the CSP by the LDC, for a response to an
inquiry or complaint, the party that is contacted second shall resolve the inquiry or complaint in a timely fashion
or contact the other party to determine responsibility for resolving the inquiry or complaint.
•
If the dispute cannot be resolved the CSP shall provide the customer with the toll free phone number and
address of the SCC.
April 2014
Columbia Gas of Virginia Choice Reference Manual
12
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
A btu, 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.
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.
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.
Gas Supply Operations Plan
Operational parameters & requirements that govern CGV Choice program
April 2014
Columbia Gas of Virginia Choice Reference Manual
13
Glossary of Terms (continued)
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.
Opt-Out
Customers ability to request to have their names removed off of the eligible customer list
Peak Day
The highest usage day during the winter season; a 24 hour period of delivery greater than any other day.
PGA
Purchased Gas Adjustment Factor, a provision of regulatory rules permitting a gas company to recover in
customer bills on a dollar-for-dollar basis, the amount it pays in purchase costs for the gas supplied to a
customer.
Purchase of Receivables (POR)
Agreement whereby Columbia purchases CSP’s gas cost at 96% of all gas cost billed (optional)
Retail Access Rules
Rules governing Retail Access to Competitive Service Providers
Storage
Typically, depleted gas wells used to store gas which has been transferred from its original location.
Summer Season
That part of a contract year from the beginning of April through the end of October.
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 Virginia Choice Reference Manual
14
Acronyms
BCF
CCF
CGV
CSP
DIS
DTH
FSS
FTS
GTS
HDD
LIFO
MCF
MDQ
MDSQ
MMCF
POR
PSIA
PSP
SCC
SCQ
TCO
VSCC
April 2014
One Billion Cubic Feet
One Hundred Cubic Feet
Columbia Gas of Virginia
Competitive Service Provider
Distributive Information System
Dekatherm (Ten Therms, One Million Btu’s)
Firm Storage Service
Firm Transportation Service (tariff)
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
Purchase of Receivables
Pounds per Square Inch Absolute
Pipeline Scheduling Point
State Corporation Commission
Storage Contract Quantity
Columbia Gas Transmission Corporation
Virginia State Corporation Commission
Columbia Gas of Virginia Choice Reference Manual
15
FTP Set-Up & Maintenance of Choice Accounts
Section 3
April 2014
Columbia Gas of Virginia Choice Reference Manual
16
Intial Access and Set Up
April 2014
•
If you are not set up on the Columbia Gas of
Virginia CHOICE web site, follow the
instructions provided below:
•
Contact the appropriate Columbia Gas
representative for supplier code assignment,
user ID and password. The request for this is
included in the New Supplier Setup Sheet.
•
Follow the “Web Site Instructions” on the
following slides. The site address is
http://www.columbiasuppliers.com
•
Once you have completed setting up your new
Supplier account and reviewed the “Web Site
Instructions,” then proceed to the “Setup and
Maintenance of CHOICE Accounts” to setup
your customer CHOICE accounts with CGV.
Columbia Gas of Virginia Choice Reference Manual
17
Web Site Instructions
Welcome to the “How To” section
of the Customer CHOICE
program’s web site.
Beginning on this page we will
show you how to navigate this
site.
Select Columbia Gas of Virginia
April 2014
Columbia Gas of Virginia Choice Reference Manual
18
Web Site Instructions (continued)
For CGV you would see this page
Members Sign in:
Logon into file exchange by entering your
User ID and Password in their respective
boxes.
Click the submit button
Additional Menu Items
•
What’s New
•
Meter Reading Schedule – meter reading
dates for Columbia’s billing cycles,
Units 1-21
•
Gas Tariff
•
Rate Information
•
Zip Code Listing
•
Need Help
April 2014
Columbia Gas of Virginia Choice Reference Manual
19
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 Virginia Choice Reference Manual
20
Set-up and Maintenance of CHOICE Accounts Overview
This slide describes how to set-up and maintain your CHOICE account information and send it to
Columbia.
The .DAT file is used by the CSP for setting up, changing, or deleting accounts from their CHOICE Aggregation
Groups.
Using any text editor software available, such as WordPad or Note Pad, create a file by entering the account
information in the .DAT file format provided in this manual.
The file must be saved as XXX.DAT. The XXX is the 3-digit marketer code assigned by Columbia Gas.
When you have entered your account information, up-load 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 setup,
changes and 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 calendar.
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, 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 Virginia Choice Reference Manual
21
Virginia Timeline and Calendar
Date Period:
45 days prior to gas flow
What to do/what to look for:
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
2nd business day
.RATE file available providing 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 changes and check returned files
4th business day
RS5500 (.REV file) placed on FTP by CGV for the previous month receivables
6th business day
CSP is billed for previous months customer’s consumption
15th calendar day
Final .DAT file for Choice due for next month’s flow (CGV freezes file)
16th thru 19th calendar days
Start entering accts for the next Choice processing cycle. No processing of Choice files,
.DAT file emptied for next processing cycle
XXXRate.DAT files continue to be processed daily
20th calendar day
Payment mailed, by the 20th of the month, for collections made on Non-POR CSPs’ behalf
Demand and Supply Curves posted
Rate changes (both automated and manual) due to Columbia Gas
21st thru 25th calendar days
Enter accounts, edit .DAT file and check returned files
Start entering rate changes (XXXRate.DAT) for next billing cycle
Payment mailed , by the 25th of the month, for collection made of CSP participating in the POR program
26th thru end of month
Enter accounts, edit .DAT file and check returned files
Frozen .DAT file (from the 15th) and the daily .RAC1 data gets uploaded into CGV billing system and re-audited
Accounts for 1st of month flow get coded as Choice in CGV billing system
.AC2, .ER2 , .RAC2 are available for the CSP
--------------------------------------------------------------------------------------------------------------------------------TIME PERIOD
DAILY
By 5:00 PM each business day Upload .DAT and XXXRATE.DAT files (except on non-processing dates)
By noon each business day
Returned files available (except on non-processing dates)
NOTES: If the 15th falls on a weekend or holiday, file is due the previous business day. ALL DATES AND TIMES ARE SUBJECT TO CHANGE.
April 2014
Columbia Gas of Virginia Choice Reference Manual
22
Reference Table/Daily & Monthly Files
Monthly Files:
Daily Files:
•
AC1 – Daily file showing all the accounts accepted from the XXX.DAT
file uploaded the previous business day (preliminary accepted file)
•
BIL – File providing the meter reading and adjustment information
billed by the DIS billing system. File may be produced daily if the CSP
has accounts in each billing cycle
•
CAN - Daily file that shows accounts that were rescinded
the previous business day
•
CON – Consumption file with 24 months customer’s consumption
requested from the XXX.DAT file
•
RERR - Errors that occurred from the XXXRATE.DAT file
uploaded the previous business day
•
ACT -This file will provide all the established accounts for a CSP
as of the date of the last .AC2 file.
•
AC2 – End of month file showing accounts that will flow gas the
1st of the month
•
DET – Providing preliminary accounting and tax information
•
DMD – File containing required nomination information for the
current group of active customers
•
ER2 – End of the month error file showing errors and accounts
that will not flow gas the 1st of the month
•
DBR – The .DBR file is a monthly file that shows the gas costs that
have been removed from Columbia’s records and sent to CSP for
collection. This file is produced for the CSP that has chosen NOT
to have Columbia purchase their receivables.
•
GCB - The Gas Cost Balance file will provide ten gas cost
balances for suppliers who have non-purchased receivables.
•
MTH – Monthly summary of the Pay file (for CSP that has nonpurchased receivables). This file is produced for the CSP who had
chosen NOT to have Columbia purchase their receivables.
•
CONF – Confirmation file which is a record of the transactions
received each day as submitted through the .DAT file
•
DAT – File for enrolling, removing or changing accounts
•
DIS – Provides the CSP with disconnected accounts (inactive/final with
Columbia Gas)
•
ERR – Daily file that shows rejected accounts from the XXX.DAT file
uploaded the previous business day
•
NOP – File that shows accounts that have received a Termination
Notice or have been terminated from the program due to non-payment
or arrearages
•
PAY – List of customer payment activity (for CSP that has nonpurchased receivables). This file is produced for the CSP who has
chosen NOT to have Columbia purchase their receivables.
•
RAC1 - Provides rate code changes preliminarily accepted from the
XXXRATE.DAT file uploaded the previous business day
•
RAC2 - File that shows rate code changes that will be used for
billing customers starting with unit 1 of the effective month.
•
RATE.DAT – File for submitting rate code changes for existing rate
codes
•
•
REM – Provides accounts that will be removed from the CSP’s
customer data base as a result of the customer’s election of another
CSP including the LDC. The generated removals will appear with code
2 and the accounts coded for removal by Columbia will appear as an S
transaction.
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.
•
REV – File provides the Supplier’s prior month billed revenues,
payment details and tax information where applicable.
April 2014
Columbia Gas of Virginia Choice Reference Manual
23
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&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&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 Virginia Choice 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
24
Action Code Definitions
The following characters are to be used in the first column in the DAT file:
1
Indicates that an account is to be set up as a Choice account
2
Indicates that an account should be removed from the Choice program
3
Indicates that an account should be set up as a Choice account and 24 months of the account’s
consumption history is to be sent back to the CSP in the XXX.CON file
4
Indicates that 24 months of an established Choice customer’s consumption history is to be sent back to
the CSP in the XXX.CON file (must be a customer of the requesting CSP)
5
Indicates that a change should be made to the customer’s rate code
D
Indicates that a pending account should be deleted from the .DAT file. DO NOT PHYSICALLY delete
the account from the .DAT file. The code is used to delete an accepted account that was submitted
during the current enrollment period.
April 2014
Columbia Gas of Virginia Choice Reference Manual
25
Audit/Error Codes and Descriptions
0001 ACCOUNT NOT ON DIS
•
Account not in DIS database - Re-verify customer
account number.
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.
0009 LOCATION INVALID
0010 INVALID RECORD ON FILE
•
Could not process record, invalid format
0011 INVALID COMM
0012 INVALID RES
0003 ACCOUNT NOT AN ACTIVE ACCOUNT
•
Account is not an active account - re-verify
account number.
0004 ACTION CODE IS NOT VALID
•
Action code is not valid. Action codes are 1, 2, 3,
4, 5, D
0005 GTS CUSTOMER, NOT VALID FOR CHOICE
•
GTS Customers are not eligible for Choice.
0006 MARKETER CODE IS NOT VALID
•
Marketer code is not in the DIS tables.
0013 INVALID IND
0014 INVALID RATE
•
The account has a GTS Rate
0015 CANNOT BE REMOVED FROM PROGRAM
•
Either the account is not set up as a
Columbia Choice account or the CSP
cannot remove the account from the
program because it was set up with a
different Marketer code.
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 38
•
Account is not an Virginia account.
April 2014
Columbia Gas of Virginia Choice Reference Manual
26
Audit/Error Codes and Descriptions (continued)
0016 NOT USED (CUST CREDIT INVALID FOR CHOICE)
0017 DUPLICATE ACCOUNT REMOVAL
TRANSMISSION
•
Account removal was transmitted twice in the .DAT
file, check the .DAT file and delete (using a ‘D’
action code) one of the entries.
0018 ACCOUNT NOT ACTIVE CHOICE CANNOT CHANGE
•
Action code ‘5’ was submitted but the account
cannot be changed because the account belongs
to another CSP or has been removed from the
program.
0019 ALREADY SET UP
•
This account is already set up as a Choice account
by another CSP or the CSP making the request. If
the account is set up by the CSP making the
request, then the additional message for CSP
XXX01 will be displayed. XXX will be the threecharacter marketer code and the 01 will be the
appropriate billing code.
0020 CANNOT REQUEST CONSUMPTION
•
Consumption cannot be provided because the CSP
requesting the consumption does not have this
account as a Choice customer.
0021 PROPANE CUSTOMER, NOT VALID FOR Choice
•
Propane customers are not valid for Choice
April 2014
0022 NO MATCH TCO AREA
•
PSP does not agree with PSP Area on table
used in conjunction with Marketer Code and
Nomination Group Number to get a valid PSP.
0023 DUP ACCT ADD DIFF
•
The account has been submitted to be added
by two different CSPs.
0024 CANNOT BE CHANGED, REMOVE FOUND
•
CSP has submitted a marketer billing code
change as well as a remove for this account.
Our system will not process the change
because the account does not need to be
changed.
0025 NOT USED
0026 NON RES ACCT IN RES ONLY MARKETER
AS OF 11/07 NO LONGER APPLICABLE
•
CSP has submitted a residential acct with a
commercial marketer billing code.
0027 NON COMM ACCT IN COMM ONLY MARKETER
AS OF 11/07 NO LONGER APPLICABLE
•
CSP has submitted a Commercial acct with a
residential marketer billing code.
Columbia Gas of Virginia Choice Reference Manual
27
Audit/Error Codes and Descriptions (continued)
0028 MARKETER CODE EXPIRED or MARKETER CODE
NOT EFFECTIVE
•
Marketer rate code is expired or has not been
established in Columbia’s system.
0036 NOM GROUP NUM INVALID
•
Nomination Group Number supplied by CSP is
invalid or not on tables used to get a valid
PSP.
0029 NOT USED
0030 NOT USED
0031 NOT USED
0037 NOT USED
0032 ACCOUNT NOT FOUND OR CANNOT UPDATE
•
The account is not on Choice or cannot be
changed because the account is with another
CSP.
0038 POSTAL ROUTE IN ERROR
•
The 4-digit zip code extension does not match
the 4-digit zip code extension on the
customer’s service address.
0039 INVALID DOLLAR VALUE FORMAT
0033 NOT ELIGIBLE UNTIL REMOVED FROM
BUDGET
0034 NOM GROUP NUMBER INVALID
•
This occurs when the marketer code was found
on the table but the contract number is zero.
•
MCF Dollar Value submitted is not in the
required format (XX.XXXX) or is a negative
value
0040 INVALID MARKETER RATE CODE - BILLING
•
CSP bills gas costs
0035 MARK CD INVALID
•
This occurs when the zip code is found but it’s
the wrong PSP match between the marketer
table and the zip code table.
April 2014
Columbia Gas of Virginia Choice Reference Manual
28
.ACT File Format
The .ACT file provides all the established
accounts for a CSP as of the date of the
last .AC2 file. This file can be used when
building a customer database or to verify the
information contained in a CSP’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
Column 12:
•
Customer Check Digit Number
Columns 13-45:
•
Customer Name
Columns 46-78:
•
Service Address
Columns 79-99:
•
City
month’s 15th deadline would not be included.
Columns 100-101:
•
State
Columns 1-8:
•
Customer PCID Number
Column 102:
•
Filler
Columns 9-11:
•
Customer Sequence Number
April 2014
Columns 103-112:
•
Zip Code plus 4
Columbia Gas of Virginia Choice Reference Manual
29
.ACT File Format (continued)
Column 113:
•
Hyphen
Columns 114-117:
•
Postal Carrier Route
Columns 118-122:
•
Five-digit Marketer Code
Columns 123-130:
•
Effective Date (YYYYMMDD)
Column 131:
•
Budget Customer Indicator “Y” or “N”
April 2014
Columbia Gas of Virginia Choice Reference Manual
30
.AC1, .AC2 & .GAC2 Files
The XXXMMDDY.AC1 file, where XXX reflects the
Natural Gas Supplier and the state in which they
operate, 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. As you build your .DAT file
during the month, the .AC1 file will continue to build as
well.
The .AC2 file provides all the accounts that were
accepted to the Columbia billing system from 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 file that is
generated after unit 21 bills in Columbia’s billing
system. It is possible that accounts you saw in your
.AC1 file may have been disconnected and final
between the time you saw them in the .AC1 file and the
time the final .AC2 file posts.
April 2014
The .GAC2 file provides all the accepted GAS/GMB
accounts from the previous processing cycle that will flow
gas the 1st of the month.
.AC1 contains preliminary accepted accounts. Do not
assume that accounts showing in the .AC1 will be
accepted in the final .AC2 or .GAC2 files.
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.
Columbia Gas of Virginia Choice Reference Manual
31
.AC1, .AC2 & .GAC2 File Formats (continued)
Column 1:
•
Action Code
Columns 2-9:
•
Columns 20-31:
•
12-Digit Control Code – 5 digit Natural Gas
Supplier rate code, and up to six characters that
were used at the Natural Gas Supplier’s discretion
Customer PCID Number
Columns 10-12:
•
Customer Sequence Number
Column 13:
•
Customer Check Digit Number
Columns 14-19:
•
April 2014
Effective Date (YYYYMM)
Columbia Gas of Virginia Choice Reference Manual
32
.BIL File Format
This file will provide the meter reading and
adjustment information billed by the DIS system.
The XXX in the name of the file is an abbreviated
three-digit code to identify the CSP and the state
in which the CSP is operating. If a CSP is
participating in more than one state program, the
XXX may vary slightly from state to state to avoid
confusion.
April 2014
Columns 19-22:
•
Location Number - Internal CGV use
Columns 23-24:
•
Revenue Class
Columns 25-32:
•
Customer PCID Number
.BIL Detail Record (11) - current
month billing information format
below:
Columns 33-35:
•
Customer Sequence Number
Columns 1-2
• Record-type
Column 36:
•
Customer Check Digit
Columns 3-10
• System Creation Date (YYYYMMDD)
Columns 37-45:
•
Customer PSID Number
Columns 11-16:
• Revenue Cycle (YYYYMM)
Columns 46-111:
•
Customer Name & Overflow
Columns 17-18:
• Billing Unit
Columns 112-144:
•
Service Address
Columbia Gas of Virginia Choice Reference Manual
33
.BIL Detail Record Format (continued)
Columns 145-164:
•
Service City
Columns 198-205:
• From-Date (YYYYMMDD)
Columns 165- 166:
•
State for Facility
Columns 206-213:
•
Columns 167-175:
•
Zip Code for facility
Columns 214-221:
•
Columns 176-178:
•
County Code
047 – Culpeper
153 – Prince William
•
•
Sign +/-
•
Usage by volume in CCF
Serial number of gas meter
Columns 194-197:
•
Calc / Read / AMR
April 2014
To-Read
Columns 230-239:
Taxing District
Columns 186-193:
•
From-Read
Columns 222-229:
Columns 179-185:
•
To-Date (YYYYMMDD)
Columns 240-240:
• Final Bill
Y – Yes, N - No
Columbia Gas of Virginia Choice Reference Manual
34
.BIL Detail Record Format (continued)
Columns 241-241:
•
Rebill – Code
•
Yes – Y, No – N
Columns 290-299:
•
Sign +/•
Pay This Amount
Columns 242-251:
•
Sign +/•
Total Current Amount
Columns 300-304:
•
Marketer 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 +/•
Marketer Rate / CCF
Columns 311-316:
•
Sign +/•
Marketer Discount
Columns 317-326:
•
Sign +/•
Marketer Previous Balance
Columns 327-336:
•
Sign +/•
Marketer Current Charges
Columbia Gas of Virginia Choice Reference Manual
35
.BIL Detail Record Format (continued)
Columns 337-346:
•
Sign +/•
Marketer Current Balance
Columns 436-445:
•
Sign +/•
Delayed Payment Penalty
Columns 347-396:
•
Reserved for future use
Columns 446-455:
•
Sign +/•
Agency Handling Fee
Columns 397-405:
•
CGV Transportation Rate
Columns 406-415:
•
Sign +/•
Columbia Customer Charge
Columns 416-425:
•
Sign +/•
Columbia Transportation Charges
Columns 426-435:
•
Sign +/•
Supplemental Charges
April 2014
Column 456:
•
Customer on Budget
•
Yes-Y, No-N
Columns 457-466:
•
Sign +/•
Marketer Budget Amount
Columns 467-476:
•
Sign +/•
Marketer Budget Arrears
Columns 477-486:
•
Sign +/•
Marketer Budget Balance
Columbia Gas of Virginia Choice Reference Manual
36
.BIL Detail Record Format (continued)
Columns 487-496:
•
Sign +/•
Columbia Budget Amount
Columns 497-506:
•
Sign +/•
Columbia Budget Arrears
Columns 507-516:
•
Sign +/•
Columbia Budget Balance
Columns 517-518
•
Billing Unit
Columns 519-539
•
Filler
Columns 540-548`
•
Sign +/•
Filler
Columns 549-557
•
Sign +/•
Filler
April 2014
Columbia Gas of Virginia Choice Reference Manual
37
.BIL Adjustment Record File Format
.BIL
Adjustment Record (15)-current month
adjustment information format below:
Columns 1-2:
•
Record – type 15
Columns 3-6:
•
Location
Columns 7-15:
•
Customer PSID Number
Columns 16-23:
•
Columns 35-38:
•
Transaction – Type
•
CAOR = CAB adjustment, over read
•
CAUR = CAB adjustment, under read
•
CAOC = CAB adjustment, over calculated
•
CAUC = CAB adjustment, under calculated
•
CAAF = CAB adjustment, adjustment on final bill
•
CAAI = CAB adjustment, adjustment on initial bill
•
CADM = CAB adjustment, dead meter
•
CAFM = CAB adjustment, fast meter
•
CAMA = CAB adjustment, manual adjustment
•
AMRA = CAB AMR adjusted reading
Customer PCID Number
Columns 39-43:
Columns 24-26:
•
•
Customer Sequence Number
Columns 27-34:
•
Transaction – Date (YYYYMMDD)
Marketer Rate Code
Columns 44-53:
•
Sign +/-
•
Transportation Charges
Columns 54-63:
•
•
April 2014
Sign +/Gas Cost Amount
Columbia Gas of Virginia Choice Reference Manual
38
.BIL Adjustment Record File Format
Columns 64-71:
•
Adjustment Period Date (YYYYMMDD)
Columns 72-81:
•
Sign +/•
CCF
Column 82:
•
Customer Check Digit Number
Columns 83-92:
•
“Add” date (YYYY-MM-DD)
• This is the date the account was added (with a “1” or “3” code) by this marketer.
Column 93:
•
Always a Y
April 2014
Columbia Gas of Virginia Choice Reference Manual
39
BIL Balance 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 $xx.xx)
Columns 28-56:
•
Filler
Columns 57-58:
•
Balance Record Indicator (all nines)
April 2014
Columbia Gas of Virginia Choice Reference Manual
40
.CAN File Format
The .CAN file provides a list of accounts that were
rescinded, using the “C” code by CGV the previous
business day.
Columns 1
•
Code will be “C” indicating the account has
rescinded their pending enrollment .
Column 20:
•
Filler
Column 21:
•
Customer Check Digit number
Columns 2-7:
•
Filler
Column 22-28:
•
Filler
Columns 8-15:
•
Customer PCID number
Columns 29-33:
•
Five digit Marketer Rate Code
Column 16:
•
Filler
Columns 17-19:
•
Customer Sequence number
April 2014
Columbia Gas of Virginia Choice Reference Manual
41
.CON File Format
The .CON 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
set up as a CHOICE account and 24
months consumption history is to be
sent to the CSP on the
XXX .CON file.
4 - indicates 24 months consumption
history of an established Columbia
CHOICE account should be sent to
the CSP in the CON file.
Columns 2-13:
•
Marketer 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 Virginia Choice Reference Manual
42
.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.
Column 1:
•
Action code
Columns 2-9:
•
Customer PCID Number
Columns 10-12:
•
Customer SEQUENCE
Column 13:
•
Customer CHECK DIGIT
Column 14 - 19
•
Filler
Columns 60-62:
• Marketer code
Columns 63-70:
• Date YYYYMMDD
Columns 71-74:
• 24 Hour Time HHMM
Columns 75-79:
• Record sequence number
Columns 20-24:
•
Marketer rate code
Columns 25-59:
•
Filler
April 2014
Columbia Gas of Virginia Choice Reference Manual
43
.DAT File Format
The .DAT file is utilized by the Competitive Service Provider to add, delete or change an account on the FTP Web Site.
The CSP enters the Action Code in the first column followed by the account information which is included in columns 2
through 31 described on the next page. Files can be submitted daily up through the 15th of the month.
Example: the following transactions would be submitted in the .DAT file:
1123456780012
XXV01
The number 1 at the beginning of the PCID number is to enroll a customer in CHOICE.
The CSP must start with a “clean” .DAT file after each enrollment period.
Columbia automatically removes the contents, after the file has been processed on the 15th of each month
NOTE: Columns = Spaces
.DAT FILE FORMAT:
Codes are ‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘D’ (see explanation of each below):
12345D-
April 2014
Account to be set up on CHOICE
Account to be removed from CHOICE
Account to be set up on CHOICE & 24 months consumption sent to CSP
24 months consumption of an established Columbia CHOICE customer sent to CSP
Change to customer’s rate code
Account to be deleted from the .DAT file. DO NOT physically delete the account from the .DAT file
Columbia Gas of Virginia Choice Reference Manual
44
.DAT File Format (continued)
Column 1
•
Action Code
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 - 19:
•
Leave Blank
Columns 20-31:
•
Enter in the 12 digit control as the
following:
• Enter a 5-digit marketer rate code in
the first 5 positions. The first 3
characters are the marketer code
and the last two characters are the
rate number. The next 7 characters
are not required and can be used by
the CSP at their own discretion
SPECIAL NOTE:
The “D” code is used during the current
enrollment period when an account in the
.DAT file has been entered in error. To remove
or delete an account that has been 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
Except for the “D” transaction code, two action
codes can not be submitted in the same
enrollment period. For example, a “3” Add &
Consumption is submitted on the 1st day of the
month, then a “5” Change is submitted on the
10th day of the month. Both will be ignored and
no action will be processed.
Here is an example:
3123456780011
XXV01
April 2014
Columbia Gas of Virginia Choice Reference Manual
45
.DBR File Format
The .DBR file is a monthly file that shows the gas costs that have been removed from Columbia’s records
and sent to the CSP for collection. This file is produced for those who have chosen NOT to have Columbia
purchase their receivables. There are 3 reasons an account will appear on the Balances Removed Report,
the account has been disconnected, the customer has been removed from Choice, or the rate code has been changed.
Columns 1-5:
•
Marketer Code
Columns 54-56:
•
Sequence Number
Column 6:
•
Blank
Column 57:
•
Blank
Column 7:
•
Dash ( - )
Column 8:
•
Blank
Columns 9-41:
•
Marketer Name
Columns 42-44:
•
Revenue Class
Columns 45-52:
•
PCID Number
Column 53:
•
Blank
April 2014
Column 58:
•
Check Digit
Columns 59-91:
•
Customer Name
Columns 92-128:
•
Service Address
Columns 129-148:
•
City
Columns 149-150:
•
State
Columns 151-155:
•
Zip Code
Columns 156-165:
•
Balance Removed
Columbia Gas of Virginia Choice Reference Manual
46
.DET File Format Layout
The .DET file is the CSP Detail file (electronic
version of the RS5500MK).
There are 4 record types that can be in each file:
1.
2.
3.
4.
Detail record
Adjustment detail record
Control total record
Customers # record
A conversion chart of values for signed
unpacked numbers are below:
April 2014
J = -1
K = -2
L = -3
M = -4
N = -5
O = -6
P = -7
Q = -8
R = -9
} = -0
Column 1:
•
Record Type 1
Columns 2-3:
•
Company
All numeric fields are defined as signed
unpacked numbers. This allows us to retain
negative values in the numeric fields.
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I = 9
{ =0
Detail Record:
Columns 4-14:
•
PCID & Sequence Number
Column 15:
•
PCID Ck Digit Number
Columns 16-20:
•
CSP Rate Code
Columns 21-23:
•
County Code
Column 24:
•
Revenue Class
Columns 25-33:
•
CSP current month MCF
Columbia Gas of Virginia Choice Reference Manual
47
.DET File Format Layout, Detail Record (continued)
Columns 34-42:
•
CSP Adjustment MCF
Columns 97-107:
•
Total Tax
Columns 43-51:
•
Total MCF
Columns 108-118:
•
Grand Total
Columns 52-60:
•
CSP Current Month Gas Cost
Columns 61-69:
•
CSP Adjustment Gas Cost
Columns 70-78:
•
Total Gas Cost
Columns 79-87:
•
State Tax Current Month
Columns 88-96:
•
State Tax Adjustment
April 2014
NOTES:
Total MCF = (CSP curr mo MCF + CSP adj MCF)
Total gas cost = (CSP curr mo gas cost + CSP adj gas
cost)
Total tax = (State tax curr mo + State tax adj.)
Grand total = (Total gas cost + Total tax)
Values for the Revenue-class are:
•
R = residential
•
C = commercial
•
I = industrial
Columbia Gas of Virginia Choice Reference Manual
48
.DET File Format Layout, Adjustment Record
Adjustment Detail Record
Column 1:
•
Record Type 2
Columns 2-3:
•
Company
Columns 4-14:
•
PCID & Sequence Number
Column 15:
•
PCID Ck Digit Number
Columns 16-20:
•
CSP Rate Code
Columns 21-26:
•
CSP Adjustment Date
(YYYYMM)
Columns 27-35:
•
CSP Adjustment MCF
Columns 36-44:
•
CSP Adjustment Gas Cost
April 2014
Columbia Gas of Virginia Choice Reference Manual
49
.DET File Format Layout, Control Record
Control Total Record
Column 1:
•
Record Type 3
Columns 52-60:
•
CSP Current Month Gas Cost
Columns 2-3:
•
Company
Columns 61-69:
•
CSP Adjustment Gas Cost
Columns 70-78:
•
Total Gas Cost
Columns 4-15:
•
Filler
Column 16-20:
•
CSP Number
Columns 79-87:
•
State Tax Current Month
Columns 21-24:
•
Filler
Columns 88-96:
•
State Tax Adjustment
Columns 25-33:
•
CSP Current Month MCF
Columns 34-42:
•
CSP Adjustment MCF
Columns 97-107:
•
Total Tax
Columns 108-118:
•
Grand Total
Columns 43-51:
•
Total MCF
April 2014
Columbia Gas of Virginia Choice Reference Manual
50
.DET File Format Layout, Customer Number Record
Customer Number Record
Column 1:
•
Record Type 4
Columns 84-87:
•
Factor
Columns 2-3:
•
Company
Columns 88-98
•
Billing Amount
Columns 4-15:
•
Filler
Columns 16-20:
•
CSP number
Columns 21-67:
•
Message
Columns 68-74:
•
Customers
Columns 75-83:
•
Times (literal)
April 2014
Columbia Gas of Virginia Choice Reference Manual
51
.DIS File Format
The .DIS file shows the customers who have
been disconnected and are inactive in
Columbia’s billing system.
The XXXMMDDY.DIS file where XXX reflects
the CSP and the state in which the CSP is
operating, 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 CSP about accounts that
have been removed from CGV service for
various reasons.
If a CSP is participating in more than one
state program, the XXX may vary slightly
from state to state to avoid confusion.
Upon receiving an account in this file, the
CSP 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
All the above would cause the customer to
be disconnected on our system
April 2014
The .DIS file reflects service changes and should not
be confused with the .NOP file.
Columns 1-5:
•
Marketer Rate Code
Columns 6-7:
•
Company Number (i.e. 38 for Virginia)
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
Columbia Gas of Virginia Choice Reference Manual
52
.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 of the unit for the
billing cycle)
Columns 81-88:
•
Customer Activity Date (YYYYMMDD) =
Date CGV processed the order in our
system
Columns 89-92:
•
Customer Activity Type (The transaction
code from the CGV 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 Virginia Choice Reference Manual
53
.DMD File - Steps to Import Into Excel
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 Virginia Choice Reference Manual
54
.DMD File - Demand Curves (Continued)
•
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.
•
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 CSP deliver on calendar months. This
report reflects that difference. Volumes on this report are increased for retainage and decreased for customer
attrition.
•
Report 3 Dth Summary Report provides number of customers, operational information, and daily and annual
volumes.
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 Virginia Choice Reference Manual
55
.DMD File Demand Curves (continued)
April 2014
Columbia Gas of Virginia Choice Reference Manual
56
.ERR, .ER2 & .GER2 File Formats
The .ER2 & .GER2 files:
The .ERR file:
This file reflects the accounts rejected from the .DAT file
that was uploaded the previous business day.
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 file:
•
XX reflects the NGS
•
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
final .DAT file uploaded on the deadline provided on the
timeline/calendar (usually the 15th of the month), and will
not flow gas the 1st of the month.
.ER2 file, shows the rejected accounts
.GER2 file, shows the rejected GAS/GMB accounts
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.
The XXXMMDDY. ER2 & .GER2
•
XX reflects the NGS
•
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 files provide a total number of
accounts at the bottom of the file processed from the .DAT file.
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 Virginia Choice Reference Manual
57
.ERR, .ER2 & .GER2 File Formats
Column 1
• Action Code
Columns 71-110:
• Audit Error Description (see Audit/Error
Codes and Descriptions)
Columns 2-6:
• Natural Gas Supplier Rate Code
Columns 7-39:
• Natural Gas Supplier Name
Columns 111-112:
• Current Revenue Class
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 127:
• Customer Middle Initial
Column 51:
• Customer Check Digit Number
Columns 128-147:
• Customer Last Name
Columns 52-60:
• Customer PSID Number
Columns 148-180:
• Service Address
Columns 61-66:
• Effective Date (YYYYMM)
Columns 181-219:
• Service City, State, Zip+4, Carrier Route
Columns 67-70:
• Audit Error Code (see Audit/Error Codes and
Descriptions)
April 2014
Columbia Gas of Virginia Choice Reference Manual
58
.ERR, .ER2 & .GER2 File Formats (continued)
Columns 220-247:
•
Blank
Columns 248-257:
•
Date Processed
Columns 258-259:
•
Company Number
Column 260:
•
Filler
Columns 261-272:
•
12 Digit Control Code-5 digit Natural Gas
Supplier rate code, and up to six
characters that were used at the Natural
Gas Supplier’s discretion
Column 273-276:
•
Standard Industrial Code
April 2014
Columbia Gas of Virginia Choice Reference Manual
59
.GCB File Format
This Gas Cost Balance file will provide ten gas
cost balances for the CSP who have
non purchased receivables.
Note:
Gas Cost balances will show negative for
budget customers with a credit balance. To see
the cash transfer, check the .PAY or .MTH files.
Columns 9-11:
•
Customer PCID Sequence Number
Columns 13-45:
•
Customer Name
Columns 112-131:
•
City
Columns 132-133:
•
State
Columns 134-142:
•
Zip + 4
Columns 1-8:
•
Customer PCID Number
Column 12:
•
Customer Check Digit Number
Columns 79-111:
•
Service Address
Column 143:
•
Sign ( + or -)
Column 144-152:
•
Total of 10 Gas Costs
Column 153:
•
Sign (+ or -)
Columns 46-78:
•
Customer Name Overflow
April 2014
Columbia Gas of Virginia Choice Reference Manual
60
.GCB File Format (continued)
Columns 154-162:
•
Current Payment
Columns 163-170:
•
Current Payment Date
Column 207:
Sign ( + or - )
Columns 208-216:
•
Columns 171-175:
•
Supplier Rate Code
Columns 176-183:
•
Supplier Rate Code Start Date
Gas Cost Amount
Columns 217-221:
•
Supplier Rate Code
Columns 222-229:
Column 184:
•
Sign ( + or - )
Columns 185-193:
•
Gas Cost Amount
Columns 194-198:
•
Supplier Rate Code
Columns 199-206:
•
April 2014
•
Supplier Rate Code Start Date
Column 230:
•
Sign ( + or - )
Columns 231-239:
• Gas Cost Amount
Columns 240-244:
• Supplier Rate Code
Supplier Rate Code Start Date
Columbia Gas of Virginia Choice Reference Manual
61
.GCB
File Format (continued)
Columns 245-252:
•
Supplier Rate Code Start Date
Columns 286-290:
Column 253:
•
Sign ( + or - )
Columns 291-298:
Columns 254-262:
•
Gas Cost Amount
Column 299:
Columns 263-267:
•
Supplier Rate Code
Columns 268-275:
•
Supplier Rate Code Start Date
Column 276:
•
Sign ( + or - )
Columns 277-285:
•
Gas Cost Amount
April 2014
•
•
Supplier Rate Code
Supplier Rate Code Start Date
•
Sign ( + or - )
Columns 300-308:
•
Gas Cost Amount
Columns 309-313:
•
Supplier Rate Code
Columns 314-321:
•
Supplier Rate Code Start Date
Column 322:
•
Sign ( + or - )
Columbia Gas of Virginia Choice Reference Manual
62
.GCB File Format (continued)
Columns 323-331:
•
Gas Cost Amount
Columns 332-336:
•
Supplier Rate Code
Columns 337-344:
•
Supplier Rate Code Start Date
Column 345:
•
Sign ( + or - )
Columns 346-354:
•
Gas Cost Amount
Column 368:
•
Sign ( + or - )
Columns 369-377:
•
Gas Cost Amount
Columns 378-382:
• Supplier Rate Code
Columns 383-390:
• Supplier Rate Code Start Date
Column 391:
Columns 355-359:
•
Supplier Rate Code
Columns 360-367:
•
Supplier Rate Code Start Date
April 2014
•
Sign ( + or - )
Columns 392-400:
• Gas Cost Amount
Columbia Gas of Virginia Choice Reference Manual
63
.NOP File Format
The XXXMMDDY. NOP file, where XXX reflects the CSP
and the state in which the CSP operates, 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 CSP about customer accounts that
have been issued a pending termination notice for nonpayment or non-access to their meter.
Columns 1-5:
•
Marketer Rate Code
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
Columns 6-7:
•
Company Number (38)
Columns 8-11:
•
Location Number - An internal Columbia
tracking number based on the Area office that
serves the customer.
April 2014
Columbia Gas of Virginia Choice Reference Manual
64
.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
(See Note for Status Code Description)
Columns 89-94:
•
CCTNNP – customer receives a 10-day
disconnection notice for non-payment of
arrears or
•
CCTNFA – customer receives a 10-day
disconnection notice for failure to grant
Columbia access to the meter for a 12 month
period or longer
Columns 95-99:
•
Five digit Marketer Rate Code
Columns 100-107:
•
Filler (zeros)
Columns 38-45:
•
Filler (zeros)
Note:
Columns 46-47:
•
Revenue Class Code
Columns 48-80:
•
Customer Name
Columns 81-88:
•
Date of Transaction (YYYYMMDD)
Date the notice occurred
April 2014
Account Status Codes
Code
Description
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
Columbia Gas of Virginia Choice Reference Manual
65
.PAY & .MTH File Format
The .PAY file is a daily file indicating customer
payments applied to the gas cost portion of the
customer’s invoice. These files are produced for
CSP choosing NOT to have Columbia purchase their
receivables.
The .MTH file is a monthly file with the same format
as the .PAY file that ties directly to the RS5500MK
report.
Columns 1-5:
• Marketer Rate Code
Columns 6-13:
• Customer PCID Number
Columns 14-16:
• Customer Sequence Number
Column 17:
• Customer Check Digit
Column 18:
• Sign (+ or -)
Columns 19-26:
• Transaction Amount
April 2014
Columns 27-29:
• Account Type
•Res = Residential
•Com =Commercial
Columns 30-62:
• Customer Name
•Business Name
•Customer Last Name
•Customer First Name
•Customer Middle Initial
Columns 63-68:
• Transaction Category
• PAYMNT = Payment
• CSHTFR = Cash Transfer, including CTCM
• RTNCHK = Return Check
• PTTYCH = Petty Cash
• VOUCHR = Journal Voucher
• REFUND = Security Deposit, Annual
Interest
• PAYMFA = Federal Assistance Payment
Columbia Gas of Virginia Choice Reference Manual
66
.RAC1 File Format
The XXXMMDDY.RAC1 file, where XXX reflects the Marketer and the
state in which the CSP operates, MM reflects the month, DD reflects the
day, and the Y reflects the last digit of the year the record is created.
Columns 1-5:
•
Marketer Rate Code (5 characters)
The .RAC1 file contains preliminary accepted marketer rate codes and
dollar values from the RATE.DAT file that were uploaded the previous
Columns 6-7:
•
Filler
business day and are to be effective for the next month’s Unit 1 billing .
In addition, the .RAC1 file will contain the last billed dollar value for the
marketer rate codes that were submitted during the submission period.
Columns 8-14:
•
New Dollar Value (mcf)
XX.XXXX
NOTE – Marketer rate codes and/or dollar values can be changed
throughout the submission period which starts on the 21st of one month
through the 20th of the following month.
Columns 15-16:
•
Filler
It is recommended that all marketer rate value submissions be sent to
Columbia by the 19th of the month. This will allow one day to submit any
final corrections on the 20th prior to Unit 1 billing of the effective month.
Columns 17-22:
•
Effective Date (YYYYMM)
Any Marketer rate codes and/or dollar values submitted on the last day of
the submission period, normally calendar day 20, that are rejected cannot
be corrected and will not be used for unit 1 billing of the effective month.
Columns 23-24:
•
Filler
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.
April 2014
Columns 25-31:
•
Last Billed Dollar Value (mcf)
XX.XXXX
Columbia Gas of Virginia Choice Reference Manual
67
.RAC2 File Format
The XXXMMDDY.RAC2, where XXX reflects the Marketer and the state in
which the CSP operates, 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 Marketer Rate Code
submission period, normally calendar day 20, and will reflect the marketer
rate codes and dollar 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 marketer codes. Hard
copy pre-bills will still be sent for new marketer codes.
NOTE – Marketer rate codes and dollar values can be changed throughout
the submission period which starts on the 21st of one month through the 20th
of the following month.
Columns 1-5:
•
Marketer Rate Code (5 characters)
Columns 6-7:
•
Filler
Columns 8-14:
•
New Dollar Value (mcf)
XX.XXXX
Columns 15-16:
•
Filler
Columns 17-22:
•
Effective Date (YYYYMM)
It is recommended that all marketer rate value submissions be sent to
Columbia by the 19th of the month. This will allow one day to submit any
final corrections on the 20th prior to Unit 1 billing of the effective month.
Any Marketer rate codes and/or dollar values submitted on the last day of
the submission period, normally calendar day 20, that are rejected cannot
be corrected and will not be used for unit 1 billing 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.
April 2014
Columbia Gas of Virginia Choice Reference Manual
68
.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.
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 1-48:
•
Filler
Columns 49 -65:
•
Company
Columns 117 -121:
•
Supplier Rate Code
Columns 122 -126:
•
Filler
Columns 127- 134:
•
Rate Effective Date
Columns 135 - 138:
•
Filler
Columns 139 - 148:
•
Price Value (MCF)
Columns 66 -72:
•
Billing Cycle (Month/Year)
Columns 73 -79:
•
Filler
Columns 80 -116:
•
Supplier Name
April 2014
Columbia Gas of Virginia Choice Reference Manual
69
RATE.DAT File Format
The XXXRATE.DAT file, where XXX reflects the Marketer and
the state in which the CSP operates, is used to submit
marketer rate codes and dollar values via the FTP Web Site.
This automated process will allow marketer rate submissions
on a daily basis starting on the 21st of one month and ending
on the 20th of the following month. Dollar values can be
changed for the same marketer code throughout the
submission period. The last dollar value for a marketer code
received and accepted by Columbia will be the dollar value
used for billing starting with unit 1 of the effective month.
Columns 1-5:
•
Marketer Rate Code (5 characters)
Columns 6-7:
•
Filler
Columns 8-14:
•
Dollar Value (mcf)
XX.XXXX
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.
NOTE:
A “clean” XXXRATE.DAT file will be posted daily.
April 2014
The dollar value is a 7 character field and must be
entered with a decimal point between the dollars and
cents.
All 7 characters must be entered.
Columbia Gas of Virginia Choice Reference Manual
70
.REM File Format
The REM file provides accounts that will be
removed from the Competitive Service Provider’s
customer base as a result of the customer's
election of another CSP, including the LDC.
The accounts will be removed from the current
CSP and enrolled with the new Competitive
Service Provider or returned to LDC tariff service.
The automatic removal process no longer
requires an action code ‘2’ submitted by the
current CSP. The ‘S’ code indicates the
customer will be returned to tariff.
The REM file may also provide accounts that will
remain with their current CSP as a result of the
customer rescinding a current enrollment with
another CSP. These accounts will be designated
by an ‘N’ in Column 1.
.
April 2014
Column 1:
The code will be ‘2’ or ‘S’ indicating the
account will be removed from the CSP;
Or
‘N’ indicating the customer will remain
with their current CSP.
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:
Marketer Rate Code
Columbia Gas of Virginia Choice Reference Manual
71
.RERR File Format
The .RERR file:
Columns 1-5:
•
Marketer Rate Code (5 characters)
This file is a daily file that reflects the marketer rate codes
and/or dollar values that rejected from the RATE.DAT that
was uploaded the previous business day. Marketer rate
codes and/or dollar 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:
XX reflects the Marketer
X reflects the operating 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-7:
•
Filler
Columns 8-14:
•
Dollar Value (mcf)
•
XX.XXXX
Columns 15-16:
•
Filler
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 Virginia Choice Reference Manual
72
.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 CSP and State, MK reflects the report name, MM
reflects the month and Y reflects the last digit of the
year the record is created.
CSP payment will be made by the 20th of each month
for non-purchased receivables and by the 25th of the month
purchased receivables.
This report provides the CSP’s prior month billed
revenue. The report provides details by supplier
rate code(s), as well as a summary page.
For CSPs who participate in the Company’s
Accounts Receivable Purchase program (POR), the
report provides detail on the purchased receivables
and the supplier payment . This total will be reflected under
the Purchased AR column in the report.
April 2014
Columbia Gas of Virginia Choice Reference Manual
73
REV File - RS5500MK
April 2014
Columbia Gas of Virginia Choice Reference Manual
74
.REV File Format – DI18306-1
DI18306-1 Detail of Payments by CSP (Non-Purchased Accounts Receivables)
The XXXDIMMY.REV file, where XXX in the name of the file is an abbreviated three-digit code to identify the CSP
and State, DI reflects the report name, MM reflects the month and Y reflects the last digit of the year the record is
created.
This report provides a CSP with payment detail by Supplier rate code, and the total expected payment.
CSP payment will be made by the 20th of each month for non-purchased receivables.
April 2014
Columbia Gas of Virginia Choice Reference Manual
75
.REV File Format – DI18306-1
April 2014
Columbia Gas of Virginia Choice Reference Manual
76
Solicitation List Layout
Column 1
•
Filler
Columns 107-109
•
Filler
Columns 2-34
•
Customer Name
Columns 110-113
•
Street Address Zip + 4
Columns 35-37
•
Filler
Column 114-116
•
Filler
Columns 38-70
•
Service Address
Columns 117-149
•
Mailing Address
Columns 71-73
•
Filler
Columns 148-152
•
Filler
Columns 74-93
•
Service Address City
Columns 153-185
•
Mailing Address Overflow
Columns 94-96
•
Filler
Columns 186-188
•
Filler
Columns 97-98
•
Service Address State
Columns 189-208
•
Mailing City
Columns 99-101
•
Filler
Columns 209-211
•
Filler
Columns 102-106
•
Service Address Zip
Columns 212-213
•
Mailing State
April 2014
Columbia Gas of Virginia Choice Reference Manual
77
Solicitation List Layout (continued)
April 2014
Columns 214-216
•
Filler
Columns 256-258
• Filler
Columns 217-221
•
Mailing Zip code
Columns 259-262
• Location
Columns 222-224
•
Filler
Columns 263-270
• Filler
Columns 225-228
•
Mailing Address Zip +4
Columns 271-271
• Revenue Class
Column 229-231
•
Filler
Columns 272-274
• Filler
Columns 232-239
•
PCID
Columns 275-283
• Current Month Cons
Columns 238-240
•
Filler
Column 284-286
• Filler
Columns 241-243
•
Seq Number
Columns 287-292
• Current Month Cycle
Columns 242-246
•
Filler
Columns 293-295
• Filler
Columns 247-255
•
PCID
Columns 296-304
• Current Month -1 Cons
Columbia Gas of Virginia Choice Reference Manual
78
Solicitation List Layout (continued)
Columns 305-307
•
Filler
Columns 356-358
•
Filler
Columns 308-313
•
Current Month -1 Cycle
Columns 359-367
•
Current Month -4 Cons
Columns 314-316
•
Filler
Columns 368-370
•
Filler
Columns 317-325
•
Current Month -2 Cons
Columns 371-376
•
Current Month -4 Cycle
Columns 326-328
•
Filler
Columns 377-379
•
Filler
Columns 329-334
•
Current Month -2 Cycle
Columns 380-388
•
Current Month -5 Cons
Columns 335-337
•
Filler
Columns 389-391
•
Filler
Columns 338-346
•
Current Month -3 Cons
Columns 392-397
•
Current Month -5 Cycle
Column 347-349
•
Filler
Columns 350-355
•
Current Month -3 Cycle
April 2014
Columns 398-400
•
Filler
Columns 401-409
•
Current Month -6 Cons
Columbia Gas of Virginia Choice Reference Manual
79
Column 410-412
•
Filler
Solicitation List Layout (continued)
Columns 461-463
•
Filler
Columns 413-418
•
Current Month -6 Cycle
Columns 464-472
•
Current Month -9 Cons
Columns 419-421
•
Filler
Column 473-475
•
Filler
Columns 422-430
•
Current Month -7 Cons
Columns 476-481
•
Current Month -9 Cycle
Columns 431-433
•
Filler
Columns 482-484
•
Filler
Columns 434-439
•
Current Month -7 Cycle
Columns 485-493
•
Current Month -10 Cons
Columns 440-442
•
Filler
Columns 494-496
•
Filler
Columns 443-451
•
Current Month -8 Cons
Columns 497-502
•
Current Month -10 Cycle
Columns 452-454
•
Filler
Columns 503-505
•
Filler
Columns 455-460
•
Current Month -8 Cycle
Columns 506-514
•
Current Month -11 Cons
April 2014
Columbia Gas of Virginia Choice Reference Manual
80
Solicitation List Layout (continued)
Columns 515-517
•
Filler
Columns 518-523
•
Current Month -11 Cycle
April 2014
Columbia Gas of Virginia Choice Reference Manual
81
Capacity & Delivery Requirements
Section 4
April 2014
Columbia Gas of Virginia Choice Reference Manual
82
Pipeline Scheduling Point
The CSP must establish an Aggregation pool which consists of at least 100 customers or at least 10,000 mcf of
annual throughput. The aggregation pool is comprised of those customers within each CSP’s customer group located
within the same Pipeline Scheduling Point. The PSP is determined by the zip code at the service address. Columbia
will provide the zip code list. Following is list of each PSP.
Pipeline Scheduling Point (PSP)
Charlottesville
Norfolk
Lewisburg
Richmond
Rocksville
KY/WV MISC
April 2014
46-31
30CS-34
26-17
30CS-33
46-30
26-18
Columbia Gas of Virginia Choice Reference Manual
83
Capacity Assignment
As per the Statewide Choice Gas Supply Operations Plan, “the Company will assign each CSP upstream
interstate pipeline firm transportation service (“FTS”) capacity equal to 1/365th of the annual normalized demand of
the CSP’s Nomination Group(s) for the PSP where the customers reside.
•
As participation in the CHOICE program grows, city gate and upstream FTS capacity will be assigned to
participating CSPs, in order by the phases set forth below:
•
•
•
Phase 1:
Phase 2:
Phase 3:
•
Phase 4:
TCO FTS1 capacity and equivalent upstream CGT FTS-1 capacity
TCO Market Expansion FTS capacity, including Transco Zone 5 FTS capacity
Any additional FTS capacity acquired in the future to serve core market sales and CHOICE
customer demand
Long-haul Transco FTS capacity3
CGV is currently in Phase 1.
•
Each month, for each PSP, CGV will determine if an incremental assignment of FTS capacity is required. The
incremental capacity assignment will be equal to the company DDO of the CSP’s Nomination Group(s), minus the
capacity previously assigned to the CSP. If the result is zero or negative, no incremental capacity will be assigned
to the CSP.
•
Each assignment of capacity will be at the maximum applicable interstate pipeline tariff rate for a 12-month period.
Capacity Recall
•
FTS capacity assigned by the Company exceeds the Company calculated DDO
•
If CSP elects to quit the Choice program
April 2014
Columbia Gas of Virginia Choice Reference Manual
84
Daily Delivery Obligation (DDO)
The company will establish the Daily Delivery Obligation (Demand Curves) using the most recent 12-months normalized
historic usage for each customer within the participating CSP’s Nomination Group and dividing that total by 365.
Demand Curves are posted on the File Exchange database available on our columbiasuppliers.com websitei n 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.
•
Flow according to DDO Flat Demand
•
Demand Curves posted on or before the 20th of each month.
•
Chronic Imbalances is default condition and may result in the termination of the CSP.
•
Balancing point temperature is 62-degree.
•
Peak Demand Dth on Report 3 shows your customers' peak day consumption on Columbia’s design peak day.
Non Compliance Charges to Daily Delivery Obligation
Failure to deliver according to the DDO requirements will subject the CSP to the following charges:
•
Non OFO days – for under deliveries, the CSP shall purchase gas at the higher of 120% of the Daily Index
Price on the day that the under delivery occurred or 120% of the First of the Month Index Price, plus all
applicable upstream penalty costs. For over deliveries, CGV shall purchase gas from the CSP at the lower of
80% of the daily index price on the day of the over delivery or 80% of the First of the Month Index Price.
•
OFO days – for under deliveries, the CSP shall purchase gas at the higher of 120% of the Daily Index Price
on the day that the under delivery occurred or 120% of the First of the Month Index Price, plus $10.00 per
dth, plus all applicable upstream penalty costs. For over deliveries, CGV shall purchase gas from the CSP at
the lower of 80% of the daily index price on the day of the over delivery or 80% of the First of the Month
Index Price. In addition the CSP shall pay $10.00 per dth for all delivered volumes plus all upstream penalty
costs
April 2014
Columbia Gas of Virginia Choice Reference Manual
85
Balancing Service
Per the Statewide Choice Gas Operations Plan, CGV will support CSP (Competitive Service Provider)
deliveries by making up the difference between the CSP’s required daily delivery
obligation and the actual consumption of the CSP’s customers. In effect, CGV will balance
system deliveries on behalf of CSP customers in the same way that it balances deliveries to
its sales customers.
April 2014
Columbia Gas of Virginia Choice Reference Manual
86
Customer Billing & Rates
Section 5
April 2014
Columbia Gas of Virginia Choice Reference Manual
87
Billing Options
The Columbia Gas of Virginia allows the CSP to choose from two billing options in rendering a bill to a participating
customer. The CSP can opt for dual or consolidated billing. The billing option must selected at the time the CSP
signs the CSPS Agreement. Their election can be changed annually. Even with the new Purchase of
Receivables Agreement, the CSP currently still has the option of dual billing.
CSP (Dual Billing)
•
Gas Costs Only
Columbia Gas of Virginia (Consolidated Billing)
•
Transportation + Gas Costs
•
Transportation Only
•
There is no charge for billing and no administrative fees
April 2014
Columbia Gas of Virginia Choice Reference Manual
88
Time Line for Rate Codes
Example:
CGV RATE CODES
CSP has three accounts to flow gas on May 1st:
•
•
•
•
•
After the 1st day of the month, if any New Rate
Codes are established, CGV provides new and
existing rates to the CSP
May: 12345678-001-8
XXX03
$3.30
15678912-002-7
XXX03
$3.30
14789123-001-2
XXX03
$3.30
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.
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:
CSP has until 4 p.m. on the 20th of the month to
submit any new rate codes and changes. If the
20th is on the weekend/holiday, it is the previous
business day.
If the CSP submits any new rate codes or
changes, then CGV faxes a pre-bill asking the
CSP to review and confirm before Unit 21 bills.
CSP then confirms all new rate codes and
changes by signing the fax cover letter.
NOTE:
No response constitutes confirmation of Rates
April 2014
June: 12345678-001-8
XXX03
$3.30
15678912-002-7
XXX01
$2.00
14789123-001-2
XXX03
$3.30
CSP 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 CSP wishes to change in
July
In order for the CSP to affect the July billings for Customer 1
and 3, the CSP must submit a Rate Statement for a rate
code change to XXX03 by June 20th. (Proposed new
amount to be $2.95/Mcf)
July: 12345678-001-8
XXX03
$2.95
15678912-002-7
XXX01
$2.00
14789123-001-2
XXX03
$2.95
Note: No Change to .DAT file was needed
Columbia Gas of Virginia Choice Reference Manual
89
Manual Marketer Rate Code Process
Establishing a new rate code:
•
To request a new rate code, the CSP must
email their Choice Analyst a minimum of
45 days prior to the flow month.
(ex: requested by 5/15 available 7/1)
•
Dollar values must be submitted at the time
of the request for new rate codes to
prevent an account from being added to a
rate code that has no dollar value attached.
Once the rate code has been created, if
the dollar value needs to be changed, this
can be done using the automated rate
entry process by the 20th of the month.
•
If the 20th fall on a weekend or holiday the
new rates are due the previous business
day.
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 Virginia Choice Reference Manual
90
CGV Rate Process: Rate Changes
The XXXRATE.DAT file is an automated process utilized by the CSP to change the price point attached to their marketer
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, Marketer 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 CSP will submit changes using their 5 digit market rate code and a 7 digit dollar value. The dollar value
must be submitted with a decimal point between the dollars and cents fields.
Example:
ABC12 XX.XXXX
The CSP must start with a clean Rate.Dat file every day. An “empty” Rate.Dat file is posted daily.
It’s recommend that 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 CSP 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 the CSPs will receive an RAC2. The RAC2, final acceptance 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 marketer rate code changes that are
submitted manually. Hard copy pre-bills will still be sent for them.
April 2014
Columbia Gas of Virginia Choice Reference Manual
91
Supplier Invoicing
Section 6
April 2014
Columbia Gas of Virginia Choice Reference Manual
92
Supplier Invoicing
Monthly Billing
•
The CSP 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 CSP begins
approximately the 6th working day of the month.
•
If the CSP participates in the Purchase of Receivables Program, the receivables credit amount will appear on the
invoice. An adjustment will be processed to reflect any amount owed CGV and will be withheld from the
receivables.
•
Payment for the prior month billing will be made by the 20th of the month to the CSP that has non purchased
receivables and by the 25th of the month to the CSP that has purchased receivables .
Annual Reconciliation
•
On March 31st of each year, Columbia will reconcile the imbalance between CSP’s deliveries and their
customer’s usage for the 12- month period ending March 31st. If the imbalance is negative, the CSP must
purchase the deficient volume from Columbia at the average of the Frist of the Month indices for each of the prior
twelve months. If the imbalance is positive, the Company will purchase the excess from the CSP at the same
index.
April 2014
Columbia Gas of Virginia Choice Reference Manual
93
Monthly Bill Image
RATE SCHEDULE INFORMATION
Nomination Group: 0000
True-Up Period: OPT 1 YRLY
Next true-up date : MAR 20xx
Rate Schedule: MSF
Rate
Volume
Amount
Rate Schedule MSF Total
Bank Penalty
0.0000
$0.00
54,658.00
$0.00
Nomination Group 0000 Total
$0.00
Current Charges Total
$0.00
SUMMARY OF GAS RECEIPTS
Nom Group
0000
From Date To Date
Shipper
MM-DD-YYYYMM-DD-YYYYSUPPLIER
Source
INTER: TCO
Dth
38,566
Mcf
0
IMBALANCE/ALLOCATION SUMMARY
Nomination Group 0000
INTER: TCO
(Dth)
Beginning Imbalance
78,685.2
Current Month Activity
Volume Received
Adjustment
Allocations
38,566.0
0.0
19,032.0
Remaining Volume
Unbilled Imbalance
Monthly Imbalance
Ending Imbalance
98,219.2
0.0
0.0
98,219.2
Average Btu of 1.023
April 2014
Columbia Gas of Virginia Choice Reference Manual
94
Annual Reconciliation (continued)
Deliveries by CSP
CSPs 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 CSP that was
consumed by their customers, but not yet billed. Payments for this imbalance gas will be included in the April
payment.
Please note the imbalance due to unbilled volumes is 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.
April 2014
Columbia Gas of Virginia Choice Reference Manual
95
Bill Image – Annual Reconciliation
RATE SCHEDULE INFORMATION
Nomination Group: 0000
True-Up Period: OPT 1 YRLY
Next true-up date :MAR 20XX
Rate Schedule: MSF
Rate
Volume
Amount
$0.00
Rate Schedule MSF Total
$92,685.29 Credit
18,645.2
4.9710
Bank Purchase Credit (Dth)
$92,685.29 Credit
Nomination Group 9999 Total
$92,685.29 Credit
Current Charges Total
$92,685.29 Credit
SUMMARY OF GAS RECEIPTS
Nom Group
0000
From Date To Date
Shipper
03-01-20XX 03-31-20XX SUPPLIER
Source
INTER: TCO
Dth
Mcf
37,539
IMBALANCE/ALLOCATION SUMMARY
Nomination Group 0000
INTER: TCO
(Dth)
Beginning Imbalance
65,288.0
Current Month Activity
Volume Received
Adjustment
Allocations
37,539.0
0.0
54,826.8
Remaining Volume
Unbilled Imbalance
Monthly Imbalance
Ending Imbalance
48,000.2
29,355.0
(18,645.2)
29,355.0
Average Btu of 1.03
April 2014
Columbia Gas of Virginia Choice Reference Manual
96
Aviator
Section 7
April 2014
Columbia Gas of Virginia Choice Reference Manual
97
Accessing the GTS Bill Viewer
The Choice CSP can access their GTS invoices for their company through the Aviator website (www.ldcaviator.com).
This allows the CSP easy access to view their invoices 24 hours a day.
You must request an access code from your Choice Analyst
April 2014
Columbia Gas of Virginia Choice Reference Manual
98
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 Virginia Choice Reference Manual
99
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 launched displaying
the invoice in .pdf format.
April 2014
Columbia Gas of Virginia Choice Reference Manual
100
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 and GTS customers. It is
viewed by Columbia and the Marketer. The site is password protected. Each person responsible for
monitoring the Concern Database will be assigned a User ID and password.
Benefits to the Marketer 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 Marketer knows the concerns of its own customers
April 2014
Columbia Gas of Virginia Choice Reference Manual
101
Customer Concern Database (continued)
Marketers are encouraged to check
the database daily, as there is a three
day response time.
•
•
•
April 2014
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
Columbia Gas of Virginia Choice Reference Manual
102
Customer Concern Database (continued)
The Marketer 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 Virginia Choice Reference Manual
103
Customer Concern Database (continued)
•
Click on the ID of the concern in the Waiting for
Marketer 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 Virginia Choice Reference Manual
104
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
(CTRLClick).
•
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 Virginia Choice Reference Manual
105