| Name | PSR_Well_Summary_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The Well Summary DOV contains general information about a well such as the spud date, coordinates of the well top, field, name, and UWI. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| CLASS | STRING255 | NA |
Denormalized from Borehole. Overall classification of the Well according to the Lahee classification system. Only useful where all Boreholes have the same classification | No |
VARCHAR2(255) |
| COMPANY_ID | ID | NA |
READ ONLY: Unique identifier for the company. | No |
NUMBER(38) |
| COUNTRY | STRING255 | NA |
Country Name | No |
VARCHAR2(255) |
| CURRENT_STATUS | CODE | NA |
Current Status | No |
VARCHAR2(64) |
| FIELD | ENTITY_NAME | NA |
Field Name | No |
VARCHAR2(255) |
| FIELD_ID | ID | NA |
READ ONLY: Unique identifier for the field. | No |
NUMBER(38) |
| GEOPOLITICAL_POSITION_ID | ID | NA |
READ ONLY: Unique identifier for the geopolitical position. | No |
NUMBER(38) |
| 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) |
| OPERATOR | ENTITY_NAME | NA |
Company Name | No |
VARCHAR2(255) |
| ORIGINAL_COORD_SYSTEM_ID | ID | NA |
Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references. | No |
NUMBER(38) |
| ORIGINAL_COORD_SYSTEM_NAME | ENTITY_NAME | NA |
READ ONLY: The name of the Original Coordinate System. | No |
VARCHAR2(255) |
| ORIGINAL_CRS | CODE | NA |
READ ONLY: The code for the original projected or geographic coordinate system. | No |
VARCHAR2(64) |
| ORIGINAL_TOP_X | double | No_Unit |
X coordinate, or longitude, of the point in the cartographic system of the input dataset. | No |
NUMBER |
| ORIGINAL_TOP_Y | double | No_Unit |
Y coordinate, or latitude, of the point in the cartographic system of the input dataset. | No |
NUMBER |
| PERMANENT_COORD_SYSTEM_ID | ID | NA |
READ ONLY: Unique identifier for the permanent coordinate system. | No |
NUMBER(38) |
| PERMANENT_ELEVATION | double | Length m |
Permanent Elevation | No |
NUMBER |
| PERMANENT_ELEVATION_REF | CODE | NA |
Permanent Elevation Reference | No |
VARCHAR2(64) |
| POSITION_ID | double | NA |
READ ONLY: Unique identifier for the position. | No |
NUMBER |
| PRIMARY_SOURCE | STRING64 | NA |
Primary Source | No |
VARCHAR2(64) |
| PROJECT_DEFAULT_ID | ID | NA |
READ ONLY: Unique identifier for the project default. | No |
NUMBER(38) |
| PROJECT_ELEVATION_REF | CODE | NA |
Project Elevation Ref | No |
VARCHAR2(64) |
| REMARKS | REMARKS_STR | NA |
Well Remarks | No |
VARCHAR2(999) |
| SHAPE | GEOMETRY | NA |
Binary spatial representation of the position. | No |
ST_GEOMETRY |
| SHORT_NAME | STRING255 | NA |
Well Alias Name | No |
VARCHAR2(255) |
| SPUD_DATE | DATE | NA |
Spud Date | No |
DATE |
| STORAGE_COORDINATE_SYSTEM_ID | ID | NA |
READ ONLY: Unique identifier for the storage coordinate system. | No |
NUMBER(38) |
| TOP_X | double | No_Unit |
X coordinate of Well Top | No |
NUMBER |
| TOP_Y | double | No_Unit |
Y coordinate of Well Top | No |
NUMBER |
| UWI | WELL_IDENTIFIER | NA |
Unique Well Identifier | Yes |
VARCHAR2(64) |
| WELL_ALIAS_ID | ID | NA |
READ ONLY: Unique identifier for the well alias. | No |
NUMBER(38) |
| WELL_BA_INVOLVEMENT_ID | ID | NA |
READ ONLY: Unique identifier for the well ba involvement. | No |
NUMBER(38) |
| WELL_NAME | ENTITY_NAME | NA |
Well Name | No |
VARCHAR2(255) |
CREATE OR REPLACE FORCE VIEW PSR_Well_Summary_DOV(ID, UWI, WELL_NAME, SHORT_NAME, PRIMARY_SOURCE, SHAPE, TOP_X, TOP_Y, ORIGINAL_COORD_SYSTEM_ID, ORIGINAL_COORD_SYSTEM_NAME, ORIGINAL_CRS, ORIGINAL_TOP_X, ORIGINAL_TOP_Y, CLASS, OPERATOR, PERMANENT_ELEVATION, PERMANENT_ELEVATION_REF, PROJECT_ELEVATION_REF, CURRENT_STATUS, SPUD_DATE, COUNTRY, FIELD, REMARKS, INSERT_DATE, INSERT_USER, FIELD_ID, WELL_BA_INVOLVEMENT_ID, COMPANY_ID, WELL_ALIAS_ID, PERMANENT_COORD_SYSTEM_ID, POSITION_ID, GEOPOLITICAL_POSITION_ID, STORAGE_COORDINATE_SYSTEM_ID, PROJECT_DEFAULT_ID) AS SELECT w.ID ID, w.uwi uwi, w.NAME well_name, wa.alias_name short_name,
w.SOURCE primary_source, p.shape shape,
DECODE (sds_spatial.sde_enabled (),
1, NVL (p.normal_longitude,
SDE.ST_X (p.shape)),
p.normal_longitude
) top_x,
DECODE (sds_spatial.sde_enabled (),
1, NVL (p.normal_latitude, SDE.ST_Y (p.shape)),
p.normal_latitude
) top_y,
p.original_coord_system_id original_coord_system_id,
cs3.NAME original_coord_system_name, cs3.crs original_crs,
p.original_x_longitude original_top_x,
p.original_y_latitude original_top_y, w.lahee_class CLASS,
c.NAME OPERATOR, cs1.z_offset permanent_elevation,
cs1.vertical_reference permanent_elevation_ref,
cs2.vertical_reference project_elevation_ref,
w.current_status current_status, w.spud_date spud_date,
gp.country_name country, f.NAME FIELD, w.remarks remarks,
w.insert_date insert_date, w.insert_user insert_user, f.ID field_id,
wbi.ID well_ba_involvement_id, c.ID company_id, wa.ID well_alias_id,
cs1.ID permanent_coord_system_id, p.ID position_id,
gp.position_id geopolitical_position_id,
cs2.ID storage_coordinate_system_id, pd.ID project_default_id
FROM well w,
FIELD f,
well_ba_involvement wbi,
company c,
well_alias wa,
coordinate_system cs1,
POSITION p,
geopolitical_position gp,
coordinate_system cs2,
coordinate_system cs3,
project_default pd
WHERE w.field_id = f.ID(+)
AND w.ID = wbi.well_id(+)
AND 'Operator' = wbi.involvement_role(+)
AND wbi.business_associate_id = c.ID(+)
AND w.ID = wa.well_id(+)
AND 'Short Name' = wa.alias_type(+)
AND w.permanent_coord_system_id = cs1.ID(+)
AND w.surface_location_id = p.ID(+)
AND p.ID = gp.position_id(+)
AND p.original_coord_system_id = cs3.ID(+)
AND pd.storage_coord_sys_id = cs2.ID
|