oats_organizations

-1 rows


Description

A NON BC GOVERNMENT ORGANIZATION is an organization that does not belong to the BC Government. A BC GOVERNMENT ORGANIZATION is an organization that belongs to the BC Government. An ORGANIZATION is an organized and named grouping of people that interacts in some way with the Ministry. Definition from old ORGANIZATION CODE (plural AIR ORGANIZATION CDS):An ORGANIZATION is a named organization or group. There are two types of ORGANIZATIONS in AIR, AGENCY or EXTERNAL AGENCY. An AGENCY is a group that is in some way responsible for the ownership, or operation of a station. An EXTERNAL AGENCY is an agency who shares station data with AIR.An example is National Air Pollution Surveillance Network (NAPS). Note an optional display order was in ORGANIZATION CODE number(4).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_id int8 19 null
oats_organizations.parent_organization_id oats_org_org_fk R
oats_person_organizations.organization_id oats_pog_org_fk R

ORGANIZATION ID is the system generated unique identifier for ORGANIZATION
parent_organization_id int8 19 √ null
oats_organizations.organization_id oats_org_org_fk R

ORGANIZATION ID is the system generated unique identifier for ORGANIZATION
org_type varchar 10 null
organization_type_cd varchar 10 null
oats_organization_types.organization_type_cd oats_org_otp_fk R

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

The ORGANIZATION NAME is the name of an organization.
effective_date timestamp 29,6 √ null

The EFFECTIVE DATE is the date the Organization becomes effective as a valid Org Unit within the Ministry organizational structure.
expiry_date timestamp 29,6 √ null

The EXPIRY DATE is the date the Organization is obsoleted and is no longer an active or valid. May be used to keep a historical record of organization.
ministry_cd varchar 10 √ null

The MINISTRY CD is a number assigned to define a BC Government Ministry
organization_unit_cd varchar 10 √ null

The ORGANIZATION UNIT CD is an acronym used for Government Organization. For MSRM Information Management Branch it would be IMB. MoF has specific organizational unit codes which identify the org unit as Executive, Branch, Region or District with the code. E.g HIS in forests is Information Management Group. The H identifies it as Headquarters.
alias_name varchar 240 √ null

The ALIAS NAME is an alias for this type of organization.
organization_guid varchar 32 √ null

The GUID of the organization as provided by WebADE
organization_contact varchar 120 √ null

The name of the contact at the organization.
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
zone_1 varchar 1 √ null

Indicates whether or not the organization is in zone 1.
zone_2 varchar 1 √ null

Indicates whether or not the organization is in zone 2.

Indexes

Constraint Name Type Sort Column(s)
oats_organizations_pkey Primary key Asc organization_id
oats_organizations_organization_guid_key Must be unique Asc organization_guid

Check Constraints

Constraint Name Constraint
oats_org_chk ((((org_type)::text = 'BGO'::text) AND (ministry_cd IS NOT NULL) AND (organization_unit_cd IS NOT NULL) AND (alias_name IS NULL)) OR (((org_type)::text = 'NBC'::text) AND (ministry_cd IS NULL) AND (organization_unit_cd IS NULL)))
oats_org_ot_chk ((org_type)::text = ANY ((ARRAY['BGO'::character varying, 'NBC'::character varying])::text[]))

Relationships

Close relationships within degrees of separation