taxonomy().concept(ferc:ScheduleMonthlyQuantityRevenueDataByRateScheduleAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Monthly Quantity & Revenue Data by Rate Schedule
|
taxonomy().concept(ferc:ScheduleMonthlyQuantityRevenueDataByRateScheduleAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Reference to account numbers in the USofA is provided in parentheses beside applicable data. Quantities must not be adjusted for discounts.
- Total Quantities and Revenues in whole numbers.
- Report revenues and quantities of gas by rate schedule. Where transportation services are bundled with storage services, reflect only transportation Dth. When reporting storage, report Dth of gas withdrawn from storage and revenues by rate schedule.
- Revenues in Column (c) include transition costs from upstream pipelines. Revenue (Other) in Column (e) includes reservation charges received by the pipeline plus usage charges, less revenues reflected in Columns (c) and (d). Include in Column (e), revenue for Accounts 490-495.
- Enter footnotes as appropriate.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleMonthlyQuantityRevenueDataByRateScheduleAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "299 - Schedule - Monthly Quantity & Revenue Data by Rate Schedule")
$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)
|
$dataHead = navigate parent-child descendants from ferc:SalesOfGasForfeitedDiscountsAndMiscellaneousServiceRevenuesAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order);
$months = list($currentQM1, $currentQM2, $currentQM3);
$schedule = list(list(for $month in $months
for $x in $dataHead
if list([covered @concept = $x[1] @period = $month]).length > 0
first(list([covered @concept = $x[1] @period = $month]))
else
none
));
for $rowl in $schedule
1 |
taxonomy().concept(ferc:SalesOfGasForfeitedDiscountsAndMiscellaneousServiceRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total Sales (480-488)
|
$rowl[1]
400,000 dth
|
$rowl[2]
$400,000
|
$rowl[3]
$400,000
|
$rowl[4]
$400,000
|
$rowl[5]
$400,000
|
$rowl[6]
400,000 dth
|
$rowl[7]
$400,000
|
$rowl[8]
$400,000
|
$rowl[9]
$400,000
|
$rowl[10]
$400,000
|
$rowl[11]
400,000 dth
|
$rowl[12]
$400,000
|
$rowl[13]
$400,000
|
$rowl[14]
$400,000
|
$rowl[15]
$400,000
|
2 |
taxonomy().concept(ferc:RevenueFromTransportationOfGasForOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Transportation of Gas for Others (489.2 and 489..3)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(60)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleAxis=*})) > 0
list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfAccountAndRateSchedule @unit@period=$currentDuration})
first(list({@ferc:DescriptionOfAccountAndRateSchedule @unit @period=$currentDuration}))
else none,
if exists({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM1})
first(list({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM1})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM1})
first(list({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM1})
first(list({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM1})
first(list({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM2})
first(list({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM2})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM2})
first(list({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM2})
first(list({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM2})
first(list({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM3})
first(list({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM3})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM3})
first(list({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM3})
first(list({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM3})
first(list({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM3}))
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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
3
1
|
$row[2]
if $row[2].is-fact "true" else "false"
Human Resources Co
|
$row[3]
100
|
$row[4]
$100
|
$row[5]
$100
|
$row[6]
$100
|
$row[7]
$100
|
$row[8]
$100
|
$row[9]
$100
|
$row[10]
$100
|
$row[11]
$100
|
$row[12]
$100
|
$row[13]
$100
|
$row[14]
$100
|
$row[15]
$100
|
$row[16]
$100
|
$row[17]
$100
|
$dataHead = navigate parent-child descendants from ferc:RevenueFromTransportationOfGasForOthersAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order);
$months = list($currentQM1, $currentQM2, $currentQM3);
$schedule = list(list(for $month in $months
for $x in $dataHead
if list([covered @concept = $x[1] @period = $month]).length > 0
first(list([covered @concept = $x[1] @period = $month]))
else
none
));
for $rowl in $schedule
63 |
taxonomy().concept(ferc:OperatingRevenuesTransportationOfGasForOthers).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total Transportation (Other than Gathering)
|
$rowl[1]
400,000 dth
|
$rowl[2]
$400,000
|
$rowl[3]
$400,000
|
$rowl[4]
$400,000
|
$rowl[5]
$400,000
|
$rowl[6]
400,000 dth
|
$rowl[7]
$400,000
|
$rowl[8]
$400,000
|
$rowl[9]
$400,000
|
$rowl[10]
$400,000
|
$rowl[11]
400,000 dth
|
$rowl[12]
$400,000
|
$rowl[13]
$400,000
|
$rowl[14]
$400,000
|
$rowl[15]
$400,000
|
64
64
|
taxonomy().concept(ferc:RevenuesFromStoringGasOfOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Storage (489.4)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(25)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleStorageAxis=*})) > 0
list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleStorageAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfAccountAndRateSchedule @unit@period=$currentDuration})
first(list({@ferc:DescriptionOfAccountAndRateSchedule @unit @period=$currentDuration}))
else none,
if exists({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM1})
first(list({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM1})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM1})
first(list({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM1})
first(list({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM1})
first(list({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM1}))
else none,
if exists({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM2})
first(list({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM2})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM2})
first(list({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM2})
first(list({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM2})
first(list({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM2}))
else none,
if exists({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM3})
first(list({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM3})
first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM3})
first(list({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM3})
first(list({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM3}))
else none,
if exists({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM3})
first(list({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM3}))
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,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
65
65
|
$row[2]
if $row[2].is-fact "true" else "false"
Human Resources Co
|
$row[3]
100
|
$row[4]
$100
|
$row[5]
$100
|
$row[6]
$100
|
$row[7]
$100
|
$row[8]
$100
|
$row[9]
$100
|
$row[10]
$100
|
$row[11]
$100
|
$row[12]
$100
|
$row[13]
100
|
$row[14]
$100
|
$row[15]
$100
|
$row[16]
$100
|
$row[17]
$100
|
$dataHead = navigate parent-child descendants from ferc:RevenuesFromStoringGasOfOthersAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order);
$months = list($currentQM1, $currentQM2, $currentQM3);
$schedule = list(list(for $month in $months
for $x in $dataHead
if list([covered @concept = $x[1] @period = $month]).length > 0
first(list([covered @concept = $x[1] @period = $month]))
else
none
));
for $rowl in $schedule
90 |
taxonomy().concept(ferc:RevenuesFromStoringGasOfOthers).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total Storage
|
$rowl[1]
400,000 dth
|
$rowl[2]
$400,000
|
$rowl[3]
$400,000
|
$rowl[4]
$400,000
|
$rowl[5]
$400,000
|
$rowl[6]
400,000 dth
|
$rowl[7]
$400,000
|
$rowl[8]
$400,000
|
$rowl[9]
$400,000
|
$rowl[10]
$400,000
|
$rowl[11]
400,000 dth
|
$rowl[12]
$400,000
|
$rowl[13]
$400,000
|
$rowl[14]
$400,000
|
$rowl[15]
$400,000
|
91 |
taxonomy().concept(ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Gathering (489.1)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$dataHead = navigate parent-child descendants from ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilitiesAbstract stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order);
$rollforwardSection = list(for $x in $dataHead
$abstractConcept = taxonomy().concept($x[1]);
$is-heading = if ($x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader")
true
else
false;
$abstractLabel = list($is-heading, $abstractConcept.label($x[2].role.uri).text);
$data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list(target, preferred-label, order);
$months = list($currentQM1, $currentQM2, $currentQM3);
$dataRow1 = list(for $month in $months
for $y in $data
if list([covered @concept = $y[1] @period = $month]).length > 0
first(list([covered @concept = $y[1] @period = $month]))
else
none
);
$abstractLabel + $dataRow1
)
for $rowl in $rollforwardSection
92
92
|
$rowl[2]
|
$rowl[3]
400,000 dth
|
$rowl[4]
$400,000
|
$rowl[5]
$400,000
|
$rowl[6]
$400,000
|
$rowl[7]
$400,000
|
$rowl[8]
400,000 dth
|
$rowl[9]
$400,000
|
$rowl[10]
$400,000
|
$rowl[11]
$400,000
|
$rowl[12]
$400,000
|
$rowl[13]
400,000 dth
|
$rowl[14]
$400,000
|
$rowl[15]
$400,000
|
$rowl[16]
$400,000
|
$rowl[17]
$400,000
|
95 |
taxonomy().concept(ferc:AdditionalOperatingRevenueAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Additional Revenues
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$dataHead = navigate parent-child descendants from ferc:AdditionalOperatingRevenueAbstract stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order);
$rollforwardSection = list(for $x in $dataHead
$abstractConcept = taxonomy().concept($x[1]);
$is-heading = if ($x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader")
true
else
false;
$abstractLabel = list($is-heading, $abstractConcept.label($x[2].role.uri).text);
$data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list(target, preferred-label, order);
$months = list($currentQM1, $currentQM2, $currentQM3);
$dataRow1 = list(for $month in $months
for $y in $data
if list([covered @concept = $y[1] @period = $month]).length > 0
first(list([covered @concept = $y[1] @period = $month]))
else
none
);
$abstractLabel + $dataRow1
)
for $rowl in $rollforwardSection
96
96
|
$rowl[2]
|
$rowl[3]
400,000 dth
|
$rowl[4]
$400,000
|
$rowl[5]
$400,000
|
$rowl[6]
$400,000
|
$rowl[7]
$400,000
|
$rowl[8]
400,000 dth
|
$rowl[9]
$400,000
|
$rowl[10]
$400,000
|
$rowl[11]
$400,000
|
$rowl[12]
$400,000
|
$rowl[13]
400,000 dth
|
$rowl[14]
$400,000
|
$rowl[15]
$400,000
|
$rowl[16]
$400,000
|
$rowl[17]
$400,000
|