taxonomy().concept(ferc:ScheduleOtherGasRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Other Gas Revenues (Account 495)
|
taxonomy().concept(ferc:ScheduleOtherGasRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
Report below transactions of $250,000 or more included in Account 495, Other Gas Revenues. Group all transactions below $250,000 in one amount and provide the number of items.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleOtherGasRevenuesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "308 - Schedule - Other Gas Revenues (Account 495)")
$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]
Description of Transaction
$row
(a)
|
0
first(list([covered @concept = $row[1] @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
$current
)
else
skip
);
for $rowl in $data-labels
]]>
1
|
|
$rowl[3]
if $rowl[1].is-abstract "gray-out" else ""
|
11 |
taxonomy().concept(ferc:OtherGasRevenuesTable).label("http://ferc.gov/form/2020-01-01/roles/label/F2GasRevenues").text
Other revenues (Specify):
|
|
// adding a comment
$data2 = list(for $i in range(28)
list($i,none,none)
);
$data = if count(list({covered @ferc:OtherGasRevenuesAxis=*})) > 0
list( {covered @ferc:OtherGasRevenuesAxis=* {list(
if exists(@ferc:OrderNumber @unit=* @period=$currentDuration)
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransaction @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfTransaction @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherMiscellanousGasRevenues @unit @period=$currentDuration})
first(list({@ferc:OtherMiscellanousGasRevenues @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
12
12
|
$row[2]
Gas Losses Damaged Lines
|
$row[3]
$23,188
|
40 |
taxonomy().concept(ferc:OtherGasRevenues).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
max(list([covered @concept=ferc:OtherGasRevenues @period = $currentDuration]))
$23,188
|