| Name | Perforation_Summary_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. Perforation is the act by which tunnels are created from the casing or liner of the wellbore into the reservoir formation, through which oil or gas can be produced. The Perforation Summary DOV provides basic information about a perforation such as gun size and type, and shot density. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Activity_BA_Invl_Id | Activity_BA_Invl |
|
READ ONLY: Unique identifier for the activity BA involvement. | No |
NUMBER(38) |
| Borehole_Id | Borehole |
|
READ ONLY: Unique identifier for the Borehole. | 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) |
| Bottom_Depth | double | Standard_Depth_Index m |
the measured depth of the base of the interval to be perforated | Yes |
NUMBER |
| Charge_Size | double | Mass kg |
The size of the charge used for this perforation expressed in terms of explosive weight. | No |
NUMBER |
| Completion_Engineer | STRING128 | NA |
An identifier, constructed and assigned by the users of the database, that allows business associates to be uniquely identified for the purpose of matching and loading data. | No |
VARCHAR2(128) |
| Current_Status | CODE |
|
The status of the perforated interval that is currently in effect. This column represents a denormalization; and its value should be equal to the Perf_Interval_Status.Status value in the Perf_Interval_Status record where End_Date is NULL. | Yes |
VARCHAR2(64) |
| End_Date | DATE | NA |
The date and time at which the activity will end or did end. For planned activities, this would be expected end date. | No |
DATE |
| Fluid_Type | STRING64 | NA |
Fluid Type | No |
VARCHAR2(64) |
| Fluid_Weight | double | Density g/cm3 |
Density of Fluid | No |
NUMBER |
| Gun_Size | double | Cylinder_Diameter mm |
The size of the gun used for this perforation job | No |
NUMBER |
| Gun_Type | CODE |
|
The type of perforation gun used in the perforation activity | 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) |
| Overbalance_Pressure | double | Pressure kPa |
The absolute pressure difference when the perforation method is under/over balanced | No |
NUMBER |
| Perforation_Activity_Id | Perforation_Activity |
|
READ ONLY: Unique identifier for the perforated interval. | No |
NUMBER(38) |
| Person_Id | Person |
|
READ ONLY: Unique identifier for the person. | No |
NUMBER(38) |
| Purpose | STRING255 | NA |
A description of purpose for the activity or its stage | No |
VARCHAR2(255) |
| Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Shot_Density | double | Inverse_Length 1/m |
Average Shot Density | No |
NUMBER |
| Shot_Phase | double | Plane_Angle deg |
The phase of the shot | No |
NUMBER |
| Start_Date | DATE | NA |
The date and time at which the activity will start or did start. For planned activities, this would be expected start date. | No |
DATE |
| Top_Depth | double | Standard_Depth_Index m |
The measured depth of the top of the interval | Yes |
NUMBER |
| UBHI | WELL_IDENTIFIER | NA |
The Unique Identifier assigned to a borehole | Yes |
VARCHAR2(64) |
| Underbalance_Pressure | double | Pressure kPa |
The absolute pressure difference when the perforation method is under/over balanced | No |
NUMBER |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole | Borehole | READ ONLY: Unique identifier for the Borehole. | Cascade | No |
| Person | Person | READ ONLY: Unique identifier for the person. | Cascade | No |
| Activity_BA_Invl | Activity_BA_Invl | READ ONLY: Unique identifier for the activity BA involvement. | Cascade | No |
| Perforation_Activity | Perforation_Activity | READ ONLY: Unique identifier for the perforated interval. | Cascade | No |
CREATE OR REPLACE FORCE VIEW Perforation_Summary_DOV(ID, UBHI, BOREHOLE_NAME, TOP_DEPTH, BOTTOM_DEPTH, CURRENT_STATUS, COMPLETION_ENGINEER, START_DATE, END_DATE, PURPOSE, FLUID_TYPE, FLUID_WEIGHT, OVERBALANCE_PRESSURE, UNDERBALANCE_PRESSURE, GUN_TYPE, GUN_SIZE, SHOT_PHASE, SHOT_DENSITY, CHARGE_SIZE, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, PERFORATION_ACTIVITY_ID, ACTIVITY_BA_INVL_ID, PERSON_ID) AS SELECT
pfi.Id Id,
bh.UBHI UBHI,
bh.Name Borehole_Name,
pfi.Top_Interval_MD Top_Depth,
pfi.Base_Interval_MD Bottom_Depth,
pfi.Current_Status
Current_Status,
per.Unique_Identifier Completion_Engineer,
pfa.Start_Date Start_Date,
pfa.End_Date End_Date,
pfa.Purpose Purpose,
pfa.Fluid_Type Fluid_Type,
pfa.Fluid_Density Fluid_Weight,
DECODE(pfa.Pressure_Difference - abs(pfa.Pressure_Difference),0,abs(pfa.Pressure_Difference),null) Overbalance_Pressure,
DECODE(pfa.Pressure_Difference + abs(pfa.Pressure_Difference),0,abs(pfa.Pressure_Difference),null) Underbalance_Pressure,
pfi.Perforating_Gun_Type
Gun_Type,
pfi.Gun_Size Gun_Size,
pfi.Shot_Phase Shot_Phase,
pfi.Shot_Density Shot_Density,
pfi.Charge_Size Charge_Size,
pfa.Remarks Remarks,
pfi.Insert_Date Insert_Date,
pfi.Insert_User Insert_User,
bh.Id Borehole_Id,
pfa.Id Perforation_Activity_Id,
abi.Id
Activity_Ba_Invl_Id,
per.Id Person_Id
from
borehole bh,
perforated_interval pfi,
perforation_activity pfa,
activity_ba_invl abi,
Person per
where
bh.id = pfi.borehole_id and
pfi.perforation_activity_id = pfa.id (+) and
pfa.id = abi.activity_id (+) and
abi.activity_role (+) = 'Completion Engineer' and
abi.business_associate_id = per.id (+)
|