oats_land_use_permits

-1 rows


Description

A LAND USE PERMIT is the granting of a specific permission by a local government or a provincial government ministry to make changes on property, or allow activities to be conducted. A LAND USE PERMIT may be covering one or more SUBJECT PROPERTIES under the ALR APPLICATION. The ALC only needs to know these permits at the aggregate level of the application, and not against the individual properties.A LAND USE PERMIT may have been issued by contravenes the Act. For example: - A ‘Permit’ from a Local Government to allow the construction of a house - A ‘Licence’ from a Local Government to allow the operation of a word working shop. - A ‘Permit’ from the Ministry of Mines to allow gravel extraction - A ‘Permit’ from the Ministry of Environment for waste management

Columns

Column Type Size Nulls Auto Default Children Parents Comments
land_use_permit_id int8 19 null

System generated sequence number to uniquely identify a LAND USE PERMIT
alr_application_id int8 19 null
oats_alr_applications.alr_application_id oats_lupt_appl_fk R

System generated sequence number to uniquely identify an ALR APPLICATION. This is also used as the ALR APPLICATION’S external reference number.
permit_type_code varchar 10 null
oats_permit_type_codes.permit_type_code oats_lupt_pttc_fk R

User supplied value to uniquely identify a PERMIT TYPE CODE
permit_number varchar 50 √ null

The reference number assigned to the LAND USE PERMIT by the issuer.
issue_date timestamp 29,6 null

Date the LAND USE PERMIT was issued by the issuer.
expiry_date timestamp 29,6 √ null

Date the LAND USE PERMIT expires.
description varchar 4000 null

Further description of the LAND USE PERMIT
who_created varchar 32 null

WHO CREATED is the IDIR or Oracle userid of the person who created the record.
when_created timestamp 29,6 null

WHEN CREATED is the date/time that the record was created.
who_updated varchar 32 √ null

WHO UPDATED is the IDIR or Oracle userid of the person who last updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was last updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_land_use_permits_pkey Primary key Asc land_use_permit_id
oats_lupt_appl_fk_i Performance Asc alr_application_id
oats_lupt_pttc_fk_i Performance Asc permit_type_code

Relationships

Close relationships within degrees of separation