natural_resource_org_unit

-1 rows


Description

Stores natural resource organization unit details associated with recreation resource files.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rec_resource_id varchar 10 null

The recreation resource file identifier, sourced from the forest file id.
org_unit_no numeric 10 null

Unique numeric identifier for the ministry organization unit.
org_unit_code varchar 6 null

Short alphanumeric code representing the organization unit.
org_unit_name varchar 100 null

Full descriptive name of the organization unit.
location_code varchar 3 √ null

Code identifying the physical location of the organization unit.
org_level_code varchar 1 √ null

Code indicating the hierarchical level of the organization unit.
office_name_code varchar 2 √ null

Code representing the office name of the organization unit.
region_no numeric 10 √ null

Numeric identifier of the region this organization unit rolls up to.
region_code varchar 6 √ null

Code of the region this organization unit rolls up to.
district_no numeric 10 √ null

Numeric identifier of the district this organization unit rolls up to.
district_code varchar 6 √ null

Code of the district this organization unit rolls up to.
effective_date date 13 √ null

The effective date of the organization unit record.
expiry_date date 13 √ null

The expiry date of the organization unit record.
updated_at date 13 √ null

The timestamp when the record was last updated.
sys_period tstzrange 2147483647 tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone)

Indexes

Constraint Name Type Sort Column(s)
natural_resource_org_unit_pkey Primary key Asc rec_resource_id

Relationships

Close relationships within degrees of separation