| Name | MicroSeismic_Data_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The MicroSeismic Pumping data DOV. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| BH_Proppant_concentration | double | Mass_Per_Volume kg/m3 |
Bottom hole concentration | No |
NUMBER |
| BH_press | double | Pressure kPa |
Borehole pressure | No |
NUMBER |
| Borehole_Id | ID | No_Unit |
Borehole Id associated with the event. | No |
NUMBER(38) |
| Borehole_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) |
| Clean_Fluid_Data_Id | ID | No_Unit |
_ | No |
NUMBER(38) |
| Clean_fluid_cumulative | double | Volume m3 |
Clean Fluid volume | No |
NUMBER |
| Clean_fluid_rate | double | No_Unit |
Clean Fluid rate | 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) |
| Job_Time | DATE | NA |
DateTime of Microseismic Event. | Yes |
DATE |
| Proppant_Data_Id | ID | No_Unit |
_ | No |
NUMBER(38) |
| Proppant_concentration | double | Mass_Per_Volume kg/m3 |
Proppant concentration | No |
NUMBER |
| Proppant_cumulative | double | Volume m3 |
Proppant volume | No |
NUMBER |
| Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Slurry_Data_Id | ID | No_Unit |
_ | No |
NUMBER(38) |
| Slurry_cumulative | double | Volume m3 |
Slurry volume | No |
NUMBER |
| Slurry_rate | double | No_Unit |
Slurry rate | No |
NUMBER |
| Start_Date | DATE | NA |
The date and time at which the activity will start or did start. | Yes |
DATE |
| Treating_press | double | Pressure kPa |
Treating pressure | No |
NUMBER |
| Treatment_Stage_Id | ID | No_Unit |
_ | No |
NUMBER(38) |
| UBHI | WELL_IDENTIFIER | NA |
The Unique Identifier assigned to a borehole | Yes |
VARCHAR2(64) |
| Update_Date | DATE | NA |
_ | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the updation of this entity in the repository. | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW MicroSeismic_Data_DOV(ID, UBHI, BOREHOLE_NAME, START_DATE, JOB_TIME, CLEAN_FLUID_CUMULATIVE, SLURRY_CUMULATIVE, BH_PROPPANT_CONCENTRATION, PROPPANT_CONCENTRATION, PROPPANT_CUMULATIVE, SLURRY_RATE, BH_PRESS, TREATING_PRESS, CLEAN_FLUID_RATE, REMARKS, UPDATE_DATE, UPDATE_USER, INSERT_DATE, INSERT_USER, BOREHOLE_ID, TREATMENT_STAGE_ID, CLEAN_FLUID_DATA_ID, SLURRY_DATA_ID, PROPPANT_DATA_ID) AS SELECT tds.Id Id, bh.UBHI UBHI, bh.Name Borehole_Name, ts.start_date Start_Date, tds.Job_Time Job_Time, td1.Fluid_Cumulative Clean_fluid_cumulative, td2.Fluid_Cumulative Slurry_cumulative, td3.BH_Concentration BH_Proppant_concentration, td3.Fluid_Concentration Proppant_concentration, td3.Fluid_Cumulative Proppant_cumulative, td2.Fluid_Rate Slurry_rate, tds.BH_Pressure BH_press, tds.Treating_Pressure Treating_press, td1.Fluid_Rate Clean_fluid_rate, tds.Remarks Remarks, tds.Update_Date Update_Date, tds.Update_User Update_User, tds.Insert_Date Insert_Date, tds.Insert_User Insert_User, bh.Id Borehole_Id, ts.Id Treatment_Stage_Id, td1.Id Clean_Fluid_Data_Id, td2.Id Slurry_Data_Id, td3.Id Proppant_Data_Id FROM Borehole bh, Treatment_Stage ts, Treatment_Dataset tds, Treatment_Data td1, Treatment_Data td2, Treatment_Data td3 WHERE ts.Borehole_Id = bh.Id AND ts.Id = tds.Treatment_Stage_Id AND tds.Id = td1.Treatment_Dataset_Id(+) AND td1.material_type(+) = 'Clean Fluid' AND tds.Id = td2.Treatment_Dataset_Id(+) AND td2.material_type(+) = 'Slurry' AND tds.Id = td3.Treatment_Dataset_Id(+) AND td3.material_type(+) = 'Proppant' |