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
// adding a comment $data2 = list(for $i in range(40) list($i,none,none,none,none,none,none,none,none,none,none,none,none) ); $data = if count(list({covered @ferc:SubstationsAxis=*})) > 0 $substations = set({covered @ferc:SubstationsAxis=*}.dimension(ferc:SubstationsAxis)); list(for $x in $substations list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:SubstationsAxis = $x}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:SubstationsAxis = $x})) else 0, if exists({@ferc:SubstationNameAndLocation @unit @period=$currentDuration @ferc:SubstationsAxis = $x}) first(list({@ferc:SubstationNameAndLocation @unit @period=$currentDuration @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:SubstationCharacterDescription @unit @period=$currentDuration @ferc:SubstationsAxis = $x}) first(list({@ferc:SubstationCharacterDescription @unit @period=$currentDuration @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:SubstationCharacterAttendedOrUnattended @unit @period=$currentDuration @ferc:SubstationsAxis = $x}) first(list({@ferc:SubstationCharacterAttendedOrUnattended @unit @period=$currentDuration @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:PrimaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:PrimaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:SecondaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:SecondaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:TertiaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:TertiaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:SubstationInServiceCapacity @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:SubstationInServiceCapacity @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:NumberOfTransformersInService @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:NumberOfTransformersInService @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:NumberOfSpareTransformers @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:NumberOfSpareTransformers @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:ConversionApparatusAndSpecialEquipmentType @unit @period=$currentDuration @ferc:SubstationsAxis = $x}) first(list({@ferc:ConversionApparatusAndSpecialEquipmentType @unit @period=$currentDuration @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:NumberOfConversionApparatusAndSpecialEquipmentUnits @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:NumberOfConversionApparatusAndSpecialEquipmentUnits @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none, if exists({@ferc:CapacityOfConversionApparatusAndSpecialEquipment @unit @period=$currentInstant @ferc:SubstationsAxis = $x}) first(list({@ferc:CapacityOfConversionApparatusAndSpecialEquipment @unit @period=$currentInstant @ferc:SubstationsAxis = $x})) else none )) else $data2; $uniqueData = list(for $y in $data if $y == list(0,none,none,none,none,none,none,none,none,none,none,none,none) skip else $y ); for $row in $uniqueData.sort // adding a comment $data = if count(list({covered @ferc:SubstationByFunctionalCharacterAxis=*})) > 0 $substations = set({covered @ferc:SubstationByFunctionalCharacterAxis=*}.dimension(ferc:SubstationByFunctionalCharacterAxis)); list(for $x in $substations list( if exists({@ferc:SubstationNameAndLocation @unit @period=$currentDuration @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:SubstationNameAndLocation @unit @period=$currentDuration @ferc:SubstationByFunctionalCharacterAxis = $x})) else "Total" + $x.local-name, if exists({@ferc:PrimaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:PrimaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:SecondaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:SecondaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:TertiaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:TertiaryVoltageLevel @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:SubstationInServiceCapacity @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:SubstationInServiceCapacity @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:NumberOfTransformersInService @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:NumberOfTransformersInService @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:NumberOfSpareTransformers @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:NumberOfSpareTransformers @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:NumberOfConversionApparatusAndSpecialEquipmentUnits @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:NumberOfConversionApparatusAndSpecialEquipmentUnits @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none, if exists({@ferc:CapacityOfConversionApparatusAndSpecialEquipment @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x}) first(list({@ferc:CapacityOfConversionApparatusAndSpecialEquipment @unit @period=$currentInstant @ferc:SubstationByFunctionalCharacterAxis = $x})) else none )) else skip $dataTotal = list( list( if exists([@ferc:SubstationNameAndLocation @unit @period=$currentDuration]) first(list([@ferc:SubstationNameAndLocation @unit @period=$currentDuration])) else "Total", if exists([@ferc:PrimaryVoltageLevel @unit @period=$currentInstant]) first(list([@ferc:PrimaryVoltageLevel @unit @period=$currentInstant])) else none, if exists([@ferc:SecondaryVoltageLevel @unit @period=$currentInstant]) first(list([@ferc:SecondaryVoltageLevel @unit @period=$currentInstant])) else none, if exists([@ferc:TertiaryVoltageLevel @unit @period=$currentInstant]) first(list([@ferc:TertiaryVoltageLevel @unit @period=$currentInstant])) else none, if exists([@ferc:SubstationInServiceCapacity @unit @period=$currentInstant]) first(list([@ferc:SubstationInServiceCapacity @unit @period=$currentInstant])) else none, if exists([@ferc:NumberOfTransformersInService @unit @period=$currentInstant]) first(list([@ferc:NumberOfTransformersInService @unit @period=$currentInstant])) else none, if exists([@ferc:NumberOfSpareTransformers @unit @period=$currentInstant]) first(list([@ferc:NumberOfSpareTransformers @unit @period=$currentInstant])) else none, if exists([@ferc:NumberOfConversionApparatusAndSpecialEquipmentUnits @unit @period=$currentInstant]) first(list([@ferc:NumberOfConversionApparatusAndSpecialEquipmentUnits @unit @period=$currentInstant])) else none, if exists([@ferc:CapacityOfConversionApparatusAndSpecialEquipment @unit @period=$currentInstant]) first(list([@ferc:CapacityOfConversionApparatusAndSpecialEquipment @unit @period=$currentInstant])) else none )) for $row in ($data.sort + $dataTotal)
taxonomy().concept(ferc:ScheduleSubstationsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text SUBSTATIONS
taxonomy().concept(ferc:ScheduleSubstationsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
  1. Report below the information called for concerning substations of the respondent as of the end of the year.
  2. Substations which serve only one industrial or street railway customer should not be listed below.
  3. Substations with capacities of Less than 10 MVa except those serving customers with energy for resale, may be grouped according to functional character, but the number of such substations must be shown.
  4. Indicate in column (b) the functional character of each substation, designating whether transmission or distribution and whether attended or unattended. At the end of the page, summarize according to function the capacities reported for the individual stations in column (f).
  5. Show in columns (I), (j), and (k) special equipment such as rotary converters, rectifiers, condensers, etc. and auxiliary equipment for increasing capacity.
  6. Designate substations or major items of equipment leased from others, jointly owned with others, or operated otherwise than by reason of sole ownership by the respondent. For any substation or equipment operated under lease, give name of lessor, date and period of lease, and annual rent. For any substation or equipment operated other than by reason of sole ownership or lease, give name of co-owner or other party, explain basis of sharing expenses or other accounting between the parties, and state amounts and accounts affected in respondent's books of account. Specify in each case whether lessor, co-owner, or other party is an associated company.
Character of Substation VOLTAGE (In MVa) Conversion Apparatus and Special Equipment
Line No. $headings = filter (taxonomy().concept(ferc:ScheduleSubstationsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "426 - Schedule - Substations") $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
$heading_dict[$row][2].name.local-name
$heading_dict[$row][1] Name and Location of Substation
$row (a)
1 $row[2] Northland $row[3] Distribution $row[4] Distribution $row[5] 115.00 $row[6] 12.00 $row[7] 20 $row[8] 25 $row[9] 4 $row[10] 8 $row[11] Type $row[12] 2 $row[13] 1,000
set({covered @ferc:SubstationsAxis=*}.dimension(ferc:SubstationsAxis)).length + 1 $row[1] if $row[1].is-fact "true" else "false" Northland $row[2] 115.00 $row[3] 12.00 $row[4] 20 $row[5] 25 $row[6] 4 $row[7] 8 $row[8] 2 $row[9] 1,000