taxonomy().concept(ferc:ScheduleElectricOperatingRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
ELECTRIC OPERATING REVENUES (Account 400)
|
taxonomy().concept(ferc:ScheduleElectricOperatingRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- The following instructions generally apply to the annual version of these pages. Do not report quarterly data in columns (c), (e), (f), and (g). Unbilled revenues and MWH related to unbilled revenues need not be reported separately as required in the annual version of these pages.
- Report below operating revenues for each prescribed account, and manufactured gas revenues in total.
- Report number of customers, columns (f) and (g), on the basis of meters, in addition to the number of flat rate accounts; except that where separate meter readings are added for billing purposes, one customer should be counted for each group of meters added. The -average number of customers means the average of twelve figures at the close of each month.
- If increases or decreases from previous period (columns (c),(e), and (g)), are not derived from previously reported figures, explain any inconsistencies in a footnote.
- Disclose amounts of $250,000 or greater in a footnote for accounts 451, 456, and 457.2.
- Commercial and industrial Sales, Account 442, may be classified according to the basis of classification (Small or Commercial, and Large or Industrial) regularly used by the respondent if such basis of classification is not generally greater than 1000 Kw of demand. (See Account 442 of the Uniform System of Accounts. Explain basis of classification in a footnote.)
- See pages 108-109, Important Changes During Period, for important new territory added and important rate increase or decreases.
- For Lines 2,4,5,and 6, see Page 304 for amounts relating to unbilled revenue by accounts.
- Include unmetered sales. Provide details of such Sales in a footnote.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleElectricOperatingRevenuesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "300 - Schedule - Electric Operating Revenues")
$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)
|
$dataHead = navigate parent-child descendants from ferc:ElectricOperatingRevenuesLineItems stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F1RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleElectricOperatingRevenues" returns list (target-name, preferred-label, order);
$rollforwardSection = list(for $x in $dataHead
$abstractConcept = taxonomy().concept($x[1]);
$is-heading = if ($x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1ElectricOperatingRevenues" or $x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1Total")
true
else
false;
$row_num = (filter $abstractConcept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "300 - Schedule - Electric Operating Revenues" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$row_number = if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
25
$data = if ($abstractConcept.is-abstract and $x[1] != ferc:OtherOperatingRevenuesAbstract)
navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleElectricOperatingRevenues" returns list(target, preferred-label, order)
else
list(list($abstractConcept,$x[2],$x[3]));
$abstractLabel = list($is-heading, $abstractConcept.is-abstract, $x[1], $abstractConcept.label($x[2].role.uri).text, $row_number);
$dataLength = $data.length;
$difference = 3 - $dataLength;
$additionalColumns = $difference * 2;
$fill = list(for $x in range($additionalColumns)
none
);
$dataRow1 = list(for $z in $data
list(
if exists([covered @concept = $z[1].name @period = $currentDuration])
first(list([covered @concept = $z[1].name @period = $currentDuration]))
else
none,
if exists([covered @concept = $z[1].name @period = $priorDuration])
first(list([covered @concept = $z[1].name @period = $priorDuration]))
else
none
)
);
$sequenceReferences = (filter $abstractConcept.references("http://ferc.gov/form/2020-01-01/roles/reference/elementSequence") where ($item.part-by-name(ferc-part:ScheduleRole).part-value == "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleElectricOperatingRevenues") returns $item.part-by-name(ferc-part:SequenceRole).part-value).to-list;
$sequenceDimension = (filter $abstractConcept.references("http://ferc.gov/form/2020-01-01/roles/reference/elementSequence") where ($item.part-by-name(ferc-part:ScheduleRole).part-value == "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleElectricOperatingRevenues") returns $item.part-by-name(ferc-part:SequenceDimension).part-value).to-list;
$breakdown = list(
if $sequenceReferences.to-list.length > 0
$sequenceRole = $sequenceReferences[1];
$sequenceElements = navigate parent-child descendants role $sequenceRole returns list(target, preferred-label, result-order);
$axis = $sequenceDimension[1].to-qname;
$lineItemsList = list(for $l in $sequenceElements
if $l.length > 0
$conceptRoll = $l[1];
if $conceptRoll.is-abstract
skip
else
$l
else
skip
);
$data1 = if count(list({covered where $fact.dimension($axis) != none})) > 0
list({covered {list(
if exists({@ferc:OrderNumber @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@ferc:OrderNumber @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
0,
/** Description **/
if exists({@concept = $lineItemsList[2][1] @unit @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[2][1] @unit @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Amount **/
if exists({@concept = $lineItemsList[3][1] @unit @period = $currentDuration where $fact.dimension($axis) != none} )
first(list({@concept = $lineItemsList[3][1] @unit @period = $currentDuration where $fact.dimension($axis) != none}))
else
none,
/** Amount **/
if exists({@concept = $lineItemsList[3][1] @unit @period = $priorDuration where $fact.dimension($axis) != none} )
first(list({@concept = $lineItemsList[3][1] @unit @period = $priorDuration where $fact.dimension($axis) != none}))
else
none
)}})
else
list(list(0,none,none,none));
$data2 = list(for $x in $data1
if $x == list(0,none,none,none)
skip
else
$x);
$orderedData = $data2.sort;
$data-sequence = list(for $z in range($orderedData.length)
$updatedNumber = "25" + "." + $z.string;
list(
$is-heading,
$abstractConcept.is-abstract,
$x[1],
$orderedData[$z][2],
$updatedNumber.number,
$orderedData[$z][3],
$orderedData[$z][4]
)
);
for $row in $data-sequence
$row + $fill
else
skip
);
$dataRow4 = if $difference > 0
sum($dataRow1) + $fill
else
sum($dataRow1);
list($abstractLabel + $dataRow4) + $breakdown
);
for $rows in $rollforwardSection
for $rowl in $rows
if $rowl.length == 0
skip
else
$rowl[5]
|
|
$rowl[6]
if $rowl[1] and $rowl[2] "gray-out" else ""
|
$rowl[7]
if $rowl[1] and $rowl[2] "gray-out" else ""
|
$rowl[8]
if $rowl[1] "gray-out" else ""
|
$rowl[9]
if $rowl[1] "gray-out" else ""
|
$rowl[10]
if $rowl[1] "gray-out" else ""
|
$rowl[11]
if $rowl[1] "gray-out" else ""
|
Line12, column (b) includes $
first(list([@ferc:RevenueFromSalesOfElectricityUnbilled @period=$currentDuration]))
789
of unbilled revenues.
|
Line12, column (d) includes $
first(list([@ferc:MegawattHoursOfElectricitySoldUnbilled @period=$currentDuration]))
200
MWH relating to unbilled revenues
|