Remaining responses to PUC data Requests 11 and 12

Celia B. O’Brien
Assistant General Counsel and Director
October 29, 2014
VIA HAND DELIVERY & ELECTRONIC MAIL
Luly E. Massaro, Commission Clerk
Rhode Island Public Utilities Commission
89 Jefferson Boulevard
Warwick, RI 02888
RE:
Docket 1725 - Termination Rules 2014
Responses to PUC Data Requests – Set 1
Dear Ms. Massaro:
On behalf of National Grid1, I have enclosed ten (10) copies of the Company’s remaining
responses, PUC 2014-11 and PUC 2014-12, to the Rhode Island Public Utilities Commission’s
(PUC) First Set of Data Requests issued on October 8, 2014.
This transmittal completes the Company’s responses to the PUC’s First Set of Data
Requests issued in 2014 in the above-referenced docket. As requested by the PUC, the Company
expects to file supplemental responses to PUC 2014-13, PUC 2014-14, and PUC 2014-16 within
two weeks.
Thank you for your attention to this filing. If you have any questions concerning this
transmittal, please contact me at 781-907-2153.
Very truly yours,
Celia B. O’Brien
Enclosures
cc:
1
Docket 1725 Service List
Leo Wold, Esq.
Steve Scialabba, Division
The Narragansett Electric Company d/b/a National Grid (National Grid or the Company).
40 Sylvan Road, Waltham, MA 02451
T: 781-907-2153[email protected] www.nationalgrid.com
Certificate of Service
I hereby certify that a copy of the cover letter and/or any materials accompanying this certificate
were electronically transmitted and sent via U.S. Mail to the individuals listed below.
Copies of this filing were hand delivered to the RI Public Utilities Commission and to the RI
Division of Public Utilities Carriers.
___________________________________
October 2, 2014
Joanne M. Scanlon
Date
Docket No. 1725 – Termination Rules
Service List as of 4/3/14
Name/Address
E-mail Distribution
Phone
File original & nine (9) copies file w/:
Luly E. Massaro, Commission Clerk
Public Utilities Commission
89 Jefferson Blvd.
Warwick, RI 02888
Marion S. Gold, Administrator
RI Office of Energy Resources
[email protected]
[email protected]
[email protected]
[email protected]
401-780-2107
[email protected]
[email protected]
401-574-9119
Christopher Kearns, Program Service Officer
RI Office of Energy Resources
Henry Shelton
The George Wiley Center
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
Raquel Webster, Esq.
National Grid
Michael R. Kirkwood, General Mgr./CEO
Pascoag Utility District
Michael McElroy, Esq. (for BIPCo)
Leo Wold, Esq.
Dept. of Attorney General
Jim Lanni, Division of Public Utilities
Jane Briesemeister, AARP
Deanna Casey, AARP
Marie Ganim
Steven Hartford, Governor’s Office Policy Dir.
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
401-728-5555
781-907-2121
401-568-6222
401-351-4100
401-222-2424
401-941-4500
401-222-8135
The Narragansett Electric Company
d/b/a National Grid
RIPUC Docket No. 1725
In Re: Termination Rules 2014
Responses to Commission’s First Set of Data Requests
Issued October 8, 2014
PUC 2014-11
Request:
Please indicate the number of residential gas and electric accounts for the period November 2013
through April 2014 that have no customer payments for any month (grant-only payments should
be separately identified). Please break out between protected and standard. Please also indicate
the percentage of the total bills.
Response:
Please see Attachment PUC 2014-11 containing the requested data, along with field descriptions
and decode values.
Prepared by or under the supervision of: Jeffrey P. Martin
The Narragansett Electric Company
d/b/a National Grid
RIPUC Docket No. 1725
Attachment PUC 2014-11
Page 1 of 2
CD_CO
49
49
49
49
PERIOD
201311 - 201404
201311 - 201404
201311 - 201404
201311 - 201404
CD_SPT_TYPE
0100
0100
0200
0200
FL_PROTECTED
N
Y
N
Y
TOT_CNT
202,468
29,762
369,084
60,324
NO_OTHER_PMT
29,901
7,114
50,002
8,813
% OF TOTAL
14.8%
23.9%
13.5%
14.6%
Definitions and decodes:
CD_CO
FL_PROTECTED
TOT_CNT
NO_OTHR_PMT
NO_GRANT_PMT
49 = The Narragansett Electric Company
Y = Account currently has Special Handling Code or Low Income Rate (see below)
Count of current active accounts
Number of accounts with no OTHER (non-grant) payments found for respective period
Number of accounts with no GRANT payments found for respective period
CD_SPT_TYPE
0100 - Gas
0200 - Electric
Low Income Rates:
CD_CO
49
49
49
49
49
49
CD_TAR_SCH
006
007
008
009
010
905
Special Handling Codes:
06
11
12
21
32
33
36
37
38
39
40
41
42
43
44
Low Income
Low Inc Eld VI Disable
Elderly VI Disabled
LIFE SUPPORT
Hardship
Unemployed
Low Income Credit Dept
Low Income Hardship
Low Income Welfare
Low Income Unemployed
Medical
Low Income/Medical
Outage Life Support
Infant Hardship
Low Inc Infant Hardship
CD_TAR_RT_CL
A60
A60
A60
A60
A60
A60
CD_LOAD_PROFILE
A60
A60
A60
A60
A60
A60
TX_TAR_SCH_DESC
Elec A-60 Resi Low Income-Std Ofr
Elec A-60 Resi Low Income-Std Ofr 2
Elec A-60 Resi Low Income-Std Ofr 11
Elec A-60 Resi Low Income-Std Ofr 12
Elec A-60 Resi Low Income-Last Resort
Elec A-60 T&D Resi Low Income
NO_GRANT_PMT
202,438
21,469
369,083
58,645
% OF TOTAL
100.0%
72.1%
100.0%
97.2%
The Narragansett Electric Company
d/b/a National Grid
RIPUC Docket No. 1725
Attachment PUC 2014-11
Page 2 of 2
Payment Types:
CD_PMT_CR_SRCE
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
PMT_TYPE
GRANT
GRANT
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
CD_PMT_SOURCE
AC
AL
BA
CB
CF
CO
DP
EF
EP
FA
HE
IC
JP
MR
MT
NR
PA
PB
PC
PE
PH
PM
PR
PS
RL
RU
SP
SS
ST
WB
WC
WU
Decode Description
Associated Credit
Allied Account Svcs, Inc
Bank of America
EOS CCA
Check Free
NCO Collection Agency
Customer Directed Payment
EFT
Emergency Payment
Fuel Assistance
Heap Payments
I.C. Systems, Inc
JPMorgan
Mercantile
Metavante
National Recovery Agy
Credit Protection Agency
Pay by Phone
Manual Paycode Entry
Penn Credit Corporation
Price Chopper
Paymode
Princeton
RPPS Third Party Payment
Regulus Lockbox
Recovery Unlimited, Inc.
Western Union Speedpay
Solomon and Solomon
Stevens Business Svcs
Web Payment
Wachovia
Western Union
The Narragansett Electric Company
d/b/a National Grid
RIPUC Docket No. 1725
In Re: Termination Rules 2014
Responses to Commission’s First Set of Data Requests
Issued October 8, 2014
PUC 2014-12
Request:
Please indicate the number of residential gas and electric accounts for the period May 2014
through to date that have no customer payments for any month (grants are not customer
payments). Please break out between protected and standard. Please also indicate the percentage
of the total bills.
Response:
Please see Attachment PUC 2014-12 containing the requested data, along with field descriptions
and decode values.
Prepared by or under the supervision of: Jeffrey P. Martin
The Narragansett Electric Company
d/b/a National Grid
RIPUC Docket No. 1725
Attachment PUC 2014-12
Page 1 of 2
CD_CO
49
49
49
49
PERIOD
201405 - 201410
201405 - 201410
201405 - 201410
201405 - 201410
CD_SPT_TYPE
0100
0100
0200
0200
FL_PROTECTED
N
Y
N
Y
TOT_CNT
202,468
29,762
369,084
60,324
NO_OTHER_PMT
32,088
9,519
38,248
7,723
% OF TOTAL
15.8%
32.0%
10.4%
12.8%
Definitions and decodes:
CD_CO
FL_PROTECTED
TOT_CNT
NO_OTHR_PMT
NO_GRANT_PMT
49 = The Narragansett Electric Company
Y = Account currently has Special Handling Code or Low Income Rate (see below)
Count of current active accounts
Number of accounts with no OTHER (non-grant) payments found for respective period
Number of accounts with no GRANT payments found for respective period
CD_SPT_TYPE
0100 - Gas
0200 - Electric
Low Income Rates:
CD_CO
49
49
49
49
49
49
CD_TAR_SCH
006
007
008
009
010
905
Special Handling Codes:
06
11
12
21
32
33
36
37
38
39
40
41
42
43
44
Low Income
Low Inc Eld VI Disable
Elderly VI Disabled
LIFE SUPPORT
Hardship
Unemployed
Low Income Credit Dept
Low Income Hardship
Low Income Welfare
Low Income Unemployed
Medical
Low Income/Medical
Outage Life Support
Infant Hardship
Low Inc Infant Hardship
CD_TAR_RT_CL
A60
A60
A60
A60
A60
A60
CD_LOAD_PROFILE
A60
A60
A60
A60
A60
A60
TX_TAR_SCH_DESC
Elec A-60 Resi Low Income-Std Ofr
Elec A-60 Resi Low Income-Std Ofr 2
Elec A-60 Resi Low Income-Std Ofr 11
Elec A-60 Resi Low Income-Std Ofr 12
Elec A-60 Resi Low Income-Last Resort
Elec A-60 T&D Resi Low Income
NO_GRANT_PMT
202,446
24,425
369,073
59,352
% OF TOTAL
99.99%
82.07%
100.00%
98.39%
The Narragansett Electric Company
d/b/a National Grid
RIPUC Docket No. 1725
Attachment PUC 2014-12
Page 2 of 2
Payment Types:
CD_PMT_CR_SRCE
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
PMT_TYPE
GRANT
GRANT
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
OTHER
CD_PMT_SOURCE
AC
AL
BA
CB
CF
CO
DP
EF
EP
FA
HE
IC
JP
MR
MT
NR
PA
PB
PC
PE
PH
PM
PR
PS
RL
RU
SP
SS
ST
WB
WC
WU
Decode Description
Associated Credit
Allied Account Svcs, Inc
Bank of America
EOS CCA
Check Free
NCO Collection Agency
Customer Directed Payment
EFT
Emergency Payment
Fuel Assistance
Heap Payments
I.C. Systems, Inc
JPMorgan
Mercantile
Metavante
National Recovery Agy
Credit Protection Agency
Pay by Phone
Manual Paycode Entry
Penn Credit Corporation
Price Chopper
Paymode
Princeton
RPPS Third Party Payment
Regulus Lockbox
Recovery Unlimited, Inc.
Western Union Speedpay
Solomon and Solomon
Stevens Business Svcs
Web Payment
Wachovia
Western Union