taxonomy().concept(ferc:ScheduleDirectorsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
DIRECTORS
|
taxonomy().concept(ferc:ScheduleDirectorsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").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 an 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 "" 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
|