DDQ Data

DDQ Data

H3 Monthly DDQ Basis Report

365 Days

This report provides marketers with projected monthly DDQs and peak day DDQs at the account level and the components used to calculate them. This report is provided to the marketers on the 23rd of each month.

I3 Monthly DDQ Basis File

365 Days

Marketer id7 ch
Aggregation group id9 ch
Delivery Pool ID7 ch
DDQ Start Date8 ch (yyyymmdd)
DDQ End Date8 ch (yyyymmdd)
Ratepayer Billing ID (RBA)7 ch
Check Digit2 ch
Customer Last Name20 ch
Customer First name12 ch
Customer Middle Initial1 ch
State Code2 ch
Revenue Class2 ch
Service Class2 ch
Baseload7 ch
Degree Day Factor5.3 ch
DDQ Algorithm1 ch
DDQ Pending On Date8 ch (yyyymmdd)
DDQ Pending Off Date8 ch (yyyymmdd)
Daily Delivery Quantity (DDQ)5.1 ch (31 occurences)
Peak Daily Delivery Quantity (PDDQ)5.1 ch (31 occurences)

J3 6-Day DDQ Basis Report

62 Days

This report provides marketers with the following 6 days of projected DDQs and peak day DDQs at the account level and the components used to calculate them. This report is provided to the marketers on each business day.

K3 6-Day DDQ Basis File

62 Days

Marketer id7 ch
Aggregation group id9 ch
Delivery Pool ID7 ch
DDQ Start Date8 ch (yyyymmdd)
DDQ End Date8 ch (yyyymmdd)
Ratepayer Billing ID (RBA)7 ch
Check Digit2 ch
Customer Last Name20 ch
Customer First name12 ch
Customer Middle Initial1 ch
State Code2 ch
Revenue Class2 ch
Service Class2 ch
Baseload7 ch
Degree Day Factor5.3 ch
DDQ Algorithm1 ch
DDQ Pending On Date8 ch (yyyymmdd)
DDQ Pending Off Date8 ch (yyyymmdd)
Daily Delivery Quantity (DDQ)5.1 ch (6 occurences)
Peak Daily Delivery Quantity (PDDQ)5.1 ch (6 occurences)

K4 Daily DDQ Midcourse Report

93 Days

This report lists all customers that have a midcourse adjustment to the monthly DDQ. This report is available daily.

K5 Daily DDQ Midcourse File

93 Days

A semi-colon delimited file:

Aggregator Identification Number7 ch
Aggregator Group Identification Number9 ch
Delivery Pool Identification7 ch
Daily Demand Quantity Start Date8 ch (yyyymmdd)
Daily Demand Quantity End Date8 ch
Ratepayer Number ID9 ch
Ratepayer Last Name20 ch
Ratepayer First Name12 ch
State Code2 ch
Account Revenue Class2 ch
Service Class Code2 ch
Base Load7 ch
Degree Day Factor9 ch (5.3)
DDQ Algorithm Used1 ch
Daily Demand Quantity On Date8 ch (yyyymmdd)
Daily Demand Quantity Off Date8 ch (yyyymmdd)
Mid Course9 ch (-6.1) (31 occurances)

L2 Monthly DDQ Cumulative Report

365 Days

This report is generated on the final business day of each month and provides marketers with final DDQ forecasts for their accounts during the month.

L3 Monthly DDQ Cumulative File

365 Days

Marketer id7 ch
Aggregation group id9 ch
Delivery Pool ID7 ch
DDQ Start Date8 ch (yyyymmdd)
DDQ End Date8 ch (yyyymmdd)
Ratepayer Billing ID (RBA)7 ch
Check Digit2 ch
Customer Last Name20 ch
Customer First Name12 ch
Customer Middle Initial1 ch
State Code2 ch
Revenue Class2 ch
Service Class2 ch
Baseload7 ch
Degree Day Factor5.3 ch
DDQ Algorithm1 ch
DDQ Pending On Date8 ch (yyyymmdd)
DDQ Pending Off Date8 ch (yyyymmdd)
Daily Delivery Quantity (DDQ)5.1 ch (31 occurences)
Peak Daily Delivery Quantity (PDDQ)5.1 ch (31 occurences)

NY Home NY Business
PA Home PA Business