Link to Project Start                                      

Link Cases to a Project Start Date. (Y or N)

Offset from Project

Offset of a case from the Project in days.

Project Date

Start date for the project.

Project Name

Name of an existing or new project.

Project Note

Notes for the project.

Case API Code

Maps alphanumeric value to "API Number" field of the default ID Codes form ONLY. Must be preceded by "Primary Import ID Code" token.

Case Memo

Maps to the Memo field of the default Memos form. To assign memo to a specific date, value must be preceded by "Case Memo Date", otherwise memo defaults date to present day. Must be preceded by "Primary Import ID Code" token.

Case Memo Date

Maps to the date field (MM/DD/YYYY) of corresponding Case Memo of the default Memos form. Must be used in combination with and precede the "Case Memo" token to have the data applied. Must be preceded by "Primary Import ID Code" token.

Case Multiplier

Maps numeric value to the Case Multiplier field of the default Eco Options form. Accepts positive and negative values. Must be preceded by "Primary Import ID Code" token.

Case Name

Maps alphanumeric value to the "Case Name" field of the default General Info form. Maximum 60 characters. Must be preceded by "Primary Import ID Code" token.

Country

Maps alphanumeric value to the "Country" field of the default General Info form. Maximum 45 characters. Must be preceded by "Primary Import ID Code" token.

County

Maps alphanumeric value to the "County" field of the default General Info form. Also used for 2nd level Administrative equivalent to County (like Parish or Municipality). Maximum 45 characters. Must be preceded by "Primary Import ID Code" token.

Field Code

Maps alphanumeric value to "Field Code" field of the default ID Codes form.  Will contain Stage Field codes from commercial data vendors. Must be preceded by "Primary Import ID Code" token.

Field Name

Maps alphanumeric value to the "Field" data field of the default General Info form. Maximum 60 characters. Must be preceded by "Primary Import ID Code" token.

Gas Gatherer

Maps alphanumeric value to "Gas Gatherer" field of the default General Info form. Maximum of 60 characters. Must be preceded by "Primary Import ID Code" token.

Gas Gravity

Maps numeric value to Gas Specific Gravity (Reference Air) in the Production Test tab of the Case Editor. Supports values > 1.0. One allowed per case. Multiple values not supported; last value imported will be used. No support for importing to Reservoir Fluids Tests. Requires "Primary Import ID Code" only.

Latitude

Maps numeric value to "Latitude" field of the default General Info form. Supports positive and negative values to 6 decimal places. No support for Min. or Sec. Must be preceded by "Primary Import ID Code" token.

Location

Maps alphanumeric value to "Location" field of the default General Info form. Maximum of 60 characters. Must be preceded by "Primary Import ID Code" token.

Longitude

Maps numeric value to "Longitude" field of the default General Info form. Supports positive and negative values to 6 decimal places. No support for Min. or Sec. Must be preceded by "Primary Import ID Code" token.

Major Phase

Maps alphanumeric value to "Major Phase" field of the default General Info form. Must be preceded by "Primary Import ID Code" token.

Offshore

Maps True/False value to the Offshore/Onshore toggle on the default General Info form. Must be preceded by "Primary Import ID Code" token.

Oil Gatherer

Maps alphanumeric value to "Gas Gatherer" field of the default General Info form. Maximum of 60 characters. Must be preceded by "Primary Import ID Code" token.

Oil Gravity

Maps numeric value to "Oil Gravity" in the Production Tests tab of the Case Editor and sets the gravity units to Specific Gravity. Can be viewed on the Case Editor's Expense tab.  Supports values > 1.0.

Operator Code

Maps alphanumeric value to "Operator Code" field of the default ID Codes form. Must be preceded by "Primary Import ID Code" token.

Operator Name

Maps alphanumeric value to "Operator Name" field of the default General Info form. Maximum of 60 characters. Must be preceded by "Primary Import ID Code" token.

Primary Import ID Code

This is a special import token, prompted for during the initial import set up, used to associate all remaining data in a given record to one specific case with a unique alphanumeric value. This token will automatically map to the first data element per record of any data to be imported. It is recommended the data element precede all other fields in the import file. It can only be mapped once per table or sheet. Will populate case "Case Name" filed of the default General Info form if creating new cases without mapping a Case Name in import file.

PRMS Category

Maps to the "PRMS Category" field of the default General Info form. The category falls under the case's class. Examples of PRMS category include proved, probable, possible, etc. Must be preceded by "Primary Import ID Code" token.

PRMS Class

Maps to the "PRMS Class" field of the default General Info form. Examples of PRMS class include reserves, contingent, prospective, etc. Must be preceded by "Primary Import ID Code" token.

PRMS Subcategory

Maps to the "PRMS Subcategory" field of the default General Info form. Examples of PRMS subcategories include producing, non-producing, shut-in, behind pipe, etc. Must be preceded by "Primary Import ID Code" token.

Res Category (Class & Cat Abbr)

Maps Reserve Category abbreviations to the reserve category. The following abbreviations are converted: DP (Producing), BP (Behind Pipe), NP (Non-Producing), SI (Shut-In), UD (Undeveloped). Does not convert: PA (P&A) or IJ (Injection)

