$data = navigate parent-child descendants from ferc:OperatingExpenseLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F6/OperatingExpenseAccounts" 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 == "302 - Schedule - Operating Expense Accounts (Account 610)" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$current_crudeGathering = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilGatheringMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilGatheringMember @period = $currentDuration]))
else
none
$current_crudeTrunk = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilTrunkMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilTrunkMember @period = $currentDuration]))
else
none
$current_crudeDelivery = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilDeliveryMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:CrudeOilDeliveryMember @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_productsTrunk = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsTrunkMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsTrunkMember @period = $currentDuration]))
else
none
$current_productsDelivery = if exists(first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsDeliveryMember @period = $currentDuration])))
first(list([covered @concept = $row[1] @ferc:ProductsAndServicesAxis=ferc:OilProductsDeliveryMember @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
$current = if exists(first(list([covered @concept = $row[1] @period = $currentDuration])))
first(list([covered @concept = $row[1] @period = $currentDuration]))
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_crudeGathering,
$current_crudeTrunk,
$current_crudeDelivery,
$current_crude,
$current_productsTrunk,
$current_productsDelivery,
$current_products,
$current
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[7]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[8]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[9]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[10]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[11]
if $rowl[1].is-abstract "gray-out" else ""
|