Electric Quarterly Report Informational Template Transactions
2/25/2005
A 1
Field # Title 46
B
47 Transaction Unique ID
C
48 Seller Company Name
D
49
E
50
F
51 FERC Tariff Reference
G
52 Contract Service Agreement ID
H
53
I
54
J
55 Time Zone Transaction End Date
K
56
L
Point of Delivery Control Area
Customer Company Customer DUNS Name Number
Transaction Unique Transaction Begin Date Identifier
2
Type Text * Required 70 Required Must match Seller Company Name in the Contract template. Text 70 Required Numeric 9 Required Text 60 Required Valid FERC Rate Schedule or Tariff Reference. Must match FERC Tariff Reference in the Contract template. The FERC Tariff Reference is not the Docket #. Examples are: FERC Electric Tariff Original Vol. No. 2 or Rate Schedule No. 1. Text 30 Required Must match the Contract Service Agreement ID listed in the Contracts template. Text 24 Required Company Selected Designation for a Transaction. It has a one-to-one relationship with the T#. Date &Time 12 Required The Import format is YYYYMMDDHHMM. The date must be within The reporting quarter. The Transaction Begin Date/Time must be before the Transaction End Date/Time. Midnight is either 2359 or 0000 of next day. 2400 not allowed. Date &Time 12 Required The Import format is YYYYMMDDHHMM. The date must be within The reporting quarter. The Transaction End Date/Time must be after Transaction Begin Date/Time. Midnight is either 2359 or 0000 of next day. 2400 not allowed. Restricted Text 2 Required Valid Values: AD - Atlantic Daylight AP - Atlantic Prevailing AS - Atlantic Standard CD - Central Daylight CP - Central Prevailing CS - Central Standard ED - Eastern Daylight EP - Eastern Prevailing ES - Eastern Standard MD - Mountain Daylight MP - Mountain Prevailing MS - Mountain Standard NA - Not Applicable PD - Pacific Daylight PP - Pacific Prevailing PS - Pacific Standard UT - Universal Time Text 50 Required Valid Name of NERC Control Area. See the Users Guide for valid values.
3 4 5
Field Length Mandatory
Restricted Values Number must start with a T. After import it will convert to a system generated number.
Must match Valid 9 digit DUNS Customer Company Number. No dashes. Name in the No slashes. Contract template.
6
1
Electric Quarterly Report Informational Template Transactions
2/25/2005
M 1
57 Point of Delivery Specific Location 58
N
59 Class Name
O
60 Term Name
P
61 Increment Name
Q
62 Increment Peaking Name Product Name
R
63
S
64 Price Transaction Quantity
T
65
U
66 Rate Units
V
67 Total Transmission Charge
W
Transaction Charge
2
Text Restricted Text 4 Required Valid Values: BA - Billing Adjustment F - Firm NF - Non-Firm N/A - Not Applicable UP - Unit Power Sale Note: Designates whether The product was provided on a Firm or Non-Firm basis. It may further define a transaction as a Billing Adjustment or a Unit Power Sale. Restricted Text 4 Required Valid Values: Restricted Text 4 Required Restricted Text 4 Required Valid Values: FP - Full Period N/A - Not Applicable or Undefined OP - Off-Peak P - On Peak Restricted Text 50 Required Numeric 17 Required Numeric 17 Required Restricted Text 10 Required Valid Values: $/KVA $/KW $/KW-DAY $/KW-MO $/KW-WK $/KW-YR $/KWH $/MVAR-YR $/MW $/MW-DAY $/MW-MO $/MW-WK $/MW-YR $/MWH $/RKVA CENTS CENTS/KVR CENTS/KWH FLAT RATE Note: Rate Units should match product names. Dollars & Cents 17 Required Any transmission charge related to the sale of power. Dollars & Cents 17 Required
3 4 5
50 Required Free form text. But if HUB is used in PORCA, a PORSL valid value is required. ADHUB AEP (into) AESO BERC COB Cinergy (into) Comed (into) DOPD Entergy (into) Four Corners GRMA HGMA Mead Mid-Columbia (Mid-C) NEPOOL (Mass Hub) NIHUB NOB NP15 NWMT PJM East Hub PJM West Hub Palo Verde SOCO (into) SP15 TVA (into) WPEC ZP26
Valid Values: H-Hourly LT=Long Term. D-Daily Power Sales transactions M-Monthly with a duration longer N/A-Not Applicable than one year are W-Weekly Long Term. Y-Yearly
Describe the product sold. BOOKED OUT POWER CAPACITY CUSTOMER CHARGE ENERGY ENERGY IMBALANCE (or EI) FUEL CHARGE Note: GRANDFATHERED BUNDLED ST=Short Term. Increment name should Off-Peak/On-Peak are NEGOTIATED RATE TRANSMISSION Power sales transactions reflect the duration of regionally defined. OTHER with a duration of one the underlying Use the definition REACTIVE SUPPLY & VOLTAGE CONTROL (or year commitment of peak/off-peak periods RV) or less are for which the transaction appropriate to the region REAL POWER TRANSMISSION LOSS Short Term, occurs. where the contract REGULATION & FREQUENCY RESPONSE (or product RF) N/A=Not Applicable. is sold. REQUIREMENTS SERVICE SCHEDULE SYSTEM CONTROL & DISPATCH (or SC) SPINNING RESERVE (or SP) SUPPLEMENTAL RESERVE (or SU) TOLLING ENERGY UPLIFT
The quantity of a product Actual Rate Charged. in a transaction. A Number with 2 to 4 A number with 2 to 4 Decimals. decimals. Represented in US Dollars. No commas or dollar signs allowed. Note: List rate applied to each product or time frame for a product.
The Transactions Total is the Quantity times the Price plus any applicable power A Number with up to 2 related transmission c Decimals is permitted. charge. Can be zero. No dollar A Number with 2 signs or commas Decimals is permitted. permissible. Only one total per transaction line. No commas or dollar signs permitted. Total each line of a transaction. Do not repeat a grand total on each line, for a multi-line transaction.
6
2