taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Name of Respondent:
[@ferc:RespondentLegalName @period=$currentDuration] Duke Energy Kentucky, Inc.
taxonomy().concept(ferc:SubmissionType).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").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/F2Header").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/F2Header").text Year/Period of Report:
End of: [@ferc:ReportYear @period=$currentDuration] 2018 / [@ferc:ReportPeriod @period=$currentDuration] Q4
// adding a comment $data2 = list(for $i in range(2,18) list($i,none,none,none,none,none) ); $data = if count(list({covered @ferc:GoodOrServicesProvidedByForAffiliatedCompanyAxis=*})) > 0 list({covered @ferc:GoodOrServicesProvidedByForAffiliatedCompanyAxis=* {list( if exists({@ferc:OrderNumber @unit=* @period=$currentDuration}) first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:DescriptionOfTheGoodOrService @unit @period=$currentDuration}) first(list({@ferc:DescriptionOfTheGoodOrService @unit @period=$currentDuration})) else none, if exists({@ferc:NameOfAssociatedAffiliatedCompany @unit @period=$currentDuration}) first(list({@ferc:NameOfAssociatedAffiliatedCompany @unit @period=$currentDuration})) else none, if exists({@ferc:AccountsChargedOrCreditedTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration}) first(list({@ferc:AccountsChargedOrCreditedTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration})) else none, if exists({@ferc:DueToOrChargedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration}) first(list({@ferc:DueToOrChargedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration})) else none, if exists({@ferc:DueFromOrCreditedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration}) first(list({@ferc:DueFromOrCreditedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration})) else none )}}) else $data2; $uniqueData = list(for $x in $data if $x == list(0,none,none,none,none,none) skip else if $x == list($x[1],$x[2],$x[3],$x[4],$x[5],none) $x else if $x == list($x[1],$x[2],$x[3],$x[4],none,none) $x else skip ); for $row in $uniqueData.sort // adding a comment $data2 = list(for $i in range(21,39) list($i,none,none,none,none,none) ); $data = if count(list({covered @ferc:GoodOrServicesProvidedByForAffiliatedCompanyAxis=*})) > 0 list({covered @ferc:GoodOrServicesProvidedByForAffiliatedCompanyAxis=* {list( if exists({@ferc:OrderNumber @unit=* @period=$currentDuration}) first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:DescriptionOfTheGoodOrService @unit @period=$currentDuration}) first(list({@ferc:DescriptionOfTheGoodOrService @unit @period=$currentDuration})) else none, if exists({@ferc:NameOfAssociatedAffiliatedCompany @unit @period=$currentDuration}) first(list({@ferc:NameOfAssociatedAffiliatedCompany @unit @period=$currentDuration})) else none, if exists({@ferc:AccountsChargedOrCreditedTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration}) first(list({@ferc:AccountsChargedOrCreditedTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration})) else none, if exists({@ferc:DueFromOrCreditedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration}) first(list({@ferc:DueFromOrCreditedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration})) else none, if exists({@ferc:DueToOrChargedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration}) first(list({@ferc:DueToOrChargedByTheTransactionsWithAssociatedAffiliatedCompanies @unit @period=$currentDuration})) else none )}}) else $data2; $uniqueData = list(for $x in $data if $x == list(0,none,none,none,none,none) skip else if $x == list($x[1],$x[2],$x[3],$x[4],$x[5],none) $x else skip ); $orders = set(for $x in $uniqueData $x[1]).sort; for $order in $orders for $row in $uniqueData if $row[1] != $order skip else
taxonomy().concept(ferc:ScheduleTransactionsWithAssociatedAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text Transactions with Associated (Affiliated) Companies - Provided by Affiliated Company
taxonomy().concept(ferc:ScheduleTransactionsWithAssociatedAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
  1. Report below the information called for concerning all goods or services received from or provided to associated (affiliated) companies amounting to more than $250,000.
  2. Sum under a description “Other”, all of the aforementioned goods and services amounting to $250,000 or less.
  3. Total under a description “Total”, the total of all of the aforementioned goods and services.
  4. Where amounts billed to or received from the associated (affiliated) company are based on an allocation process, explain in a footnote the basis of the allocation.
Line No. $headings = filter (taxonomy().concept(ferc:ScheduleTransactionsWithAssociatedAffiliatedCompaniesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "358 - Schedule - Transactions with Associated (Affiliated) Companies - Provided by Affiliated Company") $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
if $heading_dict[$row][2] != "" $heading_dict[$row][2].name.local-name else ""
$heading_dict[$row][1] Nature of Payment
$row (a)
1 taxonomy().concept(ferc:GoodsOrServicesProvidedByAffiliatedCompanyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Transactions").text
Goods or Services Provided by Affiliated Company
2 $row[2] Customer & Market Services $row[3] XYZ Energy Carolinas, LLC $row[5] $3,472,555
19 taxonomy().concept(ferc:DueToOrChargedByTheTransactionsWithAssociatedAffiliatedCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
max(list([covered @concept=ferc:DueToOrChargedByTheTransactionsWithAssociatedAffiliatedCompanies @period = $currentDuration])) $4,600,000
20 taxonomy().concept(ferc:GoodsOrServicesProvidedForAffiliatedCompanyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Transactions").text
Goods or Services Provided for Affiliated Company
21 $row[2] Other Goods and Services $row[3] ABC Transmission Company $row[5] $1,729,061
40 taxonomy().concept(ferc:DueFromOrCreditedByTheTransactionsWithAssociatedAffiliatedCompanies).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
max(list([covered @concept=ferc:DueFromOrCreditedByTheTransactionsWithAssociatedAffiliatedCompanies @period = $currentDuration])) $6,800,000