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
- 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.
- Sum under a description “Other”, all of the aforementioned goods and services amounting to $250,000 or less.
- Total under a description “Total”, the total of all of the aforementioned goods and services.
- 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
$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
|
|
|
|
// 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
2
|
$row[2]
Customer & Market Services
|
$row[3]
XYZ Energy Carolinas, LLC
|
$row[4]
Various
|
$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
|
|
|
|
// 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
21
|
$row[2]
Other Goods and Services
|
$row[3]
ABC Transmission Company
|
$row[4]
Various
|
$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
|