taxonomy().concept(ferc:ScheduleComparativeBalanceSheetLiabilitiesOtherCreditsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Comparative Balance Sheet (Assets And Other Debits)
|
Line No. |
/** THIS CODE EXCLUDES ELEMENT NAMES AS THERE ARE NO ELEMENT SPECIFIC COLUMNS **/
$headings = filter (taxonomy().concept(ferc:ScheduleComparativeBalanceSheetLiabilitiesOtherCreditsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "110 - Schedule - Comparative Balance Sheet - Liabilities and Other Credits")
$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)
|
$data = navigate parent-child descendants from ferc:LiabilitiesAndOtherCreditsAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/ComparativeBalanceSheetLiabilitiesAndOtherCredits" 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 == "110 - Schedule - Comparative Balance Sheet - Liabilities and Other Credits" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label" and "http://ferc.gov/form/2020-01-01/roles/label/" + $item.part-by-name(ferc-part:ColumnName).part-value.string == $row[2].role.uri)).to-list;
$page = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F2PageRange").text;
$current = if list([covered @concept = $row[1] @period = $currentInstant]).length > 0
first(list([covered @concept = $row[1] @period = $currentInstant]))
else
none
$prior = if list([covered @concept = $row[1] @period = $priorInstant]).length > 0
first(list([covered @concept = $row[1] @period = $priorInstant]))
else
none
list($concept,
$concept.label($row[2].role.uri).text, //Title of Account
if exists($page) $page else "", //Page Ref
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
));
for $rowl in $data-labels
$rowl[4]
1
|
|
$rowl[3]
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|