taxonomy().concept(ferc:ScheduleMiscellaneousGeneralExpensesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Miscellaneous General Expenses (Account 930.2)
|
taxonomy().concept(ferc:ScheduleMiscellaneousGeneralExpensesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Provide the information requested below on miscellaneous general expenses.
- For Other Expenses, show the (a) purpose, (b) recipient and (c) amount of such items. List separately amounts of $250,000 or more however, amounts less than $250,000 may be grouped if the number of items of so grouped is shown.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleMiscellaneousGeneralExpensesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "335 - Schedule - Miscellaneous General Expenses (Account 930.2)")
$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
$row
(a)
|
$data = navigate parent-child children from ferc:MiscellaneousGeneralExpensesLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MiscellaneousGeneralExpenses" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
if $row[3] > 5
skip
else
$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 == "335 - Schedule - Miscellaneous General Expenses (Account 930.2)" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$current = if list([covered @concept = $row[1] @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @period = $currentDuration]))
else
none;
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length == 0
""
else
($row_num.part-by-name(ferc-part:Row))[1].part-value,
$current
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
// adding a comment
$data2 = list(for $i in range(20)
list($i,none,none)
);
$data = if count(list({covered @ferc:MiscellaneousGeneralExpensesAxis=*})) > 0
list({covered @ferc:MiscellaneousGeneralExpensesAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:OtherMiscellaneousGeneralExpensesDescription @unit @period=$currentDuration})
first(list({@ferc:OtherMiscellaneousGeneralExpensesDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherMiscellaneousGeneralExpenses @unit @period=$currentDuration})
first(list({@ferc:OtherMiscellaneousGeneralExpenses @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
4
4
|
$row[2]
DSM Gas Expense
|
$row[3]
$96,587
|
25 |
taxonomy().concept(ferc:MiscellaneousGeneralExpenses).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
max(list([covered @concept=ferc:MiscellaneousGeneralExpenses @period = $currentDuration]))
$96,587
|