This DOV provides information of the perforated intervals on a particular borehole, such as top and base measured depths, status, characteristics of the equipment used, and date of the perforation job. Please be aware of the following information for this DOV:
� As a prerequisite, the referenced records in the following entities must be pre-populated or the DOV will not load:
� Borehole and Person.
� Perforated_Interval. Current_Status is a denormalization of the Perf_Interval_Status. It is assumed that this attribute has been populated.
� One Perforation_Activity can be associated with multiple Perforated_Intervals; therefore when performing INSERT\UPDATE through this DOV, the following holds true:
� If a Perforation_Activity exists in the database for the specified Borehole and Start_Date, then the existing Perforation_Activity value is re-used and a new activity is not created.
� If attribute data exists in the Perforation_Activity entity, the data in those attributes will be UPDATED; therefore, you might see changes in the data of the attributes.
� While deleting a Perforation_Summary record, the associated Perforation_Activity will be deleted if there is no other perforated interval associated with it; otherwise the Perforation_Activity will remain in the database.
� The following attributes are optional and are related to a Perforation_Activity:
� End_Date, Purpose, Fluid_Type, Fluid_Weight, Overbalance_Pressure, Underbalance_Pressure, Remarks, and Completion_Engineer.
� However, if any of these attributes are specified (inserted or updated), it is mandatory to specify the start_date because start_date is mandatory for a Perforation_Activity.