bridge_organization_unit_to_organization_unit_code


Description

Link organization unit (gym) to all its organization unit codes (tags).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_unit_to_organization_unit_code_id varchar 256 null

The primary key of the table. Surrogate primary key of the table.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id erp_v2_bridge_organization_unit_to_organization_unit_code_organization_unit_id__erp_v2_dim_organization_unit_o_508bb3291f6a R

The organization unit (gym) this organization unit code is assigned to.
organization_unit_code_id int8 19 √ null
dim_organization_unit_code.organization_unit_code_id erp_v2_bridge_organization_unit_to_organization_unit_code_organization_unit_code_id__erp_v2_dim_organization_u_a47f3e8453ce R

The organization unit code that this organization unit is assigned to.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation