Original Query Result 123 A 1-Jan-80 1-May-00 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 FALSE FALSE PRODUCTION Production ft GAS Gas ft PRODUCING Producing FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 US United States 3.50074E+13 123 A 1-May-00 10-Nov-11 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 TRUE FALSE PRODUCTION Production ft GAS Gas ft PRODUCING Producing FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 US United States 3.50074E+13 123 A 10-Nov-11 25-Jan-12 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 TRUE FALSE PRODUCTION Production ft GAS Gas ft SHUT_IN Shut In FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 US United States 3.50074E+13 123 A 25-Jan-12 1-Jan-00 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 TRUE FALSE PRODUCTION Production ft GAS Gas ft PRODUCING Producing FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 US United States 3.50074E+13 Modified Query Result 123 A 1-Jan-80 1-May-00 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None Federal Lease 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 FALSE FALSE PRODUCTION Production ft GAS Gas ft PRODUCING Producing FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 None US United States None 3.50074E+13 123 A 1-May-00 10-Nov-11 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None Federal Lease 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 TRUE FALSE PRODUCTION Production ft GAS Gas ft PRODUCING Producing FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 None US United States None 3.50074E+13 123 A 10-Nov-11 25-Jan-12 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None Federal Lease 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 TRUE FALSE PRODUCTION Production ft GAS Gas ft SHUT_IN Shut In FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 None US United States None 3.50074E+13 123 A 25-Jan-12 1-Jan-00 TRUE 1 B 35 35007 C D E F 35 Oklahoma 8289-1 35007 Beaver 3.50074E+13 72016901 NONE None Federal Lease 1300201 NONE None FALSE 23500105465 NONE None 35007353161 35007353161 TRUE FALSE PRODUCTION Production ft GAS Gas ft PRODUCING Producing FLOWING Flowing B P N NAD 27 CONUS LEGACY Legacy 191643200 36.66866 -100.31857 TPRD-624705 bbl/d hp ft SpGrvG dAPI dAPI 1000ft3/bbl bbl/k(ft3) bbl/k(ft3) bbl/bbl Btu/ft3 None US United States None 3.50074E+13 ITEM_PROPERTY table for ITEM_ID = 123 123 COMPLETION 1-Jan-00 1-May-00 OPERATED FALSE 123 COMPLETION 1-Jan-00 10-Nov-11 STATUS PRODUCING 123 COMPLETION 10-Nov-11 25-Jan-12 STATUS SHUT_IN 123 COMPLETION 1-Jan-00 1-Oct-13 DATA_STATUS LEGACY 123 COMPLETION 1-Oct-13 1-Nov-13 DATA_STATUS VERIFIED 123 COMPLETION 1-Jan-00 1-Jan-00 LATITUDE 1 123 COMPLETION 1-Jan-00 1-Jan-00 LONGITUDE 2 123 COMPLETION 1-Jan-00 1-Jan-00 ACTIVE TRUE 123 COMPLETION 1-Jan-00 1-Jan-00 NAME A 123 COMPLETION 1-Jan-00 1-Jan-00 SHORT_NAME C 123 COMPLETION 1-Jan-00 1-Jan-00 ACC_ID 8289-1 123 COMPLETION 1-Jan-00 1-Jan-00 FDC_ID P 123 COMPLETION 1-Jan-00 1-Jan-00 LEGACY_ID TPRD-624705 123 COMPLETION 1-Jan-00 1-Jan-00 DATUM NAD 27 CONUS 123 COMPLETION 1-Jan-00 1-Jan-00 ACQUISITION_CD D 123 COMPLETION 1-Jan-00 1-Jan-00 LEGAL_NAME F 123 COMPLETION 1-Jan-00 1-Jan-00 OFFSHORE FALSE 123 COMPLETION 1-Jan-00 1-Jan-00 LEGACY_UNIQUEID 35007353161 123 COMPLETION 1-Jan-00 1-Jan-00 ARIES_ROLLUP_ID 35007353161 123 COMPLETION 1-Jan-00 1-Jan-00 HORIZONTAL FALSE 123 COMPLETION 1-Jan-00 1-Jan-00 ARIES_PROPNUM B2EBS6OC00 123 COMPLETION 1-Jan-00 1-Jan-00 STATE_CODE 35 123 COMPLETION 1-Jan-00 1-Jan-00 LEGAL_OPERATOR 1 123 COMPLETION 1-Jan-00 1-Jan-00 COUNTRY US 123 COMPLETION 1-Jan-00 1-Jan-00 COUNTY_CODE 35007 123 COMPLETION 1-Jan-00 1-Jan-00 STATE 35 123 COMPLETION 1-Jan-00 1-Jan-00 REG_ID 3.50074E+13 123 COMPLETION 1-Jan-00 1-Jan-00 COUNTY 35007 123 COMPLETION 1-Jan-00 1-Jan-00 MMS_CODE 72016901 123 COMPLETION 1-Jan-00 1-Jan-00 OIL_THEOR_M NONE 123 COMPLETION 1-Jan-00 1-Jan-00 PROPERTY_NO 1300201 123 COMPLETION 1-Jan-00 1-Jan-00 GAS_THEOR_M NONE 123 COMPLETION 1-Jan-00 1-Jan-00 WATER_THEOR_M NONE 123 COMPLETION 1-Jan-00 1-Jan-00 DWIGHTS_IHS_ID 23500105465 123 COMPLETION 1-Jan-00 1-Jan-00 TYPE PRODUCTION 123 COMPLETION 1-Jan-00 1-Jan-00 LIFT_TYPE FLOWING 123 COMPLETION 1-Jan-00 1-Jan-00 API 3.50074E+13 123 COMPLETION 1-Jan-00 1-Jan-00 PRODUCT GAS 123 COMPLETION 1-Jan-00 1-Jan-00 LEASE 191643200 123 COMPLETION 1-May-00 1-Jan-00 OPERATED TRUE 123 COMPLETION 25-Jan-12 1-Jan-00 STATUS PRODUCING 123 COMPLETION 1-Nov-13 1-Jan-00 DATA_STATUS RAW CODE_LIST Table for MMS MMS_TYPE en-US 1 Federal Lease MMS_TYPE en-US 2 Indian Lease MMS_TYPE en-US 3 State Lease MMS_TYPE en-US 4 MMS OGOR Onshore