Lease_DOV

[Columns] [Composed Of] [Referenced By] [Refers To]

Name	Lease_DOV
Entity Type	ObjectView
Description	Data Object View. The Lease DOV.
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain	Property / Storage Unit	Description	Required / Default	Type
Acquisition_Date	DATE	NA	The date on which the contract was executed, usually the date of the signing of the last signatory.	No	DATE
Area_Id	Area		If the surface boundaries of a land description are described in terms of an area, this is the identifier for that area.	No	NUMBER(38)
Areal_Extent	double	Area m2	The number of measurement units, according to the land agreement, that represents the areal extent of the agreement.	No	NUMBER
Areal_Extent_Units	STRING64		The identifier of the original unit of measure (UOUM) (for example, acre or hectare) for the areal extent.	No	VARCHAR2(64)
Expiration_Date	DATE	NA	The date on which this land agreement actually expires, was terminated, or was relinquished.	No	DATE
Id	ID	No_Unit	Unique identifier for this entity.	Yes	NUMBER(38)
Insert_Date	DATE	NA	READ ONLY: Date the entity was created in the repository	No	DATE
Insert_User	STRING64	NA	READ ONLY: The name of the user responsible for the creation of this entity in the repository.	No	VARCHAR2(64)
Land_Agreement_Status_Id	Land_Agreement_Status		READ ONLY: Unique identifier for the Land Agreement Status.	No	NUMBER(38)
Land_Desc_Component_Id	Land_Desc_Component		READ ONLY: Unique identifier for the Land Desc Component.	No	NUMBER(38)
Land_Description_Id	Land_Description		READ ONLY: Unique identifier for the Land Description.	No	NUMBER(38)
Land_Sale_Id	Land_Sale		READ ONLY: Unique identifier for the Land Sale.	No	NUMBER(38)
Lease_Name	ENTITY_NAME	NA	Lease Name	No	VARCHAR2(255)
Lease_Number	STRING64	NA	A number assigned to the agreement. For example, it could be the number assigned to the agreement by the regulatory agency having jurisdiction over mineral activity in the area where the agreement grants rights.	Yes	VARCHAR2(64)
Price	double	No_Unit	The bonus price paid in consideration for this land agreement.	No	NUMBER
Price_Per_Unit	double	No_Unit	The bonus price per unit of area. For example, if the areal extent of the property is specified in acres, this is the bonus price per acre.	No	NUMBER
Sale_Date	DATE	NA	The date the actual sale occurs.	No	DATE
Sale_Number	STRING32	NA	A value that uniquely identifies a land sale. The value can be numerical or textual.	No	VARCHAR2(32)
Shape	GEOMETRY	NA	READ ONLY: Binary spatial representation of the Lease Boundary	No	ST_GEOMETRY
Status	STRING64		READ ONLY: The status of the land agreement. Examples are: expired, terminated, cancelled, relinquished, in primary term, held by production, held by drilling operations, under suspension, held by pending litigation, etc.	No	VARCHAR2(64)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Land_Desc_Component	Land_Desc_Component	READ ONLY: Unique identifier for the Land Desc Component.	Nullify	No
Land_Sale	Land_Sale	READ ONLY: Unique identifier for the Land Sale.	Nullify	No
Land_Agreement_Status	Land_Agreement_Status	READ ONLY: Unique identifier for the Land Agreement Status.	Nullify	No
Area	Area	If the surface boundaries of a land description are described in terms of an area, this is the identifier for that area.	Nullify	No
Land_Description	Land_Description	READ ONLY: Unique identifier for the Land Description.	Nullify	No

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW Lease_DOV(ID, LEASE_NUMBER, LEASE_NAME, SALE_NUMBER, SALE_DATE, EXPIRATION_DATE, ACQUISITION_DATE, PRICE, PRICE_PER_UNIT, AREAL_EXTENT, AREAL_EXTENT_UNITS, STATUS, SHAPE, INSERT_DATE, INSERT_USER, LAND_DESC_COMPONENT_ID, LAND_SALE_ID, LAND_DESCRIPTION_ID, AREA_ID, LAND_AGREEMENT_STATUS_ID) AS select  la.id                                                   Id,
        la.agreement_number                                     Lease_Number,
        la.name                                                 Lease_Name,
        ls.sale_number                                          Sale_Number,
        ls.sale_date                                            Sale_Date,
        la.actual_expiry_date                                   Expiration_Date,
        la.execution_date                                       Acquisition_Date,
        la.bonus_price                                          Price,
        la.bonus_per_unit_price                                 
Price_Per_Unit,
        la.agreement_areal_extent                               Areal_Extent,
        la.agreement_areal_extent_ouom                          Areal_Extent_Units,
        las.status_code                                         Status,
        area.shape                                              Shape,
        la.insert_date                                          Insert_Date,
        la.insert_user                                          Insert_User,
        ldc.id                                                  Land_Desc_Component_Id,
        ls.id                                                   Land_Sale_Id,
        ld.id                                                   Land_Description_Id,
        area.Id                                                 Area_Id,
        las.Id                                                  Land_Agreement_Status_Id
     from land_agreement la,
          land_desc_component ldc,
          land_sale ls,
          
land_description ld,
          area area,
          land_agreement_status las
    where la.id = ldc.land_agreement_id(+)
      and ldc.land_sale_id = ls.id(+)
      and ldc.land_description_id=ld.id(+)
      and ld.bounding_area_id = area.id(+)
      and la.id = las.land_agreement_id(+)
      and nvl(las.start_date(+), sysdate) <= sysdate
      and nvl(las.end_date(+), sysdate) >= sysdate

[Seabed Objects] [Entities in Schema Seabed] [Index]

Lease_DOV

Copyright © 2018 Schlumberger. All rights reserved.