|
Column Name |
Column Alias |
Definition |
|
SN_FORMSAND |
Sand sequence number |
Sand sequence number
- unique identifier assigned to each assessed sand (and some of the non-assessed sands) in order to enable the user to track a sand from year
to year regardless of changes (such as sand name, field, play, etc.) made
to the sand. |
|
SAND_NAME |
Sand name |
Combined PLAY_NUM,
MMS_FIELD, and SAND (unique) |
|
ASSESSED |
Assessed |
The sand was assessed
Yes (Y) or No (N) |
|
SDDATE |
Sand discovery date |
Sand discovery date
(MM/DD/YYYY) |
|
SDYEAR |
Sand discovery year |
Sand discovery year (YYYY) |
|
SDDATEH |
Sand discovery date
high |
Discovery date of
last reservoir discovered in sand (MM/DD/YYYY) |
|
SDYEAREH |
Sand discovery year
high |
Discovery year of
last reservoir discovered in sand (YYYY) |
|
WELLAPI |
Discovery well |
Discovery well API
number |
|
MMS_FIELD |
Field name |
MMS field name |
|
FCLASS |
Field class |
MMS field
classification |
|
FSTAT |
Field status |
Field status: Active
(A), Expired (E) |
|
FSTRU |
Field structure code |
Field structure code |
|
FTRAP1 |
Field primary trap
code |
Field primary trap
code |
|
FTRAP2 |
Field secondary trap
code |
Field secondary trap
code |
|
FDDATE |
Field discovery date |
Field discovery date
(MM/DD/YYYY) |
|
FDYEAR |
Field discovery year |
Field discovery year
(YYYY) |
|
EIAID |
EIA identification
number |
Energy Information
Administration field identification number |
|
PLAREA |
Planning area |
Planning area |
|
SAND |
Sand name |
Sand name (not
unique) |
|
PLAY_NUM |
Play number |
Play number |
|
PLAY_NAME |
Play name |
Play name |
|
POOL_NAME |
Pool name |
Pool name, combined
PLAY_NUM and MMS_FIELD |
|
CHRONOZONE |
Chronozone |
Chronozone name |
|
PLAY_TYPE |
Play type |
Type of play |
|
P_U |
Proved or Unproved |
Proved (P), Unproved
(U) |
|
SD_TYPE |
Sand type |
Sand type: Gas (G),
Oil (O), Combination (B) |
|
WDEP |
Water depth |
Water depth (feet) |
|
P_RECOIL |
Proved recoverable
oil |
Proved recoverable
oil (bbl) |
|
P_RECGAS |
Proved recoverable
gas |
Proved recoverable
gas (Mcf) |
|
P_RECBOE |
Proved recoverable
BOE |
Proved recoverable
BOE (bbl) |
|
CUMOIL |
Cumulative oil
produced |
Cumulative oil
produced (bbl) |
|
CUMGAS |
Cumulative gas
produced |
Cumulative gas
produced (Mcf) |
|
CUMBOE |
Cumulative BOE
produced |
Cumulative BOE
produced (bbl) |
|
P_REMOIL |
Proved remaining
recoverable oil |
Proved remaining
recoverable oil (bbl) |
|
P_REMGAS |
Proved remaining
recoverable gas |
Proved remaining
recoverable gas (Mcf) |
|
P_REMBOE |
Proved remaining
recoverable BOE |
Proved remaining
recoverable BOE (bbl) |
|
U_RECOIL |
Unproved recoverable
oil |
Unproved recoverable
oil (bbl) |
|
U_RECGAS |
Unproved recoverable
gas |
Unproved recoverable
gas (Mcf) |
|
U_RECBOE |
Unproved recoverable
BOE |
Unproved recoverable
BOE (bbl) |
|
DISCOIL |
Discovered oil |
Discovered oil (bbl)
derived from [P_RECOIL+U_RECOIL] |
|
DISCGAS |
Discovered gas |
Discovered gas (Mcf)
derived from [P_RECGAS+U_RECGAS] |
|
DISCBOE |
Discovered BOE |
Discovered BOE (bbl)
derived from [P_RECBOE+U_RECBOE] |
|
SS |
Subsea depth |
Subsea depth (feet) |
|
THK |
Total average net
thickness |
Total average net
thickness (feet) |
|
TAREA |
Total area |
Total area (acres) |
|
TVOL |
Total volume |
Total volume (acre-feet) |
|
OTHK |
Oil average net
thickness |
Oil average net
thickness (feet) |
|
OAREA |
Oil total area |
Oil total area
(acres) |
|
OVOL |
Oil total volume |
Oil total volume
(acre-feet) |
|
GTHK |
Gas average net
thickness |
Gas average net
thickness (feet) |
|
GAREA |
Gas total area |
Gas total area
(acres) |
|
GVOL |
Gas total volume |
Gas total volume
(acre-feet) |
|
DRIVE |
Drive type |
Dominant reservoir
drive type |
|
RES_TYPE |
Reservoir type |
Dominant reservoir
type: Nonassociated gas (N), Undersaturated oil (U), Saturated oil (S) |
|
POROSITY |
Porosity |
Average porosity |
|
SW |
Water saturation |
Water saturation |
|
PERMEABILI |
Permeability |
Average permeability |
|
PI |
Initial pressure |
Initial pressure (psi) |
|
TI |
Initial temperature |
Initial temperature
(degrees R) |
|
SDPG |
Sand pressure
gradient |
Sand pressure
gradient (psi per foot) |
|
SDTG |
Sand temperature
gradient |
Sand temperature
gradient (degrees F per 100 feet) |
|
RSI |
Initial solution gas-oil ratio |
Initial solution gas-oil ratio (scf/stb) |
|
YIELD |
Yield |
Yield (stb/MMcf) - gas reservoirs' recoverable condensate divided by recoverable gas |
|
PROP |
Proportion oil |
Proportion oil
(decimal) |
|
GOR |
Gas-oil ratio |
Gas-oil ratio (Mcf/bbl) |
|
SPGR |
Gas specific gravity |
Gas specific gravity
(decimal at 60 degrees F and 15.025 psia) |
|
API |
Oil API gravity |
Oil API gravity (API
units) |
|
BGI |
Initial gas formation
volume factor |
Initial gas formation
volume factor (scf/cf) |
|
BOI |
Initial oil formation
volume factor |
Initial oil formation
volume factor (bbl/stb) |
|
RECO_AF |
Recoverable oil per
acre-foot |
Recoverable oil per
acre-foot (bbl/acre-foot) |
|
RECG_AF |
Recoverable gas per
acre-foot |
Recoverable gas per
acre-foot (Mcf/acre-foot) |
|
OIP |
Oil in place |
Oil in place (bbl) |
|
GIP |
Gas in place |
Gas in place (Mcf) |
|
ORF |
Oil recovery factor |
Oil recovery factor
(decimal) |
|
ORECO |
Oil reservoirs'
recoverable oil |
Oil reservoirs'
recoverable oil (bbl) |
|
ORECG |
Oil reservoirs'
recoverable gas |
Oil reservoirs'
recoverable gas (Mcf) |
|
ORP |
Produced GOR for oil
reservoirs |
Produced GOR for oil
reservoirs (Mcf/stb) |
|
GRF |
Gas recovery factor |
Gas recovery factor
(decimal) |
|
GRECO |
Gas reservoirs'
recoverable oil |
Gas reservoirs'
recoverable oil (bbl) |
|
GRECG |
Gas reservoirs'
recoverable gas |
Gas reservoirs'
recoverable gas (Mcf) |
|
GRP |
Produced GOR for gas
reservoirs |
Produced GOR for gas
reservoirs (Mcf/stb) |
|
NCNT |
Count of
nonassociated gas reservoirs in the sand |
Count of
nonassociated gas reservoirs in the sand |
|
UCNT |
Count of
undersaturated oil reservoirs in the sand |
Count of
undersaturated oil reservoirs in the sand |
|
SCNT |
Count of saturated
oil reservoirs in the sand |
Count of saturated
oil reservoirs in the sand |
|
TRCNT |
Count of total
reservoirs in the sand |
Count of total
reservoirs in the sand |
