if first(list([covered @ferc:PurchasedPowerMajorNonmajor])) == "Major"
false
else
true
taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F1Header").text
Name of Respondent: [@ferc:RespondentLegalName @period=$currentDuration]
Name of Respondent:
taxonomy().concept(ferc:SubmissionType).label("http://ferc.gov/form/2020-01-01/roles/label/F1Header").text
This report is:
(1)
if missing({covered @concept=ferc:SubmissionType})
"☐ An Original]]>" else if
[@concept=ferc:SubmissionType @period=$currentDuration] == "O"
"☑ An Original]]>"
else
"☐ An Original]]>"
An Original
(2)
if missing([covered @concept=ferc:SubmissionType
@period=$currentDuration])
"☐ A Resubmission]]>" else if
[@concept=ferc:SubmissionType @period=$currentDuration] == "R"
"☑ A Resubmission]]>"
else
"☐ A Resubmission]]>"
A Resubmission
taxonomy().concept(ferc:ReportDate).label("http://ferc.gov/form/2020-01-01/roles/label/F1Header").text
Date of Report: [@ferc:ReportDate @period=$currentDuration]
04/26/2019
taxonomy().concept(ferc:ReportYearPeriod).label("http://ferc.gov/form/2020-01-01/roles/label/F1Header").text
Year/Period of Report:
End of: [@ferc:ReportYear @period=$currentDuration]
2018/[@ferc:ReportPeriod @period=$currentDuration]
Q4
taxonomy().concept(ferc:SchedulePurchasedPowerShortAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FScheduleTitle").text
PART XIX: PURCHASED POWER
Report below the information called for concerning power purchased during the year. Power exchange transactions should be reported net in this schedule whether net is a receipt or a delivery. Indicate such transactions by an asterisk.
Enter the name of the seller in column (a). Abbreviate if necessary but do not truncate the name or use acronyms. Report in column (e) the total cost of power shown on bills rendered by the seller.
In column (b), identify the FERC Rate Schedule or Tariff Number, or, for non-FERC jurisdictional sellers, some appropriate designation for the contract.
Report annual maximum demand in column (c). Demand must be in megawatts. Footnote any demand reported in column (c) which is not stated on a megawatt basis and explain.
Report in column (d) the megawatt-hours shown on bills rendered by the seller.
Report in column (e) the total cost of power shown on bills rendered by the seller.
Footnote entries as required and provide explanations following all required data.
Line No.
/** THIS CODE EXCLUDES ELEMENT NAMES AS THERE ARE NO ELEMENT SPECIFIC COLUMNS **/
$headings = filter (taxonomy().concept(ferc:SchedulePurchasedPowerShortAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "F1F - 019 - Schedule - Purchased Power")
$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]
Title of Account
$row
(a)
// adding a comment
$data2 = list(for $i in range(20)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:PurchasedPowerAxis=*})) > 0
list({covered @ferc:PurchasedPowerAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:NameOfCompanyOrPublicAuthorityProvidingPurchasedPower @unit @period=$currentDuration}).length > 0
first(list({@ferc:NameOfCompanyOrPublicAuthorityProvidingPurchasedPower @unit @period=$currentDuration}))
else
none,
if list({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration}).length > 0
first(list({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration}))
else
none,
if list({@ferc:PurchasedPowerAnnualMaximumDemand @unit @period=$currentDuration}).length > 0
first(list({@ferc:PurchasedPowerAnnualMaximumDemand @unit @period=$currentDuration}))
else
none,
if list({@ferc:MegawattHoursPurchased @unit @period=$currentDuration}).length > 0
first(list({@ferc:MegawattHoursPurchased @unit @period=$currentDuration}))
else
none,
if list({@ferc:SettlementOfPower @unit @period=$currentDuration}).length > 0
first(list({@ferc:SettlementOfPower @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