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 |
Current Combined PLAY_NUM, BOEM_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 |
BOEM_FIELD |
Field name |
BOEM 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 30CFR550.115, 30CFR550.116). Starting with the revised
classification system in 2009, the WLD Fields data set will no longer
be provided. In prior years, a limited dataset is presented for
the WLD fields. |
FCLASS |
Field class |
BOEM field classification. Starting with the
revised classification system in 2009, new field classes
have been added. |
FSTAT |
Field status |
Field status: Active (A), Expired (E) |
FSTRU |
Field structure code |
Field structure code; See Description File |
FTRAP1 |
Field primary trap code |
Field primary trap code; See Description File |
FTRAP2 |
Field secondary trap code |
Field secondary trap code; See Description File |
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 |
Current Play number |
PLAY_NAME |
Play name |
Play name |
POOL_NAME |
Pool name |
Current Pool name, combined PLAY_NUM and
BOEM_FIELD |
CHRONOZONE |
Chronozone |
Current Chronozone name |
PLAY_TYPE |
Play type |
Current Type of play |
P_J |
Proved or Justified for Development |
Proved (P), Reserves Justified for Development (J). Starting with the revised
classification system in 2009, Unproved (U) is no longer used. |
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) |
J_RECOIL |
Justified for Development recoverable oil |
Reserves Justified for Development recoverable oil (bbl); Starting
with the revised classification system in 2009, Unproved (U) is no longer used. |
J_RECGAS |
Justified for Development recoverable gas |
Reserves Justified for Development recoverable gas (Mcf); Starting
with the revised classification system in 2009, Unproved (U) is no longer used. |
J_RECBOE |
Justified for Development recoverable BOE |
Reserves Justified for Development recoverable BOE (bbl); Starting
with the revised classification system in 2009, Unproved (U) is no longer used. |
DISCOIL |
Discovered oil |
Discovered oil (bbl) derived from
[P_RECOIL+J_RECOIL] |
DISCGAS |
Discovered gas |
Discovered gas (Mcf) derived from
[P_RECGAS+J_RECGAS] |
DISCBOE |
Discovered BOE |
Discovered BOE (bbl) derived from
[P_RECBOE+J_RECBOE] |
SS |
Subsea depth |
True Vertical Depth Subsea(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; See Description File |
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 |
BHCOMP |
Count of total completions in the sand |
Count of wells, completed in the sand. Sums the number
of wells that have completions in each sand. If a sand has zero in the
BHCOMP column, this indicates a well(s) penetrated the sand but as of
12/31/2011 the well had not been completed; or it indicates that a sand
has been commingled with another sand(s) and the well summary is associated
with the other sand. |