taxonomy().concept(ferc:ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
ACCUMULATED DEFERRED INCOME TAXES - ACCELERATED AMORTIZATION PROPERTY (Account 281)
|
taxonomy().concept(ferc:ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report the information called for below concerning the respondent’s accounting for deferred income taxes rating to amortizable property.
- For other (Specify),include deferrals relating to other income and deductions.
- Use footnotes as required.
|
|
|
|
CHANGES DURING YEAR |
ADJUSTMENTS |
|
|
|
|
|
|
|
|
Debits |
Credits |
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "272 - Schedule - Accumulated Deferred Income Taxes - Accelerated Amortization Property (Account 281) - Classified by Utility Types")
$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
$row
(a)
|
// adding a comment
$members = navigate parent-child descendants from ferc:UtilityTypeAxis role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyUtilityTypes" returns list (target, preferred-label, order);
$data-labels = list(for $row in $members
$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 == "272 - Schedule - Accumulated Deferred Income Taxes - Accelerated Amortization Property (Account 281) - Classified by Utility Types" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$rowID = if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
0;
$abstractLabel = list($rowID.number, $concept.label($row[2].role.uri).text);
$data = navigate parent-child descendants from ferc:AccumulatedDeferredIncomeTaxLiabilitiesAssetsAcceleratedAmortizationPropertyByTypeLineItems role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyUtilityTypes" returns list (target, preferred-label, order);
$dataRow1 = list(for $y in $data
$conceptPeriod = $y[1].period-type
if $conceptPeriod == "instant"
if $y[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1BeginningBalance"
if exists([covered @concept = $y[1].name @ferc:UtilityTypeAxis = $row[1] @period = $priorInstant])
first(list([covered @concept = $y[1].name @ferc:UtilityTypeAxis = $row[1] @period = $priorInstant]))
else
none
else
if exists([covered @concept = $y[1].name @ferc:UtilityTypeAxis = $row[1] @period = $currentInstant])
first(list([covered @concept = $y[1].name @ferc:UtilityTypeAxis = $row[1] @period = $currentInstant]))
else
none
else
if exists([covered @concept = $y[1].name @ferc:UtilityTypeAxis = $row[1] @period = $currentDuration])
first(list([covered @concept = $y[1].name @ferc:UtilityTypeAxis = $row[1] @period = $currentDuration]))
else
none);
$sequenceReferences = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/elementSequence") where ($item.part-by-name(ferc-part:ScheduleRole).part-value == "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyUtilityTypes") returns $item.part-by-name(ferc-part:SequenceRole).part-value).to-list;
$sequenceDimension = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/elementSequence") where ($item.part-by-name(ferc-part:ScheduleRole).part-value == "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyUtilityTypes") returns $item.part-by-name(ferc-part:SequenceDimension).part-value).to-list;
$breakdown = list(
if $sequenceReferences.to-list.length > 0
$sequenceRole = $sequenceReferences[1];
$sequenceElements = navigate parent-child descendants role $sequenceRole returns list(target, preferred-label, result-order);
$axis = $sequenceDimension[1].to-qname;
$lineItemsList = list(for $l in $sequenceElements
if $l.length > 0
$conceptRoll = $l[1];
if $conceptRoll.is-abstract
skip
else
$l
else
skip
);
$row_number = if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"";
$NoData = list(for $i in range(2)
list($i, $row_number,'Other', None, None, None, None, None, None, None, None, None, None)
);
$data1 = if count(list({covered @ferc:UtilityTypeAxis=* where $fact.dimension($axis) != none})) > 0
list({covered @ferc:UtilityTypeAxis = $concept.name {list(
if exists({@ferc:OrderNumber @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@ferc:OrderNumber @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
0,
$row_number,
/** Description **/
if exists({@concept = $lineItemsList[2][1] @unit @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[2][1] @unit @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Opening balance **/
if exists({@concept = $lineItemsList[3][1] @unit @period = $priorInstant where $fact.dimension($axis) != none} )
first(list({@concept = $lineItemsList[3][1] @unit @period = $priorInstant where $fact.dimension($axis) != none}))
else
none,
/** Debits to 410.1 **/
if exists({@concept = $lineItemsList[4][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[4][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Credits to 411.1 **/
if exists({@concept = $lineItemsList[5][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[5][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Debits to 410.2 **/
if exists({@concept = $lineItemsList[6][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[6][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Credits to 411.2 **/
if exists({@concept = $lineItemsList[7][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[7][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Debits - Acct Credited **/
if exists({@concept = $lineItemsList[8][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[8][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Debits - Amount **/
if exists({@concept = $lineItemsList[9][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[9][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Credits - Acct Debited **/
if exists({@concept = $lineItemsList[10][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[10][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Credits - Amount **/
if exists({@concept = $lineItemsList[11][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none})
{@concept = $lineItemsList[11][1] @unit=* @period = $currentDuration where $fact.dimension($axis) != none}
else
none,
/** Ending Balance **/
if exists({@concept = $lineItemsList[12][1] @unit=* @period = $currentInstant where $fact.dimension($axis) != none})
{@concept = $lineItemsList[12][1] @unit=* @period = $currentInstant where $fact.dimension($axis) != none}
else
none
)}})
else
$NoData;
$data2 = list(for $x in $data1
if $x == list(0,$x[2],none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x);
$orders = set(for $x in $data2 $x[1]).sort;
$orderedData = list(for $order in $orders
for $row in $data2
if $row[1] != $order
skip
else
$row );
$data = list(for $z in range($orderedData.length)
$updatedNumber = $orderedData[$z][2].string + "." + $z.string;
list(
$updatedNumber.number,
$orderedData[$z][3],
$orderedData[$z][4],
$orderedData[$z][5],
$orderedData[$z][6],
$orderedData[$z][7],
$orderedData[$z][8],
$orderedData[$z][9],
$orderedData[$z][10],
$orderedData[$z][11],
$orderedData[$z][12],
$orderedData[$z][13],
false
)
);
for $row in $data
$row
else
skip
);
/** IF ADD ROW NUMBERS THEN THIS HEADING ROW NEEDS TO BE UPDATED - SEE 1st ITEM IN THE LISTS **/
$Heading_Numbers = list(list(9,"Gas", None, None, None, None, None, None, None, None, None, None, true),
list(2,"Electric", None, None, None, None, None, None, None, None, None, None, true),
list(1,"Accelerated Amortization (Account 281)", None, None, None, None, None, None, None, None, None, None, true)
);
if $abstractLabel[1] == 17
list($abstractLabel + $dataRow1 + list(false)) + $breakdown + $Heading_Numbers
else
list($abstractLabel + $dataRow1 + list(false)) + $breakdown
);
$orders = set(for $x in $data-labels
for $y in $x $y[1]).sort;
$orderedData = list(for $order in $orders
for $rows in $data-labels
for $row in $rows
if $row[1] != $order
skip
else
$row );
for $rowl in $orderedData
$rowl[1]
21
|
$rowl[2]
21
|
$rowl[3]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[4]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[5]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[6]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[7]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[8]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[9]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[10]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[11]
if $rowl[13] "gray-out" else ""
$300,000
|
$rowl[12]
if $rowl[13] "gray-out" else ""
$300,000
|
18 |
taxonomy().concept(ferc:AccumulatedDeferredIncomeTaxesClassifiedByTaxTypeAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ADITAcceleratedAmortizationProperty").text
Classification fo TOTAL
|
|
|
|
|
|
|
|
|
|
|
$dataHead = navigate parent-child descendants from ferc:AccumulatedDeferredIncomeTaxesClassifiedByTaxTypeAbstract stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F1RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyTaxTypes" returns list (target-name, preferred-label, order);
$rollforwardSection = list(for $x in $dataHead
$abstractConcept = taxonomy().concept($x[1]);
$is-heading = if ($x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1ADITAcceleratedAmortizationProperty")
true
else
false;
$abstractLabel = list($is-heading, $abstractConcept.label($x[2].role.uri).text);
$data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1/ScheduleAccumulatedDeferredIncomeTaxesAcceleratedAmortizationPropertyTaxTypes" returns list(target, preferred-label, order);
$dataRow2 = list(none, none, none, none, none, none, none, none, none, none);
$dataRow1 = list(for $y in $data
$conceptPeriod = $y[1].period-type
if $conceptPeriod == "instant"
if $y[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1BeginningBalance"
if exists([covered @concept = $y[1].name @period = $priorInstant])
first(list([covered @concept = $y[1].name @period = $priorInstant]))
else
none
else
if exists([covered @concept = $y[1].name @period = $currentInstant])
first(list([covered @concept = $y[1].name @period = $currentInstant]))
else
none
else
if exists([covered @concept = $y[1].name @period = $currentDuration])
first(list([covered @concept = $y[1].name @period = $currentDuration]))
else
none);
if $x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F1ADITAcceleratedAmortizationProperty"
$abstractLabel + $dataRow2
else
$abstractLabel + $dataRow1
)
for $rowl in $rollforwardSection
19
19
|
$rowl[2]
|
$rowl[3]
if $rowl[1] "gray-out" else ""
|
$rowl[4]
if $rowl[1] "gray-out" else ""
|
$rowl[5]
if $rowl[1] "gray-out" else ""
|
$rowl[6]
if $rowl[1] "gray-out" else ""
|
$rowl[7]
if $rowl[1] "gray-out" else ""
|
$rowl[8]
if $rowl[1] "gray-out" else ""
|
$rowl[9]
if $rowl[1] "gray-out" else ""
|
$rowl[10]
if $rowl[1] "gray-out" else ""
|
$rowl[11]
if $rowl[1] "gray-out" else ""
|
$rowl[12]
if $rowl[1] "gray-out" else ""
|