taxonomy().concept(ferc:ScheduleDirectorsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
Gas Property And Capacity Leased From Others
|
taxonomy().concept(ferc:ScheduleDirectorsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report below the information called for concerning each director of the respondent who held office at any time during the year. Include in column (a), abbreviated titles of the directors who are officers of the respondent.
- Designate members of the Executive Committee by a triple asterisk and the Chairman of the Executive Committee by a double asterisk.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleDirectorsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "105 - Schedule - Directors")
$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
$row[3]
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(48)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:DirectorAxis=*})) > 0
list( {covered @ferc:DirectorAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndTitleOfDirector @unit @period = $currentDuration})
first(list({@ferc:NameAndTitleOfDirector @unit @period = $currentDuration}))
else
none,
if exists({@ferc:PrincipalBusinessAddress @unit @period = $currentDuration})
first(list({@ferc:PrincipalBusinessAddress @unit @period = $currentDuration}))
else
none,
if exists({@ferc:ChairmanOfTheExecutiveCommittee @unit @period = $currentDuration})
first(list({@ferc:ChairmanOfTheExecutiveCommittee @unit @period = $currentDuration}))
else
none,
if exists({@ferc:MemberOfTheExecutiveCommittee @unit @period = $currentDuration})
first(list({@ferc:MemberOfTheExecutiveCommittee @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]
John Smith, Executive Vice President, Administration and Chief Human Resources Officer
|
$row[3]
1 my way
|
$row[4]
true
|
$row[5]
true
|