taxonomy().concept(ferc:ScheduleOperatingRevenueAccountsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Operating Revenue Accounts
|
taxonomy().concept(ferc:ScheduleOperatingRevenueAccountsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
Report the respondent's pipeline operating revenues year to date, classified in accordance with the Uniform System of Accounts.
|
|
|
Crude Oil |
Products |
Total |
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleOperatingRevenueAccountsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "301 - Schedule - Operating Revenue Accounts (Account 600)")
$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)
|
$data = navigate parent-child descendants from ferc:OperatingRevenueAccountsLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F6/OperatingRevenueAccounts" returns list (target-name, preferred-label);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "301 - Schedule - Operating Revenue Accounts (Account 600)" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$page = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F6PageRange").text;
$current_ps = if exists(first(list([covered @concept = $row[1] @period = $currentDuration])))
first(list([covered @concept = $row[1] @period = $currentDuration]))
else
none
$current_crude = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration]))
else
none
$current_products = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration]))
else
none
$prior_crude = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $priorDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $priorDuration]))
else
none
$prior_products = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $priorDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $priorDuration]))
else
none
$prior_ps = if exists(first(list([covered @concept = $row[1] @period = $priorDuration])))
first(list([covered @concept = $row[1] @period = $priorDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length == 0
""
else
($row_num.part-by-name(ferc-part:Row))[1].part-value,
$current_ps,
$current_crude,
$current_products,
$prior_crude,
$prior_products,
$prior_ps
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[7]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[8]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[9]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
|
|
|
Interstate |
Intrastate |
Total |
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleOperatingRevenueAccountsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "301 - Schedule - Operating Revenue Accounts (Account 600)")
$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]
Account
$row
(a)
|
$data = navigate parent-child descendants from ferc:OperatingRevenueAccountsLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F6/OperatingRevenueAccountsInterstate" returns list (target-name, preferred-label);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "301 - Schedule - Operating Revenue Accounts (Account 600) Interstate" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$page = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F6PageRange").text;
$current = if exists(first(list([covered @concept = $row[1] @period = $currentDuration])))
first(list([covered @concept = $row[1] @period = $currentDuration]))
else
none
$current_interstate = if exists(first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:InterstateTransportationMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:InterstateTransportationMember @period = $currentDuration]))
else
none
$current_intrastate = if exists(first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:IntrastateTransportationMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:IntrastateTransportationMember @period = $currentDuration]))
else
none
$prior_interstate = if exists(first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:InterstateTransportationMember @period = $priorDuration])))
first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:InterstateTransportationMember @period = $priorDuration]))
else
none
$prior_intrastate = if exists(first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:IntrastateTransportationMember @period = $priorDuration])))
first(list([covered @concept = $row[1] @ferc:GeographicAxis=ferc:IntrastateTransportationMember @period = $priorDuration]))
else
none
$prior = if exists(first(list([covered @concept = $row[1] @period = $priorDuration])))
first(list([covered @concept = $row[1] @period = $priorDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length == 0
""
else
($row_num.part-by-name(ferc-part:Row))[1].part-value,
$current,
$current_interstate,
$current_intrastate,
$prior_interstate,
$prior_intrastate,
$prior
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[7]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[8]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[9]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|