taxonomy().concept(ferc:ScheduleInvestmentsInAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Investments in Affiliated Companies
|
taxonomy().concept(ferc:ScheduleInvestmentsInAffiliatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give particulars (details) of investments included in Account Nos. 20, Investments in Affiliated Companies, and 22, Sinking and Other Funds.
- Refer to the General Instructions on page 201 (Also seen below in "GENERAL INSTRUCTIONS" Section). Be sure to follow the classification of Investments. Give totals for each class and for each subclass, and a grand total for each account.
- Indicate in footnotes the obligation in support of which any security is pledged, mortgaged, or otherwise encumbered, giving names and other important particulars (details) of such obligations.
- Enter in column (c) date of maturity of bonds and other evidences of indebtedness. In case obligations of the same designation mature serially, the date in column (c) may be reported as "Serially 19 to 19." In making entries in this column, abbreviations in common use in standard financial publications may be used where necessary due to limited space.
- If any of the companies included in this schedule are controlled by respondent, give the percent of control in column (d). In case any company listed is controlled other than through actual ownership of securities, give particulars (details) in a footnote. In cases of joint control, give in a footnote names of other parties and particulars (details) of control.
- If any advances are pledged, give particulars (details) in a footnote.
- Give particulars (details) of investments made, disposed of, or written down during the year in columns (f), (g) and (h). If the cost of any investment made during the year differs from the book value reported in column (f), explain the matter in a footnote. "Cost" means the consideration given minus accrued interest or dividends included therein. If the consideration given or received for such investments was other than cash, describe the transaction in a footnote.
- Do not include in this schedule securities issued or assumed by respondent.
GENERAL INSTRUCTIONS CONCERNING SCHEDULES 202 THRU 205
- In Schedules 202 thru 205, give particulars (details) of stocks, bonds, notes, advances, and miscellaneous securities of affiliated and nonaffiliated companies held by respondent at end of year specifically as investments; investments made or disposed of during the year; and dividends and interest credited to income. Exclude securities issued or assumed by respondent.
- Classify the investments in the following order by accounts. Show a total for each group.
- Stocks
- Bonds (Including U.S. Government Bonds)
- Other Secured Obligations
- Unsecured Notes
- Investment Advances
|
|
|
|
|
|
|
|
INVST. DISP. WRITTEN |
DIVIDENDS OR INTEREST |
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleInvestmentsInAffiliatedCompaniesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "202 - Schedule - Investments in Affiliated Companies - Stock")
$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)
|
Stocks |
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesStockAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesStocks @unit @period=$currentInstant})
first(list({@ferc:InvestmentsInAffiliatedCompaniesStocks @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InvestmentInAffiliatedCompaniesStockAdditions @unit @period=$currentDuration})
first(list({@ferc:InvestmentInAffiliatedCompaniesStockAdditions @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownStockBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownStockBookValue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownStockSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownStockSellingPrice @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DividendOrInvestmentInterestRatePercentage @unit @period=$currentDuration})
first(list({@ferc:DividendOrInvestmentInterestRatePercentage @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestAndDividendIncomeStock @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeStock @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
123
|
$row[3]
A
|
$row[4]
Company A
|
$row[5]
75%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|
$total = 1
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group1 + $total
1
|
|
|
taxonomy().concept(ferc:InvestmentsInAffiliatedCompaniesStocks).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total Stock
|
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesStocks @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentInAffiliatedCompaniesStockAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownStockBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownStockSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeStock @period=$currentDuration]))
$4,080,200
|
Bonds |
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesBondAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentInAffiliatedCompaniesBonds @unit @period=$currentInstant})
first(list({@ferc:InvestmentInAffiliatedCompaniesBonds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InvestmentInAffiliatedCompaniesBondsAdditions @unit @period=$currentDuration})
first(list({@ferc:InvestmentInAffiliatedCompaniesBondsAdditions @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownBondsBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownBondsBookValue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownBondsSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownBondsSellingPrice @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DividendRate @unit @period=$currentInstant})
first(list({@ferc:DividendRate @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestAndDividendIncomeBonds @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeBonds @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$total =1
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group1 + $total + 1
5
|
$row[2]
123
|
$row[3]
B
|
$row[4]
Company B
|
$row[5]
65%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|
$total = 2
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group1 + $group2 + $total
8
|
|
|
taxonomy().concept(ferc:InvestmentInAffiliatedCompaniesBonds).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total Bonds
|
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesBonds @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentInAffiliatedCompaniesBondsAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownBondsBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownBondsSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeBonds @period=$currentDuration]))
$4,080,200
|
Other Secured Obligations |
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligations @unit @period=$currentInstant})
first(list({@ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligations @unit @period=$currentInstant}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationsAdditions @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationsAdditions @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownOtherSecuredObligationsBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownOtherSecuredObligationsBookValue @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownOtherSecuredObligationsSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownOtherSecuredObligationsSellingPrice @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentInterestRate @unit @period=$currentDuration})
first(list({@ferc:InvestmentInterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestAndDividendIncomeOtherSecuredObligations @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeOtherSecuredObligations @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$total = 2
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group1 + $group2 + $total + 1
9
|
$row[2]
123
|
$row[3]
C
|
$row[4]
Company C
|
$row[5]
55%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|
$total = 3
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*]))
else
3;
$group1 + $group2 + $group3 + $total
12
|
|
|
taxonomy().concept(ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligations).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total Other Secured Obligations
|
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligations @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationsAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownOtherSecuredObligationsBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownOtherSecuredObligationsSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeOtherSecuredObligations @period=$currentDuration]))
$4,080,200
|
Unsecured Notes |
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotes @unit @period=$currentInstant})
first(list({@ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotes @unit @period=$currentInstant}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAdditions @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAdditions @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownUnsecuredNotesBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownUnsecuredNotesBookValue @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownUnsecuredNotesSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownUnsecuredNotesSellingPrice @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentInterestRate @unit @period=$currentDuration})
first(list({@ferc:InvestmentInterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestAndDividendIncomeUnsecuredNotes @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeUnsecuredNotes @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$total = 3
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*]))
else
3;
$group1 + $group2 + $group3 + $total + 1
13
|
$row[2]
123
|
$row[3]
D
|
$row[4]
Company D
|
$row[5]
55%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|
$total = 3
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*]))
else
3;
$group1 + $group2 + $group3 + $group4 + $total + 1
16
|
|
|
taxonomy().concept(ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotes).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total Unsecured Notes
|
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotes @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownUnsecuredNotesBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownUnsecuredNotesSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeUnsecuredNotes @period=$currentDuration]))
$4,080,200
|
Investment Advances |
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvances @unit @period=$currentInstant})
first(list({@ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvances @unit @period=$currentInstant}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAdditions @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAdditions @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownInvestmentAdvancesBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownInvestmentAdvancesBookValue @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsDisposedOfOrWrittenDownInvestmentAdvancesSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsDisposedOfOrWrittenDownInvestmentAdvancesSellingPrice @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentInterestRate @unit @period=$currentDuration})
first(list({@ferc:InvestmentInterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestAndDividendIncomeInvestmentAdvances @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeInvestmentAdvances @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*]))
else
3;
$group1 + 1 + $group2 + 2 + $group3 + 1 + $group4 + 1
17
|
$row[2]
123
|
$row[3]
E
|
$row[4]
Company E
|
$row[5]
55%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*]))
else
3;
$group5 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAxis=*]))
else
3;
$group1 + 1 + $group2 + 1 + $group3 + 1 + $group4 + 1 + $group5 + 1
20
|
|
|
taxonomy().concept(ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvances).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
Total Investment Advances
|
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvances @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownInvestmentAdvancesBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsDisposedOfOrWrittenDownInvestmentAdvancesSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeInvestmentAdvances @period=$currentDuration]))
$4,080,200
|
Account 20: Investments in Affiliated Companies (Total) |
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompanies @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesDisposedOfOrWrittenDownBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInAffiliatedCompaniesDisposedOfOrWrittenDownSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeInvestmentsInAffiliatedCompanies @period=$currentDuration]))
$4,080,200
|
Sinking and Other Funds |
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesSinkingOtherFundsAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesSinkingOtherFundsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else none,
if exists({@ferc:SinkingAndOtherFunds @unit @period=$currentInstant})
first(list({@ferc:SinkingAndOtherFunds @unit @period=$currentInstant}))
else none,
if exists({@ferc:SinkingAndOtherFundsAdditions @unit @period=$currentDuration})
first(list({@ferc:SinkingAndOtherFundsAdditions @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInSinkingAndOtherFundsDisposedOfOrWrittenDownBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInSinkingAndOtherFundsDisposedOfOrWrittenDownBookValue @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInSinkingAndOtherFundsDisposedOfOrWrittenDownSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInSinkingAndOtherFundsDisposedOfOrWrittenDownSellingPrice @unit @period=$currentDuration}))
else none,
if exists({@ferc:SinkingAndOtherFundsInterestRate @unit @period=$currentDuration})
first(list({@ferc:SinkingAndOtherFundsInterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestAndDividendIncomeInvestmentsInSinkingAndOtherFunds @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeInvestmentsInSinkingAndOtherFunds @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$group1 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesStockAxis=*]))
else
3;
$group2 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesBondAxis=*]))
else
3;
$group3 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesOtherSecuredObligationAxis=*]))
else
3;
$group4 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesUnsecuredNotesAxis=*]))
else
3;
$group5 = if count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAxis=*])) > 0
count(list([covered @ferc:InvestmentClassificationCode @ferc:InvestmentsInAffiliatedCompaniesInvestmentAdvancesAxis=*]))
else
3;
$group1 + 1 + $group2 + 2 + $group3 + 1 + $group4 + 1 + $group5 + 1
21
|
$row[2]
123
|
$row[3]
F
|
$row[4]
Company F
|
$row[5]
55%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|
Account 22: Sinking and Other Funds (Total) |
max(list([covered @concept=ferc:SinkingAndOtherFunds @period=$currentInstant]))
$4,080,200
|
max(list([covered @concept=ferc:SinkingAndOtherFundsAdditions @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInSinkingAndOtherFundsDisposedOfOrWrittenDownBookValue @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:InvestmentsInSinkingAndOtherFundsDisposedOfOrWrittenDownSellingPrice @period=$currentDuration]))
$4,080,200
|
|
max(list([covered @concept=ferc:InterestAndDividendIncomeInvestmentsInSinkingAndOtherFunds @period=$currentDuration]))
$4,080,200
|
$Historicalheader = list(if count(list({covered @ferc:MiscellaneousItemsInIncomeAndRetainedIncomeAxis=*})) > 0
"Historical Data"
else
skip);
for $row in $Historicalheader
$row
|
// adding a comment
$data = if count(list({covered @ferc:InvestmentsInAffiliatedCompaniesAxis=*})) > 0
list({covered @ferc:InvestmentsInAffiliatedCompaniesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
{@ferc:OrderNumber @unit=* @period=$currentDuration}
else
0,
if exists({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration})
first(list({@ferc:AccountNumberInvestmentClassification @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentClassificationCode @unit @period=$currentDuration})
first(list({@ferc:InvestmentClassificationCode @unit @period=$currentDuration}))
else none,
if exists({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration})
first(list({@ferc:NameOfIssuingCompanyAndDescriptionOfSecurityHeld @unit @period=$currentDuration}))
else none,
if exists({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration})
first(list({@ferc:PercentageOfControlInAffiliatedCompany @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompanies @unit @period=$currentInstant})
first(list({@ferc:InvestmentsInAffiliatedCompanies @unit @period=$currentInstant}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesAdditions @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesAdditions @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesDisposedOfOrWrittenDownBookValue @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesDisposedOfOrWrittenDownBookValue @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesDisposedOfOrWrittenDownSellingPrice @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesDisposedOfOrWrittenDownSellingPrice @unit @period=$currentDuration}))
else none,
if exists({@ferc:InvestmentsInAffiliatedCompaniesInterestRate @unit @period=$currentDuration})
first(list({@ferc:InvestmentsInAffiliatedCompaniesInterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestAndDividendIncomeInvestmentsInAffiliatedCompanies @unit @period=$currentDuration})
first(list({@ferc:InterestAndDividendIncomeInvestmentsInAffiliatedCompanies @unit @period=$currentDuration}))
else none
)}})
else skip;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
123
|
$row[3]
A
|
$row[4]
Company A
|
$row[5]
75%
|
$row[6]
$111,111
|
$row[7]
$2,000,000
|
$row[8]
$2,000,000
|
$row[9]
$2,000,000
|
$row[10]
80%
|
$row[11]
$2,000,000
|