taxonomy().concept(ferc:ScheduleLongTermDebtAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FScheduleTitle").text
PART XIV: LONG-TERM DEBT DATA
|
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 == "F1F - 014 - Schedule - Long-Term Debt Data")
$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
/** $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 == "F1F - 014 - Schedule - Long-Term Debt Data" and $item.part-by-name(ferc-part:ValueType).part-value == "Column")
$headings = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value))
$heading_dict = dict(for $row in $headings
list("("+$row[1]+")",$row[2])
);
for $row in $heading_dict.keys.sort **/
$row
(a)
|
// adding a comment
/** comment within XULE expression
**/
$data2 = list(for $i in range(13)
list($i,none,none,none,none,none,none)
);
$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,
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:LongTermDebtInterestRate @unit @period=$currentDuration})
first(list({@ferc:LongTermDebtInterestRate @unit @period=$currentDuration}))
else
none,
if exists({@ferc:InterestExpenseOnLongTermDebtIssued @unit @period=$currentDuration})
first(list({@ferc:InterestExpenseOnLongTermDebtIssued @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,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
|
|
TOTAL |
|
|
max(list([covered @concept=ferc:LongTermDebtOutstanding @period = $currentInstant]))
$2,025,000,000
|
|
max(list([covered @concept=ferc:InterestExpenseOnLongTermDebtIssued @period=$currentDuration]))
$147,642,716
|