Res Pressure

Maps one Reservoir Pressure per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/ "Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases.

Res Temp

Maps one Casing Pressure per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases.

Reservoir

Maps alphanumeric value to the "Reservoir" data field of the default General Info form. Maximum 60 characters. Must be preceded by "Primary Import ID Code" token.

Retrieval Code

Maps alphanumeric value to "Retrieval Code" field of the default ID Code form. Do not map for Aries import. Requires "Primary Import ID Code" only

RRC District Code

Maps alphanumeric value to "RRC Dist Code" field of the default ID Code form. Requires "Primary Import ID Code" only

State

Maps alphanumeric value to the "State" field of the default General Info form. Also used for 1st level Administrative equivalent to State (like Province or Region). Maximum 20 characters. Must be preceded by "Primary Import ID Code" token.

Temp Gradient (deg/100ft or deg/100m)

Imports the average temperature increase per 100 ft or 100 M. Units are defined by case's existing Unit Convention or default convention is used if new case is created. No unit conversions are applied.

Temp Gradient (deg/ft or deg/m)

Imports the average temperature increase per ft or M. Units are defined by case's existing Unit Convention or default convention is used if new case is created. No unit conversions are applied.

Total Depth

Maps numeric value to the "Total Depth" field of the default General Info form. Maximum value of 100,000. Units based on Convention applied to existing cases, or default Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Tubing Diameter

Imports the inside diameter of a tubing string. Only one per case supported. Case units or default conventions for new cases are used. No unit conversions are applied.

User-Def Gravity (cur product)

Measure of  relative density for current product

User-Def Gravity Current Product

Measure of  relative density for current product

User-Def Gravity Type (cur product)

Acceptable values are "API", "SG", or "Gas"

User-Defined ID Code

Uses column header to map value to a corresponding ID Code in the ID Codes form. Can create new ID Codes if column header does not exist as an ID Code in database. New ID Codes will default to String input type. Existing ID Codes will honor formatting of Number, String, or Date as specified in the PHDwin database. Numbers can support up 15 significant digits, and Strings have a maximum of 60 characters. Must be preceded by "Primary Import ID Code" token.

Volume Multiplier

Maps numeric value to the Volume Multiplier field of the default Eco Options form. Accepts positive and negative values. Must be preceded by "Primary Import ID Code" token.

Well Num- Append to Case Name

Used to map test data or wellbore/completion data to the correct wellbore in the case.  This text will be appended to the Case Name of a case.  This is the import trigger token for production tests and for wellbore/completion data

Well Num- No Append to Case Name

Used to map test data or wellbore/completion data to the correct wellbore in the case.  This text will be not appended to the Case Name of a case.  This is the import trigger token for production tests and for wellbore/completion data

Well Spacing

Maps numerical value to the "Spacing" field of the default General Info form. Maximum value of 10,000,000. Units based on Convention applied to existing cases, or default Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Well Type

Maps value to the "Well Type" field of the default General Info form. Values must match existing Well Types (Flowing, Pump, Inject, Source, SWD, Unknown). Must be preceded by "Primary Import ID Code" token.

Days On (Apr)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Aug)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Dec)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Feb)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Jan)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Jul)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Jun)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Mar)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (May)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Nov)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Oct)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Days On (Sep)

Maps numeric value to the monthly production table for "Days On" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are days.

Gas Production (Apr)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Aug)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Dec)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Feb)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Jan)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Jul)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Jun)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Mar)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (May)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Nov)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Oct)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas Production (Sep)

Maps numeric value to the monthly production table for "Gas" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Hours On (Apr)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Aug)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Dec)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Feb)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Jan)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Jul)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Jun)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Mar)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (May)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Nov)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Oct)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Hours On (Sep)

Divides numeric value by 24 and maps result to the monthly production table for "Days On" product for the month specified. Base units are days. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens.

Oil Production (Apr)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Aug)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Dec)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Feb)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Jan)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Jul)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Jun)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Mar)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (May)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Nov)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Oct)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil Production (Sep)

Maps numeric value to the monthly production table for "Oil" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

User-def Prod (Apr)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Aug)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Dec)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Feb)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Jan)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Jul)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Jun)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Mar)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (May)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Nov)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Oct)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-def Prod (Sep)

Production for the month specified regarding the user-defined product listed by the User-defined Product[Columnar] token.  Requires Prod year(yyyy)-Start Record token.  Base units are specified in the target cases' convention.

User-defined Product [Columnar]

Used for importing production for user-defined products.  The product name is listed in this column for every record of production.  Requires Prod year(yyyy)-Start Record token.  Base units are defined in the target cases' convention.

Water Production (Apr)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Aug)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Dec)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Feb)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Jan)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Jul)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Jun)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Mar)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (May)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Nov)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Oct)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water Production (Sep)

Maps numeric value to the monthly production table for "Water" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Apr)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Aug)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Dec)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Feb)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Jan)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Jul)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Jun)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Mar)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (May)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Nov)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Oct)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Well Count (Sep)

