bl_dailyposition

Daily Financial Position Report

Current Status
Report Name	Change Summary	Effective Date	Description	Template	Sample
bl_dailyposition	Modified. No change in report structure, a new Monthly Market "Transitional Demand Response" will be reported.	06.01.2012	PDF	XLTX	CSV
View Archived Status at the foot of this page

BL_DAILYPOSITION - Daily Financial Position Report - Rev 0

BL_DAILYPOSITION_<customer id>_<date>_<version>.CSV
<Customer Name>
Date: mm/dd/yyyy and Version: mm/dd/yyyy hh:mm:ss GMT
Availability: Daily to active Participants and Non-Participants.

REPORT COLUMN

DESCRIPTION

Description

The description of the market or standard settlement or a label if the row is a section header or section total. The Description column will contain the following section header and section total rows:

Hourly Markets	This section header will appear prior to the listing of the hourly markets.
Hourly Markets Total	This section total will appear following the listing of the hourly markets. The value in the Total and each day column will be the sum of the hourly market settlement results.
Daily Markets	This section header will appear prior to the listing of the daily markets.
Daily Markets Total	This section total will appear following the listing of the daily markets. The value in the Total and each day column will be the sum of the daily market settlement results.
Total Hourly/Daily Markets	This section total will appear following the "Daily Markets Total" row. The value in the Total and each day column will be the sum of the hourly and daily market settlement results.
Total Billed Amount	This section total will appear following the "Total Hourly/Daily Markets" row. The value in the Total and each Day column will represent the total amount that has been billed of all hourly and daily market settlement results.
Net Amount Due	This section total will appear following the "Total Billed Amount" row. The value in the Total and each day column will represent the "Total Hourly/Daily Markets" minus the "Total Billed Amount".

Total

A cumulative total of the thirty Operating Days reported. This column will be NULL on section header rows.

MM/DD/YYYY

Thirty columns representing the net credits and charges for a single Operating Day labeled as <MM/DD/YYYY>. A positive value represents a payment, a negative value represents a charge. These columns will be NULL on section header rows.

REPORT COLUMN

DESCRIPTION

Section 2 (Monthly Markets)
This section will contain settlement results for the monthly markets with subsections for preliminary and monthly market settlement results. A preliminary monthly market is a settlement that is run early in the month to provide preliminary results for that market. These line items will be reported in this section until the monthly settlement is run for the market for the obligation month. The Monthly Markets section will include a line item for each monthly market service and standard settlement for each obligation month in which MIS reports have been approved and distributed within the last 30 days. This section will only include markets and obligation months that have not been previously billed. All monthly market services and standard settlements will be listed regardless of whether the customer has a Credit or Charge. Any standard settlements that roll up to a monthly market on the bill will also roll up to that market on this report.

Description

Preliminary Monthly Markets	This section header will appear prior to the listing of the preliminary monthly markets.
Preliminary Monthly Markets Total	This section total will appear following the listing of the preliminary monthly markets. The value in the "Monthly Total" column will be the sum of the preliminary monthly market settlement results.
Monthly Markets	This section header will appear prior to the listing of the monthly markets.
Monthly Markets Total	This section total will appear following the listing of the monthly markets. The value in the "Monthly Total" column will be the sum of the final monthly market settlement results.
Total Billed Amount	This section total will appear following the "Monthly Markets Total". The value in the "Monthly Total" column will represent the total amount that has been billed for all monthly markets.
Net Amount Due	This section total will appear following the "Total Billed Amount". The value in the "Monthly Total" column will represent the "Final Monthly Markets" minus the "Total Billed Amount".

Obligation Month

The obligation month of the monthly market settlement results. This column will be NULL when there is no settlement that has been approved and distributed in the last thirty days for the line item, and will also be NULL on section header and section total rows

Monthly Total

The net credits and charges for the obligation month. A positive value represents a payment, a negative value represents a charge. This column will be NULL when there is no settlement that has been approved and distributed in the last thirty days for the line item, or the customer was not part of the settlement, and will also be NULL on section header rows.

Section 3 (Resettled Markets)
This section will report resettlements of the hourly, daily, and monthly markets (including standard settlements) in which MIS reports have been approved and distributed within the last thirty days. The resettlements may be the result of the Data Reconciliation process, the Meter Data Error Requested Billing Adjustment (RBA) process, or any other resettlements of markets for obligation months that have been previously billed. Settlement results will be reported at the monthly level and all hourly/daily/monthly market services and standard settlements will be listed regardless of whether the customer has a Credit or Charge. Any standard settlements that roll up to an hourly/daily/monthly market on the bill will also be rolled up to that market in this section.

Description

The description of the market being reported or a label if the row is a section header or section total. The Description column will contain the following section header and section total rows:

