| Name | Field_Summary_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. A geographical area in which a number of oil or gas wells produce from a continuous reservoir. A field may refer to surface area only or to underground productive formations as well. A single field may have several separate reservoirs at varying depths. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Boundary_Area_Id | Area |
|
READ ONLY: If the surface boundaries of a field are described in terms of an area, this is the identifier for that area. | No |
NUMBER(38) |
| Discovery_Date | DATE | NA |
The date on which the field was discovered. | No |
DATE |
| Field_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) |
| Field_Type | CODE | NA |
The identifier of the value of the type of field. Example: Oil Field, Gas Field. | 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 creation of this entity in the repository. | No |
VARCHAR2(64) |
| Location_Id | Position |
|
READ ONLY: The identifier of the location that represents the field. | No |
NUMBER(38) |
| Parent_Field_Id | Field |
|
READ ONLY: The parent field for this field. | No |
NUMBER(38) |
| Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Shape | GEOMETRY | NA |
Binary spatial representation of the position. | No |
ST_GEOMETRY |
| Source | STRING64 | No_Unit |
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) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Boundary_Area | Area | READ ONLY: If the surface boundaries of a field are described in terms of an area, this is the identifier for that area. | Control | No |
| Location | Position | READ ONLY: The identifier of the location that represents the field. | Cascade | No |
| Parent_Field | Field | READ ONLY: The parent field for this field. | Cascade | No |
CREATE OR REPLACE FORCE VIEW Field_Summary_DOV(ID, FIELD_NAME, FIELD_TYPE, DISCOVERY_DATE, SOURCE, REMARKS, SHAPE, INSERT_DATE, INSERT_USER, BOUNDARY_AREA_ID, LOCATION_ID, PARENT_FIELD_ID) AS SELECT
Field.Id Id,
Field.Name Field_Name,
Field.Field_Type Field_Type,
Field.Discovery_Date Discovery_Date,
Field.Source Source,
Field.Remarks Remarks,
Area.Shape Shape,
Field.Insert_Date Insert_Date,
Field.Insert_User Insert_User,
Field.Boundary_Area_Id Boundary_Area_Id,
Field.Location_Id Location_Id,
Field.Parent_Field_Id Parent_Field_Id
FROM Field,
Area
WHERE Field.Boundary_Area_Id=Area.Id(+)
AND Field.Existence_Kind = 'Actual'
AND Field.Version = '1'
|