MS_EVENT_DETAIL_DOV

[Columns] [Composed Of] [Referenced By] [Refers To]

Name	MS_EVENT_DETAIL_DOV
Entity Type	ObjectView
Description	Data Object View. The MicroSeismic Event Data DOV.
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

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)
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)
Job_Time	DATE	NA	DateTime of Microseismic Event.	Yes	DATE
MS_Coord_System_Id	ID	NA	READ ONLY: The code for the original projected or geographic coordinate system.	No	NUMBER(38)
MS_Det_SNR	double	No_Unit	Detection inversion objective function	No	NUMBER
MS_Distance	double	Length m	MS_Distance	No	NUMBER
MS_EIGVAL_Max	double	Length m	MS_EIGVAL_Max	No	NUMBER
MS_EIGVAL_Mid	double	Length m	MS_EIGVAL_Mid	No	NUMBER
MS_EIGVAL_Min	double	Length m	MS_EIGVAL_Min	No	NUMBER
MS_EIGVEC_Max_E	double	No_Unit	MS_EIGVEC_Max_E	No	NUMBER
MS_EIGVEC_Max_N	double	No_Unit	MS_EIGVEC_Max_N	No	NUMBER
MS_EIGVEC_Max_U	double	No_Unit	MS_EIGVEC_Max_U	No	NUMBER
MS_EIGVEC_Mid_E	double	No_Unit	MS_EIGVEC_Mid_E	No	NUMBER
MS_EIGVEC_Mid_N	double	No_Unit	MS_EIGVEC_Mid_N	No	NUMBER
MS_EIGVEC_Mid_U	double	No_Unit	MS_EIGVEC_Mid_U	No	NUMBER
MS_Event_Identifier	double	No_Unit	MS Event Identifier	No	NUMBER
MS_Loc_SNR	double	Pressure kPa	Location inversion objective function	No	NUMBER
MS_Location_X	double	Plane_Angle deg	X coordinate, or longitude, of the point in the cartographic system of the input dataset.	No	NUMBER
MS_Location_Y	double	Plane_Angle deg	Y coordinate, or latitude, of the point in the cartographic system of the input dataset.	No	NUMBER
MS_Location_Z	double	Length m	Vertical offset of the current Coordinate System and the From_Coordinate_System.	No	NUMBER
MS_Stage_Id	ID	No_Unit	Microseismic Event Stage Id associated with the event	No	NUMBER(38)
MT_Moment_XX	double	No_Unit	MT_Moment_XX	No	NUMBER
MT_Moment_XY	double	No_Unit	MT_Moment_XY	No	NUMBER
MT_Moment_XZ	double	No_Unit	MT_Moment_XZ	No	NUMBER
MT_Moment_YY	double	No_Unit	MT_Moment_YY	No	NUMBER
MT_Moment_YZ	double	No_Unit	MT_Moment_YZ	No	NUMBER
MT_Moment_ZZ	double	No_Unit	MT_Moment_ZZ	No	NUMBER
Noise_Level	double	No_Unit	RMS Noise level	No	NUMBER
PSH_Ampl_Ratio	double	No_Unit	P and Sh amplitude ratio	No	NUMBER
QC_Coord_System_id	ID	No_Unit	_	No	NUMBER(38)
QC_Distance	double	Length m	Final event distance from center of sensor array to Mocroseismic Event	No	NUMBER
QC_EIGVAL_Max	double	Length m	Final error ellipsoid major axis length	No	NUMBER
QC_EIGVAL_Mid	double	Length m	Final error ellipsoid semi-major axis length	No	NUMBER
QC_EIGVAL_Min	double	Length m	Final error ellipsoid minor axis length	No	NUMBER
QC_EIGVEC_Max_E	double	No_Unit	Final error ellipsoid major axis east unit vector	No	NUMBER
QC_EIGVEC_Max_N	double	No_Unit	Final error ellipsoid major axis north unit vector	No	NUMBER
QC_EIGVEC_Max_U	double	No_Unit	Final error ellipsoid major axis elevation unit vector	No	NUMBER
QC_EIGVEC_Mid_E	double	No_Unit	Final error ellipsoid semi-major axis east unit vector	No	NUMBER
QC_EIGVEC_Mid_N	double	No_Unit	Final error ellipsoid semi-major axis north unit vector	No	NUMBER
QC_EIGVEC_Mid_U	double	No_Unit	Final error ellipsoid semi-major axis elevation unit vector	No	NUMBER
QC_Location_Id	ID	No_Unit	Position Id associated with the QC location data	No	NUMBER(38)
QC_Location_X	double	Plane_Angle deg	X coordinate, or longitude, of the point in the cartographic system of the input dataset.	No	NUMBER
QC_Location_Y	double	Plane_Angle deg	Y coordinate, or latitude, of the point in the cartographic system of the input dataset.	No	NUMBER
QC_Location_Z	double	Length m	Vertical offset of the current Coordinate System and the From_Coordinate_System.	No	NUMBER
QI_Confidence	double	No_Unit	Confidence Indicator [0-5]	No	NUMBER
QI_Data_Location	double	No_Unit	Data location quality indicator [0-1]	No	NUMBER
QI_Orthogonality	double	No_Unit	Orthogonality quality indicator [0-1]	No	NUMBER
QI_Polarization_Azm	double	No_Unit	Polarization inclination quality indicator [0-1]	No	NUMBER
QI_Polarization_Inc	double	No_Unit	Polarization inclination quality indicator [0-1]	No	NUMBER
QI_Polarization_Residual	double	No_Unit	Polarization residual quality indicator [0-1]	No	NUMBER
QI_Time_Residual	double	No_Unit	QI_Time_Residual	No	NUMBER
QI_Tracedata	double	No_Unit	Trace data quality indicator [0-1]	No	NUMBER
QI_Tracedata_P	double	No_Unit	P trace quality indicator [0-1]	No	NUMBER
QI_Tracedata_S	double	No_Unit	S trace quality indicator [0-1]	No	NUMBER
Remarks	REMARKS_STR	NA	Any type of remarks added to an entity instance.	No	VARCHAR2(999)
SP_Energy	double	No_Unit	SP_Energy	No	NUMBER
SP_Magnitude	double	No_Unit	Moment Magnitude of Microseismic event	No	NUMBER
SP_Moment	double	No_Unit	SP_Moment	No	NUMBER
SP_Radius	double	Length m	SP_Radius	No	NUMBER
SP_Stress_Drop	double	No_Unit	SP_Stress_Drop	No	NUMBER
SVSH_Ampl_Ratio	double	No_Unit	Sv and Sh amplitude ratio	No	NUMBER
Shape	GEOMETRY	NA	Binary spatial representation of the position.	No	ST_GEOMETRY
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)

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW MS_EVENT_DETAIL_DOV(ID, UBHI, BOREHOLE_NAME, EVENT_TYPE, EVENT_NAME, START_DATE, JOB_TIME, MS_DET_SNR, MS_DISTANCE, MS_EIGVAL_MAX, MS_EIGVAL_MID, MS_EIGVAL_MIN, MS_EIGVEC_MAX_E, MS_EIGVEC_MAX_N, MS_EIGVEC_MAX_U, MS_EIGVEC_MID_E, MS_EIGVEC_MID_N, MS_EIGVEC_MID_U, MS_EVENT_IDENTIFIER, MS_LOC_SNR, MT_MOMENT_XX, MT_MOMENT_XY, MT_MOMENT_XZ, MT_MOMENT_YY, MT_MOMENT_YZ, MT_MOMENT_ZZ, NOISE_LEVEL, SOURCE, PSH_AMPL_RATIO, QC_DISTANCE, QC_EIGVAL_MAX, QC_EIGVAL_MID, QC_EIGVAL_MIN, QC_EIGVEC_MAX_E, QC_EIGVEC_MAX_N, QC_EIGVEC_MAX_U, QC_EIGVEC_MID_E, QC_EIGVEC_MID_N, QC_EIGVEC_MID_U, QI_CONFIDENCE, QI_DATA_LOCATION, QI_ORTHOGONALITY, QI_POLARIZATION_AZM, QI_POLARIZATION_INC, QI_POLARIZATION_RESIDUAL, QI_TIME_RESIDUAL, QI_TRACEDATA, QI_TRACEDATA_P, QI_TRACEDATA_S, REMARKS, SP_ENERGY, SP_MAGNITUDE, SP_MOMENT, SP_RADIUS, SP_STRESS_DROP, SVSH_AMPL_RATIO, SHAPE, MS_LOCATION_X, MS_LOCATION_Y, MS_LOCATION_Z, QC_LOCATION_X, QC_LOCATION_Y, QC_LOCATION_Z, INSERT_DATE, 
INSERT_USER, UPDATE_DATE, UPDATE_USER, BOREHOLE_ID, EVENT_ID, MS_STAGE_ID, QC_LOCATION_ID, QC_COORD_SYSTEM_ID, MS_COORD_SYSTEM_ID) AS SELECT
	msed.Id 								Id,
	bh.UBHI 								UBHI,
	bh.Name 								Borehole_Name,
	mses.Event_Type 							Event_Type,
	rmset.Name 								Event_Name,
	ev.Start_Date 								Start_Date,
	msed.Job_Time 								Job_Time,
	msed.MS_Det_SNR 							MS_Det_SNR,
	msed.MS_Distance 							MS_Distance,
	msed.MS_EIGVAL_Max 							MS_EIGVAL_Max,
	msed.MS_EIGVAL_Mid 							MS_EIGVAL_Mid,
	msed.MS_EIGVAL_Min 							MS_EIGVAL_Min,
	msed.MS_EIGVEC_Max_E 							MS_EIGVEC_Max_E,
	msed.MS_EIGVEC_Max_N 							MS_EIGVEC_Max_N,
	msed.MS_EIGVEC_Max_U 							MS_EIGVEC_Max_U,
	msed.MS_EIGVEC_Mid_E 							MS_EIGVEC_Mid_E,
	msed.MS_EIGVEC_Mid_N 							MS_EIGVEC_Mid_N,
	msed.MS_EIGVEC_Mid_U 							MS_EIGVEC_Mid_U,
	msed.MS_Event_Identifier 						MS_Event_Identifier,
	msed.MS_Loc_SNR 							MS_Loc_SNR,
	msed.MT_Moment_XX 							MT_Moment_XX,
	msed.MT_Moment_XY 
							MT_Moment_XY,
	msed.MT_Moment_XZ 							MT_Moment_XZ,
	msed.MT_Moment_YY 							MT_Moment_YY,
	msed.MT_Moment_YZ 							MT_Moment_YZ,
	msed.MT_Moment_ZZ 							MT_Moment_ZZ,
	msed.Noise_Level 							Noise_Level,
	msed.Source 								Source,
	msed.PSH_Ampl_Ratio	 						PSH_Ampl_Ratio,
	msed.QC_Distance 							QC_Distance,
	msed.QC_EIGVAL_Max 							QC_EIGVAL_Max,
	msed.QC_EIGVAL_Mid 							QC_EIGVAL_Mid,
	msed.QC_EIGVAL_Min 							QC_EIGVAL_Min,
	msed.QC_EIGVEC_Max_E 							QC_EIGVEC_Max_E,
	msed.QC_EIGVEC_Max_N 							QC_EIGVEC_Max_N,
	msed.QC_EIGVEC_Max_U 							QC_EIGVEC_Max_U,
	msed.QC_EIGVEC_Mid_E 							QC_EIGVEC_Mid_E,
	msed.QC_EIGVEC_Mid_N 							QC_EIGVEC_Mid_N,
	msed.QC_EIGVEC_Mid_U 							QC_EIGVEC_Mid_U,
	msed.QI_Confidence 							QI_Confidence,
	msed.QI_Data_Location 							QI_Data_Location,
	msed.QI_Orthogonality 
							QI_Orthogonality,
	msed.QI_Polarization_Azm						QI_Polarization_Azm,
	msed.QI_Polarization_Inc						QI_Polarization_Inc,
	msed.QI_Polarization_Residual 						QI_Polarization_Residual,
	msed.QI_Time_Residual 							QI_Time_Residual,
	msed.QI_Tracedata 							QI_Tracedata,
	msed.QI_Tracedata_P 							QI_Tracedata_P,
	msed.QI_Tracedata_S 							QI_Tracedata_S,
	msed.Remarks 								Remarks,
	msed.SP_Energy 								SP_Energy,
	msed.SP_Magnitude 							SP_Magnitude,
	msed.SP_Moment 								SP_Moment,
	msed.SP_Radius 								SP_Radius,
	msed.SP_Stress_Drop 							SP_Stress_Drop,
	msed.SVSH_Ampl_Ratio 							SVSH_Ampl_Ratio,
	ps.Shape 								Shape,
	ps.Original_X_Longitude 						MS_Location_X,
	ps.Original_Y_Latitude 							MS_Location_Y,
	MSCS.Z_Offset 								MS_Location_Z,
	DECODE (sds_spatial.sde_enabled (),1,
		NVL (ps.Normal_Longitude, SDE.ST_X(ps.Shape)), ps.Normal_Longitude) QC_Location_X,
	DECODE (sds_spatial.sde_enabled (),1,
		NVL (ps.Normal_Latitude, SDE.ST_Y(ps.Shape)), 
ps.Normal_Latitude) QC_Location_Y,
	QCCS.Z_Offset 								QC_Location_Z,
	msed.Insert_Date 							Insert_Date,
	msed.Insert_User 							Insert_User,
	msed.Update_Date 							Update_Date,
	msed.Update_User 							Update_User,
	bh.Id 									Borehole_Id,
	mses.Event_Id 								Event_Id,
	mses.Id 								MS_Stage_Id,
	msed.QC_Location_Id 							QC_Location_Id,
	QCCS.Id 								QC_Coord_System_id,
	MSCS.Id 								MS_Coord_System_Id
FROM
	MS_Event_Detail msed,
	Event ev,
	R_MS_Event_Type rmset,
	Position ps,
	Borehole bh,
	Coordinate_System MSCS,
	Coordinate_System QCCS,
	MS_Event_Stage mses
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
	AND msed.QC_Location_Id = ps.Id
	AND msed.MS_Event_Stage_Id = mses.Id
	AND ps.original_coord_system_id = MSCS.id
	AND ps.coordinate_system_id = QCCS.id

[Seabed Objects] [Entities in Schema Seabed] [Index]

MS_EVENT_DETAIL_DOV

Copyright © 2018 Schlumberger. All rights reserved.