taxonomy().concept(ferc:ScheduleChargesForOutsideProfessionalAndOtherConsultativeServicesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Charges for Outside Professional and Other Consultative Services
|
taxonomy().concept(ferc:ScheduleChargesForOutsideProfessionalAndOtherConsultativeServicesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report the information specified below for all charges made during the year included in any account (including plant accounts) for outside consultative and other professional services. These services include rate, management, construction, engineering, research, financial, valuation, legal, accounting, purchasing, advertising,labor relations, and public relations, rendered for the respondent under written or oral arrangement, for which aggregate payments were made during the year to any corporation partnership, organization of any kind, or individual (other than for services as an employee or for payments made for medical and related services) amounting to more than $250,000, including payments for legislative services, except those which should be reported in Account 426.4 Expenditures for Certain Civic, Political and Related Activities.
(a) Name of person or organization rendering services.
(b) Total charges for the year.
- Sum under a description "Other", all of the aforementioned services amounting to $250,000 or less.
- Total under a description "Total", the total of all of the aforementioned services.
- Charges for outside professional and other consultative services provided by associated (affiliated) companies should be excluded from this schedule and be reported on Page 358, according to the instructions for that schedule.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleChargesForOutsideProfessionalAndOtherConsultativeServicesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "357 - Schedule - Charges for Outside Professional and Other Consultative Services")
$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(34)
list($i,none,none)
);
$data = if count(list({covered @ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServicesAxis=*})) > 0
list({covered @ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServicesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServices @unit @period=$currentDuration})
first(list({@ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServices @unit @period=$currentDuration}))
else
none,
if exists({@ferc:ChargesForOutsideProfessionalAndOtherConsultativeServices @unit @period=$currentDuration})
first(list({@ferc:ChargesForOutsideProfessionalAndOtherConsultativeServices @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ACCENTURE LLP - CONSULTING - FINANCE - IT
|
$row[3]
$629,004
|
$total_sequence_number = if count(list([covered @ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServices @ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServicesAxis=*])) > 0
count(list([covered @ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServices @ferc:NameOfPersonOrOrganizationRenderingProfessionalOrConsultativeServicesAxis=*]))
else
34;
$total_sequence_number + 1
35
|
taxonomy().concept(ferc:ChargesForOutsideProfessionalAndOtherConsultativeServices).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
max(list([covered @concept=ferc:ChargesForOutsideProfessionalAndOtherConsultativeServices @period = $currentDuration]))
$3,209,815
|