oats_alr_appl_components

-1 rows


Description

An ALR APPL COMPONENT is a constituent part of an ALR APPLICATION distinguished by the type of change (as defined by ALR CHANGE CODE).An ALR APPL COMPONENT is either describing:a) a proposal component (if the relationship [identified as a proposal component for one and only one ALR APPLICATION] is provided)b) a decision component (if the relationship [identified as a decision component for one and only one ALR APPL DECISION] is provided.)A BOUNDARY CHANGE is an ALR APPL COMPONENT that will affect the boundary of the ALR. A decision ALR APPL COMPONENT-BOUNDARY CHANGE will be mapped in a digital mapping system.An INCLUSION is a specific type of ALR APPL COMPONENT that will bring land into the Agricultural Land Reserve. An EXCLUSION is a specific type of ALR APPL COMPONENT that will take land out of the Agricultural Land Reserve. A NON BOUNDARY CHANGE is an ALR APPL COMPONENT that does not affect the boundary of the ALR. A decision ALR APPL COMPONENT-NON BOUNDARY CHANGE will not be mapped in a digital mapping system.NON FARM PURPOSE is a specific type of NON BOUNDARY CHANGE-ALR APPL COMPONENT that will allow an activity other than agriculture to be conducted on the land, either as a general NONFARM USE, or as a SOIL CHANGE COMPONENT.A SUBDIVISION is a specific type of ALR APPL COMPONENT that will allow a parcel of land to be separated into multiple smaller parcels.A NON FARM USE is a specific type of NONFARM PURPOSE-NON BOUNDARY CHANGE-ALR APPL COMPONENT that will allow an activity other than agriculture to be conducted on the land, but not specifically subdivisions.A SOIL CHANGE COMPONENT is a further specific NON FARM PURPOSE that will allow either soil to be removed from the land or fill added to the land.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
alr_appl_component_id int8 19 null
oats_conditions.alr_appl_component_id oats_cond_apcp_fk R
oats_soil_change_elements.alr_appl_component_id oats_scel_apcp_fk R
oats_subdiv_parcel_intents.alr_appl_component_id oats_sdpi_apcp_fk R
oats_subdivision_designs.alr_appl_component_id oats_subd_apcp_fk R

System generated sequence number to uniquely identify an ALR APPL COMPONENT
alr_change_code varchar 10 null
oats_alr_change_codes.alr_change_code oats_apcp_alcc_fk R

System developer supplied value to uniquely identify an ALR CHANGE CODE
alr_application_id int8 19 √ null
oats_alr_applications.alr_application_id oats_apcp_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.
alr_appl_decision_id int8 19 √ null
oats_alr_appl_decisions.alr_appl_decision_id oats_apcp_aadc_fk R

System generated sequence number to uniquely identify a ALR APPL DECISION
component_area float8 17,17 null

Total land area covered by this ALR APPL COMPONENT
agri_capability_code varchar 10 √ null
oats_agri_capability_codes.agri_capability_code oats_apcp_agcc_fk R

User supplied value to uniquely identify an AGRI CAPABILITY CODE
capability_source_code varchar 10 √ null
oats_capability_source_codes.capability_source_code oats_apcp_cpsc_fk R

User supplied value to uniquely identify a CAPABILITY SOURCE CODE
legislation_code varchar 10 √ null

LEGISLATION CODE is a unique code used to identify a section of the Agricultural Land Commission Act
agri_cap_map varchar 50 √ null

Description of the source map that provided agricultural capability
agri_cap_consultant varchar 100 √ null

Description of the agricultural consultant that provided agricultural capability
decision_expiry_date timestamp 29,6 √ null

Date the decision ALR APPL COMPONENTcan no longer be implemented. This must be null for a proposal ALR APPL COMPONENT, and must be supplied for all decision ALR APPL COMPONENT, except INCLUSIONS. An INCLUSION decision component will never have an expiry date.
amendment_year int2 5 √ null
oats_map_amendment_periods.amendment_year oats_apcp_mapp_fk R

The year of the MAP AMENDMENT PERIOD
amendment_period int2 5 √ null
oats_map_amendment_periods.amendment_period oats_apcp_mapp_fk R

