Column Alias |
Definition |
Field |
FIELD_NAME_CODE -Name of the field in which the well is located. |
Lease |
LEASE_NUMBER - The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located. |
Well |
COMPLETION_NAME - The name assigned to the completion by the lease operator. |
ApiWellNumber |
API_WELL_NUMBER - A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three digit county code (or pseudo for Offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A. |
Reservoir |
This field is derived from the expression...
NVL(M.RESERVOIR_NAME, V.COMP_RSVR_NAME)
...and consists of these database columns:
RESERVOIR_NAME - The name given to an oil or gas reservoir.
COMP_RSVR_NAME - The name given to an oil or gas reservoir as applied to the name submitted on the MMS Well Summary Form.
|
TestDate |
BHTST_DATE -The date that the identified test was run. The tests involved are: drillstem test, production, initial potential, reservoir limits, etc.\The date the bottomhole pressure test was conducted. |
SITime |
This field is derived from the expression...
DECODE( BP.BHTST_SI_TIME, '9999' , '-' ,BP.BHTST_SI_TIME)
...and consists of these database columns:
BHTST_SI_TIME - The time that the well is shut-in while conducting the bottomhole pressure test.
BHTST_SI_TIME - The time that the well is shut-in while conducting the bottomhole pressure test.
|
BHTemp |
BHTST_TEMP -The temperature of the reservoir fluids when conducting the bottomhole pressure test. |
SIPress |
BHTST_SI_PRSS -The pressure that is determined while conducting the bottomhole pressure test. |
DepthMD |
BHTST_MD -The measured depth from the rig kelly bushing to the depth where the bottomhole pressure test is conducted. |
DepthTVD |
BHTST_TVD -The true vertical depth from the surface to the depth where the bottomhole pressure test is performed. |
BHPress |
BHTST_PRESSURE -The pressure as determined by the bottomhole pressure test. |
Remarks |
REMARK -An explanation, comment, or definition associated with an individual record. |