taxonomy().concept(ferc:ScheduleUndividedJointInterestPropertyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Undivided Joint Interest Property Property
|
taxonomy().concept(ferc:ScheduleUndividedJointInterestPropertyAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give an analysis of changes during the year in Account No. 30, Carrier Property, by carrier property accounts, for investments in undivided joint interest property. The respondent will only report its portion of the carrier property of any undivided joint interest pipeline in which it has an interest. If the respondent owns an interest in multiple undivided joint interest pipelines, prepare and submit a separate schedule 214-215 for each undivided joint interest pipeline in which it has an interest. If multiple schedules 214-215 are submitted, number all schedules subsequent to the first with a number and letter page designator (For example ... 214, 215; 214a, 215a; 214b, 215b; etc...).
- Enter in column (c) the cost of newly constructed property, additions, and improvements made to existing property. Include amounts distributed to carrier property accounts during the year which were previously charged to Account No. 187, Construction Work in Progress. In column (d) enter expenditures for existing pipeline property purchased or otherwise acquired. Enter in column (e) property sold, abandoned, or otherwise retired during the year. This will generally be a positive number so that the calculation in column (f) works properly.
- If pipeline operating property was acquired from or sold to some other company during the year, footnote the acquisition or sale if it exceeded $250,000. Include the following in the footnote: the name of the company the property was acquired from or sold to, the mileage acquired or sold, and the date of acquisition or sale. Include termini, the original cost of property acquired from an affiliate or other common carrier (see Instruction 3-1, Property acquired, Instructions for Carrier Property Accounts in Uniform System of Accounts), and the cost of the property to the respondent. Also give the amount debited or credited to each company account representing such property acquired or disposed of.
- Enter in column (g) for each account the net of all other accounting adjustments, transfers, and clearances applicable to prior years' accounting.
- Explain fully each adjustment, clearance, or transfer in excess of $500,000 in a footnote. Explain transfers to or from Account No. 34, Noncarrier Property, in Schedule 219.
- Indicate in parenthesis any entry in columns (f), (g), or (h) which represents an excess of credits over debits.
|
|
|
|
Property Change During Year (in dollars) |
|
|
|
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleUndividedJointInterestPropertyAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "214 - Schedule - Undivided Joint Interest Property")
$headings = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value))
$heading_dict = dict(for $row in $headings
list("("+$row[1]+")",$row[2])
);
for $row in $heading_dict.keys.sort
$heading_dict[$row]
Account
$row
(a)
|
$dataHead = navigate parent-child descendants from ferc:UndividedJointInterestPropertyLineItems stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F6RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F6/UndividedJointInterestProperty" where ($relationship.target-name != ferc:OrderNumber and $relationship.target-name != ferc:PlantName) returns list (target, preferred-label, order);
$dataRow2 = list(none, none, none, none, none, none, none, none);
$pipelinesList = set([covered @ferc:NameOfUndividedJointInterestPipelineAxis = *].dimensions-typed().values);
$piplinesUnique = if ($pipelinesList).to-list.length > 0
sum($pipelinesList).to-list
else
list("Enter Pipeline Name:");
$allData = list(
$rollforwardSection = list(for $pipeline in $piplinesUnique
$pipelineName = if list({covered @ferc:PlantName @ferc:NameOfUndividedJointInterestPipelineAxis=$pipeline}).length > 0
first(list({covered @ferc:PlantName @ferc:NameOfUndividedJointInterestPipelineAxis=$pipeline}))
else
$pipeline
$pipelineData = list(for $x in $dataHead
$abstractConcept = $x[1];
$data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F6/UndividedJointInterestProperty" returns list(target, preferred-label, order);
$row_num = (filter $abstractConcept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "214 - Schedule - Undivided Joint Interest Property" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$row_number = list(if ($row_num.part-by-name(ferc-part:Row)).length == 0
""
else
($row_num.part-by-name(ferc-part:Row))[1].part-value);
$abstractLabel = list($row_number[1], $abstractConcept.label($x[2].role.uri).text);
$dataRow1 = list(
for $y in $data
$conceptPeriod = $y[1].period-type;
if $conceptPeriod == "instant"
if $y[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F6BeginningBalance"
if exists([covered @concept = $y[1].name @unit = * @period = $priorInstant @ferc:NameOfUndividedJointInterestPipelineAxis = $pipeline])
first(list([covered @concept = $y[1].name @unit = * @period = $priorInstant @ferc:NameOfUndividedJointInterestPipelineAxis = $pipeline]))
else
none
else
if exists([covered @concept = $y[1].name @unit = * @period = $currentInstant @ferc:NameOfUndividedJointInterestPipelineAxis = $pipeline])
first(list([covered @concept = $y[1].name @unit = * @period = $currentInstant @ferc:NameOfUndividedJointInterestPipelineAxis = $pipeline]))
else
none
else
if exists([covered @concept = $y[1].name @unit = * @period = $currentDuration @ferc:NameOfUndividedJointInterestPipelineAxis = $pipeline])
first(list([covered @concept = $y[1].name @unit = * @period = $currentDuration @ferc:NameOfUndividedJointInterestPipelineAxis = $pipeline]))
else
none);
$abstractLabel + $dataRow1);
list(list("PIPE LINE NAME",$pipelineName,none,none,none,none,none,none,none,none)) + $pipelineData
);
$rollforwardSection
);
for $pipelines in $allData
for $pipeline in $pipelines
for $rowl in $pipeline
$rowl[1]
if $rowl[1] == "PIPE LINE NAME" "data-heading" else ""
1
|
$rowl[2]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[3]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[4]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[5]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[6]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[7]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[8]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[9]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|
$rowl[10]
if $rowl[1] == "PIPE LINE NAME" "gray-out" else ""
|