ss_genericss
Generic Standard Settlement

Current Status

Report Name

Change Summary

Effective Date

Description

Template

Sample

ss_genericss Existing. This is not an actual report file. This is only a sample generic file showing all columns being populated. It is used as a guide when creating Standard Settlement files. 03.01.2008 PDF XLTX CSV

 

SS_GENERICSS - Generic Standard Settlement Report - Rev 0

SS_<report_name>_<customer id>_<settlement date>_<version>.CSV
Date: mm/dd/yyyy and Version: mm/dd/yyyy hh:mm:ss GMT

Availability: Determined by associated market service

REPORT COLUMN

DESCRIPTION

CALCULATION

Trading Date

Specific period for which the data is reported in form MM/DD/YYYY.

Trading Interval

Specific hour for which the information is reported.
Numeric from 1 - 24 (For daylight-saving crossover days: the long day extra hour = 02X, the short day removes hour 02).

DUNS Number

Number used to identify the "entity responsible for the customer's bill".

DUNS Name

Name associated with DUNS Number.

Asset ID

Numerical identifier for the asset.

Asset Name

Name of the asset.

Location ID

Numerical identifier for the location related to the specific standard settlement item.

Location Name

Name of the location.

Calculation Description

Description of the calculation.

Rate

Rate associated with Total Asset Dollars.

Quantity

Quantity associated with Total Asset Dollars.

Total Asset Dollars

Total dollars calculated for the asset, as determined by the specific standard settlement item.

Allocation Share

Percentage of the asset for which the customer is responsible, as determined by the specific standard settlement item.

Customer Dollars

Total dollars calculated for the customer, as determined by the specific standard settlement item.

Comments

Comments associated with each record, as determined by the specific standard settlement item.

ALLOCATION

Trading Date

Specific period for which the data is reported in form MM/DD/YYYY.

Trading Interval

Specific hour for which the information is reported.
Numeric from 1 - 24 (For daylight-saving crossover days: the long day extra hour = 02X, the short day removes hour 02).

DUNS Number

Number used to identify the "entity responsible for the customer's bill".

DUNS Name

Name associated with DUNS Number.

Asset ID

Numerical identifier for the asset.

Asset Name

Name of the asset.

Location ID

Numerical identifier for the location related to the specific standard settlement item.

Location Name

Name of the location.

Allocation Description

Detail of the method used to distribute dollars associated with the specific standard settlement item.

Total Allocation Factor

Sum of the customer allocation factor(s).

Customer Allocation Factor

Customer value as determined by the method used to distribute dollars associated with the specific standard settlement item.

Total Dollars

Sum of the calculated credits or charges being allocated.

Customer Dollars

(Customer Allocation Factor/Total Allocation Factor) x Total Dollars

Comments

Comments associated with each record, as determined by the specific standard settlement item.

  Copyright ©2014 ISO New England Inc.