Alaska Oil and Gas Conservation Commission

AOGCC_DataExtract.mdb 

Table Description

April 8, 2014 

tblAltWellNames Contains well name changes.

Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. WellName Text 83 Current well lease/unit name and number. Prev_WellName Text 20 Previous well lease/unit name and number. Cmmnt Memo - Comment. 

tblAltWellOpers Contains recent well operator changes. Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. PermitNumber Text 11 Seven char AOGCC well permit number. WellName Text 83 Well lease/unit name and number. OpNo Double 8 Current six digit operator code. Prev_OpNo Double 8 Previous six digit operator code. Prev_OpName Text 50 Previous operator name. tblBH_LatLong Contains bottom hole location latitude and longitude information.Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. PtTyp Text 4 N/A. AOGCC Use Only. BH_Lat Double 8 Reported BH Latitude in decimal degrees. BH_Long Double 8 Reported BH Longitude in decimal degrees. BH_Calc_Lat Double 8 Calculated BH Latitude in decimal degrees. BH_Calc_Long Double 8 Calculated BH Longitude in decimal degrees. tblCoreSampSets Contains sample set data for wells.

Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. SampleSetNumber Text 14 Four digit number assigned to sample set. May have TypeOfMaterial Text 50 Description of material in set, or note about locatTop Long Integer 4 Top of sample set interval, in feet. Bot Long Integer 4 Bottom of sample set interval, in feet. 
tblFacDisp_Alt Contains Gas Disposition data for production facilities.

Note: Before 1995, historical data were reported differently. A separate 