Maps numeric value to the monthly production table for "Total Wells" product for the month specified. Must be preceded by both "Primary Import ID Code" and "Prod Year (YYYY)" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

CO2 [Daily Prod Date]

Maps numeric value to the daily production table for "CO2" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Condensate [Daily Prod Date]

Maps numeric value to the daily production table for "Condensate" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Daily Production Date

Specifies the date for daily production.  Used in conjunction with "______ [Daily Prod Date]" tokens. Date format should follow Windows Regional formatting, "MM/DD/YYYY" or "DD/MM/YYYY". Must be preceded by "Primary Import ID Code" token.

Daily Production Product

Specifies the name of an existing custom product in the database. Used in conjunction with "Daily Production Volume" token to update daily production table. Must be preceded by "Primary Import ID Code" token.

Daily Production Volume

Maps numeric value to the daily production table for custom product for the date specified. Requires both "Daily Production Product" and "Primary Import ID Code". Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Gas [Daily Prod Date]

Maps numeric value to the daily production table for "Gas" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Helium [Daily Prod Date]

Maps numeric value to the daily production table for "Helium" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

NGL [Daily Prod Date]

Maps numeric value to the daily production table for "NGL" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Oil [Daily Prod Date]

Maps numeric value to the daily production table for "Oil" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Water [Daily Prod Date]

Maps numeric value to the daily production table for "Water" product for the date specified. Must be preceded by both "Primary Import ID Code" and "Daily Production Date" tokens. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases.

Deck Cap Value

Only applicable to the base price or expense. Not applicable to shrinkage, escalations or differentials. This value should be set on the first segment of the deck and all others will be ignored. Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Fixed Esc

Only use for importing escalation decks to indicate whether an escalation is fixed or continuous. Use a 1 for True (Fixed) or 0 for False (Continuous). Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Length (months)

Maps a numeric value to determine how long each segment of the deck lasts. This must be populated for each segment of the deck. To continue until the economic limit, input "ECL" or "-1". Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values. ECL

Deck Product

Designates the product for an incoming deck. Supported options include all volume based product names, "Case" for Fixed Costs, and "Total Wells" for Well Costs. Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Start Date

The Import trigger token for decks. Supports hard-coded or linked date . Date format should follow Windows Regional formatting, "MM/DD/YYYY" or "DD/MM/YYYY". Linked Date options include "Eco Start", "FirstProd [Product Name]", "Seg [Segment Number] [Product Name]", or "DeclSeg [Product Name]". The date is only required for the first segment of the deck as the start of each subsequent segment is set by the end of the previous segment. Must be immediately preceded by either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Stream

Designates the stream for an incoming deck. Default streams include "Revenue", "Op Cost", "Trans Cost", "Other Cost", "Well Cost", "Fixed Cost", and "Shrunk Volume". Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Type

Designates the type for an incoming deck as either “Price”, “Percent Differential”, “Add Differential”, “Energy Factor”, “Expense”, “Percent Escalation”, “Add Escalation”, “Shrinkage Percent”, or “Shrinkage Add”. Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Units

Only used for importing price decks for the "Gas" product. Options include"$/Mcf", "$/MMBtu", "$/E3m3", or "$/GJ". Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" token and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Deck Value

Maps a numeric value for each segment of an incoming deck. This can be a dollar amount, percentage, or volume, depending on Deck Type. Used in conjunction with other tokens containing the "Deck" prefix. Must be preceded by "Deck Start Date" and either "Model Name" token for creating a new model, or "Primary Import ID Code" token for case specific deck values.

Model Name

Model Deck Name that acts as the trigger token for Model Deck stand alone import. It must be the leftmost column in order to begin Model Deck import.

Case Discount Factor (%)

Maps numeric discount rate in percentage (%) for each case's discounting. "Allow Individual Case Override" (Project Properties Discounting tab) must be checked on before different discounting rates can be used on each case. The project discount rates will always be used to calculate totals and subtotals.

Init Gas Rev Int

Imports initial product-specific gas revenue interest for a case.  Requires token "Init Work Int (frac)" to be used simultaneously.  Overwrites Init Rev Int (frac) when gas is major phase. Values should be decimal and are restricted to 8 decimal places.

Init Lease NRI (frac)

Maps numeric value to the "Lease NRI" field of the Initial Ownership record. Supports values between 0.0 and 1.0 with up to 8 decimal places. Requires "Primary Import ID Code" token.

Init Oil Rev Int

Imports initial product-specific oil revenue interest for a case.  Requires token "Init Work Int (frac)" to be used simultaneously.  Overwrites Init Rev Int (frac) when oil is major phase.  Values should be decimal and are restricted to 8 decimal places.

Init Rev Int (frac)

Maps numeric value to the "Revenue Interest" field of the Initial Ownership record. Supports values between 0.0 and 1.0 with up to 8 decimal places. Requires "Primary Import ID Code" token.

Init Royalty Int (frac)

Maps numeric value to the "Royatly Interest" field of the Initial Ownership record. Supports values between -1.0 and 1.0 with up to 8 decimal places. Requires "Primary Import ID Code" token.

Init Work Int (frac)

