taxonomy().concept(ferc:ScheduleTransmissionOfElectricityByOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
TRANSMISSION OF ELECTRICITY BY OTHERS (Account 565)
|
taxonomy().concept(ferc:ScheduleTransmissionOfElectricityByOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report all transmission, i.e. wheeling or electricity provided by other electric utilities, cooperatives, municipalities, other public authorities, qualifying facilities, and others for the quarter.
- In column (a) report each company or public authority that provided transmission service. Provide the full name of the company, abbreviate if necessary, but do not truncate name or use acronyms. Explain in a footnote any ownership interest in or affiliation with the transmission service provider. Use additional columns as necessary to report all companies or public authorities that provided transmission service for the quarter reported.
- In column (b) enter a Statistical Classification code based on the original contractual terms and conditions of the service as follows:
FNS - Firm Network Transmission Service for Self, LFP - Long-Term Firm Point-to-Point Transmission Reservations. OLF - Other Long-Term Firm Transmission Service, SFP - Short-Term Firm Point-to- Point Transmission Reservations, NF - Non-Firm Transmission Service, and OS - Other Transmission Service. See General Instructions for definitions of statistical classifications.
- Report in column (c) and (d) the total megawatt hours received and delivered by the provider of the transmission service.
- Report in column (e), (f) and (g) expenses as shown on bills or vouchers rendered to the respondent. In column (e) report the demand charges and in column (f) energy charges related to the amount of energy transferred. On column (g) report the total of all other charges on bills or vouchers rendered to the respondent, including any out of period adjustments. Explain in a footnote all components of the amount shown in column (g). Report in column (h) the total charge shown on bills rendered to the respondent. If no monetary settlement was made, enter zero in column (h). Provide a footnote explaining the nature of the non-monetary settlement, including the amount and type of energy or service rendered.
- Enter "TOTAL" in column (a) as the last line.
- Footnote entries and provide explanations following all required data.
|
|
|
|
TRANSFER OF ENERGY |
EXPENSES FOR TRANSMISSION OF ELECTRICITY BY OTHERS |
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleTransmissionOfElectricityByOthersAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "332 - Schedule - Transmission of Electricity by 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(16)
list($i,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionOfElectricityByOthersAxis=*})) > 0
list({covered @ferc:TransmissionOfElectricityByOthersAxis=* {list(
if list({@concept=ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@concept=ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@concept=ferc:NameOfCompanyOrPublicAuthorityTransmissionOfElectricityByOthers @unit @period=$currentDuration})
first(list({@concept=ferc:NameOfCompanyOrPublicAuthorityTransmissionOfElectricityByOthers @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:StatisticalClassificationCode @unit @period=$currentDuration})
first(list({@concept=ferc:StatisticalClassificationCode @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:TransmissionOfElectricityByOthersEnergyReceived @unit @period=$currentDuration})
first(list({@concept=ferc:TransmissionOfElectricityByOthersEnergyReceived @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:TransmissionOfElectricityByOthersEnergyDelivered @unit @period=$currentDuration})
first(list({@concept=ferc:TransmissionOfElectricityByOthersEnergyDelivered @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:DemandChargesTransmissionOfElectricityByOthers @unit @period=$currentDuration})
first(list({@concept=ferc:DemandChargesTransmissionOfElectricityByOthers @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:EnergyChargesTransmissionOfElectricityByOthers @unit @period=$currentDuration})
first(list({@concept=ferc:EnergyChargesTransmissionOfElectricityByOthers @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:OtherChargesTransmissionOfElectricityByOthers @unit @period=$currentDuration})
first(list({@concept=ferc:OtherChargesTransmissionOfElectricityByOthers @unit @period=$currentDuration}))
else
none,
if exists({@concept=ferc:ChargesForTransmissionOfElectricityByOthers @unit @period=$currentDuration})
first(list({@concept=ferc:ChargesForTransmissionOfElectricityByOthers @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Company
|
$row[3]
FNS
|
$row[4]
555
|
$row[5]
1,028
|
$row[6]
$514,247
|
$row[7]
$666,666
|
$row[8]
$777,777
|
$row[9]
$888
|
|
taxonomy().concept(ferc:TransmissionOfElectricityByOthersEnergyReceived).label("http://ferc.gov/form/2020-01-01/roles/label/F1Total").text
TOTAL
|
|
max(list([covered @concept=ferc:TransmissionOfElectricityByOthersEnergyReceived @period = $currentDuration]))
1,464
|
max(list([covered @ferc:TransmissionOfElectricityByOthersEnergyDelivered @period = $currentDuration]))
123
|
max(list([covered @ferc:DemandChargesTransmissionOfElectricityByOthers @period = $currentDuration]))
$2,907,175
|
max(list([covered @ferc:EnergyChargesTransmissionOfElectricityByOthers @period = $currentDuration]))
$2,911,545
|
max(list([covered @ferc:OtherChargesTransmissionOfElectricityByOthers @period = $currentDuration]))
$456,789
|
max(list([covered @ferc:ChargesForTransmissionOfElectricityByOthers @period = $currentDuration]))
$1,459,742
|