oats_subdiv_parcel_intents

-1 rows


Description

A SUBDIV PARCEL INTENT is either a parcel an applicant wishes to create as part of an ALR APPL COMPONENT-NON BOUNDARY CHANGE-SUBDIVISION, or a parcel the Commission has decided could be created. This depends on whether ALR APPL COMPONENT is a proposal component (the relationship from ALR APPLICATION is supplied) or a decision component (the relationship from ALR APPL DECISION is supplied). For each ALR APPL COMPONENT-NON BOUNDARY CHANGE-SUBDIVISION there must be at least two or more SUBDIV PARCEL INTENTS. I.E. the creation of one new parcel always results in two parcels being created, the new parcel and the remainder of the original.The total of SUBDIV PARCEL INTENT . PARCEL SIZE should be the same as the parent ALR APPL COMPONENT’s AREA. A decision SUBDIV PARCEL INTENT is considered to be actualized when a relationship from a SUBDIV DESIGN PARCEL has been established. Note: Two or more SUBDIV PARCEL INTENTS may be actualized by a single SUBDIV DESIGN PARCEL. For example: The decision allows the creation of 4 x 10ha parcels. The applicant submits a survey plan that only creates 2x20ha parcels. The actualization of two of the 10ha parcels will be from one of the 20ha parcels, and the actualization of the other two 10ha parcels will be from the other 20ha parcel. Another example: The decision allows the creation of 2 x 20ha parcels on the northern half of the property and 4 x 10ha lots on the southern half of the property. The applicant submits a survey plan that creates the 2 northern 20ha parcels, but does not explicitly include the southern half of the property. The actualization of the two 20ha parcels will be from the survey plan’s two 20ha parcels. If the applicant does not submit another survey plan before the decision expires, the southern four 10ha lots will be actualized by a by 40ha remainder SUBDIV DESIGN PARCEL (REMAINDER IND = ‘Y’).

Columns

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

System generated sequence number to uniquely identify a SUBDIV PARCEL INTENT

alr_appl_component_id int8 19 null
oats_alr_appl_components.alr_appl_component_id oats_sdpi_apcp_fk R

System generated sequence number to uniquely identify an ALR APPL COMPONENT

parcel_area float8 17,17 null

The surface area of the parcel to be created as the result of a subdivision proposed by the applicant or decided by the Commission

subdiv_design_parcel_id int8 19 null
oats_subdiv_design_parcels.subdiv_design_parcel_id oats_sdpi_sddp_fk R

System generated sequence number to uniquely identify a SUBDIV DESIGN PARCEL

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_subdiv_parcel_intents_pkey Primary key Asc subdiv_parcel_intent_id
oats_sdpi_apcp_fk_i Performance Asc alr_appl_component_id
oats_sdpi_sddp_fk_i Performance Asc subdiv_design_parcel_id

Relationships