| Name | Land_Agreement |
|---|---|
| Entity Type | Table |
| Description | A legally enforceable agreement between two or more business associates, whereby land-related rights and obligations are defined for one or more business associates. |
| Submodel | Land_Agreement |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | Agreement_Number , Existence_Kind , Version |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Actual_Expiry_Date | DATE | NA |
The date on which this land agreement actually expires, was terminated, or was relinquished. | No |
DATE |
| Agreement_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 |
| Agreement_Areal_Extent_OUOM | R_Unit |
|
The identifier of the original unit of measure (OUOM) (for example, acre or hectare) for the areal extent. | No |
VARCHAR2(64) |
| Agreement_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. | No |
VARCHAR2(64) |
| Amended_Expiry_Date | DATE | NA |
The date at which the agreement is currently expected to terminate. If the expiry date is amended, this is the amended date. (POSC 2.2) | No |
DATE |
| Bonus_Per_Unit_Price | 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 |
| Bonus_Price | double | No_Unit |
The bonus price paid in consideration for this land agreement. | No |
NUMBER |
| Effective_Date | DATE | NA |
The date on which this contract becomes effective. | No |
DATE |
| Execution_Date | DATE | NA |
The date on which the contract was executed, usually the date of the signing of the last signatory. (POSC 2.2) | No |
DATE |
| Existence_Kind | REF_EXISTENCE_KIND | NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| GUID | STRING128 | NA |
Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. | No |
VARCHAR2(128) |
| Government_Agency_BA_Id | Business_Associate |
|
The identifier of the government agency recording this agreement. | No |
NUMBER(38) |
| 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) |
| Land_Agreement_Category | R_Land_Agreement_Category |
|
A value that specifies the broad category into which this land agreement falls. Land_Agreement_Type should be used to store a more narrow typing within a category. | No |
VARCHAR2(64) |
| Land_Agreement_Currency | R_Currency |
|
The currency in which the monetary amounts associated with this land agreement are specified. | No |
VARCHAR2(64) |
| Land_Agreement_Type | R_Land_Agreement |
|
The type of land agreement. Land_Agreement_Category can be used to specify a broad category, while this attribute can be used to store a more narrow typing within a category. | No |
VARCHAR2(64) |
| Land_Sale_Offering_Id | Land_Sale_Offering |
|
The land sale offering through which this land agreement was acquired. | No |
NUMBER(38) |
| 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) |
| Original_Expiry_Date | DATE | NA |
The original date that the contract was to terminate. If the contract is extended, this date does not change. (POSC 2.2) | No |
DATE |
| Original_Source | STRING64 | NA |
The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" | No |
VARCHAR2(64) |
| Primary_Term_Years | double | No_Unit |
The initial period (in years) of a land agreement. | No |
NUMBER |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Publicly_Available_Flag | boolean | NA |
A flag that specifies whether the data in this agreement is publicly available. Valid values are: 1 (True) - the data is publicly available; and 0 (false) - the data is not publicly available. A null value implies that it is not known whether the data is publicly available. | No |
NUMBER(1) |
| Remarks | STRING2000 | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Source | STRING64 | NA |
Name of the person or organization responsible for this entitys 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) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Version | STRING255 | NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Agreement_Reference | Referenced_Agreement | The identifier of the land agreement that is referenced by another agreement. | Restrict | Yes |
| Agreement_Reference | Referencing_Agreement | The identifier of the land agreement that is referencing another land agreement. | Restrict | Yes |
| Interest_Set_Component | Land_Agreement | If the interest set component is a land agreement, this is the identifier of that land agreement. | Cascade | No |
| Land_Agreement_Alias | Land_Agreement | The identifier of the land agreement to which this alias name applies. | Cascade | Yes |
| Land_Agreement_Parcel | Land_Agreement | The land agreement that includes this land agreement parcel. | Cascade | Yes |
| Land_Agreement_Remark | Land_Agreement | The land agreement to which this remark applies. | Cascade | Yes |
| Land_Agreement_Status | Land_Agreement | The identifier of the land agreement to which this status applies. | Cascade | Yes |
| Land_Desc_Component | Land_Agreement | If the land description component is a land agreement, this is the identifier of that land agreement. | Cascade | No |
| NDC_Borehole | License | The License referred to by the borehole. Usage Notes: The association to Land_Agreement to identify the License is deprecated in Seabed release 2011.1. In a future release of Seabed this association will be removed. As part of the project upgrade process for Seabed 2011.1, any License data in NDC_Borehole will be copied into the new intersection table, Position_Xref. If you are storing Licenses or other Land Agreements, you must begin transitioning your process to the new intersection table, Position_Xref, as soon as possible to avoid problems when this association between NDC_Borehole and Land_Agreement is removed. | Cascade | No |
| Obligation_Component | Land_Agreement | If the obligation component is a land agreement, then this stores the identifier of that land agreement. | Cascade | No |
| Oper_Desig_Component | Land_Agreement | If this operator designation component is a land agreement, this is the identifier of that land agreement. | Restrict | No |
| Position_Xref | Land_Agreement | The unique identifier of the Land_Agreement that is associated with the Position. | Cascade | No |
| Production_Entity | Land_Agreement | The identifier of the land agreement that is represented by the production entity. | Cascade | No |
| Rate_Schedule_Component | Land_Agreement | If the rate schedule component is a land agreement, this is the identifier of that land agreement. | Cascade | No |
| Restriction_Component | Land_Agreement | If the restriction component is a land agreement, then this stores the identifier of that land agreement. | Cascade | No |
| Well_Completion_Agreement | Land_Agreement | The identifier of the land agreement (i.e., lease, concession, license) that governs this well completion. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Land_Agreement_Category | R_Land_Agreement_Category | A value that specifies the broad category into which this land agreement falls. Land_Agreement_Type should be used to store a more narrow typing within a category. | Restrict | No |
| Land_Agreement_Currency | R_Currency | The currency in which the monetary amounts associated with this land agreement are specified. | Restrict | No |
| Land_Sale_Offering | Land_Sale_Offering | The land sale offering through which this land agreement was acquired. | Restrict | No |
| Land_Agreement_Type | R_Land_Agreement | The type of land agreement. Land_Agreement_Category can be used to specify a broad category, while this attribute can be used to store a more narrow typing within a category. | Restrict | No |
| Government_Agency_BA | Business_Associate | The identifier of the government agency recording this agreement. | Restrict | No |
| Agreement_Areal_Extent_OUOM | R_Unit | The identifier of the original unit of measure (OUOM) (for example, acre or hectare) for the areal extent. | Restrict | No |