Resettled Markets	This section header will appear prior to the "Hourly Markets" row.
Hourly Markets	This section header will appear prior to the listing of the hourly markets.
Hourly Markets Total	This section total will appear following the listing of the hourly markets. The value in the "Previously Billed Settlement Amount", "Resettlement Amount", and "Adjustment Amount" columns will be the sum of the hourly market settlement results.
Daily Markets	This section header will appear prior to the listing of the daily markets.
Daily Markets Total	This section total will appear following the listing of the daily markets. The value in the "Previously Billed Settlement Amount", "Resettlement Amount", and "Adjustment Amount" columns will be the sum of the daily market settlement results.
Monthly Markets	This section header will appear prior to the listing of the monthly markets.
Monthly Markets Total	This section total will follow the listing of the monthly markets. The value in the "Previously Billed Settlement Amount", "Resettlement Amount", and "Adjustment Amount" columns will be the sum of the monthly market settlement results.
Total Hourly/Daily/Monthly Markets Total	This section total will appear following the "Monthly Markets Total" row. The value in the "Previously Billed Settlement Amount", "Resettlement Amount", and "Adjustment Amount" columns will be the sum of the hourly, daily, and monthly market settlement results.
Total Billed Amount	This section total will appear following the "Total Hourly/Daily/Monthly Markets Total" row. The value in "Previously Billed Settlement Amount" and "Resettlement Amount" will be NULL. The value in the "Adjustment Amount" column will represent the total amount that has been billed of the "Adjustment Amount" for the hourly, daily, & monthly markets.
Net Amount Due	This section total will appear column following the "Total Billed Amount" row. The value in the "Previously Billed Settlement Amount" and "Resettlement Amount" columns will be NULL. The value in the "Adjustment Amount" column will represent the "Total Hourly/Daily/Monthly Markets Total" minus the "Total Billed Amount".

Obligation Month

The obligation month of the hourly, daily, or monthly market settlement results. This column will be NULL when there is no settlement that has been approved and distributed in the last thirty days for the line item and will also be NULL on section header rows, section total rows and the "Total Billed Amount" and "Net Amount Due" rows.

Previously Billed Settlement Amount

The net credits and charges for the market for the obligation month from the previously billed settlement. A positive value represents a payment, a negative value represents a charge. This column will be NULL when there is no settlement that has been approved and distributed in the last thirty days for the line item, or the customer was not part of the settlement, and will also be NULL on section header rows and the "Total Billed Amount" and "Net Amount Due" rows.

Resettlement Amount

The net credits and charges for the market for the obligation month for the resettlement in which MIS reports were approved and distributed within the last thirty days. This settlement may or may not be billed. A positive value represents a payment, a negative value represents a charge. This column will be NULL when there is no settlement that has been approved and distributed in the last thirty days for the line item, or the customer was not part of the settlement, and will also be NULL on section header rows and the "Total Billed Amount" and "Net Amount Due" rows.

Adjustment Amount

This value is result of the "Resettlement Amount" minus the "Previously Billed Settlement Amount" for the market for the obligation month. A positive value represents a payment, a negative value represents a charge. This column will be NULL when there is no resettlement that has been approved and distributed in the last thirty days for the line item, or the customer was not part of the settlement, and will also be NULL on section header rows.

Section 4 (Billing Adjustments)
This section includes net Credits and Charges for miscellaneous billing adjustments that have been created in the last thirty days. Only those billing adjustments that the customer has a Credit or Charge for will appear in this section.

Description

The description of the billing adjustment being reported or a label if the row is a section header or section total. The Description column will contain the following section header and section total rows:

Billing Adjustments	This section header will appear prior to the listing of the billing adjustments.
Billing Adjustments Total	This section total will appear following the listing of the billing adjustments. The value in the Total columns will be the sum of the billing adjustments
Total Billed Amount	This section total will appear following the "Billing Adjustments Total" label. The value in the Total column will represent the total amount that has been billed of the billing adjustments
Net Amount Due	This section total will appear following the "Total Billed Amount" row. The value in the Total column will represent the "Billing Adjustment Total" minus the "Total Billed Amount".

Reference

Additional detail for the billing adjustment. This column will always be NULL on section header and section total rows and may be NULL on manual billing adjustment line items.

Obligation Date

The obligation date of the billing adjustment. This column will be NULL on section header and section total rows

Total

The net Credits and Charges for the obligation date for the billing adjustment. A positive value represents a payment, a negative value represents a charge. This column will be NULL on section header rows

Archived Status
Report Name	Change Summary	Effective Date
bl_dailyposition	Modified. No change in report structure, only data change. ARR Dollars will be rolled up and reported in same line item if multiple rounds held in annual actions (planned in 2013).	01.01.2012
bl_dailyposition	Modified. No changes in report structure, only data change. The following existing RNS and TOUT line items: ISO Schedule 1 for RNS; ISO Schedule 1 for TOUT; ISO Schedule 5 NESCOE; OATT-Regional Network Service; and OATT-Through or Out Service will be replaced and reported with below list of new RNS and TOUT line items: ISO Schedule 1 RNS; ISO Schedule 1 TOUT; ISO Schedule 5 NESCOE; OATT Schedule 1 RNS; OATT Schedule 9 RNS; OATT Schedule 8 TOUT and OATT Schedule 1 TOUT for any resettlement prior to obligation month Oct 1st 2010 or any new settlements effective Oct. 1st 2010 in Monthly and Resettlement sections of this report.	10.01.2010
bl_dailyposition	New. This report will be released no earlier than September 29, 2010 to all active customers registered as a Participant or non-participant.	09.29.2010

Legal & Privacy | Contact Us

Current Status

View Archived Status at the foot of this page

BL_DAILYPOSITION - Daily Financial Position Report - Rev 0