taxonomy().concept(ferc:SchedulePipelineTaxesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Pipeline Taxes (Other than Income Taxes)
|
taxonomy().concept(ferc:SchedulePipelineTaxesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give the particulars (details) on the taxes accrued in carrier properties and charged to Account No. 580, Pipeline Taxes, of the respondent's income Account for the year.
- If during the year an important adjustment was made in Account 580 for taxes applicable to a prior year, state the full particulars (details) in a footnote.
|
A. STATE, LOCAL, AND OTHER TAXES |
Line No. |
$headings = filter (taxonomy().concept(ferc:SchedulePipelineTaxesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "305 - Schedule - Pipeline Taxes (Other than Income Taxes)")
$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)
|
// adding a comment
$data2 = list(for $i in range(58)
list($i,none,none)
);
$data = if count(list({covered @ferc:PipelineTaxesAxis=*})) > 0
list({covered @ferc:PipelineTaxesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfState @unit @period=$currentDuration})
first(list({@ferc:NameOfState @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StateLocalAndOtherPipelineTaxExpense @unit @period=$currentDuration})
first(list({@ferc:StateLocalAndOtherPipelineTaxExpense @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
1
|
$row[2]
Alabama
|
$row[3]
$1,342.864
|
59 |
taxonomy().concept(ferc:StateLocalAndOtherPipelineTaxExpense).label("http://ferc.gov/form/2020-01-01/roles/label/F6Total").text
TOTAL - State, Local and Other Taxes
|
first(list([covered
@concept=ferc:StateLocalAndOtherPipelineTaxExpense @period = $currentDuration]))
$85,531,884
|
B. U.S. GOVERNMENT TAXES |
Line No. |
taxonomy().concept(ferc:FederalPipelineTaxExpenseDescription).label("http://ferc.gov/form/2020-01-01/roles/label/F6PipelineTaxes").text
Kind of Tax
(a)
|
taxonomy().concept(ferc:OtherPipelineTaxExpense).label("http://ferc.gov/form/2020-01-01/roles/label/F6PipelineTaxes").text
Amount
(b)
|
$treeElements = navigate parent-child descendants from ferc:PipelineTaxesLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F6/PipelineTaxesUsGovernmentTaxes" where $relationship.target-name not in list(ferc:StateLocalAndOtherPipelineTaxExpense, ferc:FederalPipelineTaxExpenseAbstract) returns list (target, preferred-label, result-order);
$data-labels = list(for $row in $treeElements
$concept = $row[1];
$conceptPeriod = $concept.period-type;
$total = if $row[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F6Total"
true
else
false
$row_rec = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "305 - Schedule - Pipeline Taxes (Other than Income Taxes) US Government Taxes" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$row_num = if ($row_rec.part-by-name(ferc-part:Row)).length == 0
""
else
($row_rec.part-by-name(ferc-part:Row))[1].part-value;
$current = if list([covered @concept = $row[1] @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @period = $currentDuration]))
else
none
$sequenceReferences = (filter $concept.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/F6/PipelineTaxesUsGovernmentTaxes") returns $item.part-by-name(ferc-part:SequenceRole).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 = first(list(for $a in $sequenceElements
if $a.length > 0
$conceptRoll = $a[1];
if $conceptRoll.substitution.local-name == "dimensionItem"
$conceptRoll
else
skip
else
skip));
$lineItemsList = list(for $l in $sequenceElements
if $l.length > 0
$conceptRoll = $l[1];
if $conceptRoll.is-abstract
skip
else
$l
else
skip
);
$data1 = list({covered {list(
if exists({@ferc:OrderNumber @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
first(list({@ferc:OrderNumber @unit=* @period = $currentDuration where $fact.dimension($axis) != none}))
else
0,
$row_num,
$lineItemsList[3][1],
if exists({@concept = $lineItemsList[2][1] @unit @period = $currentDuration where $fact.dimension($axis) != none})
first(list({@concept = $lineItemsList[2][1] @unit @period = $currentDuration where $fact.dimension($axis) != none}))
else
none,
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
)
}
}
);
$data2 = list(for $x in $data1
if $x == list(0,$x[2],$x[3],none,none)
skip
else
$x);
$orders = set(for $x in $data2 $x[1]).sort;
$orderedData = list(for $order in $orders
for $row in $data2
if $row[1] != $order
skip
else
$row
);
$data = list(for $z in range($orderedData.length)
$updatedNumber = $orderedData[$z][2].string + "." + $z.string;
list($orderedData[$z][1],$updatedNumber,$orderedData[$z][3],$orderedData[$z][4],$orderedData[$z][5])
);
for $row in $data
$row
else
skip
);
list(list(
0,
$row_num,
$concept,
$concept.label($row[2].role.uri).text,
$current
)
) + $breakdown
);
for $rows in $data-labels
for $rowl in $rows
$rowl[2]
|
|
$rowl[5]
if $rowl[3].is-abstract "gray-out" else ""
$300
|