oats_map_amendment_periods

-1 rows


Description

The Commission updates the official Agricultural Land Maps applying all inclusion and exclusion changes on a prescribed schedule. A MAP AMENDMENT PERIOD is a timeframe in which all inclusion and exclusion decisions that were approved outright or all CONDITIONS have been met where applied to the ALR map. There are 4 periods per year, each covering 3 months starting on January.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
amendment_year int2 5 null
oats_alr_appl_components.amendment_year oats_apcp_mapp_fk R

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

The period of the MAP AMENDMENT PERIOD
start_date timestamp 29,6 null

The calendar start date of the MAP AMENDMENT PERIOD
end_date timestamp 29,6 null

The calendar end date of the MAP AMENDMENT PERIOD
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_map_amendment_periods_pkey Primary key Asc/Asc amendment_year + amendment_period

Relationships

Close relationships within degrees of separation