bridge_organization_unit_to_organization_unit_code


Description

Link organization unit to all its organization unit codes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_unit_to_organization_unit_code_id int8 19 null

The primary key of the table. System column calculated by the source System.
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id bridge_organization_unit_to_organization_unit_code_organization_unit_id_fkey R

The organization unit this code is assigned to.
organization_unit_code_id int8 19 null
dim_organization_unit_code.organization_unit_code_id bridge_organization_unit_to_organization_unit_code_organization_unit_code_id_fkey R

The code assigned to the organization unit.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation