Sort Order Tokens
The Case List can be organized using the following sort order tokens. The sort order tokens are categorized by Economic Inputs, Economic Outputs, Effective Qualifiers, General Info, ID Codes, and Reserves.
The General Info category of tokens includes the inputs from the General Info form. This is typically the common information used to identify a case, such as Case Name, Major Phase, Phase Configuration, Location, etc. Similarly, the ID Codes Category contains the information from the ID codes form, such as API Number, Field Code, Operator Code, Eia23StateCode, etc. If you create a custom ID code, this will also be available as a sort order token so that you can sort the case list by the custom ID. The sort tokens for the remaining categories are defined below.
Economic Options
| Exclude Case | True/False value tied to “Do not report this case” setting on Eco Options form. True being checked. |
| Exclude Cash Flow | Tied to drop down for “Cash Flows Reported” on Eco Options form, show All or None value. |
| Volume Exclusion | Tied to drop down for “Volumes Reported” on Eco Options form, shows all four options as they appear in drop down. |
Economic Inputs
| Abdn Inv Date | Abandonment Investment Date is the date at which the abandonment investment occurs in the current scenario. Shows the date of the first Abandonment to happen (Earliest abandonment date). |
| Abdn Inv Value (Grs) | Abandonment Investment Value is the sum of all the abandonment investment for the case in the current scenario. |
| First Inv Date | First Investment Date is the date at which the first investment on the case was made in the current scenario regardless of when the investment occurred. |
| First Inv Value (Grs) | First Investment Value is the value of the first investment on the case was made in the current scenario regardless of when the investment occurred. |
| Fixed Cost | The fixed costs after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Diff ($) | The price add differential associated with the gas product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Diff (%) | The price percent differential associated with the gas product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Energy Factor | The gas energy factor for the segment at the report date or first production date (whichever comes later). The amount per unit volume of gas that can be burned off. This is only useful and available when the unit for gas price is in $/MMBTU. |
| Gas Op Cost | The gas operating expenses after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Price | The price of natural gas after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Shrinkage (% One) | The first shrinkage deck for the gas product which is in %. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Shrinkage (% Two) | The third shrinkage deck for the gas product which is in %. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Shrinkage (Volume) | The second shrinkage deck for the gas product which is in a fixed volume of gas per month. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Gas Trans Cost | The cost of transporting the gas product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| LNRI Interest | Lease NRI at the Report Date for current scenario. |
| Net Interest | Sum of Revenue Interest + Royalty Interest at the Report Date for current scenario. |
| Net Profits Int | Net Profits Interest at the Report Date for current scenario. |
| NGL Diff ($) | The add price differential associated with the NGL product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| NGL Diff (%) | The percent price differential associated with the NGL product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| NGL Price | The price of NGL after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Oil Diff ($) | The add price differential associated with the Oil product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Oil Diff (%) | The percent price differential associated with the Oil product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Oil Op Cost | The oil operating expense after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Oil Price | The price of oil after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Oil Trans Cost | The cost of transporting the oil product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Rev Interest | Revenue Interest at the Report Date for current scenario. |
| Roy Interest | Royalty Interest at the Report Date for current scenario. |
| Total Inv (Grs) | The sum of all the investment made on the case. |
| Water Op Cost | The water operating expense after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Water Trans Cost | The cost of transporting the water product. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Well Cost | The monthly well cost per month after all adjustments have been applied. Displays the value for the segment at the report date or first production date (whichever comes later). |
| Wrk Interest | Working Interest at the Report Date for current scenario. |
Economic Outputs
| Commercial Status | Is the case commercial or non-commercial at the report date for the current scenario |
| ECL | Economic Limit of a case The date that the case reaches its economic limit depending on the Economic Limit type selected. |
| IROR | Internal Rate of Return – The discount rate at which the discounted net cash flow equals zero. |
| Life (Rem Years) | This is the time from the report start date to the ECL of the case. |
| Life (Total Years) | This is the time from Eco Start date to the ECL of the case. |
| ROI (Disc.) | Discounted return on investment this is the ratio of the discounted operating income and the discounted investment. |
| ROI (Undisc.) | Undiscounted return on investment This is the ratio of the amount of return to the investment. The amount of return is the total operating income over the life of the case. |
| Value M$ (Disc.) | This is the sum of the discounted net cash flow from the report start date to the ECL of the case. |
| Value M$ (Undisc.) | This is the sum of the undiscounted net cash flow from the report start date to the ECL of the case. |
| Years to Payout | The time, in years, at which the Non-discounted Cumulative Cash Flow for a case goes from negative to positive. |
Effective Qualifiers
| Expense | This is the highest ranked qualifier that has data in it for the expense qualifier category. It could be the primary qualifier of an alternate qualifier. |
| Investment | This is the highest ranked qualifier that has data in it for the investment qualifier category. It could be the primary qualifier of an alternate qualifier. |
| Ownership | This is the highest ranked qualifier that has data in it for the ownership qualifier category. It could be the primary qualifier of an alternate qualifier. |
| Price | This is the highest ranked qualifier that has data in it for the price qualifier category. It could be the primary qualifier of an alternate qualifier. |
| PRMS | This is the highest ranked qualifier that has data in it for the PRMS qualifier category. It could be the primary qualifier of an alternate qualifier. |
| Projection | This is the highest ranked qualifier that has data in it for the projection qualifier category. It could be the primary qualifier of an alternate qualifier. |
| Shrinkage | This is the highest ranked qualifier that has data in it for the shrinkage qualifier category. It could be the primary qualifier of an alternate qualifier. |
General Info
| Case Name | The name of the case that is displayed on the Case List. |
| Case Type | The type of case includes Standard, Aggregate Unit, Allocation Unit, GEL Unit, Projection Unit, Recompletion Unit, Sum Plot, or Normalized Curve. |
| Convention | The unit convention used for the case and must be one of the available conventions set up in the Database settings. |
| Country | The country in which operations are taking place for the case. |
| County | The county in which operations are taking place for the case. |
| Field | The field in which operations are taking place for the case and must be one of the available fields as set up in the Database settings. |
| Gas Gatherer | The energy company that will be receiving the gas that comes out of the case. It is usually a midstream or natural gas company. |
| Latitude | The locational latitude coordinate of the case. If a case has a single wellbore, the latitude reflects the surface latitude of that wellbore. If the case has multiple wellbores, it shows the average of the surface latitudes for all wellbores. |
| Location | The block and section that the case is located in. |
| Longitude | The locational longitude coordinate of the case. If a case has a single wellbore, the longitude reflects the surface longitude of that wellbore. If the case has multiple wellbores, it shows the average of the surface longitudes for all wellbores. |
| Major Phase | Displays value for Major Phase as specified in the General Info form. |
| Oil Gatherer | The energy company that will be receiving the oil that comes out of the well. This is sometimes the same as the operator. |
| Operator | The Oil and Gas operator that has the majority working interest in the case. |
| Phase Configuration | This is a term used to describe the products, products’ behavior, and relationship between the products on each case. These options are defined under the Products Configuration option on the Database Settings ribbon. |
| PRMS – Categories & Subcategories | This describes how likely a well or case will be productive or contains hydrocarbons and the current state of the case. The category & subcategory selected must be available in the Database settings. |
| PRMS – Category | This describes how likely a well or case will be productive or contains hydrocarbons. For the Reserves classification, the default categories are Proved, Probable, and Possible. The category selected must be one of the available categories set up in the Database settings. |
| PRMS – Classification | This describes the commercial certainty of the case. The defaults are Reserves, Contingent Resources, and Prospective Resources, which translate into Commercial, Sub-Commercial, and Potentially Commercial respectively. The classification entered here must be one of the available categories set up in the Database settings. |
| PRMS – Subcategory | This depends on the selected category and describes the current state of the case. For a proved category, the subcategories are producing, behind pipe, non-producing, shut-in, undeveloped, and injection. The subcategory selected must be one of the available categories set up in the Database settings. |
| Reservoir | The reservoir in which the case is producing from and must be one of the available reservoirs as set up in the Database settings. It is nested underneath a given field. |
| State | The state (if United States) in which the case is being operated. |
| Total Depth | The total measured depth of the well. For a case with a single wellbore, this is the total measured depth of that wellbore. For a case with multiple wellbores, this is the measured depth of the longest wellbore. |
| Well | The well number associated with a case. |
| Well Type | The well type includes Flow, INJ (Injector), Pump, Source, SWD (Saltwater Disposal) or Unknown. |
ID Codes
| Alternate Id | This displays the code in the alternate ID slot. |
| API Number | American Petroleum Institute (API) number is a unique number assigned to every oil and gas well drilled in the United States |
| API Formatted | API number formatted with dashes to show a breakdown of API number into State code, County code, Wellbore ID, and directional sidetrack & event code: _ _ – _ _ _ – _ _ _ _ _ – _ _ _ _. |
| Case ID | A code that is created by PHDwin that ties each record to a case in PHDwin. |
| DRI | This displays the ID code created when data is imported from Enverus/Drilling Info. |
| Eia23CountyCode | EIA standard county code for use in Form EIA-23L, Annual report of domestic oil and natural gas reserves. Its a three-digit numeric code for the county or parish in which operated wells are located. |
| Eia23FieldCode | EIA standard field name code for identified oil and/or gas fields in the United States. |
| Eia23StateCode | EIA standard State code for use in Form EIA-23L, Annual report of domestic oil and natural gas reserves. Its a two-character alphabetic abbreviation of the State that data reported pertains. |
| Eia23SubCode | EIA standard subdivision code for use in Form EIA-23L, Annual report of domestic oil and natural gas reserves. Its a two-digit code of the appropriate geographic subdivision to which data reported for pertains. |
| Eia23TypeCode | EIA standard type code for use in Form EIA-23L, Annual report of domestic oil and natural gas reserves. Used to classify a reservoir as conventional (C), Shale (SH), or Low Permeability (LP). |
| Field Code | The code for the field listed on the case.LP). |
| Operator Code | The code for the operator listed on the case. |
| Retrieval Code | This displays the code associated with the primary import ID of the source used to create the case. If the case was created using a DRI file, the retrieval code would match the DRI code for the case. |
| RRC Dist Code | The code for the RRC district listed on the lease (Texas). |
| Unique ID | This is an ID assigned by PHDWin, and is used for merging and exporting, to ensure that duplicate leases can be found. This is a very large number and cannot be edited. |
| Custom ID Code | This displays other ID code values created by the user within PHDwin or through an import file. |
Projections
| Gas BFactor | BFactor from Segment 1 of Gas Forecast. If forecast is not Arps, leave blank.. |
| Gas Initial Decline | Decline from Segment 1 of Gas Forecast. |
| Gas Initial Forecast Method | Forecast method of segment 1 of gas product. |
| Gas Qi | Initial rate from start of Segment 1 of Gas forecast. |
| Gas Rpt Date Decline | Decline rate from Gas Forecast at Report Date.. |
| Gas Rpt Date Forecast Method | Forecast method of gas active segment on report start date. |
| Gas Rpt Date Qi | Initial rate from Gas Forecast at Report Date. qualifier. |
| Major Start Date | Beginning date of 1st segment of the Major Phase forecast. |
| Oil BFactor | BFactor from Segment 1 of Oil Forecast. If forecast is not Arps, leave blank.. |
| Oil Initial Decline | Decline from Segment 1 of Oil Forecast. |
| Oil Initial Forecast Method | Forecast method of segment 1 of Oil product. |
| Oil Qi | Initial rate from start of Segment 1 of Oil forecast. |
| Oil Rpt Date Decline | Decline rate from Oil Forecast at Report Date.. |
| Oil Rpt Date Forecast Method | Forecast method of Oil active segment on report start date. |
| Oil Rpt Date Qi | Initial rate from Oil Forecast at Report Date. qualifier. |
| Project Name | If case belongs to a Project, this will show Project Name, otherwise it’s blank. |
Reserves
| Gas Economic EUR | Sum of Gas production prior to the Economic Limit. |
| Gas First Prod Date | First date of Gas production, from monthly history or forecast, whichever comes first. |
| Gas Hist End Date | End of Gas historical monthly production. |
| Gas Historical Cum | Sum of Gas production from Monthly Production table only. |
| Gas Rem Reserves | Sum of Gas production between Report Date and Economic Limit. |
| Gas Rpt Date Cum | Sum of Gas production prior to Report Date in current scenario. |
| Gas Tech EUR | Sum of all Gas production volumes, historical + forecast, no cut off. |
| NGL Economic EUR | Sum of NGL production prior to the Economic Limit. |
| NGL First Prod Date | First date of NGL production, from monthly history or forecast, whichever comes first. |
| NGL Hist End Date | End of NGL historical monthly production. |
| NGL Historical Cum | Sum of NGL production from Monthly Production table only. |
| NGL Rem Reserves | Sum of NGL production between Report Date and Economic Limit. |
| NGL Rpt Date Cum | Sum of NGL production prior to Report Date in current scenario. |
| NGL Tech EUR | Sum of all NGL production volumes, historical + forecast, no cut off. |
| Oil Economic EUR | Sum of Oil production prior to the Economic Limit. |
| Oil First Prod Date | First date of Oil production, from monthly history or forecast, whichever comes first. |
| Oil Hist End Date | End of Oil historical monthly production. |
| Oil Historical Cum | Sum of Oil production from Monthly Production table only. |
| Oil Rem Reserves | Sum of Oil production between Report Date and Economic Limit. |
| Oil Rpt Date Cum | Sum of Oil production prior to Report Date in current scenario. |
| Oil Tech EUR | Sum of all Oil production volumes, historical + forecast, no cut off. |
| Water Economic EUR | Sum of Water production prior to the Economic Limit. |
| Water First Prod Date | First date of Water production, from monthly history or forecast, whichever comes first. |
| Waterl Hist End Date | End of Water historical monthly production. |
| Water Historical Cum | Sum of Water production from Monthly Production table only. |
| Water Rem Reserves | Sum of Water production between Report Date and Economic Limit. |
| Water Rpt Date Cum | Sum of Water production prior to Report Date in current scenario. |
| Water Tech EUR | Sum of all Water production volumes, historical + forecast, no cut off. |
Wellbore and Completions
| Lateral Length Avg | This shows the length of the horizontal section of the wellbore. If the case has multiple wellbores and/or completions, it shows the average Lateral Length across all wellbores/completions. |
| Lateral Length Max | This shows the length of the horizontal section of the wellbore. If the case has multiple wellbores and/or completions, it shows the maximum Lateral Length across all wellbores/completions. |
| Lateral Length Min | This shows the length of the horizontal section of the wellbore. If the case has multiple wellbores and/or completions, it shows the minimum Lateral Length across all wellbores/completions. |
| Lateral Length Sum | This shows the length of the horizontal section of the wellbore. If the case has multiple wellbores and/or completions, it shows the sum of Lateral Length across all wellbores/completions. |
| Plugged Date Max | The date the wellbore was plugged/abandoned. If the case has multiple wellbores, it shows the latest (maximum) plugged date |
| Plugged Date Min | The date the wellbore was plugged/abandoned. If the case has multiple wellbores, it shows the earliest (minimum) plugged date |
| Proppant Avg | This shows the mass of proppant pumped during completion of the wellbore. If the case has multiple wellbores and/or completions, it shows the average proppant mass across all wellbores/completions. |
| Proppant Max | This shows the mass of proppant pumped during completion of the wellbore. If the case has multiple wellbores and/or completions, it shows the maximum proppant mass across all wellbores/completions. |
| Proppant Min | This shows the mass of proppant pumped during completion of the wellbore. If the case has multiple wellbores and/or completions, it shows the minimum proppant mass across all wellbores/completions. |
| Proppant Sum | This shows the mass of proppant pumped during completion of the wellbore. If the case has multiple wellbores and/or completions, it shows the sum of proppant mass across all wellbores/completions. |
| Spud Date Max | The date drilling of the well started. If the case has multiple wellbores, it shows the latest (maximum) spud date |
| Spud Date Min | The date drilling of the well started. If the case has multiple wellbores, it shows the earliest (minimum) spud date |