taxonomy().concept(ferc:ScheduleServiceCompanyPropertyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60ScheduleTitle").text
Schedule II - Service Company Property
|
taxonomy().concept(ferc:ScheduleServiceCompanyPropertyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60Instructions").text
- Provide an explanation of Other Changes recorded in Column (f) considered material in a footnote.
- Describe each construction work in progress on lines 18 through 30 in Column (b).
|
Line No. |
/** THIS CODE EXCLUDES ELEMENT NAMES AS THERE ARE NO ELEMENT SPECIFIC COLUMNS **/
$headings = filter (taxonomy().concept(ferc:ScheduleServiceCompanyPropertyAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "002 - Schedule - Service Company Property")
$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]
Description
$row
(b)
|
$elements = navigate parent-child descendants from ferc:ServiceCompanyPropertyLineItems stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F60RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F60/ServiceCompanyProperty" where $relationship.target.name not in list(ferc:ConstructionWorkInProgressAbstract, ferc:ConstructionWorkInProgressRollforwardAbstract, ferc:ConstructionWorkInProgress, ferc:ConstructionWorkInProgressAdditions, ferc:ConstructionWorkInProgressAdjustments, ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgress, ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgressAdditions, ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgressAdjustments) returns list (target-name, preferred-label, order);
$dataHead = list(for $x in $elements
if $x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F60RollforwardHeader"
$x
else
skip);
$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/F60ServiceCompanyProperty")
true
else
false;
/** Represents the first 3 columns (Line Number, Account Number, Description) **/
$abstractLabel = list($is-heading, $abstractConcept.label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text, $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/F60/ServiceCompanyProperty" returns list(target, preferred-label, order);
$dataRow2 = list(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/F60BeginningBalance"
if list([covered @concept = $y[1].name @period = $priorInstant]).length > 0
first(list([covered @concept = $y[1].name @period = $priorInstant]))
else
none
else
if list([covered @concept = $y[1].name @period = $currentInstant]).length > 0
first(list([covered @concept = $y[1].name @period = $currentInstant]))
else
none
else
if list([covered @concept = $y[1].name @period = $currentDuration]).length > 0
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/F60ServiceCompanyProperty"
$abstractLabel + $dataRow2
else
$abstractLabel + $dataRow1
)
for $rowl in $rollforwardSection
1
1
|
$rowl[2]
|
$rowl[3]
|
$rowl[4]
|
$rowl[5]
|
$rowl[6]
|
$rowl[7]
|
$rowl[8]
|
17 |
taxonomy().concept(ferc:ConstructionWorkInProgressAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60Account").text
107
|
taxonomy().concept(ferc:ConstructionWorkInProgressAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F60ServiceCompanyProperty").text
Construction Work in Progress:
|
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(18,30)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:ConstructionWorkInProgressAxis=*})) > 0
list({covered @ferc:ConstructionWorkInProgressAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:ConstructionWorkInProgressDescription @unit @period=$currentDuration})
first(list({@ferc:ConstructionWorkInProgressDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ConstructionWorkInProgress @unit @period=$priorInstant})
first(list({@ferc:ConstructionWorkInProgress @unit @period=$priorInstant}))
else
none,
if exists({@ferc:ConstructionWorkInProgressAdditions @unit @period=$currentDuration})
first(list({@ferc:ConstructionWorkInProgressAdditions @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ConstructionWorkInProgressAdjustments @unit @period=$currentDuration})
first(list({@ferc:ConstructionWorkInProgressAdjustments @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ConstructionWorkInProgress @unit @period=$currentInstant})
first(list({@ferc:ConstructionWorkInProgress @unit @period=$currentInstant}))
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
18
|
|
$row[2]
XYZ CWP
|
$row[3]
$100
|
$row[4]
$4,472,555
|
|
$row[5]
$5,472,555
|
$row[6]
$6,472,555
|
31 |
|
taxonomy().concept(ferc:ConstructionWorkInProgress).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Total
|
max(list([covered @concept=ferc:ConstructionWorkInProgress @period = $priorInstant]))
$1,000,000
|
max(list([covered @concept=ferc:ConstructionWorkInProgressAdditions @period = $currentDuration]))
$2,000,000
|
|
max(list([covered @concept=ferc:ConstructionWorkInProgressAdjustments @period = $currentDuration]))
$3,000,000
|
max(list([covered @concept=ferc:ConstructionWorkInProgress @period = $currentInstant]))
$6,000,000
|
32 |
|
taxonomy().concept(ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgress).label("http://ferc.gov/form/2020-01-01/roles/label/F60Total").text
Total
|
max(list([covered @concept=ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgress @period = $priorInstant]))
$1,000,000
|
max(list([covered @concept=ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgressAdditions @period = $currentDuration]))
$2,000,000
|
|
max(list([covered @concept=ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgressAdjustments @period = $currentDuration]))
$3,000,000
|
max(list([covered @concept=ferc:ServiceCompanyPropertyIncludingConstructionWorkInProgress @period = $currentInstant]))
$6,000,000
|