Field Type
| Field Length
| Column Name
| Definition |
Char |
12 |
OGOR Document Num |
The unique number assigned to each OGOR received by the MRM. |
Char |
11 |
Contract Number |
The number assigned to a lease or unit by the regulatory agency having jurisdiction over mineral activity in the territory where the wells are located. The OGOR requires wells be reported either on a Lease or Unit. Therefore, this file does not provide both. The MRM lease or unit number is 11 digits. To convert the MRM lease number to the OMM format, do the following:
If characters 1-3 of the MRM Contract Number are equal '054'
replace the '054' with letter G' then add to characters 5-9 of contract number; e.g., 0540011010 = G01101
If characters 1-3 of the MRM Contract Number are equal to '055';
replace '055' with a space ' ' then add to characters 5-9 of contract number; e.g., 0550008420 = (space)00842
If characters 1-3 of the MRM Contract Number are not equal to above values, the number could be a unit or could be an invalid number. |
Char |
5 |
Operator Num |
The MRM number and is converted to OMM number as follows:
If character 1 of MRM Operator Number is equal to 'F'
replace 'F' with '00' and drop the last character; e.g., F0780 = 00078
If character 1 of MRM Operator Number is equal to 'L'
replace 'L' with '01' and drop the last character; e.g., L8554 = 01855
If character 1 of MRM Operator Number is equal to 'S'
replace 'S' with '02' and drop the last character; e.g., S3160 = 02316
If character 1 of MRM Operator Number is not equal to above values then the Number is invalid. |
Date |
10 |
Production Date |
The month, last day, year of production record for a well completion. The production day is always the last day of the month; e.g., August, 2002 production date is written as "2002-08-31" |
Char |
12 |
API Well Number |
A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three-digit county code (or pseudo for Offshore), a five-digit unique well code, and if applicable, a two-digit sidetrack code as defined in API Bulletin D12A. |
Char |
1 |
Tubing String |
The alpha character which identifies the tubing string as an single, double, borehole, etc. (S, D, X, etc) |
Char |
2 |
Completion Code |
Indicates the number of producing or injection intervals of the well. |
Char |
15 |
Completion Name |
The name assigned to the completion by the lease operator. |
Char |
5 |
Well Status Code |
Indicates the physical status of a well completion during the production month. |
Num |
2 |
Days on Prod |
The number of days that a well completion produced or injected in a month. |
Num |
10 |
Monthly Oil Volume |
The monthly quantity of oil produced from a completion. |
Num |
10 |
Monthly Gas Volume |
The monthly quantity of gas produced from a completion. |
Num |
10 |
Monthly Water Volume |
The monthly quantity of water produced from a completion. |
Num |
10 |
Injection Volume |
The quantity of fluids injected under pressure into a reservoir through an injection well as part of a pressure-maintenance, secondary-recovery, or recycling operation. |