taxonomy().concept(ferc:ScheduleListOfSchedulesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Schedule").text
List of Schedules (Electric Utility)
|
taxonomy().concept(ferc:ScheduleListOfSchedulesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
Enter in column (c) the terms "none," "not applicable," or "NA," as appropriate, where no information or amounts have been reported for certain pages. Omit pages where the respondents are "none," "not applicable," or "NA".
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleListOfSchedulesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "002 - Schedule - List of Schedules")
$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 Schedule
$row
(a)
|
$data = navigate parent-child descendants from ferc:Form1QAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F1Q/ListOfSchedules" returns list (target-name, preferred-label, navigation-depth);
$data-labels = list(for $row in $data
if $row[3] > 1
skip
else
$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 == "F1Q - 002 - Schedule - List of Schedules" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$page = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F1Page").text;
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
""
else
($row_num.part-by-name(ferc-part:Row))[1].part-value,
if length(list([covered @concept=ferc:Remarks @ferc:ScheduleRemarksAxis = $concept.name.local-name])) > 0
first(list([covered @concept=ferc:Remarks @ferc:ScheduleRemarksAxis = $concept.name.local-name]))
else
none
));
for $rowl in $data-labels
$rowl[4]
1
|
|
$rowl[3]
'#' + $rowl[1].name.local-name
|
$rowl[5]
|