taxonomy().concept(ferc:ScheduleDistributionOfSalariesAndWagesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Distribution of Salaries and Wages
|
taxonomy().concept(ferc:ScheduleDistributionOfSalariesAndWagesAbstract).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:ScheduleDistributionOfSalariesAndWagesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "354 - Schedule - Distribution of Salaries and Wages")
$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]
Classification
$row
(a)
|
$data = navigate parent-child descendants from ferc:DistributionOfSalariesAndWagesLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/DistributionOfSalariesAndWages" where $relationship.target-name not in list(ferc:DistributionSalariesAndWagesOtherAccountAbstract, ferc:SalariesAndWagesOtherAccounts, ferc:SalariesAndWagesGeneralExpense) returns list (target-name, preferred-label, navigation-depth);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$depth = $row[3];
$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 == "354 - Schedule - Distribution of Salaries and Wages" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label" and "http://ferc.gov/form/2020-01-01/roles/label/" + $item.part-by-name(ferc-part:ColumnName).part-value.string == $row[2].role.uri)).to-list;
$DirectPayrollDistribution = if list([covered @concept = $row[1] @ferc:TypeOfDistributionAxis=ferc:DirectPayrollDistributionMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TypeOfDistributionAxis=ferc:DirectPayrollDistributionMember @period = $currentDuration]))
else
none
$PayrollBilledByAffiliatedCompanies = if list([covered @concept = $row[1] @ferc:TypeOfDistributionAxis=ferc:PayrollBilledByAffiliatedCompaniesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TypeOfDistributionAxis=ferc:PayrollBilledByAffiliatedCompaniesMember @period = $currentDuration]))
else
none
$AllocationOfPayrollChargedForClearingAccounts = if list([covered @concept = $row[1] @ferc:TypeOfDistributionAxis=ferc:AllocationOfPayrollChargedForClearingAccountsMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TypeOfDistributionAxis=ferc:AllocationOfPayrollChargedForClearingAccountsMember @period = $currentDuration]))
else
none
$current = if list([covered @concept = $row[1] @period = $currentDuration]).length > 0
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
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$DirectPayrollDistribution,
$PayrollBilledByAffiliatedCompanies,
$AllocationOfPayrollChargedForClearingAccounts,
$current,
$depth
));
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 ""
|
// adding a comment
$data2 = list(for $i in range(3)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:DistributionSalariesAndWagesOtherAccountAxis=*})) > 0
list({covered @ferc:DistributionSalariesAndWagesOtherAccountAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:DescriptionOfDistributionSalariesAndWagesOtherAccount @unit @period=$currentDuration}).length > 0
first(list({@ferc:DescriptionOfDistributionSalariesAndWagesOtherAccount @unit @period=$currentDuration}))
else none,
if list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:DirectPayrollDistributionMember @unit @period=$currentDuration}).length > 0
first(list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:DirectPayrollDistributionMember @unit @period=$currentDuration}))
else none,
if list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:PayrollBilledByAffiliatedCompaniesMember @unit @period=$currentDuration}).length > 0
first(list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:PayrollBilledByAffiliatedCompaniesMember @unit @period=$currentDuration}))
else none,
if list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:AllocationOfPayrollChargedForClearingAccountsMember @unit @period=$currentDuration}).length > 0
first(list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:AllocationOfPayrollChargedForClearingAccountsMember @unit @period=$currentDuration}))
else none,
if list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=none @unit @period=$currentDuration}).length > 0
first(list({@ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=none @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
75
75
|
$row[2]
Other Accounts (Specify)
|
$row[3]
1,000,000
|
$row[4]
1,000,000
|
$row[5]
1,000,000
|
$row[6]
1,000,000
|
76 |
taxonomy().concept(ferc:SalariesAndWagesOtherAccounts).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL Other Accounts
|
max(list([@concept=ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:DirectPayrollDistributionMember @period=$currentDuration]))
$2,080,500
|
max(list([@concept=ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:PayrollBilledByAffiliatedCompaniesMember @period=$currentDuration]))
$2,080,500
|
max(list([@concept=ferc:SalariesAndWagesOtherAccounts @ferc:TypeOfDistributionAxis=ferc:AllocationOfPayrollChargedForClearingAccountsMember @period=$currentDuration]))
$2,080,500
|
max(list([@concept=ferc:SalariesAndWagesOtherAccounts @period=$currentDuration]))
$2,080,500
|
77 |
taxonomy().concept(ferc:SalariesAndWagesGeneralExpense).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL SALARIES AND WAGES
|
max(list([@concept=ferc:SalariesAndWagesGeneralExpense @ferc:TypeOfDistributionAxis=ferc:DirectPayrollDistributionMember @period=$currentDuration]))
$2,080,500
|
max(list([@concept=ferc:SalariesAndWagesGeneralExpense @ferc:TypeOfDistributionAxis=ferc:PayrollBilledByAffiliatedCompaniesMember @period=$currentDuration]))
$2,080,500
|
max(list([@concept=ferc:SalariesAndWagesGeneralExpense @ferc:TypeOfDistributionAxis=ferc:AllocationOfPayrollChargedForClearingAccountsMember @period=$currentDuration]))
$2,080,500
|
max(list([@concept=ferc:SalariesAndWagesGeneralExpense @period=$currentDuration]))
$2,080,500
|