This represents the non-spatial concepts of leases, licenses and concessions, and may apply to multiple portions of the Earth.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
identifier (M: CHAR VARYING(80))
license_right.identifier
The identifier assigned to a license right.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
application_date (O: DATE)
license_right.application_date
The date on which an application for the license was made.
award_date (O: DATE)
license_right.award_date
This is the date the license right was awarded.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
effective_date (O: DATE)
license_right.effective_date
This is the date at which this license right becomes effective. This is usually when the license right is defined and may be prior to its initial sale.
expiry_date (O: DATE)
license_right.expiry_date
This is the date at which this license right expires. This is usually when the license right is no longer of commercial interest, such as after the final relinquishment.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
rental_due_date (O: DATE)
license_right.rental_due_date
The due date for the rental payment.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
r_license_right (FNK, O: CHAR VARYING(80))
license_right.ref_license_right
This defines the type of license right.
Defines a foreign key to table r_license_right.
license_right.ref_license_right_acquisition
The method of acquisition, e.g., purchase, farm-in, etc.
Defines a foreign key to table r_license_right_acquisition.