oats_organization_types

-1 rows


Description

The ORGANIZATION TYPE is the type of the non BC government organization. Examples include: Corporation, First Nations Band. This system requires an ORGANIZATION TYPE of ‘Region’

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_type_cd varchar 10 null
oats_organizations.organization_type_cd oats_org_otp_fk R

ORGANIZATION TYPE CD is the unique identifier for ORGANIZATION TYPE CD. Example: CORP - Corporation.
description varchar 100 null

The DESCRIPTION is the full description of an organization type code.
effective_date timestamp 29,6 √ null

The EFFECTIVE DATE is the date the this became effective.
expiry_date timestamp 29,6 √ null

The EXPIRY DATE is the date this became obsoleted and is no longer active or valid. Used for historical record keeping.
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 updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_organization_types_pkey Primary key Asc organization_type_cd

Relationships

Close relationships within degrees of separation