taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
Long-Term Debt (Accounts 221, 222, 223, and 224)
|
taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report by balance sheet account the particulars (details) concerning long-term debt included in Accounts 221, Bonds, 222, Reacquired Bonds, 223, Advances from Associated Companies, and 224, Other long-Term Debt.
- In column (a), for new issues, give Commission authorization numbers and dates.
- 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 column (b) show the principal amount of bonds or other long-term debt originally issued.
- In column (c) show the expense, premium or discount with respect to the amount of bonds or other long-term debt originally issued.
- For column (c) the total expenses should be listed first for each issuance, then the amount of premium (in parentheses) or discount. Indicate the premium or discount with a notation, such as (P) or (D). The expenses, premium or discount should not be netted.
- Furnish in a footnote particulars (details) regarding the treatment of unamortized debt expense, premium or discount associated with issues redeemed during the year. Also, give in a footnote the date of the Commission’s authorization of treatment other than as specified by the Uniform System of Accounts.
- Identify separate undisposed amounts applicable to issues which were redeemed in prior years.
- Explain any debits and credits other than debited to Account 428, Amortization and Expense, or credited to Account 429, Premium on Debt - Credit.
- In a footnote, 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) principle 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 pledgee and purpose of the pledge.
- If the respondent has any long-term debt securities which 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 (i). Explain in a footnote any difference between the total of column (i) and the total of Account 427, interest on Long-Term Debt and Account 430, Interest on Debt to Associated Companies.
- Give particulars (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/F1LongTermDebt").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,none,none,none)
);
$data = if count(list({covered @ferc:BondObligationsAxis=*})) > 0
list({covered @ferc:BondObligationsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration})
first(list({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RelatedAccountNumber @unit @period=$currentDuration})
first(list({@ferc:RelatedAccountNumber @unit @period=$currentDuration}))
else
none,
if exists({@ferc:BondsPrincipalAmountIssued @unit @period=$currentDuration})
first(list({@ferc:BondsPrincipalAmountIssued @unit @period=$currentDuration}))
else
none,
if exists({@ferc:BondIssuanceExpense @unit @period=$currentDuration})
first(list({@ferc:BondIssuanceExpense @unit @period=$currentDuration}))
else
none,
if exists({@ferc:BondsPremium @unit @period=$currentDuration})
first(list({@ferc:BondsPremium @unit @period=$currentDuration}))
else
none,
if exists({@ferc:BondsDiscount @unit @period=$currentDuration})
first(list({@ferc:BondsDiscount @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:AmortizationPeriodStartDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodStartDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:Bonds @unit @period=$currentInstant})
first(list({@ferc:Bonds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestExpenseBonds @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseBonds @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
2
2
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
Account 221
|
$row[4]
$10,000,000
|
|
$row[5]
$1,000,000
|
$row[6]
$75,000
|
$row[7]
$75,000
|
$row[8]
03/28/2016
|
$row[9]
03/28/2021
|
$row[10]
03/28/2017
|
$row[11]
02/28/2021
|
$row[12]
$104,000,000
|
$row[13]
$10,000
|
$bonds_heading = 1
$bonds_subtotal = 1
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$bonds_heading + $bonds + $bonds_subtotal
1
|
Subtotal |
|
max(list([covered @concept=ferc:BondsPrincipalAmountIssued @period = $currentDuration]))
$22,025,000
|
|
max(list([covered @concept=ferc:BondIssuanceExpense @period = $currentDuration]))
$2,065,800
|
max(list([covered @concept=ferc:BondsPremium @period = $currentDuration]))
$2,065,800
|
max(list([covered @concept=ferc:BondsDiscount @period = $currentDuration]))
$1,092,000
|
|
|
|
|
max(list([covered @concept=ferc:Bonds @period=$currentInstant]))
$147,642,716
|
max(list([covered @concept=ferc:InterestExpenseBonds @period=$currentDuration]))
$10,345
|
$heading = 2
$subtotal = 1
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$heading + $bonds + $subtotal
|
taxonomy().concept(ferc:OutstandingReacquiredBondsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1LongTermDebt").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,none,none,none)
);
$data = if count(list({covered @ferc:ReAcquiredBondObligationsAxis=*})) > 0
list({covered @ferc:ReAcquiredBondObligationsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration})
first(list({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RelatedAccountNumber @unit @period=$currentDuration})
first(list({@ferc:RelatedAccountNumber @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReacquiredBondsPrincipalAmount @unit @period=$currentDuration})
first(list({@ferc:ReacquiredBondsPrincipalAmount @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReacquiredBondsIssuanceExpense @unit @period=$currentDuration})
first(list({@ferc:ReacquiredBondsIssuanceExpense @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReaquiredBondsPremium @unit @period=$currentDuration})
first(list({@ferc:ReaquiredBondsPremium @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReaquiredBondsDiscount @unit @period=$currentDuration})
first(list({@ferc:ReaquiredBondsDiscount @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:AmortizationPeriodStartDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodStartDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ReacquiredBonds @unit @period=$currentInstant})
first(list({@ferc:ReacquiredBonds @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestExpenseReacquiredBonds @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseReacquiredBonds @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 2;
$subtotal = 1;
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$heading + $bonds + 1 + $subtotal
1
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
Account 222
|
$row[4]
$10,000,000
|
|
$row[5]
$1,000,000
|
$row[6]
$75,000
|
$row[7]
$75,000
|
$row[8]
03/28/2016
|
$row[9]
03/28/2021
|
$row[10]
03/28/2017
|
$row[11]
02/28/2021
|
$row[12]
$104,000,000
|
$row[13]
$10,000
|
$heading = 2;
$subtotal = 2;
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $subtotal
1
|
Subtotal |
|
max(list([covered @concept=ferc:ReacquiredBondsPrincipalAmount @period = $currentDuration]))
$22,025,000
|
|
max(list([covered @concept=ferc:ReacquiredBondsIssuanceExpense @period = $currentDuration]))
$2,065,800
|
max(list([covered @concept=ferc:ReaquiredBondsPremium @period = $currentDuration]))
$1,092,000
|
max(list([covered @concept=ferc:ReaquiredBondsDiscount @period = $currentDuration]))
$1,092,000
|
|
|
|
|
max(list([covered @concept=ferc:ReacquiredBonds @period=$currentInstant]))
$147,642,716
|
max(list([covered @concept=ferc:InterestExpenseReacquiredBonds @period=$currentDuration]))
$10,345
|
$heading = 3
$subtotal = 2
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $subtotal
|
taxonomy().concept(ferc:OutstandingDebtAdvancesFromAssociatedCompaniesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1LongTermDebt").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,none,none,none)
);
$data = if count(list({covered @ferc:AdvancesFromAssociatedCompaniesAxis=*})) > 0
list({covered @ferc:AdvancesFromAssociatedCompaniesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration})
first(list({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RelatedAccountNumber @unit @period=$currentDuration})
first(list({@ferc:RelatedAccountNumber @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociatedCompaniesPrincipalAmountIssued @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociatedCompaniesPrincipalAmountIssued @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociatedCompaniesIssuanceExpense @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociatedCompaniesIssuanceExpense @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociatedCompaniesPremium @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociatedCompaniesPremium @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociatedCompaniesDiscount @unit @period=$currentDuration})
first(list({@ferc:AdvancesFromAssociatedCompaniesDiscount @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:AmortizationPeriodStartDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodStartDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AdvancesFromAssociatedCompanies @unit @period=$currentInstant})
first(list({@ferc:AdvancesFromAssociatedCompanies @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestExpenseDebtAdvancesFromAssociatedCompanies @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseDebtAdvancesFromAssociatedCompanies @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 3;
$subtotal = 2;
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $subtotal +1
3
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
Account 222
|
$row[4]
$10,000,000
|
|
$row[5]
$1,000,000
|
$row[6]
$75,000
|
$row[7]
$75,000
|
$row[8]
03/28/2016
|
$row[9]
03/28/2021
|
$row[10]
03/28/2017
|
$row[11]
02/28/2021
|
$row[12]
$104,000,000
|
$row[13]
$10,000
|
$heading = 3
$subtotal = 3
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $subtotal
3
|
Subtotal |
|
max(list([covered @concept=ferc:AdvancesFromAssociatedCompaniesPrincipalAmountIssued @period = $currentDuration]))
$22,025,000
|
|
max(list([covered @concept=ferc:AdvancesFromAssociatedCompaniesIssuanceExpense @period = $currentDuration]))
$2,065,800
|
max(list([covered @concept=ferc:AdvancesFromAssociatedCompaniesPremium @period = $currentDuration]))
$1,092,000
|
max(list([covered @concept=ferc:AdvancesFromAssociatedCompaniesDiscount @period = $currentDuration]))
$1,092,000
|
|
|
|
|
max(list([covered @concept=ferc:AdvancesFromAssociatedCompanies @period=$currentInstant]))
$147,642,716
|
max(list([covered @concept=ferc:InterestExpenseDebtAdvancesFromAssociatedCompanies @period=$currentDuration]))
$10,345
|
$heading = 4
$subtotal = 3
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $subtotal
|
taxonomy().concept(ferc:OtherLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1LongTermDebt").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,none,none,none)
);
$data = if count(list({covered @ferc:OtherLongTermDebtAxis=*})) > 0
list({covered @ferc:OtherLongTermDebtAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration})
first(list({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RelatedAccountNumber @unit @period=$currentDuration})
first(list({@ferc:RelatedAccountNumber @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherLongTermDebtPrincipalAmountIssued @unit @period=$currentDuration})
first(list({@ferc:OtherLongTermDebtPrincipalAmountIssued @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherLongTermDebtIssuanceExpense @unit @period=$currentDuration})
first(list({@ferc:OtherLongTermDebtIssuanceExpense @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherLongTermDebtPremium @unit @period=$currentDuration})
first(list({@ferc:OtherLongTermDebtPremium @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherLongTermDebtDiscount @unit @period=$currentDuration})
first(list({@ferc:OtherLongTermDebtDiscount @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:AmortizationPeriodStartDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodStartDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherLongTermDebt @unit @period=$currentInstant})
first(list({@ferc:OtherLongTermDebt @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestExpenseOtherLongTermDebt @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseOtherLongTermDebt @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,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
$heading = 4;
$subtotal = 3;
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $subtotal +1
1
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
$row[3]
Account 222
|
$row[4]
$10,000,000
|
|
$row[5]
$1,000,000
|
$row[6]
$75,000
|
$row[7]
$75,000
|
$row[8]
03/28/2016
|
$row[9]
03/28/2021
|
$row[10]
03/28/2017
|
$row[11]
02/28/2021
|
$row[12]
$104,000,000
|
$row[13]
$10,000
|
$heading = 4;
$subtotal = 4;
$bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:BondObligationsAxis=*]))
else
3;
$reacquired_bonds = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:ReAcquiredBondObligationsAxis=*]))
else
3;
$advances = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:AdvancesFromAssociatedCompaniesAxis=*]))
else
3;
$other_debt = if count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:OtherLongTermDebtAxis=*])) > 0
count(list([covered @ferc:ClassAndSeriesOfObligationCouponRateDescription @ferc:OtherLongTermDebtAxis=*]))
else
3;
$heading + $bonds + $reacquired_bonds + $advances + $other_debt + $subtotal
3
|
Subtotal |
|
max(list([covered @concept=ferc:OtherLongTermDebtPrincipalAmountIssued @period = $currentDuration]))
$22,025,000
|
|
max(list([covered @concept=ferc:OtherLongTermDebtIssuanceExpense @period = $currentDuration]))
$2,065,800
|
max(list([covered @concept=ferc:OtherLongTermDebtPremium @period = $currentDuration]))
$1,092,000
|
max(list([covered @concept=ferc:OtherLongTermDebtDiscount @period = $currentDuration]))
$1,092,000
|
|
|
|
|
max(list([covered @concept=ferc:OtherLongTermDebt @period=$currentInstant]))
$147,642,716
|
max(list([covered @concept=ferc:InterestExpenseOtherLongTermDebt @period=$currentDuration]))
$10,345
|
$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 list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration})
first(list({@ferc:ClassAndSeriesOfObligationCouponRateDescription @unit @period=$currentDuration}))
else
none,
none, /** WHERE ACCOUNT NUMBER WOULD NORMALLY BE **/
if exists({@ferc:LongTermDebtPrincipalAmountIssued @unit @period=$currentDuration})
first(list({@ferc:LongTermDebtPrincipalAmountIssued @unit @period=$currentDuration}))
else
none,
if exists({@ferc:LongTermDebtIssuanceExpensePremiumOrDiscount @unit @period=$currentDuration})
first(list({@ferc:LongTermDebtIssuanceExpensePremiumOrDiscount @unit @period=$currentDuration}))
else
none,
none, /** WHERE DISCOUNT WOULD BE AS SPLIT OUT* NOW*/
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:AmortizationPeriodStartDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodStartDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration})
first(list({@ferc:AmortizationPeriodEndDate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:LongTermDebtOutstanding @unit @period=$currentInstant})
first(list({@ferc:LongTermDebtOutstanding @unit @period=$currentInstant}))
else
none,
if exists({@ferc:InterestExpenseOnLongTermDebtIssued @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseOnLongTermDebtIssued @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,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
1
|
$row[2]
Fixed Rate Senior Notes - 5.625%
|
|
$row[4]
$32,000
|
$row[5]
$10,000,000
|
|
|
|
$row[7]
03/28/2016
|
$row[8]
03/28/2021
|
$row[9]
03/28/2017
|
$row[10]
02/28/2021
|
$row[11]
$104,000,000
|
$row[12]
$10,000
|
33 |
TOTAL |
|
max(list([covered @concept=ferc:LongTermDebtPrincipalAmountIssued @period=$currentDuration]))
$147,642,716
|
max(list([covered @concept=ferc:LongTermDebtIssuanceExpensePremiumOrDiscount @period=$currentDuration]))
$147,642,716
|
|
|
|
|
|
|
|
max(list([covered @concept=ferc:LongTermDebtOutstanding @period = $currentInstant]))
$2,025,000,000
|
max(list([covered @concept=ferc:InterestExpenseOnLongTermDebtIssued @period=$currentDuration]))
$147,642,716
|