WVGES

Oil-Gas Table Descriptions


Dividing Line

Owner/Completion

Field Name Description Column Type
API API Number NUMBER
Suffix Episode Of Drilling VARCHAR2(14)
Cmp_Dt Completion Date DATE(mm/dd/yyyy)
Status Status Of The Permit To Drill The Well CHAR(9)
Farm Farm Name (Name Of The Surface Owner) VARCHAR2(30)
Well_Num Well Number On The Farm VARCHAR2(6)
Co_Num Company Number (Operator's Number For The Well) VARCHAR2(15)
Lease Lease Name VARCHAR2(30)
Lease_Num Lease Number VARCHAR2(6)
Mineral_Own Mineral Owner (Name Of The Owner Of The Oil And Gas Rights) VARCHAR2(24)
Operator Operator Name VARCHAR2(15)
Spud_Dt Spud Date (Date Drilling Began) DATE(mm/dd/yyyy)
Elev Elevation, Feet (Surface Of The Well) NUMBER(4)
Datum Elevation Datum VARCHAR2(15)
Field Field Name VARCHAR2(15)
Deepest_Fm Formation At Total Depth VARCHAR2(20)
Deepest_FmT Deepest Formation Tested VARCHAR2(20)
Initial_Class Initial Well Classification (AAPG Well Classification) VARCHAR2(24)
Final_Class Final Well Classification (AAPG Well Classification) VARCHAR2(24)
Type Well Type VARCHAR2(15)
Rig Rig Type VARCHAR2(10)
Cmp_Mthd Completion Method VARCHAR2(10)
TD Total Depth, Feet (From The Surface Datum To The Bottom Of The Well) NUMBER(5)
New_Ftg New Footage, Feet (Footage Drilled During This Episode) NUMBER(5)
Volumes
G_Bef    Gas Before Treatment or Natural Open Flow, Thousand Cubic Feet (MCF) / Day NUMBER(6)
G_Aft    Gas After Treatment, Thousand Cubic Feet (MCF) / Day NUMBER(6)
O_Bef    Oil Before Treatment or Natural Open Flow, Barrels / Day (1 Barrel = 42 gallons) NUMBER(4)
O_Aft    Oil After Treatment, Barrels / Day (1 Barrel = 42 gallons) NUMBER(4)
Rock Pressure
P_Bef    Rock Pressure Before Treatment / Stimulation or Natural Rock Pressure, Pounds Per Square Inch NUMBER(4)
Ti_Bef    Shut-In Time Before Treatment / Stimulation, Hours NUMBER(4)
P_Aft    Rock Pressure After Treatment / Stimulation or Treated Rock Pressure, Pounds Per Square Inch NUMBER(4)
Ti_Aft    Shut-In Time After Treatment / Stimulation, Hours NUMBER(4)
Comment Comment VARCHAR2(40)

Dividing Line

WVGES Main   "Pipeline"   Table Descriptions  


Page Last Revised:   Friday, January 18, 2008 11:59:16 AM

Please send questions, comments, and/or suggestions to webmaster.

Page created and maintained by:
            West Virginia Geological and Economic Survey
  Address:  Mont Chateau Research Center
            1 Mont Chateau Road
            Morgantown, WV  26508-8079
Telephone:  1-800-WV-GEOLOgy (1-800-984-3656) or 304-594-2331
      FAX:  304-594-2575
    Hours:  8:00 a.m. - 5:00 p.m. EST, Monday - Friday

Permission to reproduce this material is granted if acknowledgment is given to the West Virginia Geological and Economic Survey.

Valid XHTML 1.0!