taxonomy().concept(ferc:ScheduleTransmissionOfElectricityByIsoOrRtoAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
TRANSMISSION OF ELECTRICITY BY ISO/RTOs
|
taxonomy().concept(ferc:ScheduleTransmissionOfElectricityByIsoOrRtoAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report in Column (a) the Transmission Owner receiving revenue for the transmission of electricity by the ISO/RTO.
- Use a separate line of data for each distinct type of transmission service involving the entities listed in Column (a).
- In Column (b) 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 (c) 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 (b) was provided.
- In column (d) report the revenue amounts as shown on bills or vouchers.
- Report in column (e) the total revenues distributed to the entity listed in column (a).
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleTransmissionOfElectricityByIsoOrRtoAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "331 - Schedule - Transmission of Electricity by ISO-RTOs")
$headings = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value))
$heading_dict = dict(for $row in $headings
list("("+$row[1]+")",$row[2])
);
for $row in $heading_dict.keys.sort
$heading_dict[$row]
Description
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(49)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionOfElectricityByIsosOrRtosAxis=*})) > 0
list({covered @ferc:TransmissionOfElectricityByIsosOrRtosAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:TransmissionPaymentByCompanyOrPublicAuthority @unit @period=$currentDuration})
first(list({@ferc:TransmissionPaymentByCompanyOrPublicAuthority @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StatisticalClassificationCode @unit @period=$currentDuration})
first(list({@ferc:StatisticalClassificationCode @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration})
first(list({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RevenuesByRateOrTariff @unit @period=$currentDuration})
first(list({@ferc:RevenuesByRateOrTariff @unit @period=$currentDuration}))
else
none,
if exists({@ferc:TransmissionOfElectricityByIsosOrRtosRevenue @unit @period=$currentDuration})
first(list({@ferc:TransmissionOfElectricityByIsosOrRtosRevenue @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Company
|
$row[3]
FNS
|
$row[4]
1,914,831
|
$row[5]
$1,028,111
|
$row[6]
$5,014,247
|
40 |
taxonomy().concept(ferc:TransmissionOfElectricityByOthersEnergyReceived).label("http://ferc.gov/form/2020-01-01/roles/label/F1Total").text
TOTAL
|
|
|
max(list([covered @concept=ferc:RevenuesByRateOrTariff @period = $currentDuration]))
$11,464,999
|
max(list([covered @concept=ferc:TransmissionOfElectricityByIsosOrRtosRevenue @period = $currentDuration]))
$987,456,031
|