Maps numeric value to the "Working Interest" field of the Initial Ownership record. Supports values between 0.0 and 1.0 with up to 8 decimal places. Requires "Primary Import ID Code" token.

Intangible Investment Amount (M$)

Maps numeric value to the "Intangible AMT (M$)" portion of a new investment for the date specfied. Must be preceded by both "Primary Import ID Code" and "Investment Date" tokens.

Investment Category

Maps alphanumeric value to the "Category" field of the investment record for the investment date specified. If the value does not match an existing investment category, it will create a new investment category. Must be preceded by both "Primary Import ID Code" and "Investment Date" tokens.

Investment Date

Specifies the date for creating a new investment. Date format should follow Windows Regional formatting, "MM/DD/YYYY" or "DD/MM/YYYY". Also supports linked dates options of Cum <Product Name> <Volume Amount>, ECL <Current Case or Case ID>, Eco Start, FProd <Product Name> , Seg <Segment Number> <Product Name>, DeclSeg <Product Name>. Should be used with either Intangible or Tangible Investment Amount tokens (or both) as well as "Investment Description" and "Investment Type Net/Gross". Must be preceded by "Primary Import ID Code" token.

Investment Date Offset/Cum Value

Offsets Investment Date by a number of days or cumulative amount of production when using a linked date reference.  Must be preceded by both "Primary Import ID Code" and "Investment Date."

Investment Description

Maps alphanumeric value to the "Description" field of the investment record for the investment date specified. Must be preceded by both "Primary Import ID Code" and "Investment Date" tokens.

Investment Type Net/Gross

Designates an investment as Gross or Net. Full text "Gross" or "Net" should be used in the import file. Must be preceded by both "Primary Import ID Code" and "Investment Date" tokens.

Tangible Investment Amount (M$)

Maps numeric value to the "Tangible AMT (M$)" portion of a new investment for the date specfied. Must be preceded by both "Primary Import ID Code" and "Investment Date" tokens.

ARIES Eco Command Line

Maps alphanumeric "Expression" field in the Aries Windows "AC_Economics" Table or the "ECO_DATA" field in the Aries DOS "ECONOMIC" table. For Aries Windows Sort = 5. For Aries DOS Sort = 4. Used in conjunction with "Aries Eco Keyword", "Aries Eco Section" and "Aries Qualifier" tokens.

ARIES Eco Keyword

Maps alphanumeric "Keyword" field in the Aries Windows "AC_Economics" Table. Not used in Aries DOS because the keyword is in the "ECO_DATA" field. Sort = 4. Used in conjunction with "Aries Eco Command Line", "Aries Eco Section" and "Aries Qualifier" tokens.

ARIES Eco Section

Maps alphanumeric "Section" field in the Aries Windows "AC_Economics" Table or the "ECO_TYPE" field in the Aries DOS "ECONOMIC" table. For Aries DOS and Windows Sort = 2. Used in conjunction with "Aries Eco Keyword", "Aries Qualifier" and "Aries Command Line" tokens.

Graph Comment Justify

Sets justification for graph note text alignment.  Supported input is "L" (for Left), "R" (for Right), or "C" (for Centered). Requires "Graph Comment Pointer" "Graph Comment Product", "Graph Comment Text", "Graph Comment XPos (Date)", "Graph Comment YPos", and "Graph Comment Vertical/Horizontal" tokens.

Graph Comment Pointer

Controls display of pointer symbol for imported graph notes.  Supported values are 0 (for pointer turned off) or 1 (for pointer turned on).  Requires "Graph Comment Product", "Graph Comment Text", "Graph Comment XPos (Date)", "Graph Comment YPos", "Graph Comment Justify" and "Graph Comment Vertical/Horizontal" tokens.

Graph Comment Product

Associates the created graph note with a specific product.  Supported values are "Gas", "Oil", "Water", or "Grid".  This field must be mapped directly after the Primary Import ID column (this column must be the second column.)  Requires "Graph Comment Text", "Graph Comment XPos (Date)", "Graph Comment YPos", "Graph Comment Pointer", "Graph Comment Justify" and "Graph Comment Vertical/Horizontal" tokens.

Graph Comment Text

Imports the text for a graph note.  Only string notes are supported; paragraph notes are not supported.  Limited to 46 characters.  Requires "Graph Comment Product", "Graph Comment XPos (Date)", "Graph Comment YPos", "Graph Comment Pointer", "Graph Comment Justify" and "Graph Comment Vertical/Horizontal" tokens.

Graph Comment Vertical/Horizontal

Sets horizontally or vertically alignment for a graph note.  Supported values are H (horizontal) or V (vertical).  Requires "Graph Comment Product", "Graph Comment Text", "Graph Comment XPos (Date)", "Graph Comment YPos", "Graph Comment Pointer" and "Graph Comment Justify" tokens.

Graph Comment XPos (Date)

Sets X coordinate for imported graph note.  Use date format mm/dd/yyyy or yyyy.decimal for notes linked to a product (Gas, Oil, Water).  Grid note values from 0 to 100 are supported. A 0 value is the left axis; 100 is the right axis.  Requires "Graph Comment Product", "Graph Comment Text", "Graph Comment YPos", "Graph Comment Justify", "Graph Comment Pointer" and "Graph Comment Vertical/Horizontal" tokens.

Graph Comment YPos

Sets Y coordinate for imported graph note.  For notes linked to a product (Oil, Gas, Water), this is the volume in base units (bbl , Mcf).  For grid notes, this is a value from 0-100 where 0 is the bottom of the graph and 100 is the top of the graph. Requires "Graph Comment Product", "Graph Comment Text", "Graph Comment XPos (Date)", "Graph Comment Justify", "Graph Comment Pointer" and "Graph Comment Vertical/Horizontal" tokens.

Other Inj [Prod Date]

Must be preceded by "Production Date" token. Monthly numeric injection fluid volume will be populated for the production month specified. Units are expected to be in base units of the convention used to import the data. i.e. bbl, etc.

Qualifier

Designates a qualifier for newly created data from a flat file (csv).  If this token is not used, then the current active qualifier will receive the results of the import. Additionally, maps alphanumeric "Qualifier" field from the Aries Windows "AC_Economics" table or the "ECO_QUALIFIER" field from the Aries DOS "ECONOMIC" table. Must be preceded by "Primary Import ID Code" token. When importing Aries file, must also be used in conjunction with "Aries Eco Keyword", "Aries Eco Section" and "Aries Qualifier" tokens.

Condensate Price

Maps a numeric value as a single segment, case specific price for the "Condensate" product. The price segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Condensate Price Diff $

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "Condensate" product by the specified dollar amount. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price differential units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Condensate Price Diff (%)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "Condensate" product by the specified percentage. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Units are dimensionless. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Energy Factor (BTU/scf or MJ/m3)

Maps a numeric value as a single segment, case specific Energy Factor adjustment to the base price for the "Gas" Product. Only applies if base price is in $/MMBtu units. The energy factor segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Energy Factor units will be based on Convention setting for existing cases in database, or default Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Gas Price Diff ($)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "Gas" product by the specified dollar amount. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price differential units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Gas Price Diff (%)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "Gas" product by the specified percentage. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Units are dimensionless. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Init Condensate Op Cost

Maps a numeric value as a single segment, case specific Op Cost for the "Condensate" product. The Op Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Fixed Cost (100% $/mon)

Maps a numeric value as a single segment, case specific Fixed Cost for the specified case. The Fixed Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on the Currency setting for existing cases in database, or default Currency for new cases. Must be preceded by "Primary Import ID Code" token.

Init Gas Op Cost

Maps a numeric value as a single segment, case specific Op Cost for the "Gas" product. The Op Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Gas Price

Maps a numeric value as a single segment, case specific price for the "Gas" product. The price segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Gas Trans Cost

Maps a numeric value as a single segment, case specific Trans Cost for the "Gas" product. The Trans Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init NGL Op Cost

Maps a numeric value as a single segment, case specific Op Cost for the "NGL" product. The Op Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Oil Op Cost

Maps a numeric value as a single segment, case specific Op Cost for the "Oil" product. The Op Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Oil Price

Maps a numeric value as a single segment, case specific price for the "Oil" product. The price segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Oil Trans Cost

Maps a numeric value as a single segment, case specific Trans Cost for the "Oil" product. The Trans Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Water Op Cost

Maps a numeric value as a single segment, case specific Op Cost for the "Water" product. The Op Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

Init Well Cost (100% $/w/m)

Maps a numeric value as a single segment, case specific monthly cost for the "Total Wells" product. The Well Cost segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Cost units will be based on the Currency setting for existing cases in database, or default Currency for new cases. Must be preceded by "Primary Import ID Code" token.

NGL Price

Maps a numeric value as a single segment, case specific price for the "NGL" product. The price segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Must be preceded by "Primary Import ID Code" token.

NGL Price Diff ($)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "NGL" product by the specified dollar amount. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price differential units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

NGL Price Diff (%)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "NGL" product by the specified percentage. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Units are dimensionless. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Oil Price Diff ($)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "Oil" product by the specified dollar amount. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Price differential units will be based on Currency and Convention setting for existing cases in database, or default Currency and Convention for new cases. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Oil Price Diff (%)

Maps a numeric value as a single segment, case specific price differential to adjust the base price for the "Oil" product by the specified percentage. The price differential segment will begin linked to the Eco Start Date of the case and remain constant until the ECL. Units are dimensionless. Supports both positive and negative values. Must be preceded by "Primary Import ID Code" token.

Annual Gas (M units) [Prod Date]

Multiplies the incoming value by 1000 then divides by 12. Maps the result into the Monthly Production table for "Gas" product for every month of the year specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token and either "Production Date" or "Prod Year (YYYY)" token.

Annual Gas [Prod Date]

Divides the incoming value by 12. Maps the result into the Monthly Production table for "Gas" product for every month of the year specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token and either "Production Date" or "Prod Year (YYYY)" token.

Annual Oil (M units) [Prod Date]

