taxonomy().concept(ferc:ScheduleAppropriatedRetainedIncomeAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Appropriated Retained Income
|
taxonomy().concept(ferc:ScheduleAppropriatedRetainedIncomeAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
Give an analysis of the amount in Account No. 74, Appropriated Retained Income, at the end of the year.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleAppropriatedRetainedIncomeAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "118 - Schedule - Appropriated Retained Income")
$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 Schedule
$row
(a)
|
$members = navigate parent-child descendants from ferc:ClassOfAppropriationDomain role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F6/AppropriatedRetainedIncome" returns list (target-name, preferred-label, order);
$output = list(for $row in $members
$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 == "118 - Schedule - Appropriated Retained Income" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$rowID = if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"";
$prior = if exists([covered @concept = ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis = $row[1] @period = $priorInstant])
first(list([covered @concept = ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis = $row[1] @period = $priorInstant]))
else
none
$current = if exists([covered @concept = ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis = $row[1] @period = $currentInstant])
first(list([covered @concept = ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis = $row[1] @period = $currentInstant]))
else
none
list($rowID, $concept.label($row[2].role.uri).text, $current, $prior)
);
$orders = set(for $x in $output $x[1]).sort;
for $order in $orders
for $rowl in $output
if $rowl[1] != $order
skip
else
$rowl[1]
|
$rowl[2]
|
$rowl[3]
|
$rowl[4]
|
// adding a comment
$data2 = list(for $i in range(7,19)
list($i,none,none,none)
);
$data = if count(list({covered @ferc:ClassOfOtherAppropriationAxis=*})) > 0
list({covered @ferc:ClassOfOtherAppropriationAxis=* {list(
if list({@ferc:OrderNumber @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ClassOfOtherAppropriationOfRetainedIncome @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit@period=$currentDuration})
first(list({@ferc:ClassOfOtherAppropriationOfRetainedIncome @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit @period=$currentInstant})
first(list({@ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit @period=$currentInstant}))
else
none,
if exists({@ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit @period=$priorInstant})
first(list({@ferc:AppropriatedRetainedIncome @ferc:ClassOfAppropriationAxis=ferc:OtherAppropriationsMember @unit @period=$priorInstant}))
else
none
)}})
else $data2;
$uniqueData = list(for $y in $data
if $y == list(0,none,none,none)
skip
else
$y
);
for $row in $uniqueData.sort
7
|
$row[2]
Other
|
$row[3]
$2,387,019
|
$row[4]
$1,231,456
|
20 |
Total |
first(list([covered @concept=ferc:AppropriatedRetainedIncome @period = $currentInstant]))
$85,531,884
|
first(list([covered @concept=ferc:AppropriatedRetainedIncome @period = $priorInstant]))
$28,882,365
|