taxonomy().concept(ferc:ScheduleAccumulatedDeferredInvestmentTaxCreditsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
ACCUMULATED DEFERRED INCOME TAX CREDITS (Account 255)
|
taxonomy().concept(ferc:ScheduleAccumulatedDeferredInvestmentTaxCreditsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
Report below information applicable to Account 255. Where appropriate, segregate the balances and transactions by utility and nonutility operations. Explain by footnote any correction adjustments to the account balance shown in column (g).Include in column (i) the average period over which the tax credits are amortized.
|
|
|
|
Deferred for Year |
Allocations to Current Year's Income |
|
|
|
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleAccumulatedDeferredInvestmentTaxCreditsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "266 - Schedule - Accumulated Deferred Investment Tax Credits (Account 255)" and $item.part-by-name(ferc-part:ValueType).part-value == "Column")
$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]
Account Subdivisions
$row
(a)
|
1 |
taxonomy().concept(ferc:ElectricUtilityAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1AccumulatedDeferredInvestmentTaxCredits").text
Electric Utility
|
|
|
|
|
|
|
|
|
|
// adding a comment
$percentData = list("","3%","4%","7%","10%");
$data2 = list(for $i in range(2,5)
list($i,$percentData[$i],none,none,none,none,none,none,none,none,none)
) +
list(for $i in range(6,7)
list($i,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:AccumulatedDeferredInvestmentTaxCreditsAccountSubdivisionsAxis=*})) > 0
list({covered @ferc:AccumulatedDeferredInvestmentTaxCreditsAccountSubdivisionsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfAccumulatedDeferredInvestmentTaxCreditsAccountSubdivision @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfAccumulatedDeferredInvestmentTaxCreditsAccountSubdivision @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$priorInstant})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$priorInstant}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAccountNumber @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAccountNumber @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAmount @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAmount @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAccountNumber @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAccountNumber @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAmount @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAmount @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustments @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustments @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentInstant})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentInstant}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAveragePeriodOfAllocationToIncome @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAveragePeriodOfAllocationToIncome @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustmentDescription @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustmentDescription @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
2
|
$row[2]
if $row[2].is-fact true else false
3%
|
$row[3]
$567
|
$row[4]
115
|
$row[5]
$772
|
$row[6]
201
|
$row[7]
$25
|
$row[8]
$4
|
$row[9]
$8
|
$row[10]
48.675
|
$row[11]
N/A
|
8 |
TOTAL |
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $priorInstant]))
$92,477,242
|
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAmount @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration]))
$15,256,784
|
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAmount @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration]))
$92,477,242
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustments @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentDuration]))
$15,256,784
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:ElectricUtilityMember @period = $currentInstant]))
$92,477,242
|
|
|
9 |
taxonomy().concept(ferc:OtherUtilityOrNonutilityAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1AccumulatedDeferredInvestmentTaxCredits").text
Other
|
|
|
|
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(10,47)
list($i,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:AccumulatedDeferredInvestmentTaxCreditsAccountSubdivisionsAxis=* @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember })) > 0
list({covered @ferc:AccumulatedDeferredInvestmentTaxCreditsAccountSubdivisionsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfAccumulatedDeferredInvestmentTaxCreditsAccountSubdivision @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfAccumulatedDeferredInvestmentTaxCreditsAccountSubdivision @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$priorInstant})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$priorInstant}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAccountNumber @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAccountNumber @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAmount @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAmount @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAccountNumber @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAccountNumber @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAmount @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAmount @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustments @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustments @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentInstant})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentInstant}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAveragePeriodOfAllocationToIncome @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAveragePeriodOfAllocationToIncome @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustmentDescription @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration})
first(list({@ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustmentDescription @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
10
|
$row[2]
Gas 3%
|
$row[3]
$567
|
$row[4]
115
|
$row[5]
$772
|
$row[6]
201
|
$row[7]
$25
|
$row[8]
$4
|
$row[9]
$8
|
$row[10]
48.675
|
$row[11]
N/A
|
48 |
TOTAL |
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @period = $priorInstant]))
$92,477,242
|
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCreditsDeferredAmount @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @period = $currentDuration]))
$15,256,784
|
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCreditsAllocationToIncomeAmount @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @period = $currentDuration]))
$92,477,242
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCreditsAdjustments @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @period = $currentDuration]))
$15,256,784
|
max(list([covered @concept=ferc:AccumulatedDeferredInvestmentTaxCredits @ferc:UtilityTypeAxis=ferc:OtherUtilityOrNonutilityMember @period = $currentInstant]))
$92,477,242
|
|
|