Alaska Oil and Gas Conservation CommissionAOGCC_DataExtract.mdbTable DescriptionApril 8, 2014**tblAltWellNames**Contains well name changes.Field Name Type Size DescriptionAPI_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 DescriptionAPI_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 DescriptionAPI_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 DescriptionAPI_WellNo Text 14 Fourteen char well identifier.SampleSetNumber Text 14 Four digit number assigned to sample set. May have alpha suffix.TypeOfMaterial Text 50 Description of material in set, or note about location.Top 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:**Before1995, historical data were reported differently. A separate project will beundertaken to calculate, format and load the pre-1995 data.Field Name Type Size DescriptionDispKey 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 (AOGCC use only).FieldPool 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 - CommentDt_Mod Date/Time 8 Date Record Last Modified**tblInjStorage**Contains records of monthly Injection Storage volumes.Field Name Type Size DescriptionAPI_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 = Liquid Storage.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.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 DescriptionRptDate Date/Time 8 Start date for prod record.FacilityNo Text 14 Two char Master prod facility numeric id (AOGCC use only).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 DescriptionAPI_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 Producer.MethodOper Text 8 One char code. 1 = Flowing; 2 = Gas lift; 3 = Rod pump; 4 = Hydraulicpump; 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 DescriptionFld 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 DescriptionFld 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 DescriptionCoNo Double 8 Six digit operator code.CoName Text 50 Operator name.**tblRefGeoFields**Converts oil & gas Field codes to names.Field Name Type Size DescriptionFieldNumber Long Integer 4 Three digit field code.FieldName Text 50 Field name.**tblRefGeoPool**Converts Field & Pool codes to names.Field Name Type Size DescriptionFieldPoolCode 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 DescriptionAPI_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 only.Field Name Type Size DescriptionAPI_WellNo Text 14 Fourteen char well identifier.WellConfidential Text 50 Confidential status of well (set to “No” = non-confidential only).TypeWork 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 subsequent report of work.Comments Memo Description of work or document.**tblWellLeases**Contains Lease Number(s) for each well.Field Name Type Size DescriptionAPI_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 DescriptionAPI_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, or UN. SeetblRefCodes, Wl_Class for code definitions.CurrentStatus Text 6 Status subsequent to completion. See tblRefCodes, Wl_Status for codedefinitions.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 from bottom to surf.Sales_Cd Integer 2 Two digit code used with Actg_Grp to sort wells by pad or platform.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 allow one or morepools to produce and inject separately from the other(s).Field_No Long Integer 4 Three digit field code.Wh_GeoArea Text 4 Three char geologic area code. See tblRefCodes, GeoArea, for codedefinitions.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 line.Wh_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 line.Wh_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 location.BH_FtNS Long Integer 4 Bottomhole distance in feet from North or South sec line.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 line.BH_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 = Fairbanks,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 volumes.Field Name Type Size DescriptionAPI_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 = Water Injection;7 = Gas Injection; 8 = ShutIn; 9 = Disposal Injection.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 DescriptionAPI_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 Producer.MethodOper Text 8 One char code. 1 = Flowing; 2 = Gas lift; 3 = Rod pump; 4 = Hydraulicpump; 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 TypeAlias TextAPINumber TextMethod TextPool DoubleZone TextTopBottomTVDSS MemoFinalTestDate DateShutInTime DoublePressSurvType TextBHTemp DoubleDepthToolTVD DoubleFinalObservedPressure DoubleDatumTVDss DoublePressureGradient DoublePress DoubleWell TextComments MemoAutokey AutoNumber