taxonomy().concept(ferc:ScheduleStatementOfIncomeAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
Quarterly
-
Report in column (c) the current year to date balance. Column (c) equals the total of adding the data in column (g) plus the data in column (i) plus the
data in column (k). Report in column (d) similar data for the previous year. This information is reported in the annual filing only.
- Enter in column (e) the balance for the reporting quarter and in column (f) the balance for the same three month period for the prior year.
- Report in column (g) the quarter to date amounts for electric utility function; in column (i) the quarter to date amounts for gas utility, and in column (k)
the quarter to date amounts for other utility function for the current year quarter.
- Report in column (h) the quarter to date amounts for electric utility function; in column (j) the quarter to date amounts for gas utility, and in column (l)
the quarter to date amounts for other utility function for the prior year quarter.
- If additional columns are needed, place them in a footnote.
Annual or Quarterly if applicable
- Do not report fourth quarter data in columns (e) and (f)
- Report amounts for accounts 412 and 413, Revenues and Expenses from Utility Plant Leased to Others, in another utility columnin a similar manner to
a utility department. Spread the amount(s) over lines 2 thru 26 as appropriate. Include these amounts in columns (c) and (d) totals.
- Report amounts in account 414, Other Utility Operating Income, in the same manner as accounts 412 and 413 above
|
$data = navigate parent-child descendants from ferc:StatementOfIncomeLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/IncomeStatment" returns list (target-name, preferred-label);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "114 - Schedule - Statement of Income" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$page = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F1Page").text;
$current = if list([covered @concept = $row[1] @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @period = $currentDuration]))
else
none
$prior = if list([covered @concept = $row[1] @period = $priorDuration]).length > 0
first(list([covered @concept = $row[1] @period = $priorDuration]))
else
none
$current_three_months = if list([covered @concept = $row[1] @period = $current3M]).length > 0
first(list([covered @concept = $row[1] @period = $current3M]))
else
none
$prior_three_months = if list([covered @concept = $row[1] @period = $prior3M]).length > 0
first(list([covered @concept = $row[1] @period = $prior3M]))
else
none
$current_electric = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration]))
else
none
$prior_electric = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $priorDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $priorDuration]))
else
none
$current_gas = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $currentDuration]))
else
none
$prior_gas = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $priorDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $priorDuration]))
else
none
$current_other = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $currentDuration]))
else
none
$prior_other = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $priorDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $priorDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if exists($page) $page else "",
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"" ,
$current,
$prior,
$current_three_months,
$prior_three_months,
$current_electric,
$prior_electric,
$current_gas,
$prior_gas,
$current_other,
$prior_other
));
for $rowl in $data-labels
$rowl[4]
1
|
|
$rowl[3]
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[7]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[8]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[9]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[10]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[11]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[12]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[13]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[14]
if $rowl[1].is-abstract "gray-out" else ""
|