| 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 / Measurement | 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 |
The number of measurement units, according to the land agreement, that represents the areal extent of the agreement. | No |
NUMBER |
| Agreement_Areal_Extent_UOUM | R_Unit |
The identifier of the original unit of measure (UOUM) (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. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers. | 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 |
Business_Associate, 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 |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| Publicly_Available_Flag | boolean No_Unit |
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 Business_Associate responsible for this entity"s 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 |
| 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 |
| 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 |
|---|---|---|---|---|
| Agreement_Areal_Extent_UOUM | R_Unit | The identifier of the original unit of measure (UOUM) (for example, acre or hectare) for the areal extent. | Restrict | No |
| Government_Agency_BA | Business_Associate | The identifier of the government agency recording this agreement. | Restrict | No |
| 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_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 |
| Land_Sale_Offering | Land_Sale_Offering | The land sale offering through which this land agreement was acquired. | Restrict | No |