Summary File for 2001sands

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