if set('1-F').contains([covered @concept.local-name ='FormType']) if first(list([covered @ferc:StatementOfIncomeMajorNonmajor])) == "Major" true else false else true
taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F1Header").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/F1Header").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/F1Header").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/F1Header").text Year/Period of Report:
End of: [@ferc:ReportYear @period=$currentDuration] 2018 / [@ferc:ReportPeriod @period=$currentDuration] Q4
$data = navigate parent-child descendants from ferc:StatementOfIncomeLineItems role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/IncomeStatment" 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 == "114 - Schedule - Statement of Income" 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/F1Page").text; $current = if list([covered @concept = $row[1] @period = $currentDuration]).length > 0 first(list([covered @concept = $row[1] @period = $currentDuration])) else none $prior = if list([covered @concept = $row[1] @period = $priorDuration]).length > 0 first(list([covered @concept = $row[1] @period = $priorDuration])) else none $current_three_months = if list([covered @concept = $row[1] @period = $current3M]).length > 0 first(list([covered @concept = $row[1] @period = $current3M])) else none $prior_three_months = if list([covered @concept = $row[1] @period = $prior3M]).length > 0 first(list([covered @concept = $row[1] @period = $prior3M])) else none $current_electric = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration]).length > 0 first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration])) else none $prior_electric = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $priorDuration]).length > 0 first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $priorDuration])) else none $current_gas = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $currentDuration]).length > 0 first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $currentDuration])) else none $prior_gas = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $priorDuration]).length > 0 first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:GasUtilityMember @period = $priorDuration])) else none $current_other = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $currentDuration]).length > 0 first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $currentDuration])) else none $prior_other = if list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $priorDuration]).length > 0 first(list([covered @concept = $row[1] @ferc:UtilityTypeAxis=ferc:OtherUtilityMember @period = $priorDuration])) else none list($concept, $concept.label($row[2].role.uri).text, if exists($page) $page else "", if ($row_num.part-by-name(ferc-part:Row)).length > 0 ($row_num.part-by-name(ferc-part:Row))[1].part-value else "" , $current, $prior, $current_three_months, $prior_three_months, $current_electric, $prior_electric, $current_gas, $prior_gas, $current_other, $prior_other )); for $rowl in $data-labels
taxonomy().concept(ferc:ScheduleStatementOfIncomeAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text Gas Property And Capacity Leased From Others
taxonomy().concept(ferc:ScheduleStatementOfIncomeAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text Quarterly
  1. Report in column (c) the current year to date balance. Column (c) equals the total of adding the data in column (g) plus the data in column (i) plus the data in column (k). Report in column (d) similar data for the previous year. This information is reported in the annual filing only.
  2. Enter in column (e) the balance for the reporting quarter and in column (f) the balance for the same three month period for the prior year.
  3. Report in column (g) the quarter to date amounts for electric utility function; in column (i) the quarter to date amounts for gas utility, and in column (k) the quarter to date amounts for other utility function for the current year quarter.
  4. Report in column (h) the quarter to date amounts for electric utility function; in column (j) the quarter to date amounts for gas utility, and in column (l) the quarter to date amounts for other utility function for the prior year quarter.
  5. If additional columns are needed, place them in a footnote.
  6. Annual or Quarterly if applicable
  7. Do not report fourth quarter data in columns (e) and (f)
  8. Report amounts for accounts 412 and 413, Revenues and Expenses from Utility Plant Leased to Others, in another utility columnin a similar manner to a utility department. Spread the amount(s) over lines 2 thru 26 as appropriate. Include these amounts in columns (c) and (d) totals.
  9. Report amounts in account 414, Other Utility Operating Income, in the same manner as accounts 412 and 413 above
Line No. $headings = filter (taxonomy().concept(ferc:ScheduleStatementOfIncomeAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "114 - Schedule - Statement of Income") $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] Title of Account
$row (a)
$rowl[4] 1
$rowl[1].name.local-name
$rowl[2] if $rowl[1].is-abstract "title" else "" UTILITY OPERATING INCOME
$rowl[3] $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 "" $rowl[12] if $rowl[1].is-abstract "gray-out" else "" $rowl[13] if $rowl[1].is-abstract "gray-out" else "" $rowl[14] if $rowl[1].is-abstract "gray-out" else ""