taxonomy().concept(ferc:ScheduleTransmissionOfElectricityForOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
TRANSMISSION OF ELECTRICITY FOR OTHERS (Account 456.1)
|
taxonomy().concept(ferc:ScheduleTransmissionOfElectricityForOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report all transmission of electricity, i.e., wheeling, provided for other electric utilities, cooperatives, other public authorities, qualifying facilities, non-traditional utility suppliers and ultimate customers for the quarter.
- Use a separate line of data for each distinct type of transmission service involving the entities listed in column (a), (b) and (c).
- Report in column (a) the company or public authority that paid for the transmission service. Report in column (b) the company or public authority that the energy was received from and in column (c) the company or public authority that the energy was delivered to. Provide the full name of each company or public authority. Do not abbreviate or truncate name or use acronyms. Explain in a footnote any ownership interest in or affiliation the respondent has with the entities listed in columns (a), (b) or (c).
- In column (d) enter a Statistical Classification code based on the original contractual terms and conditions of the service as follows: FNO - Firm Network Service for Others, FNS - Firm Network Transmission Service for Self, LFP - "Long-Term Firm Point to Point Transmission Service, OLF - Other Long-Term Firm Transmission Service, SFP - Short-Term Firm Point to Point Transmission Reservation, NF - non-firm transmission service, OS - Other Transmission Service and AD - Out-of-Period Adjustments. Use this code for any accounting adjustments or "true-ups" for service provided in prior reporting periods. Provide an explanation in a footnote for each adjustment. See General Instruction for definitions of codes.
- In column (e), identify the FERC Rate Schedule or Tariff Number, On separate lines, list all FERC rate schedules or contract designations under which service, as identified in column (d), is provided.
- Report receipt and delivery locations for all single contract path, "point to point" transmission service. In column (f), report the designation for the substation, or other appropriate identification for where energy was received as specified in the contract. In column (g) report the designation for the substation, or other appropriate identification for where energy was delivered as specified in the contract.
- Report in column (h) the number of megawatts of billing demand that is specified in the firm transmission service contract. Demand reported in column (h) must be in megawatts. Footnote any demand not stated on a megawatts basis and explain.
- Report in column (i) and (j) the total megawatthours received and delivered.
- In column (k) through (n), report the revenue amounts as shown on bills or vouchers. In column (k), provide revenues from demand charges related to the billing demand reported in column (h). In column (I), provide revenues from energy charges related to the amount of energy transferred. In column (m), provide the total revenues from all other charges on bills or vouchers rendered, including out of period adjustments. Explain in a footnote all components of the amount shown in column (m). Report in column (n) the total charge shown on bills rendered to the entity Listed in column (a). If no monetary settlement was made, enter zero (11011) in column (n). Provide a footnote explaining the nature of the non-monetary settlement, including the amount and type of energy or service rendered.
- The total amounts in columns (i) and (j) must be reported as Transmission Received and Transmission Delivered for annual report purposes only on Page 401, Lines 16 and 17, respectively.
- Footnote entries and provide explanations following all required data.
|
|
|
|
|
|
|
|
|
|
TRANSFER OF ENERGY |
REVENUE FROM TRANSMISSION OF ELECTRICITY FOR OTHERS |
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleTransmissionOfElectricityForOthersAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "328 - Schedule - Transmission of Electricity for Others")
$heading = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value))
$heading_dict = dict(for $row in $heading
list("("+$row[1]+")",list($row[2],
if $row[3] == none
""
else
taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(34)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionOfElectricityForOthersAxis=*})) > 0
$TransmissionOfElectricityForOthers = set({covered @ferc:TransmissionOfElectricityForOthersAxis=*}.dimension(ferc:TransmissionOfElectricityForOthersAxis));
list(for $x in $TransmissionOfElectricityForOthers
list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
0,
if exists({@ferc:PaymentByCompanyOrPublicAuthority @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:PaymentByCompanyOrPublicAuthority @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:TransmissionEnergyReceivedFromCompanyOrPublicAuthorityName @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:TransmissionEnergyReceivedFromCompanyOrPublicAuthorityName @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:TransmissionEnergyDeliveredToCompanyOrPublicAuthorityName @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:TransmissionEnergyDeliveredToCompanyOrPublicAuthorityName @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:StatisticalClassificationCode @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:StatisticalClassificationCode @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:TransmissionPointOfReceipt @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:TransmissionPointOfReceipt @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:TransmissionPointOfDelivery @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:TransmissionPointOfDelivery @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:BillingDemand @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:BillingDemand @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:TransmissionOfElectricityForOthersEnergyReceived @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:TransmissionOfElectricityForOthersEnergyReceived @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:TransmissionOfElectricityForOthersEnergyDelivered @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:TransmissionOfElectricityForOthersEnergyDelivered @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:DemandChargesRevenueTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:DemandChargesRevenueTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:EnergyChargesRevenueTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:EnergyChargesRevenueTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:OtherChargesRevenueTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:OtherChargesRevenueTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none,
if exists({@ferc:RevenuesFromTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x})
first(list({@ferc:RevenuesFromTransmissionOfElectricityForOthers @unit @period=$currentDuration @ferc:TransmissionOfElectricityForOthersAxis = $x}))
else
none
))
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Company
|
$row[3]
DEF Company
|
$row[4]
GHI Company
|
$row[5]
FNS
|
$row[6]
555
|
$row[7]
JKL Substation
|
$row[8]
MNO Substation
|
$row[9]
514,247
|
$row[10]
666,666
|
$row[11]
768,987
|
$row[12]
$888
|
$row[13]
$999
|
$row[14]
$111
|
$row[15]
$3,456
|
35 |
TOTAL
|
|
|
|
|
|
|
max(list([covered
@concept=ferc:BillingDemand @period = $currentDuration]))
1,464
|
max(list([covered
@concept=ferc:TransmissionOfElectricityForOthersEnergyReceived @period = $currentDuration]))
1,464
|
max(list([covered
@concept=ferc:TransmissionOfElectricityForOthersEnergyDelivered @period = $currentDuration]))
1,464
|
max(list([covered
@concept=ferc:DemandChargesRevenueTransmissionOfElectricityForOthers @period = $currentDuration]))
$1,464
|
max(list([covered
@concept=ferc:EnergyChargesRevenueTransmissionOfElectricityForOthers @period = $currentDuration]))
$1,234,567
|
max(list([covered
@concept=ferc:OtherChargesRevenueTransmissionOfElectricityForOthers @period = $currentDuration]))
$2,907,175
|
max(list([covered
@concept=ferc:RevenuesFromTransmissionOfElectricityForOthers @period = $currentDuration]))
$2,911,545
|