taxonomy().concept(ferc:ScheduleRevenuesFromTransporationOfGasOfOthersThroughGatheringFacilitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Revenues from Transporation of Gas of Others Through Gathering Facilities (Account 489.1)
|
taxonomy().concept(ferc:ScheduleRevenuesFromTransporationOfGasOfOthersThroughGatheringFacilitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report revenues and Dth of gas delivered through gathering facilities by zone of receipt (i.e. state in which gas enters respondent's system).
- Revenues for penalties including penalties for unauthorized overruns must be reported on page 308.
- Other Revenues in columns (f) and (g) include reservation charges received by the pipeline plus usage charges, less revenues reflected in columns (b) through (e).
- Delivered Dth of gas must not be adjusted for discounting.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleRevenuesFromTransporationOfGasOfOthersThroughGatheringFacilitiesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "302 - Schedule - Revenues from Transportation of Gas of Others Through Gathering Facilities (Account 489.1)")
$heading = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value))
$heading_dict = dict(for $row in $heading
list("("+$row[1]+")",list($row[2],if $row[3] == none "" else taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(25)
list($i,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:RateScheduleAndZoneOfReceiptAxis=*})) > 0
list({covered @ferc:RateScheduleAndZoneOfReceiptAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ZoneOfDeliveryOrReceiptRateSchedule @unit @period=$currentDuration})
first(list({@ferc:ZoneOfDeliveryOrReceiptRateSchedule @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration}))
else
none,
if exists({@ferc:RevenuesForGriAndAcaRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration})
first(list({@ferc:RevenuesForGriAndAcaRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration}))
else none,
if exists({@ferc:RevenuesForGriAndAcaRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration})
first(list({@ferc:RevenuesForGriAndAcaRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration}))
else none,
if exists({@ferc:OtherRevenuesRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration})
first(list({@ferc:OtherRevenuesRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration}))
else none,
if exists({@ferc:OtherRevenuesRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration})
first(list({@ferc:OtherRevenuesRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration}))
else none,
if exists({@ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration})
first(list({@ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration}))
else none,
if exists({@ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration})
first(list({@ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration}))
else none,
if exists({@ferc:QuantityOfNaturalGasRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration})
first(list({@ferc:QuantityOfNaturalGasRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$currentDuration}))
else none,
if exists({@ferc:QuantityOfNaturalGasRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration})
first(list({@ferc:QuantityOfNaturalGasRevenuesFromTransportationOfGasOfOthersThroughGatheringFacilities @unit @period=$priorDuration}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
SYSTEM
|
$row[3]
$0
|
$row[4]
$0
|
$row[5]
$0
|
$row[6]
$0
|
$row[7]
$1,081,635
|
$row[8]
$1,740,408
|
$row[9]
$1,081,635
|
$row[10]
$1,740,408
|
$row[11]
17,679,278
|
$row[12]
29,540,122
|