oats_property_interests

-1 rows


Description

A PROPERTY OWNER is the assertion that a PERSON ORGANIZATION is in possession of a PROPERTY at the time an ALR APPLICATION was submitted to the Commission or when an ISSUE was logged. For the purposes of the ALC, the owner of Crown Land will be the ministry that has governance over the land. For example: - Integrated Land Management Bureau (ILMB) - Ministry of Forest and Range (MoFR) A LAND TITLE CHARGE is an interest in land (as identified by a LAND TITLE CHARGE CODE) that is registerable against the title to land of a SUBJECT PROPERTY that may impact one or more of the title holders (for example, a mortgage) or the usage of the land (for example, statutory right of way, mineral rights). Only land title charges that are germane to the ALR APPLICATION will be included.A PROPERTY INTEREST is the generalization of PROPERTY OWNERSHIP and LAND TITLE CHARGE applied against a SUBJECT PROPERTY that is germane to the ALR APPLICATION.

Columns

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

System generated sequence number to uniquely identify a PROPERTY INTEREST
prin_type varchar 10 null
subject_property_id int8 19 null
oats_subject_properties.subject_property_id oats_prin_sbjp_fk R

System generated sequence number to uniquely identify a SUBJECT PROPERTY
person_organization_id int8 19 √ null
oats_person_organizations.person_organization_id oats_prin_pog_fk R

PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION.
property_owner_type_code varchar 10 √ null
oats_property_owner_type_codes.property_owner_type_code oats_prin_powc_fk R

User supplied value to uniquely identify an PROPERTY OWNER TYPE CODE
active_ind varchar 1 √ null

Indicates whether or not the PROPERTY OWNERSHIP is active or not; no indicates retention of historical information.
land_title_charge_code varchar 10 √ null
oats_land_title_charge_codes.land_title_charge_code oats_prin_ltcc_fk R

User supplied value to uniquely identify a LAND TITLE CHARGE CODE. This is identical to the ALTOS VTRCDE.TRNSCTN_TYP_CD column.
charge_nbr varchar 11 √ null

The CHARGE NBR is the number assigned by the Land Titles Office to identify the LAND TITLE CHARGE. This is potentially sourced from the ALTOS system’s CHARG . CHARGE_NMBR table . colum.
charge_desc varchar 4000 √ null

Further description of the charge on the land
property_interest_code varchar 10 √ null
oats_property_interest_codes.property_interest_code oats_prin_pic_fk R

Indicates the nature of the person/orgs interest in the property
nonfarm_use_type_code varchar 10 √ null
oats_nonfarm_use_type_codes.nonfarm_use_type_code oats_prin_nfuc_fk R

Indicates the type of non-farm use employed by the interest.
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_property_interests_pkey Primary key Asc property_interest_id

Check Constraints

Constraint Name Constraint
oats_prin_ai_chk ((active_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_prin_chk ((((prin_type)::text = 'CHG'::text) AND (property_owner_type_code IS NULL) AND (land_title_charge_code IS NOT NULL) AND (active_ind IS NULL) AND (charge_nbr IS NOT NULL) AND (charge_desc IS NOT NULL)) OR (((prin_type)::text = 'OWN'::text) AND (person_organization_id IS NOT NULL) AND (property_owner_type_code IS NOT NULL) AND (land_title_charge_code IS NULL) AND (active_ind IS NOT NULL) AND (charge_nbr IS NULL) AND (charge_desc IS NULL)) OR (((prin_type)::text = 'NOOWN'::text) AND (person_organization_id IS NULL) AND (property_owner_type_code IS NOT NULL) AND (active_ind IS NOT NULL)))
oats_prin_pt_chk ((prin_type)::text = ANY ((ARRAY['OWN'::character varying, 'CHG'::character varying, 'NOOWN'::character varying])::text[]))

Relationships

Close relationships within degrees of separation