taxonomy().concept(ferc:ScheduleDiscountedRateServicesAndNegotiatedRateServicesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Discounted Rate Services and Negotiated Rate Services
|
taxonomy().concept(ferc:ScheduleDiscountedRateServicesAndNegotiatedRateServicesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- In column b, report the revenues from discounted rate services.
- In column c, report the volumes of discounted rate services.
- In column d, report the revenues from negotiated rate services.
- In column e, report the volumes of negotiated rate services.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleDiscountedRateServicesAndNegotiatedRateServicesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "313 - Schedule - Discounted Rate Services and Negotiated Rate Services")
$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(39)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:DiscountedRateServicesAndNegotiatedRateServicesAxis=*})) > 0
list({covered @ferc:DiscountedRateServicesAndNegotiatedRateServicesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:AccountDescription @unit @period=$currentDuration}).length > 0
first(list({@ferc:AccountDescription @unit @period=$currentDuration}))
else
none,
if list({@ferc:RevenueFromDiscountedRateServices @unit @period=$currentDuration}).length > 0
first(list({@ferc:RevenueFromDiscountedRateServices @unit @period=$currentDuration}))
else
none,
if list({@ferc:VolumesOfDiscountedRateServices @unit @period=$currentDuration}).length > 0
first(list({@ferc:VolumesOfDiscountedRateServices @unit @period=$currentDuration}))
else
none,
if list({@ferc:RevenuesFromNegotiatedRateServices @unit @period=$currentDuration}).length > 0
first(list({@ferc:RevenuesFromNegotiatedRateServices @unit @period=$currentDuration}))
else
none,
if list({@ferc:VolumesOfNegotiatedRateServices @unit @period=$currentDuration}).length > 0
first(list({@ferc:VolumesOfNegotiatedRateServices @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
Account 489.1, Revenues from transportation of gas of others through gathering facilities.
|
$row[3]
$36,882,942
|
$row[4]
119,417,042
|
$row[5]
$823,468,108
|
$row[6]
1,473,648,227
|
40 |
taxonomy().concept(ferc:AccountDescription).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
max(list([covered @concept=ferc:RevenueFromDiscountedRateServices @period = $currentDuration]))
$36,882,942
|
max(list([covered @concept=ferc:VolumesOfDiscountedRateServices @period = $currentDuration]))
119,417,042
|
max(list([covered @concept=ferc:RevenuesFromNegotiatedRateServices @period = $currentDuration]))
$823,468,108
|
max(list([covered @concept=ferc:VolumesOfNegotiatedRateServices @period = $currentDuration]))
1,473,648,227
|