The period of the MAP AMENDMENT PERIOD
nonfarm_use_type_code varchar 10 √ null
oats_nonfarm_use_subtype_codes.nonfarm_use_type_code oats_apcp_nfst_fk R

User supplied value to uniquely identify a NONFARM USE TYPE CODE
nonfarm_use_subtype_code varchar 10 √ null
oats_nonfarm_use_subtype_codes.nonfarm_use_subtype_code oats_apcp_nfst_fk R

User supplied value to uniquely identify a NONFARM USE SUBTYPE CODE
nonfarm_use_end_date timestamp 29,6 √ null

Date the Commission set in its decision the non farm use activity should stop. This must be null for a proposal component, and must be supplied for a decision ALR APPL COMPONENT.
alr_impact_ind varchar 1 √ null

Indicates if the component will have an impact on the ALR
homesite_severance_ind varchar 1 √ null

Indicates if the componement will result in a homesite severence
support_desc varchar 4000 √ null

Describes the component support.
improvements_desc varchar 4000 √ null

Describes the improvements resulting from this component.
impact_reduction_desc varchar 4000 √ null

Describes the efforst taken to reduce the impact of this component.
agricultural_activities_ind varchar 1 √ null

Indicates if agricultural activity will result from this component.
agricultural_activities_desc varchar 4000 √ null

Description of the agricultural activities resulting from this component.
corridor_length float4 8,8 √ null

The length of the corridor resuting from this component.
corridor_width int4 10 √ null

The width of the corridor resuting from this component.
owners_notified_ind varchar 1 √ null

Indicates if the owners of the adjacent lands have been notified of this component.
rsdntl_use_type_code varchar 10 √ null
oats_rsdntl_use_type_codes.rsdntl_use_type_code oats_apcp_rsut_fk R

User supplied value to uniquely identify a RSDNTL USE TYPE CODE
rsdntl_use_end_date timestamp 29,6 √ null

Date the Commission set in its decision the Non-Adhering Residential use activity should stop. This must be null for a proposal component, and must be supplied for a decision ALR APPL COMPONENT.
material_need_ind varchar 1 √ null

Indicates whether or not the applicant needs the soil being removed, or the fill being placed
cur_struc_desc varchar 4000 √ null

Describes all existing structures on this component
infra_desc varchar 4000 √ null

Describes any infrastructure required to this component
sleeping_units int4 10 √ null

Describes how many sleeping units in total are proposed such as bedroom or a vehicle, trailer, tent or other structure, located on a campsite, field or other area
tour_env_desc varchar 4000 √ null

Describes any agri-tourism accommodation or tourist accommodation currently located on this component
exclsn_app_type_code varchar 10 √ null
oats_exclsn_app_type_codes.exclsn_app_type_code oats_apcp_exat_fk R

User supplied value to uniquely identify a EXCLSN APP TYPE CODE
applicationshare_ind varchar 1 √ null

Indicates whether or not any land under application shares a common property line with land in another Local or First Nation Government
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_alr_appl_components_pkey Primary key Asc alr_appl_component_id

Check Constraints

Constraint Name Constraint
oats_apcp_aai_ck ((agricultural_activities_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_apcp_hsi_ck ((homesite_severance_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_apcp_asi_ck ((applicationshare_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_apcp_oni_ck ((owners_notified_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_apcp_mni_ck ((material_need_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_apcp_aii_ck ((alr_impact_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_apcp_chk3 ((((alr_change_code)::text = 'NFU'::text) AND ((nonfarm_use_type_code IS NOT NULL) AND (nonfarm_use_subtype_code IS NOT NULL))) OR ((nonfarm_use_type_code IS NULL) AND (nonfarm_use_subtype_code IS NULL)) OR (((alr_change_code)::text = ANY ((ARRAY['INC'::character varying, 'EXC'::character varying, 'SDV'::character varying, 'SCH'::character varying])::text[])) AND (nonfarm_use_type_code IS NULL) AND (nonfarm_use_subtype_code IS NULL)))

Relationships

Close relationships within degrees of separation