taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Name of Respondent:

[@ferc:RespondentLegalName @period=$currentDuration] Duke Energy Kentucky, Inc.
taxonomy().concept(ferc:SubmissionType).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text This report is:
(1) if missing({covered @concept=ferc:SubmissionType}) ☐ An Original']]> else if [@concept=ferc:SubmissionType @period=$currentDuration] == "O" ☑ An Original']]> else ☐ An Original']]> An Original
(2) if missing([covered @concept=ferc:SubmissionType @period=$currentDuration]) ☐ A Resubmission']]> else if [@concept=ferc:SubmissionType @period=$currentDuration] == "R" ☑ A Resubmission']]> else ☐ A Resubmission']]> A Resubmission
taxonomy().concept(ferc:ReportDate).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Date of Report:
[@ferc:ReportDate @period=$currentDuration] 04/26/2019
taxonomy().concept(ferc:ReportYearPeriod).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Year/Period of Report:
End of: [@ferc:ReportYear @period=$currentDuration] 2018 / [@ferc:ReportPeriod @period=$currentDuration] Q4
$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 // 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
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
  1. Report revenues and Dth of gas delivered through gathering facilities by zone of receipt (i.e. state in which gas enters respondent's system).
  2. Revenues for penalties including penalties for unauthorized overruns must be reported on page 308.
  3. 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).
  4. 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)
$rowl[3] 1
$rowl[1].name.local-name
$rowl[2] if $rowl[1].is-abstract "title" else "" "padding-" + $rowl[8].string Electric
$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 ""
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