Multiplies the incoming value by 1000 then divides by 12. Maps the result into the Monthly Production table for "Oil" product for every month of the year specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token and either "Production Date" or "Prod Year (YYYY)" token.

Annual Oil [Prod Date]

Divides the incoming value by 12. Maps the result into the Monthly Production table for "Oil" product for every month of the year specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token and either "Production Date" or "Prod Year (YYYY)" token.

Annual User-Def Vol (M units) [Prod Date]

Must be preceded by "Production Date" token. Only the year is used from the date token. Each month numeric User Defined Product (as defined by the field name) value in the year specified by the date token will be populated with the imported value divided by 12. Units are expected to be 1000 times the base units of the convention used to import the data. i.e. MBbl, E3M3, etc. PHDwin will match on the import fields name to define the product.

Annual User-Def Vol [Prod Date]

Must be preceded by "Production Date" token. Only the year is used From the date token. Each month numeric Used Defined Product (as defined by the field name) value in the year specified by the date token will be populated with the imported value divided by 12. Units are expected to be in base units of the convention used to import the data. i.e. bbls, M3 etc.  PHDwin will match on the import fields name to define the product.

Annual Water (M units) [Prod Date]

Multiplies the incoming value by 1000 then divides by 12. Maps the result into the Monthly Production table for "Water" product for every month of the year specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token and either "Production Date" or "Prod Year (YYYY)" token.

Annual Water [Prod Date]

Divides the incoming value by 12. Maps the result into the Monthly Production table for "Water" product for every month of the year specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token and either "Production Date" or "Prod Year (YYYY)" token.

CO2 Production [Prod Date]

Maps numeric value to the monthly production table for "CO2" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Condensate Cum Prior Hist

Maps numeric value to the "PRE" production line of the monthly production table for the "Condensate" product. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token

Condensate Production [Prod Date]

Maps numeric value to the monthly production table for "Condensate" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Days On [Prod Date]

Maps numeric value to the monthly production table for "Days On" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Gas Cum Prior Hist

Maps numeric value to the "PRE" production line of the monthly production table for the "Gas" product. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token.

Gas Production [Prod Date]

Maps numeric value to the monthly production table for "Gas" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Helium Production [Prod Date]

Maps numeric value to the monthly production table for "Helium" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Hours On [Prod Date]

Divides value by 24 and maps numeric result to the monthly production table for "Days On" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

NGL Cum Prior Hist

Maps numeric value to the "PRE" production line of the monthly production table for the "NGL" product. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token.

NGL Production [Prod Date]

Maps numeric value to the monthly production table for "NGL" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Oil Cum Prior Hist

Maps numeric value to the "PRE" production line of the monthly production table for the "Oil" product. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by "Primary Import ID Code" token.

Oil Production [Prod Date]

Maps numeric value to the monthly production table for "Oil" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Prod Year(YYYY)

Specifies the year for columnar and annual production.  Used in conjunction with "______ Production (month)" or "Annual _____" tokens. Year format should be 4 digits, YYYY. Must be preceded by "Primary Import ID Code" token.

Production Date

Specifies the date for monthly production.  Used in conjunction with "______ [Prod Date]" tokens. Date format should follow Windows Regional formatting, "MM/DD/YYYY" or "DD/MM/YYYY". Must be preceded by "Primary Import ID Code" token.

User-Defined Product [Prod Date]

Maps numeric value to the monthly production table for a custom product for the date specified. Custom product name is determined by column header in import file. Best practice is to create custom product in PHDwin database prior to import. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Water Cum Prior Hist

Maps numeric value to the monthly production table for "Water" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Water Inj [Prod Date]

Maps numeric value to the monthly production table for "Water Inj" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Water Production [Prod Date]

Maps numeric value to the monthly production table for "Water" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Well Count [Prod Date]

Maps numeric value to the monthly production table for "Total Wells" product for the date specified. Base units are set by default unit Convention in database for new cases, or applied unit Convention on existing cases. Must be preceded by both "Primary Import ID Code" and "Production Date" tokens.

Phase Configuration

Phase Configuration to be applied to the case.

Projection (Dec)l Min (cur product)

Maps a numeric value to the Decline Minimum (Dm) parameter for an Arps projection. Only valid for Arps projection type segments. Import value should be a tangent effective decline. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection (Dec)line (cur product)

Maps a numeric value to the Decline parameter for Arps, Lin-Time, Lin-Cum, and Log-Cum projection type segments. Import value should be a tangent effective decline for Arps projection type segments. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection BegCum (cur product)

Maps a numeric value to the Initial Cumulative Production (Cumi) parameter for Lin-Cum and Log-Cum projection type segments. Units will be based on Convention setting for existing cases in database, or default Convention for new cases. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Current Product

Designates the product name when importing projection parameters for new projections. Should match existing product names in the PHDwin database. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by "Primary Import ID Code" token.

Projection End Date (cur product)

Maps a date value to the End Date parameter for Arps and Lin-Time projection type segments. Date format should follow Windows Regional formatting, "MM/DD/YYYY" or "DD/MM/YYYY". Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection EndCum (cur product)

