taxonomy().concept(ferc:ScheduleListOfSchedulesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2AScheduleTitle").text
List of Schedules (Natural Gas Company)
|
taxonomy().concept(ferc:ScheduleListOfSchedulesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
Enter in column (d) the terms "none," "not applicable," or "NA" as appropriate, where no information or amounts have been reported for certain pages. Omit pages where the responses 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:Form2AAbstract stop when ($relationship.target.name == ferc:ScheduleListOfSchedulesAbstract or $relationship.target.name == ferc:ScheduleCapitalStockAndLongTermDebtDataAbstract) role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2A/ListOfSchedule" 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 == "F2A - 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/F2Page").text;
$revision_date = $concept.label("http://ferc.gov/form/2020-01-01/roles/label/F2DateRevised").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,
$revision_date,
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[1].name.local-name
$rowl[2]
if $rowl[1].is-abstract "sch-title" else ""
UTILITY PLANT
|
$rowl[3]
'#' + $rowl[1].name.local-name
|
$rowl[5]
|
$rowl[6]
|
|
|
|
|
|