taxonomy().concept(ferc:ScheduleGasAccountNaturalGasAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Gas Account - Natural Gas
|
taxonomy().concept(ferc:ScheduleGasAccountNaturalGasAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- The purpose of this schedule is to account for the quantity of natural gas received and delivered by the respondent.
- Natural gas means either natural gas unmixed or any mixture of natural and manufactured gas.
- Enter in column (c) the year to date Dth as reported in the schedules indicated for the items of receipts and deliveries.
- Enter in column (d) the respective quarter’s Dth as reported in the schedules indicated for the items of receipts and deliveries.
- Indicate in a footnote the quantities of bundled sales and transportation gas and specify the line on which such quantities are listed.
- If the respondent operates two or more systems which are not interconnected, submit separate pages for this purpose.
- Indicate by footnote the quantities of gas not subject to Commission regulation which did not incur FERC regulatory costs by showing (1) the local distribution volumes another jurisdictional pipeline delivered to the local distribution company portion of the reporting pipeline (2) the quantities that the reporting pipeline transported or sold through its local distribution facilities or intrastate facilities and which the reporting pipeline received through gathering facilities or intrastate facilities, but not through any of the interstate portion of the reporting pipeline, and (3) the gathering line quantities that were not destined for interstate market or that were not transported through any interstate portion of the reporting pipeline.
- Indicate in a footnote the specific gas purchase expense account(s) and related to which the aggregate volumes reported on line No. 3 relate.
- Indicate in a footnote (1) the system supply quantities of gas that are stored by the reporting pipeline, during the reporting year and also reported as sales,transportation and compression volumes by the reporting pipeline during the same reporting year, (2) the system supply quantities of gas that are stored by the reporting pipeline during the reporting year which the reporting pipeline intends to sell or transport in a future reporting year, and (3) contract storage quantities.
- Also indicate the volumes of pipeline production field sales that are included in both the company's total sales figure and the company;s total transportation figure. Add additional information as necessary to the footnotes.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleGasAccountNaturalGasAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "520 - Schedule - Gas Account - Natural Gas")
$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]
Item
$row
(a)
|
$data = navigate parent-child descendants from ferc:GasAccountNaturalGasLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasAccountNaturalGas" where $relationship.target-name != ferc:OrderNumber returns list (target-name, preferred-label, result-order);
$systemsList = set([covered @ferc:SystemNameAxis = *].dimensions-typed().values);
$systemsUnique = if $systemsList.length == 0
list("Enter System Name:")
else
sum($systemsList).to-list;
$allData = list(for $system in $systemsUnique
$system-data = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num_ref = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "520 - Schedule - Gas Account - Natural Gas" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$row_num = if ($row_num_ref.part-by-name(ferc-part:Row)).length == 0
""
else
($row_num_ref.part-by-name(ferc-part:Row))[1].part-value;
$page = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F2Page").text;
$ytd = if list([covered @concept = $row[1] @unit @period = $currentDuration @ferc:SystemNameAxis = $system]).length > 0
first(list([covered @concept = $row[1] @unit @period = $currentDuration @ferc:SystemNameAxis = $system]))
else
none
$l3m = if list([covered @concept = $row[1] @period = $current3M @unit @ferc:SystemNameAxis = $system]).length > 0
first(list([covered @concept = $row[1] @period = $current3M @unit @ferc:SystemNameAxis = $system]))
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/F2/GasAccountNaturalGas") returns $item.part-by-name(ferc-part:SequenceRole).part-value).to-list;
$sequenceDimension = (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/F2/GasAccountNaturalGas") returns $item.part-by-name(ferc-part:SequenceDimension).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 = $sequenceDimension[1].to-qname;
$lineItemsList = list(for $l in $sequenceElements
if $l.length > 0
$conceptRoll = $l[1];
if $conceptRoll.is-abstract
skip
else
$l
else
skip
);
$data1 = if count(list({covered where $fact.dimension($axis) != none})) > 0
list({covered {list(
if exists({@ferc:OrderNumber @unit=* @ferc:SystemNameAxis = $system @period = $currentDuration where $fact.dimension($axis) != none})
first(list({@ferc:OrderNumber @unit=* @ferc:SystemNameAxis = $system @period = $currentDuration where $fact.dimension($axis) != none}))
else
0,
/** Description **/
if exists({@concept = $lineItemsList[2][1] @unit @ferc:SystemNameAxis = $system @period = $currentDuration where $fact.dimension($axis) != none})
first(list({@concept = $lineItemsList[2][1] @unit @ferc:SystemNameAxis = $system @period = $currentDuration where $fact.dimension($axis) != none}))
else
none,
/** Amount **/
if exists({@concept = $lineItemsList[3][1] @unit @ferc:SystemNameAxis = $system @period = $currentDuration where $fact.dimension($axis) != none} )
first(list({@concept = $lineItemsList[3][1] @unit @ferc:SystemNameAxis = $system @period = $currentDuration where $fact.dimension($axis) != none}))
else
none,
/** Amount **/
if exists({@concept = $lineItemsList[3][1] @unit @ferc:SystemNameAxis = $system @period = $current3M where $fact.dimension($axis) != none} )
first(list({@concept = $lineItemsList[3][1] @unit @ferc:SystemNameAxis = $system @period = $current3M where $fact.dimension($axis) != none}))
else
none
)}})
else
list(list(0,none,none,none));
$data2 = list(for $x in $data1
if $x == list(0,none,none,none)
skip
else
$x);
$orderedData = $data2.sort;
$data = list(for $z in range($orderedData.length)
$updatedNumber = $row_num.string + "." + $z.string;
list($concept, $updatedNumber, $orderedData[$z][2],none, $orderedData[$z][3],$orderedData[$z][4],$system)
);
for $row in $data
$row
else
skip
);
list(list(
$concept,
$row_num,
$concept.label($row[2].role.uri).text,
if exists($page) $page else "",
$ytd,
$l3m
)) + $breakdown
);
$system-data
);
for $all-systems in $allData
for $systemData in $all-systems
for $rowl in $systemData
$rowl[2]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
if $rowl[1].name == ferc:NameOfSystem "xbrl-no-sides" else "xbrl"
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
if $rowl[1].is-numeric "ixt4:num-dot-decimal" else none
if $rowl[1].name == ferc:NameOfSystem "xbrl-no-sides" else "xbrl"
if $rowl[1].name == ferc:NameOfSystem "description_items" else "numeric_items"
if $rowl[1].name == ferc:NameOfSystem "overflow" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
if $rowl[1].is-numeric "ixt4:num-dot-decimal" else none
if $rowl[1].name == ferc:NameOfSystem "xbrl-no-sides" else "xbrl"
|