Maps a numeric value to the Final Cumulative Production (Cumf) parameter for Lin-Cum and Log-Cum projection type segments. Units will be based on Convention setting for existing cases in database, or default Convention for new cases. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Hyp Factor (cur product)

Maps a numeric value to the Hyperbolic Factor (B Fact) parameter for Arps projection type segments. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Qf (cur product)

Maps a numeric value to the Final Monthly Rate (Qf) parameter for Arps, Lin-Time, Lin-Cum, and Log-Cum projection type segments. Units will be based on Convention setting for existing cases in database, or default Convention for new cases. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Qi (cur product)

Maps a numeric value to the Initial Monthly Rate (Qi) parameter for Arps, Lin-Time, Lin-Cum, and Log-Cum projection type segments. Units will be based on Convention setting for existing cases in database, or default Convention for new cases. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Seg Vol (cur product)

Maps a numeric value to the Segment Volume (Vol) parameter for Arps and Lin-Time projection type segments. Units will be based on Convention setting for existing cases in database, or default Convention for new cases. Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Solve For (cur product)

Designates the unknown values that PHDwin will solve for as part of building each projection segment. Options include "Qf", "De", "Edate", "Cumf", and "Vol". Arps and Lin-Time segments will have 2 unknown values. Lin-Cum and Log-Cum segments will have 1 unknown value. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Start Date (cur product)

Maps a date value to the Beginning Date parameter for Arps and Lin-Time projection type segments. Date format should follow Windows Regional formatting, "MM/DD/YYYY" or "DD/MM/YYYY". Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by both "Primary Import ID Code" and "Projection Current Product" tokens.

Projection Type (cur product)

Designates the projection type when importing projection parameters for new projections. Options are limited to "Arps", "Lin-Time", "Lin-Cum", "Log-Cum", or "Flat". Used in conjunction with other tokens containing the "Projection" prefix. Must be preceded by "Primary Import ID Code" token.

BHP/Z

Maps one Bottom Hole Pressure divided by Z production test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases.

Choke Size

Maps one choke size per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/ "Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases

CSGP

Maps one Casing Pressure per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases

FTP

Maps one Flowing Tubing Pressure per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/ "Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases.

SIBHP

Maps one Shut-in Bottom Hole Pressure per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases.

SITP

Maps one Shut-in Bottom Tubing Pressure per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" or "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing case convention for existing cases or default import unit convention for new cases.

Test Cum Gas

Maps value to Gas Cumulative Production field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date". Units are in existing cases gas base units or import convention's gas base units for new cases. No conversions are calculated.

Test Cum Gas (M vol)

Maps value to Gas Cumulative Production field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date". Units are in 1000 times (M) existing case's gas base units or 1000 times (M) import convention's gas base units for new cases. No conversions are calculated.

Test Cum Oil

Maps value to Oil Cumulative Production field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date". Units are in existing cases oil base units or import convention's oil base units for new cases. No conversions are calculated.

Test Cum Oil (M vol)

Maps value to Oil Cumulative Production field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date". Units are in 1000 times (M) existing case's Oil's base units or 1000 times (M) import convention's Oil base units for new cases. No conversions are calculated.

Test Cum Water

Maps value to Water Cumulative Production field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date". Units are in existing cases water base units or import convention's Water base units for new cases. No conversions are calculated.

Test Cum Water (M vol)

Maps value to Water Cumulative Production field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date". Units are in 1000 times (M) existing case's water base units or 1000 times (M) import convention's Water base units for new cases. No conversions are calculated.

Test Date

Date for each test. Supports one test per day per wellbore/completion. Always used with "Well-Number-Start Test" or "Well Num-Start Test-No Append" or "Upper Perf-Start Test"

Test Date- Start Record

Starts a test record and sets the test date. Supports one test per day. Never used with "Well Number-Start Test" or "Well Num-Start Test-No Append" or"Upper Perf-Start Test"

Test Gas (vol/day)

Maps one Gas Test Rate per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" OR "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing Gas base units for existing cases or default import convention Gas base units for new cases. Rate is Per Day.

Test Notes

Maps alphanumeric value to Test Notes field for a given test record. Used with "Test Date-Start Record" OR "Upper Perf-Start Test" w/ "Test Date" OR "Well Number-Start Test" w/ "Test Date" OR "Well Num-Start Test-No Append" w/ "Test Date".

Test Oil (vol/day)

Maps one Oil Test Rate per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" OR "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing Oil base units for existing cases or default import convention base oil unit for new cases. Rate is Per Day.

Test Water (vol/day)

Maps one Water Test Rate per test point. Requires "Test Date-Start Record" OR "Well Number-Start Test" w/ "Test Date" OR "Well Number-Start Test-No Append" w/"Test Date" on same line. Units are defined by existing Water base units for existing cases or default import convention base Water unit for new cases. Rate is Per Day.

Well Number

Used to map test data to existing wells in cases.  The Case Name of a case will be overwritten by this Well Number.

Well Number- Start Test

Used to determine correct well for importing test data into a case.  This token or the "Test Date - Start Record" token is required to successfully import new test data.  Token will also replace Case Name.

