| Name | Well_Test_Fluid_Recovery |
|---|---|
| Entity Type | Table |
| Description | A flow amount or flow rate of an individual material recovered or injected during a well test stage. For example, if a fluid that is recovered during a well test contains oil, water, and gas, there are three well test fluid recovery records. Note that if multi-stage separation is utilized, there will be a separate record for each separator and for each type of material recovered. |
| Submodel | Well_Testing |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | Well_Test_Stage_Id , Material_Type , Utilized_Facility_Id , Existence_Kind , Version |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| API_Oil_Gravity | double | API_Oil_Gravity dAPI |
API gravity of Oil. The measure of the density of liquid petroleum products; derived from relative density in accordance with the following equation: API Gravity at 60 degrees F = [141.5 /relative density at 60 degrees F] - 131.5. API Gravity is expressed in degrees API, 10 degrees API being equivalent to 1.0, the relative density of water." | No |
NUMBER |
| Concentration | double | High_Concentration % |
The concentration of the fluid per total fluid volume. | No |
NUMBER |
| Density | double | Density g/cm3 |
The density of the material recovered during the well test/well test stage. The density of the material should be used to determine mass from the actual volume value. | No |
NUMBER |
| Energy | double | Energy keV |
The energy of the material recovered during the well test/well test stage. Note: This attribute is added to this class as a denormalization so that a fluid analysis record does not have to be created to determine this information. | No |
NUMBER |
| Existence_Kind | REF_EXISTENCE_KIND | NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| Field_Factor | double | Percent % |
The ratio of the Total Measured Volume (Total output fluid) that is recovered to the total Theoretical volume (Total Input Fluid). This value can be greater than one. It is stored only for a measurement node. It is a part of back allocation results and is stored with allocated data. FF = Total Measured Volume (Output) /Total Theoretical Volume (Input). | No |
NUMBER |
| Flow_Direction_Code | R_Flow_Direction |
|
A value that specifies whether the volume is being produced from the well or being injected into the well during the well test stage. Valid values are: In, Out. | Yes |
VARCHAR2(64) |
| Flow_Rate | double | Flowrate m3/h |
The flow rate of the material recovered during the well test/well test stage. | No |
NUMBER |
| Fluid_Level | double | Depth m |
The level of the fluid that is left in the borehole, when the fluid has not flowed to the surface. This typically occurs when a drillstem test is performed. | No |
NUMBER |
| GUID | STRING128 | NA |
Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. | No |
VARCHAR2(128) |
| Gravity | double | Dimensionless |
The ratio of the weight of a given volume of the material at a given temperature to the weight of an equal volume of a standard substance at the same temperature. In determining the specific gravity of gases, the comparison is made with the standard of air or hydrogen. | No |
NUMBER |
| Id | ID | No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Liquid_Pressure_Gradient | double | Pressure_Per_Length kPa/m |
The change in pressure in the fluid as a function of depth. | No |
NUMBER |
| Mass | double | Mass kg |
The mass of the material recovered during the well test/well test stage. Note: This attribute is added to this class as a denormalization so that a fluid analysis record does not have to be created to determine this information. | No |
NUMBER |
| Material_Disposition | R_Material_Disposition |
|
The description of how a material is used/consumed. For example, Sales, Flared, Irrigation, etc. | No |
VARCHAR2(64) |
| Material_Type | R_Production_Material |
|
The type of material that is recovered in the well test stage. For example, oil, water, gas, condensate, etc. | Yes |
VARCHAR2(64) |
| Moles | double | No_Unit |
The number of moles for the material recovered during the well test/well test stage. Note: This attribute is added to this class as a denormalization so that a fluid sample does not have to be created to determine this information. | No |
NUMBER |
| Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. name of Well, name of Field, etc. | No |
VARCHAR2(255) |
| Original_Source | STRING64 | NA |
The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" | No |
VARCHAR2(64) |
| Pressure | double | Pressure kPa |
The actual pressure of the material recovered during the well test/well test stage. | No |
NUMBER |
| Pressure_Base | double | Pressure kPa |
The pressure that represents the pressure basis in which the volume is expressed. | No |
NUMBER |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | STRING2000 | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Salinity | double | Trace_Concentration ppm |
A measurement to determine the amount of salts present in the fluid. | No |
NUMBER |
| Source | STRING64 | NA |
Name of the person or organization responsible for this entitys E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. | No |
VARCHAR2(64) |
| Steam_Quality | double | Dimensionless |
Indicates the steam quality (The mass fraction of water in the vapor phase with respect to the total mass of water in both the vapor and liquid phases) in a steam injectivity test | No |
NUMBER |
| Temperature | double | Temperature degC |
The actual temperature of the material recovered during the well test/well test stage. | No |
NUMBER |
| Temperature_Base | double | Temperature degC |
The temperature that represents the temperature basis in which the volume is expressed. | No |
NUMBER |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Utilized_Facility_Id | Activity_Facility_Invl |
|
The identifier of the facility utilized during the well test. For example, a separator can be utilized during a well test. | No |
NUMBER(38) |
| Version | STRING255 | NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Viscosity | double | Dynamic_Viscosity cP |
A measure of the resistance of the sample to flow. | No |
NUMBER |
| Volume | double | Volume m3 |
The volume of the material recovered during the well test/well test stage. Note: This can be the actual volume that was measured, or the normalized volume that was calculated for a particular well test/well test stage. | No |
NUMBER |
| Volume_Method_Code | R_Volume_Method |
|
The type of method used to determine the volume of fluids recovered during a well test. Example values are: Measured, Calculated, and Normalized. | Yes |
VARCHAR2(64) |
| Well_Test_Stage_Id | Well_Test_Stage |
|
The identifier of the well test stage during which the fluid was recovered. | Yes |
NUMBER(38) |
| pH | double | Dimensionless |
Indicates the degree of acidity of the material. A value of 7 denotes a neutral fluid, lower values correspond to acidic fluids and higher values to basic fluids | No |
NUMBER |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Production_Test_DOV | Oil_Volume | READ ONLY: Unique identifier for the Oil Volume. | Cascade | No |
| Production_Test_DOV | Water_Volume | READ ONLY: Unique identifier for the Water Volume. | Cascade | No |
| Production_Test_DOV | Condensate_Volume | READ ONLY: Unique identifier for the Condensate Volume. | Cascade | No |
| Production_Test_DOV | Gas_Volume | READ ONLY: Unique identifier for the Gas Volume. | Cascade | No |
| Production_Test_DOV | Gas_Lift_Volume | READ ONLY: Unique identifier for the Gas Lift Volume. | Cascade | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Material_Disposition | R_Material_Disposition | The description of how a material is used/consumed. For example, Sales, Flared, Irrigation, etc. | Restrict | No |
| Flow_Direction_Code | R_Flow_Direction | A value that specifies whether the volume is being produced from the well or being injected into the well during the well test stage. Valid values are: In, Out. | Restrict | Yes |
| Utilized_Facility | Activity_Facility_Invl | The identifier of the facility utilized during the well test. For example, a separator can be utilized during a well test. | Restrict | No |
| Well_Test_Stage | Well_Test_Stage | The identifier of the well test stage during which the fluid was recovered. | Cascade | Yes |
| Volume_Method_Code | R_Volume_Method | The type of method used to determine the volume of fluids recovered during a well test. Example values are: Measured, Calculated, and Normalized. | Restrict | Yes |
| Material_Type | R_Production_Material | The type of material that is recovered in the well test stage. For example, oil, water, gas, condensate, etc. | Restrict | Yes |