| Name | Trace_Hdr_Summary |
|---|---|
| Entity Type | Extension of Well_Test_Trace |
| Description | An extension table to the Well_Test_Trace table to hold summary information on the information held in the bulk array for the well test trace. |
| Submodel | Well_Testing |
| Entity Scope | Project |
| Primary Key | Well_Test_Trace_Id |
| Natural Key | |
| Generalizations | Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Average_Flow_Rate | double | Flowrate m3/h |
The average flow rate of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Average_Fluid_Level | double | Depth m |
The average fluid level during the period for which the trace measurements are taken | No |
NUMBER |
| Average_Pressure | double | Pressure kPa |
The average pressure of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Average_Temperature | double | Temperature degC |
The average temperature of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Average_Volume | double | Volume m3 |
The average volume of fluid that flowed during the period for which the trace measurements are taken | No |
NUMBER |
| Depth_Increment | double | Length m |
The depth difference between 2 successive trace points in a trace with equally spaced points. | No |
NUMBER |
| End_Date | DATE | NA |
The date/time on which the recording of trace measurements ended. | No |
DATE |
| Final_Flow_Rate | double | Flowrate m3/h |
The final flow rate of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Final_Fluid_Level | double | Depth m |
The final fluid level during the period for which the trace measurements are taken | No |
NUMBER |
| Final_Pressure | double | Pressure kPa |
The final pressure of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Final_Temperature | double | Temperature degC |
The final temperature of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Final_Volume | double | Volume m3 |
The final volume of fluid that flowed during the period for which the trace measurements are taken | No |
NUMBER |
| Flow_Direction_Code | R_Flow_Direction |
|
A value that specifies whether the trace originates from material being produced from the well or being injected into the well during the well test stage. Valid values are: In, Out. | No |
VARCHAR2(64) |
| Initial_Flow_Rate | double | Flowrate m3/h |
The initial flow rate of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Initial_Fluid_Level | double | Depth m |
The initial fluid level during the period for which the trace measurements are taken | No |
NUMBER |
| Initial_Pressure | double | Pressure kPa |
The initial pressure of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Initial_Temperature | double | Temperature degC |
The initial temperature of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Initial_Volume | double | Volume m3 |
The initial volume of fluid that flowed during the period for which the trace measurements are taken | No |
NUMBER |
| 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) |
| 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 material associated with the well test trace | No |
VARCHAR2(64) |
| Max_Flow_Rate | double | Flowrate m3/h |
The maximum flow rate of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Max_Fluid_Level | double | Depth m |
The maximum fluid level during the period for which the trace measurements are taken | No |
NUMBER |
| Max_Pressure | double | Pressure kPa |
The maximum pressure of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Max_Temperature | double | Temperature degC |
The maximum temperature of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Max_Volume | double | Volume m3 |
The maximum volume of fluid that flowed during the period for which the trace measurements are taken | No |
NUMBER |
| Min_Flow_Rate | double | Flowrate m3/h |
The minimum flow rate of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Min_Fluid_Level | double | Depth m |
The minimum fluid level during the period for which the trace measurements are taken | No |
NUMBER |
| Min_Pressure | double | Pressure kPa |
The minimum pressure of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Min_Temperature | double | Temperature degC |
The minimum temperature of the fluid during the period for which the trace measurements are taken | No |
NUMBER |
| Min_Volume | double | Volume m3 |
The minimum volume of fluid that flowed during the period for which the trace measurements are taken | No |
NUMBER |
| Observation_Increment | double | Time s |
The time difference between 2 successive trace points in a trace with equally spaced points. | No |
NUMBER |
| Point_Count | int | No_Unit |
The number of points in the well test trace | No |
NUMBER(10) |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Start_Date | DATE | NA |
The date/time on which the recording of trace measurements began. | No |
DATE |
| 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) |
| Well_Test_Trace_Id | Well_Test_Trace |
|
The well test trace that is summarized in this extension table. | Yes |
NUMBER(38) |
| 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 |
| Well_Test_Trace | Well_Test_Trace | The well test trace that is summarized in this extension table. | Cascade | Yes |
| Material_Type | R_Production_Material | The material associated with the well test trace | Restrict | No |
| Flow_Direction_Code | R_Flow_Direction | A value that specifies whether the trace originates from material being produced from the well or being injected into the well during the well test stage. Valid values are: In, Out. | Restrict | No |