Well Num- No Append Case Name

Used to map test data to existing wells in cases.  The Case Name is left fully intact.

Well Num- Start Test- No Append

Used to determine correct well for importing test data into a case.  This token or the "Test Date - Start Record" token is required to successfully import new test data.

Bottom Hole Latitude

Bottom Hole Latitude for the current wellbore record.  The base units are degrees. Must be used with the “Well Num” import token to trigger the record.

Bottom Hole Longitude

Bottom Hole Longitude for the current wellbore record.  The base units are degrees. Must be used with the “Well Num” import token to trigger the record.

Completion API

The Completion API for the current completion record.  This must be a 14-digit API.  If less than 14 digits, then 0’s will be added to the end of the number and if more than 14 digits are input the first 14 will be truncated and only that value will be used. Must be used with the “Well Num” import token to trigger the record.

Completion Date

The completion date for the current wellbore record.  The date should be in mm/dd/yyyy format. Must be used with the “Well Num” import token to trigger the record.

Frac Proppant

The Frac Proppant for the current wellbore record.  The base units for the frac proppant is pounds (lb). Must be used with the “Well Num” import token to trigger the record.

Ground Elevation

The Ground elevation for the current wellbore record.  The base units for the ground elevation is feet (ft). Must be used with the “Well Num” import token to trigger the record.

Hole Direction

The hole direction for the current wellbore record.  Options include “Horizontal”, “Vertical” or “Directional”. Must be used with the “Well Num” import token to trigger the record.

Kelly Bushing Elevation

The Kelly Bushing (KB) elevation for the current wellbore record.  The base units are feet (ft). Must be used with the “Well Num” import token to trigger the record.

Lateral Length

The Lateral Length for the current wellbore record.  The base units are feet (ft). Must be used with the “Well Num” import token to trigger the record.

Latitude/Longitude Datum

The Latitude/Longitude Datum for the current wellbore record.  This value can be a text string or numbers or a combination of the two. Must be used with the “Well Num” import token to trigger the record.

Measured Total Depth

The Measured Total Depth (MTD) for the current wellbore record.  The base units are feet (ft). Must be used with the “Well Num” import token to trigger the record.

Measured Total Depth Datum

The Datum from which the Measured Total Depth (MTD) is measured from.  Options include “Ground Level” or “Kelly Bushing”.   Must be used with the “Well Num” import token to trigger the record.

Plug Back Measured Total Depth

The Plug Back Measured Total Depth (PBMD) for the current wellbore record.  The base units are feet (ft). Must be used with the “Well Num” import token to trigger the record.

Plug Back Measured Total Depth Datum

The Datum from which the Plug Back Measured Total Depth (PBMD) is measured from.  Options include “Ground Level” or “Kelly Bushing”.   Must be used with the “Well Num” import token to trigger the record.

Plug Back Total Vertical Depth

The Plug Back Total Vertical Depth (PBTVD) for the current wellbore record.  The base units are feet (ft). Must be used with the “Well Num” import token to trigger the record.

Plug Back Total Vertical Depth Datum

The Datum from which the Plug Back Total Vertical Depth (PBTVD) is measured from.  Options include “Ground Level” or “Kelly Bushing”.   Must be used with the “Well Num” import token to trigger the record.

Plugged Date

The Plugged date for the current wellbore record.  The date should be in mm/dd/yyyy format. Must be used with the “Well Num” import token to trigger the record.

Spud Date

The spud date for the current wellbore record.  The date should be in mm/dd/yyyy format. Must be used with the “Well Num” import token to trigger the record.

Surface Hole Latitude

Surface Hole Latitude for the current wellbore record.  The base units are degrees. Must be used with the “Well Num” import token to trigger the record.

Surface Hole Longitude

Surface Hole Longitude for the current wellbore record.  The base units are degrees. Must be used with the “Well Num” import token to trigger the record.

Total Vertical Depth

The Total Vertical Depth (TVD) for the current wellbore record.  The base units are feet (ft). Must be used with the “Well Num” import token to trigger the record.

Total Vertical Depth Datum

The Datum from which the Total Vertical Depth (TVD) is measured from.  Options include “Ground Level” or “Kelly Bushing”.   Must be used with the “Well Num” import token to trigger the record.

Tubing Diameter

The Tubing diameter for the current wellbore record.  The base units are inches. Must be used with the “Well Num” import token to trigger the record.

Well Lower Perf

Imports the lower perf of a well zone into the well description text of the Production Tests tab of the Case Editor.  Requires use of "Well Num" type token.

Well Upper Perf

Imports the upper perf of a well zone into the well description text of the Production Tests tab of the Case Editor.  Requires use of "Well Num" type token.

Wellbore API

The Wellbore API for the current completion record.  This must be a 10-digit API.  If less than 10 digits, then 0’s will be added to the end of the number and if more than 10 digits are input the first 10 will be truncated and only that value will be used. Must be used with the “Well Num” import token to trigger the record.

Wellbore Status

The Wellbore status.  Options include “Active”, “Inactive” or “P & A”.  Must be used with the “Well Num” import token to trigger the record.