taxonomy().concept(ferc:ScheduleCapitalStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Capital Stock (Accounts 201 and 204)
|
taxonomy().concept(ferc:ScheduleCapitalStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report below the details called for concerning common and preferred stock at end of year, distinguishing separate series of any general class. Show separate totals for common and preferred stock.
- Entries in column (b) should represent the number of shares authorized by the articles of incorporation as amended to end of year.
- Give details concerning shares of any class and series of stock authorized to be issued by a regulatory commission which have not yet been issued.
- The identification of each class of preferred stock should show the dividend rate and whether the dividends are cumulative or noncumulative.
- State in a footnote if any capital stock that has been nominally issued is nominally outstanding at end of year.
- Give particulars (details) in column (a) of any nominally issued capital stock, reacquired stock, or stock in sinking and other funds which is pledged, stating name of pledgee and purpose of pledge.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleCapitalStockAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "250 - Schedule - Capital Stock - Common Stock (Account 201)")
$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
$heading_dict[$row]
Title of Account
$row
(a)
|
1 |
taxonomy().concept(ferc:CommonStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Common Stock (Account 201)
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(41, 43-length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))))
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if list({covered @ferc:CommonStockAxis=*}).length > 0
list({covered @ferc:CommonStockAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:CapitalStockDescription @unit @period=$currentDuration}).length > 0
first(list({@ferc:CapitalStockDescription @unit @period=$currentDuration}))
else
none,
if list({@ferc:CommonStockSharesAuthorized @unit @period=$currentInstant}).length > 0
first(list({@ferc:CommonStockSharesAuthorized @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockParOrStatedValuePerShare @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockParOrStatedValuePerShare @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockCallPrice @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockCallPrice @unit @period=$currentInstant}))
else
none,
if list({@ferc:CommonStockSharesOutstanding @unit @period=$currentInstant}).length > 0
first(list({@ferc:CommonStockSharesOutstanding @unit @period=$currentInstant}))
else
none,
if list({@ferc:CommonStockIssued @unit @period=$currentInstant}).length > 0
first(list({@ferc:CommonStockIssued @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesHeldAsReacquiredStock @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesHeldAsReacquiredStock @unit @period=$currentInstant}))
else
none,
if list({@ferc:ReacquiredCapitalStock @unit @period=$currentInstant}).length > 0
first(list({@ferc:ReacquiredCapitalStock @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesHeldInSinkingAndOtherFunds @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesHeldInSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockValueHeldInSinkingAndOtherFunds @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockValueHeldInSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none
)}}) + $data2
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
2
1
|
$row[2]
300
|
$row[3]
400 shares
|
$row[4]
$4,000
|
$row[5]
$4,000
|
$row[6]
4,000 Shares
|
$row[7]
$4,000,000
|
$row[8]
4,000 Shares
|
$row[9]
$4,000,000
|
$row[10]
4,000 shares
|
$row[11]
$4,000,000
|
$heading = 1
$total = 1
$group1 = if length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))) > 0
max(list(length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))),3))
else
3;
$heading + $group1 + $total
1
|
taxonomy().concept(ferc:CommonStockIssued).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Sub Total
|
max(list([covered @concept=ferc:CommonStockSharesAuthorized @period=$currentInstant]))
4,080 shares
|
|
|
max(list([covered @concept=ferc:CommonStockSharesOutstanding @period=$currentInstant]))
4,080 shares
|
max(list([covered @concept=ferc:CommonStockIssued @period=$currentInstant]))
$4,080,200
|
|
|
|
|
$heading = 2
$total = 1
$group1 = if length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))) > 0
max(list(length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))),3))
else
3;
$heading + $group1 + $total
1
|
taxonomy().concept(ferc:PreferredStockAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2CapitalStock").text
Preferred Stock (Account 204)
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(41,43-length(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))))
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if list({covered @ferc:PreferredStockAxis=*}).length > 0
list({covered @ferc:PreferredStockAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:CapitalStockDescription @unit @period=$currentDuration}).length > 0
first(list({@ferc:CapitalStockDescription @unit @period=$currentDuration}))
else
none,
if list({@ferc:PreferredStockSharesAuthorized @unit @period=$currentInstant}).length > 0
first(list({@ferc:PreferredStockSharesAuthorized @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockParOrStatedValuePerShare @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockParOrStatedValuePerShare @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockCallPrice @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockCallPrice @unit @period=$currentInstant}))
else
none,
if list({@ferc:PreferredStockSharesOutstanding @unit @period=$currentInstant}).length > 0
first(list({@ferc:PreferredStockSharesOutstanding @unit @period=$currentInstant}))
else
none,
if list({@ferc:PreferredStockIssued @unit @period=$currentInstant}).length > 0
first(list({@ferc:PreferredStockIssued @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesHeldAsReacquiredStock @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesHeldAsReacquiredStock @unit @period=$currentInstant}))
else
none,
if list({@ferc:ReacquiredCapitalStock @unit @period=$currentInstant}).length > 0
first(list({@ferc:ReacquiredCapitalStock @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesHeldInSinkingAndOtherFunds @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesHeldInSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockValueHeldInSinkingAndOtherFunds @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockValueHeldInSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none
)}}) + $data2
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
);
$orders = set(for $x in $uniqueData $x[1]).sort;
for $order in $orders
for $row in $uniqueData
if $row[1] != $order
skip
else
$heading = 2
$total = 1
$group1 = if length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))) > 0
max(list(count(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))),3))
else
3;
$heading + $group1 + $total + 1
1
|
$row[2]
Capital Stock
|
$row[3]
400 shares
|
$row[4]
$4,000
|
$row[5]
$4,000
|
$row[6]
$4,000,000
|
$row[7]
$4,000,000
|
$row[8]
$4,000,000
|
$row[9]
$4,000,000
|
$row[10]
$4,000,000
|
$row[11]
$4,000,000
|
$heading = 2
$total = 2
$group1 = if length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))) > 0
max(list(count(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))),3))
else
3;
$group2 = if length(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))) > 0
max(list(count(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))),3))
else
3;
$heading + $group1 + $group2 + $total
1
|
taxonomy().concept(ferc:PreferredStockIssued).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Sub Total
|
max(list([covered @concept=ferc:PreferredStockSharesAuthorized @period=$currentInstant]))
4,080,200,000 shares
|
|
|
max(list([covered @concept=ferc:PreferredStockSharesOutstanding @period=$currentInstant]))
$4,080,200,000 shares
|
max(list([covered @concept=ferc:PreferredStockIssued @period=$currentInstant]))
$4,080,200
|
|
|
|
|
$Historicalheader = list(if count(list({covered @ferc:CapitalStockByTypesAxis=*})) > 0
"Historical Data"
else
skip);
for $row in $Historicalheader
$row
|
// adding a comment
$data = if list({covered @ferc:CapitalStockByTypesAxis=*}).length > 0
list({covered @ferc:CapitalStockByTypesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:CapitalStockDescription @unit @period=$currentDuration}).length > 0
first(list({@ferc:CapitalStockDescription @unit @period=$currentDuration}))
else
none,
if list({@ferc:CapitalStockSharesAuthorized @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesAuthorized @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockParOrStatedValuePerShare @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockParOrStatedValuePerShare @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockCallPrice @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockCallPrice @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesOutstanding @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesOutstanding @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockValueOutstanding @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockValueOutstanding @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesHeldAsReacquiredStock @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesHeldAsReacquiredStock @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockValueHeldAsReacquiredStock @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockValueHeldAsReacquiredStock @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockSharesHeldInSinkingAndOtherFunds @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockSharesHeldInSinkingAndOtherFunds @unit @period=$currentInstant}))
else
none,
if list({@ferc:CapitalStockValueHeldInSinkingAndOtherFunds @unit @period=$currentInstant}).length > 0
first(list({@ferc:CapitalStockValueHeldInSinkingAndOtherFunds @unit @period=$currentInstant}))
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
);
$orders = set(for $x in $uniqueData $x[1]).sort;
for $order in $orders
for $row in $uniqueData
if $row[1] != $order
skip
else
$heading = 2
$total = 2
$group1 = if length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))) > 0
max(list(count(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))),3))
else
3;
$group2 = if length(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))) > 0
max(list(count(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))),3))
else
3;
$heading + $group1 + $group2 + $total + 1
1
|
$row[2]
Capital Stock
|
$row[3]
Capital Stock
|
$row[4]
400 shares
|
$row[5]
$400
|
$row[6]
4,000 shares
|
$row[7]
$4,000,000
|
$row[8]
4,000 shares
|
$row[9]
$4,000,000
|
$row[10]
4,000 shares
|
$row[11]
$4,000,000
|
$heading = 2
$total = 2
$group1 = if length(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))) > 0
max(list(count(set({covered @ferc:CommonStockAxis=*}.dimension(ferc:CommonStockAxis))),3))
else
3;
$group2 = if length(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))) > 0
max(list(count(set({covered @ferc:PreferredStockAxis=*}.dimension(ferc:PreferredStockAxis))),3))
else
3;
$group3 = if length(set({covered @ferc:CapitalStockByTypesAxis=*}.dimension(ferc:CapitalStockByTypesAxis))) > 0
count(set({covered @ferc:CapitalStockByTypesAxis=*}.dimension(ferc:CapitalStockByTypesAxis)))
else
0;
$heading + $group1 + $group2 + $group3 +$total + 1
1
|
taxonomy().concept(ferc:CapitalStockValueOutstanding).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Grand Total
|
max(list([covered @concept=ferc:CapitalStockSharesAuthorized @period=$currentInstant]))
4,080,200 shares
|
|
|
max(list([covered @concept=ferc:CapitalStockSharesOutstanding @period=$currentInstant]))
4,080,200 shares
|
max(list([covered @concept=ferc:CapitalStockValueOutstanding @period=$currentInstant]))
$4,080,200
|
|
|
|
|