taxonomy().concept(ferc:ScheduleOfficersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
Gas Property And Capacity Leased From Others
|
taxonomy().concept(ferc:ScheduleOfficersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report below the name, title and salary for each executive officer whose salary is $50,000 or more. An "executive officer" of a
respondent includes its president, secretary, treasurer, and vice president in charge of a principal business unit, division or function
(such as sales, administration or finance), and any other person who performs similar policy making functions.
- If a change was made during the year in the incumbent of any position, show name and total remuneration of the previous
incumbent, and the date the change in incumbency was made.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleOfficersAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "104 - Schedule - Officers")
$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(40)
list($i,none,none,none,none,none));
$data = if count(list({covered @ferc:OfficerAxis=*})) > 0
list( {covered @ferc:OfficerAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:OfficerTitle @unit @period = $currentDuration})
first(list({@ferc:OfficerTitle @unit @period = $currentDuration }))
else
none,
if exists({@ferc:OfficerName @unit @period = $currentDuration} )
first(list({@ferc:OfficerName @unit @period = $currentDuration}))
else
none,
if exists({@ferc:OfficerSalary @unit=* @period = $currentDuration})
first(list({@ferc:OfficerSalary @unit=* @period = $currentDuration}))
else none,
if exists({@ferc:DateOfficerIncumbencyStarted @unit @period = $currentDuration})
first(list({@ferc:DateOfficerIncumbencyStarted @unit @period = $currentDuration}))
else
none,
if exists({@ferc:DateOfficerIncumbencyEnded @unit @period = $currentDuration})
first(list({@ferc:DateOfficerIncumbencyEnded @unit @period = $currentDuration}))
else
none
)}})
else
$data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
Executive Vice President, Administration and Chief Human Resources Officer
|
$row[3]
Melissa H. Anderson
|
$row[4]
522,596
|
$row[5]
NA
|
$row[6]
NA
|