|
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. |
|
OLD_SAND_NAME |
Sand name |
Old Combined PLAY_NUM, MMS_FIELD, and SAND
(unique) from pre-2003 biostrat chart |
|
SAND_NAME |
Sand name |
Current 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 -WLD in the field name indicates
that a preliminary field determination has been made (the
lease(s) have not been through the official well producibility
determination process 30CFR250.115, 30CFR250.116). A
limited dataset is presented for the WLD fields. |
|
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) |
|
OLD_PLAY_NUM |
Play number |
Old Play number from pre-2003 biostrat chart |
|
PLAY_NUM |
Play number |
Current Play number |
|
OLD_PLAY_NAME |
Play name |
Old Play name from pre-2003 biostrat chart |
|
PLAY_NAME |
Play name |
Play name |
|
OLD_POOL_NAME |
Pool name |
Old Pool name, combined PLAY_NUM and MMS_FIELD
from pre-2003 biostrat chart |
|
POOL_NAME |
Pool name |
Current Pool name, combined PLAY_NUM and
MMS_FIELD |
|
OLD_CHRONOZONE |
Chronozone |
Old Chronozone name from pre-2003 biostrat chart |
|
CHRONOZONE |
Chronozone |
Current Chronozone name |
|
OLD_PLAY_TYPE |
Play type |
Old Type of play from pre-2003 biostrat chart |
|
PLAY_TYPE |
Play type |
Current 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) |
|
P_CUMOIL |
Cumulative oil produced |
Cumulative oil produced (bbl) |
|
P_CUMGAS |
Cumulative gas produced |
Cumulative gas produced (Mcf) |
|
P_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 |
|
PERMEABILITY |
Permeability |
Average permeability |
|
PI |
Initial pressure |
Initial pressure (psi) |
|
TI |
Initial temperature |
Initial temperature (degrees F) |
|
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 |
