Column Alias |
Definition |
ProductionDate |
PRODUCTION_DATE -The year and month of a production record for a well completion. |
PlanArea |
value_desc -A text description specifying the meaning of a code value for a list of values entry. |
CrudeOil |
This field is derived from the expression...
sum(nvl(decode(oa.product_code, 'O',oa.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.
|
Condensate |
This field is derived from the expression...
sum(nvl(decode(oa.product_code, 'G',oa.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.
|
TotalOil |
This field is derived from the expression...
sum(nvl(decode(oa.product_code, 'O',oa.mon_o_prod_vol),0)) + sum(nvl(decode(oa.product_code, 'G',oa.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.
|
NaturalGas |
This field is derived from the expression...
sum(nvl(decode(oa.product_code, 'G',oa.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.
|
CasingheadGas |
This field is derived from the expression...
sum(nvl(decode(oa.product_code, 'O',oa.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.
|
TotalGas |
This field is derived from the expression...
sum(nvl(decode(oa.product_code, 'G',oa.mon_g_prod_vol),0)) + sum(nvl(decode(oa.product_code, 'O',oa.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.
|