| Name | MS_EVENT_HDR_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The MicroSeismic Event Header DOV. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| 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) |
| Contractor_Name | STRING64 | NA |
Name of the contractor present at site when the event took place. | No |
VARCHAR2(64) |
| Duration | NUMBER2 | NA |
DateTime of Microseismic Event. | Yes |
NUMBER(2) |
| End_Date | DATE | NA |
DateTime of Microseismic Event. | Yes |
DATE |
| Event_Id | ID | No_Unit |
Event Id associated with the event | No |
NUMBER(38) |
| Event_Name | STRING64 | NA |
String Defining Type of the Event | No |
VARCHAR2(64) |
| Event_Type | STRING64 | NA |
Type of the Event | No |
VARCHAR2(64) |
| 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 insertion of this entity in the repository. | No |
VARCHAR2(64) |
| Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Source | STRING64 | NA |
Name of the person or organization responsible for this entity"s 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) |
| Start_Date | DATE | NA |
DateTime of Microseismic Event. | Yes |
DATE |
| 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 insertion of this entity in the repository. | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW MS_EVENT_HDR_DOV(ID, UBHI, BOREHOLE_NAME, EVENT_TYPE, EVENT_NAME, START_DATE, END_DATE, DURATION, REMARKS, SOURCE, CONTRACTOR_NAME, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, BOREHOLE_ID, EVENT_ID) AS SELECT mses.Id Id, bh.UBHI UBHI, bh.Name Borehole_Name, mses.Event_Type Event_Type, rmset.Name Event_Name, ev.Start_Date Start_Date, ev.End_Date End_Date, ev.Duration Duration, mses.Remarks Remarks, mses.Source Source, ev.Contractor_Name Contractor_Name, mses.Insert_Date Insert_Date, mses.Insert_User Insert_User, mses.Update_Date Update_Date, mses.Update_User Update_User, bh.Id Borehole_Id, ev.Id Event_Id FROM Borehole bh, Event ev, MS_Event_Stage mses, R_MS_Event_Type rmset WHERE ev.Borehole_Id = bh.Id AND mses.Event_Type = rmset.Code AND mses.Event_Id = ev.Id AND mses.Treatment_Borehole_Id = bh.Id |