taxonomy().concept(ferc:ScheduleElectricSalesDataForTheYearAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FScheduleTitle").text
PART XVI: ELECTRIC SALES DATA FOR THE YEAR
|
Line No. |
/** THIS CODE EXCLUDES ELEMENT NAMES AS THERE ARE NO ELEMENT SPECIFIC COLUMNS **/
$headings = filter (taxonomy().concept(ferc:ScheduleElectricSalesDataForTheYearAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "F1F - 016 - Schedule - Electric Sales Data For The Year")
$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:ElectricSalesDataLineItems stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F1FRollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1F/ElectricSalesDataForTheYear" where ($relationship.target-name != ferc:OtherOperatingRevenuesAbstract and $relationship.target-name != ferc:ElectricOperatingRevenues ) 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/F1FElectricSalesDataForTheYear" or $x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1FTotal")
true
else
false;
$abstractLabel = list($is-heading, $abstractConcept.label($x[2].role.uri).text);
$data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1F/ElectricSalesDataForTheYear" where $relationship.target-name != ferc:OtherOperatingRevenuesAbstract returns list(target, preferred-label, order);
$dataRow1 = list(for $y in $data
if exists(first(list([covered @concept = $y[1] @period = $currentDuration])))
first(list([covered @concept = $y[1] @period = $currentDuration]))
else
none);
$abstractLabel + $dataRow1
)
for $rowl in $rollforwardSection
1
1
|
$rowl[2]
|
$rowl[3]
if $rowl[1] "gray-out" else ""
|
$rowl[4]
if $rowl[1] "gray-out" else ""
|
$rowl[5]
if $rowl[1] "gray-out" else ""
|
9 |
taxonomy().concept(ferc:OtherOperatingRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FElectricSalesDataForTheYear").text
Other operating revenues (specify)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(10,11)
list($i,none,none)
);
$data = if count(list({covered @ferc:OtherOperatingRevenuesAxis=*})) > 0
list({covered @ferc:OtherOperatingRevenuesAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:OtherOperatingRevenuesDescription @unit @period=$currentDuration})
first(list({@ferc:OtherOperatingRevenuesDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherOperatingRevenues @unit @period=$currentDuration})
first(list({@ferc:OtherOperatingRevenues @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$data3 = list(for $j in $data
if $j == list(0,none,none)
skip
else
$j);
for $row in $data3.sort
10
|
$row[2]
Item 1
|
$row[3]
$1,000,000
|
|
|
12 |
taxonomy().concept(ferc:ElectricOperatingRevenues).label("http://ferc.gov/form/2020-01-01/roles/label/F1FTotal").text
Total
|
max(list([covered @concept=ferc:ElectricOperatingRevenues @period = $currentDuration]))
$4,600,000
|
|
|