oats_alr_appl_decisions

-1 rows


Description

An ALR APPL DECISION is a resolution passed by the Commissioner’s of the Agricultural Land Commission pertaining to the inclusion or exclusion of land or permitted land uses within the Agricultural Land Reserve. The Agricultural Land Commission staff makes recommendations to the Commissioners. Only Commissioners are able to pass resolutions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
alr_appl_decision_id int8 19 null
oats_alr_appl_components.alr_appl_decision_id oats_apcp_aadc_fk R
oats_compliance_inspections.alr_appl_decision_id oats_cpin_aadc_fk R
oats_financial_instruments.alr_appl_decision_id oats_fiin_aadc_fk R

System generated sequence number to uniquely identify a ALR APPL DECISION
alr_application_id int8 19 √ null
oats_alr_applications.alr_application_id oats_aadc_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.
reconsideration_request_id int8 19 √ null
oats_reconsideration_requests.reconsideration_request_id oats_aadc_rreq_fk R

System generated sequence number to uniquely identify a RECONSIDERATION REQUEST
decision_date timestamp 29,6 √ null

Date the decision was rendered by the Commission.
applicant_notification_date timestamp 29,6 √ null

Date the details of the decision was sent to the applicants
resolution_number int8 19 √ null

A system generated sequence number that is suffixed with the year of the decision date and is the public identifier for the decision resolution. For example 1234-2007.
decision_desc varchar 4000 √ null

Narrative that describes the ALR APPL DECISION
outright_refusal_ind varchar 1 √ null

Indicates whether or not the decision is to outright refuse the ALR APPLICATION or not. If it is an outright refusal, then no decision ALR APPL COMPONENT can be created.
security_amt float8 17,17 √ null

The amount of money (in the form of a bond, letter of credit or cash) that must be provided as a guarantee the CONDITIONS of a decision will be met. This will be applied as a blanket amount for all CONDITIONS that have SECURITY REQUIRED IND set to Y.
no_statistics_required_ind varchar 1 √ 'N'::character varying

NO STATISTICS REQUIRED IND indicates whether the decision should be included in reports.
rescinded_date timestamp 29,6 √ null

RESCINDED DATE is the date the decision was rescinded
rescinded_comments varchar 500 √ null

RESCINDED COMMENTS are comments about why the decision was rescinded
ready_for_decision_date timestamp 29,6 √ null

The date when the application became ready for a decision to be made.
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_decisions_pkey Primary key Asc alr_appl_decision_id
oats_alr_appl_decisions_alr_application_id_key Must be unique Asc alr_application_id
oats_alr_appl_decisions_reconsideration_request_id_key Must be unique Asc reconsideration_request_id

Check Constraints

Constraint Name Constraint
oats_aadc_chk (((alr_application_id IS NOT NULL) AND (reconsideration_request_id IS NULL)) OR ((alr_application_id IS NULL) AND (reconsideration_request_id IS NOT NULL)))
oats_aadc_nsri_chk ((no_statistics_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
oats_aadc_ori_chk ((outright_refusal_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))

Relationships

Close relationships within degrees of separation