taxonomy().concept(ferc:ScheduleCorporationsControlledByRespondentAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
Gas Property And Capacity Leased From Others
|
taxonomy().concept(ferc:ScheduleCorporationsControlledByRespondentAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report below the names of all corporations, business trusts, and similar organizations, controlled directly or indirectly by respondent at any time during the year. If control ceased prior to end of year, give particulars (details) in a footnote.
- If control was by other means than a direct holding of voting rights, state in a footnote the manner in which control was held, naming any intermediaries involved.
- If control was held jointly with one or more other interests, state the fact in a footnote and name the other interests.
---------------------------
DEFINITIONS
---------------------------
- See the Uniform System of Accounts for a definition of control.
- Direct control is that which is exercised without interposition of an intermediary.
- Indirect control is that which is exercised by the interposition of an intermediary that exercises direct control.
- Joint control is that in which neither interest can effectively control or direct action without the consent of the other, as where the voting control is equally divided between two holders, or each party holds a veto power over the other. Joint control may exist by mutual
agreement or understanding between two or more parties who together have control within the meaning of the definition of control in the Uniform System of Accounts, regardless of the relative voting rights of each party.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleCorporationsControlledByRespondentAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "103 - Schedule - Corporations 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(27)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:CorporationsControlledByRespondentAxis=*})) > 0
list( {covered @ferc:CorporationsControlledByRespondentAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
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: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,
if exists({@ferc:FootnoteReferences @unit @period=$currentDuration})
first(list({@ferc:FootnoteReferences @unit @period=$currentDuration}))
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 Company Inc.
|
$row[3]
Energy Retailer
|
$row[4]
100%
|
$row[5]
Footnote Ref Data
|