oats_planning_reviews

-1 rows


Description

A PLANNING REVIEW is an undertaking by a Local Government or a Ministry of the Provincial Government to establish a course of action or direction on future land use that is of interest to the ALC. For example: - The Golden Ears Bridge - Ministry of Highway’s Gateway Program

Columns

Column Type Size Nulls Auto Default Children Parents Comments
planning_review_id int8 19 null
oats_documents.planning_review_id oats_docu_plrv_fk R
oats_planning_decisions.planning_review_id oats_pldc_plrv_fk R
oats_planning_review_notes.planning_review_id oats_plrn_plrv_fk R

System generated sequence number to uniquely identify a PLANNING REVIEW
planning_review_code varchar 10 null
oats_planning_review_codes.planning_review_code oats_plrv_plrc_fk R

User supplied value to uniquely identify a PLANNING REVIEW CODE
legacy_planning_review_nbr varchar 10 √ null

LEGACY PLANNING REVIEW NBR is the characters used to identify a PLANNING REVIEW in the legacy ATS application system, where NBR is an abbreviation for number. For example: 10110-1 or 20002
person_organization_id int8 19 null
oats_person_organizations.person_organization_id oats_plrv_pog_fk R

PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION.
received_date timestamp 29,6 null

RECEIVED DATE is a time the ISSUE was received by the Commission.
description varchar 4000 null

DESCRIPTION isan attribute further extending the definition of the PLANNING REVIEW.
local_gov_document_name varchar 100 null

The name of the Local Government assigned the PLANNING REVIEW
open_ind varchar 1 null

The OPEN IND attribute Y(Yes) indicates whether or not the PLANNING REVIEW is currently open and active, N(No) indicates it is closed and retained for historical reference.
gis_created_ind varchar 1 null

GIS_CREATED_IND ia a attribute where Y(Yes) indicates whether or not the PLANNING REVIEW is currently open and active, N(no) indicates it is closed and retained for historical reference.
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_planning_reviews_pkey Primary key Asc planning_review_id
oats_plrv_plrc_fk_i Performance Asc planning_review_code
oats_plrv_pog_fk_i Performance Asc person_organization_id

Check Constraints

Constraint Name Constraint
avcon_1238100890_gis_c_000 ((gis_created_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
avcon_1238100890_open__000 ((open_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))

Relationships

Close relationships within degrees of separation