taxonomy().concept(ferc:ScheduleCompaniesControlledByRespondentAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Companies Controlled by Respondent
|
taxonomy().concept(ferc:ScheduleCompaniesControlledByRespondentAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Report in column (a) the names and state of incorporation of all corporations, partnerships, and similar organizations controlled (see page iii for definition of control) directly by respondent at end of year.
- If control is held jointly with one or more other interests, state the fact in a footnote and name the other interests.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleCompaniesControlledByRespondentAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "103 - Schedule - Companies Controlled by Respondent")
$heading = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value))
$heading_dict = dict(for $row in $heading
list("("+$row[1]+")",list($row[2],if $row[3] == none "" else taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(32)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:CompaniesControlledByRespondentAxis=*})) > 0
list({covered @ferc:CompaniesControlledByRespondentAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfCompanyControlledByRespondent @unit@period=$currentDuration})
first(list({@ferc:NameOfCompanyControlledByRespondent @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StateOfIncorporation @unit @period=$currentDuration})
first(list({@ferc:StateOfIncorporation @unit @period=$currentDuration}))
else
none,
if exists({@ferc:CompanyControlledByRespondentKindOfBusinessDescription @unit @period=$currentDuration})
first(list({@ferc:CompanyControlledByRespondentKindOfBusinessDescription @unit @period=$currentDuration}))
else
none,
if exists({@ferc:VotingStockOwnedByRespondentPercentage @unit @period=$currentInstant})
first(list({@ferc:VotingStockOwnedByRespondentPercentage @unit @period=$currentInstant}))
else none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none, none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Co
|
$row[3]
MD
|
$row[4]
Company C
|
$row[5]
15%
|