undertaken to calculate, format and load the pre-1995 data.Field Name Type Size Description DispKey Long Integer 4 Unique record identifier. RptDate Date/Time 8 Start Date for facility disposition record. SubmitNumber Text 14 Ten char production facility numeric id. FacilityNo Text 14 Two char master production facility numeric id (AOGFieldPool Long Integer 4 Six digit field and pool code. OPNO Double 8 Six digit operator code. DisSold Long Integer 4 Gas Sold, volume(MCF). DisReinject Long Integer 4 Gas Reinjected, volume(MCF). FlareGTR Long Integer 4 Gas Flared/Vented, Duration > 1 Hour, volume (MCF). FlareLT Long Integer 4 Gas Flared/Vented, Duration <= 1 Hour, volume (MCF)PilotPurge Long Integer 4 Gas Pilot/Purge, volume in MCF. AssistGas Long Integer 4 Gas Assist, volume in MCF. Used Long Integer 4 Gas Used for Lease Operations, volume (MCF). DOther Long Integer 4 Other, volume (MCF). TrFrom Long Integer 4 Gas Transferred From another facility, volume (MCF)TrTo Long Integer 4 Gas Transferred To another facility, volume (MCF). NGLeq Long Integer 4 NGL Gas Equivalents produced, volume (MCF). PurchGas Long Integer 4 Gas Purchased, volume (MCF). AmndRpt Yes/No 1 Amended Report, Y/N. Cmmnt Memo - Comment Dt_Mod Date/Time 8 Date Record Last Modified 

tblInjStorage Contains records of monthly Injection Storage volumes.Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. Rpt_Date Date/Time 8 Start date for inj storage record. PoolNo Long Integer 4 Six digit field & pool code. TypeWell Text 3 One char code. 4 = Injection. Method Text 3 One char code. 5 = Gas Storage; 8 = ShutIn; 9 = LiqInj_Days Integer 2 Two digits. Number of days injecting. Vol_Liq Long Integer 4 Liq vol (BBLS) injected. Vol_Gas Long Integer 4 Gas vol (MCF) injected. OpNo Double 8 Six digit operator code. Dt_Mod Date/Time 8 Date record modified. tblProdFacPool Contains records of monthly NGL production volumes.Field Name Type Size Description RptDate Date/Time 8 Start date for prod record. FacilityNo Text 14 Two char Master prod facility numeric id (AOGCC use 
FieldPool Long Integer 4 Six digit field & pool code. 

SubmitNumber Text 14 Ten char prod facility numeric id. OPNO Double 8 Six digit operator code. ProdType Text 1 One char code. 3 = NGLs. MethodOper Text 8 One char code. 8 = ShutIn; 9 = Producing NGLs. ProdDays Long Integer 4 Two digits. Number of days producing. NGLeq Long Integer 4 NGL volume produced for the month. AmndRpt Yes/No 1 Amended report? Cmmnt Memo - Comments. Dt_Mod Date/Time 8 Date record last modified. tblProdStorage Contains records of monthly Production from Storage volumes. Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. ReportDate Date/Time 8 Start date for prod storage record. FieldPoolCode Long Integer 4 Six digit field & pool code. OPNO Double 8 Six digit operator code. WellType Text 1 One char code. 1 = Oil or Water Producer; 2 = Gas PMethodOper Text 8 One char code. 1 = Flowing; 2 = Gas lift; 3 = Rod p

 pump; 5 = Electric submersible pump; 8 = ShutIn. 

ProdOil Long Integer 4 Oil vol (BBLS) produced. ProdGas Long Integer 4 Gas vol (MCF) produced. ProdWater Long Integer 4 Water vol (BBLS) produced. ProdDays Long Integer 4 Two digits. Number of days producing. TbgPSI Integer 2 Avg Tubing pressure in psig. CsgPSI Integer 2 Avg Casing pressure in psig. DateMod Date/Time 8 Date record last modified. tblRefCodes Converts various codes to definitions.Field Name Type Size Description Fld Text 10 Data field name. Code Text 50 Data code. Definition Text 75 Defines code. (April 2014: increased from 50) DateMod Date/Time 8 Date record last modified. tblRefCodes_Add Converts various codes to definitions.Field Name Type Size Description Fld Text 20 Data field name. Code Text 50 Data code. Definition Text 50 Defines code. TableRef1 Text 50 Associated table 1. TableRef2 Text 50 Associated table 2. 
tblRefCompany Converts Operator codes to names.

Field Name Type Size Description CoNo Double 8 Six digit operator code. CoName Text 50 Operator name. tblRefGeoFields Converts oil & gas Field codes to names.Field Name Type Size Description FieldNumber Long Integer 4 Three digit field code. FieldName Text 50 Field name. tblRefGeoPool Converts Field & Pool codes to names. Field Name Type Size Description FieldPoolCode Long Integer 4 Six digit field & pool code. PoolName Text 30 Field and pool name. tblWellFieldPool Contains Pool code(s) for each well.Field Name Type Size DescriptionAPI_WellNo Text 14 Fourteen char well identifier. FieldPoolCode Long Integer 4 Six digit field & pool code. tblWellHistory Contains history of work done, other events.Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. TypeWork Text 50 Description of work done. DateWork Date/Time 8 Date effective. tblWellHistoryExpanded Contains history of work done, other events for NONCONFIDENTIAL wells onField Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. WellConfidential Text 50 Confidential status of well (set to “No” = non-confTypeWork Text 50 Description of work done. DateWork Date/Time 8 Date effective. TypeForm Text 5 Type of form submitted. SundryNo Text 10 Six digit ID number for sundry approval and subsequComments Memo Description of work or document. tblWellLeases Contains Lease Number(s) for each well.Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. WellLeaseNo Text 10 Ten char lease number. 
tblWellMaster Contains header data for each well.

Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. PermitNumber Text 11 Seven char AOGCC well permit number. OpNo Double 8 Six digit operator code. WellName Text 50 Well lease or unit name. WellNumber Text 12 Well number. WellUnit Text 10 Five char unit code. CurrentClass Text 6 Class subsequent to completion. DEV, EXP, SER, STR,  tblRefCodes, Wl_Class for code definitions. CurrentStatus Text 6 Status subsequent to completion. See tblRefCodes,  definitions. CurrentDateStatus Date/Time 8 Date well status changed subsequent to completion. PermitClass Text 6 Class proposed on drilling permit. PermitStatus Text 6 Status proposed on drilling permit. CompClass Text 6 Class at completion. CompStatus Text 6 Status at completion. DTD Long Integer 4 Max depth of the well bore in feet. TVD Long Integer 4 Max depth of the well(in feet)measured vertically fSales_Cd Integer 2 Two digit code used with Actg_Grp to sort wells by Actg_Grp Integer 2 Three digit code used with Sales Cd. Mult_Latrl Yes/No 1 N/A. CompNum Long Integer 4 One digit. Number of mechanical completions that a pools to produce and inject separately from the othField_No Long Integer 4 Three digit field code. Wh_GeoArea Text 4 Three char geologic area code. See tblRefCodes, Geo definitions. Wh_Lat Double 8 Wellhead latitude in decimal degrees. Wh_Long Double 8 Wellhead longitude in decimal degrees. Wh_FtNS Long Integer 4 Wellhead distance in feet from North or South sec lWh_Ns Text 1 Sec line Wh_FTNS measured from (N/S). Wh_FtEW Long Integer 4 Wellhead distance in feet from East or West sec linWh_EW Text 1 Sec line Wh_FTEW measured from (E/W). Wh_Sec Integer 2 Wellhead section number. Wh_Twpn Single 4 Wellhead township number. Wh_Twpd Text 1 Wellhead township direction (N/S). Wh_RngN Single 4 Wellhead range number. Wh_RngD Text 1 Wellhead range direction (E/W). Wh_Pm Text 3 Wellhead meridian. C = Copper River, F = Fairbanks,  K = Kateel, S = Seward, U = Umiat. Wh_OnOffShore Yes/No 1 Well surface onshore(0) or offshore(-1). Elev_Gr Double 8 Distance in feet from Ground to MSL. Elev_KB Double 8 Dist in feet from Kelly bushing to MSL. 
Elev_DF Double 8 Dist in feet from Derrick floor to MSL. 

Elev_RT Double 8 Dist in feet from Rotary table to MSL. Elev_CF Double 8 Dist in feet from Casing flange to MSL. Elev_OF Double 8 Dist in feet from Ocean floor to MSL. Elev_CB Double 8 Dist in feet from Centl. Braden. to MSL. WtrDepth Double 8 Depth of water in feet for offshore surface locatioBH_FtNS Long Integer 4 Bottomhole distance in feet from North or South sec BH_NS Text 1 Sec line BH_FTNS measured from (N/S). BH_FtEW Long Integer 4 Bottomhole distance in feet from East or West sec lBH_EW Text 1 Sec line BH_FTEW measured from (E/W). BH_Sec Integer 2 Bottomhole section number. BH_Twpn Single 4 Bottomhole township number. BH_Twpd Text 1 Bottomhole township direction (N/S). BH_RngN Single 4 Bottomhole range number. BH_RngD Text 1 Bottomhole range direction (E/W). BH_PM Text 3 Bottomhole meridian. C = Copper River, F = Fairbank K = Kateel, S = Seward, U = Umiat. Dt_Mod Date/Time 8 Date record last modified. tblWellPoolInjection Contains records of monthly Enhanced Recovery and Disposal injection volumeField Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. ReportDate Date/Time 8 Start date for injection record. FieldPoolCode Long Integer 4 Six digit field & pool code. OpNo Double 8 Six digit operator code. WellType Text 3 One char code. 4 = Enhanced Recovery; 5 = Disposal. MethodOper Text 3 One char code. 0 = Miscible (WAG) Injection; 6 = Wa

 7 = Gas Injection; 8 = ShutIn; 9 = Disposal Injecti

Inj_Days Integer 2 Two digits. Number of days injecting. Vol_Liq Long Integer 4 Liq vol (BBLS) injected. Vol_Gas Long Integer 4 Gas vol (MCF) injected. Prs_Tbg_Mx Integer 2 Max Tubing pressure in psig. DateMod Date/Time 8 Date record last modified. tblWellPoolProduction Contains records of monthly Production volumes. Field Name Type Size Description API_WellNo Text 14 Fourteen char well identifier. ReportDate Date/Time 8 Start date for production record. FieldPoolCode Long Integer 4 Six digit field & pool code. OPNO Double 8 Six digit operator code. WellType Text 1 One char code. 1 = Oil or Water Producer; 2 = Gas PMethodOper Text 8 One char code. 1 = Flowing; 2 = Gas lift; 3 = Rod p
 pump; 5 = Electric submersible pump; 8 = ShutIn. 

ProdOil Long Integer 4 Oil vol (BBLS) produced. ProdGas Long Integer 4 Gas vol (MCF) produced. ProdWater Long Integer 4 Water vol (BBLS) produced. ProdDays Long Integer 4 Two digits. Number of days producing. TbgPSI Integer 2 Avg Tubing pressure in psig. CsgPSI Integer 2 Avg Casing pressure in psig. DateMod Date/Time 8 Date record last modified. 

tblPoolPressures Contains records of pool pressures. NEW tableField Name Type Alias Text APINumber Text Method Text Pool Double Zone Text TopBottomTVDSS Memo FinalTestDate Date ShutInTime Double PressSurvType Text BHTemp Double DepthToolTVD Double FinalObservedPressure Double DatumTVDss Double PressureGradient Double Press Double Well Text Comments Memo Autokey AutoNumber