taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Long-Term Debt (Accounts 221, 222, 223, and 224)
|
taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report by Balance Sheet Account the details concerning long-term debt included in Account 221, Bonds, 222, Reacquired Bonds, 223, Advances from Associated Companies, and 224, Other Long-Term Debt.
- For bonds assumed by the respondent, include in column (a) the name of the issuing company as well as a description of the bonds.
- For Advances from Associated Companies, report separately advances on notes and advances on open accounts. Designate demand notes as such. Include in column (a) names of associated companies from which advances were received.
- For receivers' certificates, show in column (a) the name of the court and date of court order under which such certificates were issued.
- In a supplemental statement, give explanatory details for Accounts 223 and 224 of net changes during the year. With respect to long-term advances, show for each company: (a)principal advanced during year (b) interest added to principal amount, and (c) principal repaid during year. Give Commission authorization numbers and dates.
- If the respondent has pledged any of its long-term debt securities, give particulars (details) in a footnote, including name of the pledgee and purpose of the pledge.
- If the respondent has any long-term securities that have been nominally issued and are nominally outstanding at end of year, describe such securities in a footnote.
- If interest expense was incurred during the year on any obligations retired or reacquired before end of year, include such interest expense in column (f). Explain in a footnote any difference between the total of column (f) and the total Account 427, Interest on Long-Term Debt and Account 430, Interest on Debt to Associated Companies.
- Give details concerning any long-term debt authorized by a regulatory commission but not yet issued.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "256 - Schedule - Long-Term Debt - Bonds 221")
$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:OutstandingBondsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2LongTermDebt").text
Bonds (Account 221)
|
|
|
|
|
|
|
|
|
// adding a comment
/** comment within XULE expression
**/
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none, none)
);
$data = if count(list({covered @ferc:BondObligationsAxis=*})) > 0
list({covered @ferc:BondObligationsAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration})
first(list({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssue @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturity @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturity @unit @period=$currentDuration}))
else
none,
if exists({@ferc:Bonds @unit @period=$currentInstant})
first(list({@ferc:Bonds @unit @period=$currentInstant}))
else none,
if exists({@ferc:InterestRate @unit @period=$currentDuration})
first(list({@ferc:InterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestExpenseBonds @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseBonds @unit @period=$currentDuration}))
else none,
none,
if exists({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant})
first(list({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant}))
else none,
if exists({@ferc:RedemptionPrice @unit @period=$currentInstant})
first(list({@ferc:RedemptionPrice @unit @period=$currentInstant}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none, none)
skip
else
$x
);
for $row in $uniqueData.sort
2
2
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
3/22/2010
|
$row[4]
4/15/2020
|
$row[5]
$750,000,000
|
$row[6]
5.625%
|
$row[7]
$42,187,500
|
|
$row[9]
$0
|
$row[10]
$104.64
|
$bonds_heading = 1
$bonds_subtotal = 1
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$bonds_heading + $bonds + $bonds_subtotal
1
|
Subtotal |
|
|
max(list([covered @concept=ferc:Bonds @period = $currentInstant]))
$2,025,000,000
|
|
max(list([covered @concept=ferc:InterestExpenseBonds @period=$currentDuration]))
$147,642,716
|
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentSinkingAndOtherFundsBonds @period=$currentInstant]))
$0
|
|
$heading = 2
$subtotal = 1
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$heading + $bonds + $subtotal
|
taxonomy().concept(ferc:OutstandingReacquiredBondsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2LongTermDebt").text
Reacquired Bonds (Account 222)
|
|
|
|
|
|
|
|
|
// adding a comment
/** comment within XULE expression
**/
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none, none)
);
$data = if count(list({covered @ferc:ReAcquiredBondObligationsAxis=*})) > 0
list({covered @ferc:ReAcquiredBondObligationsAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration})
first(list({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssue @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturity @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturity @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReacquiredBonds @unit @period=$currentInstant})
first(list({@ferc:ReacquiredBonds @unit @period=$currentInstant}))
else none,
if exists({@ferc:InterestRate @unit @period=$currentDuration})
first(list({@ferc:InterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestExpenseReacquiredBonds @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseReacquiredBonds @unit @period=$currentDuration}))
else none,
if exists({@ferc:OutstandingHeldByRespondentReacquiredBonds @unit @period=$currentInstant})
first(list({@ferc:OutstandingHeldByRespondentReacquiredBonds @unit @period=$currentInstant}))
else none,
if exists({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant})
first(list({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant}))
else none,
if exists({@ferc:RedemptionPrice @unit @period=$currentInstant})
first(list({@ferc:RedemptionPrice @unit @period=$currentInstant}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none, none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 2;
$subtotal = 1;
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$heading + $bonds + 1 + $subtotal
1
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
3/22/2010
|
$row[4]
4/15/2020
|
$row[5]
$750,000,000
|
$row[6]
5.625%
|
$row[7]
$42,187,500
|
$row[8]
$0
|
$row[9]
$0
|
$row[10]
$104.64
|
$heading = 2;
$subtotal = 2;
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $subtotal
1
|
Subtotal |
|
|
max(list([covered @concept=ferc:ReacquiredBonds @period = $currentInstant]))
$2,025,000,000
|
|
max(list([covered @concept=ferc:InterestExpenseReacquiredBonds @period=$currentDuration]))
$147,642,716
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentReacquiredBonds @period=$currentInstant]))
$0
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentSinkingAndOtherFundsReacquiredBonds @period=$currentInstant]))
$0
|
|
$heading = 3
$subtotal = 2
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $subtotal
|
taxonomy().concept(ferc:OutstandingDebtAdvancesFromAssociatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2LongTermDebt").text
Advances from Associated Companies (Account 223)
|
|
|
|
|
|
|
|
|
// adding a comment
/** comment within XULE expression
**/
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none, none)
);
$data = if count(list({covered @ferc:AdvancesFromAssociatedCompaniesAxis=*})) > 0
list({covered @ferc:AdvancesFromAssociatedCompaniesAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration})
first(list({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssue @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturity @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturity @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociatedCompanies @unit @period=$currentInstant})
first(list({@ferc:AdvancesFromAssociatedCompanies @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestRate @unit @period=$currentDuration})
first(list({@ferc:InterestRate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestExpenseDebtAdvancesFromAssociatedCompanies @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseDebtAdvancesFromAssociatedCompanies @unit @period=$currentDuration}))
else
none,
none,
if exists({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant})
first(list({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:RedemptionPrice @unit @period=$currentInstant})
first(list({@ferc:RedemptionPrice @unit @period=$currentInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none, none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 3;
$subtotal = 2;
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $subtotal +1
3
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
3/22/2010
|
$row[4]
4/15/2020
|
$row[5]
$750,000,000
|
$row[6]
5.625%
|
$row[7]
$42,187,500
|
|
$row[9]
$0
|
$row[10]
$104.64
|
$heading = 3
$subtotal = 3
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $subtotal
3
|
Subtotal |
|
|
max(list([covered @concept=ferc:AdvancesFromAssociatedCompanies @period = $currentInstant]))
$2,025,000,000
|
|
max(list([covered @concept=ferc:InterestExpenseDebtAdvancesFromAssociatedCompanies @period=$currentDuration]))
$147,642,716
|
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentSinkingAndOtherFundsDebtAdvancesFromAssociatedCompanies @period=$currentInstant]))
$0
|
|
$heading = 4
$subtotal = 3
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $subtotal
|
taxonomy().concept(ferc:OtherLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2LongTermDebt").text
Other Long Term Debt (Account 224)
|
|
|
|
|
|
|
|
|
// adding a comment
/** comment within XULE expression
**/
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none,none,none,none, none)
);
$data = if count(list({covered @ferc:OtherLongTermDebtAxis=*})) > 0
list({covered @ferc:OtherLongTermDebtAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration})
first(list({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssue @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturity @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturity @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherLongTermDebt @unit @period=$currentInstant})
first(list({@ferc:OtherLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestRate @unit @period=$currentDuration})
first(list({@ferc:InterestRate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestExpenseOtherLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseOtherLongTermDebt @unit @period=$currentDuration}))
else
none,
none,
if exists({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant})
first(list({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:RedemptionPrice @unit @period=$currentInstant})
first(list({@ferc:RedemptionPrice @unit @period=$currentInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none, none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 4;
$subtotal = 3;
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $subtotal +1
1
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
3/22/2010
|
$row[4]
4/15/2020
|
$row[5]
$750,000,000
|
$row[6]
5.625%
|
$row[7]
$42,187,500
|
|
$row[9]
$0
|
$row[10]
$104.64
|
$heading = 4;
$subtotal = 4;
$bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$other_debt = if count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $other_debt + $subtotal
3
|
Subtotal |
|
|
max(list([covered @concept=ferc:OtherLongTermDebt @period = $currentInstant]))
$2,025,000,000
|
|
max(list([covered @concept=ferc:InterestExpenseOtherLongTermDebt @period=$currentDuration]))
$147,642,716
|
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentSinkingAndOtherFundsOtherLongTermDebt @period=$currentInstant]))
$0
|
|
$Historicalheader = list(if count(list({covered @ferc:ClassOrSeriesOfObligationAndNameOfStockExchangeAxis=*})) > 0
"Long Term Debt (Historical Data)"
else
skip);
for $row in $Historicalheader
$row
|
// adding a comment
/** comment within XULE expression
**/
$data = if count(list({covered @ferc:ClassOrSeriesOfObligationAndNameOfStockExchangeAxis=*})) > 0
list({covered @ferc:ClassOrSeriesOfObligationAndNameOfStockExchangeAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration})
first(list({@ferc:ClassOfSeriesOfObligationAndNameOfStockExchange @unit @period=$currentDuration}))
else
none,
if exists({@ferc:NominalDateOfIssue @unit @period=$currentDuration})
first(list({@ferc:NominalDateOfIssue @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DateOfMaturity @unit @period=$currentDuration})
first(list({@ferc:DateOfMaturity @unit @period=$currentDuration}))
else
none,
if exists({@ferc:LongTermDebtOutstanding @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtOutstanding @unit @period=$currentInstant}))
else none,
if exists({@ferc:InterestRate @unit @period=$currentDuration})
first(list({@ferc:InterestRate @unit @period=$currentDuration}))
else none,
if exists({@ferc:InterestExpenseOnLongTermDebtIssued @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseOnLongTermDebtIssued @unit @period=$currentDuration}))
else none,
if exists({@ferc:OutstandingHeldByRespondentReacquiredBonds @unit @period=$currentInstant})
first(list({@ferc:OutstandingHeldByRespondentReacquiredBonds @unit @period=$currentInstant}))
else none,
if exists({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentDuration})
first(list({@ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @unit @period=$currentDuration}))
else none,
if exists({@ferc:RedemptionPrice @unit @period=$currentDuration})
first(list({@ferc:RedemptionPrice @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)
skip
else
$x
);
for $row in $uniqueData.sort
1
1
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
3/22/2010
|
$row[4]
4/15/2020
|
$row[5]
$750,000,000
|
$row[6]
5.625%
|
$row[7]
$42,187,500
|
$row[8]
$0
|
$row[9]
$0
|
$row[10]
$104.64
|
40 |
TOTAL |
|
|
max(list([covered @concept=ferc:LongTermDebtOutstanding @period = $currentInstant]))
$2,025,000,000
|
|
max(list([covered @concept=ferc:InterestExpenseOnLongTermDebtIssued @period=$currentDuration]))
$147,642,716
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentReacquiredBonds @period=$currentInstant]))
$0
|
max(list([covered @concept=ferc:OutstandingHeldByRespondentSinkingAndOtherFunds @period=$currentInstant]))
$0
|
|