| Name | Well_Status_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The Well Status DOV contains the changes in status of a well over time. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| End_Date | DATE | NA |
The end date and time for the validity of a well status | No |
DATE |
| 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) |
| Start_Date | DATE | NA |
The effective date for this status for this well | Yes |
DATE |
| Status | CODE | NA |
The status of a well at a particular point in time | Yes |
VARCHAR2(64) |
| UWI | WELL_IDENTIFIER | NA |
Unique Well Identifier | Yes |
VARCHAR2(64) |
| Well_Id | Well |
|
READ ONLY: Unique identifier for the well. | No |
NUMBER(38) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Well | Well | READ ONLY: Unique identifier for the well. | Cascade | No |
CREATE OR REPLACE FORCE VIEW Well_Status_DOV(ID, UWI, START_DATE, END_DATE, STATUS, INSERT_DATE, INSERT_USER, WELL_ID) AS SELECT ws.Id Id, w.UWI UWI, ws.Start_Date Start_Date, ws.End_Date End_Date, ws.Status Status, ws.Insert_Date Insert_Date, ws.Insert_User Insert_User, w.Id Well_Id FROM Well w, Well_Status ws WHERE w.Id = ws.Well_Id |