Data Center

Data Center >>
Field Definitions for PACIFIC RANK OPERATOR BY OIL

Field Definitions for PACIFIC RANK OPERATOR BY OIL

Click on hyperlinked Column Aliases to show possible values.

The Start Position Column is used for fixed dumps only. Click on the column alias for a valid list of values or codes associated with the element selected.

Start
Position
Item
Length
Column
Alias
Definition
1 5 Operator Number OPERATOR_NUM -The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information.
6 100 Bus Asc Name BUS_ASC_NAME -The name of a **business associate**.
106 16 Casing Head Gas This field is derived from the expression... SUM( DECODE( OGOR.PRODUCT_CODE ,'O' , OGOR.MON_G_PROD_VOL ,0 ) ) ...and consists of these database columns:
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_G_PROD_VOL - The monthly quantity of gas produced from a completion.
122 16 Gas This field is derived from the expression... SUM( DECODE( OGOR.PRODUCT_CODE ,'G' , OGOR.MON_G_PROD_VOL ,0) ) ...and consists of these database columns:
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_G_PROD_VOL - The monthly quantity of gas produced from a completion.
138 16 TOTAL GAS This field is derived from the expression... SUM( DECODE( OGOR.PRODUCT_CODE ,'O' , OGOR.MON_G_PROD_VOL , 0 ) ) + SUM( DECODE( OGOR.PRODUCT_CODE ,'G' , OGOR.MON_G_PROD_VOL ,0 ) ) ...and consists of these database columns:
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_G_PROD_VOL - The monthly quantity of gas produced from a completion.
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_G_PROD_VOL - The monthly quantity of gas produced from a completion.
154 16 Condensate This field is derived from the expression... SUM( DECODE( OGOR.PRODUCT_CODE ,'G' , OGOR.MON_O_PROD_VOL , 0 ) ) ...and consists of these database columns:
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_O_PROD_VOL - The monthly quantity of oil produced from a completion.
170 16 Crude Oil This field is derived from the expression... SUM( DECODE( OGOR.PRODUCT_CODE ,'O' , OGOR.MON_O_PROD_VOL , 0)) ...and consists of these database columns:
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_O_PROD_VOL - The monthly quantity of oil produced from a completion.
186 16 TOTAL OIL This field is derived from the expression... SUM( DECODE( OGOR.PRODUCT_CODE ,'G' , OGOR.MON_O_PROD_VOL ,0) ) +SUM( DECODE( OGOR.PRODUCT_CODE ,'O' , OGOR.MON_O_PROD_VOL , 0)) ...and consists of these database columns:
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_O_PROD_VOL - The monthly quantity of oil produced from a completion.
PRODUCT_CODE - Indicates the primary commodity or product produced by a completion, well, lease or unit.
MON_O_PROD_VOL - The monthly quantity of oil produced from a completion.