Search This Blog

Thursday, 2 January 2014

Dissecting PPDM Well Table

PPDM Well  table  has general and header information about a well.  Below is a simplified version of data organization within this table. The data is classified in to What, Where and How of the well.

Well Identifiers

  • [UWI]
  • [WELL_NAME]
  • [WELL_NUM]
  • [WELL_NUMERIC_ID]
  • [LEASE_NAME]
  • [LEASE_NUM]
  • [OPERATOR]
  • [WELL_GOVERNMENT_ID]

Offshore Well

  • [SUBSEA_ELEV_REF_TYPE]
  • [WATER_ACOUSTIC_VEL]
  • [WATER_ACOUSTIC_VEL_OUOM]
  • [WATER_DEPTH]
  • [WATER_DEPTH_DATUM]
  • [WATER_DEPTH_OUOM]

Tight Well

  • [CONFIDENTIAL_DATE]
  • [CONFIDENTIAL_DEPTH]
  • [CONFIDENTIAL_DEPTH_OUOM]
  • [CONFIDENTIAL_TYPE]
  • [CONFID_STRAT_NAME_SET_ID]
  • [CONFID_STRAT_UNIT_ID]

Additional Well Details

  • [INITIAL_CLASS]
  • [CURRENT_CLASS
  • [PROFILE_TYPE]
  • [WELL_LEVEL_TYPE]
  • [ENVIRONMENT_TYPE]
  • [CURRENT_STATUS]
  • [CURRENT_STATUS_DATE]
  • [STATUS_TYPE]
  • [DISCOVERY_IND]
  • [FAULTED_IND]
  • [PLATFORM_ID]
  • [PLATFORM_SF_TYPE]

Symbology

  • [PLOT_NAME]
  • [PLOT_SYMBOL]

Location Data

  • [SURFACE_LATITUDE]
  • [SURFACE_LONGITUDE]
  • [BOTTOM_HOLE_LATITUDE]
  • [BOTTOM_HOLE_LONGITUDE]
  • [GEOGRAPHIC_REGION]
  • [GEOLOGIC_PROVINCE]
  • [ASSIGNED_FIELD]
  • [COUNTY]
  • [DISTRICT]
  • [PROVINCE_STATE]
  • [COUNTRY]

Elevation Data

  • [ELEV_REF_DATUM]
  • [DERRICK_FLOOR_ELEV]
  • [DERRICK_FLOOR_ELEV_OUOM]
  • [ROTARY_TABLE_ELEV]
  • [ROTARY_TABLE_ELEV_OUOM]
  • [KB_ELEV]
  • [KB_ELEV_OUOM]
  • [CASING_FLANGE_ELEV]
  • [CASING_FLANGE_ELEV_OUOM]
  • [GROUND_ELEV]
  • [GROUND_ELEV_OUOM]
  • [GROUND_ELEV_TYPE]

Depth Data

  • [DEPTH_DATUM]
  • [DEPTH_DATUM_ELEV]
  • [DEPTH_DATUM_ELEV_OUOM]
  • [DRILL_TD]
  • [DRILL_TD_OUOM]
  • [LOG_TD]
  • [LOG_TD_OUOM]
  • [FINAL_TD]
  • [FINAL_TD_OUOM]
  • [MAX_TVD]
  • [MAX_TVD_OUOM]
  • [WHIPSTOCK_DEPTH]
  • [WHIPSTOCK_DEPTH_OUOM]
  • [PLUGBACK_DEPTH]
  • [PLUGBACK_DEPTH_OUOM]

Strat Data

  • [OLDEST_STRAT_AGE]
  • [OLDEST_STRAT_NAME_SET_AGE]
  • [OLDEST_STRAT_NAME_SET_ID]
  • [OLDEST_STRAT_UNIT_ID]
  • [TD_STRAT_AGE]
  • [TD_STRAT_NAME_SET_AGE]
  • [TD_STRAT_NAME_SET_ID]
  • [TD_STRAT_UNIT_ID]

Well Events

  • [RIG_ON_SITE_DATE]
  • [SPUD_DATE]
  • [RIG_RELEASE_DATE]
  • [FINAL_DRILL_DATE]
  • [COMPLETION_DATE]
  • [ABANDONMENT_DATE]

Add-on Data

  • [NET_PAY]
  • [NET_PAY_OUOM]
  • [TAX_CREDIT_CODE]
  • [REMARK]
  • [SOURCE_DOCUMENT]

Audit Data / Meta Data

  • [EFFECTIVE_DATE]
  • [ACTIVE_IND]
  • [EXPIRY_DATE]
  • [PRIMARY_SOURCE]
  • [ROW_CHANGED_BY]
  • [ROW_CHANGED_DATE]
  • [ROW_CREATED_BY]
  • [ROW_CREATED_DATE]
  • [ROW_QUALITY]